財務報表盈利預測與估值表

1、,代碼,公司名稱,分析日期,600439.SH,瑞貝卡,2009-10-12,歷史數(shù)據(jù),明確預測期,長期預測期,1、經(jīng)營活動假設,2004,2005,2006,2007,2008,2009E,2010E,2011E,2012E,2013E,2014E,2015E,2016E,2017E,2018E,營業(yè)收入增長率（YOY),50.19%,8.12%,40.76%,15.00%,0.47%,17.48%,22.66%,15.09%,8.52%,10.40%,10.16%,5.95%,11.41%,6.11%,7.72%,營業(yè)成本 /營業(yè)收入,80.15%,78.22%,79.83%,73.78%

2、,70.64%,73.28%,68.67%,66.86%,64.90%,63.33%,62.21%,61.21%,60.54%,59.33%,58.67%,營業(yè)稅率,0.01%,0.39%,0.41%,0.61%,0.42%,0.40%,0.40%,0.40%,0.40%,0.40%,0.40%,0.40%,0.40%,0.40%,0.40%,銷售費用 /營業(yè)收入,2.36%,2.50%,1.09%,1.39%,3.02%,3.50%,3.50%,3.40%,3.40%,3.40%,3.40%,3.40%,3.40%,3.40%,3.40%,管理費用 /營業(yè)收入,2.39%,3.60%,3.4

3、2%,2.93%,3.84%,5.00%,4.60%,4.40%,4.30%,4.20%,4.20%,4.20%,4.20%,4.20%,4.20%,實際稅率,29.34%,29.86%,30.32%,27.39%,10.86%,20.00%,20.00%,20.00%,25.00%,25.00%,25.00%,25.00%,25.00%,25.00%,25.00%,少數(shù)股東損益/稅前利潤,0.03%,0.00%,0.02%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,股利分配比例,55.11%

4、,59.13%,49.02%,26.12%,17.57%,30.00%,35.00%,40.00%,42.00%,44.00%,46.00%,48.00%,50.00%,52.00%,54.00%,2、營運資金假設,2004,2005,2006,2007E,2008,2009E,2010E,2011E,2012E,2013E,2014E,2015E,2016E,2017E,2018E,貨幣資金 /營業(yè)收入,15.50%,42.85%,33.89%,27.50%,30.00%,30.00%,30.00%,30.00%,30.00%,30.00%,30.00%,30.00%,30.00%,30.0

5、0%,應收帳款周轉天數(shù)(相對于營業(yè)收入),50.92,42.56,46.56,24.75,30.00,30.00,30.00,30.00,30.00,30.00,30.00,30.00,30.00,30.00,其他應收款/營業(yè)收入,0.89%,0.74%,0.75%,1.27%,1.10%,1.10%,1.10%,1.10%,1.10%,1.10%,1.10%,1.10%,1.10%,1.10%,應收票據(jù)周轉天數(shù)(相對于營業(yè)收入),0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,存貨周轉天數(shù)(相對于營業(yè)

6、成本),256.29,134.69,176.74,360.75,300.00,300.00,300.00,300.00,300.00,300.00,300.00,300.00,300.00,300.00,應付票據(jù)周轉天數(shù)(相對于營業(yè)成本),0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,應付帳款周轉天數(shù)(相對于營業(yè)成本),43.15,8.82,18.45,27.30,22.00,22.00,22.00,22.00,22.00,22.00,22.00,22.00,22.00,22.00,預付帳款增加 /營

7、業(yè)成本,1.38%,2.46%,5.18%,-4.59%,-0.50%,3.00%,3.00%,3.00%,3.00%,3.00%,3.00%,3.00%,3.00%,3.00%,預收帳款(負債)增加 /營業(yè)收入,0.10%,0.26%,-0.13%,0.51%,0.50%,0.50%,0.50%,0.50%,0.50%,0.50%,0.50%,0.50%,0.50%,0.50%,預提費用增加 /營業(yè)收入,-0.01%,-0.05%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,其他流動資產(chǎn)增加

