COUNTRY REPORT 

FINANCIAL SPREADSHEETS 

FORECAST FINANCIAL SCENARIOS

This database provides the following Financial Scenarios which analyze the effects of various corporate, financial and marketing strategies on the evolution of the financial situation in a particular industry. Clearly this data can also be applied to companies within the industry and to their own balance sheets and those of their competitors.

Please read the notes in the Financial Definitions page.

F01

MARKETING EXPENDITURE : Financials

G01

MARKETING EXPENDITURE : Margins & Ratios

F02

NEW PRODUCT DEVELOPMENT : Financials

G02

NEW PRODUCT DEVELOPMENT : Margins & Ratios

F03

MARKET SEGMENTATION : Financials

G03

MARKET SEGMENTATION : Margins & Ratios

F04

NEW PLANT + EQUIPMENT INVESTMENT : Financials

G04

NEW PLANT + EQUIPMENT INVESTMENT : Margins & Ratios

F05

NEW TECHNOLOGY INVESTMENT : Financials

G05

NEW TECHNOLOGY INVESTMENT : Margins & Ratios

F06

DISTRIBUTION CHANNEL IMPROVEMENT : Financials

G06

DISTRIBUTION CHANNEL IMPROVEMENT : Margins & Ratios

F07

COST STRUCTURE IMPROVEMENT : Financials

G07

COST STRUCTURE IMPROVEMENT : Margins & Ratios

F08

SHORT-TERM PRICE CUTTING EFFECT : Financials

G08

SHORT-TERM PRICE CUTTING EFFECT : Margins & Ratios

F09

SHORT-TERM PRICE INCREASE EFFECT : Financials

G09

SHORT-TERM PRICE INCREASE EFFECT : Margins & Ratios

F10

QUALITY IMPROVEMENT : Financials

G10

QUALITY IMPROVEMENT : Margins & Ratios

F11

EXPORT SALES IMPROVEMENT : Financials

G11

EXPORT SALES IMPROVEMENT : Margins & Ratios

F12

PERSONNEL + STAFF IMPROVEMENT : Financials

G12

PERSONNEL + STAFF IMPROVEMENT : Margins & Ratios

F13

MARKETING EXPENDITURE INCREASE : + 2% : Financials

G13

MARKETING EXPENDITURE INCREASE : + 2% : Margins & Ratios

F14

MARKETING EXPENDITURE INCREASE : + 4% : Financials

G14

MARKETING EXPENDITURE INCREASE : + 4% : Margins & Ratios

F15

MARKETING EXPENDITURE INCREASE : + 6% : Financials

G15

MARKETING EXPENDITURE INCREASE : + 6% : Margins & Ratios

F16

MARKETING EXPENDITURE INCREASE : + 8% : Financials

G16

MARKETING EXPENDITURE INCREASE : + 8% : Margins & Ratios

F17

MARKETING EXPENDITURE INCREASE : +10% : Financials

G17

MARKETING EXPENDITURE INCREASE : +10% : Margins & Ratios

F18

MARKETING EXPENDITURE INCREASE : +12% : Financials

G18

MARKETING EXPENDITURE INCREASE : +12% : Margins & Ratios

F19

MARKETING EXPENDITURE DECREASE : - 2% : Financials

G19

MARKETING EXPENDITURE DECREASE : - 2% : Margins & Ratios

F20

MARKETING EXPENDITURE DECREASE : - 4% : Financials

G20

MARKETING EXPENDITURE DECREASE : - 4% : Margins & Ratios

F21

MARKETING EXPENDITURE DECREASE : - 6% : Financials

G21

MARKETING EXPENDITURE DECREASE : - 6% : Margins & Ratios

F22

MARKETING EXPENDITURE DECREASE : - 8% : Financials

G22

MARKETING EXPENDITURE DECREASE : - 8% : Margins & Ratios

F23

MARKETING EXPENDITURE DECREASE : -10% : Financials

G23

MARKETING EXPENDITURE DECREASE : -10% : Margins & Ratios

F24

MARKETING EXPENDITURE DECREASE : -12% : Financials

G24

MARKETING EXPENDITURE DECREASE : -12% : Margins & Ratios

F25

FIXED MARKETING COST OBJECTIVES : Financials

