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.