Question

You've graduated from college and landed a good job. You want to replace your​ car, but​...

You've graduated from college and landed a good job. You want to replace your​ car, but​ don't want to take out a car loan. ​ Instead, you decide to invest ​$400 per month in the stock market and hope to earn 6%. If the market performs as​ you're hoping, how many years will it take to accumulate $20000​? Ignore taxes.  

Solve using Excel and show all formulas used.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

BI U - - - A E Merge & Center Alignment Font fx =NPER(0.005, 400, 0, -20000) D E F C G H PV PMT FV 400 -20,000 0.06 1/Y 44.74

Add a comment
Know the answer?
Add Answer to:
You've graduated from college and landed a good job. You want to replace your​ car, but​...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • You've graduated from college and have wisely started saving for retirement immediately. However, you don't save...

    You've graduated from college and have wisely started saving for retirement immediately. However, you don't save much and only invest $200 per year in the stock market. Your portfolio earns a 9% annual return, how many years will it take you to accumulate $12,000 in the account? Suppose you bought a house on January 1 and took out a mortgage for $400,000. The amortized loan requires annual payments for 15 years. For tax purposes you want to figure out how...

  • You've landed your first job out of college and they are paying you money like you've...

    You've landed your first job out of college and they are paying you money like you've never seen before! So, you have decided to buy a new car at the end of next two years. Your graduation money has totaled $10,000 and the car you like is priced at $28,000. How much of your paycheck will you need to put away at the end of each month in an 8.85% account that compounds on a monthly basis?

  • You just graduated from college and landed your first "real" job, which pays $32,000 a year....

    You just graduated from college and landed your first "real" job, which pays $32,000 a year. In 12 years how much will you need to earn to maintain the same purchasing power if inflation is 2.50% per year?

  • You just graduated from college and landed your first "real" job, which pays $32,000 a year....

    You just graduated from college and landed your first "real" job, which pays $32,000 a year. In 12 years how much will you need to earn to maintain the same purchasing power if inflation is 2.50% per year?

  • Question 3 (0.5 points) You just graduated from college and landed your first "real" job, which...

    Question 3 (0.5 points) You just graduated from college and landed your first "real" job, which pays $25,000 a year. In 12 years how much will you need to earn to maintain the same purchasing power if inflation is 0.75% per year? Your Answer: Answer Question 4 (0.5 points) You save $600 a year into a 401(k) account that you invest in a mutual fund earning 7% per year. You plan to retire in 30 years. How much money will...

  • You just graduated college with your Bachelors Degree and accepted a job offer at your dream...

    You just graduated college with your Bachelors Degree and accepted a job offer at your dream company. On January 1, 2020, you decide to celebrate by purchasing a Mercedes Convertible (see picture above) for $52,455. You have a 720 credit score, therefore you were able to get a 5% interest rate on a 7 year loan. You will be making monthly payments. Using Excel, prepare a professional amortization schedule for the entire 7 years. It must include the payment and...

  • You just graduated college with your Bachelors Degree and accepted a job offer at your dream...

    You just graduated college with your Bachelors Degree and accepted a job offer at your dream company. On January 1, 2020, you decide to celebrate by purchasing a Mercedes Convertible (see picture above) for $52,455. You have a 720 credit score, therefore you were able to get a 5% interest rate on a 7 year loan. You will be making monthly payments. Using Excel, prepare a professional amortization schedule for the entire 7 years. It must include the payment and...

  • 14. Four years ago, when you were 24, you graduated from college and landed a good...

    14. Four years ago, when you were 24, you graduated from college and landed a good paying job. At that time you purchased your "starter home" for $200K. Since then, the housing market in the city where your home is located experienced unusually high rate of price appreciation and a local real estate agent informed you that if you were to put your home on the market today, you will be able to sell it for about $350K. a. Did...

  • You need $40,000 in ten years for the purchase of a new car for your nephew...

    You need $40,000 in ten years for the purchase of a new car for your nephew who will be graduating college.  You currently have $20,000 saved and want to invest it for ten years at a 6% rate of return. Will you be able to achieve your investment goal in ten years? Answer If not, then how much more would you need to invest today, instead of the $20,000, to accumulate that goal in ten years? Answer If not, and you...

  • a. It is 2016, you've just graduated college, and you are contemplating your lifetime budget. You...

    a. It is 2016, you've just graduated college, and you are contemplating your lifetime budget. You think your general pre-retirement living expenses will average around $50,000 a year. For the next 8 years, you will rent an apartment for $16,000 a year (assume end-of-period payments). At the end of Year 8, you will want to buy a house that should cost around $250,000. In addition, you will need to buy a new car roughly once every 10 years, starting now...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT