Amortization refers to the process of paying off a debt (often from a loan or mortgage) over time through regular payments. A portion of each payment is for interest while the remaining amount is applied towards the principal balance. The percentage of interest versus principal in each payment is determined in an amortization schedule. The schedule differentiates the portion of payment that belongs to interest expense from the portion used to close the gap of a discount or premium from the principal after each payment.
While a portion of every payment is applied towards both the interest and the principal balance of the loan, the exact amount applied to principal each time varies (with the remainder going to interest). An amortization schedule indicates the specific monetary amount put towards interest, as well as the specific amount put towards the principal balance, with each payment. Initially, a large portion of each payment is devoted to interest. As the loan matures, larger portions go towards paying down the principal.
This template includes 5 different examples of Amortization Schedules as well as a Line of Credit Calculator
Contents:
• Standard Loan including Interest Only Period option
Amortization Schedule of a fixed-rate loan including an optional interest-only (IO) period.
Loans with an IO period allow borrowers to make payments, for a certain number of years, that include interest only (no principal). The result is a lower payment during the first few years (or months) of the loan.
• Home Mortgage
Amortization Schedule of a fixed-rate or variable-rate Home Mortgage.
The schedule offers users the option to add extra payments and/or ballon payments and calculates how much borrowers can save on interest by making extra payments. It analyses Lenders Yield (APR) as well as the outstanding balance at the end of a specified number of years.
• Line of Credit Calculator
A user-friendly designed for lenders or borrowers to track or service a line of credit account.
It allows users to enter draws and payments or changes in interest rate on the actual dates they occur and calucates interest ad principal paid and total LC amount due.
• Bond Amortization Schedule (Effective Interest Rate method)
The effective interest method involves preparing a bond amortization schedule to calculate the interest expense based on the market rate at the time the bond was issued and the bonds book value. This interest expense is then compared to the actual interest payment based on the face value of the bond and the bond rate, and the difference gives the amount to be amortized to the interest expense account.
• Operating and Finance Leases Amortization Schedules
Amortization Schedules of Operating and Finance Leases including assumptions for Lease Term, Borrowing Rate, BoM or EoM payments, Lease Costs & Incentives. Each schedule also includes supporting Amortization Journal Entries for Income Statement and Balance Sheet.
Help & Support
Committed to high quality and customer satisfaction, all our templates follow best-practice financial modeling principles and are thoughtfully and carefully designed, keeping the user’s needs and comfort in mind.
No matter if you have no experience or are well versed in finance, accounting, and the use of Microsoft Excel, our professional financial models are the right tools to boost your business operations!
If you however experience any difficulty while using this template and you are not able to find the appropriate guidance in the provided instructions, please feel free to contact us for assistance.
If you need a template customized for your business requirements, please e-mail us and provide a brief explanation of your specific needs.
Similar Products
Other customers were also interested in...
Crowdlending (P2P) Platform – 5 Year Financi...
Financial Model providing an advanced 5-year financial plan for a startup Crowdlending (Peer-to-Peer... 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
Private Equity Fund Model (Investor Cashflows)
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
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
Leveraged Buyout (LBO) Financial Projection Model
User-friendly financial model to project and analyse the financial outcomes (IRR, projected financia... 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
Multi-Member Investment Fund Portfolio and Distrib...
A fund management tool to track many positions over time as well as distributions to up to 20 member... Read more
Investment Holding Company 3 Statement Financial P...
3 statement 5 or 8 year rolling financial projection Excel model for an investment holding company h... 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
Mergers and Acquisition (M&A) Financial Projec...
User-friendly financial model to project and analyze the financial outcomes and feasibility of an Me... Read more
You must log in to submit a review.