Question

To meet your retirement goals (and pay for that big trip around the world) you will need $85,000 in your travel account at the end of 12 years. You are able to place $2800 in to the account at the end of each year.  However, you know that this won't make it. Once the estate clears, you are expecting an inheritance from you late uncle in 5 years. (start the savings account now.. 5 years from now, you will have $$ from uncle).If you can get a 4.2% rate on you account (PYCY)… how much do you need from you uncle to make work?

Answer 1

Amount needed from uncle in 5 years will be $ 31,821.46

Step-1:Calculation of annual saving of $ 2800 in 12 years
Future Value		=FV(rate,nper,pmt,pv)
		= $42,558.16
Where,
rate	=	4.20%
nper	=	12
pmt	=	$(2,800.00)
pv	=	0
Step-2:Calculation of balance amount needed
Total amount needed in 12 years		$85,000.00
Less future value of $ 2,800		$42,558.16
Balance amount needed in 12 years		$42,441.84
Step-3:Calculation of amount needed from uncle 5 years from now
Amount neede from uncle in 5 years from now will the such amount , future value of which could become $ 42,441.84.
Present Value		=-PV(rate,nper,pmt,fv)
		= $31,821.46
Where,
rate	=	4.20%
nper	=	7 (12-5)
pmt	=	0
fv	=	$42,441.84