I'm opening a small neighbourhood bakery next spring. Build me a 12-month cash-flow spreadsheet I can actually edit: monthly rows for rent, flour and butter, wages, utilities, card fees, and a seasonality bump for December. Put my assumptions on their own tab so I can change one number and watch the year update. Give me the .xlsx.
The number worth knowing about this file is 86.
That's how many of its 154 formulas reach across to the Assumptions tab. The request said "change one number and watch the year update", and the difference between a workbook that does that and one that doesn't is invisible in a screenshot — both look like a tidy grid of numbers. Open the cells and you find out which one you got.
Two sheets, Assumptions and Cash Flow, the split the request asked for. Click any monthly figure and you land on a formula pointing back at the assumptions page, not a hard-typed number someone calculated once and pasted in. Nudge the December seasonality bump and the year moves.
Ninety seconds, and $0.375000 on Smart. Watch the run: https://elsedoes.com/share/f2bbb3f57c4e44f2bc403aca85d38b3c
neighbourhood_bakery_12_month_cash_flow.xlsx 6.8 KB
By Heei