Financial Planning & Analysis - Retail

Key Tasks & Responsibilities1. Financial Planning & ForecastingPrepare monthly, quarterly, and annual forecasts across revenue, COGS, OPEX, and CAPEX.Support store-level P&L forecasts for new openings (sales ramp-up, break-even, staffing, rent, etc.).Build scenario models (best case, base case, worst case) for market expansion and sales promotions.2. BudgetingAssist in annual budgeting process: consolidate departmental budgets, validate assumptions, and prepare presentations.Implement a rolling budget update every quarter based on performance and business changes.3. Performance Reporting & KPI TrackingDesign and maintain weekly/monthly performance dashboards (Sales, EBITDA, Store Productivity, etc.).Track key retail KPIs:Sales per sq. ft.Average basket sizeStaff productivityInventory turnoverPromotion ROI4. Store & Brand-Level Profitability AnalysisEvaluate profitability by store, region, and brand.Recommend store-specific actions: staffing optimization, margin improvement, or cost reduction opportunities.Identify low-margin or non-performing categories needing support or replacement.5. Cash Flow Management & Cost ControlBuild and maintain a cash flow model (weekly and monthly).Monitor accounts payable/receivable aging with Finance and flag risks.Identify opportunities to improve working capital efficiency.6. Strategic Analysis & Business CasesBuild financial models for:New store openings (capex, payback, ROI)Supplier negotiations (minimum guarantees, rebates, marketing spend)Promotions and pricing strategiesPrepare investment cases and ROI calculations for strategic initiatives.7. Tools & SystemsSet up automated financial templates in Excel/Google Sheets/Power BI.Support onboarding of POS-to-Finance reporting automation if needed.8. Monthly Management Reporting PackPrepare structured decks for monthly review with you:Executive SummaryFinancial performance vs budgetKPI dashboardRisks and opportunitiesKey recommendations