Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. please show it on excel with formulas. thank you

Please show it on Excel with formulas. Thank you 3)...

80.2K

Verified Solution

Question

Finance

Please show it on Excel with formulas. Thank you image

3) Lets assume we are a heating oil delivery service company that sells 100,000 gallons of heating oil every month its clients. The firm wants to hedge its position buy entering into a contract to buy its heating oil each month for the next 4 months. What would be the swap price of the 100,000 gallons of heating oil each month for the next 4-months if the following information is true? (Risk-free rate is provided per annum with continuous compounding) Month Forward Price Risk-Free Rate 1 $ 2.999 1.50% 2 $ 3.019 1.50% 3 $ 3.039 1.60% 4 $ 3.075 1.75% 1 3) Lets assume we are a heating oil delivery service company that sells 100,000 gallons of heating oil every month its clients. The firm wants to hedge its position buy entering into a contract to buy its heating oil each month for the next 4 months. What would be the swap price of the 100,000 gallons of heating oil each month for the next 4-months if the following information is true? (Risk-free rate is provided per annum with continuous compounding) Month Forward Price Risk-Free Rate 1 $ 2.999 1.50% 2 $ 3.019 1.50% 3 $ 3.039 1.60% 4 $ 3.075 1.75% 1

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students