On the MarketinaConsultants worksheet, a monthly loan payment analysis has been started. The resort is considering hiring marketing consultants. However, they require a large up-front retainer fee. The resort would need to take out a loan to cover the cost. The resort needs an analysis of the loan payment by varying interest rate and down payment amount. Think carefully about how to use mixed and absolute cell referencing. In cell D10, add a PMT function using the following arguments. -Calculate the monthly Rate from the annual rate in cell C10. - Calculate the number of monthly payments from the term in years in cell B5. - Calculate the present value of the loan by subsracting the down payment in cell D9 from the retainer amount in cell B4. -Adjust the formula so the result is positive. - Copy the function in cell D10 down to D13 and across to H13. GuestData AdvertisingPlan AdvertisingDiscount MarketingConsultants Reacr FR ficcesibity inkertigate