Blu Containers Financial Model – README
File: Blu Containers Worksheet.xlsm (Excel 2019 / Microsoft 365 compatible)
Purpose
A self‑contained, 5‑year three‑statement model (2023‑2027) with Base / Best / Worst scenarios, built for the CFA PSM Financial Modeling assignment. Recruiters can open the workbook, tweak a few inputs, and instantly see earnings, cash‑flow and leverage impacts.
Quick Tour
Sheet
What you’ll see
Assumptions
Yellow input cells for volumes, pricing, cost inflation, capex, WC days & tax items. Scenario toggles sit top‑left.
IS_BS_CF
Fully linked Income Statement, Balance Sheet & Cash‑Flow (no circular refs).
Schedules
Revenue build, operating‑cost bridge, depreciation & capex, working‑capital, debt & revolver sweep.
Summary
Key KPIs and charts for each scenario. Print‑ready (A4 / Letter).
Macros: one lightweight VBA module only—drives the scenario buttons. Safe to disable if preferred (manual drop‑down works too).
Using the Model
Enable macros when prompted (optional, for one‑click scenario buttons).
On Assumptions, change yellow cells ➜ everything updates.
Choose Base, Best, or Worst via drop‑down or buttons.
Review impacts on Summary and integrated statements.
Ctrl + P: all key tabs are pre‑formatted for printing.
Base‑Case Headlines
Revenue CAGR: 4.6 %
2027 EBITDA margin: 27.4 %
2027 Free Cash Flow: $58 m
Net Debt / EBITDA falls 2.1× ➜ 0.6× over the forecast horizon
Build Notes
Model completed in <12 hours, following FAST‑style discipline (left‑to‑right flow, inputs separated, consistent lines).
Color‑coding: inputs yellow, hardcodes blue, calculations black, cross‑sheet links green.
No external links; workbook recalculates cleanly after Ctrl +Alt +Shift +F9.
Author: Khashayar Zarekarizi – 2025. For demonstration purposes only.