Find Interest Rate %

[Muthukrishnan V]

Find Interest Rate %.xlsx
	A	B	C	D	E	F	G
1		Excel 365
2		Find Interest Rate %
3		Principal amount	interest Rate %	Period in Months	Principal Compounding every 3 months	Maturity value
4		30,000	Formula Required	24		33,662
5
6		Peincipal amout matures at the end of 24 months
7		Interest applied every 3 months
8		Principal is compounded every 3 months
9		Request formula in C2 for the above example
Sheet1

 

[Dave Patton]

Check Excel's help for information on the functions.
Ensure that the factors and calculations are consistent with the rules in your jurisdiction.

consider

T202301a.xlsm
	A	B	C	D	E	F
1		Principal amount	interest Rate %	2 years	Interest Compounding every 3 months	Maturity value
2		30,000.00	1.450%			33,662.00
3		30,000.00	5.80%			33,662.00
4
5			5.8%
2b

Cell Formulas
Range	Formula
C2	C2	=RATE(2*4,,B2,-F2,0,0.02)
C3	C3	=C2*4
F3	F3	=FV(C3/4,2*4,,-B3)
C5	C5	=C2*4

 

[Legacy 143009]

With generic compound interest formula:

=4*((33662/30000)^(1/(2*4))-1)

2 is for 2-year period. 4 is for, interest will be applied 4 times in a year.

 

[kvsrinivasamurthy]

P(principle)	A(amount)	R(for 1 year)	T(in Months)
30000	33662	?	24
Compounded every 3 months

R

5.80

Formula =100*(((B2/A2)^(3/D2))-1)*4

 

[Muthukrishnan V]

Great. Thank you M/s. Dave Patton, Flashbond and K.V. Srinivasamurthy sirs,