FCF 9th edition Chapter 23

FCF 9th edition Chapter 23 - Chapter 23 Problems 1-8 Input...

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

View Full Document Right Arrow Icon
Chapter 23 Problems 1-8 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."
Background image of page 1

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

View Full DocumentRight Arrow Icon
Chapter 23 Question 1 Input Area: Initial cocoa price $3,122 Tons per contract 10 Final cocoa price $3,081 Output Area: Initial contract value $31,220 Final contract value $30,810 Gain/(Loss) $(410)
Background image of page 2
Chapter 23 Question 2 Input Area: Initial price per ounce $16.6070 Ounces per contract 5,000 Number of contracts sold 5 Ending price per ounce $16.81 Ending price per ounce $16.32 Output Area: Initial contract value $83,035.00 Final contract value $16.81 $84,050.00 Gain/(Loss) per contract $(1,015.00) Gain/(Loss) on short position $(5,075.00) Final contract value $16.32 $81,600.00 Gain/(Loss) per contract $1,435.00 Gain/(Loss) on short position $7,175.00
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 23 Question 3 Input Area: Strike price $1.40 Initial price per pound $0.0835 Futures price at expiration $1.29 Futures price at expiration $1.67 Pounds per contract 15,000 Output Area: Cost per contract $1,252.50 Final contract value: $1.29 The option is out of the money.
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 9

FCF 9th edition Chapter 23 - Chapter 23 Problems 1-8 Input...

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

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