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)

8/12/2008 7:03 PM 2b803093-68b2-4fda-b2e7-1097a00bd1e0.xls


				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:426
posted:1/3/2008
language:English
pages:1
Jeff Sperry Jeff Sperry
About