There are four children ages 543 20 each child will have


There are four children ages 5,4,3, 2,0. Each child will have 100,000 dollars purchasing power at age 18. Education cost have been increasing at a rate of 7%. Inflation has been steady at 3%. How much must I set aside today to fund my goal for my grandchildren if I can earn a rate of 9% on my return. Please help me understand how to calculate this in excel.

Solution Preview :

Prepared by a verified Expert
Finance Basics: There are four children ages 543 20 each child will have
Reference No:- TGS02736666

Now Priced at $10 (50% Discount)

Recommended (94%)

Rated (4.6/5)