“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Insert the PMT function in cell J5 to calculate the first clients monthly payment, using appropriate relative and absolute cell references. Copy the formula down the column.

Solved by V. B. in 19 mins

Enter a function in cell D12, based on the payment and loan details, that calculates the amount of interest paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references.

Solved by G. L. in 22 mins

Enter a function in cell G12, based on the payment and loan details, that calculates the amount of cumulative interest paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references.

Solved by B. J. in 13 mins

Edit the formula in cell O6 so that it uses relative references instead of absolute references for the range B6:M6, and then copy the formula from cell O6 to fill the range O7:O10 without formatting.

Solved by D. Y. in 21 mins

Use the VLOOKUP function in cell G11 to determine the insurance cost. Use the Value in cell E11 to lookup the appropriate cost on the "Insurance Cost" reference table (range K11:L18). Make sure to use relative and absolute references appropriately

Solved by I. D. in 27 mins