Financial Analysis

1. Calculation of Earnings and CostNew_2.gif (1948 字节)

According to the construction program, by the year 2000 the corporation will have manufactured and sold 40,000 square meters of bamboo flooring and 30,000 square meters of bamboo decorative planking, obtaining a sales revenue of RMB 10,150,000. From 2001 on, the production capacity will be gradually increased to 70,000 square meters of bamboo flooring and 50,000 square meters of bamboo decorative planking, achieving a sales revenue of RMB 20,300,000. 

Table 2: Estimation of Earnings and Cost (RMB in 10 thousand)

Year

1999

2000

2001

2002

2003

Sales Revenue

1015.0

2030.0

2030.0

2030.0

2030.0

Cost of Sales

689.6

1335.0

1335.0

1335.0

1335.0

(1)Depreciation of Fixed Assets
(2)Cost of Repairs
(3)Primary Material
(4)Subsidiary Material
(5)Fuel, Water and Electricity
(6)Wage of Production Workers

44.2
10.0
406.0
101.5
36.5
91.4

44.2
20.0
812.0
203.0
73.1
182.7

44.2
20.0
812.0
203.0
73.1
182.7

44.2
20.0
812.0
203.0
73.1
182.7

44.2
20.0
812.0
203.0
73.1
182.7

Marketing Expenses

10.2

20.3

20.3

20.3

20.3

Sales Tax and Surtax

66.0

132.0

132.0

132.0

132.0

Profit of Sales

249.2

542.7

542.7

542.7

542.7

Administrative Expenses

54.4

79.8

79.8

79.8

79.8

(1)Wage of Superintendence
(2)Amortization of Deferred Assets
(3)Others

24.0
5.0
25.4

24.0
5.0
50.8

24.0
5.0
50.8

24.0
5.0
50.8

24.0
0
50.8

Financial Expenses

16.0

54.5

54.5

54.5

22.5

(1)Interest of Loan
(2)Interest of Current Capital

16.0
0

32.0
22.5

32.0
22.5

32.0
22.5

0
22.5

Total Profit

178.8

408.4

408.4

408.4

445.4

Tax of Profit

59.0

134.8

134.8

134.8

147.0

Net Profit

119.8

273.6

273.6

273.6

298.4

The explanatory notes on the estimation are as follows:
a. The fixed assets depreciation rate is 9% and the salvage value is on the basis of 10% of fixed assets.
b. All other manufacturing expenses are based on present actual cost.
c. Packing cost, one part of marketing expenses, has been included in subsidiary material. Since the products are mainly exported, the marketing expense is relatively low, constituting about 1% of total sales value.
d. Sales tax and surtax are based on 6.5% of sales revenue.
e. The
Othersin administrative expense means various additional administrative expenses after the implementation of the project, such as newly-increased office allowance, business entertainment, insurance, etc., accounting for 2% of sales revenue.
f. The wages and welfare benefits of production workers will be paid on a piecework basis, amounting to 9% of sales value.
g. After going into operation, there will be an additional current capital of RMB 2,500,000 with a yearly interest rate of 9%.
 

2. Break-even Point Analysis New_2.gif (1948 字节)

After the implementation of the project, the newly-added fixed cost is as follows: (RMB in 10 thousand per annum)
Depreciation of fixed assets: 44.2
Wage of superintendence: 24.0
Interest of loan: 32.0
Amortization of deferred assets: 5.0
Total: 105.2

According to Table 2, the variable cost of unit sales value is RMB 151.7/m2.
Variable cost percentage=74.7%
Marginal contribution ratio =( Fixed cost + Profit) / Sales revenue=25.3%
Break-even sales revenue = 105.2/0.253=415.8

3 Analysis of Cash Flow and Investment Recovery New_2.gif (1948 字节)

According to Table 3, we can get the following data:
Net present value in 5-year period: RMB 5,934,000
Static investment recovery period: 2.96 years
Dynamic investment recovery period: 3.21 years
Internal rate of return: 31.46%
 

