Calculate the pmt using the two different rates

Assignment Help Financial Management

Reference no: EM131147091

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: EM131147091

Questions Cloud

Interactions between humans and the hydrologic cycle : List at least three specific examples of interactions between humans and the hydrologic cycle. Briefly describe the consequences of each of these interactions

What role would social workers play in the administration : What social and economic forces would influence this? What role would social workers play in the administration and organization of such an agency system?

Calculate departures and latitudes : Using the mean radius of the Earth of 6,371,000 m, reduce the observations to grid and adjust the traverse using the compass rule. Assume that the azimuths given in Problem 10.21 are grid azimuths. Compare this solution with that obtained in Probl..

Can a competitor get a copy of the grant from the nih : Federal grants for medical research are very competitive. Scientists requesting federal grant money must submit a detailed proposal, including previous work in the area, Can a competitor get a copy of the grant from the NIH

Calculate the pmt using the two different rates : alculate the pmt using the two different rates. - Calculate the monthly income by multiplying the rate by the account balance for each different rate.

Calculate grid lengths for the traverse lines : If station A has SPCS83 state plane coordinates E = 634,728.082 m and N = 384,245.908 m, balance the departures and latitudes computed in Problem 20.30 using the compass rule, and determine SPCS83 coordinates of stations B and C.

Compute the budgeted cash receipts : Assume 20% of Turks's sales are for cash. The remaining 80% are credit sales;- Compute the budgeted cash receipts for June.

Analyze finance and value creation arguments : Analyze finance and value creation arguments. - Analyze finance and value creation facts and data.- Analyze validity of finance and value creation arguments.

Explain which of the four components of gdp had : In view of the weak economy of the last several years, explain which of the four components of GDP had, or is having, the greatest positive impact in our economy. Use the following historical tables to support your response.

User Account

All Pages