Question

In: Finance

An investor plans the following investments for the next 20 years: 12.00 years of $10,200.00 per...

An investor plans the following investments for the next 20 years: 12.00 years of $10,200.00 per year, and 8.00 years of $13,825.00 per year.

She thinks his investments will earn 6.00% a year for the first 12.00 years, and then earn 11.00% per year for the last 8.00 years. How much would the investor have to set aside today if she wants to fund the entire account?

Solutions

Expert Solution

The amount to be set aside = Present value of investment to be made.

Step1.

find the present value of investment to be made at $10,200 for first 12 years

Present Value = $10,200 X PV Annuity factor 12 years at 6%,

= (((1+i)n)-1) / (((1+i)n)(i)),

Where 'i' is the interest rate = 6% or 0.06,

n is the number of years = 12,

Applying values in formula, ((1.0612)-1) / ((1.0612)(0.06),

8.38384394038333,

Present Value = $10,200 X 8.38384394038333,

= $85,515.20819191

Step2.

find the present value of investment to be made at $13,825 for 8 years.

Present Value = $13,825 X PV Annuity factor 8 years at 11%,

PV Annuity factor 8 years at 11% = (((1+i)n)-1) / (((1+i)n)(i)),

Where 'i' is the interest rate = 11% or 0.11,

n is the number of years = 8,

Applying values in formula, ((1.118)-1) / ((1.118)(0.11),

PV Annuity factor 8 years at 11% = 5.14612276092708,

Present Value = $13,825 X 5.14612276092708,

Present Value =$71,145.1471698169

Step 3.

Discound the amount in step2 at 12th year discount factor.

The amount get from step 2 is the present value at the year 12 of the investment from year 13 to year20. The amount to set aside to fund the entire account at the year0 i.e, now. So the amount in step2 is to be discounted to arrive its year0 value by using the discount factor of year12.

the formula for discount rate = 1/ (1+i)n, where i is the existing interest rate = 6% or 0.06,

n = 12

the discount factor of year12 = 1/ (1.0612),

= 0.496969363577001

The Year0 value of investment from 13th year through 20th year = Step2 Value X the discount factor of year12,

=$71,145.1471698169 X 0.496969363577001,

= $35,356.9585105759

Step 4.

Add step1 value and step3 value. this is the present value of total investment to be made annually. this is the amount to be setaside to fund the entire account.

Total Year0 Value = Step1 value + Step3 Vaue,

= $85,515.20819191 + $35,356.9585105759,

= $120,872.166702486, Rounded to 2 decimal places = $120,872.17.

Please rate the answer maximum if you get the answer and satisfied. If you remains any doubts on this answer, please leave a comment and it will be cleared.

Thank you,…


Related Solutions

An investor plans the following investments for the next 20 years: 12.00 years of $10,075.00 per...
An investor plans the following investments for the next 20 years: 12.00 years of $10,075.00 per year, and 8.00 years of $13,775.00 per year. She thinks his investments will earn 4.00% a year for the first 12.00 years, and then earn 11.00% per year for the last 8.00 years. How much would the investor have to set aside today if she wants to fund the entire account?
An investor plans the following investments for the next 20 years: 12.00 years of $10,550.00 per...
An investor plans the following investments for the next 20 years: 12.00 years of $10,550.00 per year, and 8.00 years of $13,950.00 per year. She thinks his investments will earn 5.00% a year for the first 12.00 years, and then earn 11.00% per year for the last 8.00 years. How much would the investor have to set aside today if she wants to fund the entire account? PLEASE ROUND TO 2 DECIMAL PLACES. THANKS IN ADVANCE.
Derek can deposit $266.00 per month for the next 10 years into an account at Bank A. The first deposit will be made next month. Bank A pays 12.00%
Derek can deposit $266.00 per month for the next 10 years into an account at Bank A. The first deposit will be made next month. Bank A pays 12.00% and compounds interest monthly. Derek can deposit $2,572.00 per year for the next 10 years into an account at Bank B. The first deposit will be made next year. Bank B compounds interest annually. What rate must Bank B pay for Derek to have the same amount in both accounts after...
Graham plans to save $100 each month for the next 20 years so he can purchase...
Graham plans to save $100 each month for the next 20 years so he can purchase a boat. If he earns 10% interest annually with monthly compounding, how much money will he have at the end of 20 years if he starts saving today?
Dr.Arrowhead will receive $150,000 per year for the next 20 years as an ordinary annuity payment...
Dr.Arrowhead will receive $150,000 per year for the next 20 years as an ordinary annuity payment for a high-tech slingshot weapon he invented. If a 6 percent rate is applied, should he be willing to sell out his future rights now for $2,000,000?
2. An investor plans to retire in 10 years. As part of the retirement portfolio, the...
2. An investor plans to retire in 10 years. As part of the retirement portfolio, the investor buys a newly issued, 12-year, 8% annual coupon payment bond. The bond is purchased at par value, so its yield-to-maturity is 8.00% stated as an effective annual rate. a. Calculate the approximate Macaulay duration for the bond, using a 1 bp (0.01%) increase and decrease in the yield-to-maturity and calculating the new prices per 100 of par value to six decimal places. b....
What is the value per share be of a company with the following dividends? Next years...
What is the value per share be of a company with the following dividends? Next years Dividend is expected to be $1.40 Expect Div Growth rates 13.40% 12.70% 10.80% 9.65% 7.70% ROE = 13.47% Plowback Rate= 61% US T-BILL = 1.15% BETA = 1.07 expect ret in Mkt = 10.83% Please compute with excel
You have an opportunity to invest in an investment plan for the next 45 years. This plan will offer compound interest of 8 percent per year for the next 20 years and 11 percent per year for the last 25 years.
  a) You have an opportunity to invest in an investment plan for the next 45 years. This plan will offer compound interest of 8 percent per year for the next 20 years and 11 percent per year for the last 25 years. If you invest $8,000 in this plan today, how much will you accumulate at the end of the 45 years? Choose the correct answer: $505,539.84 $501,516.38 $506,570.12 $509,092.54 $592,394.59 b) Your rich uncle will give you a...
Assume the following scenario: Bob plans to retire in 20 years from now and wants to...
Assume the following scenario: Bob plans to retire in 20 years from now and wants to have the following stream of CFs after retirement. Monthly payments of $4,000 for 15 years starting right after retirement (The first payment will be at the end of the first month in year 21). He then needs an extra 50000$ with the final payment (final month of year 35). Starting from year 36, he wants the monthly payments to be 6000$ for 10 years...
Which of the following investments is clearly preferred to the others for an investor who is...
Which of the following investments is clearly preferred to the others for an investor who is not holding a well-diversified portfolio.. Asset E(r) σ2 A .15 .10 B .18 .12 C .21 .08
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT