Purchase Solution

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

Not what you're looking for?

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?

##### Solution Summary

The solution calculates the future value of a retirement contribution showing all the steps with the proper responses. Then the solution explains how to do the same calculations in Excel.

##### Solution Preview

Future Value (FV) = P(1+r)^n

(1) Where, P=\$20000, r=11% and n=45 years.

FV = 20000(1.11)^45 ...

##### Free BrainMass Quizzes

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

##### Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

##### MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.