Financial Statements Model (Telus).
Model type: Scenario analyses (2 independent drivers)
Forecast period: 5 years (yearly)
Data type: External – Financial Statements (six years)
Software: Excel, VBA
Financial model - current asset analysis, credit line calculation.
Model type: Scenario analysis (2 independent drivers), Statistical forecast analysis, Interactive Dashboard (historical)
Forecast period: 2 years (monthly and quarterly)
Data type: Internal – Monthly Sales Data (four years)
Software: Excel, VBA, Power Query
Financial model - sales report (historical/ forecasted). Data models.
Model type: Sales Report, Two Interactive Dashboards (historical & forecasted), Two Data Models
Forecast period: 1 year (monthly )
Data type: Internal – Monthly Sales Data (2,5 years)
Software: Excel, Power Query, Power Pivot