You purchase a house that costs $625,000 with an 8%, 30-year mortgage. You make a 20%...

You purchase a house that costs $625,000 with an 8%, 30-year mortgage. You make a 20% down payment to avoid PMI insurance. 1. What is your monthly payment? 2. Amortize the first and second payments. 3. What is the mortgage balance after 5 years? 4. What percentage of the principal is paid off after 5 years? 5. Suppose after 5 years you refinance at 6% the remaining balance at a cost of $10,000, for 30 years. What is your new monthly payment? 6. Further, suppose you maintain the same payments as in (1), i.e. pre-pay on the principal, how many YEARS until you payoff the mortgage? show work please

Expert Solution

SEE IMAGES

WE TAKE GREAT CARE IN PROVIDING SOLUTIONS TO YOU. BUT OCCASSIONALLY MISTAKES CAN HAPPEN.

SO IF THAT HAPPENS, LET US KNOW, WILL CORRECT IT.

ANY DOUBTS, FEEL FREE TO ASK. HAPPY TO HELP YOU

jeff jeffy answered 2 years ago

Mortgage Analysis You are planning to purchase a house that costs $480,000. You plan to put 20%...

Mortgage Analysis You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.99% on a 30-year mortgage. Use function “PMT” to calculate your mortgage payment. Use function “PV” to calculate the loan amount given a payment of $1700 per month. What is the most that you can borrow? Use function “RATE” to calculate the interest rate given a payment of...

7. In order to purchase a house, you have taken out a 30 year mortgage of...

7. In order to purchase a house, you have taken out a 30 year mortgage of $200,000 at 4.29% interest per year. You make payments at the end of every month. What is the amount of each monthly payment?Refer to question 7. Using Excel, prepare an amortization table for the mortgage. Obtain the results for the first fifteen periods and include the results with your completed assignment. On the same page, show the overall sums for the relevant columns over...

Amortize a 30-year mortgage for a $200,000 house cost with a 20% down payment. The mortgage...

Amortize a 30-year mortgage for a $200,000 house cost with a 20% down payment. The mortgage interest rate is 4.125%. How much is the monthly payment? How much will the borrower pay in total interest?

Loan 3: 15-year versus 30-year mortgage Amortize a mortgage for a $225,000 house with a 20%...

Loan 3: 15-year versus 30-year mortgage Amortize a mortgage for a $225,000 house with a 20% down payment for both a 15-year mortgage at 3.625% and a 30-year mortgage at 4.125%. 15-year mortgage monthly payment? What is the total interest cost over the life of the 15-year loan? 30-year mortgage monthly payment? What is the total interest cost over the life of the 30-year loan? Difference in interest costs between a 15-year and a 30-year mortgage?

Suppose you take out a 30-year mortgage for a house that costs $496,845. Assume the following:...

Suppose you take out a 30-year mortgage for a house that costs $496,845. Assume the following: The annual interest rate on the mortgage is 3.9%. The bank requires a minimum down payment of 16% at the time of the loan. The annual property tax is 2.1% of the cost of the house. The annual homeowner's insurance is 0.6% of the cost of the house. There is no PMI If you make the minimum down payment, what will your monthly PITI...

Suppose you take out a 20-year mortgage for a house that costs $394818. Assume the following:...

Suppose you take out a 20-year mortgage for a house that costs $394818. Assume the following: The annual interest rate on the mortgage is 5%. The bank requires a minimum down payment of 10% at the time of the loan. The annual property tax is 2% of the cost of the house. The annual homeowner's insurance is 0.9% of the cost of the house. The monthly PMI is $54 Your other long-term debts require payments of $566 per month. If...

Suppose you take out a 20-year mortgage for a house that costs $264,857. Assume the following:...

Suppose you take out a 20-year mortgage for a house that costs $264,857. Assume the following: The annual interest rate on the mortgage is 3%. The bank requires a minimum down payment of 11% at the time of the loan. The annual property tax is 2.5% of the cost of the house. The annual homeowner's insurance is 0.9% of the cost of the house. The monthly PMI is $87 Your other long-term debts require payments of $624 per month. If...

Suppose you take out a 20-year mortgage for a house that costs $386,150. Assume the following:...

Suppose you take out a 20-year mortgage for a house that costs $386,150. Assume the following: The annual interest rate on the mortgage is 3%. The bank requires a minimum down payment of 19% at the time of the loan. The annual property tax is 2.1% of the cost of the house. The annual homeowner's insurance is 0.6% of the cost of the house. The monthly PMI is $54 Your other long-term debts require payments of $555 per month. If...

Suppose you take out a 20-year mortgage for a house that costs $332,294. Assume the following:...

Suppose you take out a 20-year mortgage for a house that costs $332,294. Assume the following: The annual interest rate on the mortgage is 4%. The bank requires a minimum down payment of 18% at the time of the loan. The annual property tax is 1.6% of the cost of the house. The annual homeowner's insurance is 0.7% of the cost of the house. The monthly PMI is $70 Your other long-term debts require payments of $937 per month. If...

You plan to purchase a house for $115,000 using a 30-year mortgage obtained from your local...

You plan to purchase a house for $115,000 using a 30-year mortgage obtained from your local bank. You will make a down payment of 20 percent of the purchase price. You will not pay off the mortgage early. (LG 7-3) a. Your bank offers you the following two options for payment: Option 1: Mortgage rate of 9 percent and zero points. Option 2: Mortgage rate of 8.85 percent and 2 points. Which option should you choose? b. Your bank offers...

Question