Skip to content
Study Hall
Lesson 5 of 7Developing and Completing the Venture Plan
Unit 4 · Lesson 5 of 7

Cash-Flow Projections and Break-Even

A monthly cash-flow projection tracks when cash actually comes in and goes out so a venture can spot and fix shortfalls, and break-even analysis shows how many units must be sold to cover costs.

7 min read10 practice questionsInteractiveAsk AI about this →

Key things to remember

  1. 1Net cash flow total cash receipts total cash payments.
  2. 2Closing cash opening cash net cash flow, and each month's closing cash is the next month's opening cash.
  3. 3Profit is not cash: timing, non-cash expenses, loan principal, drawings and inventory purchases all make them differ.
  4. 4Break-even units always rounded up to a whole unit.
  5. 5Break-even in dollars break-even units price.
  6. 6Units for a target profit rounded up.

Here is a surprise that sinks many new businesses: a venture can be profitable on paper and still run out of money. Profit compares revenue and expenses over a whole period. Cash is the money actually in the bank today. If Ava's Cycle Works has to pay for a big parts order in May but most of its customers do not show up until June, May's bills arrive before May's cash. A cash-flow projection is a month-by-month forecast of the cash coming in and going out, so the owner can see a cash crunch coming and fix it before it happens. Lenders almost always ask for one.

Why profit is not the same as cash

  • Timing of receipts. A sale made on credit counts as revenue now, but the cash arrives later, when the customer pays.
  • Timing of payments. Inventory is often bought and paid for months before it is sold. Ava paid for her first stock of bikes before she opened.
  • Non-cash expenses. Tool wear (amortization) reduces profit, but no cash leaves the business for it.
  • Cash that is not an expense. Repaying the principal of a loan and the owner's drawings take cash out but are not expenses, so they do not reduce profit.
  • Seasonality. Sales rise and fall with the seasons. A bike shop is busy in June and July and quiet in October, but rent is the same every month.
VideoSee how a business can show a profit and still run out of cash, which is why a monthly cash-flow projection matters.Watch on YouTube

Building a monthly cash-flow projection

Six-month cash-flow projection (dollars)ItemMarAprMayJunJulAugOpening cash2,000900700900−300400Cash receipts: sales8001,2001,5009002,2002,600Payments: inventory1,0005004001,200600700Payments: rent500500500500500500Payments: wages & other400400400400400400Total cash payments1,9001,4001,3002,1001,5001,600Net cash flow−1,100−200200−1,2007001,000Closing cash900700900−3004001,400June: closing cash falls to −$300. Plan ahead: arrange a line of credit or delay partof the inventory purchase.Each month's closing cash becomes the next month's opening cash (for example, $900 at the endof March opens April).
Fig 1The layout of a cash-flow projection, shown for a different venture: opening cash, receipts, payments, net cash flow and closing cash, with each closing balance carried to the next month.
  1. Opening cash: the cash on hand at the start of the month. For the first month it is the cash left after start-up spending; after that it is last month's closing cash.
  2. Cash receipts: all cash coming in during the month: cash sales, collections from customers, loans received, owner's investment.
  3. Cash payments: all cash going out: inventory and parts, rent, wages, advertising, loan payments, owner's drawings.
  4. Net cash flow total receipts total payments. It can be negative.
  5. Closing cash opening cash net cash flow. Carry it forward as next month's opening cash.

Ava's Cycle Works opens on May 1 with $2,700 in the bank: its operating reserve, since the other $6,000 of start-up capital was spent in April. Ava forecasts tune-ups of 30, 40, 45, 40, 25 and 15 from May to October at $60 each, and refurbished bike sales of 4, 6, 6, 5, 3 and 2 at $250 each. Every sale is paid on the spot. Her helper is paid $800 a month in June, July and August. Loan payments are $140 a month on the youth loan, plus a $1,500 repayment to her family in October. Ava takes drawings only from July to September, once cash has built up.

ItemMayJunJulAugSepOctTotal
Opening cash$2,700$3,410$4,270$4,855$5,165$5,600$2,700
Tune-up sales$1,800$2,400$2,700$2,400$1,500$900$11,700
Refurbished bike sales$1,000$1,500$1,500$1,250$750$500$6,500
Total receipts$2,800$3,900$4,200$3,650$2,250$1,400$18,200
Rent, phone, ads, utilities$900$900$900$900$900$900$5,400
Helper wages$0$800$800$800$0$0$2,400
Tune-up parts$450$600$675$600$375$225$2,925
Used bikes and parts$600$600$500$300$0$0$2,000
Loan payments$140$140$140$140$140$1,640$2,340
Owner's drawings$0$0$600$600$400$0$1,600
Total payments$2,090$3,040$3,615$3,340$1,815$2,765$16,665
Net cash flow$710$860$585$310$435-$1,365$1,535
Closing cash$3,410$4,270$4,855$5,165$5,600$4,235$4,235
Ava's Cycle Works cash-flow projection, May to October. Each closing balance becomes the next month's opening balance.
Two checks that prove the projection adds up
Check the columns: in every month, opening cash plus net cash flow must equal closing cash. Check the Total column: $18,200 of receipts minus $16,665 of payments is $1,535, and $2,700 of opening cash plus $1,535 is the October closing balance of $4,235. If either check fails, an addition is wrong somewhere.
Loading interactive…
Enter Ava's Cycle Works' opening cash, receipts and payments for six months, then add a large parts order in May and watch which month's closing cash turns negative.

