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.

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

Reviews

  • Comment

    Good website. Please allow free to download for learning purpose

    38 of 90 people found this review helpful.

    Help other customers find the most helpful reviews

    Did you find this review helpful? Yes No

    • Hi Sandeep, Many thanks for leaving a review. This template is already free to download! Simply add to cart and proceed to checkout. After completing the checkout process, you will receive the download link to download the template accordingly. To learn more about financial modeling, please feel free to visit our Blog and Knowledgebase section. We hope this helps and as always, we remain available for any questions or further assistance you might require!

      40 of 68 people found this review helpful.

      Help other customers find the most helpful reviews

      Did you find this review helpful? Yes No

  • You must log in to submit a review.