Please explain, Excel assignment. Prepare an amortization table for a 30-year mortgage where the homeowner is...

Please explain, Excel assignment.

Prepare an amortization table for a 30-year mortgage where the homeowner is borrowing $170,000 at a 3.75% interest rate. In addition to the monthly table, provide a summary table showing the interest paid, principal paid, and ending balance on a yearly basis. Create three separate graphs illustrating interest paid over time, principal paid over time, and ending balance over time for the 30 annual periods in the summary table.

Repeat the analysis, changing the interest rate to 8.75% and comment (briefly) on the impact of mortgage rates on home affordability.

Expert Solution

To find monthly payment, use excel function =PMT

To find principal payment, use excel function = PPMT

Interest = Monthly Payment - Principal Payment

Ending Balance = Previous Balance - Principal Paid

Calculate and plot as below -

When interest rate = 8.75%

jeff jeffy answered 4 months ago

Excel assignment Prepare an amortization table for a 30-year mortgage where the homeowner is borrowing $170,000...

Excel assignment Prepare an amortization table for a 30-year mortgage where the homeowner is borrowing $170,000 at a 3.75% interest rate. In addition to the monthly table, provide a summary table showing the interest paid, principal paid, and ending balance on a yearly basis. Create three separate graphs illustrating interest paid over time, principal paid over time, and ending balance over time for the 30 annual periods in the summary table. Repeat the analysis, changing the interest rate to 8.75%...

1) Prepare an amortization table for a 30-year mortgage where the homeowner is borrowing $170,000 at...

1) Prepare an amortization table for a 30-year mortgage where the homeowner is borrowing $170,000 at a 3.75% interest rate. In addition to the monthly table, provide a summary table showing the interest paid, principal paid, and ending balance on a yearly basis. Create three separate graphs illustrating interest paid over time, principal paid over time, and ending balance over time for the 30 annual periods in the summary table. 2) Repeat the analysis, changing the interest rate to 8.75%...

In Excel, create the amortization table for a 15-year mortgage for $780,000 at 6.6% interest. Individual...

In Excel, create the amortization table for a 15-year mortgage for $780,000 at 6.6% interest. Individual taxpayers may be able to deduct the amount of interest that they paid on a mortgage for a personal residence. If the mortgage was issued on July 1, how much interest will be earned in the first year? How much interest will be earned in the second year?

In Excel, create the amortization table for a 15-year mortgage for $950,000 at 4.2% interest. Individual...

In Excel, create the amortization table for a 15-year mortgage for $950,000 at 4.2% interest. Individual taxpayers may be able to deduct the amount of interest that they paid on a mortgage for a personal residence. If the mortgage was issued on May 1, how much interest will be earned in the first year? How much interest will be earned in the second year? Upload your Excel file below.

Your 30 year mortgage is $350,000 with an interest rate of 4%. Prepare the amortization schedule...

Your 30 year mortgage is $350,000 with an interest rate of 4%. Prepare the amortization schedule for repayment of the mortgage

Excel, create the amortization table for a 15-year mortgage for $950,000 at 4.2% interest. Individual taxpayers...

Excel, create the amortization table for a 15-year mortgage for $950,000 at 4.2% interest. Individual taxpayers may be able to deduct the amount of interest that they paid on a mortgage for a personal residence. If the mortgage was issued on May 1, how much interest will be earned in the first year? How much interest will be earned in the second year? Upload your Excel file below. I dont know how to create an ammortization in excel. It is...

On the third tab build the full amortization table for a 30 year Constant Payment Mortgage...

On the third tab build the full amortization table for a 30 year Constant Payment Mortgage (CPM) Loan with a 4.5% interest rate compounded monthly. The initial loan amount should be $2,500,000. in excel

A homeowner took out a 30-year, fixed-rate mortgage of $145,000. The mortgage was taken out 6...

A homeowner took out a 30-year, fixed-rate mortgage of $145,000. The mortgage was taken out 6 years ago at a rate of 8.4 percent. If the homeowner refinances, the charges will be $2,550. What is the highest interest rate at which it would be beneficial to refinance the mortgage? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)

A homeowner paid a fixed 3% on a 30-year mortgage of $200,000. 11a. Calculate the monthly...

A homeowner paid a fixed 3% on a 30-year mortgage of $200,000. 11a. Calculate the monthly mortgage payment. [10 points] 11b. Calculate the total interest payment over this 30-year period. [5 points] 11c. In the third monthly mortgage payment, calculate the interest payment. [5 points] 11d. In the fourth monthly mortgage payment, calculate the principal payment.

a homeowner can obtain 250,000, 30 year fixed mortgage at a rate of 6% with zero...

a homeowner can obtain 250,000, 30 year fixed mortgage at a rate of 6% with zero points or at a rate of 5.5% with 2.25 points. IF you will keep the mortgage for 30 years, what is the net present value of paying the points (to the nearest dollar)

Question