Financial Analysis
1. Calculation
of Earnings and Cost
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 “Others” in
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
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
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
In this project, the foreign party will invest
RMB4,000,000. Referring to “Cash Flow from Operation”
in 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
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
corporation’s 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 |
|