Part II$-$B Assume that the home in Part I$-$B will be financed at $3\mathrm{.}75\%$ APR for a $30$ year mortgage.Find the monthly payment and create the payment schedule. Show this information like in Part II$-$A above, for payment numbers $1,12,60,120,240,360,$ and answer the following questions:$1.$ What is the total amount of principle paid for the $360$ payments?$2.$ What is the total amount of interest paid for the$360$ payments?$3.$ What is the total amount paid for the $360$ payments?$4.$ The total interest is what percent of the amount of the loan?$5.$ How does the total percent of interest paid for the truck loan compare to the total percent of interest paid for the mortgage?

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\mathrm{.}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 $H_{?}$ He$.$

$\backslash$table$[[4,$A$,$B$,$C$,$D$,$E$],[1,$house price,$$250,000\mathrm{.}00,,,],[2,$percent down,$20\mathrm{.}00\%,,,],[3,$APR,$1\mathrm{.}50\%,,,],[4,pm\frac{t}{y}r,12,,,1],[5,yr,3,,,],[6,,,,,],[7,$amount down,$$xx,xxx.xx,,,],[8,$amount Ioan,$$xxxx,xxxxxx,,,],[9,$monthly deposit,,,,$],[10.,,,,,],[11,$saving schedule,PMT #$,$$PMT$,$$INT,SBAL$],[12,,,,,],[13,,1,$$$x,xxx,,$$$,$$$xx,xxx.xx$