# Chapter09CorradoJordanRex - Chapter 9 Problems 1-25 Input...

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

Chapter 9 Problems 1-25 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 require that the "Analysis ToolPak" or "Solver Add-in" be installed in Excel. To install these, click on "Tools|Add-Ins" and select "Analysis ToolPak and "Solver Add-In."

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

View Full Document
k"
Chapter 9 Question 1 STRIPS Input Area: 2 6 5.20% \$100 Output Area: Price (% of par) 73.491 =100/(1+(i/n))^M 73.49 Quote Err:511 =INT(D17)&":"&ROUND(32*(D17-INT(D Sheet function \$73.49 Frequency, n Time to maturity, M Yield to maturity, i Par value, F =PV(D9/D7,D8*D7,,-D10) P F i n*T F = P *(1+ i/n ) nT

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

View Full Document
D17)),)
Chapter 9 Question 2 STRIPS Input Area: 9.5 6.80% \$100,000 Output Area: Price (% of par) 52.980 =100/(1+(D8/2))^(2*D7) 52.98 Quote Err:511 =INT(D15)&":"&ROUND(32*(D15-INT(D Sheet function \$52,979.73 Time to maturity, M Yield to maturity, i Par value, F =PV(D8/2,2*D7,,-D9) P F i n*T F = P *(1+ i/n ) nT

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

View Full Document
D15)),)
Chapter 9 Question 3 STRIPS Input Area: 7.0 75.875 75.88 Output Area: YTM 3.98% =2*((100/D8)^(1/(2*D7))-1) Sheet function 3.98% Time to maturity, M Price, P =2*RATE(2*D7,,-D8,100)

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

View Full Document
Chapter 9 Question 4 STRIPS Input Area: 10.0 50.375 50.38 Output Area: YTM 6.98% =2*((100/D8)^(1/(2*D7))-1) Sheet function 6.98% Time to maturity, M Price, P =2*RATE(2*D7,,-D8,100)
Chapter 9 Question 5 Fisher Effect Input Area: Nominal rate 13.40% Inflation rate 3.90% Output Area: Approx. real return rate 9.50%

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

View Full Document
Chapter 9 Question 6 Fisher Effect Input Area: Nominal rate 10.10% Real rate 6.20% Output Area: Inflation rate 3.90%
Chapter 9 Question 7 Treasury Bill Prices Input Area: 110 4.80% \$1,000,000 Output Area: Treasury Bill Prices \$985,333.33 =D9*(1-D7*D8/360) Days to maturity, D Discount yield, Y Face value, F P i 360-D P = F *(1-( D/360 ) Y ) D

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

View Full Document
Chapter 9 Question 8 Treasury Bill Prices Input Area: Days per year 365 110 4.80% Output Area: 4.939% =D7*D9/(360-D8*D9) Days to maturity, D Discount yield, Y Bond equivalent yield, BEY P i 360-D P = F *(1-( D/360 ) Y ) D
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern