SmartHelping / Business Acquisitions / Excel
Direct Marketing & Print Communications Acquisition Financial Model
Evaluate whether a print and direct marketing business can support its purchase price, debt obligations, and buyer return. Connect a detailed operating forecast with acquisition funding, valuation, scenarios, and a structured deal assessment in one Excel workbook.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
Video walkthrough & workbook preview
See the operating business and the acquisition in one model.
Follow the customer, production, cost, and funding assumptions through to cash flow, buyer returns, and the acquisition scorecard.
A forecast built from the work the business sells
Connect customer demand with revenue and margins.
Forecast six service lines: direct mail; digital and offset print; large format and retail; fulfillment and kitting; promotional products; and data, portals, and creative services.
Customer retention & new accounts
Start with existing service accounts, annual retention, monthly account additions, and acquisition-related account losses. Optional cross-selling adds service relationships as integration progresses.
Order frequency, volume & pricing
Build demand from orders per account, units per order, and calendar-month seasonality. Set selling prices and setup fees, with growth assumptions for each forecast year.
Materials, spoilage & outsourcing
Model internal material costs, spoilage allowances, labor requirements, and outsourced production costs by service line to understand the margin behind completed work.
Historical earnings & forecast comparison
Enter the target's historical results, opening balances, and EBITDA adjustments. Review five forecast years beside historical figures and compare major operating assumptions with the last twelve months.
Production capacity & the cost of growth
Test whether the business can deliver the forecast.
The model connects demand with equipment, space, and productive labor. Completed production drives billed revenue, while outsourcing and unserved demand remain visible.
Capacity constraints
Compare equipment or space capacity with available productive labor for each service line. Review how the binding constraint affects in-house production.
Overflow production
Set the share of excess demand handled by outside suppliers. Review outsourced work, its cost, and demand that remains unserved.
Staffing & payroll
Plan production teams and administrative staff by forecast year. Payroll includes wages, wage inflation, employer burden, and the minimum operators required by installed capacity.
Equipment additions & occupancy
Add capacity modules by year. New modules bring capital spending, minimum operator payroll, floor-space rent, and depreciation into the forecast. Maintenance CapEx is modeled separately.
Postage & working-capital funding
Keep pass-through postage separate from operating revenue.
Postage is billed at cost and shown separately from net operating revenue and EBITDA. Postage advance days capture the cash required when the business pays before the customer reimburses it.
Customer collection days, material inventory days, and supplier payment days connect the operating forecast with working-capital needs. This helps reveal cash pressure that an EBITDA-only forecast can miss.
Purchase price, closing funding & ongoing liquidity
Understand the buyer's full cash commitment.
Connect normalized historical earnings and the proposed purchase price with closing costs, financing, operating cash needs, and subsequent equity contributions.
Purchase price & Sources and Uses
Set entry enterprise value from normalized LTM EBITDA and a purchase multiple. Adjust consideration for delivered operating working capital versus the agreed peg, then include transaction costs, financing fees, and opening cash.
Senior debt & seller financing
Size debt as shares of total closing uses, with buyer equity funding the remainder. Model senior amortization and interest-only periods, financing fees, and the seller note's final repayment.
Revolver & additional equity
Set a revolving-credit limit, minimum cash target, and cap on post-close operating equity. Track peak borrowing and any funding shortfall that remains after those limits are reached.
Cash sweeps & equity distributions
Apply the model's cash rules to debt repayment and investor distributions. Review debt service coverage, including a separate view of the seller-note balloon, alongside the equity cash-flow schedule.
Base / Downside / Upside / No Synergies
See how much the investment depends on the operating plan.
Four selectable cases run through the same 60-month forecast. Change the selected case to review its operating results, funding needs, debt coverage, valuation, and returns.
Operating scenarios
Vary retention, account acquisition, pricing, order frequency, material and wage inflation, production capacity, collections, and postage funding assumptions.
Integration benefits & costs
Model overhead savings, procurement discounts, and cross-selling with a start month and implementation ramp. Include one-time integration spending to capture the cost of achieving those benefits.
No Synergies case
Evaluate the acquisition without overhead savings, procurement benefits, cross-selling, or integration expense. The acquisition-related account-loss assumption remains.
Two-way sensitivity tables
Test equity XIRR across entry and exit EBITDA multiples when using the EBITDA exit method. A second table tests minimum rolling debt service coverage against demand and internal material-cost stress.
Financial reporting, valuation & decision support
Review the return, the cash path, and the supporting evidence.
Connected financial statements
Review monthly and annual income statements, balance sheets, and cash flow statements linked to the operating model, assets, taxes, working capital, and financing.
Equity return analysis
Evaluate dated equity XIRR, MOIC, and NPV. The annual equity summary separates closing investment, later contributions, operating distributions, exit cash flow, and cumulative cash flow.
Three exit valuation methods
Choose a Year 5 EBITDA multiple, continuing DCF, or net-revenue multiple. Review the enterprise-value-to-equity bridge, DCF analysis, and a chart comparing low/high valuation estimates.
LTM comparisons & visualizations
Compare historical revenue, expenses, and EBITDA with Years 1–5. Review operating KPIs, production capacity, debt, cash, and Sources and Uses charts.
Assumptions Analysis
Enter the existing business's LTM operating assumptions beside linked Year 1–5 drivers. Review Year 1 differences and calculation notes across the service lines, staffing, overhead, synergies, and working capital.
Deal scorecard & diligence
Use the weighted acquisition scorecard, financial/quality/risk dimensions, and evidence coverage to organize your review. Track requested evidence, closing conditions, responsibilities, and open risks in the diligence checklist.
A practical acquisition workflow
From seller information to an investment case.
-
Establish the historical baseline
Replace the illustrative financials with the seller's results, opening balances, and supported EBITDA adjustments. Enter LTM operating drivers for comparison.
-
Build the operating and funding plan
Set service volumes, retention, pricing, staffing, capacity investment, working capital, acquisition terms, and financing assumptions.
-
Test returns and document the risks
Review scenarios, debt coverage, funding gaps, valuation, and buyer returns. Use the scorecard and diligence checklist to identify what still needs evidence.
Also included in these bundles
Get this model as part of a broader collection.
Industry-Specific Financial Model Bundle
Get this acquisition model alongside financial models for a wide range of operating businesses.
Explore the industry-specific bundleThe Super Smart Bundle
Get this model as part of the complete SmartHelping template collection.
Explore the Super Smart BundleQuestions before you buy
A few useful details.
Who is this model for?
It is built for evaluating the acquisition of an existing direct marketing and print communications business. Buyers, operators, and advisers can use it to connect the target's operating assumptions with acquisition funding, cash flow, valuation, and buyer returns.
Is this a startup forecast or an acquisition model?
It combines an existing-business acquisition framework with a bottom-up operating forecast. Historical results and normalized earnings inform the purchase analysis, while service accounts, production capacity, staffing, and costs drive the five-year projection.
Does it include actual results from a specific company?
No. The example financials and transaction terms are illustrative. Replace them with verified information for the business you are evaluating.
Are service accounts the same as unique customers?
No. They represent service relationships. One customer can buy several types of work, so adding accounts across all six service lines does not produce a unique customer count.
How does the model treat postage?
Postage is an at-cost pass-through, excluded from net operating revenue and EBITDA but visible in billings and funding needs. Positive advance days represent the business funding postage before reimbursement. Customer prepaid-postage deposits are not modeled.
What does the No Synergies case remove?
It removes overhead savings, procurement benefits, cross-selling, and the associated integration expense. The acquisition-related account-loss assumption remains. It is useful for reviewing the acquisition without the planned integration benefits and spending.
Do LTM entries on Assumptions Analysis change the forecast?
No. Those entries provide a comparison with the existing business. The Year 1–5 columns link to the selected case and the model's operating schedules. Change forecast assumptions on the existing input tabs.
Does a high deal score mean the evidence is verified?
No. The acquisition assessment and verified evidence coverage are separate. Record supporting information and reviewer conclusions before changing evidence statuses. Illustrative inputs do not establish that diligence or closing conditions have been satisfied.
What software should I use?
This is an Excel workbook. For the built-in two-way sensitivity tables, use Excel with calculation set to Automatic, including data tables.
How much does the model cost?
The one-time price is $45 for the Excel download, available immediately after purchase. It is also included in the Industry-Specific Financial Model Bundle and the Super Smart Bundle linked above.
Evaluate the acquisition
Connect the operating plan with the buyer's return.
Get the Direct Marketing & Print Communications Acquisition Financial Model. Have a question? Contact SmartHelping.
