Calculate the monthly income by multiplying rate

Assignment Help Financial Management

Reference no: EM131325092

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.

Reference no: EM131325092

Questions Cloud

What was your dollar return on investment : You purchased 150 shares in ABC Ltd at the beginning of the year at a price of $75.15. During the year the company paid a dividend of $1.12 per share and the share price closed the year $67.87. What was your dollar return on investment?

Why do you suppose countries impose foreign exchange control : Why do you suppose countries impose foreign exchange controls?- Do you think that, long-term, foreign exchange controls will encourage or discourage inward foreign investment?

Create a resource chart and determine the constraints : American Motor Works produces SUVs and Trucks at the same plant. Each SUV requires 4 minutes on the body assembly line, 5 minutes in the paint booth, 8 minutes on the interior installation line and 3 minutes to install the luxury trim. The factory se..

What additional factors deserve consideration : What additional factors deserve consideration in multinational capital budgeting that may not normally be relevant for a purely domestic project?

Calculate the monthly income by multiplying rate : 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,..

Explain debt equity swaps and how they increase activity : List additional factors that deserve consideration in a foreign project analysis but are not relevant for a purely domestic project.

Rules of the diffusion of innovation : Consider Kotter's eight-stage model of change. How does it compare to Berwick's rules of the diffusion of innovation

How characteristics of mncs can affect the cost of capital : From an investor's standpoint, have small companies, in general over the past, been more profitable than their larger brethren?

What are the total costs–order costs plus carrying costs : Economic Order Quantity. Micro-Encapsulator Corp. (MEC) expects to sell 7,200 miniature home encapsulators this year. The cost of placing an order from its supplier is $250. Each unit costs $50 and carrying costs are 20% of the purchase price. (Pleas..

User Account

All Pages