The Loan Amortization Table is a great tool to use when looking at the financial impact of a loan.
This model contains an input section where loan detail can be entered such as the Number of Payments, Interest Rate, and Initial Loan Amount. The model will then calculate the information to give a breakdown of principal and interest paid each period and the remaining principal balance. This allows for additional payments to be entered into cell G8 to calculated the payoff period when additional payments are made. Rows will become highlighted in yellow to display when the loan has been paid off. Two charts are shown in the next worksheet to visualize the paydown period as well as the ratio of principal to the interest of each payment during the life of the loan.
All cells in blue font are input cells where custom information can be entered. All cells in black font are formulas set to streamline the model.
Similar Products
Other customers were also interested in...
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
Debt Fund Excel Model
Explore the Debt Fund Excel Model, a comprehensive tool for evaluating new credit fund opportunities... Read more
Collateralized Mortgage Obligations Model
Collateralized Mortgage Obligations Model presents a simple model where mortgage backed securities a... Read more
Bundle – Business Financial Forecasting Mode...
The purpose of this Bundle of Business Forecasting and Financial Models is to assist Business Owners... Read more
Private Equity Fund Model (Investor Cashflows)
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
Lending Platform Financial Model (LaaS)
Includes all the assumptions you need to project the gross revenues and profits of a LaaS platform (... Read more
Lending Model Startup Forecast: 10-Year Scaling &#...
This is a full 10-year startup lending business financial model, including a 3-statement model. Accu... Read more
Flat Fee Lending Business: Operating Model
10-year financial model directly built for a flat fee / fixed fee lender. Includes leverage for orig... Read more
You must log in to submit a review.