Illinois Needs a Moon Shot

Biosphere Sustainability climate  |modeling | society | unintended Water touches everything. Permanence is the illusion of every age. To create a product that is safe, healthy, affordable, effective, and designed to be returned safely to nature or industry after use. Cradle-to-Cradle Can the company demonstrate to society and investors the link between sustainable business and corporate value? in general: overshoot: Limits to Growth Meadows > Modeling | unsustainability: Finland’s system of social benefits is unsustainable | energy innovation: Breakthrough Energy Coalition | Permanence is the illusion of every age. | carbon-neutral cities: carbon markets, Malmo, Sweden | forums & institutes: Institute for Climate and Sustainable Cities, theinstituteforsustainability, Worldwatch Institute | about: Sustainability Primer | buildings: Living Building Challenge | circular economy: about | globalization: telecoupling big ideas | measure ROI: The Green Scorecard Phillips | Collapse or Sustainability of Societies Motesharrei | Cradle to Cradle McDonough | Crowd Supply | design: Ideas and Integrities Fuller | farming: The Farm Bromfield | Sustainable Freshwater Aquaculture Romanowski | more

by Scott PIckard

For all of us that have a commitment to living out our years in Illinois, it’s a very scary proposition. I’ve got a State pension and who knows what could happen 5, 10, 20 years down the road. I guess I’m going to find out.

Illinois is in a slow bankruptcy burn. I’ve been inside companies that went bankrupt and Illinois has all the signs:

  • overwhelmed by crushing debt that grows daily
  • harassed by creditors from every angle that is slowly grinding the State down
  • a delusional hope springs eternal denial of the problem
  • citizen’s clueless to the real magnitude of the problem; or,
  • they simply don’t give a shit because there is nothing they can do about it and when it all blows up, they will just move on down the road
  • the problem is unfixable
  • the State is checked
  • the State is….. checkmate

The State will eventually hit the wall and either goes through a “simulated” bankruptcy; or, everything and everybody blows away like dust in the wind.

Chris Kennedy and other wealthy businessmen-politicians mean well but will only give us what the classic quote tells us and we all know deep down: “If you keep doing what you have always done, you will keep getting what you have always gotten.” But, I do admire that Kennedy et al want a crack at the State’s Fiscal Gordian Knot and are chomping at the bit to kick out Governor Bruce Rauner on his billion-dollar country club ass.

The politicians will NEVER solve the State’s Fiscal Gordian Knot in our lifetimes. Only the people can solve this by:

  • firing every sitting politician all the way up to the governor
  • hiring a third party turnaround trustee-manager person that does not live in Illinois and is clean of any conflicts of interest
  • have the person report directly to the people
  • have the person manage a “moonshot” competition to develop a 50-year plan to reach financial sustainability
  • any person and/or team on the planet can submit their moonshot plan
  • have the people use “approval voting” to vote for the best moonshot plan
  • the winning moonshot team gets $100M paid out over 50 years contingent on performance of the plan over time
  • while the plan is playing out, re-engineer and revolutionize Illinois government so this never happens again

All you radical-thinking, clear-thinking people out there, here’s your chance to make your mark, never have to work again (unless you want to), save Illinois, and in the process design a revolutionary financial roadmap for the rest of the world because we’re all going to need it.

Crazy, you say?

Have you got a better idea?

- sp -

cash

cash

by scott pickard

Cash is king, as the old saying goes. It is the one resource a company cannot survive without for any length of time until the doors are closed, voluntarily or involuntarily, which is why the CEO must find or develop a method to reliably understand and predict the company’s current and future ability to generate the cash it needs to pay all of its bills.

Forecasting cash flow is much easier than it used to be, thanks to the convenient number-crunching power of PCs and spreadsheet software which allows one to build an Integrated Spreadsheet which links a projected balance sheet and income statement for the business. The Integrated Spreadsheet is a tool that will give any CEO the positive direct control they must have over the financial rudder of the business.

