Finance & Accounting

F03 · Intermediate

Financial Statement Analysis

10 lessons

F03 · Module 2, lesson 3 · Lesson 5 of 10

Efficiency and working capital

Measure how hard a business makes its assets work and how long its cash is tied up: asset turnover, receivables, inventory and payables days, the operating and cash conversion cycles, the contract asset as revenue waiting to be billed, and why growth eats cash.

About 70 minutes

Before you start

You will be able to

  • Calculate asset turnover and fixed-asset turnover, on average balances, and adjust a part-year for comparison.
  • Calculate receivables, inventory and payables turnover and their days, choosing the flow that matches each balance (credit sales billed, cost of goods sold, purchases).
  • Calculate the operating cycle and the cash conversion cycle, and interpret a negative cycle such as Amazon’s.
  • Measure a contract asset as days of revenue tied up, and explain why it belongs neither in receivables days nor out of the analysis.
  • Estimate the cash that growth absorbs, and the cash released by changing credit, stock or supplier terms.

Review first

  • Liquidity — Liquidity measures the stock of working capital at one date; this lesson measures how fast it turns over.
  • Receivables and payables — Net receivables, the allowance, credit terms and payables come from there.
  • Inventory and cost of goods sold — Inventory turnover uses cost of goods sold, which that lesson builds.
  • The indirect method — Working-capital changes in the indirect method are the cash side of the same story.

Fictional case A fictional coffee business founded by Ana Lim. It starts as a catering and barista-training service, opens its own cafés and an online shop for beans, and plans a canned cold brew.

The idea

Fictional case

Lantern’s revenue tripled in 2027, yet its operations brought in only $8,341 of cash against $39,940 in its first ten months. Ana wants to know where the cash went. Part of the answer is in the liquidity lesson: the cafés were paid for in cash. The rest is in how long Lantern’s money now waits at each stage between buying beans and being paid by customers, and that is what efficiency ratios measure.

Efficiency ratios (also called activity or turnover ratios) compare a flow from the income statement with a balance from the balance sheet. A turnover divides the flow by the balance: how many times a year the balance is used up and replaced. Days divides the balance by the flow per day: how long the balance would last, or how long an item waits on average. The two say the same thing, upside down: days = days in the period ÷ turnover.

Two families matter. Asset turnover asks how much revenue each dollar of assets generates; it is one of the three drivers of return on equity in module 3. The working-capital days follow cash around the operating cycle: the business buys stock on credit (payables days), holds it (inventory days), sells it on credit (receivables days) and finally collects the cash. The cash conversion cycle is the number of days the business itself must finance between paying its suppliers and being paid by its customers.

The operating cycle (inventory days plus receivables days) and the part of it the business finances itself, the cash conversion cycle.
Lantern’s efficiency ratios (fictional)
Measure2026 (ten months, closing balances)2027 (average balances)
Asset turnover2.06 (2.48 annualised)2.74
Fixed-asset turnover5.20 (6.24 annualised)8.72
Receivables days (DSO), on invoiced catering34.537.2
Inventory days (DIO), on cost of goods sold33.417.1
Payables days (DPO), on purchases on account39.818.0
Cash conversion cycle (days)28.136.3

Days use 304.17 days for 2026’s ten months and 365 for 2027. 2026 has no opening balance sheet, so it uses closing balances.

Lantern made its assets work harder: each dollar of average assets produced $2.74 of revenue in 2027, against $2.48 (annualised) in 2026, and its equipment and fit-out turned over 8.72 times. Stock moved faster too, 17.1 days against 33.4. But catering clients took longer to pay (37.2 days against 34.5), Lantern paid its own suppliers much faster (18.0 days against 39.8), and the cycle it must finance lengthened from 28.1 to 36.3 days. That comparison mixes bases (2027 on averages, 2026 on closing balances) and understates the change: on closing balances in both years, 2027’s figures are 45.5 days of receivables, 21.2 of inventory and 18.0 of payables, a cycle of 48.6 days against 28.1. Above all, $30,840 of revenue sits in the contract asset, which none of these ratios counts. The rest of the lesson builds each measure and then puts the pieces together.

In depth

Asset turnover

