Every SMB owner eventually builds a spreadsheet. Cash flow projections in Excel. Break-even calculations in Google Sheets. Custom dashboards pulling from QuickBooks exports. The spreadsheet is what owners build because they cannot afford dedicated tools and because it feels like it should be solvable in a spreadsheet. Sometimes it is. Often it produces precise arithmetic on the wrong inputs, and the owner mistakes the precision for accuracy.
The Two Different Questions
Spreadsheet-based DIY (Excel/Sheets) answers: "What can I model in a spreadsheet?"
The Aldebert Diagnostic answers: "What does Aldebert doctrine say about this business?"
Two different questions. Both matter. Confusing them is where owners lose time and money.
Side by Side
| DIY spreadsheets | The Aldebert Diagnostic (RTO + MMP + Layer Cake) | |
|---|---|---|
| Primary job | Custom modeling in Excel or Sheets | Doctrinal diagnostic on the business |
| Doctrine embedded | Whatever the owner builds | Full Aldebert Financial Ecosystem |
| MMP calculation | Only if owner knows how to build it | Pre-built with five sub-layers grossed for taxes |
| Working Capital treatment | Only if owner builds Required-vs-Actual | Native to the diagnostic |
| Layer Cake | Almost never in DIY spreadsheets | The core five-layer model |
| Time to build | Days to weeks depending on complexity | 10 business days for the written verdict |
| Update cadence | Whenever the owner has time | Continuous diagnostic reading |
| Best use | Simple modeling and scenario testing | Full diagnostic reading on the business |
What DIY spreadsheets Does Well
A well-built spreadsheet is a powerful tool. Owners with strong Excel skills can model scenarios, run sensitivity analysis, and build custom dashboards that fit the specific quirks of their business. For simple businesses with straightforward economics, a spreadsheet can suffice for years. The cost is only the owner's time, which owners often forget to price. When it works, it works.
What the Aldebert Diagnostic Adds
The Aldebert Diagnostic is what the spreadsheet was trying to become. It has doctrine embedded. It does not require the owner to know that MMP has five sub-layers or that debt service needs to be grossed at 1.30-to-1. It comes with the questions pre-built. The five layers of Layer Cake. The Working Capital Required vs Actual comparison. The Realized vs Intended margin cascade. Owners who try to build the equivalent in a spreadsheet almost always miss two or three sub-layers because they have not been taught the doctrine that produced them.
The Missing Sub-Layer Test
Ask an owner running a DIY spreadsheet: does your spreadsheet include an Owner Compensation sub-layer restated to market rate? Usually no.
Does it include a Retirement Funding sub-layer? Usually no.
Does it include an Exit Strategy funding requirement? Almost never.
Does it gross Debt Service for taxes at 1.30-to-1? Rarely.
Does it compare Working Capital Required against Actual? Sometimes, roughly.
Does it compare Realized Gross Margin against Intended? Very rarely.
The spreadsheet is arithmetic without doctrine. The Aldebert Diagnostic is doctrine plus arithmetic. Both matter. The doctrine is what most owners cannot produce on their own because it took twenty-six years of practice to codify.
How They Work Together
For simple businesses with straightforward economics, a spreadsheet may suffice for tactical work. For any business asking questions the spreadsheet doctrine cannot answer, run the Aldebert Diagnostic. After the diagnostic identifies the important measurements, a spreadsheet can be a good tool for tracking them going forward. The spreadsheet is a fine tool. It is a poor doctrine.
Frequently Asked Questions
Can I build the Aldebert Diagnostic in a spreadsheet?
In theory yes. In practice, most owners cannot because the doctrine (five MMP sub-layers, Layer Cake structure, Working Capital Gap, cascade effect) is not obvious from reading standard SMB financial content. The doctrine is what took time to develop. The math is straightforward once the doctrine is in hand.
What if my accountant built me a spreadsheet?
Ask specifically whether it includes the five MMP sub-layers, Layer Cake with Realized vs Intended margin, and Working Capital Required vs Actual. If it does, great. Most accountant-built spreadsheets do not include these because they are not standard accounting doctrine.
Should I stop using my spreadsheet if I run the Aldebert Diagnostic?
No. Use the spreadsheet for what it does well (tactical scenarios, ad hoc analysis). Use the diagnostic for the doctrinal read. They complement each other.
How much time does the DIY spreadsheet cost me?
Owners who track their time on their own spreadsheets are shocked. Ten to twenty hours per month is common for owners who genuinely maintain the model. At $135,000 restated market comp for a $2M business, that is $8,000 to $16,000 of owner time per year. Priced correctly against a diagnostic engagement, the diagnostic is usually cheaper.