Debt Amortization
  • Debt Amortization
  • Debt Amortization
Originally published: 14/09/2019 12:11
Last version published: 25/10/2019 20:19
Publication number: ELQ-83206-2
View all versions & Certificate
certified

Debt Amortization

Debt Amortization Schedule

Description
In this tool, you will be able to calculate the schedule for your debt or loan amortization.

This tool allows you to schedule over a specific period of time. The tool is based solely on six key inputs:

- Purchase Price
- Principal (Debt Financed Portion)
- Interest rate (monthly)
- Term (months)
- Tax Rate
- Repayments per month

By inputting this data, the excel tool automatically creates a chart, documenting a schedule for your loan amortization.

These outputs show:

- Beginning Balance
- Interest
- Balance before payment
- Monthly payment
- Principal repaid
- Ending Balance

As such, this tool is a quick, easy and efficient way of calculating and scheduling your debt repayments and loan amortization. Using this tool will allow you keep a close track of your debt repayments.


Filling in extra space Filling in extra space Filling in extra space Filling in extra space Filling in extra space Filling in extra space Filling in extra space Filling in extra spaceFilling in extra spaceFilling in extra spaceFilling in extra spaceFilling in extra spaceFilling in extra spaceFilling in extra spaceFilling in extra spaceFilling in extra space Filling in extra spaceFilling in extra spaceFilling in extra spaceFilling in extra spaceFilling in extra spaceFilling in extra spaceFilling in extra spaceFilling in extra spaceFilling in extra spaceFilling in extra spaceFilling in extra space

This Best Practice includes
1 Excel File

Prather Financial offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Reviews

  • Be the first to review this Downloadable Tool

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

Any questions on Debt Amortization?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...