Question

In: Accounting

2. Review and discuss the collapse of the Futures Oil Market, which fell into the negative...

2. Review and discuss the collapse of the Futures Oil Market, which fell into the negative realm in May 2020.

What were the main reasons for this fall into the negative realm? Critically discuss. . Please state references and use APA Citation latest version

Solutions

Expert Solution

To solve this question just input those variables which are to be used in logistic regression, as the question talks about using two variables only that is total loans and leases to total assets & total expenses/ total assets, so we will not input total cap/assets as an input variable in our excel, here we go

As one can see, we have taken only two variables , total exp/assets and total lns & leases/ assets in calculation, follwing steps have been followed to construct the above table

1. Assume logit= b0+ b1* independent variable1+ b2* independent variable 2 , take values of b0=0.1, b1=0.1, b2=0.1, note that these values of b0, b1 and b2 are just taken for calculation, one could assume any values here for bo , b1 and b2

2. Calculate exponential of logit in the next column by using exp (value in previous column)

3. Calculate probability by using formula, probability= exp (logit)/ { 1+ exp(logit)} in the next column

4. In next column, calculate log likelihood by using formula : financial condition value (i.e. 1 or 0) * LN( probability calculated in previous column) + (1- financial condition value)* LN( 1- probability calculated in previous column)

5. take the total of the column values of log likelihood

6. use solver function in excel to change this total by putting max value of 0 and changing the variable cells containing assumed values of b0, b1 and b2 , by clicking on solve, you will get actual values of b0, b1 and b2

which comes out to be b0=-14.72, b1=89.83, b2= 8.37

therefore you will get logit as

-14.72+ 89.83* Total exp/assets+8.37*Total lns & lsses/ assets

With values given in the question as total exp/ assets= 0.11 and total loans & leases/ assets= 0.6 , we get

logit as -14.72+ 89.83* 0.11+ 8.37*0.6= 0.1833

exp (logit) = 1.20

Probability= 0.546

Loglikelihood= 1*LN(0.546)+0*LN(1-0.546)= LN(0.546)= -0.605


Related Solutions

2.i) Review and discuss the collapse of the Futures Oil Market, which fell into the negative...
2.i) Review and discuss the collapse of the Futures Oil Market, which fell into the negative realm in May 2020. What were the main reasons for this fall into the negative realm? ii) Critically discuss.What were the main reasons for this fall into the negative realm? Critically discuss.
Review and discuss the collapse of the Futures Oil Market, which fell into the negative realm...
Review and discuss the collapse of the Futures Oil Market, which fell into the negative realm in May 2020.
3. Review   and discuss the collapse of the Futures Oil Market, which   fell into the negative...
3. Review   and discuss the collapse of the Futures Oil Market, which   fell into the negative realm in May 2020. What were the main reasons for this fall into the negative realm? Critically discuss   After May 2020, what are the prospects of futures contracts as a significant risk management tool for firms? Discuss critically. Please state references and use APA Citation latest version
Review and discuss the collapse of the Futures Oil Market, which fell into the negative realm...
Review and discuss the collapse of the Futures Oil Market, which fell into the negative realm in May 2020. What were the main reasons for this fall into the negative realm? Critically discuss. . Please state references and use APA Citation latest version
Review   and discuss the collapse of the Futures Oil Market, which   fell into the negative realm...
Review   and discuss the collapse of the Futures Oil Market, which   fell into the negative realm in May 2020. What were the main reasons for this fall into the negative realm? Critically discuss. After May 2020, what are the prospects of futures contracts as a significant risk management tool for firms? Discuss critically.
Review and discuss the collapse of the Futures Oil Market, which   fell into the negative realm...
Review and discuss the collapse of the Futures Oil Market, which   fell into the negative realm in May 2020.       2.What were the main reasons for this fall into the negative realm? Critically discuss.
3. After May 2020 collapse of the futures oil markets, what are the prospects of futures...
3. After May 2020 collapse of the futures oil markets, what are the prospects of futures contracts as a significant risk management tool for firms? Discuss critically.
Describe how contango in wti oil futures contracts caused a negative price of wti oil futures...
Describe how contango in wti oil futures contracts caused a negative price of wti oil futures to occur
Explain the reasons for observing negative price in the oil future market and discuss its effects...
Explain the reasons for observing negative price in the oil future market and discuss its effects on the financial markets. On April 20 2020,oil prices went to negative $37 ( coronavirus effects)
Last week oil prices, which are determined by the market and not individual producers, became negative....
Last week oil prices, which are determined by the market and not individual producers, became negative. Graphically show what happened to the demand curve, marginal revenue curve, and profits/losses of an individual oil producing firm. Please label everything.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT