Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Excel please ( if you show the formulas) You are given with the following information of two proposal of financing programs for your home loan.

Excel please ( if you show the formulas)

  1. You are given with the following information of two proposal 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 or refinancing is pursued. Let there be no prepayment penalty. That is, you may pay off the loan should you have some extra cash later on. The brokerage fees and commissions are already considered in all the numbers given. Answer the following questions.
  2. 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%).
  3. 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 buy a bigger one if your income has gained 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).
  4. c) Which way of financing the house originally gives you more rate of return if you in fact, sell the house?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Dividend Policy On Share Price Volatility In Indian Stock Market

Authors: Vijay Deswal

1st Edition

3841859623, 978-3841859624

More Books

Students also viewed these Finance questions