G25

FIXED MARKETING COST OBJECTIVES : Margins & Ratios

F26

VARIABLE MARKETING COST OBJECTIVES : Financials

G26

VARIABLE MARKETING COST OBJECTIVES : Margins & Ratios

F27

GENERAL MARKETING PROCESS COST OBJECTIVES : Financials

G27

GENERAL MARKETING PROCESS COST OBJECTIVES : Margins & Ratios

F28

DISTRIBUTION & PRODUCT DELIVERY COST OBJECTIVES : Financials

G28

DISTRIBUTION & PRODUCT DELIVERY COST OBJECTIVES : Margins & Ratios

F29

ADMINISTRATIVE & GENERAL EXPENSE OBJECTIVES : Financials

G29

ADMINISTRATIVE & GENERAL EXPENSE OBJECTIVES : Margins & Ratios

F30

SELLING COST OBJECTIVES : Financials

G30

SELLING COST OBJECTIVES : Margins & Ratios

F31

ADVERTISING COST OBJECTIVES : Financials

G31

ADVERTISING COST OBJECTIVES : Margins & Ratios

F32

PROMOTIONAL & PRICING COST OBJECTIVES : Financials

G32

PROMOTIONAL & PRICING COST OBJECTIVES : Margins & Ratios

F33

RESEARCH & PRODUCT COST OBJECTIVES : Financials

G33

RESEARCH & PRODUCT COST OBJECTIVES : Margins & Ratios

F34

MARKET SHARE BUILDING OBJECTIVES : Financials

G34

MARKET SHARE BUILDING OBJECTIVES : Margins & Ratios

F35

MARKET SHARE HOLDING OBJECTIVES : Financials

G35

MARKET SHARE HOLDING OBJECTIVES : Margins & Ratios

F36

MARKET SHARE HARVESTING OBJECTIVES : Financials

G36

MARKET SHARE HARVESTING OBJECTIVES : Margins & Ratios

F37

SALES COST IMPROVEMENT : Financials

G37

SALES COST IMPROVEMENT : Margins & Ratios

F38

LONG-TERM PRODUCT PRICE CUTTING : Financials

G38

LONG-TERM PRODUCT PRICE CUTTING : Margins & Ratios

F39

LONG-TERM PRODUCT PRICE INCREASE : Financials

G39

LONG-TERM PRODUCT PRICE INCREASE : Margins & Ratios

F40

PROMOTIONAL EXPENDITURE : Financials

G40

PROMOTIONAL EXPENDITURE : Margins & Ratios

F41

TARGET MARKETS DEVELOPMENT : Financials

G41

TARGET MARKETS DEVELOPMENT : Margins & Ratios

F42

ORDER TAKING IMPROVEMENTS : Financials

G42

ORDER TAKING IMPROVEMENTS : Margins & Ratios

F43

PRODUCT POSITIONING : Financials

G43

PRODUCT POSITIONING : Margins & Ratios

F44

PRODUCT BRANDING + MULTI-BRANDING INVESTMENT : Financials

G44

PRODUCT BRANDING + MULTI-BRANDING INVESTMENT : Margins & Ratios

F45

CUSTOMER / ORDER PROCESSING SYSTEMS INVESTMENT : Financials

G45

CUSTOMER / ORDER PROCESSING SYSTEMS INVESTMENT : Margins & Ratios

F46

SYSTEMS INVESTMENT : Financials

G46

SYSTEMS INVESTMENT : Margins & Ratios

F47

OVERSEAS DEVELOPMENT : Financials

G47

OVERSEAS DEVELOPMENT : Margins & Ratios

F48

SALES PERSONNEL + STAFF IMPROVEMENT : Financials

G48

SALES PERSONNEL + STAFF IMPROVEMENT : Margins & Ratios

F49

MATERIALS & ENERGY COST SCENARIOS : Financials

G49

MATERIALS & ENERGY COST SCENARIOS : Margins & Ratios

F50

PAYROLL & STAFF COST SCENARIOS : Financials

G50

PAYROLL & STAFF COST SCENARIOS : Margins & Ratios

F51

ADMINISTRATION COST SCENARIOS : Financials

G51

ADMINISTRATION COST SCENARIOS : Margins & Ratios

