You are saving for a Porsche Carrera Cabriolet, which currently sells for nearly half a million dollars. Your plan is to deposit $30,800 at the end of each year for the next 10 years. You expect to earn 7 percent each year. Required: 1. Determine how much you will have saved after 10 years. 2. Determine the amount saved if you were able to deposit $33,300 each year. 3. Determine the amount saved if you deposit $30,800 each year, but with 11 percent interest.

You are saving for a Porsche Carrera Cabriolet, which currently sells for nearly half a million dollars. Your plan is to deposit $30,800 at the end of each year for the next 10 years. You expect to earn 7 percent each year. Required: 1. Determine how much you will have saved after 10 years. 2. Determine the amount saved if you were able to deposit $33,300 each year. 3. Determine the amount saved if you deposit $30,800 each year, but with 11 percent interest.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter27: Time Value Of Money (compound)

Section: Chapter Questions

Problem 6E

See similar textbooks

Similar questions

Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $4,200 over the next 6 years when the interest rate is 8%, how much do you need to deposit in the account? B. If you place $8,700 in a savings account, how much will you have at the end of 12 years with an interest rate of 8%? C. You invest $2,000 per year, at the end of the year, for 20 years at 10% interest. How much will you have at the end of 20 years? D. You win the lottery and can either receive $500,000 as a lump sum or $60,000 per year for 20 years. Assuming you can earn 3% interest, which do you recommend and why?
If you are saving the same amount each month in order to buy a new sports car when the new models are released, which of the following will help you determine the savings needed? A. future value of one dollar ($1) B. present value of one dollar ($1) C. future value of an ordinary annuity D. present value of an ordinary annuity
Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $2,500 over the next 4 years when the interest rate is 15%, how much do you need to deposit in the account? B. If you place $6,200 in a savings account, how much will you have at the end of 7 years with a 12% interest rate? C. You invest $8,000 per year for 10 years at 12% interest, how much will you have at the end of 10 years? D. You win the lottery and can either receive $750,000 as a lump sum or $50,000 per year for 20 years. Assuming you can earn 8% interest, which do you recommend and why?
You want to invest $8,000 at an annual Interest rate of 8% that compounds annually for 12 years. Which table will help you determine the value of your account at the end of 12 years? A. future value of one dollar ($1) B. present value of one dollar ($1) C. future value of an ordinary annuity D. present value of an ordinary annuity
Conestoga Plumbing plans to invest in a new pump that is anticipated to provide annual savings for 10 years of $50,000. The pump can be sold at the end of the period for $100,000. What is the present value of the investment in the pump at a 9% interest rate given that savings are realized at year end?
Calculating interest earned and future value of savings account. If you put 6,000 in a savings account that pays interest at the rate of 3 percent, compounded annually, how much will you have in five years? (Hint: Use the future value formula.) How much interest will you earn during the five years? If you put 6,000 each year into a savings account that pays interest at the rate of 4 percent a year, how much would you have after five years?
How much must be invested now to receive $50,000 for 8 years if the first $50,000 is received in one year and the rate is 10%?