Chapter_07

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

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

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."

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

View Full Document
quire that xcel.
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

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

View Full Document
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!
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

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

View Full Document
Chapter 7 Question 18 Input area: Settlement date
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
Ask a homework question - tutors are online