Please Provide Step by Step by step insructions and the formulas used.

H11 D G B E 5 Rate 0.05 6 7 Term (years) 15 8 9 Max Payment 1800 10 11 Loan Value Payment 12 $ 150,000 13 S 175,000 14 $ 200,000 15 $ 225,000 16 $ 250,000 17 S 275,000 18 $ 300,000 19 $ 325,000 20 S 350,000 21 $ 375,000 22 S 400,000 23 24 25 1. In range C12:022 input a function which will calculate a monthly payment based on the rate in C5, 26 the term in C7 and the loan value in range B12:B22. Set the payment so that it shows as a positive number 27 2. Set the worksheet so that the gridlines do not display. 28 3. Format the cell borders as shown. 29 4. Set the range C12:C22 so that the text and fill colors are dark green/light green if the value is below C9 30 and dark red/light red if the value is above C9. The colors must update when the numbers change. 31. 5. Format cells C5, C10 and C12:022 as shown (currency or % with the show number of decimal places). Instructions Problem 1 Problem 2 Problem 3 + Calculation Mode: Automatic Workbook Statistics Type here to search O BI enovo