Asset turnover is revenue divided by average total assets; fixed-asset turnover uses average property and equipment, net, instead. Because revenue is earned over the whole year and assets change during it, the average of the opening and closing balances is the better divisor. Lantern 2027: average total assets (93,676+327,883)÷2=210,779.5(93{,}676 + 327{,}883) \div 2 = 210{,}779.5, so asset turnover is 577,860÷210,779.5=2.74577{,}860 \div 210{,}779.5 = 2.74. For 2026 there is no opening balance sheet (Lantern started on 1 March with nothing), so the closing balance stands in, and the ten months of revenue must be annualised before comparing: 193,320×12÷10÷93,676=2.48193{,}320 \times 12 \div 10 \div 93{,}676 = 2.48.

Asset turnover depends on the business model as much as on management. A café chain with leased premises has a different asset base from a roaster that owns its plant. And since ASC 842 the right-of-use asset for leased premises is in total assets: Lantern’s $173,379 of right-of-use assets is more than half its year-end total. Leaving it out, average assets would be $124,090 and asset turnover 4.66. Neither figure is wrong; compare like with like.

Receivables: turnover and days

Receivables turnover divides credit sales by average net receivables; days sales outstanding (DSO) turns it into days: the average number of days customers take to pay. Only sales on credit create receivables, so only they belong in the numerator. Lantern’s café, shop and workshop sales are paid at the till or online at once; only catering is invoiced on 30-day terms.

Even catering revenue needs care. Lantern’s 2027 catering revenue of $118,360 includes $30,840 for the law firm, which is in the contract asset and has never been billed, and $1,640 for January events paid for by deposits in 2026. Neither passed through accounts receivable. The sales that did were the $85,880 invoiced in the year. Matching flow and balance:

DSO2027=Receivables‾Credit sales×365=8,74785,880×365=37.2 days\text{DSO}_{2027} = \dfrac{\overline{\text{Receivables}}}{\text{Credit sales}} \times 365 = \dfrac{8{,}747}{85{,}880} \times 365 = 37.2 \text{ days}

Using all catering revenue gives 27.0 days, and using total revenue 5.5 days: both divide receivables by sales that never became receivables, so both understate how long clients take to pay. The aging schedule is consistent with 37.2: of the $11,460 owed at the year end, $3,060 was more than 30 days old, past Lantern’s terms. For 2026, with closing receivables of $6,796 and $59,920 invoiced in ten months, DSO is 6,796÷59,920×304.17=34.56{,}796 \div 59{,}920 \times 304.17 = 34.5 days. The days in a ten-month period are 365×10÷12=304.17365 \times 10 \div 12 = 304.17; using 365 with ten months of sales would overstate the days by a fifth.

The contract asset: revenue waiting to be billed

The contract asset is not a receivable, so it stays out of DSO. It is still working capital: cash Lantern has earned and is waiting for. Measure it in days of revenue. At 31 December 2027 it held 30,840÷577,860×365=19.530{,}840 \div 577{,}860 \times 365 = 19.5 days of Lantern’s total revenue, and 274 days, nine months, of the law firm’s fee: every event since April. Counting it as if it were a receivable, DSO would be 75.6 days. That figure mixes two kinds of asset and is not a collection measure, but it shows a lender how much of Lantern’s revenue is still outside its bank account. Whether 2027’s profit is as good as it looks, given that $30,840 of it rests on a CPI estimate and one client, is the cash-flow-quality lesson’s question.

Inventory: turnover and days

Inventory turnover divides cost of goods sold by average inventory; days inventory outstanding (DIO) is the average number of days stock waits before it is sold. Cost of goods sold, not revenue, because inventory is carried at cost. Lantern’s cost of sales, $224,205, also includes $61,080 of cost of services (event baristas and catering supplies), which never passed through inventory, so use cost of goods sold, $163,125:

DIO2027=Inventory‾COGS×365=7,637.5163,125×365=17.1 days\text{DIO}_{2027} = \dfrac{\overline{\text{Inventory}}}{\text{COGS}} \times 365 = \dfrac{7{,}637.5}{163{,}125} \times 365 = 17.1 \text{ days}

With the whole cost of sales the answer is 12.4 days, which flatters the stock. For 2026, 5,800÷52,800×304.17=33.45{,}800 \div 52{,}800 \times 304.17 = 33.4 days. Lantern’s stock moves faster now because café stock (milk, pastries, cups) is used within days, while bagged beans for the shop can wait for weeks. A blended ratio hides that, and a business with very different product lines is better analysed line by line where the data allow.

