Part I-B Change the parameters in Part I-A to saving for a 20% down payment of a $250,000 home in 3 years when a 1.5% APR can be found. Find the amount of the down payment, the amount of the mortgage, and the monthly savings deposit. Although the complete schedule needs to be worked out on a spreadsheet, only payment numbers 1 (row 13), payment 12 (initially in row 24), payment 24 (initially in row 36), and payment 36 (initially in row 48) need to be shown. To hide the other payments 2-11 (initially in rows 14 - 23), payments 13 - 23, and payments 25 - 35 right clicking on the rows, and clicking Hide. D E E 12 A B 1 house price $ 250,000.00 2 percent down 20.00% 3 APR 1.50% 4 pmt/yr 5 yr 3 6 7 amount down $XX,XXX.XX 8 amount loan $XXX,XXX.XX 9 monthly deposit $X.XXX.XX 10 11 saving schedule PMT # 12 13 1 24 12 36 24 48 36 $ PMT SINT $ BAL 1 $X,XXX.XX $ $X,XXX.XX $X,XXX.XX $X,XXX.xx $XX,XXX.XX $X,XXX.xx $X,XXX.XX $XX,XXX.XX $X,XXX.XX $X,XXX.XX $XX,XXX.XX Answer the following questions on your spreadsheet. 1. How much money is deposited? 2. What is the total amount of interest is earned? 3. What percent of the amount deposited is the interest earned? (Write answer to four decimal places.) 4. How does the percent in #3 above compare to the APR? Explain. 5. How do the answers in #4 Part I-A and #4 in Part I-B compare? Explain