# Convertible Bond Model Build a convertible bond and convertible note model with PIK interest compounding, dynamic conversion mechanics, and investor return analysis across multiple financing and exit scenarios. - Canonical: https://finamodel.com/templates/convertible-bond-model - Excel download: https://finamodel.com/templates/convertible-bond.xlsx - Category: Capital Markets - Model type: Valuation - Difficulty: Advanced - Audiences: Investors & analysts, Bankers & advisors, Corporate treasurers, Credit analysts, Equity researchers, CFOs - Tags: Debt, Equity, Convertible, Options ## Overview This convertible bond model values a hybrid debt-equity security by calculating the straight bond value (NPV of coupon and principal using bond yield-to-maturity) and the conversion value (number of shares received × equity stock price at conversion). It then models the embedded call and put option economics: if stock rises above the call price, the issuer may call the bond, forcing conversion. If stock falls below the put price, the bondholder may put the bond back to the issuer. The model projects dilution per share upon conversion and shows the effective cost of capital to the issuer versus straight debt. The model includes coupon and maturity assumptions, conversion ratio (shares per $1,000 bond), stock price paths across three scenarios (base, bull, bear), and option pricing using the Black-Scholes framework or Monte Carlo simulation. It calculates the bond floor (minimum value = straight debt value), conversion value, and option-adjusted spread (OAS). Outputs include the full valuation breakdown across scenarios, the probability-weighted fair value range, and sensitivity to stock price volatility and interest rates. An earnings-per-share impact sheet shows dilution at various conversion prices. This model is used by corporate finance teams evaluating convertible issuance versus straight debt or equity raises; investors assessing whether convertibles are fairly priced relative to straight debt and equity; and M&A advisors valuing convertible securities held by targets or acquirers. It is essential for any company considering convertible debt as a capital structure optimization tool. ## What's included - PIK and cash interest capitalisation schedules - Conversion mechanics using valuation cap and discount logic - Forced conversion triggers at qualified financing thresholds - Creditor return outputs including IRR and MOIC - Bridge to equity capitalisation table impact - Convertible bond terms: coupon, maturity, conversion ratio, call/put features - Straight bond value using yield-to-maturity - Conversion value based on equity price paths - Call and put option mechanics - Dilution impact on earnings per share post-conversion ## How the Convertible Bond Model Works: Terms, Conversion and Returns This convertible bond model template maps a seven-year convertible issuance from bond terms and conversion mechanics through to issuer earnings and investor returns. A single assumptions sheet drives coupon and principal schedules, parity and embedded-option valuation, dilution, and hold, convert, put and call outcomes. The preview shows all outputs as static values, so read it as a worked illustration of the model's logic rather than a live calculator. ### Inputs That Drive a Convertible Bond Model Everything starts on the Assumptions sheet, which gathers 43 inputs into eight labelled blocks. Bond terms set face value, coupon, maturity, issue price and issue year, alongside call and put prices and the call-protection end date. - Conversion terms set the conversion price and issue-date stock price, from which the conversion premium and ratio derive. Issuer financials feed revenue growth, EBITDA margin, D&A and tax. - Market inputs cover stock growth for bull, base and bear paths, dividend yield, straight-bond yield and the investor discount rate. Option inputs supply equity volatility, the risk-free rate and a credit spread for the Black-Scholes call. Further blocks expose soft-call and make-whole flags, anti-dilution and settlement codes, and a switch selecting which stock path drives projections. ### Bond Schedule and Conversion Valuation The Bond Schedule rolls par forward from issue to year seven. Each year shows opening par, coupon at the coupon rate on opening par, cumulative coupons, call and put eligibility flags, and a maturity repayment in the final period. - A total cash flow line turns negative at issue, then reflects coupon and maturity flows. Closing par retires to zero from the first year the conversion value is in the money. - The Conversion Analysis sheet projects the stock price along the chosen path, then calculates conversion value, parity, straight-bond value as a discounted coupon and principal annuity, and a floor equal to the higher of the two. A Black-Scholes embedded call is valued on the full issue by year, and the theoretical convertible value adds that call to the straight value. ### Issuer Earnings, Dilution and Balance Sheet The Issuer Impact sheet builds a P&L from revenue through EBITDA, D&A, EBIT, interest, pre-tax profit, tax and net income. Interest expense is opening par multiplied by the coupon rate, so it falls to zero once conversion retires the par. - Tax is floored at zero, which the sheet flags as a simplification that ignores loss carryforwards. Basic EPS divides net income by shares outstanding, while diluted EPS takes the lower of basic and the if-converted figure so the more dilutive number always shows, with a flag labelling anti-dilutive years. - On the balance sheet, convertible debt opening rolls forward and closing debt mirrors the schedule, so it also clears on conversion. A debt-to-EBITDA line gives a simple credit metric. Illustrative dilution is checked against a thirty per cent ceiling. ### Investor Return Scenarios and Validation Investor Returns runs four self-contained scenarios, each with its own cash flows so converted par retirement does not leak between them. Hold to maturity pays coupons and face, with IRR equal to yield to maturity. - Convert at maturity pays coupons then the conversion value at the end, avoiding double counting. The put scenario follows the coupon path until the put year and exercises only if the put value beats the present value of holding. - The call scenario mirrors this, comparing straight value against face times call price. Dedicated helper rows produce yield-to-put and yield-to-call for comparison. A checks sheet runs six tests covering coupon accuracy, conversion ratio, par retirement by maturity, a positive hold IRR, dilution under thirty per cent, and a positive conversion premium; all should pass in the default state. ## Built for convertible debt structuring Use this model when PIK interest, conversion triggers, and investor return outcomes are central to the financing decision. ## Handles complex conversion mechanics A useful convertible bond model automatically toggles between valuation cap and discount methods depending on the next financing round price. ## Better for scenario-based analysis This gives you clear payout views across equity financing, change of control, and maturity scenarios instead of a single static output. ## Built for convertible debt structuring Use this model when PIK interest, conversion triggers, and investor return outcomes are central to the financing decision. ## Handles complex conversion mechanics A useful convertible bond model automatically toggles between valuation cap and discount methods depending on the next financing round price. ## Better for scenario-based analysis This gives you clear payout views across equity financing, change of control, and maturity scenarios instead of a single static output. ## Features - **Option value calculation:** Use binomial or Black-Scholes to price the embedded equity call option independently from bond value. - **Equity dilution waterfall:** Show share count impact at different conversion scenarios and model EPS bridge. - **Call and put scenarios:** Model early call or put exercise and calculate the issuer's and bondholder's incentives. ## Use cases - **Financing decision at issuance:** Compare convertible bond cost of capital to straight debt and equity issuance alternatives. - **Bond investor analysis:** Determine the bond floor value and option value to assess risk-return profile. - **Treasury management:** Track the likelihood of conversion and its impact on capital structure and equity financing needs. ## Frequently asked questions ### What is a convertible bond model? It is a model that tracks convertible debt instruments, including interest accrual, conversion mechanics, and investor returns under different exit and financing scenarios. ### Who uses convertible bond models? Venture lenders, startup founders, corporate finance teams, and private credit funds use them for structuring and underwriting convertible debt. ### What should a convertible bond model include? It should include interest schedules, conversion logic (valuation cap and discount), forced conversion triggers, and return outputs across multiple scenarios. ### Does it handle PIK interest? Yes. The model supports pure cash interest, pure PIK capitalised into the principal balance, or a hybrid structure. ### Can I see the dilution impact on the cap table? Yes. The model bridges from conversion to equity impact so founders and investors can see ownership outcomes clearly. ## Related templates - [Convertible Note and SAFE Model](https://finamodel.com/templates/convertible-safe-model) - [Bond Trading Model](https://finamodel.com/templates/bond-trading-model)