F52

CAPITAL COST SCENARIOS : Financials

G52

CAPITAL COST SCENARIOS : Margins & Ratios

F53

PLANT & EQUIPMENT COST SCENARIOS : Financials

G53

PLANT & EQUIPMENT COST SCENARIOS : Margins & Ratios

F54

SALES & MARKETING COST SCENARIOS : Financials

G54

SALES & MARKETING COST SCENARIOS : Margins & Ratios

F55

NEW PRODUCT & NEW TECHNOLOGY COST SCENARIOS : Financials

G55

NEW PRODUCT & NEW TECHNOLOGY COST SCENARIOS : Margins & Ratios

F56

DEPRECIATION & CAPITALIZATION SCENARIOS : Financials

G56

DEPRECIATION & CAPITALIZATION SCENARIOS : Margins & Ratios

F57

SHORT TERM BORROWING SCENARIOS : Financials

G57

SHORT TERM BORROWING SCENARIOS : Margins & Ratios

F58

LONG TERM FINANCIAL SCENARIOS : Financials

G58

LONG TERM FINANCIAL SCENARIOS : Margins & Ratios

F59

FINANCIAL & DEBT SERVICING COST SCENARIOS : Financials

G59

FINANCIAL & DEBT SERVICING COST SCENARIOS : Margins & Ratios

F60

TRADING & OPERATING MARGINS & PROFITABILITY SCENARIOS : Financials

G60

TRADING & OPERATING MARGINS & PROFITABILITY SCENARIOS : Margins & Ratios

F61

PROFIT IMPACT FROM MATERIALS COST REDUCTION : Financials

G61

PROFIT IMPACT FROM MATERIALS COST REDUCTION : Margins & Ratios

F62

PROFIT IMPACT FROM PAYROLL COST REDUCTION : Financials

G62

PROFIT IMPACT FROM PAYROLL COST REDUCTION : Margins & Ratios

F63

PROFIT IMPACT FROM PROCESS COST REDUCTION : Financials

G63

PROFIT IMPACT FROM PROCESS COST REDUCTION : Margins & Ratios

F64

PROFIT IMPACT FROM DISTRIBUTION COST REDUCTION : Financials

G64

PROFIT IMPACT FROM DISTRIBUTION COST REDUCTION : Margins & Ratios

F65

PROFIT IMPACT FROM CUSTOMER HANDLING COST REDUCTION : Financials

G65

PROFIT IMPACT FROM CUSTOMER HANDLING COST REDUCTION : Margins & Ratios

F66

CAPITAL INVESTMENTS OPTIONS: PROCESS PLANT & EQUIPMENT : Financials

G66

CAPITAL INVESTMENTS OPTIONS: PROCESS PLANT & EQUIPMENT : Margins & Ratios

F67

CAPITAL INVESTMENTS OPTIONS: PREMISES : Financials

G67

CAPITAL INVESTMENTS OPTIONS: PREMISES : Margins & Ratios

F68

CAPITAL INVESTMENTS OPTIONS: DISTRIBUTION / HANDLING : Financials

G68

CAPITAL INVESTMENTS OPTIONS: DISTRIBUTION / HANDLING : Margins & Ratios

F69

CAPITAL INVESTMENTS OPTIONS: CUSTOMER HANDLING SYSTEMS : Financials

G69

CAPITAL INVESTMENTS OPTIONS: CUSTOMER HANDLING SYSTEMS : Margins & Ratios

F70

PRODUCT COST IMPROVEMENTS : Financials

G70

PRODUCT COST IMPROVEMENTS : Margins & Ratios

F71

PRODUCT QUALITY IMPROVEMENT : Financials

G71

PRODUCT QUALITY IMPROVEMENT : Margins & Ratios

F72

CUSTOMER HANDLING IMPROVEMENTS : Financials

G72

CUSTOMER HANDLING IMPROVEMENTS : Margins & Ratios

F73

NEW EQUITY SCENARIOS : Financials

G73

NEW EQUITY SCENARIOS : Margins & Ratios

F74

BANK BORROWING: BASE SCENARIOS : Financials

G74

BANK BORROWING: BASE SCENARIOS : Margins & Ratios

F75

