Chapter_07 - Chapter 7 Input boxes in tan Output boxes in...

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

View Full Document Right Arrow Icon
Chapter 7 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may req the "Analysis ToolPak" or "Solver Add-In" be installed in Ex To install these, click on the Office button then "Excel Options," "Add-Ins" and select "Go." Check "Analyis ToolPak" and "Solver Add-In," then click "OK."
Background image of page 1

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

View Full DocumentRight Arrow Icon
quire that xcel.
Background image of page 2
Chapter 7 Question 4 Input area: Settlement date Maturity date Annual coupon rate Coupons per year Face value (% of par) Bond price (% of par) Output area: Yield to maturity Err:502
Background image of page 3

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

View Full DocumentRight Arrow Icon
Chapter 7 Question 5 Input area: Years to maturity Coupons per year Face value Bond price Yield to maturity Output area: Present value of final payment $- Present value of coupon payments $- Coupon payment #VALUE! Coupon rate #VALUE!
Background image of page 4
Chapter 7 Question 6 Input area: Settlement date Maturity date Coupon rate Coupons per year Face value Yield to maturity Output area: Price Err:502
Background image of page 5

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

View Full DocumentRight Arrow Icon
Chapter 7 Question 18 Input area: Settlement date
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/16/2011 for the course FIN 521 taught by Professor Varney during the Spring '11 term at Andrew Jackson.

Page1 / 8

Chapter_07 - Chapter 7 Input boxes in tan Output boxes in...

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