Time Value of Money
Not what you're looking for?
Q1: You are saving for retirement. To live comfortably, you decide you will need to save $2 million by the time you are 65. Today is your 30th birthday, and you decide, starting today and continuing on every birthday up to and including your 65th birthday, that you will put the same amount into a savings account. If the interest rate is 5%, how much must you set aside each year to make sure that you will have $2 million in the account on your 65th birthday?
Q2: You realize that the plan above has a flaw. Because your income will increase over your lifetime, it would be more realistic to save less now and more later. Instead of putting the same amount aside each year, you decide to let the amount that you set aside grow by 7% per year. Under this plan, how much will you put into the account today? (Recall that you are planning to make the first contribution to the account today.)
Please show in excel.
Purchase this Solution
Solution Summary
Calculates the annuity for specified future value.
Solution Preview
Please see attached file
Q1: You are saving for retirement. To live comfortably, you decide you will need to save $2 million by the time you are 65. Today is your 30th birthday, and you decide, starting today and continuing on every birthday up to and including your 65th birthday, that you will put the same amount into a savings account. If the interest rate is 5%, how much must you set aside each year to make sure that you will have $2 million in the account on your 65th birthday?
Total number of payments= 36 counting year 30 ...
Purchase this Solution
Free BrainMass Quizzes
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
SWOT
This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.
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.