Calculate the total cost of financing your home purchase

Assignment Help Financial Management

Reference no: EM132005957

You are planning to purchase a house that costs $747,500. You plan to put 20% down and borrow the remainder. You have been pre-approved, based on your credit score and income, for a 30-year loan with an interest rate of 4.03%.

Please provide excel formulas

1. Use function “PV” to calculate the loan amount given a payment of $2900 per month. What is the most that you can borrow?

2. Use function “PMT” to calculate your mortgage payment.

3. Assume that you plan to pay an extra $500 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.03%). Calculate how much interest you will pay in total. Compare this to the total interest 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 my house. Because you are only putting 10% down, lenders require that you purchase private mortgage insurance (PMI). Assume that your annual PMI premium is .52% of the mortgage amount. Divide this by 12 to get the monthly payment. Use Excel for all calculations.

4. Calculate your total monthly payment (mortgage payment plus PMI). (The mortgage amount will be 90% of the price of the home.)

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

4b) Assume that you can stop paying mortgage insurance after 8 years given that the value of your house will appreciate and the balance of your mortgage will decrease. Calculate the total cost of the home purchase. (Down payment plus principle (loan amount) plus interest plus PMI.)

Reference no: EM132005957

Questions Cloud

Predicted by the duration-with-convexity rule : What price would be predicted by the duration-with-convexity rule?

What is the present value and duration of your obligation : What is the present value and duration of your obligation? What is the duration of a zero-coupon bond that would immunize your obligation

What is the present value of growth opportunities : Next year's earnings are estimated to be $3. what is the present value of growth opportunities?

Expected return or the cost of equity capital for the firm : calculate the expected return or the cost of equity capital for the firm.

Calculate the total cost of financing your home purchase : Calculate your total monthly payment (mortgage payment plus PMI). Calculate the total cost of financing your home purchase (interest plus PMI).

Difference between sterilized and nonsterilized intervention : What is the difference between sterilized and nonsterilized intervention?

The ytm on bond is the interest rate : The YTM on a bond is the interest rate you earn on your investment if interest rates don’t change.

Amount must you deposit each year to achieve your goal : What real amount must you deposit each year to achieve your goal?

What rate would you expect to see on treasury bill : What rate would you expect to see on a Treasury bill?

User Account

All Pages