南方基金管理公司的财务模型底稿利润表.doc

公司名称：一汽轿车 000800 利润表 会计年度截止日：12/31 2001 A 2002 A 2003 1-9 2003 E 2004 E 2005 E 2006 E 2007 E 2008 E 函数关系注释 主营业务收入 344,526.92 475,558.16 642,559.41 944,119.79 1,424,471.84 1,584,726.25 1,722,737.90 1,883,600.91 1,997,704.15 O11* 1+P12 增长率（YOY 38.0% 98.5% 50.9% 11.3% 8.7% 9.3% 6.1% 经营活动预测!M14 主营业务收入净额 344,526.92 475,558.16 642,559.41 944,119.79 1,424,471.84 1,584,726.25 1,722,737.90 1,883,600.91 1,997,704.15 减：主营业务成本 274,590.32 364,448.37 488,839.56 715,991.67 1,057,018.63 1,170,004.13 1,267,233.86 1,381,214.20 1,461,701.02 -P11*经营活动预测!M16 17,166.36 10,673.08 40,295.16 59,196.31 89,314.38 99,362.34 108,015.67 118,101.78 125,256.05 主营业务利润 52,770.24 100,436.71 113,424.69 168,931.81 278,138.82 315,359.79 347,488.37 384,284.94 410,747.08 P11+P14 毛利率 15.3% 21.1% 17.7% 17.9% 19.5% 19.9% 20.2% 20.4% 20.6% P16/P11 加：其他业务利润 87.26 102.25 773.84 773.84 0.00 0.00 0.00 0.00 0.00 减：存货跌价损失 -1,490.04 4,384.87 -3,084.76 4,203.57 -2,892.01 3,818.16 营业费用 20,378.98 31,642.42 35,679.01 52,870.71 79,770.42 88,744.67 96,473.32 105,481.65 111,871.43 -P11*经营活动预测!M18 27,882.31 36,403.57 38,034.05 56,647.19 85,468.31 95,083.58 103,364.27 113,016.05 119,862.25 -P11*经营活动预测!M20 122.17 186.87 7,299.28 7,689.25 836.93 0.00 0.00 0.00 -债务预测!R37 8,771.18 8,985.72 6,375.55 7,088.51 8,973.93 10,946.95 债务预测!R44 财务费用 -3,170.43 -3,897.11 1,813.12 828.09 -1,296.48 -5,538.61 -7,088.51 -8,973.93 -10,946.95 营业利润 7,766.64 36,390.08 38,672.35 60,849.70 109,811.70 140,154.92 150,535.72 177,653.18 186,142.19 加：投资收益 -1,157.53 402.29 1,021.80 2,043.60 2,043.60 2,043.60 2,043.60 2,043.60 加：期货收益 补贴收入 营业外收入 1.04 0.68 16.14 16.14 减：营业外支出 942.20 943.17 -737.53 -737.53 加：以前年度损益调整 税前利润 6,825.48 34,290.06 39,828.31 62,625.17 111,855.30 142,198.52 152,579.32 179,696.78 188,185.79 P32+P36+P38 减：所得税 4,327.34 8,038.43 1,842.39 3,757.51 16,778.29 21,329.78 22,886.90 26,954.52 28,227.87 -P41*经营活动预测!M22 63.4% 23.4% 4.6% 6.0% 15.0% 15.0% 15.0% 15.0% 15.0% 加