{"product_id":"electricity-distribution-case-study-financial-model-unsolved","title":"Electricity Distribution Case Study - Financial Model (Unsolved)","description":"\u003cp\u003eA genuine corporate finance modelling test, preserved exactly as a candidate sees it - no answers, no shortcuts, no solution sheet. You build a full integrated model from three years of historical financials and a one-page brief, against the clock.\u003c\/p\u003e\n\u003cp\u003eWHAT YOU GET\u003c\/p\u003e\n\u003cp\u003eBlank model (Excel): a Test Info tab, a Key Assumptions tab, and three years of historical financial statements, with the candidate build areas ready to complete.\u003c\/p\u003e\n\u003cp\u003eCase brief (PDF): the full instructions, company overview, and every assumption you need, branded and clean.\u003c\/p\u003e\n\u003cp\u003eTHE EXERCISE\u003c\/p\u003e\n\u003cp\u003eBuild an integrated annual model (Income Statement, Balance Sheet, Cash Flow) for a manufacturer over five forecast years (2026-2030): sales price and volume growth, a variable\/fixed operating cost split with inflation, capex and straight-line depreciation, deferred-tax timing differences, fixed-rate and variable (BBSW-linked) term debt with a revolver for cash shortfalls, plus dividends and share buybacks. Add your own assumptions where gaps exist and keep the model dynamic and printable.\u003c\/p\u003e\n\u003cp\u003eWHAT IT TESTS\u003c\/p\u003e\n\u003cp\u003e3-statement integration, debt and revolver mechanics, depreciation schedules, tax, and clean, logical model structure under a two-hour time limit.\u003c\/p\u003e\n\u003cp\u003eWHO THIS IS FOR\u003c\/p\u003e\n\u003cp\u003eCandidates targeting corporate finance, FP\u0026amp;A, and graduate analyst roles, and anyone preparing for a timed financial modelling test. Uses Australian rate conventions (BBSW).\u003c\/p\u003e\n\u003cp\u003eWHAT'S NOT INCLUDED\u003c\/p\u003e\n\u003cp\u003eNo answer key. No model solution. No walkthrough video. This is a workout, not a tutorial.\u003c\/p\u003e\n\u003cp\u003eLICENCE\u003c\/p\u003e\n\u003cp\u003eSingle-user licence. For your own preparation. Do not redistribute, resell, or post in shared drives, Discord servers, or Notion pages.\u003c\/p\u003e","brand":"Alex Euripidou","offers":[{"title":"Default Title","offer_id":52165507449128,"sku":null,"price":20.0,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0989\/1043\/7672\/files\/ElectricityDistributionCaseStudy-FinancialModel_Unsolved_-mockup_dc6657dc-3caa-40f6-92d1-9ae3b78a913f.png?v=1785292071","url":"https:\/\/alexeuripidou.com\/products\/electricity-distribution-case-study-financial-model-unsolved","provider":"Alex Euripidou","version":"1.0","type":"link"}