Module VI· Model Architecture & DesignIntermediate
Question

How do you organize an assumptions tab?

Answer

Group assumptions by topic: transaction, operating forecast, margins, working capital, capex, tax, debt, valuation, scenarios, and outputs. Use clear units, sources, dates, and color coding. Keep assumptions close enough to the model to audit but centralized enough to run scenarios cleanly. Avoid duplicate assumptions in multiple tabs.