Finance
Name Three Financial Statements
Balance Sheet
Income Statement
Statement of Cash Flows
The minimum charge generally covers (blank) expenses while the volumetric charge covers (blank) expenses.
Choices: variable, fixed
The minimum charge generally covers fixed expenses while the volumetric charge covers variable expenses.
What two types of utility billing data do we generally work with?
STW & Incode.
Who has graduated from both A&M and the University of Texas*?
Matthew
*Not THE University of Texas at Austin, but the University of Texas at Dallas :)
Who at NewGen holds a PhD?
Natalie
What is the equation for working capital?
Current Assets minus Current Liabilities
What volumetric rate structure would you propose to a utility if they were looking to promote conservation?
Increasing Block Rate.
What formula is similar to a vlookup..but on steroids?
Index Match
Who began his/her career as a Risk Accountant in Houston?
Kim
Name one pet belonging to someone at NewGen besides from your team.
open-ended
What is the difference between cash-base accounting and accrual-base accounting?
Cash based recognizes sales and expenses when cash actually flows out of the company. Accrual based recognizes revenues and expenses as they are incurred regardless of cash flows.
Generally, what billing units are used for a drainage utility? How is a billing unit calculated?
Equivalent Residential Units (ERUs). Calculated by taking average impervious area of residential properties.
What formula would you use to remove trailing/leading/double spaces in a text?
Trim
Who has previously interned for U.S. Congressman Larry Combest?
Chris
What is the name of the beloved coffee machine at the Richardson office?
Ol' Rusty
What is one way an entity would have positive net income and still go bankrupt?
Increasing accounts receivable
Lowering accounts payable
Financial Fraud
What does CCN stand for? What does it mean?
A Certificate of Convenience and Necessity (CCN) gives a retail public utility the exclusive right to provide retail water and sewer utility service to an identified geographic area .
Which of the following features cannot be found in the Data ribbon?
-What-If Analysis
-PivotTable
-Data Validation
-Text to Colums
PivotTable
Who won Fantasy Football this year?
Aaron
What month did we begin our first virtual happy hour?
(DOUBLE POINTS IF YOU CAN CORRECTLY GUESS WHICH EXACT DATE)
March 27th, 2020
Why do Capital Expenditures increase assets, while other cash outflows (salary, taxes, etc.) do not create any asset?
Capital expenses are capitalized because of the timing of their estimated benefits. Ex. Treatment plant will benefit the utility for many years.
Per M1 Manual, name at least two common reasons a utility might implement a rate surcharge?
Response to Disaster Surcharge
Rate Stabilization surcharge
Elevation surcharge
Capital Financing surcharge
Drought surcharge
You are you trying to break a link to an external dataset and that nasty critter does not want to leave your life...what are three places you would look at to manually identify and remove those connections?
Data Validation
Charts/Tables (including Pivot)
Conditional Formatting
Name Manager
Shapes
Who has been referred to as Sunshine from his/her client?
Becky - courtesy of Donna from Ada
Name all 13 member cities for NTMWD.
Allen, Farmersville, Forney, Frisco, Garland, MicKinney, Mesquite, Plano, Princeton, Richardson, Rockwall, Royce City, Wylie