Bond Calculators for Portfolio Management.

This bond software does not have a database with bond data. So you can't input CUSIPs and have individual bond data come up. You have to get the data yourself and input them.

Customers' say they had to spend $250 to get YieldBook or Bloomberg to run these numbers just once. Now you can do it yourself, as many times as you need, for less than a penny on their dollar, without the hassle, any time, in minutes.

What these Bond Calculators Do:

Bond Calculator Sheet 1: 100-Bond portfolio duration and convexity calculator. Calculate all of the usual Macaulay/modified duration and convexity numbers, and see how assumed changes in interest rates change the price of each bond, and the combined portfolio of up to 100 bonds. Calculate:

º Macaulay and modified duration and convexity of each bond, and the whole bond portfolio combined (both weighted using market values, and unweighted). Effective duration calculator and modified duration calculator via Macaulay duration.

º Estimated percentage and current market price changes in dollars due to both modified duration and convexity, separately, and then both of them combined. All at the individual bond level, and at the overall bond portfolio level.

º The bond portfolio's average credit quality rating and weighted average credit quality rating, using both Moodys and S&P credit rating schedules.

º The average inputted yield to maturity of the bond portfolio.

º Average maturity and weighted average maturity of the combined bond portfolio.

º Average current market price of all of the bonds entered (input in percentage of par format).

º Average coupon of all of the bonds entered.

º Average bond portfolio yield and weighted average bond portfolio yield.

º Total number of bonds included in the portfolio.

º Total current market value of all of the bonds included in the portfolio.

º Total maturity value of all of the bonds included in the portfolio.

º Each bond's percentage make up of the total bond portfolio.

º Each bond's average total return over its life in the portfolio.

º Excel's IRR formula is used to amortize premiums and discounts.

º How many coupons it takes to recoup premium.

º Each bond's cash flows over the whole thirty-year window. Great for analyzing laddered bond portfolios.

º Year-by-year total cash flows from all of the bonds combined for all thirty years. Also shown are the cash flows from just the coupons, and just the maturity proceeds. All are also summed so you can see the total amount of net inflows into the portfolio each year over the thirty-year window.

º Turn individual bonds on or off with one switch to simulate adding or deleting them from the portfolio. With one keystroke, you can deselect a single bond, so all of its input is ignored. Then bring it back with one keystroke.

