Hello,
Bing AI gave me this solution. Check whether it suits you
The present value (PV) of a stream of cash flows can be calculated using the formula PV = C * [(1 - (1 + r)^(-n)) / r] 12. Here, C is the monthly payment, r is the interest rate per month, and n is the number of months.
For example, if you have a monthly payment of $100, an interest rate of 5% per annum, and a loan term of 36 months, then the present value of the loan would be:
r = 5% / 12 = 0.00416666667
n = 36
C = $100
PV = $100 * [(1 - (1 + 0.00416666667)^(-36)) / 0.00416666667] = $3,456.05
When I tried the same formula in excel, I got $3336.57 for the above value.
For r = 10%, n = 48, C = $2500, I got $98570.4
I hope this helps!
Happiness Always
BKR Sivaprakash
