Excel Spreadsheets: quick calculation of the total investment yields from a fixed interest bond

Investment-Calc Excel Spreadsheets Securities Calc V3.0

Investment-Calc Securities Calc V3.0 provides quick answers to price, yields to redemption and OID (Original Issue Discount) for T-Bills, CDs and Fixed, Variable and Zero Coupon Bonds.

Original Issue Discounts, Pricing and Rate of Return calculations for T-Bills, CDs, Commercial Paper and Bills of Exchange are all provided in this spreadsheet.

Use this spreadsheet for quick calculation of the total investment yields from a fixed interest bond with any settlement, redemption price and coupon rate. Any combination of Day Count Basis and Frequency can be selected. The Duration figure will tell you how long it will take to recover your original investment. Duration is used to compare the total return values from different bonds.

This spreadsheet calculates the yield from zero coupon bonds.

This spreadsheet calculates the variation in bond prices (row F16 >) in any yearly yield environment as years move forward from the settlement date. The lower table calculates bond prices (column F21 & downwards) with increasing yield increments for any coupon rate, settlement and redemption dates to create the reverse yield curve chart to the right.

Investment-Calc Securities Calc V3.0 is included in All Programs Gold Edition Collection of Business Support Programs for Excel which contains also many other business support programs.

System Requirements

Platform : Windows or Mac & MS Excel 95/Excel97/Excel 2000/Excel XP/Excel 2002/Excel 2003 or MS Office 7(95) or later.

Order

30 day money back guarantee!