Using the assumption table, I need help solving these problems below.

Q2. Show the table of cash flow/bbl and the P/L /bbl at JAN2022 expiration of the following strategy:

The State buys the K = $55.50, JAN2022 puts.

Q3. Graph the P/L profile of the State from the strategy in Q2, using all possible prices per barrel at JAN202 expiration.

Q4. Show the table of cash flow/bbl and the P/L /bbl at JAN2022 expiration of the following strategy by the State:

buy the K1=$55.50, puts and sell the K2= $57.50 call

Q5. Graph the P/L /bbl profile of the State from the strategy in Q4. using all possible prices/bbl at JAN2022 expiration.

For this Real life situation p. 3/4 Assume (for simplicity): A1. Today, Texas crude oil is trading at S = $57.18/barrel (bbl). Also today, calls and puts on Texas crude for Jan2022 Expiration are traded for the following prices per barrel: K calls puts $55.00/bbl $2.60/bbl $1.18/bbl $55.50/bbi $2.30/bbl $1.38/bbl $56.00/bbl $2.03/bbl $1.65/bbl $56.50/bbl $1.79/bbl $1.86/bbl $57.00/bbl $1.58/bbl $2.13/bbl $57.50/bbl $1.38/bbl $2.43/bbl $58.50/bbl $0.46/bbl $2.99/bbl. The State of Texas expects the price of Texas crude to be between $56/bbl and $58/bbl in Jan2022. but wishes to hedge its severance tax revenue in case the crude's price falls below $54. Based on production data from the last 5 years, the Texas Railroad Commission figures that by the options' Jan2022 expiration date, it needs to protect the 4.6% severance tax revenue from the sale of 152,000,000 barrels of oil that are expected to be produced and sold between today and the expiration date on Jan2022. A2. All the 152,000,000 barrels are sold on the Jan2022 options' expiration day. An Important Hint to follow: The tax revenue must be part of this real life strategy. In the tables of cash flows, however, the cash flow associated with the tax revenue from the sale of the Texas crude oil does not appear in the ICF column because the State does not own or buy it. Instead, the State receives the tax revenue only when the crude oil is sold, i.e., on the Jan2022 expiration date of the options. Therefore in the table of cash flows there should appear a row for the Tax revenue. The ICF associated with the Tax revenue from the crude oil sale is (zero) 0. and the tax revenue appears only at the Jan2022 expiration. A3. The State buys puts to protect only it's revenue from the tax; i.e., only 4.6% barrels out of the 152,000,000 barrels produced and sold are covered by the puts. p2/4 "Crude oil protective puts by the State of Texas" Texas, along with other governments, is becoming a big-time player in the commodities market. But it's not because they've become bored with their own lottery operations. Quite the contrary; their goal is not to take risks, but to reduce them. If the word hedging does not yet appear in the codification of government accounting standards, you can be certain that it will soon. Texas uses commodity options to protect its tax revenues from sudden drops in the price of oil. Texas expects to generate $500 million from its oil severance tax. For every barrel of the "black gold" produced in the state, the Treasury receives 4.6 percent of the sales price. A sharp drop in price, such as in 1986 when it nose-dived from almost $25.82 to 11.36, can play havoc with the state's budget. To lock in a set price, the state is experimenting with oil options. Here's how they work. The State purchases put options on crude oil. Each option permits it to sell (or "put") a thousand (1,000) barrels of oil at an established (exercise) price to the party that sold the option on a specified (exercise) date. If on the exercise date the market price of crude oil is below the established price, then the option has value: the intrinsic value - the difference between the established exercise price and the market price. The state either exercises the option or sells it in the open market, thus making a "profit" and covering the cost of the oil itself. The greater the decline in market price, the greater the gain to the state from the put.. If, however, the oil market price on the specified date is above the established exercise price, then the option has no value and the state will allow it to expire worthless. Its loss is limited to the amount that it paid to acquire the option (the "premium" cost). The Texas Treasury can be viewed as the de facto owner of 4.6 percent (the severance tax rate) of all the oil produced in the state. Therefore, for each 1,000 barrels of oil that it wants to protect against a decline in revenue, it must buy puts on 46 barrels. Suppose that on June 1, the State buys puts on 100,000 barrels of oil, thereby protecting 2,173,913 barrels (100,000 divided by 4.6 percent). Since put contracts are written in units of 1,000 barrels, the state would be required to buy 100 contracts. Assume that on the date the puts are purchased the prevailing market price is S = $21 per barrel and that this is the price that the state wants to lock in for purposes of severance tax collection three months hence. Therefore it buys puts with X = $21 as the strike price and T = October 1 as the expiration date. The cost of each contract might be approximately $1,100 including commissions---$110,000 for the 100 contracts. If, on the expiration date, the market value of oil has fallen to ST = $18 per barrel, then the market value of each contract can be expected to approximate $3,000 [$21-$18)(1,000)] barrels]-or $300,000 for the 100 contracts. This amount will be just sufficient to offset the loss on the severance tax revenue from the $3 per barrel price drop (2,173,913 barrels times $3 per barrel times the tax rate of 4.6 percent). The state will sell the options for the $300,000 and its net loss on the entire transaction will be $110,000, the cost of the options. If on the expiration date, the price of oil is $21 or more, then the options will have no value and the state will be out the $110,000 that it paid for them. However, the state will still reap the benefits from the increased tax revenue owing to the rise in oil prices, and this additional revenue may be sufficient to offset all or at least a part of the option cost. For this Real life situation p. 3/4 Assume (for simplicity): A1. Today, Texas crude oil is trading at S = $57.18/barrel (bbl). Also today, calls and puts on Texas crude for Jan2022 Expiration are traded for the following prices per barrel: K calls puts $55.00/bbl $2.60/bbl $1.18/bbl $55.50/bbi $2.30/bbl $1.38/bbl $56.00/bbl $2.03/bbl $1.65/bbl $56.50/bbl $1.79/bbl $1.86/bbl $57.00/bbl $1.58/bbl $2.13/bbl $57.50/bbl $1.38/bbl $2.43/bbl $58.50/bbl $0.46/bbl $2.99/bbl. The State of Texas expects the price of Texas crude to be between $56/bbl and $58/bbl in Jan2022. but wishes to hedge its severance tax revenue in case the crude's price falls below $54. Based on production data from the last 5 years, the Texas Railroad Commission figures that by the options' Jan2022 expiration date, it needs to protect the 4.6% severance tax revenue from the sale of 152,000,000 barrels of oil that are expected to be produced and sold between today and the expiration date on Jan2022. A2. All the 152,000,000 barrels are sold on the Jan2022 options' expiration day. An Important Hint to follow: The tax revenue must be part of this real life strategy. In the tables of cash flows, however, the cash flow associated with the tax revenue from the sale of the Texas crude oil does not appear in the ICF column because the State does not own or buy it. Instead, the State receives the tax revenue only when the crude oil is sold, i.e., on the Jan2022 expiration date of the options. Therefore in the table of cash flows there should appear a row for the Tax revenue. The ICF associated with the Tax revenue from the crude oil sale is (zero) 0. and the tax revenue appears only at the Jan2022 expiration. A3. The State buys puts to protect only it's revenue from the tax; i.e., only 4.6% barrels out of the 152,000,000 barrels produced and sold are covered by the puts. p2/4 "Crude oil protective puts by the State of Texas" Texas, along with other governments, is becoming a big-time player in the commodities market. But it's not because they've become bored with their own lottery operations. Quite the contrary; their goal is not to take risks, but to reduce them. If the word hedging does not yet appear in the codification of government accounting standards, you can be certain that it will soon. Texas uses commodity options to protect its tax revenues from sudden drops in the price of oil. Texas expects to generate $500 million from its oil severance tax. For every barrel of the "black gold" produced in the state, the Treasury receives 4.6 percent of the sales price. A sharp drop in price, such as in 1986 when it nose-dived from almost $25.82 to 11.36, can play havoc with the state's budget. To lock in a set price, the state is experimenting with oil options. Here's how they work. The State purchases put options on crude oil. Each option permits it to sell (or "put") a thousand (1,000) barrels of oil at an established (exercise) price to the party that sold the option on a specified (exercise) date. If on the exercise date the market price of crude oil is below the established price, then the option has value: the intrinsic value - the difference between the established exercise price and the market price. The state either exercises the option or sells it in the open market, thus making a "profit" and covering the cost of the oil itself. The greater the decline in market price, the greater the gain to the state from the put.. If, however, the oil market price on the specified date is above the established exercise price, then the option has no value and the state will allow it to expire worthless. Its loss is limited to the amount that it paid to acquire the option (the "premium" cost). The Texas Treasury can be viewed as the de facto owner of 4.6 percent (the severance tax rate) of all the oil produced in the state. Therefore, for each 1,000 barrels of oil that it wants to protect against a decline in revenue, it must buy puts on 46 barrels. Suppose that on June 1, the State buys puts on 100,000 barrels of oil, thereby protecting 2,173,913 barrels (100,000 divided by 4.6 percent). Since put contracts are written in units of 1,000 barrels, the state would be required to buy 100 contracts. Assume that on the date the puts are purchased the prevailing market price is S = $21 per barrel and that this is the price that the state wants to lock in for purposes of severance tax collection three months hence. Therefore it buys puts with X = $21 as the strike price and T = October 1 as the expiration date. The cost of each contract might be approximately $1,100 including commissions---$110,000 for the 100 contracts. If, on the expiration date, the market value of oil has fallen to ST = $18 per barrel, then the market value of each contract can be expected to approximate $3,000 [$21-$18)(1,000)] barrels]-or $300,000 for the 100 contracts. This amount will be just sufficient to offset the loss on the severance tax revenue from the $3 per barrel price drop (2,173,913 barrels times $3 per barrel times the tax rate of 4.6 percent). The state will sell the options for the $300,000 and its net loss on the entire transaction will be $110,000, the cost of the options. If on the expiration date, the price of oil is $21 or more, then the options will have no value and the state will be out the $110,000 that it paid for them. However, the state will still reap the benefits from the increased tax revenue owing to the rise in oil prices, and this additional revenue may be sufficient to offset all or at least a part of the option cost