Payables: turnover and days

Days payables outstanding (DPO) is the average number of days the business takes to pay its suppliers: average payables divided by purchases on credit, times the days. Purchases, not cost of goods sold, because payables arise when goods are bought, and Lantern’s payables include supplies and unpaid utility bills as well as beans. In 2027 Lantern bought $187,780 on account ($166,800 of stock, $19,800 of supplies and $1,180 of December utility bills): 9,245÷187,780×365=18.09{,}245 \div 187{,}780 \times 365 = 18.0 days. In 2026, 9,210÷70,430×304.17=39.89{,}210 \div 70{,}430 \times 304.17 = 39.8 days. When purchases are not disclosed, as for most public companies, analysts use cost of goods sold (or cost of sales) and say so.

The 2026 figure is inflated by the year end. Lantern bought heavily for the December gift peak, so its payables at 31 December were high compared with an average month, and with no opening balance there is nothing to average against. Kilnworth’s terms are 30 days in both years. A year-end balance in a seasonal business can mislead any days ratio; quarterly balances, where available, give a better average.

The operating cycle and the cash conversion cycle

The operating cycle is inventory days plus receivables days: how long from buying stock to collecting cash for it. Suppliers finance part of it; the cash conversion cycle is the rest:

CCC=DIO+DSO−DPO\text{CCC} = \text{DIO} + \text{DSO} - \text{DPO}

Lantern 2027: 17.1+37.2−18.0=36.317.1 + 37.2 - 18.0 = 36.3 days, against 28.1 in 2026. Read it with care for a mixed business: it is a composite of two different flows, and no real cash flow runs through both. The 37.2 days of DSO apply only to catering, about 15% of revenue, a service business whose cycle is its collection period less whatever supplier credit its supplies get. The goods sold in the cafés and the shop are paid for at once, so their cycle is inventory days less payables days, 17.1−18.0=−0.917.1 - 18.0 = -0.9 days: they are paid for their stock a little before they pay for it. A firm-wide figure, with receivables measured in days of total revenue, is 5.5+17.1−18.0=4.65.5 + 17.1 - 18.0 = 4.6 days. Each view answers a different question; the composite 36.3 is best used only to compare like with like over time. The cycle has lengthened on every basis, and Lantern now pays its suppliers within 18 days though their terms allow 30: as cash grew scarce, it was not taking the credit it was offered.

A negative cycle: Amazon

A business that sells its stock quickly, is paid at once and pays its suppliers late can have a negative cash conversion cycle: its suppliers finance its operations and growth adds cash rather than using it. Amazon’s 10-K figures for 2013 and 2014 show it.

Amazon.com, Inc.: working-capital days (average balances, 365 days)
Measure20132014
Receivables days (on total net sales)21.021.3
Inventory days (on cost of sales)45.345.7
Payables days (on cost of sales)95.891.9
Cash conversion cycle-29.5-24.9

Computed from Amazon’s consolidated balance sheets (31 December 2012, 2013 and 2014) and statements of operations. Receivables are Amazon’s “accounts receivable, net and other”; credit sales and purchases are not disclosed, so total net sales and cost of sales are used. At 31 December 2014 accounts payable ($16,459 million) exceeded inventories and receivables together ($13,911 million).

For Amazon, each extra dollar of sales brought cash in before the stock had to be paid for. For Lantern’s catering the opposite holds: each extra invoiced event ties up cash for as long as the client takes to pay, about 37 days, and the law firm’s contract for up to a year.

How growth consumes working capital

When the cycle is positive, working capital grows with sales: more receivables, more stock, partly offset by more payables. A rough rule:

Operating working capital≈Credit sales×DSO365+COGS×DIO365−Purchases×DPO365\text{Operating working capital} \approx \text{Credit sales} \times \dfrac{\text{DSO}}{365} + \text{COGS} \times \dfrac{\text{DIO}}{365} - \text{Purchases} \times \dfrac{\text{DPO}}{365}

