Loan Armortization Schedule Style 347

As time goes on, more and more of each payment goes towards your principal (and you pay less in interest each month). We use the PMT function to calculate the monthly payment on a loan with an annual interest rate of 5%, a 2-year duration and a present value (amount borrowed) of $20,000. We have named the input cells. It takes 24 months to pay off this loan. See how the principal part increases and the interest part decreases with each payment. Your monthly loan payments don’t change; the math simply works out the ratios of debt and principal payments each month until the total debt is eliminated. This template is easy to download and print. Each free business plan template is available in Microsoft Word (DOC) format, and many of the Business Plan Forms are available in Excel (XLS) format as well. This means that at the end of year seven the loan can be paid off in full for the amount of $79,268.02. Typically mortgage lenders will have a balloon payment clause in the contract that will charge a fee for early payment.

Show More

Share this Template:

More templates from this category…

Search
Generic filters
Filter by Custom Post Type
Filter by Categories
Business Formation
Business Management
Business Operations
Business Property
Client and Customer
Construction
Employment
Event
Event & Project Management
Financial
Financial Management
Finder's Fee Agreement
Human Resources
Inventory
IT Project Management
Manufacturing
Personal & Family
Personal Lists, Tracker & Calculator
Real Estate
Website & Services
Will & Estate Planning
Filter by Apps
Excel
Word

Templates by Word