1. In range C11:C21 input a function which will calculate a monthly payment based on the rate in C4, the term in C6 and the loan value in range B11:B21. Set the payment so that it shows as a positive number. 2. Set the worksheet so that the gridlines do not display. 3. Format the cell borders as shown. 4. Set the range C11:C21 so that the text and fill colors are dark green/light green if the value is below C8 and dark red/light red if the value is above C8. The colors must update when the numbers change. 5. Format cells C8 and C11:C21 as currency and C4 as %. The result should look as shown below: