Project 2 - Problem 1 The Green Cells are Input Cells. The...

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

View Full Document Right Arrow Icon
Problem 1 Problem 2 Price Calculator Term YTM Term to Maturity 20 20 10% Yield to Maturity 10% 5 10% Coupon Rate 5% Face Value 1000 20 10% Price $571.02 20 5% Coupon Rate Calculator 20 10% Term to Maturity 20 20 10% Yield to Maturity 10% Face Value 1000 Price 571.02 Coupon Rate 5% YTM Calculator Term to Maturity 20 Coupon Rate 5% Face Value 1000 Price 571.02 Yield to Maturity 10% Term to Maturity Calculator Yield to Maturity 10% Coupon Rate 5% Face Value 1000 Price 571.02 Term to Maturity 20 The Green Cells are Input Cells. The Orange Cells are Output Cells. For each calculator, place the correct formula in the Orange Output Cell to calculate the correct value for a SEMI- ANNUAL bond. The Green Cells are Input C The Orange Cells are Outpu For each set of rows, place t values in the Green Input ce specific bond factor between
Background image of page 1

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

View Full DocumentRight Arrow Icon
Coup Rate FV Initial Price 10% 1000 $1,000.00 $1,092.01 9.20% 10% 1000 $1,000.00 $1,039.56 3.96% 10% 1000 $1,000.00 $1,092.01 9.20% 10% 1000 $1,627.57 $1,820.66 11.86%
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/17/2009 for the course BCOR 2200 taught by Professor Tomnelson during the Fall '08 term at Colorado.

Page1 / 5

Project 2 - Problem 1 The Green Cells are Input Cells. The...

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

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