|Mortgage (Time, Base, FromDatesInt, IntSimple, FinishRates, FromDates, AnnDebtServiceRates, AdvanceDates, NetAdvances, [LongStopRepDate], [LoanOutput], [DayCount], [DayCountInt], [Periods], [PrdsInt], [ProjMode])|
|With Mortgage you essentially specify the amount of the loan in NetAdvances (and there can be several advances over time), and the total amount of cashflow that services both the interest and principal of the loan using AnnDebtServiceRates (and this can b|
|Auto Array Function|
Whats good or unique about it
Mortgage does the kind of job that you might do yourself with a loan amortisation spreadsheet. However, it dos several things that would otherwise be extremely difficult or impossible:
DayCount and DayCountInt
Mortgage caters for an extremely generic situation where debt service rates (the overall principal and interest repayment), and interest rates can vary over time. Often, if you just want to input a quick mortgage-type loan, it can be quicker to use MortgageQ, which although it has a smaller feature set, works out the debt service rate for you.
TemplatesThis function features in the following downloadable spreadsheet template(s):