0 ITEMS
Loan Amortization Table Template
The Loan Amortization Table is a great tool to use when looking at the financial impact of a loan.
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 ProductsOther customers were also interested in...
Giorgos
Lending Company Financial Model – 5 Year Forecas...
Financial Model presenting a business scenario of a corporation engaged in granting loans from its o... 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
Andreas
Collateralized Mortgage Obligations Model
Collateralized Mortgage Obligations Model presents a simple model where mortgage backed securities a... Read more
anthony
Bundle – Business Financial Forecasting Mode...
The purpose of this Bundle of Business Forecasting and Financial Models is to assist Business Owners... Read more
Anuj
Private Equity Fund Model (Investor Cashflows)
The Private Equity Fund Cashflows Model helps LPs and GPs analyze fund cash flows, returns, and dist... Read more
Eastwich Advisors
Debt Fund Excel Model
Explore the Debt Fund Excel Model, a comprehensive tool for evaluating new credit fund opportunities... Read more
You must log in to submit a review.