Compound Interest

[Muthukrishnan V]

Compound Interest calculation

Office 365

Cell C182 contains Investment in numerical 64000
Cell C183 contains Interest rate per annum 6.10%
Cell C184 contains period (in months) 21
Cell C185 contains compounding frequency: 4
(Quarterly; 4 times in a year)

I request formula for arriving at the compounded value of the investment,
rounded to the nearest rupee, on maturity date.

Thanking you,

 

[Dave Patton]

What did you try?
You can add the rounding to the nearest rupee.

T202007b.xlsm
	B	C
1	Investment	64,000.00
2	Rate -Annual	6.10%
3	Months	21
4	Compounding	4
5
6	Future Value	$69,292.82
7
4b

Cell Formulas
Range	Formula
C6	C6	=FV(C2/4,C3/4,0,-C1,0)

 

[Muthukrishnan V]

Thanking you Mr Dave Patton Sir,