File Home Insert Draw K7 fx A B Page Layout Formulas Data Review View Help D 1 Reid Furniture Store Financing E F G H K M N Comments Share 0 P In range G9:G115 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. In range H9:H115 enter a formula to calculate the balance due based on the amount in column F and the down payment in colum G. If values in F or C3:C6 are changed the formula must still work. In 19:1115 enter a function to caluate the monthly payment based on the loan term, loan rate and balance. If values on the spreadsheet change the funtion must still work. The values in 19:1115 should be positive not negative. 2 3 Required Down Payment: 10% 4 5.50% 12 4 Loan Term in years: 5 Loan Rate (annual rate) 6 Payments per year 7 8 Number Salesperson 17 2018-008 Desmarais 18 2018-009 Gruenewald 19 2018-010 Gallagher 20 2018-011 Desmarais 21 2018-012 Sardelis 22 2018-013 Desmarais 23 2018-014 Gallagher 24 2018-015 Desmarais 25 2018-016 Gallagher 26 2018-017 Gallagher 27 2018-018 Gruenewald 28 2018-018 Gruenewald 29 2018-019 Gallagher Date 3/1/2018 Dining Room 3/1/2018 Appliances 3/2/2018 Dining Room 3/2/2018 Dining Room 3/2/2018 Appliances Department Type Amount Down Paym Balance Monthly Payment Finance 4,080 Finance 2,750 Finance 6,780 Finance 10,000 Finance 1,100 3/3/2018 Living Room 3/3/2018 Dining Room Finance 2,430 Finance 4,550 3/3/2018 Living Room Finance 6,784 3/4/2018 Appliances 3/4/2018 Appliances Finance 640 Finance 8,490 30 2018-020 Gallagher 31 2018-021 Gallagher 32 2018-022 Sardelis 33 2018-023 Gallagher 3/4/2018 Appliances Finance 3/4/2018 Appliances 3/5/2018 Living Room 3/5/2018 Living Room 3/5/2018 Dining Room Finance 3/6/2018 Dining Room Finance 3/6/2018 Living Room Finance 6,780 Finance 6,780 Finance 2,500 Finance 950 425 10,000 1,732 34 2018-024 Gallagher 35 2018-025 Gallagher 36 2018-026 Gruenewald 37 2018-027 Desmarais Instructions 3/6/2018 Dining Room 3/7/2018 Dining Room 3/7/2018 Living Room 3/8/2018 Dining Room Problem 1 Problem 2 Finance 8,560 Finance 3,240 Finance Finance Problem 3 7,690 5,000 Ready Accessibility: Investigate ET 10