Download HW3 and create a Data Table as follows: Vary the interest rate from 3.25% to 7.00% by 0.25% What is the Loan Payment in scenario #2? (Enter two decimal places. Payments are considered negative values because they reduce the cash that you have) 1. 3.75% 2. 6.75% 3. 5.00% 4. 4.75% 5. 4.00% B D E 500 750 3.75 A 1 2 Down Payment 3 Miles per month 4 Price of Gas 5 6 7 Insurance 8 Cost 9 Registration (annual) 10 Loan Amount 11 Rate 12 Loan Term in Months 13 MPG 14 Loan Payment 15 Total Monthly Expenses 16 Total Cost over 4 years 17 =B16 0.0325 0.035 Car 1 35 6000 140 =88-$B$2 0.04 36 40 =PMT(B11/12,B12, B10) =B7+B9-B14+(B4*83)/813 -48 B15 18 Download HW3 and create a Data Table as follows: Vary the interest rate from 3.25% to 7.00% by 0.25% What is the Loan Payment in scenario #2? (Enter two decimal places. Payments are considered negative values because they reduce the cash that you have) 1. 3.75% 2. 6.75% 3. 5.00% 4. 4.75% 5. 4.00% B D E 500 750 3.75 A 1 2 Down Payment 3 Miles per month 4 Price of Gas 5 6 7 Insurance 8 Cost 9 Registration (annual) 10 Loan Amount 11 Rate 12 Loan Term in Months 13 MPG 14 Loan Payment 15 Total Monthly Expenses 16 Total Cost over 4 years 17 =B16 0.0325 0.035 Car 1 35 6000 140 =88-$B$2 0.04 36 40 =PMT(B11/12,B12, B10) =B7+B9-B14+(B4*83)/813 -48 B15 18