5g: Financial Library

Finance Library
This library provides a sample of 5G functions for the financial modeling industry. Each functions works nicely with dynamic arrays. This is best used with the Date library. Here is what is included in the Financial Library.

AMORTIZATION (Simple Loans) SUITE

• Amortizeλ Creates a corkscrew amortization schedule.

• SumAmortizeλ Create row totals for Amortizeλ's results.

• LabelAmortizeλ Create row labels for Amortizeλ result

DEPRECIATE SUITE

• Depreciateλ Create a block of CAPEX, Opening Balance, Depreciation Values, and Book Value for each asset

• SumDepreciateλ Create row totals for Depreciateλ's results.

• LabelDepreciateλ Create row labels for Depreciateλ result
  
  

MAIN FUNCTIONS - 

• Corkscrewλ Creates a simple corkscrew where the closing balance is the sum of independent flows plus opening balance

• Cumulativeλ Creates a row or column of cumulative totals from a total row or column

• IntOnIntλ Calculates how much we need to borrow, in addition to principal, when we also need to borrow the interest 

• IRRλ Calculates IRR, correcting for when the first investment is not in the first period

• Movementλ Create a row of differences from column to column

• RollingSumλ Creates totals for preceding values of a set size moving from beginning to end over a row of values.

SUMMARIES - Functions that create totals for the main functions

• SumContainsλ Creates a row of totals for each row in an array where its labels contain a unique letter, word, or phrase.

• SumPeriodsλ Groups and totals all columns in a dynamic array by period resulting in one column for each period.

 SUBROUTINES - Functions used by the main functions

• FilterContainsλ Filter an array by another array that contains specifice text

• RangeToDAλ Create a dynamic array from a static range

• TimelineOffsetλ Determines how many columns a date is offset from a timeline's first date

• TimelinePositionλ Places an array or value appropriately within a model's timeline.