Managerial — Excel guide

Inward-facing accounting: how costs behave, where breakeven sits, and which costs should (and shouldn't) drive decisions.

Cost behavior & contribution margin

Fixed costs don't move with volume (rent); variable costs do (materials). Contribution margin = price − variable cost per unit: what each sale contributes toward fixed costs, then profit.

Costs that fool decision-makers

SUNK costs are spent and unrecoverable, irrelevant to what happens next, however painful. OPPORTUNITY cost is the value of the best alternative you give up, invisible on statements, central to decisions.

Variance analysis

Actual vs budget, split into price and quantity effects: did we pay more per unit, or use more units? Favorable/unfavorable labels beat raw differences because they carry direction.

Capital budgeting bridges

Payback period is the quick risk screen; NPV and IRR are the real decision tools, see the NPV & IRR cheat sheet on the finance side. WACC is the discount rate a company's NPVs should clear.

All Excel guides & practice on Excelympics