Cash Flow Planning
Project workbook · Path 62

Build a three-month cash plan, reconcile opening and closing balances and test a delayed-receipt scenario.

The case

A community workshop starts January with 1,000 cash units. Receipts and payments occur in different months. There is no borrowing or tax in this simplified case. A delayed February receipt must be evaluated before anyone commits to additional spending.

MonthReceiptsPayments
January8001100
February14001600
March1200900
STAGE 1

Define the cash boundary

A cash budget records expected receipts and payments within a stated boundary. Define the period, currency or teaching unit, opening balance and excluded flows. Do not mix invoiced sales with collected cash. The supplied receipt schedule already represents expected collections; changing it requires a recorded scenario.

Your task

Write the planning assumptions and label every column as cash or non-cash.

Required output

Cash planning policy

Record your result and evidence here or in a separate file.

Review gate

The 1,000 opening balance is not counted as new monthly revenue.

If the gate is not met

Separate opening resources from current-period receipts.

STAGE 2

Build the rolling balances

For each month, closing cash equals opening cash plus receipts minus payments. Carry that closing figure into the next row. A formula can look plausible while referring to the wrong month, so reconcile the whole period as well as each row. Keep inputs visibly distinct from calculations.

Your task

Create the three-month cash table and a whole-period reconciliation.

Required output

Base cash plan

Record your result and evidence here or in a separate file.

Review gate

Closing balances are 700, 500 and 800; the final balance also reconciles directly.

If the gate is not met

Trace cell references and check the opening balance is used once.

STAGE 3

Shift a receipt honestly

A timing scenario moves a receipt between periods while preserving its amount unless loss is a separate assumption. The lowest balance may reveal a problem hidden by the final balance. Review the sequence, not just the quarter total, and record which event would trigger a revised plan.

Your task

Move 600 of February receipts to March and recalculate every balance.

Required output

Delayed-receipt scenario

Record your result and evidence here or in a separate file.

Review gate

The balances become 700, -100 and 800, with the same quarter-end total.

If the gate is not met

Do not subtract the delay in February without adding it to March.

STAGE 4

Compare responses

A forecast shortfall is a prompt for a decision, not permission to spend or borrow. Compare timing changes, reduced optional payments and additional verified receipts. State the effect and the consequence of each option. Avoid hiding a gap by assuming unapproved finance or a customer payment that has not been agreed.

Your task

Compare deferring 150 of optional February payments with obtaining an earlier confirmed receipt.

Required output

Response options

Record your result and evidence here or in a separate file.

Review gate

Each response names an approval owner and distinguishes a proposal from an agreement.

If the gate is not met

Replace a balancing plug with a named, testable assumption.

STAGE 5

Set a review routine

Compare actual cash movements with the plan and explain differences by amount, timing and cause. A revised forecast should preserve the original version for learning. Use a short review cadence and identify who updates the records. This case does not substitute for bookkeeping controls or professional financial review.

Your task

Create a monthly actual-versus-plan template and a trigger for updating the forecast.

Required output

Review sheet

Record your result and evidence here or in a separate file.

Review gate

A timing variance can be traced without overwriting the original plan.

If the gate is not met

Add version dates and an explanation column.

Final project

Submit the base plan, delayed-receipt plan, response comparison and review template. Demonstrate that changing one input updates every affected later opening balance. Explain why the same final balance can conceal a temporary shortfall.

Critical condition

A negative balance is visible and no unapproved borrowing is inserted to conceal it.

CriterionPointsEvidence
Evidence and correctness30Calculations, source use and results match the supplied case; limitations are honest.
Required artifacts30All five stage outputs and the capstone handoff are present and inspectable.
Reasoning and decisions20Choices, assumptions, alternatives and the case-specific critical condition are explained.
Reproducibility10A reviewer can follow the stated steps and distinguish expected from observed results.
Clear communication10Labels, units, structure and evidence references make the work easy to review.

Score at least 80/100, supply every required artifact, and satisfy the path-specific critical condition. Rework missing evidence before marking complete.

Worked reference

Base cash: 1,000 + 3,400 − 3,600 = 800 at quarter end. Moving 600 from February to March does not alter that total, but February falls from 500 to −100. Deferring a genuine optional February payment of 150 to March would make February 50 and leave March at 800.

Boundaries

This is budgeting practice with synthetic values, not personal investment, tax or borrowing advice.