º It calculates days to maturity (or call on the next sheet) automatically (because it uses your computer's current date as a reference). It automatically determines the numbers of days until maturity when you input the maturity date.

º You can input an alternative valuation date, if other than today. For example, if you need to calculate duration as part of year-end reporting in January, and the bond's valuation date needs to be the last day of the previous year, you can do that.

Bond Calculator Sheet 2: 100-Bond portfolio duration and convexity to call calculator. Same as the 100-bond calculators sheet described above, but it calculates duration to call and convexity to call numbers based on data input into the regular 100-bond calculator sheet. Just input the call dates and proceeds and see worst-case call values.

Bond Calculator Sheet 3: Single-bond duration calculator and bond convexity calculator: Easily calculate all of the usual duration and convexity numbers, and see how changes in interest rates change the price of a bond in greater detail. You can input an alternative valuation date, if other than today. For example, if you need to calculate duration as part of year-end reporting in January, and the bond's valuation date needs to be the last day of the previous year, you can do that.

Bond Calculator Sheet 4: Bond yield calculator - Determine before- and after-tax bond yield to maturity (or bond yield to call) down to a very high level of accuracy (third decimal place). The YTM calculator works with interest rates from 1% to 20%.

º You can input an alternative valuation date, if other than today. For example, if you need to calculate yield to maturity as part of year-end reporting in January, and the bond's valuation date needs to be the last day of the previous year, you can do that.

º Calculate a coupon bond's current fair market value, and total return considering the reinvestment of coupons.

º Calculate a zero coupon bond's current fair market value and bond yield to maturity (or bond yield to call).

º Calculate a zero coupon bond's accretion (annual inputted tax liability).

º Muni vs. taxable bond breakeven rate calculator.

º T-bill yield and/or T-bill current market price finder.

º Bond equivalent yield - used to turn the 360-day T-bill rate into the 365-day rate.

º Simple current yield calculator.

º CD equivalent yield (AKA money market equivalent yield - used to compare T-bills to 360-day money market instruments).

Bond Calculator Sheets 5 - 13: Calculate annual amortization of premium and see basis on up to 100 coupon bonds.

The concept is basically this: You'll have a capital loss on bonds if bought at premium and held to maturity. So the IRS allows you to take this locked-in loss, divide it into annual chuncks, and then use the loss on each chunk to offset taxes due on coupon interest along the way (these annual chunks are calculated using two methods, but they both end up with the whole premium being amortized at maturity. There may be tax advantages in using one method over another if sold before maturity, and this will calculate and show that). The total capital loss ends up being the same, just not as painful when it's taken in chunks annually. So at maturity, premium should go to zero, basis should be par, and your capital loss therefore should also be zero. Discounts are not amortized.

These sheets calculate the (annual) figures for:

º Accrued interest that needs to be returned to the seller after settlement
º Net bond basis
º Original discount or premium
º Annual (pro-rated) amortization of bond premium using both Constant Yield and Straight Line amortization as required by the IRS
º End-of-year basis
º Annual coupons
º Estimates of taxes due on coupons
º Estimates of differences in taxes paid vs. not amortizing premiums
º Capital loss upon sale before maturity
º Then most everything is summed up so you can see totals on portfolios

As far as we know, this is the only bond calculator that allows you to calculate premium amortization for more than one bond at a time. Bloomberg only does one bond at a time, and we haven't seen any other competing product that even makes these calculations at all.

Because of the complexity, there are nine sheets: Four input and calculation sheet using 25 bonds each. Four calculates the Constant Yield method and another four uses Straight Line, so you can make comparisons. The last sheet has sums of all of the other sheets, and is unprotected so you can make any changes you want (add graphs, whatever).

It first strips off any accrued interest the buyer has to refund to the seller. Then it displays all of the annual amortization, interest, basis, and taxes for every year to either sale or maturity, up to 20 years. It pro-rates everything given purchase and sale/maturity dates. It keeps track of basis and the amount of capital loss if sold before maturity. It works with any type of coupon bond, including municipals. Zero coupon bonds use a process called accretion, and is calculated on sheet 14.

All 100 bonds are totally independent of each other.

You can assign a different tax rate to the four different input/calculation sheets with 25 bonds each.

You can choose to sell bonds before maturity to see what the numbers look like, including basis and capital loss.

You can "go back in time" by inputting current dates with the same data as what actually happened (see the directions).

Bond Calculator Sheet 14: Zero coupon bond accretion. Input up to 25 zero coupon bonds, and see the annual accretion/basis, and taxes due, on all 25 bonds together and all individual bonds, up to 50 years. There's a graph to show all of the accretion and taxes combined. It works with any type of coupon bond, including municipals.

Bond Calculators Sheet 15: Bond yield calculator - Bond total return calculator using the most accurate method - Horizon Return. Calculate total return considering everything including the compounding of reinvested coupon interest and capital gain/loss when sold. Compare bond prices and yields before purchasing or selling them.

Bond Calculator Sheet 16: Multi-year bond investment calculator. Input up to ten bonds and see an overall portfolio yield (IRR) up to 50 years.

Bond Calculators Sheet 17: Single-year bond investing software. Input up to 50 bonds and get a one-year overall portfolio yield (IRR).

Bond Calculator Sheet 18: Calculate differences in interest rates given several different compounding periods. Two graphs.

Bond Calculators Sheet 19: Input and compare, on the same page, the growth (or shrinkage) of money given the three compound interest rates of return. It has one column for simple interest; one compound interest column has a year-by-year manual override (so you can have a different rate of return every year), and a graph sheet. You can also add new money to the picture every year.

Bond Calculator Sheet 20: An array of convertible bond investment calculators.

Bond Calculators Sheet 21: Bond yield calculator / Portfolio Yield Calculator - The fixed income software calculates the combined average income/dividend yield on your total portfolio; how much income, or paycheck, your total portfolio will produce on a daily, weekly, monthly, semi-annual, and annual basis; how much as a percent each asset is of the total portfolio; and how much each asset is estimated to pay out on a daily, weekly, monthly, semi-annual, and annual basis. You just enter five data points (asset name, dollar amount of it held, when it pays, and its annualized estimated yield - get it from the fund's prospectus, website, other source, or guess) into the green-shaded areas, and it automatically computes all of the income generated in all of the different time frames (along with all of the totals). You can enter up to 100 investments.

Customers have said they've found this sheet to be sufficient to model bond ladders and bond laddering strategies. We look forward to your suggestions to make this fully-functional in this area. You'd get any modifications to the calculators free for helping this development (we don't do or use ladders, so we'd like someone that does to help).

To download the demo, right click on the link below, and then choose "Save (Target) As..." to save to your hard drive. Then find and open with Excel. Answers to frequently asked demo questions and how to use demos.

This bond software's free 11Mb demo has the most functional and accurate free bond yield to maturity calculator on the web!

The bond yield to maturity calculator part of the spreadsheet has its formulas intact. The rest of "demo" is non-functional because it's password protected without formulas. You won't be able to do anything but look at the bond calculator. You'll receive a non-input-protected 23Mb bond calculator spreadsheet (6Mb zip file) after you buy it.

It helps to read the directions while you look at the bond software demo.

Please send e-mail if you'd like to suggest new features. If you have a good idea, you may get it for free.

Why aren't you taking advantage of this bond investment calculator? Send e-mail and if you have an interesting reason, then you may get a freebie.

Personal Finance Software Modules

Fully Integrated Financial Planning Software

Menu of Retirement Planning Software

Asset Allocation Overview with Our Historical Returns

Asset Allocation Calculator

Asset Allocation Models with Our Historical Returns

Monthly Updated Mutual Fund Picks

Financial Tools

Free Personal Budget Software