Note: In order to use the spreadsheet examples, you need to download Business Functions
|LoanLinX (Time, Base, FromDatesInt, IntSimple, AdvanceDates, NetAdvances, StartRepayments, RepaymentDate, [RollTo], [LoanOutput], [DayCountInt], [PrdsInt], [DayCountPrin], [PrdsPrin], [ProjMode])|
|Loan with a linear repayment schedule|
|Calculates a loan in full, its interest, principal and balance. Differs from LoanLin in that it allows for roll up of interest.|
|Auto Array Function|
How It Works
The AdvanceDates have to be in ascending order or an error is thrown.