Build a three-month cash plan, reconcile opening and closing balances and test a delayed-receipt scenario.
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.
| Month | Receipts | Payments |
|---|---|---|
| January | 800 | 1100 |
| February | 1400 | 1600 |
| March | 1200 | 900 |
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.
Write the planning assumptions and label every column as cash or non-cash.
Cash planning policy
Record your result and evidence here or in a separate file.
The 1,000 opening balance is not counted as new monthly revenue.
Separate opening resources from current-period receipts.
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.
Create the three-month cash table and a whole-period reconciliation.
Base cash plan
Record your result and evidence here or in a separate file.
Closing balances are 700, 500 and 800; the final balance also reconciles directly.
Trace cell references and check the opening balance is used once.
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.
Move 600 of February receipts to March and recalculate every balance.
Delayed-receipt scenario
Record your result and evidence here or in a separate file.
The balances become 700, -100 and 800, with the same quarter-end total.
Do not subtract the delay in February without adding it to March.
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.
Compare deferring 150 of optional February payments with obtaining an earlier confirmed receipt.
Response options
Record your result and evidence here or in a separate file.
Each response names an approval owner and distinguishes a proposal from an agreement.
Replace a balancing plug with a named, testable assumption.
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.
Create a monthly actual-versus-plan template and a trigger for updating the forecast.
Review sheet
Record your result and evidence here or in a separate file.
A timing variance can be traced without overwriting the original plan.
Add version dates and an explanation column.
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.
A negative balance is visible and no unapproved borrowing is inserted to conceal it.
| Criterion | Points | Evidence |
|---|---|---|
| Evidence and correctness | 30 | Calculations, source use and results match the supplied case; limitations are honest. |
| Required artifacts | 30 | All five stage outputs and the capstone handoff are present and inspectable. |
| Reasoning and decisions | 20 | Choices, assumptions, alternatives and the case-specific critical condition are explained. |
| Reproducibility | 10 | A reviewer can follow the stated steps and distinguish expected from observed results. |
| Clear communication | 10 | Labels, 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.
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.
This is budgeting practice with synthetic values, not personal investment, tax or borrowing advice.