（专业财务模板）预算现金流量表.xlsx

《（专业财务模板）预算现金流量表.xlsx》由会员分享，可在线阅读，更多相关《（专业财务模板）预算现金流量表.xlsx（3页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、20132013年年现现金金流流量量预预算算表表现现金金流流量量预预算算表表20122012年年1 1月月2 2月月3 3月月4 4月月5 5月月一一、经经营营活活动动产产生生的的现现金金流流量量销售商品，提供劳务收到的现金480,000500,000530,000500,000525,000565,000收到的税费返还1,2001,5001,6001,8001,5201,800收到的其他与经营活动有关的现金-现金流入小计481,200501,500531,600501,800526,520566,800购买商品，接受劳务支付的现金115,000122,000138,000153,000150

2、,000132,000支付给职工以及为职工支付的现金 27,00031,00035,00037,80079,00092,000支付的各项税费32,80043,00046,00048,00049,00050,000支付的其他与经营活动有关的现金2,6002,7002,8002,9002,5002,600现金流出小计177,400198,700221,800241,700280,500276,600经营活动产生的现金流量净额303,800302,800309,800260,100246,020290,200二二、投投资资活活动动产产生生的的现现金金流流量量收回投资所收到的现金170,000165,

3、000168,000166,000168,000152,000取得投资收益所收到的现金18,00015,00016,00012,00015,00014,000处置固定资产无形资产其他资产收到的现金净额4,6004,0004,2004,3004,4004,200收到的其他与投资活动有关的现金1,8001,6001,5001,7001,8001,800现金流入小计194,400185,600189,700184,000189,200172,000购建固定资产无形资产其他资产支付的现金17,50017,20017,80019,00016,00017,000投资所支付的现金2,6004,3005,20

4、04,0004,2004,100支付的其他与投资活动有关的现金560780850930989875现金流出小计20,66022,28023,85023,93021,18921,975投资活动产生的现金流量净额173,740163,320165,850160,070168,011150,025三三、筹筹资资活活动动产产生生的的现现金金流流量量吸收投资收到的现金-借款所收到的现金300,000230,000100,000120,00015,00018,000收到的其他与筹资活动有关的现金-现金流入小计300,000230,000100,000120,00015,00018,000偿还债务所支付的现

5、金58,000120,000146,00020,00028,00029,000分配股利利润或偿付利息支付的现金5,00012,00013,20020,50024,0008,000支付的其他与筹资活动有关的现金-现金流出小计63,000132,000159,20040,50052,00037,000筹资活动产生的现金流量净额237,00098,000-59,20079,500-37,000-19,000四四、现现金金及及现现金金等等价价物物增增加加净净额额714,540714,540564,120564,120416,450416,450499,670499,670377,031377,0314

6、21,225421,225预预算算现现金金流流量量趋趋势势123456789101112-100,000 200,000 300,000 400,000 500,000 600,000 预算现金流量趋势6 6月月7 7月月8 8月月9 9月月1010月月1111月月1212月月20132013年年589,000612,000618,000552,300598,500620,000618,0006,827,8001,7001,6001,5001,5001,4001,5001,40018,820-590,700613,600619,500553,800599,900621,500619,4006,

7、846,620146,000145,000144,000147,000148,000149,000147,0001,721,00091,00078,00079,00082,00086,00089,00095,000874,80048,00047,00049,00048,00051,00052,00051,000582,0002,7002,8002,6522,4002,5002,7802,90032,232287,700272,800274,652279,400287,500292,780295,9003,210,032303,000340,800344,848274,400312,400328

8、,720323,5003,636,588-170,000173,000156,000149,000153,000155,000158,0001,933,00016,00015,00017,00016,00015,00015,00018,000184,0004,5004,6004,8004,9005,0005,1005,20055,2001,8521,7801,8501,8711,7001,9001,80021,153192,352194,380179,650171,771174,700177,000183,0002,193,35315,00014,00016,00017,00018,00016

9、,00017,400200,4004,3004,1004,2004,6005,6004,7004,80054,1008527418624226325332028,66820,15218,84121,06222,02224,23221,23322,402263,168172,200175,539158,588149,749150,468155,767160,5981,930,185-15,80019,00020,00019,00025,00028,00035,000644,800-15,80019,00020,00019,00025,00028,00035,000644,80027,00032,

10、00035,00036,00038,00038,00039,000588,0007,5006,00045,0008,22052,50225,62082,532305,074-34,50038,00080,00044,22090,50263,620121,532893,074-18,700-19,000-60,000-25,220-65,502-35,620-86,532-248,274456,500456,500497,339497,339443,436443,436398,929398,929397,366397,366448,867448,867397,566397,5665,318,49920132013年年现现金金流流量量预预算算表表预预算算现现金金流流量量趋趋势势123456789101112-100,000 200,000 300,000 400,000 500,000 600,000 预算现金流量趋势结结构构增增减减13.2214.680.0013.2313.9731.4016.7411.4017.0910.970.0010.379.2211.0010.7510.2810.4519.8114.4811.7410.111.150.001.159.1460.0113.18(2.05)6.44