financial modeling

profilebigant856
Take-HomeExamII_.xlsx
Home>Business & Finance homework help>Financial markets homework help>financial modeling

Bond Pricing

T-BOND 6.250% of 15-Aug-2023 Yield Price
0.0%
Coupon (%) 6.250% 0.2%
Coupon Frequency (per year) 2 0.4%
Dated Date 8/15/93 0.6%
Maturity Date 8/15/23 0.8%
1.0%
Pricing Date 3/28/14 1.2%
Yield to maturity 2.551% 1.4%
1.6%
Remaining Coupons 1.8%
Next Coupon Date 2.0%
Previous Coupon Date 2.2%
Current Coupon Period 2.4%
Days of Accrued Interest 2.6%
Percent of Coupon Period Elapsed 2.8%
Accrued Interest (per $100 par) 3.0%
Excel's ACCRINT function 3.2%
3.4%
"Dirty" price 3.6%
"Clean" price 3.8%
Excel's PRICE function 4.0%
Hundreds 4.2%
32nds 4.4%
4.6%
4.8%
5.0%
5.2%
5.4%
5.6%
5.8%
6.0%
6.2%
6.4%
6.6%
6.8%
7.0%
7.2%
7.4%
7.6%
7.8%

Price-Yield Relationship

Price 0 2E-3 4.0000000000000001E-3 6.0000000000000001E-3 8.0000000000000002E-3 0.01 1.2E-2 1.4E-2 1.6E-2 1.7999999999999999E-2 0.02 2.1999999999999999E-2 2.4E-2 2.5999999999999999E-2 2.8000000000000001E-2 0.03 3.2000000000000001E-2 3.4000000000000002E-2 3.5999999999999997E-2 3.7999999999999999E-2 0.04 4.2000000000000003E-2 4.3999999999999997E-2 4.5999999999999999E-2 4.8000000000000001E-2 0.05 5.1999999999999998E-2 5.3999999999999999E-2 5.6000000000000001E-2 5.8000000000000003E-2 0.06 6.2E-2 6.4000000000000001E-2 6.6000000000000003E-2 6.8000000000000005E-2 7.0000000000000007E-2 7.1999999999999995E-2 7.3999999999999996E-2 7.5999999999999998E-2 7.8E-2

Yield to Maturity

Price

Bond Data

