Bond Yield Calculator by hedongchenchen

VIEWS: 6 PAGES: 1

									      Client:
 Investment:
Prepared by:

                 INPUTS                                                         RESULTS
Days in First "Odd" Period:      117                                    Maximum Accuracy:        $0.00
Greatest Common Devisor:          2                                 Period Yield to Maturity:   43.160%
   Last Cash Flow Period:         3                                Required YTM per Period:     43.160%
Number of Decimal Places:        10                                            Annual Yield:    86.320%

                                               DISCOUNT          INCOME    INCREASED                           PRINCIPAL
 PERIOD          DATE         CASH FLOWS                                             DIFFERENCE
                                               AMOUNTS         CALCULATION ACCURACY                           OUTSTANDING
            0   5-Dec-06         ($2,345.00)    Acquisition Cost
            1   1-Apr-07           $234.00           $185.92           $648.85       $648.85         $0.00         ($2,345.00)
            2   1-Oct-07           $234.00           $129.87          $1,191.15     $1,191.15       ($0.00)        ($2,759.85)
            3   1-Jan-08          $5,234.00        $2,029.05          $1,604.26     $1,604.26       ($0.00)        ($3,717.01)
            4                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
            5                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
            6                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
            7                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
            8                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
            9                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           10                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           11                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           12                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           13                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           14                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           15                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           16                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           17                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           18                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           19                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           20                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           21                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           22                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           23                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           24                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           25                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           26                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           27                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           28                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           29                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           30                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           31                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           32                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           33                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           34                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           35                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           36                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           37                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           38                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           39                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           40                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           41                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           42                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           43                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           44                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           45                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           46                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           47                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           48                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           49                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)
           50                         $0.00             $0.00             $0.00         $0.00        $0.00            ($87.27)

                                 $3,357.00        $2,344.84          $3,444.27    MAX ERROR:         $0.00          ($87.27)
                                                                                  MIN ERROR:        ($0.00)




                                    10/14/2011 3:16 AM d7430495-1e26-4d70-aa3b-1a721067773a.xls

								
To top