公司估值模型

1、一般情景預(yù)測公司名稱華星化工代碼002018分析日期2006/04/18流通 A股2,000.00流通 B股總股本6,500.00A股股價7.17B 股股價Word 模板指標(biāo)輸出2004A2005A2006E2007E主營收入（萬元）25,110.0035,524.0048,675.9367,905.18主營收入增長率24.39%41.47%37.02%39.50%EBITDA （萬元）4,027.004,577.008,108.4613,348.07EBITDA 增長率15.95%13.66%77.16%64.62%凈利潤（萬元）2,147.002,371.003,522.906,606.9

2、3凈利潤增長率0.56%10.43%48.58%87.54%ROE8.28%8.68%11.67%18.59%EPS（元）0.3300.3650.5421.016P/E21.7119.6613.237.05P/B1.801.711.541.31EV/EBITDA9.1711.036.943.88估值結(jié)果匯總估值方法估值結(jié)果估值 區(qū) 間FCFF20.6417.0823.62FCFE16.3814.9019.09DDM2.862.633.29APV17.9914.9020.13AE10.109.6510.94EVA16.3314.2118.10EVAAEAPVDDMFCFEFCFF0.005.00

3、10.0015.0020.0025.002003200420052006EEBIT3,473.003,448.003,732.006,051.67EBITDA3,473.004,027.004,577.008,108.46所得稅率32.01%33.84%31.63%32.73%NOPLAT2,361.422,281.312,551.494,070.69IC9,162.0016,252.0031,033.0039,678.80Ve32,265.0046,605.0046,605.0046,605.00Vd2,700.004,670.0011,771.0020,489.52WACC11.55%11

4、.43%10.50%9.63%EV32,649.0036,937.0050,467.0056,257.40業(yè)績表現(xiàn)2003200420052006E收入增長率24.39%41.47%37.02%凈利潤增長率0.56%10.43%48.58%EBITDA 增長率15.95%13.66%77.16%EBIT 增長率-0.72%8.24%62.16%主營業(yè)務(wù)利潤率31.41%25.80%22.22%24.26%EBITDA Margin (%)11.25%5.28%26.85%ROE24.32%8.28%8.68%11.67%ROIC25.77%14.04%8.22%10.26%ROIC WACC1

5、4.22%2.60%-2.28%0.63%價值比率2003200420052006EP / E15.1121.7119.6613.23EV/ 收入1.621.471.421.16EV / EBITDA9.409.1711.036.94EV / EBIT9.4010.7113.529.30EV / NOPLAT13.8316.1919.7813.82EV/IC3.562.271.631.42P / B3.681.801.711.54Dividend Yield (%)1.16%0.48%1.39%1.43%每股指標(biāo)2003200420052006E報(bào)表 EPS0.470.330.360.54經(jīng)常

6、性 EPS每股紅利0.080.030.100.10每股經(jīng)營現(xiàn)金流1.26每股凈資產(chǎn)1.953.994.204.64流動性2003200420052006E凈負(fù)債 / 權(quán)益0.04-0.370.140.32總負(fù)債 / 總資產(chǎn)49.22%35.22%51.02%60.58%流動比率1.102.271.100.91速動比率0.571.490.600.48輸出到 Word 模板中的三張表（輸出 2004-2008年）利潤表（萬元）200420052006E增長率 %主營業(yè)務(wù)收入25,110.0035,524.0048,675.9337.02%主營業(yè)務(wù)利潤6,468.007,873.0011,785.6

7、149.70%其他業(yè)務(wù)利潤55.00-49.0050.00N/A營業(yè)費(fèi)用1,929.002,596.003,648.2440.53%管理費(fèi)用1,146.001,496.002,135.6942.76%財(cái)務(wù)費(fèi)用197.00221.00784.38254.92%營業(yè)利潤3,251.003,511.005,267.2950.02%投資收益0.000.000.00N/A利潤總額3,245.003,468.005,237.2951.02%凈利潤2,147.002,371.003,522.9048.58%NOPLAT2,281.312,551.494,070.6959.54%資產(chǎn)負(fù)債表（萬元）200420

8、052206E增長率 %流動資產(chǎn)26,134.0025,839.0035,559.5837.62%貨幣資金14,338.007,909.0010,837.1237.02%短期投資0.000.000.00N/A應(yīng)收帳款1,730.00其他應(yīng)收款233.00存貨8,949.00長期投資0.00固定資產(chǎn)12,883.00無形資產(chǎn)996.00總資產(chǎn)40,013.00無息負(fù)債9,030.00有息負(fù)債4,670.00少數(shù)股東權(quán)益0.00股東權(quán)益25,920.00凈營運(yùn)資本14,604.00投入資本 IC16,252.00現(xiàn)金流量表（萬元）2004凈利潤2,147.00折舊攤銷579.00凈營運(yùn)資金增加13

