南方基金公司估值模型.xls
《南方基金公司估值模型.xls》由会员分享,可在线阅读,更多相关《南方基金公司估值模型.xls(28页珍藏版)》请在淘文阁 - 分享文档赚钱的网站上搜索。
1、公公司司名名称称:一一汽汽轿轿车车 000800主主营营业业务务收收入入(万万元元)2001 A2002 A2003 1Q2003 2Q2003 3Q2003 4Q E整整车车289,279.55421,268.64114,451.42187,774.39301,439.78285,814.02 红旗114,451.4268,523.00101,225.0060,325.00 MAZDA-119,251.39200,214.78225,489.02备备件件55,247.3754,289.5211,286.6713,292.2814,314.8715,746.36合合计计344,526.9247
2、5,558.16125,738.09201,066.67315,754.65301,560.38主主营营业业务务成成本本(万万元元)2001 A2002 A2003 1Q2003 2Q2003 3Q2003 4Q E整整车车244,971.40332,297.7484,644.04142,643.37232,525.32215,307.75 红旗84,644.0457,163.1987,821.5852,337.24 MAZDA-85,480.18144,703.74162,970.51备备件件46,785.2842,823.7115,470.282,788.9510,767.6011,844
3、.36合合计计291,756.68375,121.45100,114.32145,432.32243,292.92227,152.11主主营营业业务务成成本本/收收入入(%)2001 A2002 A2003 1Q2003 2Q2003 3Q整整车车84.68%78.88%73.96%75.97%77.14%红旗73.96%83.42%86.76%MAZDA-71.68%72.27%备备件件84.68%78.88%137.07%20.98%75.22%合合计计84.68%78.88%79.62%72.33%77.05%毛毛利利(万万元元)2001 A2002 A2003 1Q2003 2Q200
4、3 3Q2003 4Q E整整车车44,308.1588,970.9029,807.3845,131.0268,914.4670,506.28 红旗29,807.3811,359.8113,403.427,987.76 MAZDA-33,771.2155,511.0462,518.51备备件件8,462.0911,465.81-4,183.6110,503.333,547.273,902.00合合计计52,770.24100,436.7125,623.7755,634.3572,461.7374,408.27毛毛利利率率(%)2001 A2002 A2003 1Q2003 2Q2003 3Q整
5、整车车15.32%21.12%26.04%24.03%22.86%红旗26.04%16.58%13.24%MAZDA-28.32%27.73%备备件件15.32%21.12%-37.07%79.02%24.78%合合计计15.32%21.12%20.38%27.67%22.95%整整车车销销售售数数量量(辆辆)2002 A2003 E2004 E2005 E2006 E2007 E 红旗26,55726,00024,00024,00024,00024,000 销售量增长(%)-2.1%-7.7%0.0%0.0%0.0%MAZDA-24,00050,00065,00081,250101,563
6、销售量增长(%)-108.3%30.0%25.0%25.0%合计26,55750,00074,00089,000105,250125,563 销售量增长(%)-88.3%48.0%20.3%18.3%19.3%主主营营业业务务收收入入2002 A2003 E2004 E2005 E2006 E2007 E整整车车421,268.64889,479.611,364,777.441,519,510.131,651,489.291,805,761.80 红旗421,268.64344,524.42286,220.29257,598.26231,838.43208,654.59 MAZDA0.0054
7、4,955.191,078,557.151,261,911.871,419,650.851,597,107.21备备件件54,289.5254,640.1859,694.3965,216.1271,248.6277,839.11合合计计475,558.16944,119.791,424,471.841,584,726.251,722,737.901,883,600.91 主主营营业业务务收收入入增增长长(%)-98.53%50.88%11.25%8.71%9.34%主主营营业业务务成成本本/收收入入(%)2002 A2003 E2004 E2005 E2006 E2007 E整整车车84.68
8、%75.90%红旗84.68%81.84%81.84%81.84%81.84%81.84%MAZDA-72.14%72.14%72.14%72.14%72.14%备备件件84.68%74.80%74.80%74.80%74.80%74.80%合合计计84.68%75.84%74.20%73.83%73.56%73.33%2003 1Q2003 2Q2003 3Q2003 4Q E 红旗7,8055,2718,0984,82614.6613.0012.5012.5010.8410.8410.8410.84 MAZDA05,2878,8019,912-22.5622.7522.75-16.1716
9、.4416.44整整车车销销售售数数量量(辆辆)2003 012003 022003 032003 042003 052003 06 红旗3,0161,9872,8021,7011,2112,359 销售量增长(%)-34.1%41.0%-39.3%-28.8%94.8%MAZDA0009441,8722,471 销售量增长(%)-98.3%32.0%合计2,6453,0834,830 销售量增长(%)-#DIV/0!#DIV/0!#DIV/0!16.6%56.7%轿车价格10万以下10-15万15-20万20万以上2002年市场占有率20.90%37.60%18.40%22.30%00094
10、41872247126752957316934703016198728021701121123592790246928391895图图:20032003年年马马自自达达M6M6、红红旗旗月月销销售售量量2003 012003 02 2003 032003 042003 052003 062003 072003 082003 092003 1005001000150020002500300035004000 MAZDA 红旗0.2090.3760.1840.22310万以下10-15万15-20万20万以上红红旗旗MAZDA2001 A2002 A2003 1H应收帐款+其他应收款43,3023
11、7,56637,339三年以上款项8,78419,72920,638三年以上款项比例(%)20.3%52.5%55.3%三年以上款项坏帐准备3,7238,9769,247坏帐准备/应收款(%)42.4%45.5%44.8%2001 A2002 A2003 1H存货-产成品40,40368,38167,352 产成品跌价准备4702,3672,337 产成品跌价准备比例1.16%3.46%3.47%市市净净率率ROE净净利利率率资资产产周周转转率率权权益益乘乘数数600104上上海海汽汽车车3.5914.84%27.01%0.461.28927一一汽汽夏夏利利4.8916.49%11.82%0.
12、502.87625长长安安汽汽车车4.5925.43%10.58%1.142.24600006东东风风汽汽车车2.7513.74%9.80%0.771.952004年年M6销销售售量量(辆辆)35,00040,00045,00050,00055,000主营业务收入增长率16.6%28.0%39.5%50.9%62.3%净净利利润润(万万元元)70,01378,36886,72295,077103,432净利率6.36%6.48%6.59%6.67%6.75%EPS(元元)0.4300.4820.5330.5840.636P/E2017161413市场零售价265,800经销商费用10,000主
13、营业务收入218,632100.0%增值税(17%)37,168主营业务成本161,50073.9%出厂价218,632主营业务税金及附加17,4918.0%消费税(8%)17,491管理费用2,5001.1%进口KD件160,000营业费用8,3333.8%国产零部件与组装1,500利润28,80913.2%4%14%7%60%0%1%3%11%M6M6主主营营业业务务收收入入组组成成经销商费用增值税(17%)消费税(8%)进口KD件国产零部件与组装固定成本摊销广告费用摊销利润0.2090.3760.1840.22310万以下10-15万15-20万20万以上固定成本摊销2,500广告费用摊
14、销8,333利润28,809经销商费用10,000增值税(17%)37,168消费税(8%)17,491进口KD件160,000国产零部件与组装1,500固定成本摊销2,500广告费用摊销8,333利润28,8094%14%7%60%0%1%3%11%M6M6主主营营业业务务收收入入组组成成经销商费用增值税(17%)消费税(8%)进口KD件国产零部件与组装固定成本摊销广告费用摊销利润2003 E2003 1-62003 1-9889,479.61302,225.81603,665.59344,524.42544,955.1954,640.1824,578.9538,893.82944,119.
15、79326,804.76642,559.412003 E2003 1-62003 1-9675,120.48227,287.41459,812.73281,966.05393,154.4340,871.1918,259.2329,026.83715,991.67245,546.64488,839.562003 1-62003 1-975.20%76.17%74.29%74.63%75.14%76.08%2003 E2003 1-62003 1-9214,359.1474,938.40143,852.8662,558.37151,800.7713,768.996,319.729,866.9922
16、8,128.1281,258.12153,719.852003 1-62003 1-924.80%23.83%25.71%25.37%24.86%23.92%2008 E2003 1-92003 1-1024,00021,17423,0690.0%121,87514,08817,55820.0%145,87535,26240,62716.2%2008 E2003 1-91,912,664.92603,665.59187,789.131,724,875.7985,039.2338,893.821,997,704.15642,559.416.06%2008 E2003 1-981.84%72.14
17、%74.80%73.17%2003 072003 082003 092003 102003 112003 122,7902,4692,8391,89518.3%-11.5%15.0%-33.3%-100.0%#DIV/0!2,6752,9573,1693,4708.3%10.5%7.2%9.5%-100.0%#DIV/0!5,4655,4266,0085,36513.1%-0.7%10.7%-10.7%-100.0%#DIV/0!0009441872247126752957316934703016198728021701121123592790246928391895图图:20032003年年
18、马马自自达达M6M6、红红旗旗月月销销售售量量2003 012003 02 2003 032003 042003 052003 062003 07 2003 082003 092003 1005001000150020002500300035004000 MAZDA 红旗PRICEBVTATOTAL13.85973,4301,244,293252,0008.73284,554816,215159,51716.57442,738991,879122,66710.81392,980767,837100,0004%14%7%60%0%1%3%11%M6M6主主营营业业务务收收入入组组成成经销商费用增
19、值税(17%)消费税(8%)进口KD件国产零部件与组装固定成本摊销广告费用摊销利润4%14%7%60%0%1%3%11%M6M6主主营营业业务务收收入入组组成成经销商费用增值税(17%)消费税(8%)进口KD件国产零部件与组装固定成本摊销广告费用摊销利润公公司司名名称称:一一汽汽轿轿车车 0008000008001、经经营营活活动动2001 A2002 A2003 1-92003 E2004 E主营业务收入同比增长率-38.0%-98.5%50.9%主营业务成本/主营业务收入79.7%76.6%76.1%75.8%74.2%主营业务税金及附加/主营业务收入4.98%2.24%6.27%6.27
20、%6.27%营业费用/主营业务收入5.92%6.65%5.55%5.60%5.60%管理费用/主营业务收入8.09%7.65%5.92%6.00%6.00%财务费用/主营业务收入-0.92%-0.82%0.28%0.09%-0.09%实际税率63.4%23.4%4.6%6.0%15.0%股利分配比率335.5%131.7%-75.0%75.0%2、营营运运资资金金2001 A2002 A2003 1-92003 E2004 E货币资金/主营业务收入65.55%55.40%60.40%65.00%20.00%应收帐款周转天数(相对于主营业务收入)-24.116.115.015.0存货周转天数(相
21、对于主营业务成本)-122.680.360.060.0应付帐款周转天数(相对于主营业务成本)-99.0114.885.085.0预付帐款增加 /主营业务成本-0.39%0.38%0.50%0.50%待摊费用增加 /营业费用和管理费用-0.28%0.22%0.22%0.00%预收帐款(负债)增加 /主营业务收入-2.06%1.51%1.51%1.51%预提费用增加/营业费用和管理费用-0.09%29.28%30.00%0.00%其他流动资产增加/主营业务收入增加-0.00.0其他流动负债增加/主营业务收入增加-0.00.0其他长期资产增加/主营业务收入增加-0.00.0其他长期负债增加/主营业务
22、收入增加-0.00.0其他长期资产增加/主营业务收入增加-0.00.0其他长期负债增加/主营业务收入增加-0.00.0坏帐准备/应收帐款19.21%25.94%-28.00%28.00%短期投资跌价准备0.00.00.00.00.0存货跌价准备(含工程亏损准备)5.52%4.33%3.50%3.50%长期投资减值准备0.00.00.00.00.0固定资产减值准备0.54%0.23%0.08%在建工程减值准备0.00.00.00.00.03、资资本本性性投投资资a、假定固定资产采用直线法折旧b、现有固定资产和新建固定资产的折旧年限均为845年,残值率3,年折旧率为2.1612.13.c、各年的固
23、定资产投资如下:d、无形资产无采用直线法折旧2003 1H2003 E2004 E固定资产投资42,000.0120,000.0无形资产投资137.20.04、债债务务和和利利息息a、公司最低现金余额为主营业务收入20.00%b、公司长期银行债务,利率为6.00%2003 1H2003 E2004 Ec、公司现金不足时增加循环贷款,利率为4.00%0.00.00.0d、公司现金余额时利息收入,利率为2.00%5、短短期期投投资资当年变现2005 E2006 E2007 E2008 E11.3%8.7%9.3%6.1%73.8%73.6%73.3%73.2%6.27%6.27%6.27%6.27
24、%5.60%5.60%5.60%5.60%6.00%6.00%6.00%6.00%-0.35%-0.41%-0.48%-0.55%15.0%15.0%15.0%15.0%75.0%75.0%75.0%75.0%2005 E2006 E2007 E2008 E20.00%20.00%20.00%20.00%15.015.015.015.060.060.060.060.085.085.085.085.00.50%0.50%0.50%0.50%0.00%0.00%0.00%0.00%1.51%1.51%1.51%1.51%0.00%0.00%0.00%0.00%0.00.00.00.00.00.00
25、.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.028.00%28.00%28.00%28.00%0.00.00.00.03.50%3.50%3.50%3.50%0.00.00.00.00.00.00.00.02005 E2006 E2007 E2008 E60,000.00.00.00.00.00.00.00.02005 E2006 E2007 E2008 E0.00.00.00.0公公司司名名称称:一一汽汽轿轿车车 000800000800(单位:万元)利利润润表表会计年度截止日:12/312001 A2002 A2003 1-920
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 南方 基金 公司 模型
限制150内