Docstoc

Bond Yield Calculator

Document Sample
Bond Yield Calculator Powered By Docstoc
					Client: Investment: Prepared by: INPUTS Days in First "Odd" Period: Greatest Common Devisor: Last Cash Flow Period: Number of Decimal Places: PERIOD
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

117 2 3 10

RESULTS Maximum Accuracy: Period Yield to Maturity: Required YTM per Period: Annual Yield: DISCOUNT AMOUNTS

$0.00 43.160% 43.160% 86.320%

DATE
5-Dec-06 1-Apr-07 1-Oct-07 1-Jan-08

CASH FLOWS
($2,345.00)
$234.00 $234.00 $5,234.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

INCOME INCREASED DIFFERENCE CALCULATION ACCURACY
$648.85 $1,191.15 $1,604.26 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $648.85 $1,191.15 $1,604.26 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($0.00) ($0.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

PRINCIPAL OUTSTANDING
($2,345.00) ($2,759.85) ($3,717.01) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27) ($87.27)

Acquisition Cost $185.92 $129.87 $2,029.05 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

$3,357.00

$2,344.84

$3,444.27

MAX ERROR: MIN ERROR:

$0.00 ($0.00)

($87.27)

11/14/2009 5:42 AM b7c499c7-8454-442b-b6f5-189551b9e23d.xls


				
DOCUMENT INFO
Shared By:
Stats:
views:435
posted:11/14/2009
language:English
pages:1
Description: The Bond Yield Calculator for Excel enables the automatic generation of scheduled bond payments and the calculation of resulting yield to maturity. The model is equipped to handle 'odd' first time periods and is ideal to speed up bond payment and yield calculations.