How do you calculate the annuity due using Excel?
Not what you're looking for?
Terry Austin is 30 years old and is saving for her retirement. She is planning on making 36 contributions to her retirement account at the beginning of each of the next 36 years. The first contribution will be made today (t = 0) and the final contribution will be made 35 years from today (t = 35). The retirement account will earn a return of 10 percent a year. If each contribution she makes is $3,000, how much will be in the retirement account 35 years from now (t = 35)?
Use Excel.
Purchase this Solution
Solution Summary
The solution shows how to calculate the future value of an annuity due in Excel.
Solution Preview
Please see attached file
Terry Austin is 30 years old and is saving for her retirement. She is planning on making 36 contributions to her retirement account at the beginning of each of the next 36 years. The first contribution will be made today (t = 0) and the final contribution will be made 35 years from today (t = 35). The retirement ...
Purchase this Solution
Free BrainMass Quizzes
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.