-Show the calculations and explanation per question clearly
– Use excel spreadsheets then copy paste it to MS word
You are now 50 years old and plan to retire at the age of 67. You currently have a share portfolio worth ,000, a superannuation fund worth ,000 and a money market account worth ,000. Your share portfolio is expected to provide you annual returns of 12%, your superannuation will earn you 9.5% annually and the money market account earns 6.25%, compounded monthly.
a) If you do not save another cent, what will be the total value of your investments when you retire?
b) Assume that your superannuation contribution is ,000 per year for the next 15 years (starting 1 year from now). How much will your investments be worth when you retire?
c) Assume that you expect to live 23 years after you retire (until age 90). Today, at age 50, you take all of your investments and place them an account that pays 8% annually (use the scenario from part b) in which you continue saving. If you start withdrawing funds starting at age 67, how much can you withdraw every year and leave nothing in your account after the 23
& final withdrawal?
d) At age 67, you want your investments, which are described in the problem statements above, to support a perpetuity that starts a year from now. How much can you withdraw each year without touching your principal (at 8% per year)?
Wattyl Group Ltd has 18-year bonds outstanding. These bonds, which pay semiannual coupons, have a coupon rate of 9.375 per cent and a yield to maturity of 7.95 per cent.
a) Calculate the bondu2019s current price.
b) If the bonds can be called after 5 more years at a premium of 13.5% over the par value, what is the investoru2019s realized yield?
c) If you bought the bond today & sold it a year later, what is your expected rate of return?
Explain in your own words.
What would be the effect on the price of bonds of
a) An unexp