FINA4920-BVTemplate0

FINA4920-BVTemplate0 - Student Name Contents Date Created...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Student Name Contents Date Created Date Modified Ford Bonds Face Value 1000 Coupon Rate 7.45% YTM 7.71% Frequency 1 PMT $74.50 Bond Price 1500 Bond YTM Year Cash Flow PV of CF Year Cash Flow 1 $74.50 $69.17 ($970.22) 2 $74.50 $64.21 1 $74.50 3 $74.50 $59.62 2 $74.50 4 $74.50 $55.35 3 $74.50 5 $74.50 $51.38 4 $74.50 6 $74.50 $47.70 5 $74.50 7 $74.50 $44.29 6 $74.50 8 $74.50 $41.12 7 $74.50 9 $74.50 $38.17 8 $74.50 10 $74.50 $35.44 9 $74.50 11 $74.50 $32.90 10 $74.50 12 $74.50 $30.55 11 $74.50 13 $74.50 $28.36 12 $74.50 14 $74.50 $26.33 13 $74.50 15 $74.50 $24.44 14 $74.50 16 $74.50 $22.69 15 $74.50 17 $74.50 $21.07 16 $74.50 18 $74.50 $19.56 17 $74.50 19 $74.50 $18.16 18 $74.50 20 $74.50 $16.86 19 $74.50 21 $74.50 $15.65 20 $74.50 22 $74.50 $14.53 21 $74.50 23 $74.50 $13.49 22 $74.50 24 $74.50 $12.52 23 $74.50 25 $74.50 $11.63 24 $74.50 26 $74.50 $10.80 25 $74.50 27 $74.50 $10.02 26 $74.50 28 $1,074.50 $134.20 27 $74.50 Bond Price Sum of CFs $970.22 28 $1,074.50 Bond Price NPV Fxn $970.22 YTM (IRR) 7.712% A B C D E F 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 XYZ Bonds Market interest rate 6.50% Face Value $1,000.00 Years to Maturity 7 Coupon Rate 7.00% Frequency 1 Coupon Payment $70.00 Bond Price Bond YTM Year Bond CF PV of CF Year Bond CF 1 70 $65.73 -1,027 2 70 $61.72 1 70.00 3 70 $57.95 2 70.00 4 70 $54.41 3 70.00 5 70 $51.09 4 70.00 6 70 $47.97 5 70.00 7 1,070 $688.55 6 70.00 Bond Value $1,027.42 7 1,070.00 NPV $1,027.42 YTM 6.50% A B C D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 22-Apr-88 6/6/2011 How many days I have live 8445 YTM of Ford Bonds Market price of bond 970.22 Year Bond Cash Flow 15-Sep-03-970.22 16-Jul-04 74.5 16-Jul-05 74.5 16-Jul-06 74.5 16-Jul-07 74.5 16-Jul-08 74.5 16-Jul-09 74.5 16-Jul-10 74.5 16-Jul-11 74.5 16-Jul-12 74.5 16-Jul-13 74.5 16-Jul-14 74.5 16-Jul-15 74.5 16-Jul-16 74.5 16-Jul-17 74.5 16-Jul-18 74.5 16-Jul-19 74.5 16-Jul-20 74.5 16-Jul-21 74.5 16-Jul-22 74.5 16-Jul-23 74.5 16-Jul-24 74.5 16-Jul-25 74.5 16-Jul-26 74.5 16-Jul-27 74.5 16-Jul-28 74.5 16-Jul-29 74.5 16-Jul-30 74.5 16-Jul-31 1074.5 YTM of bond (IRR) 7.712% INCORRECT YTM of bond (XIRR) 7.817% A B C 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 YTM - Semi-annual pmts Market price of bond 970.22 Year 15-Sep-03-970.22 16-Jan-04 37.25 16-Jul-04 37.25 16-Jan-05 37.25 16-Jul-05 37.25 16-Jan-06 37.25 16-Jul-06 37.25 16-Jan-07 37.25 16-Jul-07 37.25 16-Jan-08 37.25 16-Jul-08 37.25 16-Jan-09 37.25 16-Jul-09 37.25 16-Jan-10 37.25 16-Jul-10 37.25 16-Jan-11 37.25 16-Jul-11 37.25 16-Jan-12 37.25 16-Jul-12 37.25 16-Jan-13 37.25 16-Jul-13 37.25 16-Jan-14 37.25 16-Jul-14 37.25 16-Jan-15...
View Full Document

Page1 / 15

FINA4920-BVTemplate0 - Student Name Contents Date Created...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online