Convertible Bond Calculator Excel Template
Convertible Bond Calculator Excel Template
Interactive Excel Financial Model
Download, customize, and integrate into your own analysis
What's Included
- Interactive financial model with live Excel formulas
- All formulas visible and fully editable
- Professional formatting with color-coded inputs & outputs
- Formula reference sheet with variable definitions
- Step-by-step instructions sheet
- Compatible with Microsoft Excel 2016 and later
Download Template
Price range: $0.00 through $20.00
Calculate conversion value, premium, and bond floor for convertible bonds. Editable Excel template with live formulas.
Online Calculator vs Excel Template
| Feature | Online | Excel |
|---|---|---|
| Instant use — no download | ✓ | — |
| Works offline | — | ✓ |
| Customize formulas & layout | — | ✓ |
| Save & share with colleagues | — | ✓ |
| Integrate into your own models | — | ✓ |
| Print-ready formatting | — | ✓ |
About This Template
Analyze convertible bonds with this professional Excel template. Calculate conversion value, conversion premium, investment value (bond floor), and market conversion price instantly. Perfect for fixed income analysts, portfolio managers, and finance students evaluating hybrid securities.
What You Can Calculate
This template computes six key convertible bond metrics:
- Conversion Value (Parity) — The value if converted to stock immediately, calculated as conversion ratio times current stock price
- Conversion Premium — Both dollar amount and percentage premium over parity, showing what you pay for optionality and downside protection
- Conversion Price — The effective stock price implied by the bond's face value
- Market Conversion Price — The actual price per share you'd pay by buying the bond at market and converting
- Investment Value (Bond Floor) — Present value of the bond's cash flows at comparable straight bond yields, representing downside protection
- Premium over Investment Value — How much the market price exceeds the bond floor
Required Inputs
Enter six values to analyze any convertible bond:
- Bond Market Price — Current trading price (face value is $1,000 per market convention)
- Conversion Ratio — Shares received per bond upon conversion, found in the prospectus
- Current Stock Price — Market price of the underlying common stock
- Annual Coupon Rate — Coupon as percentage of face value (enter 0 for zero-coupon convertibles)
- Years to Maturity — Time remaining until the bond matures
- Comparable Straight Bond YTM — Yield of similar non-convertible debt from the same issuer
Methodology
The template uses standard convertible bond valuation formulas. Conversion value equals the conversion ratio multiplied by stock price. Investment value is calculated using present value of an annuity for coupons plus present value of face value, discounted at the comparable straight bond yield. All formulas are visible and editable in Excel.
Assumptions & Limitations
- Face value fixed at $1,000 (US market convention)
- Annual coupon payment frequency
- Valuation on coupon payment date (no accrued interest)
- No call provisions, put options, or forced conversion features
- End-of-period discounting convention
Frequently Asked Questions
Convertible bonds trade with a standard face value of $1,000 per bond in the US market. The conversion ratio specifies how many shares you receive per $1,000 face value bond. This is market convention, not a limitation of the calculator.
Look for non-convertible bonds from the same issuer with similar maturity. If unavailable, use the issuer's credit spread over Treasuries plus the risk-free rate. This reflects what the bond would yield without the conversion option.
Yes. The template uses standard Excel formulas you can modify. Unprotect the Calculator sheet to add call schedules, put options, or other provisions. The investment value formula can be extended to include call premium discounting.
A fully interactive financial model with live Excel formulas, an Instructions sheet with usage guide, and a Formula Reference sheet with variable definitions and model assumptions. All formulas are visible and editable.
Microsoft Excel 2016 or later. The template uses standard Excel formulas only — no macros, VBA, or add-ins required.
Yes. All cells are fully editable. You can modify any formula, add your own calculations, change formatting, or integrate the model into your existing spreadsheets.
The online calculator runs in your browser for quick calculations. This Excel template gives you a portable, offline financial model you can customize, save, share with colleagues, and integrate into your own analysis.
This template is provided for educational and personal use. You may use it in your own professional analysis and presentations. Redistribution or resale of the template itself is not permitted.
You can re-download the latest version from your account or by requesting a new download link. Free downloads are limited to 5 per email address per month.