Pricing (Settlement) Date 3/15/14
Type Issue Price Coupon(%) Maturity Previous Coupon Date Next Coupon Date Days in Coupon Period Days since Last Coupon Accrued Interest Invoice Price YTM
Treas T-NOTE 1.250 15-Apr-2014 100.07 1.25 15-Apr-14
Treas T-NOTE 1.875 30-Apr-2014 100.18 1.875 30-Apr-14
Treas T-NOTE 0.250 30-Apr-2014 100.03 0.25 30-Apr-14
Treas T-NOTE 4.750 15-May-2014 100.64 4.75 15-May-14
Treas T-NOTE 1.000 15-May-2014 100.14 1 15-May-14
Treas T-NOTE 2.250 31-May-2014 100.4 2.25 31-May-14
Treas T-NOTE 0.250 31-May-2014 100.05 0.25 31-May-14
Treas T-NOTE 0.750 15-Jun-2014 100.17 0.75 15-Jun-14
Treas T-NOTE 2.625 30-Jun-2014 100.69 2.625 30-Jun-14
Treas T-NOTE 0.250 30-Jun-2014 100.07 0.25 30-Jun-14
Treas T-NOTE 0.625 15-Jul-2014 100.19 0.625 15-Jul-14
Treas T-NOTE 2.625 31-Jul-2014 100.9 2.625 31-Jul-14
Treas T-NOTE 0.125 31-Jul-2014 100.03 0.125 31-Jul-14
Treas T-NOTE 4.250 15-Aug-2014 101.64 4.25 15-Aug-14
Treas T-NOTE 0.500 15-Aug-2014 100.18 0.5 15-Aug-14
Treas T-NOTE 2.375 31-Aug-2014 100.99 2.375 31-Aug-14
Treas T-NOTE 0.250 31-Aug-2014 100.09 0.25 31-Aug-14
Treas T-NOTE 0.250 15-Sep-2014 100.11 0.25 15-Sep-14
Treas T-NOTE 2.375 30-Sep-2014 101.19 2.375 30-Sep-14
Treas T-NOTE 0.250 30-Sep-2014 100.11 0.25 30-Sep-14
Treas T-NOTE 0.500 15-Oct-2014 100.25 0.5 15-Oct-14
Treas T-NOTE 2.375 31-Oct-2014 101.37 2.375 31-Oct-14
Treas T-NOTE 0.250 31-Oct-2014 100.12 0.25 31-Oct-14
Treas T-NOTE 4.250 15-Nov-2014 102.65 4.25 15-Nov-14
Treas T-NOTE 0.375 15-Nov-2014 100.19 0.375 15-Nov-14
Treas T-NOTE 2.125 30-Nov-2014 101.39 2.125 30-Nov-14
Treas T-NOTE 0.250 30-Nov-2014 100.12 0.25 30-Nov-14
Treas T-NOTE 0.250 15-Dec-2014 100.13 0.25 15-Dec-14
Treas T-NOTE 2.625 31-Dec-2014 101.93 2.625 31-Dec-14
Treas T-NOTE 0.125 31-Dec-2014 100.04 0.125 31-Dec-14
Treas T-NOTE 0.250 15-Jan-2015 100.12 0.25 15-Jan-15
Treas T-NOTE 2.250 31-Jan-2015 101.82 2.25 31-Jan-15
Treas T-NOTE 0.250 31-Jan-2015 100.13 0.25 31-Jan-15
Treas T-BOND 11.250 15-Feb-2015 109.91 11.25 15-Feb-15
Treas T-NOTE 4.000 15-Feb-2015 103.46 4 15-Feb-15
Treas T-NOTE 0.250 15-Feb-2015 100.12 0.25 15-Feb-15
Treas T-NOTE 2.375 28-Feb-2015 102.08 2.375 28-Feb-15
Treas T-NOTE 0.250 28-Feb-2015 100.12 0.25 28-Feb-15
Treas T-NOTE 0.375 15-Mar-2015 100.25 0.375 15-Mar-15
Treas T-NOTE 2.500 31-Mar-2015 102.39 2.5 31-Mar-15
Treas T-NOTE 0.250 31-Mar-2015 100.12 0.25 31-Mar-15
Treas T-NOTE 0.375 15-Apr-2015 100.26 0.375 15-Apr-15
Treas T-NOTE 2.500 30-Apr-2015 102.57 2.5 30-Apr-15
Treas T-NOTE 0.125 30-Apr-2015 100 0.125 30-Apr-15
Treas T-NOTE 4.125 15-May-2015 104.5 4.125 15-May-15
Treas T-NOTE 0.250 15-May-2015 100.13 0.25 15-May-15
Treas T-NOTE 2.125 31-May-2015 102.31 2.125 31-May-15
Treas T-NOTE 0.250 31-May-2015 100.12 0.25 31-May-15
Treas T-NOTE 0.375 15-Jun-2015 100.28 0.375 15-Jun-15
Treas T-NOTE 1.875 30-Jun-2015 102.16 1.875 30-Jun-15
Treas T-NOTE 0.375 30-Jun-2015 100.28 0.375 30-Jun-15
Treas T-NOTE 0.250 15-Jul-2015 100.11 0.25 15-Jul-15
Treas T-NOTE 1.750 31-Jul-2015 102.12 1.75 31-Jul-15
Treas T-NOTE 0.250 31-Jul-2015 100.11 0.25 31-Jul-15
Treas T-BOND 10.625 15-Aug-2015 114.51 10.625 15-Aug-15
Treas T-NOTE 4.250 15-Aug-2015 105.63 4.25 15-Aug-15
Treas T-NOTE 0.250 15-Aug-2015 100.09 0.25 15-Aug-15
Treas T-NOTE 1.250 31-Aug-2015 101.51 1.25 31-Aug-15
Treas T-NOTE 0.375 31-Aug-2015 100.25 0.375 31-Aug-15
Treas T-NOTE 0.250 15-Sep-2015 100.05 0.25 15-Sep-15
Treas T-NOTE 1.250 30-Sep-2015 101.53 1.25 30-Sep-15
Treas T-NOTE 0.250 30-Sep-2015 100.05 0.25 30-Sep-15
Treas T-NOTE 0.250 15-Oct-2015 100 0.25 15-Oct-15
Treas T-NOTE 1.250 31-Oct-2015 101.55 1.25 31-Oct-15
Treas T-NOTE 0.250 31-Oct-2015 99.98 0.25 31-Oct-15
Treas T-BOND 9.875 15-Nov-2015 115.71 9.875 15-Nov-15
Treas T-NOTE 4.500 15-Nov-2015 106.87 4.5 15-Nov-15
Treas T-NOTE 0.375 15-Nov-2015 100.15 0.375 15-Nov-15
Treas T-NOTE 0.250 30-Nov-2015 99.93 0.25 30-Nov-15
Treas T-NOTE 1.375 30-Nov-2015 101.8 1.375 30-Nov-15
Treas T-NOTE 0.250 15-Dec-2015 99.89 0.25 15-Dec-15
Treas T-NOTE (DBL OLD 2YR) 0.250 31-Dec-2015 99.86 0.25 31-Dec-15
Treas T-NOTE 2.125 31-Dec-2015 103.13 2.125 31-Dec-15
Treas T-NOTE 0.375 15-Jan-2016 100.05 0.375 15-Jan-16
Treas T-NOTE (OLD 2YR) 0.375 31-Jan-2016 100.03 0.375 31-Jan-16
Treas T-NOTE 2.000 31-Jan-2016 103.01 2 31-Jan-16
Treas T-BOND 9.250 15-Feb-2016 116.76 9.25 15-Feb-16
Treas T-NOTE 4.500 15-Feb-2016 107.78 4.5 15-Feb-16
Treas T-NOTE 0.375 15-Feb-2016 99.99 0.375 15-Feb-16
Treas T-NOTE (2YR) 0.250 29-Feb-2016 99.71 0.25 29-Feb-16
Treas T-NOTE 2.625 29-Feb-2016 104.28 2.625 29-Feb-16
Treas T-NOTE 2.125 29-Feb-2016 103.32 2.125 29-Feb-16
Treas T-NOTE 0.375 15-Mar-2016 99.92 0.375 15-Mar-16
Treas T-NOTE 0.375 31-Mar-2016 99.87 0.375 31-Mar-16
Treas T-NOTE 2.375 31-Mar-2016 103.91 2.375 31-Mar-16
Treas T-NOTE 2.250 31-Mar-2016 103.62 2.25 31-Mar-16
Treas T-NOTE 0.250 15-Apr-2016 99.58 0.25 15-Apr-16
Treas T-NOTE 2.625 30-Apr-2016 104.51 2.625 30-Apr-16
Treas T-NOTE 2.000 30-Apr-2016 103.19 2 30-Apr-16
Treas T-BOND 7.250 15-May-2016 114.42 7.25 15-May-16
Treas T-NOTE 5.125 15-May-2016 109.9 5.125 15-May-16
Treas T-NOTE 0.250 15-May-2016 99.5 0.25 15-May-16
Treas T-NOTE 3.250 31-May-2016 106 3.25 31-May-16
Treas T-NOTE 1.750 31-May-2016 102.68 1.75 31-May-16
Treas T-NOTE 0.500 15-Jun-2016 99.94 0.5 15-Jun-16
Treas T-NOTE 3.250 30-Jun-2016 106.11 3.25 30-Jun-16
Treas T-NOTE 1.500 30-Jun-2016 102.13 1.5 30-Jun-16
Treas T-NOTE 0.625 15-Jul-2016 100.11 0.625 15-Jul-16
Treas T-NOTE 3.250 31-Jul-2016 106.23 3.25 31-Jul-16
Treas T-NOTE 1.500 31-Jul-2016 102.13 1.5 31-Jul-16
Treas T-NOTE 4.875 15-Aug-2016 110.14 4.875 15-Aug-16
Treas T-NOTE 0.625 15-Aug-2016 100.03 0.625 15-Aug-16
Treas T-NOTE 3.000 31-Aug-2016 105.75 3 31-Aug-16
Treas T-NOTE 1.000 31-Aug-2016 100.89 1 31-Aug-16
Treas T-NOTE 0.875 15-Sep-2016 100.54 0.875 15-Sep-16
Treas T-NOTE 3.000 30-Sep-2016 105.86 3 30-Sep-16
Treas T-NOTE 1.000 30-Sep-2016 100.82 1 30-Sep-16
Treas T-NOTE 0.625 15-Oct-2016 99.83 0.625 15-Oct-16
Treas T-NOTE 3.125 31-Oct-2016 106.23 3.125 31-Oct-16
Treas T-NOTE 1.000 31-Oct-2016 100.75 1 31-Oct-16
Treas T-BOND 7.500 15-Nov-2016 117.79 7.5 15-Nov-16
Treas T-NOTE 4.625 15-Nov-2016 110.19 4.625 15-Nov-16
Treas T-NOTE 0.625 15-Nov-2016 99.71 0.625 15-Nov-16
Treas T-NOTE 2.750 30-Nov-2016 105.3 2.75 30-Nov-16
Treas T-NOTE 0.875 30-Nov-2016 100.33 0.875 30-Nov-16
Treas T-NOTE 0.625 15-Dec-2016 99.61 0.625 15-Dec-16
Treas T-NOTE 3.250 31-Dec-2016 106.72 3.25 31-Dec-16
Treas T-NOTE 0.875 31-Dec-2016 100.21 0.875 31-Dec-16
Treas T-NOTE (DBL OLD 3YR) 0.750 15-Jan-2017 99.83 0.75 15-Jan-17
Treas T-NOTE 3.125 31-Jan-2017 106.48 3.125 31-Jan-17
Treas T-NOTE 0.875 31-Jan-2017 100.11 0.875 31-Jan-17
Treas T-NOTE (OLD 3YR) 0.625 15-Feb-2017 99.36 0.625 15-Feb-17
Treas T-NOTE 4.625 15-Feb-2017 110.78 4.625 15-Feb-17
Treas T-NOTE 3.000 28-Feb-2017 106.16 3 28-Feb-17
Treas T-NOTE 0.875 28-Feb-2017 100 0.875 28-Feb-17
Treas T-NOTE (3YR) 0.750 15-Mar-2017 99.61 0.75 15-Mar-17
Treas T-NOTE 3.250 31-Mar-2017 106.99 3.25 31-Mar-17
Treas T-NOTE 1.000 31-Mar-2017 100.25 1 31-Mar-17
Treas T-NOTE 3.125 30-Apr-2017 106.64 3.125 30-Apr-17
Treas T-NOTE 0.875 30-Apr-2017 99.77 0.875 30-Apr-17
Treas T-BOND 8.750 15-May-2017 124.13 8.75 15-May-17
Treas T-NOTE 4.500 15-May-2017 110.91 4.5 15-May-17
Treas T-NOTE 2.750 31-May-2017 105.5 2.75 31-May-17
Treas T-NOTE 0.625 31-May-2017 98.85 0.625 31-May-17
Treas T-NOTE 2.500 30-Jun-2017 104.71 2.5 30-Jun-17
Treas T-NOTE 0.750 30-Jun-2017 99.08 0.75 30-Jun-17
Treas T-NOTE 2.375 31-Jul-2017 104.28 2.375 31-Jul-17
Treas T-NOTE 0.500 31-Jul-2017 98.1 0.5 31-Jul-17
Treas T-BOND 8.875 15-Aug-2017 126.04 8.875 15-Aug-17
Treas T-NOTE 4.750 15-Aug-2017 112.23 4.75 15-Aug-17
Treas T-NOTE 1.875 31-Aug-2017 102.57 1.875 31-Aug-17
Treas T-NOTE 0.625 31-Aug-2017 98.32 0.625 31-Aug-17
Treas T-NOTE 1.875 30-Sep-2017 102.51 1.875 30-Sep-17
Treas T-NOTE 0.625 30-Sep-2017 98.17 0.625 30-Sep-17
Treas T-NOTE 1.875 31-Oct-2017 102.45 1.875 31-Oct-17
Treas T-NOTE 0.750 31-Oct-2017 98.42 0.75 31-Oct-17
Treas T-NOTE 4.250 15-Nov-2017 110.89 4.25 15-Nov-17
Treas T-NOTE 2.250 30-Nov-2017 103.7 2.25 30-Nov-17
Treas T-NOTE 0.625 30-Nov-2017 97.81 0.625 30-Nov-17
Treas T-NOTE 2.750 31-Dec-2017 105.54 2.75 31-Dec-17
Treas T-NOTE 0.750 31-Dec-2017 98.1 0.75 31-Dec-17
Treas T-NOTE 2.625 31-Jan-2018 105.04 2.625 31-Jan-18
Treas T-NOTE 0.875 31-Jan-2018 98.42 0.875 31-Jan-18
Treas T-NOTE 3.500 15-Feb-2018 108.34 3.5 15-Feb-18
Treas T-NOTE 2.750 28-Feb-2018 105.51 2.75 28-Feb-18
Treas T-NOTE 0.750 28-Feb-2018 97.75 0.75 28-Feb-18
Treas T-NOTE 2.875 31-Mar-2018 105.98 2.875 31-Mar-18
Treas T-NOTE 0.750 31-Mar-2018 97.58 0.75 31-Mar-18
Treas T-NOTE 0.125 15-Apr-2018 102.45 0.125 15-Apr-18
Treas T-NOTE 2.625 30-Apr-2018 104.98 2.625 30-Apr-18
Treas T-NOTE 0.625 30-Apr-2018 96.94 0.625 30-Apr-18
Treas T-BOND 9.125 15-May-2018 131.44 9.125 15-May-18
Treas T-NOTE 3.875 15-May-2018 110.08 3.875 15-May-18
Treas T-NOTE 2.375 31-May-2018 103.92 2.375 31-May-18
Treas T-NOTE 1.000 31-May-2018 98.24 1 31-May-18
Treas T-NOTE 2.375 30-Jun-2018 103.89 2.375 30-Jun-18
Treas T-NOTE 1.375 30-Jun-2018 99.61 1.375 30-Jun-18
Treas T-NOTE 2.250 31-Jul-2018 103.28 2.25 31-Jul-18
Treas T-NOTE 1.375 31-Jul-2018 99.49 1.375 31-Jul-18
Treas T-NOTE 4.000 15-Aug-2018 110.84 4 15-Aug-18
Treas T-NOTE 1.500 31-Aug-2018 99.89 1.5 31-Aug-18
Treas T-NOTE 1.375 30-Sep-2018 99.21 1.375 30-Sep-18
Treas T-NOTE 1.750 31-Oct-2018 100.8 1.75 31-Oct-18
Treas T-NOTE 1.250 31-Oct-2018 98.52 1.25 31-Oct-18
Treas T-BOND 9.000 15-Nov-2018 133.57 9 15-Nov-18
Treas T-NOTE 3.750 15-Nov-2018 109.79 3.75 15-Nov-18
Treas T-NOTE 1.250 30-Nov-2018 98.38 1.25 30-Nov-18
Treas T-NOTE 1.375 30-Nov-2018 99.01 1.375 30-Nov-18
Treas T-NOTE (DBL OLD 5YR) 1.500 31-Dec-2018 99.39 1.5 31-Dec-18
Treas T-NOTE 1.375 31-Dec-2018 98.86 1.375 31-Dec-18
Treas T-NOTE (OLD 5YR) 1.500 31-Jan-2019 99.25 1.5 31-Jan-19
Treas T-NOTE 1.250 31-Jan-2019 98.1 1.25 31-Jan-19
Treas T-BOND 8.875 15-Feb-2019 134.32 8.875 15-Feb-19
Treas T-NOTE 2.750 15-Feb-2019 105.14 2.75 15-Feb-19
Treas T-NOTE (5YR) 1.500 28-Feb-2019 99.13 1.5 28-Feb-19
Treas T-NOTE 1.375 28-Feb-2019 98.53 1.375 28-Feb-19
Treas T-NOTE 1.625 31-Mar-2019 99.61 1.625 31-Mar-19
Treas T-NOTE 1.500 31-Mar-2019 98.98 1.5 31-Mar-19
Treas T-NOTE 1.250 30-Apr-2019 97.58 1.25 30-Apr-19
Treas T-NOTE 3.125 15-May-2019 106.86 3.125 15-May-19
Treas T-NOTE 1.125 31-May-2019 96.76 1.125 31-May-19
Treas T-NOTE 1.000 30-Jun-2019 95.92 1 30-Jun-19
Treas T-NOTE 0.875 31-Jul-2019 95.11 0.875 31-Jul-19
Treas T-BOND 8.125 15-Aug-2019 132.82 8.125 15-Aug-19
Treas T-NOTE 3.625 15-Aug-2019 109.38 3.625 15-Aug-19
Treas T-NOTE 1.000 31-Aug-2019 95.55 1 31-Aug-19
Treas T-NOTE 1.000 30-Sep-2019 95.36 1 30-Sep-19
Treas T-NOTE 1.250 31-Oct-2019 96.58 1.25 31-Oct-19
Treas T-NOTE 3.375 15-Nov-2019 108.07 3.375 15-Nov-19
Treas T-NOTE 1.000 30-Nov-2019 94.95 1 30-Nov-19
Treas T-NOTE 1.125 31-Dec-2019 95.47 1.125 31-Dec-19
Treas T-NOTE 1.375 31-Jan-2020 96.67 1.375 31-Jan-20
Treas T-BOND 8.500 15-Feb-2020 136.91 8.5 15-Feb-20
Treas T-NOTE 3.625 15-Feb-2020 109.36 3.625 15-Feb-20
Treas T-NOTE 1.250 29-Feb-2020 95.76 1.25 29-Feb-20
Treas T-NOTE 1.125 31-Mar-2020 94.89 1.125 31-Mar-20

Corporate Bond

Pricing (Settlement) Date 3/15/14
Coupon Rate 8.125
Maturity 3/15/17
Maturity (years) 3
Static Spread 3.500%
Price $ - 0
YTM
Type Issue Price Coupon(%) Maturity YTM Term (yrs) Zero Price Spot Rate Pricing Yield Corporate Zero Price Cash Flow Value
$ - 0

Static Spread

Pricing (Settlement) Date 3/15/14 3/15/14
Coupon Rate 3.25 1.75
Maturity 9/15/16 9/15/15
Maturity (years) 2.5 1.5
Static Spread
Observed Price $ 101.16 $ 99.53
Calculated Price $ - 0 $ - 0
YTM
Term (yrs) Spot Rate Pricing Yield Treasury Zero Price Corporate Zero Price Cash Flow Value
$ - 0
Term (yrs) Spot Rate Pricing Yield Treasury Zero Price Corporate Zero Price Cash Flow Value
$ - 0