集团财务模型底稿

公司名称：一汽轿车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.00MAZDA-119,251.39200,214.78225,489.02备件55,247.3754,289.5211,286.6713,292.2814,314.8715,746.36合计344,526.92475,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.24MAZDA-85,480.18144,703.74162,970.51备件46,785.2842,823.7115,470.282,788.9510,767.6011,844.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 2Q2003 3Q2003 4Q E整车44,308.1588,970.9029,807.3845,131.0268,914.4670,506.28红旗29,807.3811,359.8113,403.427,987.76MAZDA-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整车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销售量增长 (%)-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.59MAZDA0.00544,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%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.84MAZDA05,2878,8019,912-22.5622.7522.75-16.1716.4416.44整车销售数量 (辆)2003012003 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%图： 2003 年马自达 M6、红旗月销售量4000350034703000301629573169280227902839250026752469红2471235920001987187218951500170112111000944500MAZDA0000200320032003200320032003200320032003200301020304050607080910轿车价格10万以下10-15万15-20万20万以上2002年市场占有率20.90%37.60%18.40%22.30%0.2230.20910万以下10-15 万0.18410-15 万15-20 万20万以上0.3762001 A2002 A2003 1H应收帐款 + 其他应收款43,30237,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.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主营业务收入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%M6主营业务收入组成固定成本摊销2,500广告费用摊销8,333利润28,809经销商费用10,000增值税（ 17%）37,168消费税（ 8%）17,491进口KD件160,000国产零部件与组装1,500固定成本摊销2,500广告费用摊销8,333利润28,809M6主营业务收入组成3%11%4%0%1%14%7%60%2003 E2003 1-62003 1-9889,479.61302,225.81603,665.59344,524.42544,955.1954,640.1824,578.9538,893.82944,119.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.99228,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%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!470895MAZDA红旗PRICEBVTATOTAL13.85973,4301,244,293252,0008.73284,554816,215159,51716.57442,738991,879122,66710.81392,980767,837100,000成成经销商费用增值税（ 17%）消费税（ 8%）进口KD件国产零部件与组装固定成本摊销广告费用摊销利润