All Industries, Financial Model, General Excel Financial Models |
Debt Amortization, Debt Schedule |
This excel file will allow you to calculate the interest and capital repayments of your mortgage based on the loan amount, the interest rate and the number of years to repay the loan.
The tool will allow you to calculate each period interest and capital repayments, as well as the closing balance of the loan amount at the end of each period.
A mortgage loan is used either by purchasers of real property to raise funds to buy real estate, or alternatively by existing property owners to raise funds for any purpose, while putting a lien on the property being mortgaged. The loan is “secured” on the borrower’s property through a process known as mortgage origination. This means that a legal mechanism is put into place which allows the lender to take possession and sell the secured property to pay off the loan in the event the borrower defaults on the loan or otherwise fails to abide by its terms.
Mortgage borrowers can be individuals mortgaging their home or they can be businesses mortgaging commercial property. The lender’s rights over the secured property take priority over the borrower’s other creditors, which means that if the borrower becomes bankrupt or insolvent, the other creditors will only be repaid the debts owed to them from a sale of the secured property if the mortgage lender is repaid in full first.
In many jurisdictions, it is normal for home purchases to be funded by a mortgage loan. Few individuals have enough savings or liquid funds to enable them to purchase property outright. In countries where the demand for home ownership is highest, strong domestic markets for mortgages have developed.
Similar Products
Other customers were also interested in...
Leveraged Buyout (LBO) Model
Leveraged Buy Out (LBO) Model presents the business case of the purchase of a company by using a hig... Read more
Dynamic Arrays Financial Model
Dynamic Arrays Financial Model generates the three financial statements (profit & loss, balance ... Read more
Mergers and Acquisition (M&A) Financial Model
Merger and Acquisition Model template consists of an excel model which assists the user to assess th... Read more
Sales Commissions Dashboard
This model will allow you to plan your commission structure and monitor the performance of your sale... Read more
Operating Company Financial Model
Operating Company Model consists of an Excel model which allows the user to generate forecast financ... Read more
Capital Budgeting Model Excel Template
Capital Budgeting consists of a process that companies use for decision making on investment project... Read more
Options and Real Options Model Template
Options and Real Options model consists of an Excel model which presents a valuation framework calcu... Read more
Inventory Dashboard Model Template
!! Kindly use the latest Microsoft Excel Version before purchasing the model, otherwise, the dynamic... Read more
Dashboard Actuals PnL Model
!! Kindly use the latest Microsoft Excel Version before purchasing the model, otherwise, the dynamic... Read more
Cash Budget Model
Cash Budget Excel Model generates a simple cash forecast based on a series of assumptions, and compa... Read more
You must log in to submit a review.