COSC 1301: Excel 2 - Housing

Copy both those formulas down their respective columns. Calculate the Monthly Payment. Most clients pay the remainder by making monthly payments for ONE year. Monthly payments are thus based on 12 months and the standard interest rate provided. Use a PMT function to calculate the first client’s monthly payment in cell . J5. (Note that the ... ................
................