Template Video Tutorial:
If you have a house payment to make or any mortgage, this financial model is a great tool to help the planning and budgeting of the paydown. The template comes in an Excel document and a Google Sheet version as well (link in the Excel file). The inputs are really simple. Simply enter the current loan terms (remaining mortgage balance, payments per year, interest rate (variable or fixed), and remaining term.
The above inputs will automatically create a standard amortization schedule that shows you how much total interest and principal are paid over time based on the loan terms and making regularly scheduled payments for the entire term. Then, there is a second tab that is the same schedule, except it has an extra column for principal payments made above the initial monthly payment. The user can enter any amount in each period, and the schedule will automatically update. The more that is paid earlier, the quicker this second schedule finishes a payoff and the less interest that is paid.
Each tab has the total repayment summary of both scenarios (standard repayment and extra principal payment), so the user can see the total interest paid and the total periods it takes to complete the payoff.
There is also a clean visualization that will update as your data inputs change and shows the remaining balance of both schedules over time as well as the total interest saved per the extra payment schedule.
Similar Products
Other customers were also interested in...
The Realtors Quintessential ALL-IN-ONE Toolkit
Professional Realtors need a professional Toolkit which allows them to operate at a higher level. Th... Read more
Discounted Big Bundle Real Estate Valuation and Fi...
One Excel file for this bundle of Valuation and Financial forecasting models. Storage Parks, Hotels,... Read more
Lending Company Financial Model – 5 Year Forecas...
This Financial model template presents a business scenario of a corporation engaged in granting loan... Read more
Crowdlending (P2P) Platform – 5 Year Financi...
Financial Model providing an advanced 5-year financial plan for a startup Crowdlending (Peer-to-Peer... Read more
Amortization Schedules Template (Loans, Mortgages,...
User friendly template including Amortization Schedules for Loans, Mortgages, Operating and Finance ... Read more
Mobile Home Park / Community Financial Feasibility...
Plan out all aspects of starting up to 40 mobile home communities or parks. End to end from assumpti... Read more
Mixed-Use Real Estate Model: Leverage / JV Options
A general real estate model to plan all assumptions for up to 7 'uses' for a given property. Include... Read more
Joint Venture and Fund Cash Flow Waterfall Templat...
Here are all the spreadsheets I've built that involve cash flow distributions between GP/LP. Include... Read more
Apartment Building / Self-Storage / Multi-Family A...
This real estate model works great for acquisitions of apartment buildings, multi-family properties,... Read more
Top 16 Google Sheet Templates
This is a bundle of all the most useful and efficient google sheet templates I have built over the y... Read more
You must log in to submit a review.