BANK BORROWING: 3% INFLATION SCENARIOS : Financials

G75

BANK BORROWING: 3% INFLATION SCENARIOS : Margins & Ratios

F76

BANK BORROWING: 6% INFLATION SCENARIOS : Financials

G76

BANK BORROWING: 6% INFLATION SCENARIOS : Margins & Ratios

F77

BANK BORROWING: 9% INFLATION SCENARIOS : Financials

G77

BANK BORROWING: 9% INFLATION SCENARIOS : Margins & Ratios

F78

BOND / DEBENTURES SCENARIOS : Financials

G78

BOND / DEBENTURES SCENARIOS : Margins & Ratios

F79

ASSET SALES: 5% OF ASSETS SCENARIOS : Financials

G79

ASSET SALES: 5% OF ASSETS SCENARIOS : Margins & Ratios

F80

ASSET SALES: 10% OF ASSETS SCENARIOS : Financials

G80

ASSET SALES: 10% OF ASSETS SCENARIOS : Margins & Ratios

F81

ASSET SALES: 25% OF ASSETS SCENARIOS : Financials

G81

ASSET SALES: 25% OF ASSETS SCENARIOS : Margins & Ratios

F82

SELF GENERATED FUNDS: WORST SCENARIOS : Financials

G82

SELF GENERATED FUNDS: WORST SCENARIOS : Margins & Ratios

F83

SELF GENERATED FUNDS: BEST SCENARIOS : Financials

G83

SELF GENERATED FUNDS: BEST SCENARIOS : Margins & Ratios

F84

TRADING CREDIT EXTENSION & MARGIN REDUCTION SCENARIOS : Financials

G84

TRADING CREDIT EXTENSION & MARGIN REDUCTION SCENARIOS : Margins & Ratios

F85

NEW CAPITAL SCENARIOS : Financials

G85

NEW CAPITAL SCENARIOS : Margins & Ratios

F86

SHORT-TERM LOAN: BASE SCENARIOS : Financials

G86

SHORT-TERM LOAN: BASE SCENARIOS : Margins & Ratios

F87

SHORT-TERM LOAN: 3% INFLATION SCENARIOS : Financials

G87

SHORT-TERM LOAN: 3% INFLATION SCENARIOS : Margins & Ratios

F88

SHORT-TERM LOAN: 6% INFLATION SCENARIOS : Financials

G88

SHORT-TERM LOAN: 6% INFLATION SCENARIOS : Margins & Ratios

F89

SHORT-TERM LOAN: 9% INFLATION SCENARIOS : Financials

G89

SHORT-TERM LOAN: 9% INFLATION SCENARIOS : Margins & Ratios

F90

LONG-TERM LOAN SCENARIOS : Financials

G90

LONG-TERM LOAN SCENARIOS : Margins & Ratios

F91

ASSET SALES: 5% OF ASSETS SCENARIOS : Financials

G91

ASSET SALES: 5% OF ASSETS SCENARIOS : Margins & Ratios

F92

ASSET SALES: 10% OF ASSETS SCENARIOS : Financials

G92

ASSET SALES: 10% OF ASSETS SCENARIOS : Margins & Ratios

F93

ASSET SALES: 25% OF ASSETS SCENARIOS : Financials

G93

ASSET SALES: 25% OF ASSETS SCENARIOS : Margins & Ratios

F94

PROFIT IMPROVEMENTS: WORST SCENARIOS : Financials

G94

PROFIT IMPROVEMENTS: WORST SCENARIOS : Margins & Ratios

F95

PROFIT IMPROVEMENTS: BEST SCENARIOS : Financials

G95

PROFIT IMPROVEMENTS: BEST SCENARIOS : Margins & Ratios

F96

CREDIT EXTENSION & COST REDUCTION SCENARIOS : Financials

G96

CREDIT EXTENSION & COST REDUCTION SCENARIOS : Margins & Ratios

 

CURRENCY DATA:  The currency figures given in this report are in U.S. Dollars. If the Windows Regional Settings on your computer is set to a non-U.S. setting then the currency symbol ($) may appear in the local currency (€, £, ¥, etc.). Either reset your Regional settings, or alternatively read all currency figures in this report as being U.S. Dollars (US$).