.

Recall the \"Compact Excavator Leasing by the City of Saskatoon\" of Session 8. The best offer was from Earthworks Equipment Corporation of Saskatoon for Kubota KX040-4. The monthly lease payment is $1,076 for a 3-year lease and the buyout at the end of year 3 is $35,585. The City department manager is wondering what annual lease rate Earthworks is charging. He has investigated the price of a new KX040-4 and it is $71,081. Calculate the annual lease rate. Show your work Hint: Use Excel's Goal Seek (in Data tab, then What-if Analysis) and PMT function. Upload your Excel workbook (containing this problem and Problem 3, each on a separate worksheet), together with this Word le (for problems 2 and 4) before the due time and date