Calculate the total cost of the home purchase

Assignment Help Financial Management

Reference no: EM132075089

1. Electronic copy of your EXCEL spreadsheet and Memo.

a. You must email me a copy of your EXCEL spreadsheet and Memo before you hand in your hard copies.

b. Use the last name of one or more of your group members to name the excel file. For example: MusaGP1.xls

Mortgage Analysis

You are planning to purchase a house that costs $520,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 4.50% on a 30-year mortgage.

1. Use function "PMT" to calculate your mortgage payment.

2. Use function "PV" to calculate the loan amount given a payment of $1500 per month. What is the most that you can borrow?

3. Use function "RATE" to calculate the interest rate given a payment of $1500 and a loan amount of $400,000.

4. For each scenario, calculate the total interest that you will have paid once the mortgage is paid off. (There is not a function for this, enter the formula into the cell.)

5. For each scenario, calculate the total cost of the home purchase. (Down payment plus principle (loan amount) plus interest.)

6. Assume that you plan to pay an extra $300 per month on top of your mortgage payment, calculate how long it will take you to pay off the loan given the higher payment. (Use interest rate of 4.50%). Calculate how much interest you will pay in total? Compare this to the value that you calculated for #2.

You want to determine whether or not you should save some of your money and put only 10% down on your house. Because you are only putting 10% down, lenders require that you purchase private mortgage insurance (PMI). Assume that PMI is 1% of the mortgage amount.

7. Calculate your total monthly payment (mortgage payment plus PMI).

8. Calculate the total cost of financing your home purchase (interest plus PMI).

9. Calculate the total cost of the home purchase. (Down payment plus principle (loan amount) plus interest plus PMI.)

10. Compare this to the costs associated with a 20% down payment.

Reference no: EM132075089

Questions Cloud

Array large enough to hold a user-defined number of test : Can someone please show how this would be coded in C++ along with associated output. The example problem is as follows:

Scores and averages with appropriate headings : A program that dynamically allocates an array large enough to hold a user-defined number of test scores.

What is the expected return of your portfolio of homer : What is the expected return of your portfolio of Homer, Marge and Bart have expected returns of 3 per cent, 20 per cent and 5 per cent, respectively?

What is the overall tax rate on crocket pre tax income : Jimmy's marginal ordinary tax rate it 34% and his marginal tax rate on dividends is 15%. What is the overall tax rate on Crocket and Company's pre tax income

Calculate the total cost of the home purchase : Calculate the total cost of the home purchase. (Down payment plus principle (loan amount) plus interest plus PMI.)

How much of the value of the home : Lynn still owns the home as of the end of 2015 and has no plans to sell it. How much of the value of the home is included in her 2015 gross income

What premium should the futures contract have today : At each of these states (0, u, or d) is the market in contango or normal backwardation? What premium should the futures contract have today?

What is the bonds yield-to-maturity if a semiannual convert : Kerby manufacturing corporation sells a zero coupon bond for $38 with 8 years to maturity. At maturity the company will pay the bond's holder $100.

What is the primary purpose of the money markets : According to Holmstrom (2015), what is the primary purpose of the money markets and how is that purpose served by "over-collateralized" debt?

User Account

All Pages