:: Templates:: Loans

Loans

Loans;Mortgages;Bonds;Securitisations;Finance Leases.
Key Features: Comprehensive DayCount options for calculating interest; Flexible Periods option for specifying when interest is paid; some models can work on a dual basis on either budget periods or loan dates.

Template NameDescriptionFilename
Click For ScreenshotFinance LeaseFinance Leases have all but lost their appeal in the UK at least, and the math for analysing them has become more complex, but for a general illustration of the principle, this worksheet is a typical finance lease for property. Amongst other things, it demonstrates BF"s functionalised GoalSeek.finance_lease.xls
Click For ScreenshotLoan Amortisation with the LoanX FunctionVery simple loan amortisation, although it does have interest rollup if requiredloan_amortisation_with_loanx.xls
Click For ScreenshotMortgageConventional Mortgage Model.loan_mortgage.xls
Click For ScreenshotLoan Mortgage With Extra Capital RepaymentsCalculates the effect on a level payment mortgage of one or a number of ad-hoc capital repayment, reducing the loan repayments to keep the repayment date the same.loan_mortgage_extrapayments.xls
Click For ScreenshotMaximum Mortgage for given periodic repaymentDetermines the maximum loan serviceable by a specified repayment. It does not require a GoalSeek.max_loan_mortgage.xls
Click For ScreenshotScheduled Repayment loanLoan model where you have set advances and repayments on specific dates.loan_schedrep.xls
Click For ScreenshotScheduled Repayment Loan with Interest RollupLoan model where you have set advances and repayments on specific dates, BUT want to be able to roll-up the interest until a certain date.loan_rollup.xls
Click For ScreenshotFlexible Mortgage Loan with stepped paymentsUsing the Mortgage() function, this template models a loan where the overall payment profile can be stepped, and can run on any timebase. Good for property loans where all rent goes to debt service.loan_mortgage_matcheddebtservice.xls
175