8、/營業(yè)收入增加,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,其他流動負債增加 /營業(yè)收入增加,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,其他長期資產(chǎn)增加 /營業(yè)收入增加,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,0.00%,其他長期負債

9、增加 /營業(yè)收入增加,0.00%,3.53%,0.46%,11.83%,5.00%,5.00%,5.00%,5.00%,5.00%,5.00%,5.00%,5.00%,5.00%,5.00%,壞帳準備 /應收帳款,短期投資跌價準備,存貨跌價準備(含工程虧損準備),長期投資減值準備,固定資產(chǎn)減值準備,在建工程減值準備,3、投資活動假設,2004,2005,2006,2007,2008,2009E,2010E,2011E,2012E,2013E,2014E,2015E,2016E,2017E,2018E,I,資本開支,期末固定資產(chǎn)原值,22226.71 ,27363.13 ,31112.03 ,3

10、3986.48 ,35923.70 ,37892.32 ,39876.62 ,41868.77 ,43864.85 ,45862.89 ,47361.91 ,48611.42 ,期末累計折舊,3948.94 ,5134.80 ,7092.73 ,9223.13 ,11469.76 ,13834.51 ,16318.32 ,18921.66 ,21644.76 ,24487.74 ,27420.67 ,30428.56 ,期末固定資產(chǎn)減值準備,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,1.00 ,固定資產(chǎn)投

11、資,3102.1 ,-678.7 ,619.90 ,6813.68 ,4000.00 ,2000.00 ,1000.00 ,2000.00 ,2000.00 ,2000.00 ,2000.00 ,2000.00 ,1000.00 ,1000.00 ,無形資產(chǎn)投資,1000.00 ,1000.00 ,1000.00 ,0.00 ,1000.00 ,1000.00 ,0.00 ,1000.00 ,0.00 ,1000.00 ,長期待攤費用增加,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,固定資產(chǎn)的折舊年限平均為

12、,15,年,殘值率為,5.00%,年折舊率=,6.33%,新增固定資產(chǎn)折舊率,6.00%,現(xiàn)有無形資產(chǎn)攤銷年限為,15 ,年,新增無形資產(chǎn)攤銷年限為,15 ,年,現(xiàn)有長期待攤費用攤銷年限為,10 ,年,新增長期待攤費用攤銷年限為,10 ,年,II,金融投資及股權投資,交易性金融資產(chǎn)投資,0,0,0,0,0,0,0,0,0,0,0,可供出售金融資產(chǎn)投資,0,0,0,0,0,0,0,0,0,0,0,持有至到期投資,0,0,0,0,0,0,0,0,0,0,0,長期股權投資,0,0,0,0,0,0,0,0,0,0,0,投資性房地產(chǎn),0,0,0,0,0,0,0,0,0,0,0,4、融資活動假設,2004

13、,2005,2006,2007,2008,2009E,2010E,2011E,2012E,2013E,2014E,2015E,2016E,2017E,2018E,貸款,銀行長期貸款增加額,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,債券或短融,期初余額,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,債券發(fā)行數(shù)量,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,債

14、券償還,0.00 ,0.00 ,可轉債,期初余額,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,可轉換債當期發(fā)行/(贖回）,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,可轉債當期轉股,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,轉股價格,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.

15、00 ,0.00 ,0.00 ,轉股股數(shù),0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,股票融資,發(fā)行股數(shù),0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,發(fā)行價格,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,發(fā)行費用所占比例,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,利率假設,a、最低貨幣資金為營業(yè)收入的,15.00%,b、銀行長期貸款利率為,5.94%,c、短期貸款利率為,5.30%,d、現(xiàn)金存款利率為,0.98%,f、債券利率,e、可轉債利率,5、估值參數(shù)相關假設