|LoanX (Time, Base, FromDatesInt, IntSimple, AdvanceDates, NetAdvances, RepaymentDate, [RollTo], [LoanOutput], [DayCount], [PrdsInt], [ProjMode])|
|Calculate a loan (interest, principal and balance) for a loan where the interest can roll up|
|Calculates a loan in full, its interest, principal and balance. Differs from Loan in that it allows for roll up of interest.|
|Auto Array Function|
The main difference between this function, LoanX, and Loan is that interest rollup is permitted using the optional RollTo variable.
TemplatesThis function features in the following downloadable spreadsheet template(s):