Revenue Quality and Capitalized Cloud Costs at Redwood
Redwood Industrial reports FY2023 revenue of $480 million, up 12% from $428.6 million, and EBITDA of $96 million. Days sales outstanding rose from 45 days to 68 days; accounts receivable ended at $89.4 million versus $52.9 million a year earlier. Management says the increase reflects 'strategic payment terms' for new large customers. Redwood also capitalized $28 million of 'cloud implementation costs' in 2023 and is amortizing them over five years. The vendor contract runs three years and can be terminated for convenience with 90 days' notice. Reported interest expense is $40 million, and the main covenant requires EBITDA/interest of at least 2.5x. The company changed its revenue recognition for bill-and-hold sales, recognizing $22 million when goods were segregated but still in Redwood's warehouse; the customer had not requested the arrangement and Redwood retains physical control. Inventory days fell from 90 to 62, and the CFO's bonus is tied to EBITDA.
1. Quantify the key red flags and estimate adjusted revenue, adjusted EBITDA, and the covenant ratio. State assumptions.
Read the worked answer
Reported revenue is $480m. The $22m bill-and-hold sale is questionable because the customer did not request it and Redwood retains physical control, so control may not have transferred. Adjusted revenue is approximately $458m. DSO of 68 days implies receivables of $89.4m; at the prior 45-day policy, receivables would be about $480m x 45/365 = $59.2m, so there is about $30m of excess receivables. That is not automatically a revenue reversal, but it is a strong warning that revenue may be overstated or collections are deteriorating.
For EBITDA, start with $96m. If the $28m cloud cost is a current-period operating cost, EBITDA falls by $28m. If the $22m bill-and-hold sale carried a 30% gross margin, remove another $6.6m. Adjusted EBITDA is roughly $61.4m, with a range of about $61m-$64m depending on the gross margin. The covenant ratio is reported EBITDA/interest = 96/40 = 2.40x, already below the 2.5x requirement. On adjusted EBITDA, 61.4/40 = 1.54x, a clear breach. Even excluding the bill-and-hold adjustment, 68/40 = 1.70x. The analyst should confirm the covenant's EBITDA definition, because add-backs could change the result, but the direction is unambiguous.
2. How should the cloud implementation costs be treated under IFRS and US GAAP? What is the impact on ROA and leverage of correcting the amortization period?
Read the worked answer
Under IFRS, configuration and customization costs in a cloud computing arrangement are capitalized only if the entity controls the software or the asset meets intangible asset recognition criteria; otherwise they are expensed as incurred under IAS 38. Under US GAAP, implementation costs for a hosting arrangement may be capitalized under ASC 350-40 and amortized over the hosting term, including reasonably certain renewal periods. Here the contract is three years and terminable for convenience, so a five-year life is not supportable under either framework. If the costs are capitalized, amortization should be over three years or shorter: $28m/3 = $9.33m versus $5.6m reported, an additional $3.73m. EBIT falls by $3.73m and net income by about $2.8m at a 25% tax rate.
If the costs should be expensed, assets fall by $28m less any amortization, equity falls by the after-tax amount if already tax-effected, and current-year EBITDA falls by $28m. ROA is ambiguous: expensing lowers both numerator and denominator, so ROA may rise if the asset was unproductive. Leverage (debt/assets) rises because assets are lower. The main point is that the five-year amortization overstates near-term profit and understates expense, and the contract term makes the accounting aggressive.
3. Identify management incentives and five diligence questions; explain how the bonus and inventory decline interact with revenue recognition risk.
Read the worked answer
The CFO bonus tied to EBITDA creates incentives to capitalize costs, recognize bill-and-hold revenue, and manage working capital to support EBITDA. Falling inventory days (90 to 62) while DSO rises (45 to 68) is a classic warning: inventory may have been shipped to customers or distributors ahead of demand, or sales may be recognized without cash collection. It can also reflect a real change in product mix, so it needs corroboration.
Five diligence questions: (1) What are the terms, side agreements, and customer acceptance provisions for the $22m bill-and-hold sales? (2) Why did DSO rise, and what are the payment terms and collection experience for the new large customers? (3) What is the exact nature of the $28m cloud costs, and who controls the software? (4) What is the amortization period, and what renewal or termination assumptions support it? (5) What inventory was sold, to whom, and were there returns or channel-stuffing indicators? Also ask for post-year-end cash collections and a reconciliation of revenue to cash. The bonus should be disclosed as a governance red flag, and compensation should be assessed after adjusting for capitalized costs and working-capital changes.