You want to calculate the payment for a loan amount of INR 20,000 at 10% interest rate for a period of 2 years.
You want to calculate the payment for a loan amount of INR 20,000 at 10% interest rate for a period of 2 years. Which of the following excel formula would you use in cell E2 assuming the loan is compounded monthly?
A"=PMT(A2/C2,B2*C2,D2)"
B"=NPER(A2/C2,B2*C2,D2)"
C"=RATE(A2/C2,B2*C2,D2)"
D"=PV(A2/C2,B2*C2,D2)"
Post your answers here:
Post
