Urgent 12-Month Cashflow Forecast

I need a seasoned financial modeller who can turn around a fully-linked, month-by-month cashflow forecast for the next twelve months today. I already have the underlying management accounts, recent bank statements and working files; you will build on these, not start from scratch. Every figure in the model must reconcile back to the Income Statement, Balance Sheet and Statement of Cash Flows so that lenders can trace assumptions straight through to the three-statement output.

Core requirements
– Model three scenarios side-by-side (base, optimistic, downside) with toggles that make sensitivities clear at a glance.
– Document every assumption inside the workbook and in a brief accompanying memo so reviewers see exactly how revenue drivers, margin movements, capex timing, interest charges and tax treatments were derived.
– Provide a separate tab that highlights monthly net cash movement, cumulative cash position, and the precise point at which the runway is exhausted under each case.
– Ensure all formulas are transparent, no hard-codes outside the assumptions section, and the file is easy for another analyst to audit.

Acceptance criteria
• File delivered in Excel (.xlsx) before close of business today (my local time is GMT+1).
• Balance sheet balances each month in every scenario.
• Cashflow statement cross-checks to the net change in cash.
• Clear colour-coding and consistent formatting applied throughout.
• A one-page PDF summary of key insights and risks.

If you are confident you can meet the timeline and quality bar, I will share the existing data immediately so you can begin.