{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

FCF 9th edition Chapter 23

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

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

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

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

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

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

View Full Document
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.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}