Use Excel to calculate these:

4. (20 points) You are given the following information of two proposals of financing programs for your home loan. Suppose the new house costs you $650,000 (sales taxes and others are included). One program is asking you to deposit a 20% down payment on the $650,000 and it provides you with 5.5% interest rate for 15-year monthly payments of the remaining balance, the other program is a 100% financing program which gives you a 2.5% for the first 5 year with the balloon payment as $600,000 plus the PMI (property mortgage insurance) as $200 per month and the rate increases to 6.75% afterward for a 30-year mortgage if no balloon payment for the remaining balance is paid. Let there be no prepayment penalty. That is, you may pay off the loan should you have some extra cash later. The brokerage fees and commissions are already considered in all the numbers given. Answer the following questions.

a) What is the monthly payment for each program in the first 5 years? Which one is more favorable to you if your monthly income is $6,000 before tax? (Notice that most lenders will require the borrower to have ratio between mortgage payment and monthly income no greater than 33%).

b) Suppose 4 years later, the market price of your house is $800,000. The tax rate on gains/losses on house sales is 8%. Will you consider selling this house and buying a bigger one if your income has increased to $7000 per month? What is the annualized rate of return in your investment on housing? (Hint: you need to apply amortization of loan here first).

c) Which way of financing the house originally gives you a higher rate of return if you in fact, sell the house?