Debt Amortization Table

This simple amortization table calculates how long it takes for a monthly installment to repay debt via monthly installments.

Amortization table
,
, , ,

This simple amortization table calculates how long it takes for a monthly installment to repay debt via monthly installments.

  • Graph debt amortization
    Graph debt amortization

The excel model allows you to play around with interest rate, monthly installment and the debt amount to calculate  how long it takes till the debt is repayed.

Financial Model inputs:

  • debt amount
  • interest rate
  • monthly installment

Outputs:

  • # of months needed till the debt has been fully repaid
  • Graph showing debt level, interest and repayments over time

The model thus offers a simple way to play around with a planned debt amortization schedule and via the graph makes it easer to read

Add to wish list

Write a Review

Get these templates too for a discount!

Price: $54.95

This is a collection of financial model templates for businesses in the Education Industry as well as its related sectors.

Add to wish list
Add to cart Excluding 0% tax

Price: $149.95

This is a collection of financial model templates in Excel for businesses in the Manufacturing industry and its related sectors.

Add to wish list
Add to cart Excluding 0% tax

Price: $95.00

This is a collection of financial model templates for businesses in the hospitality industry and its related sectors

Add to wish list
Add to cart Excluding 0% tax