Tommy TUMler's working-capital control room

IB analyst difficulty Working capital, cash conversion cycle, and operating cash-flow bridge
Hide overview

Tommy's bike business has moved from small repairs into B2B fleet contracts. Revenue is growing, but cash is getting tight because customers pay slowly, inventory is building ahead of orders, and supplier terms only partly offset the cash drag. Your task is to analyze working capital like an investment-banking analyst: calculate net working capital, diagnose the cash conversion cycle, rebuild the operating cash-flow bridge, and identify the biggest cash-release levers.

Work through the analysis checkpoints first, then build the operating cash-flow bridge. Use the Analysis tab to diagnose the business, not just to get the cash movement to tie.

Full balance sheet

GAAP-style presentation: subsection headings carry rolled-up totals (similar to sell-side models). Operating adjustments for NWC sit in the working capital memo; tie them out in Analyst workflow › Net working capital.

Line item20252026Change
Assets
+95,000
Cash and cash equivalents
Reconciles to the cash-flow statement and is excluded from operating NWC.
+30,000
Short-term investments
Excluded from operating NWC.
+2,000
Accounts receivable
+22,000
Inventory
+35,000
Prepaid expenses
+4,000
Other current assets
+2,000
+41,000
Property, plant and equipment, net
+30,000
Intangible assets, net
+4,000
Right-of-use assets
+4,000
Long-term deposits
+2,000
Deferred tax assets
+1,000
Total assets
+136,000
Liabilities & equity
+46,000
Accounts payable
+18,000
Accrued payroll and bonus
+6,000
Customer deposits / deferred revenue
+11,000
Warranty accrual
+2,000
Current portion of debt
+4,000
Current lease liabilities
+1,000
Income taxes payable
+1,000
Other current liabilities
+3,000
+40,000
Long-term debt
+32,000
Lease liabilities
+4,000
Deferred tax liabilities
+2,000
Other provisions
+2,000
+50,000
Owner capital
+30,000
Retained earnings
+18,000
Other reserves
+2,000
Total liabilities & equity
+136,000
Working capital memo
Line item20252026Change
+61,000
Accounts receivable
+22,000
Inventory
+35,000
Prepaid expenses
+4,000
+37,000
Accounts payable
+18,000
Accrued payroll and bonus
+6,000
Customer deposits / deferred revenue
+11,000
Warranty accrual
+2,000
Operating net working capital
73,00097,000+24,000

Management targets (days)

Day-count targets for the models. Build operating NWC and ΔNWC from the balance sheet and memo using Analyst workflow › Net working capital.

Line item20252026Change
Target DSO
Target DIO
Target DPO

Click numeric cells needed for formulas. Pins show only while labels are surfaced for selected inputs.

Operating current assets, operating current liabilities, and operating net working capital are analyst constructs—use the memo and Analyst workflow, not GAAP balance-sheet captions.