9、,925.00經(jīng)營活動產(chǎn)生現(xiàn)金流1,372.00投資活動產(chǎn)生現(xiàn)金流-3,986.00融資活動產(chǎn)生現(xiàn)金流4,458.00現(xiàn)金凈增（減）1,844.00指標(biāo)說明：EV =股權(quán)價值 +債權(quán)價值現(xiàn)金EBITDA EBIT 折舊 攤銷EBIT 營業(yè)利潤財(cái)務(wù)費(fèi)用4,047.004,449.469.94%413.00565.9037.02%11,801.0016,726.4541.74%0.00151.00N/A29,587.0040,051.2135.37%210.00189.00-10.00%55,787.0076,559.7837.24%15,644.0023,892.8652.73%11,771.0

10、020,489.5274.07%0.000.00N/A27,322.0030,177.4110.45%2,424.00-3,322.80N/A31,033.0039,678.8027.86%20052006E增長率 %2,371.003,522.9048.58%845.002,056.79143.41%-12,180.00-5,746.80N/A4,894.008,161.4766.76%-1,156.00-12,500.00N/A-4,756.007,266.65N/A-1,018.002,928.12N/ANOPLAT EBIT ×（ 1所得稅率）EBIT 所得稅（只考慮核心業(yè)務(wù)

11、，扣除非經(jīng)常性損益）IC （ invested capital ） 股東權(quán)益 長期借款 短期借款 應(yīng)付債券 少數(shù)股東權(quán)益現(xiàn)金短期投資長期投資 ROIC NOPLAT / IC × 100OPFCF EBITDA 稅收 凈資本性支出營運(yùn)資本的增加WACC (Ke ×Ve) （ Kd× Vd） / (Ve Vd)Kd 債務(wù)成本 平均債務(wù)利率（1稅率）（短期借款×短期借款利率長期借款×長期借款利率長期應(yīng)付債券×長期（1所得稅率）Ve 股本價值 股價×總股本（H股、 B 股按各自股價×匯率轉(zhuǎn)換為人民幣計(jì)算，非流通股按A 股

12、計(jì)算）Vd 債務(wù)價值短期借款長期借款應(yīng)付債券Ke Rf + (Rm Rf)營運(yùn)資本 流動資產(chǎn) 流動負(fù)債公司自由現(xiàn)金流FCFF EBIT ×（1-所得稅率）折舊資本支出非現(xiàn)金性流動資本變化股權(quán)資本自由現(xiàn)金流FCFE 稅前利潤 ×（1- 所得稅率）折舊資本支出非現(xiàn)金性流動資本變化新增債務(wù)債務(wù)償還0.00流通 H股0.000.00H股股價0.002008E74,220.529.30%17,156.3028.53%9,175.1638.87%21.35%1.4125.081.082.45敏感度分析區(qū)間貼現(xiàn)率 ±1%，長期增長率 ±1%6.54貼現(xiàn)率 ±

13、1%，長期增長率 ±1%4.19貼現(xiàn)率 ±1%，長期增長率 ±1%0.66貼現(xiàn)率 ±1%，長期增長率 ±1%5.23貼現(xiàn)率 ±1%，長期增長率 ±1%1.29貼現(xiàn)率 ±1%，長期增長率 ±1%3.89EVAAEAPVDDMFCFEFCFF0.005.0010.0015.0020.0025.002007E2008E10,826.0114,371.6013,348.0717,156.3032.73%32.73%7,282.189,667.1540,557.7638,271.8646,605.0046,605.

14、0020,294.5411,977.949.65%10.48%51,781.2542,058.622007E2008E39.50%9.30%87.54%38.87%64.62%28.53%78.89%32.75%27.80%31.16%27.25%60.30%18.59%21.35%17.96%25.26%8.31%14.78%2007E2008E7.055.080.760.573.882.454.782.937.114.351.281.101.311.082.69%3.73%2007E2008E1.021.410.190.271.182.025.476.612007E2008E0.15-0.

15、1159.70%52.61%1.081.320.590.752007E增長率 %2008E增長率 %67,905.1839.50%74,220.529.30%18,844.8759.90%23,090.8822.53%50.000.00%100.00100.00%5,089.4739.50%5,562.809.30%2,979.3939.50%3,256.489.30%973.8624.16%701.41-27.98%9,852.1487.04%13,670.1938.75%0.00N/A0.00N/A9,822.1487.54%13,640.1938.87%6,606.9387.54%9,1

16、75.1638.87%7,282.1878.89%9,667.1532.75%2007E增長率 %2008E增長率 %48,826.2737.31%53,237.099.03%15,118.2939.50%16,524.329.30%0.00N/A0.00N/A6,996.6757.25%7,647.379.30%565.900.00%862.8852.48%22,243.7132.99%23,181.124.21%151.000.00%151.000.00%38,550.14-3.75%36,786.44-4.58%168.00-11.11%147.00-12.50%88,177.4115.17%90,676.532.83%30,350.3627.03%33,729.3511.13%20,294.54-0.95%11,977.94-40.98%0.00N/A0.00N/A35,532.5117.75%42,969.2420.93%3,681.37N/A13,029.80253.94%40,557.762.22%38,271.86-5.64%2007E增長率 %2008E增長率 %6,606.9387.54%9,175.1638.87%2,52