I need help with this project any help is greatly appreciated! Sorry for the multiple pictures. The last picture is the document I submit my answers in. Thanks!

The North Central Water Company has finalized its financial statements for the 2021 financial year. The Company's board of directors has asked you, their cost accountant, to look at the financial results and to compare the financial performance for the 2021 fiscal year to the results of the 2020 financial year. The board would also like you to project the revenues and expenses for the 2022 financial year based on several key assumptions. They have asked you to submit an excel file containing the financial results and budget projections as well as a one page memorandum of your findings. Financial Results Total Number of Customers 24,750 23,150 2021 % of Total Revenues % of Total Revenues 2020 Revenues Water Sales Late Fees Fire Hydrant Fees Total Revenues $1,148,000 2 $ 1.192,000 2 71,020 2 64,825 ? 123,050 2 121 273 ? $1,342,070 100% $1,378,100 100% DA Expenses: Cost of Water Sold $618,000 ? $567,000 ? 512,000 2 478,125 ? 198,215 ? 278,000 ? Payroll Expense Overhead Expense Miscellaneous Expenses Total Expenses Net Income (Loss) ? ? 64.515 $1,392,730 72,369 $1,395,494 ? ? ? I. Excel Analysis (Please submit your answers with the excel file provided for you in Ilearn entitled North Central Financial Results- Student Copy. Based on the financial results provided above, complete the excel spreadsheet file provided to you and submit your file in Ilearn. Please include include your name in the filename. You must use formulas in the excel spreadsheet rather typing-in calculated numbers to get full credit. You will also run into rounding errors unless you use formulas. Some formulas and calculated numbers have already been included in the spreadsheet to help you. YOU SHOULD HAVE AN ANSWER WHEREVER YOU SEE A QUESTION MARK (?). Required: 1. Calculate each revenue and expense item as a percentage of total revenues in 2021 and 2020 (show percentages out to TWO decimal places for all revenues and expenses, but round total revenue's percentage to ZERO decimal places- see examples in spreadsheet) 2. Calculate the water sales per customer for 2021 and 2020 (show number out to TWO decimal places- see example in spreadsheet). 3. Calculate the company's budgeted amounts for 2022 based on the assumptions listed below for each revenue and expense item. Then calculate each item as a percentage of total revenues just like you did for 2021 and 2020. Then calculate the water sales per customer for 2022 just as you did for 2021 and 2020- see examples in spreadsheet 4. Finally, calculate the differences in each revenue and expense item between 2022 and 2021 and 2021 and 2020 sec example in spreadsheet. This will provide you with some insight about the year-to-year changes and help you with your business memo which is the second part of this project 2022 BUDGET ASSUMPTIONS: Assume that the water company expects that in 2022: a. The number of customers will increase by 6% because of out of an upsurge in out-of-state people moving into the area. b. Water sales will increase by 8% and late fee income will increase by 6.5% because of the upsurge in new customers. c. Hydrant fee income will increase slightly by 2% as the company begins to install new fire hydrants to service new residential neighborhoods under construction. d. The cost of water sales will increase by 3% because of higher chemical costs. e. Payroll expenses will increase by 2.5% because of wage increases and higher medical insurance expenses. f. Overhead expense will increase by 2% to cover protective mask costs for customer service personnel. g. Miscellaneous expenses are expected to decrease by 3% because employees will no longer have to travel to the annual water company convention, because of Covid restrictions, and will instead attend using Zoom. Here are some check figures to help you out: 2022 Total Revenue=1,440,987 2022 Total Expense=1,426,099 Total Income loss> 2022 vs 2021= 65,548 Total Income closs> 2021 vs 2020= $33,266> Total Income loss as a percentage of total revenue in 2022=1.03% Total Income loss as a percentage of total revenue in 2021= - 3.77% II. Business Memo: In the second part of project, you will need to write a small memo detailing the difference in the financial results between 2021 and 2020. To complete this part of the project, download and open the word file called "North Central Business Memo" and write a basic business memo where you describe the financial results of North Central Water Company in 2021 versus 2020, and describe how management might be able to increase net income in 2022 based on your budget projections. You will also be asked to offer your opinion about an ethical situation faced by company's management. Your memo should be single spaced and you should use times new roman style, with a font size of 12. When finished, upload your word file into Ilearn in the assignment called "North Central Business Memo". Please include our name in the filename. H N Budget 2022 of Total Revenues of Total Revenues M Difference 2021 2020 of Total Difference Revenue 2022 2021 2021 2020 Water Sales $ 1,239,840 2 5 1,14 000 2 $ 1.192.000 2 $ 91,840 144.000) Late Tees ? > 71020 2 2 ? 2 2 Hydrant fees ? 2 123 050 > ? 2 2 Total Revenue 1,239 840 100N 1 342,070 100N ? 2 2 Cost of water sold 636, 540 2 618.000 567 000 > 18540 51.000 Payroll expense 512.000 > 2 > Overhead spent > 7 2 2 Miscellaneous 2 > Totalten 636540 2 1.130.000 2 2 Total income 609 300 2 212070 15.30 > ? Customers 24,750 21,150 WATER les per customer 1,600 5 46.1