COSC 1301: Excel 2 - Housing

Use a PMT function to calculate the first client’s monthly payment in cell . J5. (Note that the value in . B3 . is an annual rate and must be converted to a monthly rate for use in the PMT function), using appropriate relative and absolute cell references. Monthly payments are based on a 1-year term. ................
................