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.