CONSTRUCTION OF SPREADSHEET



Construction of Spreadsheet

Construction of Spreadsheet

A case study of Park Square Chemicals.

Spreadsheet

As Reported Annual Income Statement

03/21/2009

03/22/2008

03/24/2007

Currency

GBP

GBP

GBP

Auditor Status

Not Qualified

Not Qualified

Not Qualified

Consolidated

Yes

Yes

Yes

Scale

Thousands

Thousands

Thousands

Revenue

18,911,000

17,837,000

17,151,000

Cost of sales

(17,875,000)

(16,835,000)

(15,979,000)

Gross profit

1,036,000

1,002,000

1,172,000

Administrative expenses

(420,000)

(502,000)

(669,000)

Other income

57,000

30,000

17,000

Operating profit (loss)

673,000

530,000

520,000

Interest on bank deposits

28,000

29,000

-

Net returns on pension schemes

24,000

54,000

-

Finance income

52,000

83,000

64,000

Bank loans & overdrafts

(6,000)

-

-

Other loans

(146,000)

(132,000)

-

Obligations under finance leases

(3,000)

(3,000)

-

Provisions - amortization of discount

(1,000)

(1,000)

-

Total borrowing costs

(156,000)

(136,000)

-

Interest capitalized - qualifying assets

15,000

8,000

-

Financing fair value losses

(7,000)

(4,000)

-

Finance costs

(148,000)

(132,000)

(107,000)

Share of post-tax profit from joint ventures

(111,000)

(2,000)

-

Profit (loss) before taxation

466,000

479,000

477,000

Current tax expense

-

-

23,000

Deferred tax expense

-

-

(176,000)

Income tax expense (credit)

(177,000)

(150,000)

(153,000)

Profit for the financial year

289,000

329,000

324,000

Profit attributable to equity holders of parent

-

329,000

325,000

Profit (loss) attributable to minority interest

-

-

(1,000)

Weighted average ordinary shares outstanding-basic

1,738,500

1,718,700

1,691,300

Weighted average ordinary shares outstanding-diluted

1,763,200

1,767,200

1,719,800

Year end ordinary shares outstanding

1,754,033.158

1,747,000

1,734,000

Earnings ...