Suppose you are committed to owning a $225,000 Ferrari. Required: If you believe your mutual fund can...

Free

80.2K

Verified Solution

Question

Finance

Suppose you are committed to owning a $225,000 Ferrari.
Required:

If you believe your mutual fund can achieve a 8.50 percentannual rate of return, and you want to buy the car in 14 years onthe day you turn 35, how much must you invest today?(Enter rounded answer as directed, but donot use rounded numbers in intermediate calculations.Round your answer to 2 decimal places (e.g.,32.16).)

  Amount to be invested$   

You have just made your first $10,000 contribution to yourindividual retirement account. Assume you earn a 7.5 percent rateof return and make no additional contributions.

Requirement 1:

What will your account be worth when you retire in 45 years?(Enter rounded answer as directed, but do not use roundednumbers in intermediate calculations. Round youranswer to 2 decimal places (e.g., 32.16).)

  Amount$   
Requirement 2:

What if you wait 10 years before contributing? (Enterrounded answer as directed, but do not use rounded numbers inintermediate calculations. Round your answer to 2decimal places (e.g., 32.16).)

  Amount$   

You expect to receive $20,000 at graduation in two years. Youplan on investing it at 10 percent until you have $100,000.

Required:

How long will you wait from now? (Enter rounded answeras directed, but do not use rounded numbers in intermediatecalculations. Round your answer to 2 decimalplaces (e.g., 32.16).)

  Periodyears
You have decided that you want to be a millionaire when youretire in 45 years.
Requirement 1:

If you can earn an annual return of 9 percent, how much do youhave to invest today? (Enter roundedanswer as directed, but do not use rounded numbers in intermediatecalculations. Round your answer to 2 decimalplaces (e.g., 32.16).)

  Investment$   
Requirement 2:

What if you can earn 4.5 percent?(Enter rounded answer as directed, but donot use rounded numbers in intermediate calculations.Round your answer to 2 decimal places (e.g.,32.16).)

  Investment$   

You have $25,000 you want to invest for the next 30 years. Youare offered an investment plan that will pay you 5 percent per yearfor the next 15 years and 8 percent per year for the last 15years.

Requirement 1:

How much will you have at the end of the 30 years?(Enter rounded answer as directed, but donot use rounded numbers in intermediate calculations.Round your answer to 2 decimal places (e.g.,32.16).)

  Amount$   
Requirement 2:

If the investment plan pays you 8 percent per year for the first15 years and 5 percent per year for the next 15 years, how muchwill you have at the end of the 30 years?(Enter rounded answer as directed, but donot use rounded numbers in intermediate calculations.Round your answer to 2 decimal places (e.g.,32.16).)

  Amount$   

Answer & Explanation Solved by verified expert
4.5 Ratings (794 Votes)

Rate Rate of return 8.50%
Nper Number of years 14 71806.9
Fv Amount required after 14 years $225,000
PV Amount to be invested today $71,806.90 (Using PV function of excelwith Rate=8.5%,Nper=14, Fv=-225000)
Excel Command: =PV(8.5%,14,,-225000)
Amount to be invested   $71,806.90
Pv Amount contributed now $10,000
Nper Number of years 45
Rate Rate of return per year 7.50%
FV Amount worth in 45 years $259,048.39 (Using FV function of excelwith Rate=7.5%,Nper=45, Pv=-10000)
ExcelCommand:=FV(7.5%,45,,-10000)
Amount $259,048.39
If youwait for 10years before contributing
Amount worth in 35 years $125,688.70 (Using FV function of excelwith Rate=7.5%,Nper=35, Pv=-10000)
ExcelCommand:=FV(7.5%,35,,-10000)
Amount $125,688.70
Pv Amount to be invested in 2 years $20,000
Rate Interest rate 10%
Fv Required Future Value $100,000
NPER Number of years of investment 16.9 (Using NPER function of excelwith Rate=10%, Pv=-20000,Fv=100,000)
Number of years from now 19.9 (16.9+2)
Period 20 Years (rounded towhole number)

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

Suppose you are committed to owning a $225,000 Ferrari.Required:If you believe your mutual fund can achieve a 8.50 percentannual rate of return, and you want to buy the car in 14 years onthe day you turn 35, how much must you invest today?(Enter rounded answer as directed, but donot use rounded numbers in intermediate calculations.Round your answer to 2 decimal places (e.g.,32.16).)  Amount to be invested$   You have just made your first $10,000 contribution to yourindividual retirement account. Assume you earn a 7.5 percent rateof return and make no additional contributions.Requirement 1:What will your account be worth when you retire in 45 years?(Enter rounded answer as directed, but do not use roundednumbers in intermediate calculations. Round youranswer to 2 decimal places (e.g., 32.16).)  Amount$   Requirement 2:What if you wait 10 years before contributing? (Enterrounded answer as directed, but do not use rounded numbers inintermediate calculations. Round your answer to 2decimal places (e.g., 32.16).)  Amount$   You expect to receive $20,000 at graduation in two years. Youplan on investing it at 10 percent until you have $100,000.Required:How long will you wait from now? (Enter rounded answeras directed, but do not use rounded numbers in intermediatecalculations. Round your answer to 2 decimalplaces (e.g., 32.16).)  PeriodyearsYou have decided that you want to be a millionaire when youretire in 45 years.Requirement 1:If you can earn an annual return of 9 percent, how much do youhave to invest today? (Enter roundedanswer as directed, but do not use rounded numbers in intermediatecalculations. Round your answer to 2 decimalplaces (e.g., 32.16).)  Investment$   Requirement 2:What if you can earn 4.5 percent?(Enter rounded answer as directed, but donot use rounded numbers in intermediate calculations.Round your answer to 2 decimal places (e.g.,32.16).)  Investment$   You have $25,000 you want to invest for the next 30 years. Youare offered an investment plan that will pay you 5 percent per yearfor the next 15 years and 8 percent per year for the last 15years.Requirement 1:How much will you have at the end of the 30 years?(Enter rounded answer as directed, but donot use rounded numbers in intermediate calculations.Round your answer to 2 decimal places (e.g.,32.16).)  Amount$   Requirement 2:If the investment plan pays you 8 percent per year for the first15 years and 5 percent per year for the next 15 years, how muchwill you have at the end of the 30 years?(Enter rounded answer as directed, but donot use rounded numbers in intermediate calculations.Round your answer to 2 decimal places (e.g.,32.16).)  Amount$   

Other questions asked by students