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 Loan function.

Example

LoanLin.xls