【财务表格】预算资产负债表.xlsx

2013年预算资产负债表资产负债表预算2012年1月2月3月4月5月6月7月8月9月10月11月12月货币资金160,0006,6966,6967,0317,7007,8287,9959,99011,98313,80813,80814,27714,277盈余资金3,2803,373423(1,390)(10,139)(24,614)(31,631)(35,429)(36,529)(31,271)(27,827)(27,613)(24,789)应收帐款款48,00050,22050,22052,73157,75358,71259,96274,92889,870103,564103,564107,075107,075存货50,00049,91853,73556,54157,77564,89177,82091,00197,82398,78598,78598,78598,785其他流动资产5006706707037707837999991,1981,3811,3811,4281,428流动资产合计261,780110,877111,743115,616113,859107,601114,944141,489164,345186,266189,711193,951196,774固定资产96,00096,00096,00096,100104,380115,380129,600129,600129,600129,700129,700129,700129,700资产折旧(12,000)(12,386)(12,773)(13,159)(13,595)(14,064)(14,687)(15,366)(16,046)(16,726)(17,406)(18,086)(18,765)固定资产净值84,00083,61483,22782,94190,785101,316114,913114,234113,554112,974112,294111,614110,935资产合计345,780194,491194,970198,557204,644208,917229,857255,723277,899299,241302,005305,565307,709应付帐款89,00041,32241,32244,25548,47049,02950,07262,26074,11884,93384,93384,93384,933应交税金13,0002,1672,1562,2072,7092,8222,9064,5086,2147,7937,7938,8968,900应付工资97,0003,5353,5353,5353,5353,6933,6933,6933,6933,6933,6933,6933,693其他流动负债5006706707037707837999991,1981,3811,3811,4281,428流动负债合计199,50047,69347,68250,70155,48556,32657,47071,45985,22397,79997,79998,94998,953银行借款-USD8,2808,2808,2808,2808,2808,28016,56016,56016,56016,56016,56016,5608,280银行借款-RMB4,0004,0004,0004,0004,0004,00014,00022,00024,00024,00018,00010,00010,000银行借款合计12,28012,28012,28012,28012,28012,28030,56038,56040,56040,56034,56026,56018,280负债合计211,78059,97359,96262,98167,76568,60688,030110,019125,783138,359132,359125,509117,233实收资本130,000130,000130,000130,000130,000132,000132,000132,000132,000132,000132,000132,000132,000盈余公积4,0004,5175,0085,5766,8798,3119,82813,70320,11728,88137,64648,05658,475所有者权益134,000134,517135,008135,576136,879140,311141,828145,703152,117160,881169,646180,056190,475负债和所有者权益合计345,780194,491194,970198,557204,644208,917229,857255,723277,899299,241302,005305,565307,709