Reverse Compound Interest

[wendy21]

Hi, I need a formula to calculate reverse compound interest.
I know the end amount, interest rate, period of compounding and term:

End Value £100,000
Interest Rate 9.5%
Term 1 year
Compounds monthly
What is the initial amount?

Thanks in advance.

 

[Dave Patton]

check help information for PV and FV

Future Value.xlsm
	B	C	D
1
2	End value	100,000.00
3	Interest	9.5%
4	Term	1
5	Present value	90,971.32	$90,971.32
6
1b

Cell Formulas
Range	Formula
C5	C5	=PV(C3/12,C4*12,0,-C2)
D5	D5	=FV(C3/12,-C4*12,0,-C2)

 

[wendy21]

Thank you.