Projected Balance Sheet (with LivePlan)

“Think of it as your business dashboard, providing a snapshot of the financial health of your company at a specific moment in time. The purpose is simple: balance sheets list assets, LivePlan Specific Versionliabilities and owner equity, typically in order from shortest- to longest-term assets and liabilities divided on either side of the balance sheet.”

– Financial Post

The Balance Sheet includes spending and income that isn’t in the Profit and Loss. For example, the money you spend to repay a loan or buy new assets doesn’t show up in the Profit and Loss. And the money you take in as a new loan or a new investment doesn’t show up in the Profit and Loss either. The money you are waiting to receive from customers’ outstanding invoices shows up in the Balance Sheet, not the Profit and Loss. The Balance Sheet shows many reasons why profits are not cash, and why cash flow isn’t intuitive. It’s all related to the those cash flow traps.

The Balance Sheet shows your financial picture – assets, liabilities, and capital – at some specific moment. It helps to understand that the Profit and Loss shows financial performance over a length of time, like a month, quarter, or year. The Balance, in contrast, is a moment. Usually it’s the end of the month, quarter, or year. Sometimes it’s the end of the business day.

Balancing is a common term associated with bookkeeping, accounting, and finance. We “balance the books.” It’s a lot like reconciling a checkbook: if it isn’t right down to the last penny, then it’s wrong. Assets have to equal liabilities plus capital. Always.

LivePlan generates a standard Projected Balance Sheet using the assumptions you’ve given it for Profit and Loss and the Cash Flow Assumptions:

 

LivePlan Projected Balance Sheet

The balance sheet involves the other three of the six key financial terms (the ones that aren’t on the Profit and Loss: Assets, Liabilities, and Capital).

  • Assets. Cash, accounts receivable, inventory, land, buildings, vehicles, furniture, and other things the company owns. Assets can usually be sold to somebody else. One definition is “anything with monetary value that a business owns.”
  • Liabilities. Debts, notes payable, accounts payable, amounts of money owed to be paid back.
  • Capital (also called equity). Ownership, stock, investment, retained earnings. Actually there’s an iron-clad and never-broken rule of accounting: Assets = Liabilities + Capital. That means you can subtract liabilities from assets to calculate capital.

Although traditional printed balance sheet statements are usually arranged horizontally, as in the illustration above, balance sheets in financial projections are usually arranged vertically, showing the assets first, then the liabilities, and then the capital.

This is planning, not accounting. It’s one of the primary principles of the lean business plan. To make a powerful and useful cash flow projection, you need to summarize and aggregate the rows of the balance sheet. Resist the temptation to break it down into detail the way you would with a tax report after the fact. This is a tool to help you forecast your cash.

The Link Between Balance and Profit

The balance sheet is so different from the Profit and Loss that there is only one direct link between the two, a vital one that connects them so that when the books are right, the balance balances: That is the direct line from profits (Net Profits) on the Profit and Loss to Earnings and Retained Earnings on the Balance Sheet. The illustration here shows the link with the bicycle store sample:

LivePlan Links Balance and Profit

Leave a Reply

Your email address will not be published. Required fields are marked *