If the days stay the same, operating working capital grows in proportion to sales, and that increase is cash the business must find before it can spend its profit. The indirect method shows Lantern’s 2027 bill: working capital absorbed $33,890, of which $30,840 was the contract asset, $3,902 the increase in receivables and $3,675 the increase in stock, partly offset by $2,960 more unearned revenue and $2,200 more wages payable. That is why $22,431 of net income and $19,800 of depreciation became only $8,341 of cash from operations.

Formulas

Asset turnover

Asset turnover=RevenueTotal assets‾\text{Asset turnover} = \dfrac{\text{Revenue}}{\overline{\text{Total assets}}}
Revenue\text{Revenue}
Net revenue for a twelve-month period (annualise a part-year)$
Total assets‾\overline{\text{Total assets}}
Average of opening and closing total assets (closing if there is no opening balance sheet)$

Times a year. Lantern 2027: 2.74. Fixed-asset turnover uses average property and equipment, net (Lantern 2027: 8.72).

Fixed-asset turnover

Fixed-asset turnover=RevenuePP&E, net‾\text{Fixed-asset turnover} = \dfrac{\text{Revenue}}{\overline{\text{PP\&E, net}}}
Revenue\text{Revenue}
Net revenue for the period$
PP&E, net‾\overline{\text{PP\&E, net}}
Average property, plant and equipment, net of accumulated depreciation; right-of-use assets excluded unless stated$

Lantern: 5.20 (2026, ten months), 8.72 (2027).

Receivables turnover and days sales outstanding

DSO=DaysReceivables turnover=Receivables‾Credit sales×Days\text{DSO} = \dfrac{\text{Days}}{\text{Receivables turnover}} = \dfrac{\overline{\text{Receivables}}}{\text{Credit sales}} \times \text{Days}
Receivables‾\overline{\text{Receivables}}
Average of opening and closing net receivables (not contract assets)$
Credit sales\text{Credit sales}
Sales billed on credit during the period: the sales that passed through receivables$
Days\text{Days}
Days in the period: 365 for a year, 304.17 for ten monthsdays

Assumes. Receivables turnover = credit sales ÷ average receivables. When credit sales are not disclosed, total revenue is used and the result understates the days.

Lantern 2027: 8,747÷85,880×365=37.28{,}747 \div 85{,}880 \times 365 = 37.2 days.

Inventory turnover and days inventory outstanding

DIO=Inventory‾COGS×Days\text{DIO} = \dfrac{\overline{\text{Inventory}}}{\text{COGS}} \times \text{Days}
Inventory‾\overline{\text{Inventory}}
Average of opening and closing inventory$
COGS\text{COGS}
Cost of goods sold for the period (not cost of services)$
Days\text{Days}
Days in the perioddays

Assumes. Inventory turnover = COGS ÷ average inventory.

Lantern 2027: 17.1 days (turnover 21.36).

Payables turnover and days payables outstanding

DPO=Payables‾Purchases×Days\text{DPO} = \dfrac{\overline{\text{Payables}}}{\text{Purchases}} \times \text{Days}
Payables‾\overline{\text{Payables}}
Average of opening and closing accounts payable$
Purchases\text{Purchases}
Purchases on credit for the period; cost of goods sold when purchases are not known (say so)$
Days\text{Days}
Days in the perioddays

Purchases = COGS + closing inventory − opening inventory, when all stock is bought on credit. Lantern 2027: 18.0 days.

Operating cycle and cash conversion cycle

CCC=DIO+DSO−DPO\text{CCC} = \text{DIO} + \text{DSO} - \text{DPO}
DIO\text{DIO}
Days inventory outstandingdays
DSO\text{DSO}
Days sales outstandingdays
DPO\text{DPO}
Days payables outstandingdays

The operating cycle is DIO + DSO. Lantern 2027: CCC 36.3 days; operating cycle 54.3 days. Amazon 2014: −24.9 days.

Contract asset in days of revenue

Contract asset days=Contract assetRevenue×Days\text{Contract asset days} = \dfrac{\text{Contract asset}}{\text{Revenue}} \times \text{Days}
Contract asset\text{Contract asset}
Revenue earned but not yet billable, at the year end$
Revenue\text{Revenue}
Total revenue for the period, or the revenue of the contract concerned$
Days\text{Days}
Days in the perioddays

Lantern 2027: 19.5 days of total revenue; 274 days of the law firm’s fee.

Worked examples

A first example: Lantern’s receivables and inventory days, 2027

