Bond Yield Calculator
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Bond Yield Calculator as PDF for free.
More details
- Words: 444
- Pages: 1
Client: Investment: Prepared by: INPUTS Days in First "Odd" Period: Greatest Common Devisor: Last Cash Flow Period: Number of Decimal Places: PERIOD
DATE 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
calculates accuracy
RESULTS Maximum Accuracy: Period Yield to Maturity: Required YTM per Period: Annual Yield:
117 2 3 10
CASH FLOWS
5-Dec-06 1-Apr-07 1-Oct-07 1-Jan-08
($2,345.00)
DISCOUNT AMOUNTS
INCOME CALCULATION
$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
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
$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
$3,357.00
$2,344.84
$3,444.27
INCREASED 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
MAX ERROR: MIN ERROR:
($87.27) -0.16 1 0.43 0
$0.00 43.160% 43.160% 86.320%
DIFFERENCE
3 PRINCIPAL OUTSTANDING
$0.00 ($0.00) ($0.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
($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)
$0.00 ($0.00)
($87.27)
{goto}f17~ 1~{goto}c13~1~ /xic14<5~/xge128~ +f17+1~{edit}{calc}~ /c~f17~ /xgb155~
04/27/2009 01:07:56 16926239.xls
3.12 0.28 $2,344.84 -0.16
DATE 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
calculates accuracy
RESULTS Maximum Accuracy: Period Yield to Maturity: Required YTM per Period: Annual Yield:
117 2 3 10
CASH FLOWS
5-Dec-06 1-Apr-07 1-Oct-07 1-Jan-08
($2,345.00)
DISCOUNT AMOUNTS
INCOME CALCULATION
$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
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
$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
$3,357.00
$2,344.84
$3,444.27
INCREASED 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
MAX ERROR: MIN ERROR:
($87.27) -0.16 1 0.43 0
$0.00 43.160% 43.160% 86.320%
DIFFERENCE
3 PRINCIPAL OUTSTANDING
$0.00 ($0.00) ($0.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
($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)
$0.00 ($0.00)
($87.27)
{goto}f17~ 1~{goto}c13~1~ /xic14<5~/xge128~ +f17+1~{edit}{calc}~ /c~f17~ /xgb155~
04/27/2009 01:07:56 16926239.xls
3.12 0.28 $2,344.84 -0.16
Related Documents
Bond Yield Calculator
April 2020 22
Bond Yield Calculator
June 2020 12
Bond Calculator
June 2020 18
Yield
May 2020 28
Bond Pricing - By Yield To Maturity
July 2020 4
Bond
November 2019 67More Documents from ""
Portfolio Monitoring,,nit Durgapur
April 2020 16
Bond Yield Calculator
April 2020 22
Fundamental Analysis Of Pantaloon,mba,nit Durgapur
April 2020 20
Cost Of Caital - Tata Chemicals
April 2020 19
Poters Five Model Of Tata Tele,mba,nit Durgapur
April 2020 4