Forum Discussion
Debt amortization schedule
Hi,
I am new to Power Bi and would like to know if it's possible to create a full debt amortization scehdule based on the following inputs:
- Debt Name
- Start Date
- End Date
- Terms (Months)
- Amount
From here, I would want it to be able to automatically calculate the following:
- Monthly amortization (displayed by each month for entire term)
- Cumulative amortization
- Remaining amortization
I would want the program to be able to calculate the monthly amortization based on Amount divded by Terms and have it automatically associate with a date each month between the start and end dates.
An example:
Series 1 debt for $10,000 amortized over 10 months:
| Debt name | Date | Monthly Amortization | Cumulative Amort. | Remaining Amort |
| Series 1 | 1/31/2021 | $1,000 | $1,000 | $9.000 |
| Series 1 | 2/28/2021 | $1,000 | $2,000 | $8,000 |
Thanks in advance!
4 Replies
- AlexisOlsonSuper User
It's certainly possible. Lots have been written about this.
https://spreadsheetheroes.com/amortization-schedule-power-bi/
https://community.powerbi.com/t5/Desktop/loan-amortization/td-p/632336
- Ashish_MathurSuper User
Hi,
Share some data and show the expected result.
- AnonymousNot applicable
Hello! theh below chart would the expected result. That result would come from inputting only the first few fields.
Thanks!
- Ashish_MathurSuper User
Hi,
i do not see any chart in your latest message.