$4.$ Use a monthly production schedule to value an oil well that will start producing $1,332$ barrels of oil per day, and will produce for $48$ months. The production will fall by $1\mathrm{.}0\%$ per month, based on the initial production. So in month $1,$ the well produces $100\%$ of the initial amount, month $2$ is $99\%,$ month $3$ is $98\%,$ etc. Note that $12\%$ of the daily production will go to the landowner and is not part of the valuation. Note that it costs $$14$ per barrel to ship the oil, so account for that expense. Use the West Texas Intermediate $($WTI$)$ NYMEX curve, $$prior settle$$ price, over the next $48$ months $($I downloaded and put the data in Excel$)$ to assign a price per barrel. Assume the well costs $$7\mathrm{.}5$ million to drill, and will cost $$3$ million to cap at the end of the project life $($put in an expense of $$3$ million in month $48).$ Make your spreadsheet flexible and easy to read. The the sum of the discounted cash flows should be given somewhere at the top. Use a $16\%$ discount rate$\mathrm{.}4.$ Use a monthly production schedule to value an oil well that will start producing $1,332$ barrels of oil per day, and will produce for $48$ months. The production will fall by $1\mathrm{.}0\%$ per month, based on the initial production. So in month $1,$ the well produces $100\%$ of the initial amount, month $2$ is $99\%,$ month $3$ is $98\%,$ etc. Note that $12\%$ of the daily production will go to the landowner and is not part of the valuation. Note that it costs $$14$ per barrel to ship the oil, so account for that expense. Use the West Texas Intermediate $($WTI$)$ NYMEX curve, $$prior settle$$ price, over the next $48$ months $($I downloaded and put the data in Excel$)$ to assign a price per barrel. Assume the well costs $$7\mathrm{.}5$ million to drill, and will cost $$3$ million to cap at the end of the project life $($put in an expense of $$3$ million in month $48).$ Make your spreadsheet flexible and easy to read. The the sum of the discounted cash flows should be given somewhere at the top. Use a $16\%$ discount rate.