创业经济数据分析模型(闻心).xls

金额单位（万元）营业周期单位月总营业期数36当前营业期1启动资金16.19贷款年利率6.00%每期资金成本0.08每期固定成本2.95当期销售额20.00风险拨备率1.50%每期风险拨备0.30每期变动成本12.86销售费用率5.00%营业期12每期销售费用1.00启动资金-16.19 0.00营业税率6.00%每期资金成本-0.08-0.08 营业税金1.20每期固定成本-2.95-2.95 当期营业利润4.64当期营业利润4.644.60研发时间（期）0当期净现金流量-14.57 1.57所得税率25.00%累计现金流量-14.57-13.01 所得税0.000.00累累计计现现金金流流量量现现值值135,352.24135,352.24税后累计净现金流量-14.57-13.01 总总投投资资回回报报率率83.62%83.62%累计现金流净现值-14.50-12.88 年年均均投投资资回回报报率率27.87%27.87%累计现金流量现值13.54累累计计现现金金流流净净现现值值123456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36-20.00-15.00-10.00-5.00 0.00 5.00 10.00 15.00 34567891011120.000.000.000.000.000.000.000.000.000.00-0.08-0.08-0.08-0.08-0.08-0.08-0.08-0.08-0.08-0.08-2.95-2.95-2.95-2.95-2.95-2.95-2.95-2.95-2.95-2.95 4.554.504.464.414.364.314.264.224.174.121.521.471.431.381.331.281.231.181.141.09-11.49-10.02-8.59-7.21-5.88-4.60-3.37-2.18-1.04 0.040.000.000.000.000.000.000.000.000.000.01-11.49-10.02-8.59-7.21-5.88-4.60-3.37-2.18-1.04 0.03-11.32-9.82-8.38-7.00-5.68-4.42-3.22-3.22 -2.07-0.99 0.03每每期期净净现现金金流流量量12345678910 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36-16.00-14.00-12.00-10.00-8.00-6.00-4.00-2.00 0.00 2.00 4.00 累累计计现现金金流流净净现现值值123456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36-20.00-15.00-10.00-5.00 0.00 5.00 10.00 15.00 131415161718192021220.000.000.000.000.000.000.000.000.000.00-0.08-0.08-0.08-0.08-0.08-0.08-0.08-0.08-0.08-0.08-2.95-2.95-2.95-2.95-2.95-2.95-2.95-2.95-2.95-2.95 4.074.023.973.923.863.813.763.713.653.601.040.990.940.880.830.780.730.680.620.571.082.063.003.884.725.506.226.907.528.090.000.000.000.000.000.000.000.000.000.001.082.063.003.884.725.506.226.907.528.091.011.922.783.584.335.025.666.256.787.25每每期期净净现现金金流流量量12345678910 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36-16.00-14.00-12.00-10.00-8.00-6.00-4.00-2.00 0.00 2.00 4.00 232425262728293031320.000.000.000.000.000.000.000.000.000.00-0.08-0.08-0.08-0.08-0.08-0.08-0.08-0.08-0.08-0.08-2.95-2.95-2.95-2.95-2.95-2.95-2.95-2.95-2.95-2.95 3.553.493.443.383.333.273.213.163.103.040.520.460.410.350.300.240.180.130.070.018.619.079.489.8310.1210.3610.5510.6710.7410.750.002.260.000.000.000.000.000.000.000.008.616.819.489.8310.1210.3610.5510.6710.7410.757.686.048.378.638.859.019.139.199.209.17每每期期净净现现金金流流量量12345678910 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36-16.00-14.00-12.00-10.00-8.00-6.00-4.00-2.00 0.00 2.00 4.00 333435360.000.000.000.00-0.08-0.08-0.08-0.08-2.95-2.95-2.95-2.95 2.982.932.872.81-0.05-0.11-0.17-0.22 10.7110.6010.4416.480.000.000.000.2910.7110.6010.4416.209.088.958.7613.54项项目目名名称称金金额额折折旧旧期期数数残残值值装修40000360按金240003624000设备10000483000产品研发0360流动资金42857.1436 25714.29基础库存200003610000品牌加盟费20000360工商登记5000360项项目目每每期期金金额额基本工资16000福利3200水电能源2300租金8000零利润销售额450 5 9#零销售额毛利率100%100#预计每期销售额20万元预计每期毛利率55.56%预计每期销售成本12.86万元每期资金周转次数3.0030毛利率递减率1.0%10当期毛利率55.6%当期毛利额7.14万元项目总现金流量13.54万元04.59 13.5 18 22.5 27 31.5 36 40.5 450%20%40%60%80%100%120%有效区域04.59 13.5 18 22.5 27 31.5 36 40.5 450%20%40%60%80%100%120%