Steel pipe is one of the important raw materials in the national economy and is known as the "blood vessel" of industry. Cold-drawn steel pipe is one of the most difficult varieties in steel pipe production. At present, there is a great demand for cold-drawn steel pipes at home and abroad. According to the domestic market demand and its own conditions, a steel pipe company plans to purchase a domestic cold-drawn steel pipe technology and related equipment and invest in a new precision steel pipe project.
1.2 Prediction and estimation of main data
1.2. 1 product scheme and price
See table 1 for the product scheme and sales price forecast (the sales price in the table does not include VAT, the same below).
Table 1? Product plan and price list
serial number
?
name
?
Annual output (ton)
?
Selling price (yuan/ton)
?
1
?
Hydraulic pneumatic cylinder tube
?
3000
?
9000
?
2
?
DOM tube
?
1000
?
7000
?
three
?
Honing tube
?
1 100
?
10000
?
four
?
Automobile inner tube
?
900
?
10000
?
five
?
Petroleum geological pipeline
?
Eight hundred
?
8500
?
six
?
Downhole prop pipe
?
700
?
7500
?
seven
?
Other types of pipes
?
500
?
12000
?
1.2.2 Investment and related data estimation
(1) precision steel pipe workshop: the main workshop covers an area of 20 16m2, the unit cost is 2500 yuan /m2, the equipment weight is 6 10t, the average unit price is 27500 yuan /t, and the installation works account for 9.25% of the equipment purchase price.
(2) Public and auxiliary facilities: the construction area is 2,223 ㎡, the unit price is 2 100 yuan/m2, the equipment weight is 130t, and the average unit price is 26,500 yuan/t; The installation works are 22% of the purchase price of the equipment.
(3) The purchase cost of tools and furniture is 250,000 yuan.
(4) Intangible assets and deferred assets totaled 5.75 million yuan, including 750,000 yuan of deferred assets.
(5) The reserve fund is 8% of the construction investment.
(6) The above investment does not bear interest. 30% of the construction investment is self-owned funds (capital); 70% is a bank loan, the loan interest rate is 8.08%, and the loan is repaid as much as possible. The interest on construction investment loans during the construction period shall be repaid with other self-owned funds.
(7) 30% of the project liquidity is owned by itself; 70% borrowed from the bank, and the loan interest rate was 8.08%.
(8) The construction period of the project is 2 years (the planned annual investment accounts for 50% each), and the production date is 2 years (50% in 1 year and 85% in the second year); The calculation period of the project is 16 years (including construction period and production date).
(9) The return on benchmark investment of the project is 12%, and the payback period of benchmark investment is 10 year.
1.2.3 consumption of raw materials, fuel and power
See Table 2 for consumption of raw materials, fuel and power (all purchased raw materials, fuel and power).
Table 2? Table of raw materials, fuel and power consumption in normal years
serial number
?
project name
?
price
?
consume
?
1
?
raw material
?
?
?
1. 1
?
hot rolled seamless steel tube
?
4500 yuan/ton
?
7600 tons
?
1.2
?
Straight welded pipe
?
3,200 yuan/ton
?
1200 ton
?
1.3
?
Sulfuric acid (93%)
?
600 yuan/ton
?
42t
?
2
?
Fuel and power
?
?
?
2. 1
?
water
?
0.50 yuan/m3
?
24,500 cubic meters
?
2.2
?
electric current
?
0.40 yuan/kilowatt hour
?
16565000 kwh
?
2.3
?
Thermal coal
?
160 yuan/ton
?
4450 tons
?
1.2.4 tax rate
Except for thermal coal, the VAT rate is calculated at 17%. Urban maintenance and construction tax is 0.6% of product sales revenue; Education surcharge is 3% of the value-added tax payable; The income tax rate is 33%.
1.2.5 labor ability and salary
There are 402 production personnel and 88 management service personnel. The per capita salary and welfare expenses of employees are 8900 yuan/person-year.
1.2.6 others
Other expenses in the manufacturing expenses are 2.55 million yuan/year; Other expenses in the management expenses are 973,000 yuan/year; The sales expenses in normal years are 2.35 million yuan/year (treated as variable expenses).
Turnaround days in liquidity estimation: 30 days for accounts receivable, 30 days for raw materials, 65,438+05 days for fuel power, 3 days for products, 65,438+00 days for finished products, 45 days for accounts payable and 30 days for cash.
The residual value of fixed assets is 5% of the original value of fixed assets. Repair fees and maintenance fees are omitted.
2. 1 Basic data collection and summary
According to the background information of the above-mentioned investment projects and the prediction and estimation of relevant data, the estimated values of basic data and normal data are listed in categories.
2.2 Project implementation progress
The precision steel pipe project is planned to be completed in two years and reach the production capacity in three years, that is, the production load will reach 50% of the design capacity in the third year, 85% in the fourth year and the design output in the fifth year. The construction period of this project is 2 years, the production period is 14 years (including 2 years from the date of production), and the calculation period of this project is 16 years.
2.3 Investment estimation, investment plan and fund raising
What is the total investment in fixed assets (construction investment plus construction period interest) calculated at the base period price? Ten thousand yuan, investment in fixed assets? Ten thousand yuan, how much is the construction investment? 10000 yuan, interest during construction 10000 yuan. The value of fixed assets, intangible assets and deferred assets formed after the project is put into production is 1 ten thousand yuan, and the value of intangible assets and deferred assets is 5.75 million yuan.
How much is the working capital in a normal year? Ten thousand yuan.
The total investment of this project is 10000 yuan.
Of the ten thousand yuan construction investment, self-owned funds account for 30% (ten thousand yuan) and bank loans account for 70% (? Ten thousand yuan). Among the working capital of 5.274 million yuan, self-owned funds account for 30% (6.5438+0.582 million yuan); Bank loans accounted for 70% (3.692 million yuan), with an annual interest rate of 8.08%.
2.4 Total cost estimation
The estimation of purchased raw materials, purchased fuel and power is calculated according to the normal year, and then calculated according to the production ratio as the cost of purchased raw materials, purchased fuel and power on the production day of each year. According to the total number of employees, it is estimated that the salary and compound interest expenses are 490 yuan, the annual per capita salary and welfare expenses are 8900 yuan, and the total annual salary is 436.438+0 million yuan.
What is the value of fixed assets? Ten thousand yuan, the residual value of fixed assets is ten thousand yuan, the depreciation period is 14 years, and the annual depreciation expense is? Ten thousand yuan. Intangible assets are amortized by 10 year, with an annual amortization fee of 500,000 yuan; Deferred assets are amortized in five years, and the annual amortization fee is 6.5438+0.5 million yuan.
The above data are included in the total cost estimation table, plus interest and period expenses, and the total cost of the project in each year can be obtained.