Why Choose Us?
0% AI Guarantee
Human-written only.
24/7 Support
Anytime, anywhere.
Plagiarism Free
100% Original.
Expert Tutors
Masters & PhDs.
100% Confidential
Your privacy matters.
On-Time Delivery
Never miss a deadline.
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.
Expert Solution
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 |
Archived Solution
You have full access to this solution. To save a copy with all formatting and attachments, use the button below.
For ready-to-submit work, please order a fresh solution below.