Fictional figures

Lantern’s net receivables were $6,796 at 31 December 2026 and $10,698 at 31 December 2027; it invoiced $85,880 of catering in 2027. Its inventory was $5,800 and $9,475, and cost of goods sold $163,125. Calculate receivables and inventory turnover and days for 2027.

  1. Average receivables: (6,796+10,698)÷2=8,747(6{,}796 + 10{,}698) \div 2 = 8{,}747. Receivables turnover: 85,880÷8,747=9.8285{,}880 \div 8{,}747 = 9.82. DSO: 365÷9.82=37.2365 \div 9.82 = 37.2 days.
  2. Average inventory: (5,800+9,475)÷2=7,637.5(5{,}800 + 9{,}475) \div 2 = 7{,}637.5. Inventory turnover: 163,125÷7,637.5=21.36163{,}125 \div 7{,}637.5 = 21.36. DIO: 365÷21.36=17.1365 \div 21.36 = 17.1 days.
  3. Check the flows: the invoiced catering is the only revenue that went into receivables, and cost of goods sold (not the cost of services) is what left inventory.

Answer. Receivables turnover 9.82, DSO 37.2 days; inventory turnover 21.36, DIO 17.1 days.

What it means. Catering clients take about a week longer than Lantern’s 30-day terms, consistent with the aging schedule; stock sells in a little over two weeks on average.

A harder example: The cash conversion cycle, both years, and what changed

Fictional figures

Calculate Lantern’s cash conversion cycle for 2026 and 2027 and explain the change. For 2026 use closing balances and 304.17 days: receivables $6,796, invoiced catering $59,920; inventory $5,800, COGS $52,800; payables $9,210, purchases on account $70,430. For 2027 use averages and 365 days, with payables of $9,280 at the year end and purchases on account of $187,780.

  1. 2026: DSO 6,796÷59,920×304.17=34.56{,}796 \div 59{,}920 \times 304.17 = 34.5; DIO 5,800÷52,800×304.17=33.45{,}800 \div 52{,}800 \times 304.17 = 33.4; DPO 9,210÷70,430×304.17=39.89{,}210 \div 70{,}430 \times 304.17 = 39.8. CCC 34.5+33.4−39.8=28.134.5 + 33.4 - 39.8 = 28.1 days.
  2. 2027: DSO 37.2 and DIO 17.1 (simple example). Average payables (9,210+9,280)÷2=9,245(9{,}210 + 9{,}280) \div 2 = 9{,}245; DPO 9,245÷187,780×365=18.09{,}245 \div 187{,}780 \times 365 = 18.0. CCC 37.2+17.1−18.0=36.337.2 + 17.1 - 18.0 = 36.3 days.
  3. Change: +8.2 days. Inventory days fell by 16.3 (good), receivables days rose by 2.7, and payables days fell by 21.8. The payables change dominates.
  4. Check the basis: 2026 uses closing balances, 2027 averages. On closing balances in both years, 2027 gives DSO 10,698÷85,880×365=45.510{,}698 \div 85{,}880 \times 365 = 45.5, DIO 9,475÷163,125×365=21.29{,}475 \div 163{,}125 \times 365 = 21.2, DPO 9,280÷187,780×365=18.09{,}280 \div 187{,}780 \times 365 = 18.0: a cycle of 48.6 days against 28.1. The mixed-basis comparison understates the deterioration.
  5. Judgement: part of the payables change is the 2026 year end (December’s heavy buying, no opening balance to average); part is real: Lantern paid within 18 days though Kilnworth allows 30.

Answer. CCC 28.1 days (2026) and 36.3 days (2027) on the usual bases, mainly because payables days fell from 39.8 to 18.0; on closing balances in both years the 2027 cycle is 48.6 days.

What it means. Lantern is financing more of its own cycle at the very time cash is short. Taking the full 30 days its supplier allows is the cheapest finance it has.

Applied: a business decision: Releasing cash from working capital

Fictional figures

