Key takeaways
- Enter costs only when they were charged to the starting profit.
- Price every continuing owner duty before you calculate adjusted EBITDA.
- Run separate periods to spot adjustments that repeat each year.
Which earnings figure should you start with?
Enter reported net profit for a clearly identified period. Use the same accounting basis and reporting entity throughout the bridge so an adjustment is either present in the starting figure or clearly outside it.
Pull the year-end profit and loss statement and compare the bottom line with the return or accountant’s reconciliation. If your reporting package already starts at EBITDA, adding interest, tax, depreciation and amortization again would inflate the result. Resolve that difference with your bookkeeper before entering the numbers. Entity income tax belongs on a different line from payroll tax, sales tax and an owner’s personal income tax.
The spreadsheet provides three comparison columns. You might use two full fiscal years and a trailing twelve-month period. Name each period and note whether it contains an unusual closure, an added location or a payroll calendar change. A partial year in one column needs a label before anyone compares it with full years.
Which inputs belong on the earnings worksheet?
The first section, Prepare your inputs, gives you these prompts and room to document your evidence.
- Set the period. Choose one full fiscal or trailing period. Use matching dates for payroll, financial statements and rent.
- Trace each adjustment. List only costs already charged to the starting profit. Document the ledger account, owner approval and amount accepted.
- Separate earnings and cash. Enter interest, entity income tax, depreciation and amortization only where expensed. Debt principal and equipment purchases are separate cash uses.
| Section | Topics covered |
|---|---|
| Prepare your inputs | Set the period · Trace each adjustment · Separate earnings and cash |
| Read the bridge | One owner’s role · Independent operation · Occupancy change |
How do you decide what to include?
Accept a proposed adjustment when you can trace it to the period and explain what will happen to the expense after closing. Record support outside the original ledger and preserve the source reference.
There is a difference between an expense you would prefer to eliminate and a job the buyer must continue performing. If the owner drives the parts van, the cost of a personal weekend trip may disappear but the shop still needs parts delivery. If the seller plans to take a diagnostic subscription, the buyer still needs equivalent access to perform the work. Separate those dollars before writing the amount into the bridge.
If you’re selling, keep an invoice, payroll report or contract alongside each accepted amount. If you’re buying, make a second copy and record your proposed treatment of disputed entries. Compare the effect of your changes line by line rather than arguing over a single earnings total.
How does owner replacement change the result?
Illustrative composite — not a real client.
A sample shop reports $80,000 of net profit after $10,000 of interest, $5,000 of entity income tax and $20,000 of depreciation. Reported EBITDA is $115,000. Add $72,000 of expensed owner compensation and $4,000 of supported personal costs. Subtract $11,000 of extra market rent to get $180,000 of normalized SDE. If the owner’s role requires $82,000 of loaded replacement payroll, adjusted EBITDA falls to $98,000. That figure still precedes debt service, capital spending and working-capital changes.
How do you enter the first period without producing a misleading total?
Open Earnings bridge and start in Period A with the Period end and Reported net profit for one identified entity. Use a loss as a negative number. Enter only the interest expense, entity income tax, and depreciation and amortization already charged against that profit. A sole proprietor’s personal tax payment from an owner account does not become entity income tax merely because the owner used business cash. An equipment loan payment can include both interest and principal. Only the interest expense recorded in the starting figure belongs on the interest line.
The sheet waits for required numerical inputs before showing certain calculated results. A blank indicates the item needs review, while zero can indicate that you checked the records and the amount does not apply. Use Evidence and treatment to identify the financial statement page or ledger account and state why the amount belongs there. If you have only one reliable year, leave the other period columns unused. Repeating the same figure across three columns would make a single observation appear to be a trend.
Which adjustments need an offset somewhere else?
Read the rows between Reported EBITDA and Normalized SDE as a chain. Active owner compensation and Active owner benefits refer to one working owner’s pay and benefits expensed in the company books. Supported personal items and Supported one-time costs need distinct source transactions. A vehicle insurance premium cannot be treated as an owner benefit in one row and added again as a personal item. A bonus distribution charged to equity did not lower net profit in the first place.
Enter amounts with the direction the formula expects. Nonrecurring income and Increase in recurring rent represent amounts the workbook subtracts from the normalized earnings bridge. If the shop earned an unusual gain unrelated to repeat operations, recording the income as a negative input would make it increase normalized earnings instead. Read the treatment note and inspect the formula result before copying your adjustment into another period. For Replacement labor and burden, include the funded cost of the duties an incoming operator needs someone to perform. This row takes the analysis from owner benefit to the workbook’s adjusted EBITDA case.
How can you verify the spreadsheet with a complete test case?
Illustrative composite — not a real client. Enter $90,000 of reported net profit, $12,000 of interest, $0 of entity income tax and $18,000 of depreciation and amortization for one period. Reported EBITDA should show $120,000. The zero matters because the tax line has been examined. Next enter $70,000 of active owner compensation, $8,000 of removable benefits, $3,000 of supported personal costs and $5,000 of supported one-time expenses. Assume the period also includes $4,000 of nonrecurring income and that the buyer’s new rent increases annual cost by $10,000.
On these assumptions the normalized SDE is $192,000. The arithmetic starts at $120,000, adds $86,000 across the four supported rows and subtracts $14,000 for the income and rent adjustments. If a manager and added technical coverage together cost $62,000 a year fully loaded, the workbook’s adjusted EBITDA becomes $130,000. Test the direction by setting the rent increase to zero. Both normalized SDE and adjusted EBITDA should increase by $10,000. Use a copy for the test, then enter your actual records or retain the case clearly labeled as illustrative.
What is the most revealing way to use Periods B and C?
Compare complete periods with matching definitions. If one includes a change from owner-operated to manager-run service, identify the date and the payroll cost already charged. A new manager hired midway through a year may require an annualization adjustment in your buyer analysis, but any salary already expensed stays accounted for. Avoid deducting a full year of replacement cost on top of the portion already paid for the same role. If the necessary adjustment cannot be faithfully represented on an existing line, document an outside reconciliation and have your accountant approve the presentation.
Compare the direction of multiple lines. Earnings could increase while the owner works more unpaid production hours. Rent expense could fall because the property company temporarily waived payments. A short-lived fleet rebate could lift profit while the new owner loses eligibility. Enter or explain these facts on the periods they affect. A buyer reviewing the workbook should be able to tell whether the economic improvement came from greater shop productivity or a temporary transfer of cost to another person or entity.
What should you give the buyer or lender with the completed workbook?
Provide the identified profit and loss statements, a ledger-backed adjustment register, documents supporting the material items, the proposed lease or property-cost schedule, and the owner-duty and replacement-cost analysis. Protect payroll and customer detail through agreed access controls. Keep separate versions for the seller’s case and a lender or buyer case where a specific adjustment is disputed. State the date, evidence and reason for each difference so the reviewer can reproduce it.
Finish with a separate cash schedule for acquisition debt, recurring capital spending, working capital, taxes relevant to the buyer and one-time deal costs. A computed $130,000 adjusted operating earnings figure in the example does not make that amount available for distribution. Giving the recipient both schedules helps them evaluate value and understand the cash left to operate the shop.
How do the earnings totals change when the buyer replaces the owner?
Record the role the buyer expects to perform and test each earnings adjustment against that operating plan.
- One owner’s role. Add back one active owner’s charged compensation and eligible benefits. Include other workers at normal pay.
- Independent operation. Deduct fully loaded replacement payroll for the duties that have to continue. Use your shop’s actual job mix and get a written wage estimate.
- Occupancy change. Enter the annual expense change if rent will reset at closing. Treat a higher future rent as a positive expense increase that the model subtracts.
What belongs outside the earnings bridge?
Keep debt principal, working capital and equipment purchases on a separate cash-flow schedule. They affect how much you can take home and finance, even though the earnings bridge does not deduct them all in the same period.
Use the interactive SDE recast when you want to change one assumption during a conversation. If the sales price depends heavily on owner hours, use the technician roster and pay-plan tracker to document billed work, attendance and compensation separately. Check whether a single replacement manager can realistically cover both the service desk and the hardest diagnostic jobs.
Before sharing the file, compare your clean starting statement with the protected output formulas. List any rejected proposal alongside its rationale so a reviewer can see where your numbers differ and which assumptions still depend on market pay or lease terms.
What else should you know?
Can I add back my owner draws?
Trace how the payment was recorded before you add anything. A distribution taken directly from equity typically did not reduce the profit on your starting statement. Adding it to profit would count the same earnings twice. Have your accountant identify the underlying entry and confirm the correct treatment.
Where does my personal truck go?
Separate private use from the cost of running the shop. Find the expense on the ledger, document how much relates to personal driving and estimate the portion the buyer still needs for parts runs or towing. Only the supported removable expense belongs in the adjustment.
Why is my adjusted EBITDA lower than SDE?
Your SDE includes the benefit of one owner working in the business. Your adjusted EBITDA should reflect the pay and employer costs needed to replace that work. A shop where the seller diagnoses vehicles, dispatches technicians and writes estimates may need more than one replacement role.
Should a blank input count as zero?
Use zero when you have checked a line and confirmed it does not apply. Leave it blank while you still need evidence. The workbook holds back dependent totals when required inputs are missing so an unresolved adjustment cannot quietly turn into an apparently verified result.
Which sources can you check?
- Business recordkeeping · Internal Revenue Service · 2026-11-21
- Buy an existing business or franchise · U.S. Small Business Administration · 2026-11-21