This project builds a fully linked three-statement financial model for a fictitious company, Blu Containers — a manufacturer of environmentally friendly water storage tanks made from recycled materials. The model projects the Income Statement, Balance Sheet and Cash Flow Statement and links them into a single, transparent structure.
Using the model outputs, I calculate key profitability, leverage and cash-flow ratios, run scenarios and sensitivities, and evaluate whether Blu Containers would be a suitable addition to an investor’s portfolio.
Blu Containers is positioned as a growth company in the sustainable infrastructure space. An investor considering the company needs to understand:
- How revenues, margins and reinvestment drive future earnings and cash flows.
- Whether the capital structure and liquidity profile are appropriate for the level of risk.
- How different assumptions (growth, pricing, costs, capex) change intrinsic value and key ratios.
This model is designed to support that decision-making process.
- Integrated Income Statement, Balance Sheet and Cash Flow Statement
- Driver-based assumptions for revenue, margins, operating costs and capex
- Ratio analysis: growth, margins, returns, leverage and coverage
- Scenario and sensitivity analysis on key value drivers
- Summary outputs that can be used to form an investment view and recommendation for different investor risk/return profiles
- Open the Excel file
Model Sample.xlsx. - Review and adjust the assumptions (revenue growth, margins, capex, etc.).
- Inspect the financial statements and ratio tabs to see how the company performs under each scenario.
- Use the outputs to form a view on whether Blu Containers fits a given investor’s objectives and constraints.
Model/Model Sample.xlsx– main three-statement model for Blu Containers.
README.md– project overview and usage guide.