Can you solve this using a excel spreadsheet..

Esume October 14. 2023 As per decisions made by the city council, the following increases for 2022 were agreed upon: On the revenue side. the city budget committee proposes the following increases: - an overall property tax increase of 2.7% which represents a weighted average of the following: 4.4% increase for residential properties [2.9% for inflation plus a 1.5% levy). 1.45% increase for commercial properties . 0.97% for industrial properties . and 0% increase for multi- residential/ apartment buildings as per provincial legislation, and some reductions in property tax for small business - a water rate increase of 3.0% - a solid waste rate increase of 3.0% - a Toronto Transit Commission (Conventional] fare increase by 5c per ride. from $3.25 to $3.30 for an adult Presto Fare a 2.11% increase for all other categories of revenue On the expense side, the city budget committee proposes to increase each expense category by an inarane nradisiad inflation rate of 1 17 ameant for tha fallawinn- Marl On the Case 5 work sheet, calculate the revenues and expenses for the neat year using the proposed increases in the case. 5 ALise the BONDAuction when cabvisting the 17Care increase. Round to ] decimals they Aowner as percentage showing / decimal) Properly design the work sheet to allow the user to easily change any assumption value. All 2022 cells should contain formulas containing cell references. At the TOP of the work sheet, calculate the sum of the projected revenues and expenses as well as the size of the surplus or deficit Format all values as Currency. What is the percent increase in the TTC Fare? Cell reference your answer into cell 06 on this worksheet. 2 What is the sum of the project revenues for 2022? Cell reference your answer into cell 07 on this work sheet. 3 What is the sum of the project expenses for 20227 Cell reference your answer into cell US on this work sheet What is the size of the deficit of surplus? Cell reference your answer into cell 09 on this work sheet. On the Task 2 work sheet, use Goal Seek to determine what overall property tax increase would be needed to balance next year's operating budget Assume the formula in cell C5 calculates the difference between the total revenues and the total expenses. Copy the Case 5 work sheet and rename it as Task 3. Using Solver, revise the Task 3 worksheet to incorporate your recommendations for balancing the budget if the TTC fare increase is canceled, "all other categories of revenue" and "all other categories of expenses" are allowed to increase subject to "all other categories of revenue" being not less than 2% Property tax, water, solid waste, police and public health assumptions remain unchanged.] After Solver what is the percent increase for "all other categories of revenue ? Cell reference your answer into cell 013 on this work cheer