In Excel, create the amortization table for a 15-year mortgage for $800,000 at 8.7% interest. 1 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 April 1, how much interest will be earned in the first year? 100 points How much interest will be earned in the second year? Skipped Upload your Excel file below. OPPORTUNITY FOR EXTRA CREDIT: eBook Print 1. Create the graph of the Outstanding Principal Balance (should be declining) 2. Create the graph of the Structure of the Monthly Payments a. The interest portion should be declining b. The repayment of principal portion should be increasing References CLEARLY include the graphs in your Excel worksheet. In Excel, create the amortization table for a 15-year mortgage for $800,000 at 8.7% interest. 1 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 April 1, how much interest will be earned in the first year? 100 points How much interest will be earned in the second year? Skipped Upload your Excel file below. OPPORTUNITY FOR EXTRA CREDIT: eBook Print 1. Create the graph of the Outstanding Principal Balance (should be declining) 2. Create the graph of the Structure of the Monthly Payments a. The interest portion should be declining b. The repayment of principal portion should be increasing References CLEARLY include the graphs in your Excel worksheet