Services / Modelling
Forecasts for the best, base and worst case
Budgets, cash flow forecasts and funding models built in Excel or Google Sheets. Change one assumption and every month, total and chart updates with it.
12-month cash forecast
Illustrative figuresMonthly salesCash balance
Closing cash, December0
Lowest cash balance0
Total sales for the year0
Assumptions
| Best | Base | Worst | |
|---|---|---|---|
| Monthly sales growth | 6% | 3% | -4% |
| Gross margin | 45% | 40% | 32% |
| Sales in January | 30,000 | ||
| Fixed costs a month | 11,000 | ||
| Opening cash | 40,000 | ||
Models I build
- Annual budgets and rolling forecasts
- Thirteen-week and monthly cash flow forecasts
- Funding and loan models, including repayment schedules and cover ratios
- Project reports for lenders
- Scenarios: what changes if sales drop, prices rise or a hire is delayed
How they're built
- Every assumption on one sheet, with its source stated
- Calculations driven by formulas, with no typed-in figures
- Profit and loss, balance sheet and cash flow linked together
- A checks sheet that flags errors in every period
- Built so you or your lender can follow it without me
We worked with Arya on a financial modelling project, and she did an excellent job. She built a flexible, input-driven model that we could reuse across multiple clients to understand the potential savings from implementing different systems. She used advanced Excel functions to make the model practical and easy to adapt simply by changing the inputs. This saved us a lot of time and made scenario analysis much easier. We would happily recommend Arya for financial modelling and analysis.
Advisory firmFinancial modelling
Need a forecast you can trust?
Tell me what the model is for, such as a budget, a loan application or an investor conversation, and the period it should cover.
Get in touch