Determining the future value (FV) of a savings bond using Excel.

How do I set this problem up in a spreadsheet?

You have just made your first $20,000 contribution to your individual retirement account. Assuming you earn an 11% rate of return and make no additional contributions, what will your account be worth when you retire in 45 years? What if you wait 10 years before contributing?

© SolutionLibrary Inc. solutionlibary.com 9836dcf9d7 https://solutionlibrary.com/business/finance/determining-the-future-value-fv-of-a-savings-bond-using-excel-29h

Solution Preview

... $2,190,605

The account would be worth $2,190,605 when you retire.

(2) When you contribute after 10 years, ...