Note: In order to use the spreadsheet examples, you need to download Business Functions
|MortgageQ (Time, Base, InterestSimple, AdvanceDate, NetAdvance, RepaymentDate, [EarlyRepDate], [LoanOutput], [DayCount], [PrdsInt], [ProjMode])|
|With MortgageQ 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|
|Auto Array Function|
MortgageQ is a less capable but easier version of Mortgage. Both these functions model a constant overall (principal and interest) repayment of the kind where you might be tempted to use Excel"s PMT function.