Question
ABC Oil & Gas, LLC (ABC) is in the oil and gas exploration and production business and all of its oil and gas activities are
ABC Oil & Gas, LLC ("ABC") is in the oil and gas exploration and production business and all of its oil and gas activities are in the United States. ABC uses the full cost method of accounting. As an LLC, ABC is a flow-through entity and income taxes are not applicable to it. Data relating to ABC's oil and gas properties at 12/31/2020 are as follows:
Data from ABC's reserve report prepared in accordance with SEC/FASB requirements:
1. Estimated present value of future gross revenue (estimated future production of proved oil and gas reserves at current prices, discounted at 10%) - $145 million
2. Estimated present value of future production costs, based on current costs, discounted at 10% - $62 million
3. Estimated present value of future development costs, based on current costs, discounted at 10% - $16 million
Data from ABC's financial records, after recording current year DD&A, are as follows:
1. Unproved properties not be amortized - $75 million
2. Cost of unproved properties being amortized - $5 million (Market value - $0)
3. Gross capitalized cost of proved properties - $185 million
4. Accumulated DD&A - $63 million
Required: From the data presented above, (1) prepare a ceiling test computation in an Excel worksheet, and (2) if a write-down of capitalized costs is required, at the bottom of the worksheet prepare the appropriate journal entry.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started