Amortization Schedule

In today's world, accountant and financial analyst has to maintain an excel sheet and formulas to create ammortization scheudle. However, Power BI platform with good Power BI developer to make this process automated.

In this Report, I have utilized monthly rental payment and Interest Dsicount for each month to calculate the amortization.

I have utilize some of the DAX functionalities to make this process faster and automated.

Summarize function

All

Amortization formula in DAX form

IF (
                            PV
                                * POWER ( 1 + I, Series - 1 )
                                - Payment
                                    * DIVIDE ( POWER ( 1 + I, Series - 1 ) - 1, I ) >= 0,
                            PV
                                * POWER ( 1 + I, Series - 1 )
                                - Payment
                                    * DIVIDE ( POWER ( 1 + I, Series - 1 ) - 1, I ),
                            0
                        )

Please check out attached pbix, and laso if you need shot me a message at BI49@frq49.onmicrosoft.com

eyJrIjoiNThjNDRhMWUtNDFiNC00MmQyLWI3MzktN2FjZDlmYTcyZjg1IiwidCI6IjQzMDE5M2U1LTk1OGEtNDMxNC05MDk2LWIzMWIxMGYyOTk2YiIsImMiOjl9

Summarize: Dynamic Amortization Schedule