# Calculator by tyndale

VIEWS: 39 PAGES: 5

• pg 1
```									Dated date                               1/15/2009
Next interest payment date               7/15/2009                  181 no. of days this six months   unadjusted price           100.359375
Settlement date                          6/19/2009                  155 no. of days accrued           adjusted price              99.577575
coupon                                     0.02500
per                                           1,000                   25 annual interest              par purchased             1,000,000.00
12.5 semiannual interest
unrounded     0.06906077348066                                Inflation adjustment    -7,790.0000000
unadjusted accrued interest per \$1000   rounded 5              10.70442
inflation index on settlement day                                          0.99221                    premium(discount)      3,565.75000000
adjusted accrued interest per \$1000     rounded 5              10.62103
995,775.7500000

Accrued interest             10,621.03

Settlement cost           1,006,396.78

1,006,396.78

0.00
1,003,593.75

-11,383.75

992,210.00
9,922.10
995,775.75
3,565.75
Settlement Calculator for Coupon Notes and Bonds including TIPS
Red values are your inputs
Inputs                    example               Input Values                   Definitions
Unadjusted Price                             100.359375               100.359375               This is the price per \$100 before multiplying by the index-ratio, ex
Coupon Interest Rate                             2.500%                   2.500%               This is the fixed-interest percentage at an annual rate expressed
Par purchased                                 \$1,000,000               \$1,000,000              This is the total amount of face value purchased expressed in \$1
Index-ratio on settlement date                   0.99221                  0.99221              This is the inflation adjustment, above one is inflation and below
Settlement date                                6/19/2009                6/19/2009              This is the date payment is made expressed as mm/dd/yyyy
Next interest payment date                     7/15/2009                7/15/2009              This is the next interest payment date to calculate accrued intere

Results
Adjusted Price                                99.577575                99.577575
Par purchased                             \$1,000,000.00            \$1,000,000.00
Inflation adjustment                         -\$7,790.00               -\$7,790.00 Tax Note:1    The change in Inflation adjustment is taxable annually.
Premium(Discount)                              \$3,565.75                \$3,565.75 Tax Note:2   The Premium(Discount) is subject to tax over the life of the secu
Gross Amount                                \$995,775.75              \$995,775.75
Accrued Interest                               10,621.03                10,621.03 Tax Note:3   Accrued Interest is tax deductible.
Total Settlement Cost                     \$1,006,396.78            \$1,006,396.78

Adjusted Par Holdings                       \$992,210.00              \$992,210.00               ***To find the index ratios, go to http://www.treasurydirect.gov/ins

Note: For unoffical use only

In versions of Excel prior to
Excel 2007, the EOMONTH
function is a part of the
Analysis Toolpak. If you get
an error when you try to
use the function, you can
make sure the toolpak is
loaded in this manner:

1.   Choose Add-Ins from
the Tools menu. Excel
dialog box.
2.  Make sure the
Analysis Toolpak check
box is selected.
3.  Click on OK.
ing by the index-ratio, expressed to 6 decimal places.
n annual rate expressed to 3 decimal places.
chased expressed in \$100 increments.
ne is inflation and below one is deflation, expressed to 5 decimal places.***
sed as mm/dd/yyyy
calculate accrued interest expressed as mm/dd/yyyy

able annually.
over the life of the security.

ww.treasurydirect.gov/instit/annceresult/tipscpi/tipscpi_hiscpi.htm. Note: for non-TIPS, use 1.00000

```
To top