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.
THE FINX JOURNAL LEARN BY DOING
Better models.
Clearer thinking.
Practical guides to Excel and financial modelling. Work through the details, understand the mistakes, and build with more confidence.
Keep building your understanding
PAGE 3
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.
Scenario analysis in Excel: base, upside and downside cases
Switch a finance model between base, upside and downside cases with one driver cell, check each case with hand calculations, and see how scenarios differ from sensitivity grids.
WACC formula: assemble and audit the discount rate
Assemble Northgate's WACC in Excel from a transparent, cell-by-cell assumptions table, cross-check it two ways, and see how a 0.37-point error moves a terminal value.