A wise time investment for CEO’s
A company’s cash flow at any point in time is a juxtaposition of payables, receivables, debt service, capital expenditures, sales/repurchases of stock, and other factors. An Integrated Spreadsheet handles this complex financial interaction with electronic precision. Using this tool, a CEO can more carefully predict where the company is heading. That’s powerful planning and peace of mind for the executive/owner that shoulders the burden of consistently meeting payroll and staying current with suppliers on all bills.

  • The Integrated Spreadsheet gives the CEO a rational way to appropriately pace capital expenditures, quarterly (or even monthly) bonus payments, and sweeps of excess cash into less liquid but higher-returning financial instruments at the earliest possible time.
  • The Integrated Spreadsheet allows the CEO to look at the effect on cash from big-picture business initiatives such as acquiring a new business, selling off a division, developing and staffing a new department, or launching a new product line.
  • Using an Integrated Spreadsheet helps the CEO disclose mistakes that are sometimes made in monthly financial statements from either miscoding or a faulty accounting interpretation of a particular transaction.
  • With an Integrated Spreadsheet the company always has a three-year plan that is built on actual operating numbers, but fine-tuned to reflect management’s best judgment of future revenues and expenses.
  • The Integrated Spreadsheet can easily generate an unlimited number of graphs to analyze past performance and predict future performance which is often the most effective way to communicate financial data to employees, directors, shareholders, and the bank.
  • An Integrated Spreadsheet will demonstrate to the bank, board, and investors that the financial management and budgeting of the company is under control which promotes confidence in the officers and the business by its internal and external constituents.

DIY

Assuming the user knows their way around a spreadsheet and double- entry accrual accounting, the structure of an Integrated Spreadsheet can be set up in a few hours. It will take a day or so to input the previous twelve months of operating data; a day to input informed estimates of revenues, expenses, and capital expenditures for the next twelve months and to fine-tune those estimates; and a day to train all users who will have access to the Integrated Spreadsheet.

If the CEO cannot spare the time, this task can be delegated to inside accounting staff or subcontracted to an outside accountant or consultant. If this project is delegated, it is still important that the CEO be trained in the use of the Integrated Spreadsheet so that he or she can perform what-if analyses and generally watch over the constantly revising forecast of the financials of the business, a function that should be owned by the CEO. Financial forecasting involves hundreds of experience-based estimates of highest-probable outcomes of revenues, expenses, capital expenditures, debt service, equity inflows and outflows, extraordinary gains and losses, and other income and expenses, by someone that has the overview of the business. The CEO has this overview as it is part of the responsibility of the position.

Basic structure of the integrated spreadsheet
It is important for the user to have a general understanding of how the spreadsheet is laid out and functions. The integrated spreadsheet has three major components:

  • Balance Sheet
  • Income Statement
  • Cash flow adjustment

These three components are linked or integrated so that they balance or tie out in accrual accounting terms. These integrated accounts are highlighted in various colors as shown on the diagram below:

cashflow

The major points of integration are identified by the matching colors. For example, the link between “depreciation” on the balance sheet and “depreciation expense” on the income statement is shown in brown, since these two entries must be identical in double-entry accrual accounting. There are in fact numerous links between the income statement and the balance sheet as a result of the double-entry methodology. The beauty of the spreadsheet is it affords the user the flexibility to add/subtract/modify at will and build increasing sophistication into the integrated spreadsheet enabling a more realistic modeling of the financial dynamics of the business.

I’ve posted a power point presentation on prezi that leads you through the basic construction of the integrated spreadsheet. The secret sauce in this process is the synching of a cash flow adjustment (plug) at the bottom of the spreadsheet below the income statement as shown in the diagram below:

2slides

By wiring together these key accounts to calculate the actual cash flow for each month, this will cause what’s known as a circular calculation in the spreadsheet which is normally a no-no, but in this case it is a good thing! The user simply needs to go into “settings” and set the automatic calculation to 100 iterations and the spreadsheet will automatically recalculate and balance the statements after each new value entry to a cell.

Using the tool

Once the integrated spreadsheet is set up, using it effectively involves inputting the actuals from each monthly financial statement as they occur and reforecasting the numbers going forward from the most recent actuals. This process repeats itself every month — inputting the most recent actuals and reforecasting ahead — and as each month goes by and the user gains experience in using the spreadsheet and making experience-based judgments of how the numbers will track, the integrated spreadsheet becomes an expert system that does a better job over time of forecasting the financial fortunes (or misfortunes) of the company. The key point is that all of this boils down to one most important account: cash flow.

Once the process of updating actuals and forecasting ahead is complete,
the CEO looks at the impact on cash and then develops a financing plan
that optimizes the uses of working capital in the next six months and beyond.
If the projected cash flow shows surpluses being generated, the CEO can
decide how that excess cash could be used today and in the coming months
to:

  • Reduce payables
  • Reduce long-term debt
  • Make capital expenditures
  • Make other long-term investments

If the projected cash flow is negative, the CEO must plan for how the
minimum working capital requirements for the business will be generated to
carry the company through tight cash periods by a combination of:

  • Drawing down cash surpluses
  • Deferring certain operating and capital expenditures
  • Extending the payables cycle for a brief period within acceptable bounds
  • Making a draw on an operating line of credit
  • Securing additional long-term financing
  • Raising equity capital through the sale of common or preferred shares

