Financial Analysis & Forecasting Model

I need a robust Excel-based model that pulls together my historical figures, highlights key performance indicators, and then rolls those insights into forward-looking forecasts. The workbook should let me toggle assumptions easily, compare best-, base-, and worst-case scenarios, and generate clear charts for presentations.

The raw numbers are ready for import, but they still require standardisation and error-checking before any calculations begin. Once cleaned, I want dynamic summaries that instantly recalculate whenever I update inputs such as growth rates, cost drivers, or seasonality factors.

Deliverables
• One consolidated Excel file with separate, well-labelled tabs for data, assumptions, calculations, and dashboards
• Built-in formulas (no hard-coding) and sensitivity tables for “what-if” analysis
• A short walkthrough video or annotated sheet so I can understand and maintain the model on my own

Accuracy and transparency are more important to me than flashy formatting, so please focus on logical structure, traceable formulas, and error controls.