8 A Rate XVfx C D 0.05 Term (years) 15 Max Payment 1800 Loan Value Payment $ 150,000 $ 175,000 $ 200,000 $ 225,000 250,000 $ 275,000 $ 300,000 $ 325,000 $ 350,000 $ 375,000 $ 400,000 LLI E LL F Instructions Problem 1 Problem 2 Problem 3 + culation Mode. Automatic Workbook Statistics w " G H 1 J 1 in range C12C22 Input a function which will calculate a monthly payment based on the rate in CS, the term in C7 and the loan value in range 812:822. Set the payment so that it shows as a positive number. 2. Set the worksheet so that the gridlines do not display. H38 A 19 20 21 22 23 24 25 26 27 28 37 2 38 ARRNAZAARRASESBEARERS 30 5 X fx B 325,000 C D $ 350,000 $ 375,000 $ 400,000 3 Format the cell borders as shown. 29 30 4. Set the range C12:C22 so that the text and fill colors are dark green/light green if the value is below C and dark red/light red of the value is above CS The colors must update when the numbers change. 31 5. Format cells CS, C10 and C12C22 as shown (currency or % with the show number of decimal places). 32 33 The result should look as shown below. 34 35 36 D Instructions Problem 1 Problem 2 Problem 3+ Calculation Mode Automatic Workbook Status ab esc 2 + # 3 S 55 M hp 6