Introduction:

This case is mainly dealing with two scenarios, one is dealing with the crude oil and gasoline’s future contractsfor XOMcompany and another company MG is using rolling strategy which is leading towards cash shortage which is needed to be filled by the company by contracting with the oil suppliers for reducing their risks of meeting the contract requirements at lower prices. It results in the huge losses for company by not predicting the prices according to its nature rather they followed the intense strategy to earn money quickly which resulted in the adverse direction by following the aggressive policy of hedging. So, to overcome this situation optimal hedging ratio has been calculated and the relative volatilities as well.

Question 1 Part a: Interpretation

Regression Statistics
Multiple R	0.97546552
R Square	0.95153298
Adjusted R Square	0.950018386
Standard Error	6441.188397
Observations	100

ANOVA
	DF	SS	MS	F	Significance F
Regression	3	78195321386	26065107129	628.242786	0.00
Residual	96	3982935165	41488907.97
Total	99	82178256551

	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	5451.738957	1275.528552	4.27410186	0.00	2919.834792	7983.643122
X Variable 1	562.8312772	64.74081319	8.693608397	0.00	434.3217787	691.3407757
X Variable 2	4473.559783	508.9265163	8.790188051	0.00	3463.348632	5483.770933
X Variable 3	198.8105899	47.35356704	4.198429018	0.00	104.8145023	292.8066776

As it is mentioned in the excel sheets and assessment file that we are supposed to find out the relationship and impact of XOM revenues with respect to WIT crude oil prices, Henry Hub gasoline and Brent oil prices. In this case we have taken XOM revenues as independent variable whereas, dependent variables have been selected as WIT, Henry and Brent.

The-Collapse-of-Metallgesellschaft-Harvard-Case-Solution-Analysis
Regression analysis results show that the overall model is best fit model as all these factors are significantly impacting revenues which is around 97%. If we analyze each factor independently and individually, then all these factors are showing significance as their p-value is less than 5% which shows that the null hypothesis cannot be rejected as there lies a strong positive relationship of these prices on revenues.

Q1 part b Interpretation:

Therelation between hedge ratio and regression analysis is insignificant. As most of the values of hedge ratios are negative. In addition, regression analysis is showing insignificance and rejection of null hypothesis because their p-value is more than 5% and stats significance is also greater than 5%. Therefore, all the hedge ratios and regression analysis results are insignificant. Files have been attached in exhibits..........................

This is just a sample partial work. Please place the order on the website to get your own originally done case solution.