Reference no: EM133005971

Question - Joe and Lauren have decided to buy a house for $279,000. They will make a 20% down payment, and they expect to be approved for a 30-year mortgage with an interest rate of 3.75%. Find their monthly payment.

-Construct the first row of the amortization table for their mortgage.

-How much of their first payment goes toward interest?

-How much of their first payment goes toward principal?

-After making their first payment, what is the remaining balance?

-Construct the second row of the amortization table for their mortgage.

-How much of their second payment goes toward interest?

-How much of their second payment goes toward principal?

-After making their second payment, what is the remaining balance?

-Continue constructing the amortization table for their mortgage until you have completed 12 rows of the table. What is the total amount of interest that Joe and Lauren will pay on their mortgage in the first year?

-For the house that Joe and Lauren have chosen, the annual property taxes are $3,441, and their homeowners insurance premium is $1,128 per year. Since they will make a 20% down payment, they do not have to pay PMI. Find their total PITI.

-Do Joe and Lauren pass the 28% and 36% tests to qualify for a mortgage? Recall that Joe and Lauren have a car loan and a student loan from Part 1 of the project. Use their salaries given in Part 2 of the project. Show all of your calculations to justify your answers.