Question: how to calculate rate of return on recurring deposit in excel?
Answer: = FV(Rate,Nper,Pmt,Pv,Type) Modified Rate of Interest: The interest rate in Recurring Deposits (in this case case of 8.75%) is compounded on quarterly basis. Whereas FV is calculated on monthly basis because we are making monthly deposits.So we cannot directly put the standard bank rate into the above formula.