Im trying to calculate the interest rate of a lease with PowerBI (essentially the Excel RATE -function).
My columns are:
-Monthly Lease Payment
-Total Leasing Capital
-Duration (in months)
If I understand correctly, since the payments are periodic, I have to use XIRR formula like in the post below.
One way would be to modify the GENERATESERIES formula in order to accommodate the advanced payment in the first period and and residual value in the last. How would I go about doing this?
Any other suggestions?
Go to Solution.
It seems that you may directly subtract the advanced payment from the total.
View solution in original post
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!