Question: pls help 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.

pls help
pls help Please use spreadsheet software, like Google Sheets or Excel, to

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!