Ana considers three changes for 2028 (all hypothetical): (a) ask the law firm to pay each quarter’s fee at the quarter end instead of the whole year in arrears; (b) pay Kilnworth at its full 30 days rather than in about 18, and then negotiate 45 days; (c) cut stock by three days of cost of goods sold. Estimate the cash each would have released at the end of 2027, and compare it with the cost of the line of credit (9% a year).

  1. (a) Quarterly billing: at 31 December only the fourth quarter’s fee would be outstanding, 41,120×3÷12=10,28041{,}120 \times 3 \div 12 = 10{,}280, as a receivable on 30-day terms. Cash released: 30,840−10,280=20,56030{,}840 - 10{,}280 = 20{,}560.
  2. (b1) Taking the full 30 days instead of about 18, on stock purchases of $166,800: 166,800÷365×12=5,484166{,}800 \div 365 \times 12 = 5{,}484, released for nothing, since the terms already allow it.
  3. (b2) A 45-day deal adds fifteen more days: 166,800÷365×15=6,855166{,}800 \div 365 \times 15 = 6{,}855. At 9% that saves about 6,855×0.09=6176{,}855 \times 0.09 = 617 a year of interest on the line of credit; if Kilnworth wanted even 1% more on its prices ($1,668) for the longer terms, the deal would cost more than it saves.
  4. (c) Three days of stock: 163,125÷365×3=1,341163{,}125 \div 365 \times 3 = 1{,}341, with some risk of running out at the cafés.
  5. Ranking: (a) is worth about 1.7 times (b1) and (b2) together and fifteen times (c), and costs only a conversation with one client, who may want something in return. (b1) is free and should be done at once.

Answer. About $20,560 from quarterly billing; $5,484 from paying Kilnworth at its full 30 days and $6,855 more from a 45-day deal (worth it only if the price doesn’t rise); and $1,341 from three fewer days of stock.

What it means. Working capital is cash. Lantern’s biggest lever is not its beans or its suppliers but one contract’s billing terms; a lender would rather see that changed than see the credit line drawn further.

Explore

Asset and fixed-asset turnover from opening and closing balances. Start from Lantern’s 2027, then reproduce 2026 (ten months, no opening balance sheet) and see what annualising and the choice of average or closing balances do.

Loading the interactive…

Working-capital days for Lantern and for Amazon in 2014. Untick “Receivables days on credit sales only” to see the classic slip; tick the contract-asset box to see what DSO would be if the law firm’s unbilled fee were counted as a receivable.

Loading the interactive…

How much cash does growth absorb? Start from Lantern’s 2027 catering-and-stock figures, then change the days and the growth rate.

Loading the interactive…

Common mistakes

  • Using total revenue for receivables days

    Most of Lantern’s sales are paid at once, so dividing catering receivables by total revenue gives 5.5 days and hides a collection period of 37.2. Use sales on credit; if they are not disclosed, say that the result understates the days.

  • “Catering revenue is credit sales.”

    Only revenue that was invoiced on credit created receivables. Lantern’s catering revenue includes the law firm’s unbilled $30,840 and $1,640 of events paid by deposit; using it all gives 27.0 days instead of 37.2.

  • Inventory turnover on revenue or on all cost of sales

    Inventory is carried at cost, so divide cost of goods sold by it. Revenue includes the margin and overstates turnover; cost of sales that includes services (Lantern’s event baristas) does too: 12.4 days instead of 17.1.

  • Closing balances when averages are available

    A flow earned over the year belongs with the year’s average balance. Lantern’s 2027 DSO on closing receivables would be 45.5 days, overstated because receivables grew during the year. Use closing balances only when there is no opening balance sheet, as for 2026, and say so.

  • Ten months of flow, 365 days

    A ten-month period has 304.17 days. Lantern’s 2026 inventory days computed with 365 would be 40.1 rather than 33.4. Either use the period’s days or annualise the flow; both give the same answer.

  • “A shorter cash conversion cycle is always better.”

    Paying suppliers late lengthens DPO but can cost discounts and goodwill; cutting stock can mean empty shelves; tight credit terms can lose clients. The cycle measures cash tied up, not the best way to run the business.

Guided practice

Work through these with hints when you need them. Every hint and every worked solution is there to be used.

Loading four questions…

On your own

No hints this time. Answer, check, and read the feedback; the solution appears once you have answered or if you ask for it. Your first answers count toward mastery.

Loading five questions…

In practice

