Bukola (Becky) Oyekunle

Three-Statement Model: Meridian (Industrial Engineering)

A fully linked income statement, balance sheet and cash flow statement for Meridian, a fictional industrial engineering manufacturer, built from publicly sourced industry data.

Status: complete

What the model does

• Income statement driven by revenue growth, gross margin and operating cost assumptions.
• Balance sheet with working capital (receivables, inventory, payables), fixed assets and depreciation, and debt.
• Cash flow statement derived from the other two statements, so the balance sheet balances every year.
• Supporting schedules for working capital, fixed assets and debt.

Why it matters

A three-statement model is the base for budgeting, forecasting and valuation. Building it from a blank sheet, with every formula written by hand, tests how well the three statements link together.

Files

Path	Contents
*.xlsx	The Excel model
screenshots/	Images of the key sheets