From the book, Succeeding in Business with Microsoft Excel 2013 - Chapter 6, Level 2 Case Problem (2CP).

Can someone please show how to solve this case? I have made a worksheet with the calculator and table requested in the question, but I do not feel confident with my answer or how to complete the rest of the case from there.

Mortgage Calculator Q Search Sheet Insert Page Layout FormulasData Review Vievw +Share , x Insert Delete Format- Calibri (Body), 12 , A- A, Wrap Text Currency - . s ._._ F Merge & Center $ %, .00+.0 Conditional Format Cell Formatting as Table Styles Sort Filter . 0 Final Loarn Annual Interest Rate 300,000 4.25% 25 12 an Duration In Years Number of Periods per Year Ending Value of Loan Monthly Payment 25,4BB.98 Period Number Remaining Princ 10 12 13 14 15 16 17 18 19 Calculator 100%