3-Statement Model Excel

Description
This template combines three key reports:


Income statement: A cornerstone of many financial models, the income statement reveals the business's ability to make a profit (and the extent of that profit).


Balance sheet: When paired with the profit and loss statement, the balance sheet shows how much cash or investment you need to support the sales and profits on the income statement.
Net income from the income statement flows into the balance sheet as a change in retained earnings (adjusted for payment of dividends).


Cash flow: This statement displays the change in cash over a period along with both the beginning and ending balances for that period in cash.


Your cash flow statement takes net income and adjusts it for any non-cash expenses. From there, you can reference changes in the balance sheet to find cash usage and receipt patterns.


3-statement model is linked with below mentioned keys:
Net income: The bottom calculation from the income statement appears on the balance sheet and cash flow statement.
Depreciation: Added back into cash flow statement.
Capital expenditure: deducted from the cash flow statement, which determines the amount for PP&E on the balance sheet.
Financing: Feature on the balance sheet. Cash from financing also appears on the balance sheet.
Cash balance: Closing cash balance from the previous period, added to the current period cash from operating activities, investing, and financing, becomes the closing cash balance on the balance sheet.