Summary

If the CEO can build the integrated spreadsheet for the business and start using it each month ( if not each day), learning by doing is the most efficient user’s manual. The CEO will quickly discover the many dimensions of value that are derived from the integrated spreadsheet aside from the very tangible value of forecasting cash flow. The integrated spreadsheet causes the user to think about every aspect of the business, across all accounts, across time, across strategies, by looking back to look forward. And at the end of the exercise instead of saying, “I hope we’ll have the money in the bank when we need it,” the CEO can say, “We expect to have the cash we need, and here’s how.”

That’s powerful business confidence!

- sp -

On Electing a President

Development of Technology Trustworthiness How do you measure/validate trust in the cybersecurity of the enterprise? How can big-city police (e.g. Baltimore) and neighborhoods-at-risk rebuild trust in each other? How do you know if someone is trying to win, or lose? Parameters of trust Trust is built over a marriage, a career, a lifetime, but can be lost in a second. sp Confidence Reliability Integrity: trustworthiness over time Privacy Resiliency: Antifragile: Things That Gain from Disorder Taleb Skepticism and Conspiracy Theory Terms of Service: monitoring: docracy | ratings: crowd ratings Truth (correctness) photos: A bullet can kill a man, but a lying camera can kill a nation. lying: There is no defense against lying. sp | white lies vs black lies Technologies of trust big data: cyber-physical systems: terraechos certifications: kikscore drug testing federations: InCommon passwords: keepersecurity products & services relationship mining: intersecting people sp | Relationship Science scoring trust: TrustCloud Fields of Application economy: Economic Anxiety Index human-machine relationships marketing: celebrity DBI DBI= 0.6*(Awareness) + 0.4*((Appeal+ Breakthrough+Trend-Setter +Influence + Trust + Endorsement + Aspiration)/7) Societal Risk Management (SRM): graduate program software: Top 25 Most Dangerous Software Errors in general: advertising: evidon, doubleverify | medical devices: Open Medical Device Research Library omdrl.org | electronic voting: Do electronic voting machines improve the voting process? | Failed States Index: fundforpeace | financial institutions: credit cards, financialtrustindex | internet |sports: Lance Armstrong, research | wellness: Dr. Oz, Food Babe untrustworthy: politicians: Donald Trump, Chris Christie, Hillary Clinton > Politics | priests: Spotlight | investment advisers: Bernie Madoff | corporations: Volkswagen | government: NSA | nonprofits: FIFA, Red Cross books: ubiquitous: Trust is the glue that holds us together sp | Dare: Accepting the Challenge of Trusting Leadership Weiss | Extreme Trust: Honesty as a Competitive Advantage Peppers | Just How Fragile Are America’s Bridges? Sofge | Likeonomics Bhargava | The Fix: Soccer and Organized Crime Hill

by scott pickard

Kudos to Mr. Pickens for throwing down an idea! We need new ideas and the discussion they instigate is good and is our democratic way. But I think the greater problem than the election process is the accountability process on the back end. If the federal government was a corporation and we were its shareholders, the CEO (President) and board (Congress) are driving our company towards bankruptcy and we have no way to stop it. The best idea I ever heard was Warren Buffett’s idea: “I can end the deficit in five minutes. You just pass a law that says that anytime there’s a deficit of more than 3% of Gross Domestic Product (GDP), all sitting members of Congress are ineligible for reelection.” You may argue that an idea this radical can never be implemented (the same feasibility of passing a flat tax), but until we have a real financial check-and-balance that does not depend upon politicians, a new election process will not bring us any improved accountability. “Trust” and “accountability” are what we must restore and the irony is that the way our current political system is designed, the overwhelming objective evidence shows that professional politicians cannot get the job done. So how does it get done?

- sp -

Budgeting


Successful Implementation of a Long-Term Energy Management Program

by Scott Pickard

energy management

The Concept

Content

  • Getting started
  • Resources
  • Incentives
  • Developing a written plan
  • Presenting to decision makers
  • Costing, budgeting, ROI
  • Financing the ECRMs
  • Bidding, contracting, managing contractors
  • Monitoring and reporting energy results
  • Dealing with human behavior and its impact on success
  • Continuous improvement

Education materials

  • self-published book in paperback, e-book, online form
  • power point presentation >> PDF
  • live webinar(s) >> video(s)
  • video interviews/profiles of successful programs
  • annual “implementation” workshop

Presentation styles

  • in person
  • in live webinar
  • in pre-recorded webinar
  • in written format

sp