PlanMark/Profitability

After inserting all the input info, you see what the effect of changes has been on your profitability and cash flow.

 

PROFIT & LOSS ACC.(000)

FACTORIES TOTAL

start

% OF VAT

PLAN

% OF VAT

DIFF.

 

 

 

 

 

 

GROSS SALES

814361

 

814361

 

0

SALES DEDUCTIBLES

82011

10,1

82011

10,1

0

NET SALES

732350

100,0

732350

100,0

0

RAW MATERIALS

518680

70,8

518680

70,8

0

OTHER VARIABLES

37440

5,1

37440

5,1

0

GROSS MARGIN

176230

24,1

176230

24,1

0

COSTS OF SALES OFFICE

0

0,0

0

0,0

0

FIXED COSTS OF FACT.

77250

10,5

77250

10,5

0

DEPARTEM. G.M.

98980

13,5

98980

13,5

0

TOP MANAGEMENT

16900

2,3

16900

2,3

0

NET CONTRIBUTION

82080

11,2

82080

11,2

0

DEPRECIATION

20500

2,8

20500

2,8

0

INTERESTS

37968

5,2

37968

5,2

0

TAXES

0

0,0

0

0,0

0

NET PROFIT

23611

3,2

23611

3,2

0

CAPITAL EMPLOYED

412456

 

412456

 

0

RET. ON CE, ROCE %

14,9

 

14,9

 

0,0

 

 

 

 

 

 

CASH FLOW ANALYSIS FOR THE WHOLE UNIT

 

 

 

 

 

 

 

 

 

 

 

NET PROFIT+DEPRECIATION

 

44111

(CF I)

 

 

CHANGE INACCS. RECEIVABLE

 

0

 

 

 

CH. IN ACCS. PAYABLE

 

0

 

 

 

CHANGE IN STOCKS

 

0

 

 

 

EXPENDITURE

 

44111

(CF II)

 

 

INVESTMENTS

 

9200

 

 

 

 

 

 

 

 

 

FINANCIAL SURPLUS

 

34911

(CF III)

 

 

 

 

 

 

 

 

PROFIT & LOSS ACC.(000)

TRE

 

start

% OF VAT

PLAN

% OF VAT

DIFF.

 

 

 

 

 

 

GROSS SALES

458801

 

458801

 

0

FREIGHTS

18970

 

18970

 

0

REIMB.+DISCOUNTS

9671

 

9671

 

0

FEES

19014

 

19014

 

0

CURRENCY CHANGES

0

 

0

 

0

OTHER COSTS

0

 

0

 

0

SALES DEDUCTIBLES

47655

10,4

47655

10,4

0

NET SALES

411146

100,0

411146

100,0

0

RAW MATERIALS

292215

71,1

292215

71,1

0

OTHER VARIABLES

20930

5,1

20930

5,1

0

GROSS MARGIN

98001

23,8

98001

23,8

0

COSTS OF SALES OFFICE

0

0,0

0

0,0

0

FIXED COSTS OF FACT.

33700

8,2

33700

8,2

0

DEPARTEM. G.M.

64301

15,6

64301

15,6

0

TOP MANAGEMENT

9488

2,3

9488

2,3

0

NET CONTRIBUTION

54813

13,3

54813

13,3

0

DEPRECIATION

10200

2,5

10200

2,5

0

INTERESTS

19637

4,8

19637

4,8

0

TAXES

 

0,0

 

0,0

0

NET PROFIT

24976

6,1

24976

6,1

0

CAPITAL EMPLOYED

212233

 

212233

 

0

RET. ON CE, ROCE %

21,0

 

21,0

 

0,0

 

 

 

 

 

 

CASH FLOW ANALYSIS

TRE

 

 

NET PROFIT+DEPRECIATION

 

35176

(CF I)

 

 

CHANGE INACCS. RECEIVABLE

 

0

 

 

 

CH. IN ACCS. PAYABLE

 

0

 

 

 

CHANGE IN STOCKS

 

0

 

 

 

EXPENDITURE

 

35176

(CF II)

 

 

INVESTMENTS

 

4500

 

 

 

 

 

 

 

 

 

FINANCIAL SURPLUS

 

30676

(CF III)

 

 

 

 

 

 

 

 

PROFIT & LOSS ACC.(000)

