Bondsxls - Paul McFedries Tech Tonic by tyndale

VIEWS: 11 PAGES: 10

									           Current Date      8/23/2004

                                                   Price Per
         Bond             Maturity Date   Coupon      $100     Yield
Bell                      Jun 15, 2009     6.15%   $ 99.230    6.34%
Royal Bank                Apr 12, 2011     6.30%   $ 102.210   5.89%
Logophilia Limited        Apr 12, 2012     6.25%   $ 97.750    6.63%
Life Capital Trust        Jun 30, 2012    6.679%   $ 101.430   6.44%
Manitoba Manufacturing    Sep 01, 2009     6.25%   $ 103.800   5.38%
Brunswick                 Jun 15, 2010     6.38%   $ 103.772   5.60%
Ontario Industrial        Dec 12, 2011     7.75%   $ 107.600   6.43%
Brimson Furniture         Sep 08, 2009     8.10%   $ 107.709   6.29%
John Hancock              May 31, 2011     6.67%   $ 104.100   5.93%
Calculating Bond Prices
Settlement Date   August 23, 2004
Maturity Date       April 12, 2011
Coupon                      6.30%
Yield                       6.00%
Redemption                     100
Frequency                        2
Basis                            0
Price                   $101.61
Calculating Bond Duration
Settlement Date   August 23, 2004
Maturity Date       April 12, 2011
Coupon                      6.30%
Yield                       6.00%
Frequency                        2
Basis                            0
Duration                      5.4
                                          Face            Total Face
         Bond            Maturity Date   Value    Units     Value      Year
Bell                     Jun 15, 2009    $1,000    20        $20,000     2009
Royal Bank               Apr 12, 2011    $1,000    30        $30,000     2010
Logophilia Limited       Apr 12, 2012    $1,000    30        $30,000     2011
Life Capital Trust       Jun 30, 2010    $1,000    25        $25,000     2012
Manitoba Manufacturing   Sep 01, 2009    $1,000    15        $15,000
Brunswick                Jun 15, 2010    $1,000    30        $30,000
Ontario Industrial       Dec 12, 2011    $1,000    30        $30,000
Brimson Furniture        Sep 08, 2009    $1,000    15        $15,000
John Hancock             May 31, 2012    $1,000    35        $35,000
Face Value
 Maturing
   $50,000
   $55,000
   $60,000
   $65,000
Working with Coupons
Issue Date        March 8, 2000                   Coupon Payment            $25.00
Settlement Date    May 8, 2004             Coupon Days in Period                180
Maturity Date     March 8, 2011             Previous Coupon Date      March 8, 2004
Coupon                   5.00%    Coupon Days Since Last Payment                 60
Face Value              $1,000                   Next Coupon Date September 8, 2004
Frequency                     2     Coupon Days To Next Payment                 120
Basis                         0                    Accrued Interest          $8.33
                                     Coupon Payments to Maturity                 14
                                          Total Interest to Maturity       $341.67
=B5 * B6 / B7
=COUPDAYS(B3, B4, B7, B8)
=COUPPCD(B3, B4, B7, B8)
=COUPDAYBS(B3, B4, B7, B8)
=COUPNCD(B3, B4, B7, B8)
=COUPDAYSNC(B3, B4, B7, B8)
=E2 * (E5 / E3)
=COUPNUM(B3,B4,B7,B8)
=E9 * E2 - E8
Zero-Coupon Bond Yield
Settlement Date   August 23, 2004
Maturity Date       April 12, 2024
Coupon                      0.00%
Price                      $35.00
Redemption                   $100
Frequency                        2
Basis                            0
Yield                     5.42%

Zero-Coupon Bond Price
Settlement Date   August 23, 2004
Maturity Date       April 12, 2024
Coupon                      0.00%
Yield                       5.50%
Redemption                     100
Frequency                        2
Basis                            0
Price                    $34.46
Calculating T-Bill Yields
Settlement Date   August 23, 2004
Maturity Date       April 15, 2005
Price                      $98.75
Yield                     1.94%
Calculating T-Bill Prices
Settlement Date   August 23, 2004
Maturity Date       April 15, 2005
Discount                    1.50%
Price                    $99.02

								
To top