Overview

CALCULATE THE AMORTIZATION SCHEDULE OF A MORTGAGE OR CONSUMER LOAN, EITHER AT FIXED OR VARIABLE INTEREST RATE OR BOTH (most online calculators only accept fixed interest rates with standard monthly repayments)

 

This calculator will compute a mortgage or an amortised loan's periodic payment amount at the defined payment intervals, based on the principal amount borrowed, the term's length and the annual interest rate (fixed or variable), generating an amortisation schedule for the full term, also in chart form.

 

An amortization schedule is a complete table of periodic payments, showing the amount of principal and the amount of interest that comprise each payment until the loan is paid-off at the end of its term. While each periodic payment is the same amount, early in the schedule the majority of each payment is what is owed in terms of interest, while later in the schedule the majority relates to the loan's principal. Thus, the shorter the term of the loan, the lower the interest paid.

 

The model requires the following data inputs:

  • Loan amount
  • Interest rate type (fixed, variable, mixed)
  • Interest rate
  • Term (number of years)
  • Installments frequency (monthly, quarterly, semi-annual, annual)
  • Date of first installment

 

Based on the above, the following information will be automatically generated:

  • Amount of periodic payment (principal plus interest)
  • Total payments (principal plus interests) at due date
  • Total interest payment at due date
  • Residual balance to date (principal)
  • Principal repaid to date
  • Interest paid to date
  • Interest paid in the current year (for tax deduction purposes)
  • full amortisation schedule

 

 

 

Reviews Add a review
No reviews yet

More From Domenico Cristarella

Browse our top rated business templates. See All
PREPAID EXPENSE & UNEARNED INCOME CALCULATOR
109
2
THE MODEL CALCULATES MONTHLY AMORTIZATION FOR PREPAID EXPENSES AND/OR UNEARNED INCOME, GENERATING RELEVANT ACCOUNTING ENTRIES. Prepaid expenses represent expenditures that have been…
NET TOTAL RETURN ON BOND INVESTMENT CALCULATOR
169
9
CALCULATE NET TOTAL RETURN ON BOND INVESTMENT DENOMINATED IN ANY CURRENCY, broken-down by trading gains (realized & unrealized), foreign exchange gains (realized…
ANALYTICAL RETURN ON INVESTMENT (ROI) CALCULATOR
357
42
This tool calculates return of an investment denominated in any currency, split between Realized and Unrealized and further dissected into…
FINANCIAL MANAGEMENT SYSTEM
563
47
FULLY FLEDGED ACCOUNTING AND FINANCIAL MANAGEMENT PACKAGE FOR PRIVATE INVESTORS, SMALL FINANCIAL SERVICE BUSINESSES AND PROFESSIONALS A comprehensive tool to…
DEPRECIATION SCHEDULE CALCULATOR
585
39
CALCULATE DEPRECIATION OF AN ASSET USING 4 OF THE MOST POPULAR DEPRECIATION METHODS. Fully editable version available. This excel tool will calculate the…
EFFECTIVE NET YIELD TO MATURITY CALCULATOR
466
31
CALCULATE THE EFFECTIVE NET YIELD-TO-MATURITY (OR TO SALE DATE) OF A BOND, KEEPING PRICE VOLATILITY AND INTEREST RATE RISK UNDER…
See All