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
The account would be worth $2,190,605 when you retire.
(2) When you contribute after 10 years, ...