please show all steps if possible

1) In range G9:G11 enter a formula to calculate the down payment based on C3 and column F. If the value in C3:C6 or column F are changed the formula must still work. 2) In range H9:H115 enter a formula to calculate the balance due based on the amount in column F and the down payment in column G. If values in for C3:C6 are changed the formula must still work. 3) In I9:I115 enter a function to calculate the monthly payment based on the loan term, loan rate and balance. If values on the spread sheet change function must still work. The values in I9:I115 should be positive not negative.

In range G9 G115 enter a formula to calculate the down payment based on C3 and column F. If the value in C3:06 or column F are changed the formula must still work In range 115 enter a formula to calculate the balance due based on the amount in column F and the down payment in colum G. values in For C3 C6 are changed the formula mus In 19:1115 enter a function to caluate the monthly payment based on the loan term, loun rate and balance. If values on the spreadsheet change the funtion must still work. The values in 191115 should be positive not negative Reid Furniture Store Financing In range G9:G115 enter a formula to calculate the down 10% In range H9 H115 enter a formula to calculate the balance due based on the In 19:1115 enter a function to caluate the monthly payment based on the for The values in 19:1115 should be positive not negative. Required Down Payment: Loan Term in years: Loan Rate (annual rate) Payments per year 4 5.50% 12 Number Salesperson Date Department Type Amount Down Paymer Balance Monthly Payment 3/1/18 Bedroom 2018-001 Gruenewald Finance 2,788 2018-002 Gruenewald 3/1/18 Bedroom Finance 3,245 2018-003 Gallagher 3/1/18 Living Room Finance 10,000 3/1/18 Living Room Finance 1,000 Finance 2,750 2018-004 Gallagher 2018-005 Gallagher 2018-006 Sardelis 2018-006 Sardelis 2018-007 Gallagher 3/1/18 Appliances 3/1/18 Living Room Finance 12,000 3/1/18 Living Room Finance 12,000 3/1/18 Dining Room Finance 3,240 2018-008 Desmarais 3/1/18 Dining Room Finance 4,080 2018-009 Gruenewald 3/1/18 Appliances Finance 2,750 3/2/18 Dining Room Finance 6,780 Dining Room Finance 10,000 3/2/18 3/2/18 Appliances Finance. 1,100 Living Room Finance 2,430 3/3/18 3/3/18 Dining Room Finance 4,550 Living Room. Finance 6,784 3/3/18 3/4/18 Appliances Finance 640 3/4/18 Appliances Finance 8,490 2018-010 Gallagher 2018-011 Desmarais 2018-012 Sardelis 2018-013 Desmarais 2018-014 Gallagher 2018-015 Desmarais 2018-016 Gallagher 2018-017 Gallagher 2018-018 Gruenewald 2018-018 Gruenewald 2018-019 Gallagher 2018-020 Gallagher 2018-021 Gallagher 2018-022 Sardelis 2018-023 Gallagher 2018-024 Gallagher 2018-025 Gallagher 2018-026 Gruenewald 3/4/18 Appliances Finance 6,780 3/4/18 Appliances Finance 6,780 3/5/18 Living Room Finance 2,500 3/5/18 Living Room Finance 950 3/5/18 Dining Room Finance 425 3/6/18 Dining Room Finance 10,000 Finance 3/6/18 Living Room 3/6/18 Dining Room 1,732 Finance 8,560 3/7/18 Dining Room Finance 3,240 3/7/18 Living Room Finance 7,690 2018.027 Desmarais 3/9/18 Dining Room Finance 5.000 D F ( E A C Name Box Reid Furniture Store Financing In range G9:G115 enter a formula In range H9:H115 enter a formula to c In 19:1115 enter a function to caluate The values in 19:1115 should be positi 10% Required Down Payment: Loan Term in years: 4 5.50% Loan Rate (annual rate) Paynts per year 12 Amount Down Pay Date Type Department 3/1/18 Bedroom Finance 2,788 Number Salesperson 2018-001 Gruenewald 10 2018-002 Gruenewald 1 2018-003 Gallagher 2 2018-004 Gallagher 3/1/18 Bedroom Finance 3,245 3/1/18 Living Room Finance 10,000 3/1/18 Living Room Finance 1,000 3 2018-005 Gallagher 3/1/18 Appliances Finance 2,750 4 2018-006 Sardelis 3/1/18 Living Room Finance 12,000 3/1/18 Living Room Finance 12,000 15 2018-006 Sardelis 6 2018-007 3/1/18 Dining Room Finance 3,240 Gallagher Desmarais 17 2018-008 3/1/18 Dining Room Finance 4,080 18 2018-009 Gruenewald 3/1/18 Appliances Finance 2,750 19 2018-010 Gallagher 3/2/18 Dining Room Finance 6.780 20 2018-011 Desmarais 3/2/18 Dining Room Finance 10,000 21 2018-012 Sardelis 3/2/18 Appliances Finance 1,100 22 2018-013 Desmarais 3/3/18 Living Room Finance 2,430 23 2018-014 Gallagher 3/3/18 Dining Room Finance 4,550 3/3/18 Living Room Finance 6,784 3/4/18 Appliances Finance 640 8,490 24 2018-015 Desmarais 25 2018-016 Gallagher 26 2018-017 Gallagher 27 2018-018 Gruenewald 28 2018-018 Gruenewald 29 2018-019 Gallagher 30 2018-020 Gallagher 3/4/18 Appliances Finance 3/4/18 Appliances Finance 6,780 Appliances Finance 6,780 3/4/18 3/5/18 Living Room Finance 2,500 3/5/18 Living Room Finance 950 31 2018-021 Gallagher 3/5/18 Dining Room Finance 425 3/6/18 Dining Room Finance 10,000 3/6/18 Living Room Finance 1,732 32 2018-022 Sardelis 33 2018-023 Gallagher Gallagher 35 2018-025 Gallagher 34 2018-024 3/6/18 Dining Room Finance 8,560 3/7/18 Dining Room Finance 3,240 36 2018-026 Gruenewald 3/7/18 Living Room Finance 7,690 37 2018-027 Dasmarais 3/8/18 Dining Room Finance 5.000 In range G9 G115 enter a formula to calculate the down payment based on C3 and column F. If the value in C3:06 or column F are changed the formula must still work In range 115 enter a formula to calculate the balance due based on the amount in column F and the down payment in colum G. values in For C3 C6 are changed the formula mus In 19:1115 enter a function to caluate the monthly payment based on the loan term, loun rate and balance. If values on the spreadsheet change the funtion must still work. The values in 191115 should be positive not negative Reid Furniture Store Financing In range G9:G115 enter a formula to calculate the down 10% In range H9 H115 enter a formula to calculate the balance due based on the In 19:1115 enter a function to caluate the monthly payment based on the for The values in 19:1115 should be positive not negative. Required Down Payment: Loan Term in years: Loan Rate (annual rate) Payments per year 4 5.50% 12 Number Salesperson Date Department Type Amount Down Paymer Balance Monthly Payment 3/1/18 Bedroom 2018-001 Gruenewald Finance 2,788 2018-002 Gruenewald 3/1/18 Bedroom Finance 3,245 2018-003 Gallagher 3/1/18 Living Room Finance 10,000 3/1/18 Living Room Finance 1,000 Finance 2,750 2018-004 Gallagher 2018-005 Gallagher 2018-006 Sardelis 2018-006 Sardelis 2018-007 Gallagher 3/1/18 Appliances 3/1/18 Living Room Finance 12,000 3/1/18 Living Room Finance 12,000 3/1/18 Dining Room Finance 3,240 2018-008 Desmarais 3/1/18 Dining Room Finance 4,080 2018-009 Gruenewald 3/1/18 Appliances Finance 2,750 3/2/18 Dining Room Finance 6,780 Dining Room Finance 10,000 3/2/18 3/2/18 Appliances Finance. 1,100 Living Room Finance 2,430 3/3/18 3/3/18 Dining Room Finance 4,550 Living Room. Finance 6,784 3/3/18 3/4/18 Appliances Finance 640 3/4/18 Appliances Finance 8,490 2018-010 Gallagher 2018-011 Desmarais 2018-012 Sardelis 2018-013 Desmarais 2018-014 Gallagher 2018-015 Desmarais 2018-016 Gallagher 2018-017 Gallagher 2018-018 Gruenewald 2018-018 Gruenewald 2018-019 Gallagher 2018-020 Gallagher 2018-021 Gallagher 2018-022 Sardelis 2018-023 Gallagher 2018-024 Gallagher 2018-025 Gallagher 2018-026 Gruenewald 3/4/18 Appliances Finance 6,780 3/4/18 Appliances Finance 6,780 3/5/18 Living Room Finance 2,500 3/5/18 Living Room Finance 950 3/5/18 Dining Room Finance 425 3/6/18 Dining Room Finance 10,000 Finance 3/6/18 Living Room 3/6/18 Dining Room 1,732 Finance 8,560 3/7/18 Dining Room Finance 3,240 3/7/18 Living Room Finance 7,690 2018.027 Desmarais 3/9/18 Dining Room Finance 5.000 D F ( E A C Name Box Reid Furniture Store Financing In range G9:G115 enter a formula In range H9:H115 enter a formula to c In 19:1115 enter a function to caluate The values in 19:1115 should be positi 10% Required Down Payment: Loan Term in years: 4 5.50% Loan Rate (annual rate) Paynts per year 12 Amount Down Pay Date Type Department 3/1/18 Bedroom Finance 2,788 Number Salesperson 2018-001 Gruenewald 10 2018-002 Gruenewald 1 2018-003 Gallagher 2 2018-004 Gallagher 3/1/18 Bedroom Finance 3,245 3/1/18 Living Room Finance 10,000 3/1/18 Living Room Finance 1,000 3 2018-005 Gallagher 3/1/18 Appliances Finance 2,750 4 2018-006 Sardelis 3/1/18 Living Room Finance 12,000 3/1/18 Living Room Finance 12,000 15 2018-006 Sardelis 6 2018-007 3/1/18 Dining Room Finance 3,240 Gallagher Desmarais 17 2018-008 3/1/18 Dining Room Finance 4,080 18 2018-009 Gruenewald 3/1/18 Appliances Finance 2,750 19 2018-010 Gallagher 3/2/18 Dining Room Finance 6.780 20 2018-011 Desmarais 3/2/18 Dining Room Finance 10,000 21 2018-012 Sardelis 3/2/18 Appliances Finance 1,100 22 2018-013 Desmarais 3/3/18 Living Room Finance 2,430 23 2018-014 Gallagher 3/3/18 Dining Room Finance 4,550 3/3/18 Living Room Finance 6,784 3/4/18 Appliances Finance 640 8,490 24 2018-015 Desmarais 25 2018-016 Gallagher 26 2018-017 Gallagher 27 2018-018 Gruenewald 28 2018-018 Gruenewald 29 2018-019 Gallagher 30 2018-020 Gallagher 3/4/18 Appliances Finance 3/4/18 Appliances Finance 6,780 Appliances Finance 6,780 3/4/18 3/5/18 Living Room Finance 2,500 3/5/18 Living Room Finance 950 31 2018-021 Gallagher 3/5/18 Dining Room Finance 425 3/6/18 Dining Room Finance 10,000 3/6/18 Living Room Finance 1,732 32 2018-022 Sardelis 33 2018-023 Gallagher Gallagher 35 2018-025 Gallagher 34 2018-024 3/6/18 Dining Room Finance 8,560 3/7/18 Dining Room Finance 3,240 36 2018-026 Gruenewald 3/7/18 Living Room Finance 7,690 37 2018-027 Dasmarais 3/8/18 Dining Room Finance 5.000