Revenue forecasting: build a price-and-volume driver model
Build a monthly revenue forecast in Excel from contract and job drivers, reconcile the annual bridge, and test changes in pricing and additions.
THE FINX JOURNAL LEARN BY DOING
Better models.
Clearer thinking.
Practical guides to Excel and financial modeling. Work through the details, understand the mistakes, and build with more confidence.
Keep building your understanding
PAGE 4
Unlevered beta: remove and reapply leverage in a peer analysis
Strip peer leverage with the Hamada formula on a fictional comps set, relever to the target's capital structure, and catch the basis and order errors that distort the result.
Cash conversion cycle: DIO, DSO and DPO in one worked example
Calculate the cash conversion cycle from a year of financials, see why the answer depends on stated conventions, and turn a longer cycle into the extra cash it funds.
Days sales outstanding: calculate DSO and forecast receivables
Calculate DSO three ways on a seasonal distributor, catch the year-end snapshot that flatters collections, and turn a defended day-count into a forecast receivables balance.
Depreciation schedule in Excel: connect capex, depreciation and net PP&E
Build a three-year property and equipment schedule in Excel: a cohort table for the charge, roll-forwards for gross and accumulated, and the checks.
IRR vs XIRR: choose the return calculation that matches the dates
Apply Excel's IRR and XIRR to the same irregularly dated investment, watch the two answers disagree, and learn which function reads the calendar and which only counts rows.