In all Pivotal180 financial modeling courses, when we build the financial model, we build in forecasts for the three key financial statements. The three financial statements together help to understand the business activities and financial performance of a business. By forecasting these statements, we can analyze how the project or business will perform under a variety of different sensitivities and scenarios.
In our financial models we always have an integrated set of financial statements which includes a balance sheet, income statement and cashflow statement. All three of these statements connect with each other and one should never develop a forward-looking model for any business without these three financial statements.
You now know you need to build an integrated set of financial statements in your model but what are these three financial statements, how are they linked and is any one more important than the other.
Before I launch into the world of financial statements let me tell you a little about me. I am one of the founders of Pivotal180 together with Haydn and Dan. My background is very different as I am not a modeler and have not been involved in actual project finance deals. My expertise is in finance with over 30 years’ experience as a CFO for companies including SAP, Giorgio Armani and Corality. I have therefore been using these financial statements for a long time that I had forgotten that they are a learned skill and not part of my DNA.
We use these statements in our financial modeling so it is important we introduce them to you properly.
The three financial statements are
- Balance Sheet
- Income Statement (Profit and Loss Statement or P&L)
- Cashflow Statement (Cash waterfall)
These are used by investors, analysts, and creditors to evaluate the health and earning potential of a business.
BALANCE SHEET
The balance sheet tells you about the health and net worth of a business. It is a snapshot of a business’ performance at a single point in time
It comprises of
- Assets – these are what the business owns or is owed
- Liabilities – what the business owes to others
- Equity the owners’ investment and the retained earnings
The fundamental rule of accounting is
ASSETS = LIABILITIES PLUS EQUITY (or if you are an Australian, Assets – Liabilities = Equity but that is another story)
A balance sheet is further categorized as follows
Current Assets can be used in less than 12 months
- Accounts receivable – amounts owed by clients
- Cash and cash equivalents
Non-Current Assets lasts more than 12 months
- Capital items such as plant and equipment
Current Liabilities due in less than 12 months
- Accounts payable – amounts owed to suppliers of services
Noncurrent Liabilities due in more than 12 months
- Debt provided to the business
Equity paid up capital and retained earnings
- Opening retained earnings + Net Income – Distributions = Ending retained earnings
- Equity represents the amount of money that would be returned to shareholders if all the assets were liquidated and all the company’s debt was paid off.
INCOME STATEMENT
The Income Statement records how much a business has earned and spent over a period of time, reflecting the profitability of a business
It tells you the financial strength of the business. It includes all the sources of income and costs – including items that are not cash related. The income statement calculates the profit of the business called net Income
It is often considered the most important financial statement from an accounting perspective and is usually the first place an investor will look
An income statement does not match the cash flow statement. Accounting principles such as accruals, prepayments are used to determine net income. Accrual accounting calculates the receipts instead of the actual cash.
Revenue is recorded at the time of the sale, even if the customer has not paid. It therefore is revenue but no cash has been received so it does not appear in the cash flow statement. The other side of the entry is accounts receivable being the amount owed by a customer for a service performed but not paid. As it is money owed to the company it is reflected as an asset on the balance sheet. When the cash is received, we reduce the accounts receivable balance and increase cash.
Other non-cash items such as depreciation appear in the income statement but not the cashflow statement
Some terms you may not be familiar with our income statement below are
- Cost of Goods Sold (COGS) also referred to as the cost of sales or cost of services, is how much it costs to produce your products or services.
- EBITDA Earnings before interest, tax, depreciation, and amortization.
- EBIT Earnings before interest tax.
I have ignored tax to keep things simple in line with our financial modeling courses.
CASH FLOW STATEMENT
A cashflow statement tracks all the cash inflows and outflows in a business over a period of time
The cash flow statement measures how well a company generates cash to fund the operating activities, pay its debt and fund investments.
Reflects only the cash movements and tells us how much cash the business generates.
The cash flow statement takes net income and adjusts it for any non-cash expenses.
How are the three statements linked
Accountant commonly calculate the cash flow by starting with the income statement and movements between the two balance sheets within the period to calculate the cash flow. For example, if the long term of 45K is repaid the liability in the balance will reduce by 45K. Cashflow will reflect this by taking the delta of the balance sheet at the end of each period. (0-45k). The cashflow will show -45K as loan has been repaid and will show as a reduction in cash available from funding.
(In fact, a cash flow can be totally derived from the balance sheet and income statements but that is another blog)
In our financial modelling courses, we start with the cashflow and then create the income statement and balance sheet from the cashflow This is known as the direct method. We find that analysts tend to create more straight forward forecasts by using this method
The cashflow links to both the income statement and balance sheet
The net Income from income statement is the first line of the cash flow statement the net income from the profit and loss also becomes part of the retained earnings in the balance sheet
The closing cash balance equals to the cash in the balance sheet A cashflow statement is in effect a reconciliation of the changes in the prior period over current period balance sheet
This will all become much clearer once you work through building a three-way statement in our financial modeling courses.
Which Financial Statement is most important?
From an accounting perspective there is no consensus, I think it is the balance sheet where others would argue it is the income statement BUT in project finance the cashflow waterfall is the most important financial statement.
This is referred to the cash flow waterfall or cash cascade in the context of project finance This is similar to the cashflow statement, but the cashflow waterfall shows the priority of each cash inflow and outflow from the project. And this is an important distinction!
As cash is so important in project finance, the financial statement of most interest to the lenders and investors is the cashflow waterfall
This is just an introduction financial statements and they do become harder and more complicated. If you are interested in learning more about financial modeling for business planning please Speak to us about our tailored courses
Learn more about the cash waterfalls in Haydn’s blog
The cashflow waterfall is a must-know for all project finance participants. Our courses go into further detail than what we cover here. Our financial modeling courses that teach this in more detail are:
- Project finance and infrastructure financial modeling
- Renewable energy project finance modeling
As a seasoned financial professional with over 30 years of experience as a CFO for notable companies such as SAP, Giorgio Armani, and Corality, I bring a wealth of expertise in the realm of finance and financial statements. Throughout my career, I've not only utilized but mastered the intricacies of financial modeling, making me well-versed in the principles discussed in the article.
Now, let's delve into the key concepts highlighted in the article:
1. Financial Statements: The Backbone of Analysis
The article emphasizes the significance of constructing an integrated set of financial statements in any financial model. These statements include:
a. Balance Sheet:
- Snapshot of a business' performance at a specific point in time.
- Comprises Assets, Liabilities, and Equity.
- Formula: Assets = Liabilities + Equity.
- Categorized into Current and Non-Current Assets and Liabilities.
b. Income Statement (Profit and Loss Statement or P&L):
- Records a business's earnings and expenditures over a specific period.
- Reflects profitability.
- Includes all sources of income and costs, not limited to cash-related transactions.
- Key terms: Cost of Goods Sold (COGS), EBITDA, EBIT.
c. Cash Flow Statement (Cash Waterfall):
- Tracks cash inflows and outflows over time.
- Measures a company's ability to generate cash for operations, debt payments, and investments.
- Adjusts net income for non-cash expenses.
- Essential for understanding the cash position of a business.
2. Linkage Between the Three Statements:
The article highlights the interconnectedness of these statements, emphasizing that accountants often derive cash flow by starting with the income statement and considering movements in the two balance sheets within a given period. The direct method, as mentioned, involves starting with the cash flow and then building the income statement and balance sheet.
3. Importance of Financial Statements:
a. Balance Sheet vs. Income Statement:
- Accounting perspectives differ on which statement is most crucial.
- Balance sheet proponents argue for its importance, while others favor the income statement.
- However, in project finance, the article asserts that the Cash Flow Waterfall takes precedence.
b. Cash Flow Waterfall in Project Finance:
- Considered the most crucial financial statement in project finance.
- Similar to the cash flow statement but emphasizes the priority of each cash inflow and outflow.
- Critical for lenders and investors due to the paramount importance of cash in project finance.
4. Financial Modeling Approach:
The article introduces the direct method for financial modeling courses, starting with the cash flow and subsequently creating the income statement and balance sheet. This approach is touted as more straightforward and preferred by analysts.
Conclusion:
The foundational understanding of these financial statements is paramount, and the article suggests exploring tailored financial modeling courses for in-depth knowledge. It emphasizes the relevance of the Cash Flow Waterfall in project finance, signaling its importance in real-world financial analysis.
For those keen on expanding their knowledge, the recommended financial modeling courses cover areas such as project finance, infrastructure financial modeling, and renewable energy project finance modeling.