PLEASE SHOW WHAT TO PUT FOR EACH OF THE YELLOW CELLS! THANK YOU

Instructions: - Given the values in the assumptions area, key formulas, including one using the PMT function (in cell B19), to calculate the monthly repayment amount that would need to be sent to the bank in order to pay off a car loan and the other indicated amounts. - General guideline: Only key calculations in the cells that are colored yellow. Do not perform any calculations outside the yellow cells. - To do what-if analysis, you can vary the down payment account, term, and repayments per year, and note the effect on the Total Cost of car (cell b22) - see the next worksheet.

Instructions: - Given the values in the assumptions area, key formulas, including one using the PMT function (in cell B19), to calculate the monthly repayment amount that would need to be sent to the bank in order to pay off a car loan and the other indicated amounts. General guideline: Only key calculations in the cells that are colored yellow. Do not perform any calculations outside the yellow cells. - To do what-if analysis, you can vary the down payment account, term, and repayments per year, and note the effect on the Total Cost of car (cell b22) - see the next worksheet. Delta Bank $ $ Assumptions Area Cost of Car* Down payment amount APR (annual interest rate) Term of loan (years) Repayments per year *Includes taxes, etc. 20,780.00