Question

In: Finance

Suppose you are a gas user, such as a chemical company, and want to put a...

Suppose you are a gas user, such as a chemical company, and want to put a ceiling on the price you will have to pay for gas in 3 months by longing a call with K=$5.00. To offset (approximately) the cost of the call, you short a put with K=$4.20. Calculate and graph the net price you will pay for your gas 3 months later when gas prices are $3.80, $4.00, $4.20, ....$5.20 including the future value of the option premiums

Solutions

Expert Solution

Net Premium paid $0
(Assumed premium paid for buying a call =premium received for selling a put)
Pay off for buying Call:K=$5.00
Price after 3 months =S
If S>$5.00,
Payoff =(S-5.00)
If S=$5.00 or <$5.00,
Payoff=$0
Pay off for Selling (Short)Put:K=$4.20
Price after 3 months =S
If S<$4.20,
Payoff =(S-4.20)
If S=$4.20 or >$4.20,
Payoff=$0
S A B C=A+B D=S-C
Gain/(Loss) Gain/(Loss) Net Gain/ Net Price
Price at Expiration (S) Buy Call K=$5.00 Short Put K=$4.20 (Loss) Paid
$3.80 $0 ($0.40) ($0.40) $4.20
$4.00 $0 ($0.20) ($0.20) $4.20
$4.20 $0 $0.00 $0.00 $4.20
$4.40 $0 $0.00 $0.00 $4.40
$4.60 $0 $0.00 $0.00 $4.60
$4.80 $0 $0.00 $0.00 $4.80
$5.00 $0 $0.00 $0.00 $5.00
$5.20 $0.20 $0.00 $0.20 $5.00
$5.40 $0.40 $0.00 $0.40 $5.00
$5.60 $0.60 $0.00 $0.60 $5.00


Related Solutions

put a loop around the main module that will ask the user if they want to...
put a loop around the main module that will ask the user if they want to run the program again with another week of lemonade and cookie sales. def main():    # constants given CUP_COST= .05 LEMONADE_MIX_OZ_COST =.10 COSTOFCOOKIES = .11 COOKIESALE = .25 #inputs numberOfCupsUsed=int(input('Enter the number of cups used this week ')) ouncesOfMixUsed=int(input('Enter ounces of Lemonade mix used ')) salesForWeekLemonade=float(input('Enter total Lemonade sales for the week $')) cookiesSoldForWeek = int(input("Enter number of cookies sold for the week: "))...
I. Suppose an apartment you want to purchase costs $500,000. You can put down 20% in...
I. Suppose an apartment you want to purchase costs $500,000. You can put down 20% in cash and take out a 30-year fixed rate mortgage loan for the remaining. You believe that you can get an APR of 6.5% on such a mortgage loan at a local bank. a. Suppose the loan calls for equal monthly payments. Please set up a monthly amortization schedule table for the loan (Input setting: 20%, creating and copying formulas and Excel finance functions: 40%)....
Suppose an apartment you want to purchase costs $500,000. You can put down 20% in cash...
Suppose an apartment you want to purchase costs $500,000. You can put down 20% in cash and take out a 30-year fixed rate mortgage loan for the remaining. You believe that you can get an APR of 6.5% on such a mortgage loan at a local bank. Suppose the loan calls for equal monthly payments. Set up a monthly amortization schedule table for the loan (Input: 20%, creating and copying formulas and Excel finance functions: 30%). What is the sum...
Suppose an apartment you want to purchase costs $500,000. You can put down 20% in cash...
Suppose an apartment you want to purchase costs $500,000. You can put down 20% in cash and take out a 30-year fixed rate mortgage loan for the remaining. You believe that you can get an APR of 6.5% on such a mortgage loan at a local bank. Suppose the loan calls for equal monthly payments. 1. Set up a monthly amortization schedule table for the loan (Input: 20%, creating and copying formulas and Excel finance functions: 30%). Use 360 months...
Suppose you want to value a European put option under the following assumptions: stock price is...
Suppose you want to value a European put option under the following assumptions: stock price is $100, exercise price is $95, interest rate is 10% per year, dividend yield is 0, time to maturity is 3 months, standard deviation is .5 per year. What is the price of this put using Black-Scholes model?A. $4.88 B. $6.35 C. $10.32 D. None of the above
Suppose you are the Chief Financial Officer of a tech company and that you want to...
Suppose you are the Chief Financial Officer of a tech company and that you want to obtain a good estimate for the cost of capital of a new investment project. Your project is an investment in a new production line for semi-conductors and has an expected lifetime of 20 years. That is, you expect to receive cash flows from the project for 20 years. Explain how you would obtain a good cost of capital estimate for your project using two...
Suppose you are a financial manager of a company and you want to determine the price...
Suppose you are a financial manager of a company and you want to determine the price of the stock. The most recent annual (2019) dividend payment of the company, was $8 per share. You expect that these dividends will grow at a 5% annual rate over the next five years. At the end of the fifth year (i.e. the end of 2024) the dividend growth rate is expected to increase to 6.5% for the foreseeable future. If the firm’s required...
a) if gas bubbles are produced by a chemical reaction, how could you prove that the...
a) if gas bubbles are produced by a chemical reaction, how could you prove that the bubbles were composed of carbon dioxide? b) if a solution is thought to contain chloride ions, how could this be detemined?
Suppose that you work in a shoe company want to compare two materials, A and B,...
Suppose that you work in a shoe company want to compare two materials, A and B, for use on the soles of boys' shoes. In this problem, each of ten boys in a study wore a special pair of shoes with the sole of one shoe made from Material A in column (Mat-A) and the sole on the other shoe made from Material B in column (Mat-B). The sole types were randomly assigned to account for systematic differences in wear...
You want to buy a new car for $25,000. You put $2000 down and are given...
You want to buy a new car for $25,000. You put $2000 down and are given $2000 as trade-in for your current car. You take out a loan for the remaining $21,000. The terms of the loan are an annual interest rate of 4.8% compounded monthly. You are to make 60 equal monthly payments (end of month) to pay off the loan. how can i get the answer using excel
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT