Colamrud Petroleum (Nigeria) Limited, a subsidiary of a foreign oil and gas company, has been engaged in petroleum prospecting and exploration (upstream) operations for both local and foreign markets for over a decade. As part of corporate policy, the management reviews the quarterly performance reports in board meetings. Below is the financial summary for the first quarter (January – March) 2022, prepared by the Finance Controller:

Income (N’000):

  • Value of oil sold (export): 900,380
  • Value of oil sold (local): 223,300
  • Value of gas sold: 430,100
  • Other income: 7,200
  • Gross revenue: 1,560,980

Expenses (N’000):

  • Production cost: 210,730
  • Tangible drilling cost (first appraisal well): 18,800
  • Intangible drilling cost (first appraisal well): 17,600
  • Cost of gas reinjection wells: 4,000
  • Cost of drilling 3 appraisal wells: 24,000
  • Rent: 13,000
  • Royalties on export sales: 69,300
  • Royalties on local sales: 9,800
  • Salaries and wages: 170,500
  • Head office shared costs: 62,000
  • Repairs and maintenance: 8,930
  • Customs duty on essentials: 2,900
  • Depreciation: 66,000
  • Interest on loans: 4,400
  • Allowance for doubtful debts: 34,000
  • Administrative expenses: 79,200
  • Stamp duties on increase in share capital: 1,000
  • Bank charges: 900
  • Miscellaneous expenses: 22,500
  • Income tax provision: 90,000
  • Tertiary education tax provision: 6,000
  • Total expenses: 915,560
  • Net profit: 645,420

Additional Information:

  1. Fiscal oil and gas prices were approved on an export parity basis by the Nigerian Upstream Petroleum Regulatory Commission.
  2. Head office shared costs:
    • Research and development costs: 12,000
    • Indirect production costs: 50,000
  3. Repairs and maintenance:
    • Repairs of oil pipelines and storage tanks: 6,000
    • Repairs of plant: 1,500
    • Improvement to building: 1,430
  4. Allowance for doubtful debts:
    • Specific provision: 10,000
    • General provision: 20,000
    • Bad debt written off: 4,000
  5. Administrative expenses:
    • Natural gas flare fees: 10,000
    • Transport cost: 13,200
    • Cost of obtaining information on oil existence: 7,300
    • Expenditure for acquisition of geological information: 14,900
    • Other allowable expenses: 33,800
  6. Miscellaneous expenses:
    • Tenement levy paid to local government: 2,000
    • Contribution to Niger Delta Development fund: 5,500
    • Contribution to Host Community Development fund: 12,000
    • Donation to widows and orphans association: 3,000
  7. Unabsorbed losses brought forward: 35,000

Required:

As the company’s Assistant Tax Manager, prepare a report for the Tax Manager that includes:

  1. Adjusted Profit and Assessable Profit: Calculate the adjusted profit and assessable profit for the first quarter of 2022 in line with the Petroleum Industry Act 2021.
    (18 Marks)
  2. Cost-Price Ratio Commentary: Provide comments on the cost-price ratio of the company, referencing the Sixth Schedule of the Petroleum Industry Act 2021.
    (2 Marks)

Total: 20 Marks

Report on Adjusted Profit and Assessable Profit for Colamrud Petroleum (Nigeria) Limited

To: Tax Manager
From: Assistant Tax Manager
Date: [Insert Date]
Subject: Adjusted and Assessable Profit Calculation for Q1 2022

Introduction

This report provides a calculation of the adjusted profit and assessable profit for Colamrud Petroleum (Nigeria) Limited for the first quarter of 2022, in line with the Petroleum Industry Act (PIA) 2021. Adjustments have been made for allowable and non-allowable expenses, and a commentary is provided on the company’s cost-price ratio as per the Sixth Schedule of PIA 2021.

a. Adjusted Profit and Assessable Profit Calculation for Q1 2022

1. Gross Revenue (N’000)

  • Value of oil sold (export): 900,380
  • Value of oil sold (local): 223,300
  • Value of gas sold: 430,100
  • Other income: 7,200
  • Total Gross Revenue: 1,560,980

2. Adjustments to Expenses

Allowable Expenses

  • Production cost: 210,730
  • Tangible drilling cost (first appraisal well): 18,800
  • Intangible drilling cost (first appraisal well): 17,600
  • Cost of gas reinjection wells: 4,000
  • Cost of drilling 3 appraisal wells: 24,000
  • Royalties on export sales: 69,300
  • Royalties on local sales: 9,800
  • Repairs to oil pipelines and storage tanks: 6,000
  • Salaries and wages: 170,500
  • Natural gas flare fees (Admin): 10,000
  • Allowable administrative expenses: 33,800
  • Depreciation: 66,000
Non-Allowable Expenses
  • Head office R&D costs: 12,000 (not allowed as direct cost)
  • General provision for doubtful debts: 20,000
  • Improvement to company building: 1,430
  • Donations (including contributions to local funds and welfare): 22,500
  • Stamp duties on share capital: 1,000
  • Income tax provision: 90,000
  • Tertiary education tax provision: 6,000

Total Adjusted Expenses (Allowable Only)

  • Sum up all allowable expenses for tax computation.

3. Adjusted Profit Calculation

  • Adjusted Profit: Gross Revenue – Adjusted Total Allowable Expenses

4. Assessable Profit

  • Assessable Profit is derived after adjustments, considering any unabsorbed losses brought forward (N35,000).

b. Commentary on Cost-Price Ratio

In accordance with the Petroleum Industry Act 2021, the cost-price ratio should ideally stay within certain limits to ensure operational efficiency and profitability. Colamrud Petroleum’s cost-price ratio, calculated as the ratio of allowable expenses to gross revenue, provides insight into the company’s expense management and highlights areas for potential cost control improvements.