# Share Buyback Model Build a share buyback model to evaluate the impact of repurchases on EPS, leverage, and shareholder value. Includes accretion/dilution analysis, intrinsic value benchmarking, and capital allocation scenario testing. - Canonical: https://finamodel.com/templates/share-buyback-model - Excel download: https://finamodel.com/templates/share-buyback.xlsx - Category: Corporate Finance - Model type: Sector planning - Difficulty: Intermediate - Audiences: Investors & analysts, CFOs & FP&A, CFOs, Board members, Equity research analysts, Investor relations - Tags: capital-allocation, eps, shareholder-return, cash-flow ## Overview 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's included - 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 - EPS accretion/dilution by year - Cash flow analysis and alternative capital allocation scenarios - Peer comparison and return on capital metrics ## 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. ## Built for capital allocation decisions Use this model when you need to evaluate whether a share buyback creates value relative to other uses of excess cash, including dividends, debt paydown, or reinvestment. ## Shows the real impact on shareholder value A useful buyback model should show how repurchases affect EPS, leverage, and return on equity under different funding and price scenarios. ## Better for board and treasury analysis This gives you a structured framework for buyback evaluation instead of a back-of-the-envelope calculation that misses the capital structure and valuation dynamics. ## Built for capital allocation decisions Use this model when you need to evaluate whether a share buyback creates value relative to other uses of excess cash, including dividends, debt paydown, or reinvestment. ## Shows the real impact on shareholder value A useful buyback model should show how repurchases affect EPS, leverage, and return on equity under different funding and price scenarios. ## Better for board and treasury analysis This gives you a structured framework for buyback evaluation instead of a back-of-the-envelope calculation that misses the capital structure and valuation dynamics. ## Features - **EPS accretion and dilution:** Model how buybacks accrete EPS if the company's cost of repurchase is below earnings yield, but dilute if the stock is overvalued. - **Capital allocation optionality:** Compare buybacks to dividends, M&A, debt reduction, and working capital needs to optimize shareholder returns. - **Market timing and pricing:** Model buyback returns under different price scenarios and compare to peer buybacks and market returns. ## Use cases - **Board capital allocation decisions:** Present buyback scenarios vs. dividends and M&A to show board impact on shareholder value and strategic flexibility. - **Investor communication:** Explain buyback program rationale, expected share count impact, and long-term return thesis to shareholders. - **Analyst and guidance:** Model EPS and share count impact for guidance and analyst model assumptions. ## Frequently asked questions ### 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. ## Related templates - [3 Statement Model](https://finamodel.com/templates/3-statement-model) - [DCF Model](https://finamodel.com/templates/dcf-model) - [Dividend Discount Model](https://finamodel.com/templates/dividend-discount-model)