Question

2) Felix’s Retirement Plan Felix just turned 40 years-old. Although he still has many years of...

2) Felix’s Retirement Plan Felix just turned 40 years-old. Although he still has many years of work ahead of him, he feels that he has not been saving enough for his retirement and wants to remediate the issue. He makes an appointment with his banker who offers the following long-term investment scheme: Felix is to commit to invest $1,000 at the beginning of each month for the next 20 years. These funds are to be invested 50% in bonds and 50% in stocks. The expected nominal annual return is 4% for the bonds and 8% for the stocks. Before any penny is invested in the markets, however, the bank’s management fees (5% of each $1,000 monthly investment) must be paid upfront for the entire investment plan.This means that the monthly payments will first be applied to paying the bank fees for the entire amount that Felix will invest over the 20-year life of this investment plan. Once all the fees are paid, the following monthly payments will be invested in bonds and stocks on Felix’s behalf. (Note: there is no time-value-of-money calculation applied to these fees, they are just calculated as 5% of all the $1,000 monthly payments to be made by the investor throughout the 20-year life of the product). a) What will be the $ value (to the nearest cent) of the investment in bonds at maturity, i.e., 20 years from today, after the fees are paid and assuming that the bonds perform as predicted? b) What will be the $ value (to the nearest cent) of the investment in stocks at maturity, i.e., 20 years from today, after the fees are paid and assuming that the stocks perform as predicted? c) What will be the true rate of return on the entire investment plan, expressed as an Effective Annual Rate (EAR), assuming that bonds and stocks perform as predicted? (the EAR should contain 4 decimals)

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

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins as Cut 11.A. A.--- 9- ずWrap Text ー E ゴText General copy ▼ チFormat Painter B l U. ーータ.Δ. -=- 還便困Merge & Center. $,%,,Ma conditional Format Cell Insert Delete Format Conditional Fomat yell Inserta Formatぶutos mh A 2 ClearFe Select Edting Clipboard Alignment Number er Cells TJ2 TH TN TO TP TO TR TS 110 TW WHEN AMOUNT IS COMPOUNDED ANNUALLY, INTEREST IS PAID ONLY ONCE SAY RATE AMOUNT- AFTER A YEAR, YOU WILL GET- 1000(1+10%)- 4 10% 1000 6 1100 8 NOW IF AMOUNT IS COMPOUNDED SEMI-ANNUALLY, INTEREST WILL BE PAID 2 TIMES, AT THE END OF 6 MONTHS AND AT THE END OF 12 MONTHS SAY RATE AMOUNT 10 1.1 12 13 14 15 16 17 143 19 20 /4 | CALCULATOR , 1096 INTEREST FOR 6 MONTHS 1000*(1+1096/2)- NOW INTEREST FOR NEXT 6 MONTHS WILL BE PAID ON 1050 THAT IS 1000+50 WHICH WE RECEIVED OF INTEREST SO OBVIOUSLY AS INTEREST IS ALSO PAYABLE ON INTEREST, THE FUTURE VALUE WILL BE HIGHER THAN ANNUAL COMPOUNDING INTEREST FOR NEXT 6 MONTHS = SO TOTAL AMOUNT RECEIVED = 1102.5, WHICH IS 2.5 MORE THAN ANNUAL COMPOUNDING 1050 1050*(1+1096/2) = 1102.5 SO HIGHER THE COMPOUNDING HIGHER WILL BE THE AMOUNT So MONTHLY COMPOUNDING WILL GIVE HIGHEST FUTURE VALUE TOR LOAN OPTIONS pv, fv, annuity CAP STRU VALUE profit margin symbols LOCK BOX DILUTION DOLLAR COST AVG MORTGAGE XPO Sheeti Sheet2 S OPTIONS rences: x261 福 130%File Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum Calibri ー E ゴWrap Text General aCopy в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Paste Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard G0404 GM Font Alignment Number Styles Cells Edting GN GO GP GQ GR GS GT GU GV GW 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 I < CALCULATOR , LOAN OPTIONS ! TOTAL FUTURE VALUE AT THE END OF 20 YEARS FROM SToCK FROM BOND TOTAL AMOUNT 281649.93 174798.67 456448.60 INVESTMENT PER MONTH YEARS PERIODS IN A YEAR 1000 ANNUITY DUE 12 MONTHLY RATE- 0.491424096 RATE(GS397*GS398,-GS396,GS394) ANSWER c RC EAR= (1+0.491424%)^12-1 = 6.0591% fv, annu CAP STRU VALUE LOCK BOXDILUTION DOLLAR COST AVGMORTGAGE EXPO Sheeti Sheet2She rences: x261 08:33 29-01-2019

