Fill This Form To Receive Instant Help
Homework answers / question archive / A petroleum project involves production of crude oil from a 5,000,000 barrel reserve
A petroleum project involves production of crude oil from a 5,000,000 barrel reserve. Time zero mineral rights acquisition cost (lease bonus) of $2,000,000 is the basis for cost depletion. Intangible drilling expenses of $1,500,000 will be incurred in time zero. Tangible producing equipment costing $3,000,000 at time zero will go into service in year one and be depreciated using double declining balance on the 7-year depreciation basis considering first full year of Use). Production is estimated to be 350,000 barrels per year. Well-head crude oil value before transportation cost is estimated to be $42.00 per barrel in year one, $43.00 per barrel in year two, and $44.00 per barrel in year three. Royalties are 10.0% of revenues (well-head value) each year. Operating costs are expected to be $3,000,000 in year one, $3,300,000 in yeartwo, and $3,600,000 in year three. The allowable percentage depletion is 15.0%. The effective income tax rate is 40.0%. The investor has other taxable income against which to deduct negative taxable income (No Carry forward is allowed). Determine the after-tax cash flows for years 0, 1, 2, and 3. Expense 100% of intangible drilling costs at the end of first year; Use the larger of percentage depletion (subject to limit rules) and cost depletion.
SOLUTION:
0 | 1 | 2 | 3 | |
Drilling costs (Intangible) | -1500000 | |||
Cost of acquisition of Mineral rights | -2000000 | |||
Equipment | -3000000 | |||
Sales (Quantity) | 350000 | 350000 | 350000 | |
Sales Price | 42 | 43 | 44 | |
Sales Value | 14700000 | 15050000 | 15400000 | |
Less: Operating costs | -3000000 | -3300000 | -3600000 | |
Less: Royalty | -1470000 | -1505000 | -1540000 | |
Before tax cash flows | -6500000 | 10230000 | 10245000 | 10260000 |
Depreciation | -857142.86 | -612244.9 | -437317.78 | |
Depletion | -300000 | -300000 | -300000 | |
Intangibles writte off | -1500000 | |||
EBT | -1500000 | 9072857.14 | 9332755.1 | 9522682.22 |
Tax carryover set off (Year 0) | -1500000 | |||
EBT | 7572857.14 | 9332755.1 | 9522682.22 | |
Tax | -3029142.856 | -3733102.04 | -3809072.888 | |
Net Income | 4543714.284 | 5599653.06 | 5713609.332 | |
Add: Non cash items | 2657142.86 | 912244.9 | 737317.78 | |
After tax Cash flows | -6500000 | 7200857.144 | 6511897.96 | 6450927.112 |