Assumption builder options
📘 MoM Fixed Change
MoM stands for Month-over-Month, and Fixed Change means the value increases or decreases by the same amount each month.
🔍 Plain-English Definition:
“MoM Fixed Change” means you’re forecasting a line item to go up or down by the same fixed amount every month—like adding £500 to your marketing budget each month, or reducing a cost by £200 monthly.
🧠 When to Use It in sherloc
This method is ideal when:
You expect steady growth or decline in a cost or revenue stream.
You’re building up a budget gradually (e.g. hiring one new staff member per month).
You want to model a phased rollout (e.g. increasing ad spend in fixed steps).
💡 Examples for UK SMEs
| Forecast Item | MoM Fixed Change Example | Why It Works Well |
| Marketing Spend | +£500/month increase | Gradual ramp-up |
| Software Subscriptions | +£100/month as new tools are added | Predictable growth |
| Freelance Costs | -£250/month reduction as projects wrap up | Controlled decline |
| Office Supplies | +£50/month for scaling team | Steady expansion |
✅ sherloc Tips
In sherloc, this method is great for non-seasonal, predictable changes.
Use it when you want to test the impact of gradual increases on cash flow.
Pair it with MoM % Change if you want to compare fixed vs. percentage-based growth.
📊 MoM % Change
🔍 Plain-English Definition:
“Month-over-Month Percentage Change” means the value increases or decreases by the same percentage every month.
💡 Example:
If your revenue is £10,000 in January and you apply a 5% MoM increase, February will be £10,500, March will be £11,025, and so on.
✅ When to Use:
You expect compounding growth or decline (e.g. viral product adoption, churn).
You want to model momentum-based changes (e.g. sales growing 10% monthly).
🧠 sherloc Tip:
Use this when forecasting scalable growth—especially for revenue, subscriptions, or variable costs that grow with volume.
💷 Fixed Amount
🔍 Plain-English Definition:
You enter a specific £ amount for each month—no automatic changes.
💡 Example:
Rent = £2,000 every month.
Insurance = £300/month flat.
✅ When to Use:
For stable, recurring costs or income.
When you know the exact amount and it doesn’t change.
🧠 sherloc Tip:
Use this for fixed overheads like salaries, rent, or subscriptions. It keeps your base forecast clean and predictable.
📌 % of Line Item
🔍 Plain-English Definition:
This method calculates a value as a percentage of another line item—like saying marketing is 10% of revenue.
💡 Example:
Revenue = £20,000
Marketing = 10% of revenue → £2,000
✅ When to Use:
For costs that scale with sales, like transaction fees, commissions, or marketing.
To keep forecasts proportional and dynamic.
🧠 sherloc Tip:
Use this for variable costs tied to performance. It helps you model realistic margins and cash flow.
📈 Fixed Percentage
🔍 Plain-English Definition:
You apply a fixed % rate to a base value—often used for things like VAT, payroll tax, or discounts.
💡 Example:
VAT = 20% of taxable sales
Staff pension = 3% of gross salary
✅ When to Use:
For regulatory or contractual rates.
When the percentage is known and stable.
🧠 sherloc Tip:
Use this for taxes, benefits, or discounts. It keeps your forecast compliant and consistent.
🗓️ Tip: Use “Calendar Period” or “One-Off” to Control Timing
🔍 What It Means:
When you choose Fixed % or Fixed Amount, sherloc lets you apply it either:
Across a calendar period (e.g. Jan–Mar, or Q2 only)
As a one-off in a specific month
This gives you precise control over when the cost or income hits your forecast.
💡 Why It’s Useful:
| Option | Use Case Example | Why It Helps |
| Calendar Period | £1,200 insurance spread over Jan–Dec | Smooths out annual costs into monthly impact |
| One-Off | £5,000 equipment purchase in March Or £500k fundraise in October | Models a single cash outflow accurately Or Models a single cash inflow accurately for your forecast operating working capital |
Why It Helps:
Models lumpy or infrequent cash movements accurately—so you don’t overestimate monthly liquidity or understate runway.
✅ Founder Tip:
“Use calendar period for costs you want to spread evenly, like insurance or software. Use one-off for big events—like a fundraising round, grant, or major purchase—so your forecast reflects real cash timing and investor expectations.”
OR
📘 sherloc Forecasting Glossary for Founders
For UK SMEs using sherloc to forecast cash flow, revenue, and costs—no finance jargon required.
🔢 Fixed Amount
Definition:
Enter a specific £ amount for each month—no automatic changes.
Example:
Rent = £2,000/month every month.
Use When:
You know the exact value and it doesn’t change.
Founder Tip:
Use this for stable costs like rent, salaries, or subscriptions. You can apply it as a one-off (e.g. £5,000 in March) or spread across a calendar period (e.g. £1,200 insurance over Jan–Dec).
📈 MoM Fixed Change (Month-over-Month Fixed Change)
Definition:
The value increases or decreases by the same £ amount each month.
Example:
Marketing spend grows by £500/month → Jan: £1,000, Feb: £1,500, Mar: £2,000...
Use When:
You’re scaling up or down gradually.
Founder Tip:
Great for phased rollouts—like hiring one person per month or slowly increasing ad spend.
📊 MoM % Change (Month-over-Month Percentage Change)
Definition:
The value increases or decreases by the same percentage each month—compounding over time.
Example:
Revenue grows 5% monthly → Jan: £10,000, Feb: £10,500, Mar: £11,025...
Use When:
You expect momentum-based growth or decline.
Founder Tip:
Use this for scalable revenue, subscriptions, or churn. It’s ideal for modeling viral growth or recurring income.
📌 % of Line Item
Definition:
Calculates a value as a percentage of another line item.
Example:
Marketing = 10% of revenue → Revenue = £20,000 → Marketing = £2,000
Use When:
Costs scale with sales or another driver.
Founder Tip:
Perfect for transaction fees, commissions, or marketing budgets tied to performance. Keeps your forecast dynamic and proportional.
💷 Fixed Percentage
Definition:
Applies a fixed % rate to a base value—often used for taxes, benefits, or discounts.
Example:
VAT = 20% of taxable sales
Pension = 3% of gross salary
Use When:
The percentage is known and stable.
Founder Tip:
Use this for regulatory costs or benefits. You can apply it once or over a calendar period to match timing (e.g. quarterly VAT payments).
🗓️ Calendar Period vs. One-Off
Definition:
Controls when a forecasted item appears.
| Option | Use Case Example | Why It Helps |
| Calendar Period | £1,200 insurance spread over Jan–Dec | Smooths out annual costs into monthly impact |
| One-Off | £5,000 equipment purchase in March | Models a single cash outflow accurately |
Founder Tip:
“Use calendar period for seasonal or annual costs you want to spread. Use one-off for big purchases or grants that hit once—so your forecast reflects reality.”