Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 nameDateMonthly AmortizationCumulative Amort.Remaining Amort
Series 11/31/2021$1,000$1,000$9.000
Series 12/28/2021$1,000$2,000$8,000

 

 

Thanks in advance!

 

 

4 Replies