Answer all subpart. Vanna has just financed the purchase of a home for $ XXXXXXXXXXShe agreed to repay the loan by making equal monthly blended payments of $3000 each at 4%/a compounded monthly....

Answer all subpart.

Vanna has just financed the purchase of a home for $200 000.She agreed to repay the loan by making equal monthly blended payments of $3000 each at 4%/a compounded monthly.

a.Create an amortization table using a Microsott Excel spreadsheet.In your answer include all the formulas used.

b.How long will it take to repay the loan? c.How much will be the final payment? d.Determine how much interest she will pay for her loan.