| LoanLinX (Time, Base, FromDatesInt, IntSimple, AdvanceDates, NetAdvances, StartRepayments, RepaymentDate, [RollTo], [LoanOutput], [DayCountInt], [PrdsInt], [DayCountPrin], [PrdsPrin], [ProjMode]) | | Loan with a linear repayment schedule | | | | | Auto Array Function | Features | | ..X | Extended | How It Works | - First of all, the function creates a single list of all the advances and advance dates. For the first bit, this is simply the advances that you input. Then it has to loop through the entire linear repayment schedule, effectively repaying the loan. It stores the results of the advances in a cache so that next time this function is called, it might be able to re-use the same advances schedule.
- Once it has the master schedule of advances, the function simple calls the LoanX function.
| Example LoanLinX.xls |
Any comments on this documentation? Send us your suggestions below. | 