Mr. Richards has a client ready to retire. They have approximately, $1.5 million in an account with the firm. They are very conservative client and he want to gove 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 wit rates of 4% and 8%. Calculate the payment using the two difference 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 rate and another column showing the balance after 30 years for each method using excel.