Module 6: Course 2 Capstone: Normalizing Vanguard Industrial Machining
Worked teaching capstone. The graded student packet withholds the complete solution.
Learning objectives and prerequisites
By the end of this lesson, you should be able to defend a two-year normalization and liquidity model. Prerequisite knowledge: All preceding modules. Work from assumptions to equations, explain the acquisition consequence, and record the evidence needed to rely on the answer.
The investment decision behind the assignment
Vanguard Industrial Machining produces precision components for regional equipment manufacturers. Its founder wants to retire after decades of managing production and key accounts. Annual revenue is $4.5 million, and the broker describes substantial owner benefits that allegedly make the company's reported earnings conservative. You are responsible for determining what an acquirer can actually rely on.
The assignment combines source reconciliation, tax interpretation, accounting correction, economic normalization, and a linked operating forecast. A successful submission is not the highest possible EBITDA. It is a reproducible explanation of the earnings and cash that the buyer receives, together with the conditions that could change the conclusion.
All amounts are actual US dollars. Vanguard is fictional. This packet controls the capstone even where earlier chapters used separate demonstration figures. The base normalization assumptions match Modules 3 and 5; Module 4's revised evidence case remains a separate sensitivity. The stated forecast taxes and debt terms are teaching assumptions, not advice about a particular acquisition structure.
The information environment
The seller provides an accrual internal P&L, a year-end balance sheet, a general-ledger export, tax-preparer workpapers, payroll records, asset schedules, and selected invoices. The bookkeeper reconciles bank accounts monthly but has not consistently reconciled the inventory subledger to physical stock. The owner approves large journal entries and negotiates both customer pricing and the related-party property lease.
This environment explains why competent acquisition analysis needs more than an annual income statement. The records can be useful without constituting an audit. The owner's combined managerial and ownership role creates normalization questions, while the inventory control weakness creates an accounting question. Those findings should not be merged into a single unsupported “owner add-back” amount.
Historical incentives also matter. The owner preferred legal tax deductions while operating the company and now emphasizes expenses that might disappear after a sale. Neither preference establishes the correct earnings. You must test which costs affected the selected starting metric, which are recurring, and what replacement organization the buyer needs.
The reported income statement
The P&L separately presents D&A below EBITDA. The direct production costs in the table therefore exclude the D&A shown later. Manufacturing overhead includes ordinary production support but excludes the separately listed repairs. There is no entity income-tax expense in these historical S-corporation accounts and no nonoperating income. Owner-level income taxes are outside the company statements.
| Reported annual income statement | Amount |
|---|---|
| Revenue | $4,500,000 |
| Materials and subcontracted production | ($1,350,000) |
| Direct production payroll and burden | ($1,250,000) |
| Other manufacturing overhead | ($400,000) |
| Gross profit before separately presented D&A | $1,500,000 |
| Officer compensation | ($300,000) |
| Office and administrative payroll | ($220,000) |
| Related-party facility rent | ($90,000) |
| Machine repairs | ($60,000) |
| Owner personal truck operating expenses | ($24,000) |
| Owner personal travel | ($12,000) |
| Other operating expenses | ($254,000) |
| Reported EBITDA | $540,000 |
| D&A | ($150,000) |
| EBIT | $390,000 |
| Interest expense | ($55,000) |
| Book net income | $335,000 |
Operating expenses before D&A total $960,000, leaving $540,000 from $1,500,000 gross profit. Your first check is to reproduce that arithmetic, then tie the totals to source accounts. A discrepancy at the starting point contaminates every later adjustment, even if the normalization formulas themselves are correct.
The tax-preparer reconciliation
The filed return's ordinary business income is $255,000 under this simplified packet. Book depreciation is $150,000, tax depreciation is $240,000, and a separate $10,000 expense within other operating costs is nondeductible for tax. There are no separately stated income or deduction items and no other differences affecting this explanatory endpoint.
The bridge is $335,000 + $10,000 + $150,000 − $240,000 = $255,000. The tax income is lower than book income because the $90,000 additional tax depreciation exceeds the $10,000 nondeductible expense. The IRS Form 1120-S instructions provide the authoritative reporting context; this packet is a simplified reconciliation rather than an actual return.
The nondeductible $10,000 is not an add-back to economic EBITDA merely because tax rules disallow it. Assume it is a necessary recurring business cost. Conversely, accelerated tax depreciation is not a hidden EBITDA benefit because EBITDA already excludes book D&A. Your memo should explain both distinctions before turning to owner adjustments.
The inventory error described next was discovered after the supplied tax workpapers were prepared. Do not silently modify the filed return. Flag the need for tax-adviser review of correction timing, deductibility, and any filing consequences. The opening-balance teaching case ignores any resulting historical tax asset or liability; the forecast's 25% tax assumption applies prospectively only.
Diligence findings and accepted base assumptions
A physical count and valuation review identify $20,000 of missing stock and $20,000 of unusable material within reported ending inventory. Both arose during the reported year, neither has recovery value, and neither was previously expensed or reserved. Reduce inventory and current-year pretax earnings by $40,000. This is an accounting correction, not a discretionary owner adjustment.
The owner's $300,000 compensation is supported by payroll records. The base hiring plan replaces all continuing owner functions with a fully burdened $180,000 general manager. For this exercise, no separate engineer, salesperson, or supervisor is required beyond costs already included. Transition overlap and recruitment are excluded from recurring EBITDA and must be identified separately if proposed.
The $24,000 truck operating costs and $12,000 travel are verified personal expenses that reduced EBITDA. No replacement operating cost is required under the base case. These amounts are not vehicle purchase price, depreciation, debt principal, or owner distributions. Those distinctions prevent an attractive but duplicated add-back.
A supported replacement facility lease costs $150,000 on the same total occupancy basis as the existing $90,000 lease. The operating company therefore needs a $60,000 negative adjustment. The real estate remains outside the acquisition case, and no property value is included in operating earnings or assets.
The $60,000 repair invoice contains $20,000 of exceptional excess expense. Multi-year evidence supports keeping $40,000 as the normal annual repair allowance. Only $20,000 is removed. There are no other accepted adjustments, unimplemented price increases, synergies, or assumed unreported sales.
Reconstruct normalized earnings
Begin with book net income and recover reported EBITDA: $335,000 + $55,000 interest + $150,000 D&A = $540,000. Correct inventory to reach $500,000 historical EBITDA. Then apply the recurring economic adjustments.
| Earnings reconstruction | Amount |
|---|---|
| Reported EBITDA | $540,000 |
| Inventory correction | ($40,000) |
| Corrected historical EBITDA | $500,000 |
| Remove officer compensation | +$300,000 |
| Include replacement general manager | ($180,000) |
| Remove personal truck costs | +$24,000 |
| Remove personal travel | +$12,000 |
| Increase facility rent | ($60,000) |
| Remove exceptional repair excess | +$20,000 |
| Normalized managed EBITDA | $616,000 |
| Less unchanged D&A | ($150,000) |
| Normalized EBIT | $466,000 |
Corrected historical book net income is $295,000 before any historical tax-correction consequence: $335,000 − $40,000. The $616,000 EBITDA is a normalized comparison, not the company's historical bank receipts. Under the disclosed one-owner SDE convention, earnings before paying for the replacement owner's role are $796,000. Your recommendation must identify whether the buyer is purchasing a managed business, a full-time job, or a combination.
Correct the opening balance sheet
The seller's reported ending inventory is $540,000 and reported equity is $1,080,000. Other balances are cash $200,000, receivables $600,000, prepayments $40,000, net PP&E $900,000, trade payables $350,000, operating accruals $150,000, and financial debt $700,000. Reported total assets and liabilities plus equity both equal $2,280,000.
Apply the $40,000 stock correction to inventory and accumulated equity. Corrected assets become $2,240,000, with inventory $500,000 and equity $1,040,000. No cash leaves when this correction is recorded. The loss reflects a reduction in recorded economic resources, not a new cheque written at the forecast's start.
For the capstone, treat these corrected balances as the opening standalone operating balance sheet. Do not add acquisition goodwill, replacement financing, purchase consideration, or new investor equity. A full acquisition model would require those separate transaction assumptions; introducing them here without a funded schedule would make the case irreproducible.
Year 1 forecast instructions
Forecast revenue growth of 5% and preserve the normalized EBITDA margin of $616,000 divided by $4,500,000. The resulting Year 1 revenue is $4,725,000 and EBITDA is $646,800. Grow receivables, corrected inventory, prepayments, payables, and operating accruals by 5%. Assume this scaling captures all operating working-capital balances in the simplified case.
Use D&A of $160,000 and cash CapEx of $220,000. All D&A reduces the modeled PP&E category; there are no separate intangibles, disposals, impairment charges, or leases requiring additional schedules. The supplied asset schedule incorporates the forecast's timing convention.
Financial debt bears 8% interest on opening principal, with $100,000 principal repaid at year-end and no new borrowing. Owner distributions are $120,000 at year-end. Prospective cash income taxes are 25% of positive pretax income and paid currently, with no tax-balance movements. This is a hypothetical buyer-planning tax convention, not a representation of Vanguard's historical entity taxation.
Minimum required operating cash is $180,000. Annual results alone are insufficient to prove intra-year liquidity, so identify the need for a monthly or 13-week schedule even after completing the annual balance sheet.
Year 1 solution: net income through operating cash
EBIT is $646,800 − $160,000 = $486,800. Interest is $700,000 × 8% = $56,000. Pretax income is $430,800, cash taxes are $107,700, and net income is $323,100.
Ending operating balances are receivables $630,000, inventory $525,000, prepayments $42,000, payables $367,500, and accruals $157,500. NWC rises from $640,000 to $672,000. Consequently, OCF is $323,100 + $160,000 − $32,000 = $451,100.
Net income -> operating cash -> ending cash
Net income 323,100
D&A 160,000
NWC investment (32,000)
Operating cash flow 451,100
Cash CapEx (220,000)
Debt principal (100,000)
Distributions (120,000)
Change in cash 11,100
Opening cash 200,000
Ending cash 211,100
The $40,000 historical inventory correction does not appear again as forecast expense or spending. It already changed the opening stock and equity. Your model should distinguish inventory investment from noncash recognition of a loss rather than automatically treating every inventory decrease as cash collected.
Year 1 solution: the balance-sheet check
Ending net PP&E is $900,000 + $220,000 − $160,000 = $960,000. Debt ends at $600,000. Equity ends at $1,040,000 + $323,100 − $120,000 = $1,243,100. Cash links from the cash-flow statement rather than being selected to force the accounting equation.
| Balance-sheet reconciliation | Year 1 |
|---|---|
| Cash | $211,100 |
| Receivables | $630,000 |
| Inventory | $525,000 |
| Prepayments | $42,000 |
| Net PP&E | $960,000 |
| Assets | $2,368,100 |
| Payables | $367,500 |
| Accruals | $157,500 |
| Debt | $600,000 |
| Equity | $1,243,100 |
| Liabilities plus equity | $2,368,100 |
| Difference | $0 |
An auditor of your workbook should be able to trace each balance to one schedule and reproduce every statement without inserting a residual “other asset.” A zero difference supports mechanical consistency; it does not independently validate the assumptions or source records.
Extend the model into Year 2
Continue 5% sales growth and the same normalized EBITDA margin. Grow Year 1 operating NWC balances another 5%. Use Year 2 D&A of $170,000, CapEx of $230,000, principal repayment of $100,000, and distributions of $120,000. Interest remains 8% of opening debt, and the prospective tax convention remains unchanged.
Year 2 revenue is $4,961,250 and EBITDA is $679,140. EBIT is $509,140; interest is $48,000; pretax income is $461,140; taxes are $115,285; net income is $345,855. NWC ends at $705,600, a $33,600 investment. OCF is therefore $345,855 + $170,000 − $33,600 = $482,255.
Cash ends at $211,100 + $482,255 − $230,000 − $100,000 − $120,000 = $243,355. Net PP&E is $1,020,000, debt is $500,000, and equity is $1,468,955. Receivables are $661,500, inventory $551,250, prepayments $44,100, payables $385,875, and accruals $165,375. Total assets and liabilities plus equity both equal $2,520,205.
The Year 2 exercise tests whether the model rolls forward dynamically. If the learner copied Year 0 opening balances into every forecast year, the statements may look reasonable individually while failing the sequence. Every Year 2 opening amount should link to Year 1 ending balances.
Downside analysis and the decision memorandum
Run a separate Year 1 sensitivity with EBITDA $80,000 below base, an additional $50,000 ending receivable balance, and an additional $30,000 cash CapEx. Keep D&A, interest, distributions, and principal unchanged for this isolated test. Taxable income remains positive, so the EBITDA reduction lowers net income by $60,000 after tax.
OCF falls by $60,000 from earnings and $50,000 from collection delay, reaching $341,100. CapEx rises to $250,000. Ending cash becomes $71,100, which is $108,900 below the required $180,000 floor. A smaller distribution can improve liquidity, but cannot make lost earnings or slow collections disappear.
Seller Tricks & Red Flags: paper adjustments offered as funding.
The owner may argue that an omitted add-back “covers” the shortfall. Unless the expense truly disappears and cash is retained at the required time, that statement does not fund payroll. Model the cash mechanism and obtain evidence.
The memorandum should state whether base earnings are supported, whether the operating organization is complete, and whether the proposed distribution policy is prudent. Explain how tax reconciliation, inventory control, related-party occupancy, customer concentration, and replacement management affect reliance. A recommendation to proceed conditionally, revise economics, or decline can all be correct when supported by the case.
Self-Study Problem Set and Assessment
Problem 1: distinguish three earnings measures
Calculate reported EBITDA, corrected historical EBITDA, and normalized managed EBITDA. Explain why none is the same as bank-account growth.
Solution moved to the separate instructor key.
Problem 2: rebuild the Year 2 equity balance
Starting from Year 1 ending equity, calculate Year 2 equity and identify the effect of an additional $50,000 owner distribution.
Solution moved to the separate instructor key.
Problem 3: link downside cash to the balance sheet
For the stated Year 1 downside, calculate ending receivables, PP&E, equity, and total assets. Show that the cash deficit does not require a balancing plug.
Solution moved to the separate instructor key.
Problem 4: specify evidence that could change the conclusion
The general-manager replacement quote excludes customer sales work, and the founder says the buyer can handle that personally. What should the analyst do?
Solution moved to the separate instructor key.
Submission standard and grading
Submit a linked workbook containing source mapping, book-to-tax reconciliation, reported and corrected history, normalization, two forecast years, and downside checks. Accompany it with a three-page acquisition memorandum and an adjustment register. The reader should be able to distinguish verified facts, assumptions, and unresolved issues without reconstructing your research process.
Allocate 20 points to source and tax reconciliation, 25 to accounting correction and normalization, 30 to statement integration, 15 to liquidity and downside analysis, and 10 to recommendation quality. A passing self-assessment requires 80/100 and no unresolved balance-sheet difference, cash plug, repeated inventory correction, or undisclosed minimum-cash breach. Defensible caution earns credit; unsupported optimism does not.
Spreadsheet construction and audit lab
Reconcile source income to tax, correct opening inventory and equity once, then forecast two years using prior ending balances. Reproduce the repair and collection downside without modifying the base silently.
Use named row labels and explicit units. Blue-font inputs should contain assumptions or source data; black-font formulas should calculate results from those inputs. Reproduce the worked example first, then change one economically important assumption and predict the direction of the result before recalculating. Save a base case and a dated challenge case rather than silently replacing assumptions. A zero arithmetic check does not establish an executable deal.
Learning summary and further reading
Defend a two-year normalization and liquidity model. The acquisition decision depends on the bridge between source evidence, modeled cash and the claim being valued. Explain what the model includes, what it omits, and which outstanding evidence could reverse your conclusion. Consult the source and alignment references for attributed public reading; fictional case assumptions are not market observations or legal approvals.
Previous module · Course overview · Course 3 overview
Independent assessment
Complete the student assignment before consulting the separate instructor key. The chapter's worked examples teach the method; the assignment uses independent inputs.