Share Buyback Model
Corporate Finance Financial Model (Free Excel Download)
Measure repurchase effects on EPS, leverage, share count, intrinsic value, accretion or dilution, and capital allocation under alternative buyback programs.
professionals from Deloitte
Used by professionals from
About this model
Analyze share buyback programs and compare capital allocation to dividends, acquisitions, and debt reduction without treating EPS accretion as the sole metric. The model projects annual repurchase budgets, share price assumptions, pacing, impact on share count, and resulting EPS accretion/dilution. It then shows return on capital metrics (ROIC, pay-down of debt vs buyback comparison) and peer multiples to reveal whether buybacks are the best use of cash vs alternatives.
The model quantifies EPS accretion (shares repurchased at lower prices boost EPS per share even if net income is flat) and dilution (shares repurchased at higher prices damage EPS). Sensitivity tables show how buyback returns vary with entry price and company growth rate. Cash flow availability is modeled (FCF after capex and working capital) to ensure buyback budget is sustainable. The comparison framework shows opportunity cost: the same cash deployed to debt reduction cuts interest expense and leverage, while acquisition spend adds revenue and earnings. Tax impact on shareholders depends on sale vs dividend treatment.
Use cases: CFO capital allocation planning, investor communication (buyback justification vs dividend), and M&A strategy evaluation. Works with equity compensation dilution and voting power effects.
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Share Buyback Model
- EPS accretion and dilution sensitivity analysis
- Intrinsic value vs market price benchmarking
- WACC and leverage impact tracking
- Treasury stock accounting and share count adjustments
- Buyback vs dividend return comparison
- Annual buyback budget and share repurchase mechanics
- Share price assumptions and repurchase pacing
- Net impact on share count and dilution
Share Buyback Model: How the Template Works
This share buyback model is a five-year projection template for evaluating a corporate share repurchase programme. It captures the impact on EPS, leverage, cash, and shareholder returns.
Using a single assumptions sheet, it shows how buybacks flow through a schedule, income statement, debt schedule, and returns analysis, highlighting key operating drivers and checks.
Operating Drivers and Programme Framework
The template begins with a single Assumptions sheet that feeds every other calculation through named ranges. Programme behaviour is governed by a few key drivers: the authorisation size, the annual budget, the active window, the financing mix, and the buyback premium.
- A numeric programme-type code selects among open-market execution, accelerated share repurchase, and two placeholder structures for Dutch auction and fixed-price tender offers. The model also allows a target-leverage cap to constrain spend before the budget is applied.
- These inputs determine the pace and scale of repurchases, while the programme window ensures activity only occurs when the programme is live. Because everything is input-driven, users can adjust assumptions to see how the programme responds.
Calculation Flow: Financing, Caps, and Shares
Programme spend is the minimum of requested budget, target-leverage room, and remaining authorisation, but only if the programme is active. The target-leverage cap is solved as target leverage times EBITDA minus existing debt, so the model treats leverage as a sizing constraint rather than an after-the-fact check.
- Funding is split between new debt and operating cash based on the debt-funded percentage. Buyback debt amortises straight-line over its tenor.
- On the share side, the model uses a time-weighted average basic share count that accounts for when during the year repurchases occur. Diluted EPS adds treasury stock method dilution from options.
An excise tax on repurchases is applied below the tax line as a separate, non-deductible expense.
Outputs and Integrity Checks
The outputs span several linked schedules. The income statement carries revenue through net income, with the excise tax shown separately.
- The buyback schedule rolls forward shares, treasury stock, and the ASR block. The cash flow statement uses the indirect method and enforces a minimum-cash covenant test.
- The debt schedule amortises both existing and buyback-related debt and tracks leverage and coverage. The returns analysis reports ROE, ROIC, a mark-to-market-inclusive buyback ROI, and a dividend-versus-buyback comparison.
A dedicated checks sheet flags errors, leverage breaches, authorisation limits, cash floors, ROI sanity, and ROE monotonicity, so users can quickly see whether assumptions produce coherent results. These outputs help evaluate shareholder value and financial stability together.
Practical Use and Sensitivity Analysis
Practically, the template supports scenario testing by overriding a handful of high-impact assumptions. The dominant drivers for buyback ROI include price growth, debt-funding percentage, annual budget, and buyback premium.
- For a one-variable sensitivity, the budget can be varied across a range and the terminal ROI read from the returns analysis. Two-variable sensitivity can be set up with a data table tied to named ranges, for example budget versus premium.
- The dividend-versus-buyback comparison shows equivalent special dividend per share, after-tax yields, and the DPS uplift from a lower share count. The model’s known limitations include placeholder tender mechanics and no revolver, so it is best used as a structured evaluation tool, not a substitute for full covenant modelling.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is a share buyback model?+
It is a model used to evaluate the financial impact of share repurchases on earnings per share, capital structure, and overall shareholder value creation.
What should a share buyback model include?+
It should include EPS accretion analysis, valuation benchmarking, leverage and WACC impact, share count adjustments, and comparison against alternative capital uses.
Who uses share buyback models?+
Corporate treasury teams, CFOs, investor relations, board members, and equity analysts use them to plan and evaluate repurchase programmes.
When is a buyback accretive?+
A buyback is generally accretive when the earnings yield on repurchased shares exceeds the after-tax cost of funding the repurchase, whether from cash or debt.
Can I compare buybacks to dividends?+
Yes. The model includes a comparative analysis of the net-of-tax return to shareholders from buybacks versus dividends across different scenarios.
Have more financial modelling questions? Contact us
Related templates
3 Statement Model
Integrated income statement, balance sheet, and cash flow forecasts.
DCF Model
Discounted cash flow valuation model with explicit forecast, terminal value, and WACC.
Dividend Discount Model
Valuation of dividend-paying stocks using multi-stage dividend growth and terminal yield.
M&A Modeling & Valuation
Comprehensive M&A valuation with DCF, comparable companies, and precedent transactions analysis.
