How to solve on excel please

A B D E F G 1 2 3 Term 5 6 7 8 9 Q4- Given the following snapshot for "What-if" Analysis for car loan where the 4 buyer would have an interest rate option to take a Rebate (Discount). Value of interest rate depends on the loan term (number of years). Reproduce the car loan Analysis sheet using appropriate commands and structure. Rebate 1 8.90% 2 9.90% 3 10.90% 4 11.90% 5 12.90% 11 12 13 14 Create a check button (click developer; insert; checkbox) and link it to the value 10 of rebate. Locate this checkbox in the cell (K23)When checked should show 1000 (value of rebate) and when unchecked should show ZERO rebate Note: You MUST use of vlookup command as part of solution vote. YOU MUST use O VIOOkup Command as part of solution X Microsoft Excel - Carloan2.xls Fle Edi View Insert Form Tools Dola Window Help DEA 0/60 Efa 2140 X 1202 Arial 10 BIU Price 18000 G H Rebate Down Payment Trade-in Amount Financed 1000 2000 1500 13500 2 9.90% 3 10.90% 4 11.90% 5 12.90% 1 Annual Rate 8.90% Monthly Payment pmt Total Payment Finance Charge B C D E F 1 2 3 4 Purchase Price $18,000 5 less: 6 Rebate $ 1,000 7 Down Payment $ 2.000 8 Trade-In $ 1,500 9 Amount Financed $13,500 10 11 Term of Loan (in years) 12 1 2 3 4 5 13 Annual Finance Rate 9.9% 10.9% 11.9% 12.9% 14 Monthly Payment $1,180 $622 $441 $355 $306 15 Total Payments $14.160 $14,936 $15,888 $17.033 $18,389 16 Finance Charge $660 $1,436 $2,388 $3,533 $4,889 17 18 19 20 21 wa Car Loan Abalosis terest Reser 8.9% Shes She? A B D E F G 1 2 3 Term 5 6 7 8 9 Q4- Given the following snapshot for "What-if" Analysis for car loan where the 4 buyer would have an interest rate option to take a Rebate (Discount). Value of interest rate depends on the loan term (number of years). Reproduce the car loan Analysis sheet using appropriate commands and structure. Rebate 1 8.90% 2 9.90% 3 10.90% 4 11.90% 5 12.90% 11 12 13 14 Create a check button (click developer; insert; checkbox) and link it to the value 10 of rebate. Locate this checkbox in the cell (K23)When checked should show 1000 (value of rebate) and when unchecked should show ZERO rebate Note: You MUST use of vlookup command as part of solution vote. YOU MUST use O VIOOkup Command as part of solution X Microsoft Excel - Carloan2.xls Fle Edi View Insert Form Tools Dola Window Help DEA 0/60 Efa 2140 X 1202 Arial 10 BIU Price 18000 G H Rebate Down Payment Trade-in Amount Financed 1000 2000 1500 13500 2 9.90% 3 10.90% 4 11.90% 5 12.90% 1 Annual Rate 8.90% Monthly Payment pmt Total Payment Finance Charge B C D E F 1 2 3 4 Purchase Price $18,000 5 less: 6 Rebate $ 1,000 7 Down Payment $ 2.000 8 Trade-In $ 1,500 9 Amount Financed $13,500 10 11 Term of Loan (in years) 12 1 2 3 4 5 13 Annual Finance Rate 9.9% 10.9% 11.9% 12.9% 14 Monthly Payment $1,180 $622 $441 $355 $306 15 Total Payments $14.160 $14,936 $15,888 $17.033 $18,389 16 Finance Charge $660 $1,436 $2,388 $3,533 $4,889 17 18 19 20 21 wa Car Loan Abalosis terest Reser 8.9% Shes She