Add a comment
Know the answer?
Add Answer to:
2) Felix’s Retirement Plan Felix just turned 40 years-old. Although he still has many years of...
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
  • Fin Mgt-Group Assignment #1.pdf d 2017.Fin Mgt-Group Assignment #1.pdf (471 KB) Felix just turned 40 years-old....

    Fin Mgt-Group Assignment #1.pdf d 2017.Fin Mgt-Group Assignment #1.pdf (471 KB) Felix just turned 40 years-old. Although he still has many years of work ahead of him, he feels that he has not been saving enough for his retirement and wants to remediate the issue. He makes a appointment with his banker who offers the following long-term investment scheme: Felix is to commit to invest $1,000 at the beginning of each month for the next 20 years. These funds are...

  • Fin Mgt-Group Assignment #1.pdf d 2017.Fin Mgt_Group Assignment #1.pdf (471 KB) Felix just turned 40 years-old....

    Fin Mgt-Group Assignment #1.pdf d 2017.Fin Mgt_Group Assignment #1.pdf (471 KB) Felix just turned 40 years-old. Although he still has many years of work ahead of him, he feels that he has not been saving enough for his retirement and wants to remediate the issue. He makes a appointment with his banker who offers the following long-term investment scheme: Felix is to commit to invest $1,000 at the beginning of each month for the next 20 years. These funds are...

  • Jack has just turned 40 years old. He has currently accumulated $55,000 toward his planned retirement...

    Jack has just turned 40 years old. He has currently accumulated $55,000 toward his planned retirement at age 60. He wants to accumulate enough money over the next 20 years to provide for a 25-year retirement annuity of $100,000 at the beginning of each year, starting with his 60th birthday. He plans to save $8,000 at the end of each year for the next 10 years. What equal amount must be saved at the end of years 11 through 20...

  • Barry has just become eligible for his​ employer-sponsored retirement plan. Barry is 40 and plans to...

    Barry has just become eligible for his​ employer-sponsored retirement plan. Barry is 40 and plans to retire at 65 . Barry calculates that he can contribute ​$4 comma 400 per year to his plan.​ Barry's employer will match this amount. If Barry can earn a return of 6 ​% on his​ investment, he will have ​$482 comma 808 at retirement. Assuming a return of 6 ​%, how much would Barry have if he could invest an additional ​$900 per year...

  • You are 25 years old, having just started working. You are considering a retirement plan for...

    You are 25 years old, having just started working. You are considering a retirement plan for a retirement at the age of 65. You want to be able to withdraw $76,000 from your savings account on each birthday for 20 years following your retirement at the age of 65. Your first withdrawal will be on your 66th birthday. To achieve your goal, you intend to make equal annual deposits in a pension scheme which offers 7% interest per year. According...

  • Mr. Moore is 35 years old today and is beginning to plan for his retirement. He...

    Mr. Moore is 35 years old today and is beginning to plan for his retirement. He wants to set aside an equal amount at the end of each of the next 25 years so that he can retire at age 60. He expects to live to the maximum age of 80 and wants to be able to withdraw $25,000 per year from the account on his 61st through 80th birthdays. The account is expected to earn 10 percent per annum...

  • Mike is planning to retire in 32 years. He is thinking about opening a retirement account...

    Mike is planning to retire in 32 years. He is thinking about opening a retirement account and plans to invest an equal amount each year into the account. He expects to earn 10.5% per year in the account and is planning to have $1,500,000 in the account at retirement, what is the amount of Mike's annual investment? ( $7,922 $6,728 $5,387 $4,727 None of the above OMT Inc. is planning to issue a $1,000 face-value bond with an annual coupon...

  • Troy is saving for his retirement 22 years from now by setting up a savings plan. He has set up a...

    Troy is saving for his retirement 22 years from now by setting up a savings plan. He has set up a savings plan wherein he will deposit $ 127.00 at the end of each month for the next 11 years. Interest is 7 % compounded monthly. (a) How much money will be in his account on the date of his​ retirement? ​ (b) How much will Troy ​contribute? ​(c) How much will be​ interest? ​ (a) The future value will...

  • Adam wants to prepare in order to enter retirement in 30 years. He expects that he will be in retirement for 25...

    Adam wants to prepare in order to enter retirement in 30 years. He expects that he will be in retirement for 25 years and he wants to have a monthly income of $2,500 in order to support his lifestyle. At the end of that period he wants to have $20,000 left to take care of end of life expenses. a) How much will he need to have at the time of retirement to accomplish these goals if he car earn...

  • please do both questions 68. 69. Jeremiah has a long-term savings plan. For 10 years, he...

    please do both questions 68. 69. Jeremiah has a long-term savings plan. For 10 years, he has been investing $150 a month, earning 4.25% interest compounded monthly. How much more would he have saved if he had chosen to make deposits of $200 a month? When using the financial calculator, be sure to indicate what you have entered for each parameter, to receive full marks. (5 marks) Darren is 30 and is debating whether he should start investing $100 a...

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