New on FinoLib · Volume IV: Finance Careers
New on FinoLib, my finance education website: I have published an article called Month-End Close Failure, Cash Forecast Slip and IPO Readiness, from Volume IV: Finance Careers. Here is what the article explains, written as a short expert briefing; the full piece, with every worked example, is one click away.
F.1 The Month-End Close Fails
The idea in plain words
Sometimes the month-end close finds a real error late. Then the Controller moves the date, books the fix and logs the failed control, and the CFO tells the auditor and the audit committee chair. Nothing is restated because the numbers had not yet been issued, but the control failure still counts in the SOX evaluation.
Key points
■A $4.8m missed accrual cuts operating income 7.7% and net income $3.6m after tax.
■At 1.6 times planning materiality, the auditor will weigh a significant deficiency.
A closer look
Each scenario in Part F uses an illustrative company with invented, internally consistent numbers, in USD. Here it is a manufacturer with about $1.2 billion of revenue that closes in five business days (C.1: The Controller). It is day 4 of the September quarter-end close. The flux review shows freight and outside-services expense down 30% against August with no volume change, and the goods-received-not-invoiced (GRNI) accrual is $4.8 million lower than the purchasing system says it should be: an interface from the receiving system dropped two days of receipts, so the accrual was never booked. Before the fix, quarterly operating income is $62.0 million and pre-tax income $60.0 million; the earnings call is in 12 days.
Decision rule
An interface completeness control: every day, receipts count and value in the receiving system are compared with what landed in the ERP, and any difference above zero is cleared before the next run. Evidence an auditor accepts: the system-generated comparison report for each day of the quarter, the exception log with resolution dates, and the GL manager’s dated sign-off, plus a monthly GRNI reconciliation reviewed by the Controller. Internal Audit closes the finding only after the control has run cleanly for a full quarter.
Recap
When the close finds a real error late, the Controller moves the date, books the fix and logs the failed control, and the CFO tells the auditor and audit committee chair. Nothing is restated because the numbers were not yet issued.
F.2 The Cash Forecast Deteriorates
The idea in plain words
When the cash forecast gets worse, each role has a job. The Treasurer owns the 13-week forecast and the conversation with lenders. FP&A reforecasts EBITDA, and the Controller books the credit loss.
Key points
■Headroom = covenant multiple × EBITDA − net debt.
■A $12m bad receivable, with lost margin and stranded inventory, can turn 3.00× leverage into a 3.56× breach.
A closer look
An illustrative specialty-chemicals company has $520 million of revenue, a $200 million term loan and a $150 million revolving credit facility. Its loan agreement tests net leverage (net debt ÷ trailing twelve-month EBITDA) at no more than 3.50× each quarter-end, plus a $25 million minimum liquidity floor. Last quarter: net debt $240 million, EBITDA $80 million, leverage 3.00×. In week 3 of the quarter, the largest customer (12% of sales) stops paying a $12 million receivable and announces a restructuring. The Treasurer’s 13-week cash forecast (C.2: The Treasurer) shows the quarter-end test, in week 9, failing.
Decision rule
Two controls, both evidenced. First, a weekly forecast-to-actual variance review of the 13-week forecast with a set tolerance (for example ±5% of receipts), signed by the Treasurer, with every miss explained. Second, the quarterly covenant calculation, prepared by treasury, reperformed by the Controller’s team from the general ledger using the loan agreement’s own EBITDA definition, and signed by the CFO before the compliance certificate goes to the agent bank. An auditor accepts the signed calculation, its tie-out to the ledger and the forecast variance log.
F.3 The IPO Is Six Months Away
The idea in plain words
Six months before an IPO, the CFO runs a readiness program: PCAOB-standard audits, closing the books like a public company, a disclosure committee and an investor relations function. The costs of getting ready are expensed, while the direct costs of the offering are deferred and netted against the money raised.
Key points
■EGCs show two years of audited statements and skip the 404(b) attestation.
■$250m raised less a 6.5% discount and $4.5m of costs credits $229.25m to equity.
Decision rule
A disclosure committee and sub-certification process that runs before the S-1 is filed: each owner of a number or statement (revenue, the cap table, the key metrics, legal matters) signs a sub-certification, the committee minutes record its review, and the CEO and CFO sign the registration statement only after that. Evidence an auditor and underwriters’ counsel accept: signed sub-certifications, minutes, a tick-and-tie binder linking every S-1 number to a source, and the comfort letter itself.
What the full article covers
In the full article I take you through these sections:
■F.1 The Month-End Close Fails
■F.2 The Cash Forecast Deteriorates
■F.3 The IPO Is Six Months Away
It includes worked examples, a clear decision rule, a recap, a reveal-on-click quiz and the official sources behind every figure.
Volume IV: Finance Careers
Read the full article on FinoLib
The complete article, Month-End Close Failure, Cash Forecast Slip and IPO Readiness, with every worked example, diagram, quiz and source, is free to read in Volume IV, Finance Careers on finolib.com.
Explore the Finance Education Series: Vol. II — Capital Markets · Vol. I — Global Economy · Vol. III — Finance Encyclopedia · Vol. IV — Finance Careers · Vol. V — Personal Finance