Multiplying the rate by account balance for different rate

Assignment Help Financial Management

Reference no: EM131886292

Mr. Richards has a client ready to retire. They have approximately, $1.5 million in an account with the firm. They are very conservative clients and he wants to give them options. The first is to have the money paid out over 30 years earning a 2% rate, then 4%. He also wants to show them that a little risk could preserve their equity so he wants to show the monthly payout of interest only on full balance with rates of 4% and 8%.

Excel: Use the standard TVM setup and calculate the pmt using the two different rates. Calculate the monthly income by multiplying the rate by the account balance for each different rate. Create a summary table show the four different methods, the rates and another column showing the balance after 30 years for each different method.

Written: Briefly describe the analysis that you have performed and explain the effect of compound interest on the payouts. What are the benefits of paying interest only and what are the risks? If this client were retiring in good health with a life expectancy of 40 years, and current income needs of $80,000 per year (not eligible for social security) which payout strategy would you recommend for these clients and why?

Reference no: EM131886292

Questions Cloud

What are the implied one-year forward rates : What are the implied one-year forward rates? Assume that only the expectations hypothesis explains the shape of the term structure.

Market value balance sheet for zetatron : Zetatron is an? all-equity firm with 300 million shares? outstanding, What is the market value balance sheet for Zetatron

What is the rate of return on investment : what is the rate of return (%) on the investment?

What is the bonds approximate yield to call : Trickle Corporation's bonds have a 12% coupon rate, $1,000 par, and mature in 25 years. What is the bonds' approximate yield to call?

Multiplying the rate by account balance for different rate : Calculate the monthly income by multiplying the rate by the account balance for each different rate.

What is new leasing company reservation price : What is Quartz’s reservation price? What is New Leasing Company’s reservation price?

Does dark pool trading in stock increasing market quality : Does dark pool trading in stock increasing the market quality? How it working? Appreciate how futures and options can be used by companies to reduce risk.

Calculate the duration of the bond : Given a one-year coupon-paying bond (semi-annual coupons) with face value of $100,000, Calculate the duration of the bond.

What is the expected rate of return on its shares : If Sime Natural Cosmetics is fairly priced in the marketplace, what is the expected rate of return on its shares?

User Account

All Pages