A cash forecast built on days. Lantern’s accountant forecasts 2028 working capital from days rather than guessing balances. If catering invoices grow to about $120,000 and clients still take 37.2 days, receivables will average about $12,230; if purchases on account reach $200,000 and Lantern takes Kilnworth’s full 30 days, payables will average about $16,438, $7,193 more than in 2027. Each assumption is a lever someone can be held to: the credit controller for DSO, the café managers for stock, Ana for supplier terms.

A lender’s view of the contract asset. Coastline’s credit officer adds a line to her review: 19.5 days of Lantern’s revenue is waiting for a single billing date. Concentration matters as much as the days. If the law firm disputes the CPI adjustment or delays payment, Lantern’s March 2028 cash plan fails. She asks for the contract and its payment terms, which is what an analyst should do whenever a contract asset is large.

Comparing models. An analyst comparing Lantern with an online retailer or a café chain should expect very different cycles: Amazon’s was −24.9 days in 2014, because its suppliers waited longer to be paid than its stock and its customers took together. The point of comparison is not the level but the direction and the reason: a cycle lengthening because clients pay late is a warning; one lengthening because the business stocks up for a launch may be a plan.

Knowledge check

Six questions, one attempt each, no hints. Score 80% or more to complete the lesson; you can take it again at any time.

Loading six questions…

Summary

  • Efficiency ratios divide a flow by a balance (turnover) or a balance by the flow per day (days); days = days in the period ÷ turnover.
  • Match the flow to the balance: credit sales billed for receivables, cost of goods sold for inventory, purchases for payables. Use average balances where an opening balance sheet exists, and the period’s days (304.17 for ten months) or annualised flows for part-years.
  • Lantern 2027: asset turnover 2.74 (2.48 annualised in 2026); DSO 37.2 days on invoiced catering; DIO 17.1 days on cost of goods sold; DPO 18.0 days on purchases; cash conversion cycle 36.3 days (28.1 in 2026), or 48.6 days on closing balances like 2026’s, so the deterioration is larger than the mixed-basis figures suggest.
  • A contract asset is not a receivable and stays out of DSO, but it is working capital: Lantern’s $30,840 is 19.5 days of total revenue and nine months of the law firm’s fee.
  • The cash conversion cycle (DIO + DSO − DPO) is the part of the operating cycle the business finances itself; it can be negative, as Amazon’s was (−24.9 days in 2014).
  • When the cycle is positive, growth absorbs cash in proportion to sales; Lantern’s working capital absorbed $33,890 in 2027, $30,840 of it in the contract asset.

Key formulas

Terms introduced

Turnover
In ratio analysis, a flow for a period divided by the balance that produces it, such as revenue ÷ average total assets: how many times a year the balance is used and replaced.
Days sales outstanding
Average net receivables divided by credit sales, times the days in the period: the average number of days customers take to pay. Abbreviated DSO.
Days inventory outstanding
Average inventory divided by cost of goods sold, times the days in the period: the average number of days stock is held before it is sold. Abbreviated DIO.
Days payables outstanding
Average accounts payable divided by purchases on credit (or cost of goods sold when purchases are not known), times the days in the period: the average number of days the business takes to pay its suppliers. Abbreviated DPO.
Cash conversion cycle
Inventory days plus receivables days minus payables days: the number of days between paying suppliers and collecting from customers that the business must finance itself.

Sources

  1. Dahlquist, J. & Knight, R. (2022). Principles of Finance, section 6.2, “Operating Efficiency Ratios”. OpenStax. openstax.org/books/principles-finance/pages/6-2-operating-ef…
  2. U.S. Securities and Exchange Commission (2007). Beginners’ Guide to Financial Statements (inventory turnover). sec.gov/reportspubs/investor-publications/investorpubsbegfin…
  3. Amazon.com, Inc. (2015). Form 10-K for 2014: consolidated balance sheets (SEC EDGAR financial report R7). sec.gov/Archives/edgar/data/1018724/000101872415000006/R7.ht…
  4. Amazon.com, Inc. (2015). Form 10-K for 2014: consolidated statements of operations (SEC EDGAR financial report R3). sec.gov/Archives/edgar/data/1018724/000101872415000006/R3.ht…
  5. Amazon.com, Inc. (2014). Form 10-K for 2013: consolidated balance sheets, with 31 December 2012 (SEC EDGAR financial report R7). sec.gov/Archives/edgar/data/1018724/000101872414000006/R7.ht…