# Finance homework-call options…i need this in excel

Don't use plagiarized sources. Get Your Assignment on
Finance homework-call options…i need this in excel
Just from \$13/Page

Problem 20-6 on Call Options based on Chapter 20

(Excel file included)

You own a call option on Intuit stock with a strike price of \$40. The option will expire in exactly 3 months’ time.

a. If the stock is trading at \$55 in 3 months, what will be the payoff of the call?

b. If the stock is trading at \$35 in 3 months, what will be the payoff of the call?

c. Draw a payoff diagram showing the value of the call at expiration as a function of the stock price at expiration.

Problem 20-8 on Put Options based on Chapter 20

(Excel file included)

You own a put option on Ford stock with a strike price of \$10. The option will expire in exactly 6 months’ time.

a. If the stock is trading at \$8 in 6 months, what will be the payoff of the put?

b. If the stock is trading at \$23 in 6 months, what will be the payoff of the put?

c. Draw a payoff diagram showing the value of the put at expiration as a function of the stock price at expiration.

Problem 20-11 on Return on Options based on Chapter 20

Consider the September 2012 IBM call and put options in Problem 20-3. Ignoring any interest you might earn over the remaining few days’ life of the options, consider the following.

a. Compute the break-even IBM stock price for each option (i.e., the stock price at which your total profit from buying and then exercising the option would be 0).

b. Which call option is most likely to have a return of −100%?

c. If IBM’s stock price is \$216 on the expiration day, which option will have the highest return?

Problem 21-12 on Option Valuation using the Black Scholes model based on Chapter 21

Rebecca is interested in purchasing a European call on a hot new stock—Up, Inc. The call has a strike price of \$100 and expires in 90 days. The current price of Up stock is \$120, and the stock has a standard deviation of 40% per year. The risk-free interest rate is 6.18% per year.

a. Using the Black-Scholes formula, compute the price of the call.

b. Use put-call parity to compute the price of the put with the same strike and expiration date.

Problem 30-14 on Swaps based on Chapter 30

Your firm needs to raise \$100 million in funds. You can borrow short-term at a spread of 1% over LIBOR. Alternatively, you can issue 10-year, fixed-rate bonds at a spread of 2.50% over 10-year treasuries, which currently yield 7.60%. Current 10-year interest rate swaps are quoted at LIBOR versus the 8% fixed rate.

Management believes that the firm is currently “underrated” and that its credit rating is likely to improve in the next year or two. Nevertheless, the managers are not comfortable with the interest rate risk associated with using short-term debt.

a. Suggest a strategy for borrowing the \$100 million. What is your effective borrowing rate?

b. Suppose the firm’s credit rating does improve 3 years later. It can now borrow at a spread of 0.50% over treasuries, which now yield 9.10% for a 7-year maturity. Also, 7-year interest rate swaps are quoted at LIBOR versus 9.50%. How would you lock in your new credit quality for the next 7 years? What is your effective borrowing rate now?

Problem 30-6 on Futures Contract based on Chapter 30

(Excel file included)

Your utility company will need to buy 100,000 barrels of oil in 10 days, and it is worried about fuel costs. Suppose you go long 100 oil futures contracts, each for 1,000 barrels of oil, at the current futures price of \$60 per barrel. Suppose futures prices change each day as follows.

a. What is the mark-to-market profit or loss (in dollars) that you will have on each date?

b. What is your total profit or loss after 10 days? Have you been protected against a rise in oil prices?

c. What is the largest cumulative loss you will experience over the 10-day period? In what case might this be a problem?

Calculate the price
Pages (550 words)
\$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Human Resources Management (HRM)
Thank you for this excellent power point
Customer 453633, February 24th, 2020
Military
good work
Customer 456821, March 18th, 2022
Education
nice
Customer 463813, March 10th, 2023
Sociology
Really beautiful, beautiful work here. Well done! I love this service so much!
Customer 454259, April 11th, 2020
Cybersecurity Management and Policy
Thank you to the writer for the near perfect revision and a HUGE thank you to customer support for staying in constant communication with me to ensure the assignment was completed to my specifications.
Customer 452455, January 26th, 2023
Psychology
Good work.
Customer 459817, June 16th, 2022
Great work again!
Customer 454345, May 10th, 2020
Economics
I would like to thank you for your hard work. The essay is clear and clean.
Customer 462687, March 14th, 2022
Public Relations
Good Job, Keep up the good work!
Customer 452621, February 5th, 2020
Public Relations
This writer did a good job on my paper, it had to be revised and I couldn't have asked for a better writer. My paper was on time. Thanks!
Customer 452621, January 22nd, 2020
Religious studies
Excellent content and structure.
Customer 462681, April 24th, 2022
Military
Excellent Paper
Customer 456821, December 6th, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend