# The Financial Controller: companion files

Julian R. Sterling

## What is here

- **Financial_Controller_Model.xlsx**: the workbook that rebuilds the Harlan Instruments case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Close, Revenue, Variance, Covenant, Checks.
- **Financial_Controller_Toolkit.docx**: the checklists and templates of Appendix B (close calendar, reconciliations, journal entry review, cut-off, revenue contracts, variance commentary, covenant certificate, audit PBC list), in editable form.

## Which sheet answers which chapter

- Chapters 4 to 6: Close (the June 2026 corrections)
- Chapter 7: Revenue (allocation, monthly service revenue, deferred revenue)
- Chapter 9: Variance (volume, price, cost)
- Chapter 11: Covenant (add-backs, cap, leverage, cushion)

## Two inputs to change first

1. On Inputs, set the proposed lost-sales add-back to 1.5: see why the cap, not the refusal, decides what reaches covenant EBITDA.
2. On Inputs, lower the standalone price of the service plan to 300,000: watch the allocation, the 2026 revenue and the deferred revenue move. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light yellow background is an input, black type a formula. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Harlan Instruments, Westbrook Equity and Marrick Credit Partners are fictional; the models are simplified teaching models; all case figures are illustrative assumptions, not market terms, ratings or forecasts. Provided as is, without warranty. Not investment, legal, tax or accounting advice.
