Create the spreadsheet model shown in this picture Dynamic Loan Calculation Model with Prepayment in Excel 150,000 Loan Amount Interest Rate Number of Years E8 12 10 Number of Months Interest Rate/Month 0.6 nE7/12 12 13 14 15 Monthly Loan Payment $1,100.64___ -PMT (E1r, E 10, E6, o) Excel Spreadsheet Dynamic Model Example of a Simple Loan 17 A 5100 Prepayment every Month-Loan is paid off in Month 270 19$C320 824 24 $100.00 Total Principle 22Month Payment Amount PaymenOwed 21 $150,000 23 24 149,799E23 (1 SE$11)-024 1 $1,100.65 $100.00 $ 2 $1,100.65 $100.00 $1,200.65 s149,597 $1,100.65 $100.00 $1,200.65 $149,394 $1,100.65 $100.00 $1,200.65$149,189 5 $1,100.65 $100.00 $1,200.65$148,983 26 27 Copy the Cells in Row 24 into Rows 25 through Row 383 to get 360 Months of Results QUESTION 2 What is the effect to the monthly loan payment of a change in the interest rate from 8% to 10%? Increase or decrease to