A simple dynamic Excel model for financial forcast. It showcase Profit & Loss and scenario analysis.
• Revenue Forcasting: Calculates Revenue based on the number of orders and average order value.
• Expense Assumptions: Categorizes and predicts both variable expenses per order and fixed expenses (e.g., salary, marketing).
• Income Statement & Profit & Lost Margins: Combines revenue and expense data to create the income statement and calculating key margins like gross profit and operating profit.
• Dynamic Scenario Analysis: Allows comparison between upper case and lower case scenarios using different assumption sets.
• Hardcoded & Dynamic numbers: Differentiates inputs values entered directly and values linked to formulas or other cells.
• Formulas: IF & IFERROR functions for conditional tax calculations, along with CHOOSE function to switch between different scenario assumptions.
• Data Validation: Restricts input to specific values to reduce errors.