Skip to content
Tutorials Center
My learning

Topics

Lesson 36 of 37 ยท Projects and Practice

Project: A Six-Month Cash Flow Plan

Build a six-month cash flow forecast for an invented online shop, find the month cash runs out, and test fixes such as an overdraft or faster customer payment.

In this project you build a six-month cash flow forecast for PetPals, an invented online shop selling pet accessories. The owner, Tariq, worries about the first half of the year. Your job is to forecast cash, find problems and suggest fixes. Every figure is made up for practice.

Step 1: The facts

  • Opening cash on 1 January: $4,000.
  • Tariq expects these sales (in dollars): Jan 6,000; Feb 7,000; Mar 9,000; Apr 12,000; May 15,000; Jun 16,000.
  • Customers pay in the month after the sale (many pay through a payment provider that holds money for a month). So January's receipts come from the previous year's December sales: $5,500.
  • Stock (the goods he sells) costs 55% of sales and must be paid for in the month the sales happen because suppliers want quick payment.
  • Fixed monthly payments: rent of a small storage unit $600, website and software $250, one part-time helper $1,100, advertising $500.
  • In March Tariq will buy a $3,000 packing machine (paid at once).

Step 2: Receipts and payments by month

Receipts in each month = sales of the previous month.

Jan Feb Mar Apr May Jun
Receipts 5,500 6,000 7,000 9,000 12,000 15,000

Payments each month = stock (55% of that month's sales) + fixed payments (2,450) + the machine in March.

For January: 0.55 ร— 6,000 = 3,300; plus 2,450 = 5,750.

Step 3: Build the forecast

Python PetPals cash flow forecast

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Look at the closing balances. Cash falls from $4,000 to only $50 in March and to $0 in April, so Tariq has no safety cushion at all, although sales are growing. The shop pays for stock a month before customers pay, which is the overtrading problem you met in the cash flow lesson. Any small miss in sales would push the balance below zero, and Tariq would then need finance.

Step 4: Test the fixes

Tariq has three ideas:

  1. A bank overdraft of $3,000 (cost: interest).
  2. Rent the packing machine for $150 a month instead of buying it.
  3. Negotiate with suppliers to pay in the following month.
Python Compare cash flow fixes

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Compare the lowest balance in each case. A fix that raises the lowest balance above zero removes the need for an overdraft. In this model the third idea changes the timing of payments for stock; it does not change profit, only the date of payment, and it depends on a supplier agreeing.

Step 5: Write the advice note

A good note might include:

  • What the forecast shows: which month is the lowest, and how much extra cash is needed.
  • Causes: paying suppliers before customers pay; a large one-off purchase.
  • Options and trade-offs: overdraft (interest), renting (higher cost over time), delaying payment (supplier relationship), selling for faster payment.
  • Recommendation: pick one or two and explain why.
  • Risks: sales may be lower than the forecast; update the forecast every month.

Because the forecast depends on assumptions, test a pessimistic case too: set each month's sales 20% lower and see whether the plan still works.

JS Pessimistic sales case

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Check your understanding

Quick check ยท 3 questions

of 3 answered You scored / 3 ยท perfect!

  1. 1. Why can a growing shop run short of cash?

    Timing differences between payments and receipts can drain cash even when sales rise.
  2. 2. Which option raises the lowest cash balance without borrowing?

    Renting spreads the cost over months, reducing the large March payment.
  3. 3. Why test a pessimistic case?

    Forecasts are uncertain, so planning for a worse case reduces risk.

Summary

  • Build a forecast from receipts, payments and opening and closing balances.
  • Timing of cash matters as much as profit.
  • Compare fixes by the lowest balance and the cost of each.
  • Update forecasts regularly and test pessimistic cases.

Next: Practice Set: Business Calculations