sample_excel_sol_chapter_25

sample_excel_sol_chapter_25 - Chapter 25 Problems 1-16...

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

Chapter 25 Problems 1-16 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 25 Question 1 Input Area: Final cocoa price \$1,402 Initial cocoa price \$1,435 Tons per contract 10 Output Area: Initial contract value \$14,350 Final contract value \$14,020 Gain/(Loss) \$(330)

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

View Full Document
Chapter 25 Question 3 Input Area: Exercise price per barrel \$35 # barrels bought 50,000 Oil prices: \$30 \$32 \$35 \$38 \$40 Output Area: The call option gives the manager the right to purchase oil futures contracts at a \$35 per barrel. The manager will exercise the option i \$35 Selling put options obligates the manager to buy o futures price of \$35 per barrel. The put holder will exerc falls below \$35 The payoffs per barrel are: Oil futures price: \$30.00 \$32.00
This is the end of the preview. Sign up to access the rest of the document.

sample_excel_sol_chapter_25 - Chapter 25 Problems 1-16...

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

View Full Document
Ask a homework question - tutors are online