Table 3: Table of Cash Flow after Taxes (RMB in 10 thousand)

Year

1999

2000

2001

2002

2003

Total

Investment

-537.7

-537.7

Sales Revenue

1015.0

2030.0

2030.0

2030.0

2030.0

9135.0

Discounted Cost

851.0

17112.2

17112.2

17112.2

1687.4

7675.0

Depreciation

44.2

44.2

44.2

44.2

44.2

221.0

Profit

119.8

273.6

273.6

273.6

298.4

1239.0

Cash Flow from Operation

164.0

317.8

317.8

317.8

342.6

1460.0

Current Capital

-250

+250

0

Net Cash Flow

-373.7

67.8

317.8

317.8

592.6

922.3

Accumulative Net Cash Flow

-373.7

-305.9

11.9

329.7

922.3

---------

Net Present Value

-373.7

61.6

262.6

238.2

404.7

593.4

Accumulative Net Present Value

-373.7

-312.1

-49.5

188.7

593.4

-----------

  • The discount rate is 10%.
  • At the end of the 5th year, the salvage value of fixed assets will be RMB 2,697,000. 

4. Investment Recovery Analysis New_2.gif (1948 字节)

In this project, the foreign party will invest RMB4,000,000. Referring to Cash Flow from Operationin the Table of Cash Flow, by the end of the third year, the accumulative cash flow operation has been RMB 7,996,000. Therefore the total investment can be recovered within 3 years. 

5. Elasticity and Risk Analysis New_2.gif (1948 字节)

After analyzing the effects on profit that such five factors have as unit price, variable cost per unit, fixed cost, sales value and unit price of raw material, we can obtain the results as shown in Table 4 and Figure 2 and Figure 3. 

According to Table 4, unit price has the greatest effect on profit with an elasticity coefficient of 4.98. The next is variable cost per unit and then unit price of raw material. 

When the unit price decreases by 20%, the project begins to lose money. However, this situation is almost impossible to occur, because as a resource-based product, its supply is limited by the supply of resource, especially when it comes to raw bamboo, which nearly originates in China only. Furthermore, the corporations international trade is settled by U.S. dollars and thus evades foreign exchange risk.

When the price of raw material rises by 40%, the project begins to incur a loss. But it is barely possible since the present price of bamboo has risen by 200% than that of the previous years. 

The break-even sales value accounts for 20.5% of normal sales value only. As a result, the risk of insufficient sales is quite small. 

Table 4: Effects on Profit from Various Factors

Factor

Normal Index

Break-even Point

Difference between Normal and Break-even Points

Difference Percentage

Elasticity Coefficient

Composite Unit Price

203

162.6

-40.4

-19.9

4.98

Flooring Unit Price

185

147.8

-37.2

-19.9

Planking Unit Price

230

183.5

-46.5

-19.9

Variable Cost

151.7

192.5

40.8

26.9

-3.72

Fixed Cost

10.5

51.3

40.8

388.6

-0.26

Sales Value

2030

415.8

-1614.2

-79.5

1.25

Cost of Raw Material

101.5

142.3

40.8

40.2

2.49

 back7.gif (5150 字节)


 |Home |About us|Agency Service|Letter to You|Benefits for You|

Copyright  2001 LINAN EURO-CHINA Co., Ltd. Last modify: 09.18.2004 Questions about our products,
please send e-mail to
sales@linanwindow.com  811766684@qq.com
TEL: +86-571-63726372  Mobile:+86 13216144789   
FAX: +86-571-63726372
 http://www.linanwindow.com
  MSN Messenger:
ADD: 199# PING_SHAN XIN CUN,, LINAN CITY, ZHEJIANG PROVINCE, P.R.CHINA. 311300
Contact person:Mr.Wang Hua
ICP NO.: 05081080#