Spotting and fixing a cash shortfall

A cash shortfall is any month where closing cash falls below zero, or below the minimum cushion the owner wants to keep. Notice that October's net cash flow is negative (the family loan repayment is due) but closing cash stays positive, so October is not a shortfall. A negative net cash flow is a warning sign; a negative closing balance is the problem. When a projection shows a shortfall, the owner has time to act. Common fixes are:

  • Delay or shrink a large purchase, or spread it over several months.
  • Ask the supplier for trade credit, such as net 30 (pay within 30 days), so the payment moves into a busier month.
  • Arrange a line of credit with a bank before it is needed, and repay it when cash comes back.
  • Bring cash in sooner: take deposits on refurbished bikes, run an early-season tune-up promotion.
  • Cut or postpone the owner's drawings, or keep a bigger operating reserve.

Break-even in units and in dollars

The cash-flow projection shows whether Ava can pay her bills; break-even analysis shows how much she must sell before she makes any profit at all. Fixed costs stay the same no matter how many tune-ups she does: in a summer month, rent, phone, advertising and utilities of $900 plus her helper's $800, for $1,700. Variable costs rise with each unit: $15 of parts per tune-up. Each $60 tune-up therefore leaves a contribution margin of $45 to pay the fixed costs; once those are covered, every extra $45 is profit.

Break-even in units. Always round up to the next whole unit.
Ava's Cycle Works, one summer month, tune-ups only.
Why break-even always rounds up
At 37 tune-ups the contribution is , which is $35 short of the $1,700 of fixed costs, so the shop still loses money. At 38 tune-ups the contribution is $1,710, a $10 profit. You cannot sell 0.78 of a tune-up, so the break-even point is 38. Break-even in dollars is the break-even units times the price: of tune-up sales.

To plan for a target profit, treat the profit like one more fixed cost that the contribution margins must cover: units needed again rounded up. Ava's July projection of 45 tune-ups is above the 38 needed to break even, which is evidence that her summer goals are realistic.

Loading interactive…
Set the fixed costs to 1700, the price to 60 and the variable cost to 15, and find where the revenue line crosses the total-cost line.
VideoThe video shows the break-even point in words, as a graph and as a formula; compare its graph with the break-even lab in this lesson.Watch on YouTube

Worked examples

Reveal one step at a time and try to beat it to the next line.

Example 1
Build the May and June columns of Ava's Cycle Works' cash-flow projection. Opening cash on May 1 is $2,700. May: 30 tune-ups at $60, 4 bikes at $250; payments are $900 fixed, $450 parts, $600 used bikes, $140 loan. June: 40 tune-ups, 6 bikes; payments are $900 fixed, $800 wages, $600 parts, $600 used bikes, $140 loan.
Example 2
What if May is rainy? Suppose May receipts fall to $1,600, and Ava also places a $2,400 bulk parts order in May to get a discount. All other May and June figures stay as projected. Find May's closing cash, then show how asking the supplier for net 30 terms (paying the $2,400 in June instead) fixes the problem.
Example 3
In a summer month Ava's Cycle Works has fixed costs of $1,700. A tune-up sells for $60 and uses $15 of parts. Find the break-even point in units and dollars, then the number of tune-ups needed for a monthly profit of $800.
Example 4
Ava's Cycle Works projects a net profit of $3,105 for the season, but its net cash flow is only $1,535. Explain the $1,570 difference.

Where marks get lost

  • Forgetting to carry the closing cash forward, so every month starts again from the original opening balance.
  • Adding the opening cash into total receipts. Opening cash is money already in the bank, not new cash coming in.
  • Treating a negative net cash flow as a shortfall even when closing cash stays positive, or ignoring a month whose closing cash is negative.
  • Leaving loan principal and owner's drawings out of the cash-flow projection because they are not expenses. They are still cash going out.
  • Rounding break-even down (37.78 to 37) or dividing fixed costs by the price instead of by the contribution margin.

Flashcards 8

Cash-flow projection
Net cash flow
Closing cash
Cash shortfall
+ 4 more

Practice

1
A venture opens a month with $1,250 in cash. Its receipts for the month are $3,400 and its payments are $3,975. What is its closing cash?
$
2
A phone-repair venture has monthly fixed costs of $2,100. Each screen repair sells for $35 and uses $12 of parts. How many repairs must it do to break even?
repairs
3
Using the phone-repair venture's break-even point of 92 repairs at $35 each, what is its break-even point in dollars?
$
4
Ava's Cycle Works' fixed costs in a summer month are $1,700 and each tune-up contributes $45. If the shop does only tune-ups, what is its profit in a month with 45 tune-ups?
$
5
In a cash-flow projection, where does February's opening cash come from?
6
Which of these is a cash payment but NOT an expense, so it appears on a cash-flow projection but not on an income statement?
7
A venture's projected closing cash is: April $900, May $350, June -$420, July $610. What should the owner do now?
8
Put the lines of one month of a cash-flow projection in order, from top to bottom.
  1. 1Closing cash
  2. 2Net cash flow
  3. 3Total cash payments
  4. 4Opening cash
  5. 5Total cash receipts
9
A tutoring venture has fixed costs of $600 a month and earns a contribution margin of $28 per session. How many sessions does it need for a monthly profit of $500?
sessions
10
What is the name for regular rises and falls in sales that happen at the same time each year?

Spot a mistake on this page? Let us know