JY

 

start

% OF VAT

PLAN

% OF VAT

DIFF.

GROSS SALES

118695

 

118695

 

0

FREIGHTS

4990

 

4990

 

0

REIMB.+DISCOUNTS

2559

 

2559

 

0

FEES

5155

 

5155

 

0

CURRENCY CHANGES

0

 

0

 

0

OTHER COSTS

0

 

0

 

0

SALES DEDUCTIBLES

12705

10,7

12705

10,7

0

NET SALES

105990

100,0

105990

100,0

0

RAW MATERIALS

73193

69,1

73193

69,1

0

OTHER VARIABLES

5460

5,2

5460

5,2

0

GROSS MARGIN

27337

25,8

27337

25,8

0

COSTS OF SALES OFFICE

0

0,0

0

0,0

0

FIXED COSTS OF FACT.

7200

6,8

7200

6,8

0

DEPARTEM. G.M.

20137

19,0

20137

19,0

0

TOP MANAGEMENT

2446

2,3

2446

2,3

0

NET CONTRIBUTION

17691

16,7

17691

16,7

0

DEPRECIATION

2200

2,1

2200

2,1

0

INTERESTS

4569

4,3

4569

4,3

0

TAXES

 

0,0

 

0,0

0

NET PROFIT

10922

10,3

10922

10,3

0

CAPITAL EMPLOYED

53011

 

53011

 

0

RET. ON CE, ROCE %

29,2

 

29,2

 

0,0

 

 

 

 

 

 

CASH FLOW ANALYSIS

 

JY

 

 

 

NET PROFIT+DEPRECIATION

 

13122

(CF I)

 

 

CHANGE INACCS. RECEIVABLE

 

0

 

 

 

CH. IN ACCS. PAYABLE

 

0

 

 

 

CHANGE IN STOCKS

 

0

 

 

 

EXPENDITURE

 

13122

(CF II)

 

 

INVESTMENTS

 

1200

 

 

 

 

 

 

 

 

 

FINANCIAL SURPLUS

 

11922

(CF III)

 

 

 

 

 

 

 

 

PROFIT & LOSS ACC.(000)

SCA

 

start

% OF VAT

PLAN

% OF VAT

DIFF.

GROSS SALES

236865

 

236865

 

0

FREIGHTS

6000

 

6000

 

0

REIMB.+DISCOUNTS

6572

 

6572

 

0

FEES

9079

 

9079

 

0

CURRENCY CHANGES

0

 

0

 

0

OTHER COSTS

0

 

0

 

0

SALES DEDUCTIBLES

21651

9,1

21651

9,1

0

NET SALES

215214

100,0

215214

100,0

0

RAW MATERIALS

153272

71,2

153272

71,2

0

OTHER VARIABLES

11050

5,1

11050

5,1

0

GROSS MARGIN

50892

23,6

50892

23,6

0

COSTS OF SALES OFFICE

0

0,0

0

0,0

0

FIXED COSTS OF FACT.

36350

16,9

36350

16,9

0

DEPARTEM. G.M.

14542

6,8

14542

6,8

0

TOP MANAGEMENT

4966

2,3

4966

2,3

0

NET CONTRIBUTION

9576

4,4

9576

4,4

0

DEPRECIATION

8100

3,8

8100

3,8

0

INTERESTS

13762

6,4

13762

6,4

0

TAXES

 

0,0

 

0,0

0

NET PROFIT

-12286

-5,7

-12286

-5,7

0

CAPITAL EMPLOYED

147212

 

147212

 

0

RET. ON CE, ROCE %

1,0

 

1,0

 

0,0

 

 

 

 

 

 

CASH FLOW ANALYSIS

 

SCA

 

 

 

NET PROFIT+DEPRECIATION

 

-4186

(CF I)

 

 

CHANGE INACCS. RECEIVABLE

 

0

 

 

 

CH. IN ACCS. PAYABLE

 

0

 

 

 

CHANGE IN STOCKS

 

0

 

 

 

EXPENDITURE

 

-4186

(CF II)

 

 

INVESTMENTS

 

3500

 

 

 

 

 

 

 

 

 

FINANCIAL SURPLUS

 

-7686

(CF III)

 

 


Name: Matti J. Haverila

Email: Matti.Haverila@kolumbus.fi