Please use spreadsheet software, like Google Sheets or Excel, to create the amortization table for a 15-year mortgage fo

[answerhappygod]

Please Use Spreadsheet Software Like Google Sheets Or Excel To Create The Amortization Table For A 15 Year Mortgage Fo 1 (35.22 KiB) Viewed 10 times

Please use spreadsheet software, like Google Sheets or Excel, to create the amortization table for a 15-year mortgage for $850,000 at 6.3% interest. Individual taxpayers may be able to deduct the amount of interest that they paid on a mortgage for a primary residence DURING A CALENDAR YEAR from their income taxes for that year. If the mortgage was issued on August 1, how much interest will be earned in the first year? How much interest will be earned in the second year? CLEARLY indicate on your spreadsheet the amount of interest for CALENDAR YEAR 1 and CALENDAR YEAR 2. If you use Google Sheets, please download or spreadsheet to your system as Excel file. Then, upload your Excel file to this assignment (below). OPPORTUNITY FOR EXTRA CREDIT: 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 CLEARLY include the graphs in your Excel worksheet. IMPORTANT: Please do not provide links to Google Sheets or submit spreadsheets from Pages. Please either work in Excel or convert your work to Excel and upload an Excel file to this assignment.