Financial Planning & Analysis - Retail

Key Tasks & Responsibilities

1. Financial Planning & Forecasting

• Prepare 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. Budgeting

• Assist 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 Tracking

• Design and maintain weekly/monthly performance dashboards (Sales, EBITDA, Store Productivity, etc.).
• Track key retail KPIs:
• Sales per sq. ft.
• Average basket size
• Staff productivity
• Inventory turnover
• Promotion ROI

4. Store & Brand-Level Profitability Analysis

• Evaluate 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 Control

• Build 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 Cases

• Build financial models for:
• New store openings (capex, payback, ROI)
• Supplier negotiations (minimum guarantees, rebates, marketing spend)
• Promotions and pricing strategies
• Prepare investment cases and ROI calculations for strategic initiatives.

7. Tools & Systems

• Set up automated financial templates in Excel/Google Sheets/Power BI.
• Support onboarding of POS-to-Finance reporting automation if needed.

8. Monthly Management Reporting Pack

• Prepare structured decks for monthly review with you:
• Executive Summary
• Financial performance vs budget
• KPI dashboard
• Risks and opportunities
• Key recommendations