Amortization Schedules (Loans, Mortgages, LC, Bonds, Leases) (Excel XLSB)

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.