The only part I am stuck on is the two tables multi-colored. Excel formula needed. Thank you.

House Price $350,000 Term 30 Rate 2.875% % of Downpayment 20% Monthly Payment $70,000 What is monthly payment? (S12 104.92 a) How much do you owe to bank by end of 19th month? b) How much of the 20th monthly payment is used to reduce principle? c) How much of the 20th monthly payment is used to pay interest payment? Fill in Table 2. I need to see excel functions you use to get all Replicate numbers. Only copying numbers from your calculator carn no points Insert a chart to Replicate Figure 1 Insert a chart to Replicate Figure 2 Ofreshmenth payment For interest For Principle Month Starting Principle Outreach enthly at For Interest (56) For Principle (6) Ending Principle 33 Amortization Table Ready 27 A Conditional Format Cell Formatting as Table Styles 22 Delete Format Y O V Sort & Filter Find & Select M P 5 60 10 120 15 180 20 240 30 25 300 Year Month 360 Reduce principal (Accumulative) Reduce principal (Incremental every 5 years) Pay Interest (Accumulative) Pay Interest (Incremental every 5 years % of interest V.S. % of principle (Ist month to last month) 100 Soon 50