I have attached a sharable google excel sheet link below for viewing it can be copied and pasted into a excel sheet.

https://docs.google.com/spreadsheets...it?usp=sharing

This is the excersise given to me. How did they do the accounting on the revuenes / expenses tab?? When I totaled up each years availabe budgets on the revenues, its all negative numbers which doesnt make any sense. Here are the instructions given... and a screenshot of Revenues / Expenses tabs.

Exercise 1:

In June of 2017 Public Utilities brought forward several changes that positively affect the future of Public Utilities. While one change brings savings, it will be several years until the full savings are felt. In the meantime, other changes immediately affect our revenues.

We were just informed this morning that a major water distribution main has been compromised and needs immediate replacement. The estimate replacement cost is $15 million and it is critical that the construction is complete in the next two years.

With the attached revenues and expenses, and our 5-year CIP, what is the recommended plan of action? Please provide a memo outlining your recommendations and financial charts and graphs.