BondValu - BOND PRICE VALUE OF A BOND This Model Calculates...

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

View Full Document Right Arrow Icon
VALUE OF A BOND This Model Calculates The Value / Price of a Bond Assumes Semiannual Interest Payments 25 Year Maximum (Maturity); Years Entered As .5, 1.0, 1.5, 2.0, etc. PERIOD INPUTS 0 ($1,000.00) ($1,000.00) ($1,000.00) ($705.46) $1,000.00 1 $50.00 $46.30 $0.00 $0.00 $46.30 $50.00 10.00% 2 $50.00 $42.87 $0.00 $0.00 $42.87 $50.00 10.0 3 $50.00 $39.69 $0.00 $0.00 $39.69 $50.00 4 $50.00 $36.75 $0.00 $0.00 $36.75 $50.00 10.00% 8.00% 5 $50.00 $34.03 $0.00 $0.00 $34.03 $50.00 6 $50.00 $31.51 $0.00 $0.00 $31.51 $50.00 7 $50.00 $29.17 $0.00 $0.00 $29.17 $50.00 8 $50.00 $27.01 $0.00 $0.00 $27.01 $50.00 9 $50.00 $25.01 $0.00 $0.00 $25.01 $50.00 OUTPUT 10 $50.00 $23.16 $0.00 $0.00 $23.16 $50.00 PRICE / VALUE OF BOND $705.46 11 $50.00 $21.44 $0.00 $0.00 $21.44 $50.00 12 $50.00 $19.86 $0.00 $0.00 $19.86 $50.00 13 $50.00 $18.38 $0.00 $0.00 $18.38 $50.00 14 $50.00 $17.02 $0.00 $0.00 $17.02 $50.00 15 $50.00 $15.76 $0.00 $0.00 $15.76 $50.00 DATA TABLE ROR CHANGES $705.46 16 $50.00 $14.59 $0.00 $0.00 $14.59 $50.00 16% $705.46 17 $50.00 $13.51 $0.00 $0.00 $13.51 $50.00 15% $705.46 18 $50.00 $12.51 $0.00 $0.00 $12.51 $50.00 14% $705.46 19 $50.00 $11.59 $0.00 $0.00 $11.59 $50.00 13% $705.46 20 $50.00 $10.73 $1,000.00 $214.55 $225.28 $1,050.00 12% $705.46 21 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 11% $705.46 22 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10% $705.46 23 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 9% $705.46 24 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 8% $705.46 25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 7% $705.46 26 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 6% $705.46 27 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 5% $705.46 28 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 4% $705.46 29 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 3% $705.46 30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 2% $705.46 31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 1% $705.46 32 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 33 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 34 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 35 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 36 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 37 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 38 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 39 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 41 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 42 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 43 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 44 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 46 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 47 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 48 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 49 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 50 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 NPV = IRR = $705.46 16.00% INTEREST CASH FLOWS DISCOUNTED INTEREST CASH FLOWS PRINCIPAL CASH FLOWS DISCOUNTED PRINCIPAL CASH FLOWS SUM OF DISCOUNTED CASH FLOWS CASH FLOWS FOR CALCULATION OF
Background image of page 1

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

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

This note was uploaded on 12/14/2011 for the course MGT 268 taught by Professor Paragkosalge during the Spring '08 term at Grand Valley State.

Page1 / 3

BondValu - BOND PRICE VALUE OF A BOND This Model Calculates...

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

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