FormulaCamp
Completed
11. Finance and Business Analytics · Management Accounting and Analysis · 25 min

7. P&L and Cash Flow: Profit Is Not Cash

Lesson 7 of 16
Task 1 of 6
  1. In B4:D4, calculate gross profit: revenue minus cost of goods sold.

Lesson theory

A business owner needs two reports, and they must not be mixed up.

  • The P&L (profit and loss statement, or income statement) answers "did we earn money?". Revenue comes first, then expenses are subtracted in steps: cost of goods sold (coffee, milk, cups) → gross profit; rent, payroll, marketing and depreciation → operating profit; tax → net profit.
  • Cash flow answers "will there be enough money in the bank?". An espresso machine bought for $24,000 is a huge cash outflow in the month of purchase, but the P&L records it little by little through depreciation ($1,000 a month here, straight-line, as with SLN).

The simplified indirect method: Cash flow = Net profit + Depreciation − Capital expenditure. Depreciation is added back because it is an on-paper expense: the cash already left when the machine was bought. Ending cash for the month = opening cash + cash flow.

No income tax is due in a loss-making month, so tax is calculated as =MAX(0,profit*rate). Real accounting also carries losses forward to future periods; we leave that out.

The tax rate sits in its own cell, G2, and is anchored in the formulas: =MAX(0,B9*$G$2). When the rate changes, you edit one cell instead of twenty formulas.

Note: the 20% flat rate is only a practice number. Real tax rules differ by country and business type and change over time, so check current rules or ask an accountant before real calculations.

Test yourself

1. In January the operating profit is slightly negative, yet cash in the bank fell by $24,200. Why is the gap so big?
2. Why add depreciation back to net profit when calculating cash flow?
3. Why keep the tax rate in its own cell instead of typing 20% into every formula?

Practice is part of Pro

The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.