sample_excel_sol_chapter_25

sample_excel_sol_chapter_25 - Chapter 25 Problems 1-16...

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

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

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

View Full DocumentRight Arrow Icon
k"
Background image of page 2
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)
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 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
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 / 14

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 Right Arrow Icon
Ask a homework question - tutors are online