资源描述:
《毕博管理咨询工具方法—BalanceSheetForecastExampleChinese.docx》由会员上传分享,免费在线阅读,更多相关内容在行业资料-天天文库。
1、精品文档,值得拥有[企业名称]2001年7月-2002年6月资产负债表预测期初数七月01八月01九月01十月01十一月01十二月01一月02二月02三月02四月02五月02六月02流动资产$$$$$$$$$$$$$银行存款19,20819,68246,71957,21961,12288,601120,209154,150171,354168,204180,187232,615293,293应收帐款230,502234,930168,080204,600218,680222,530232,650196,350171,820233,310266,530297,110281,820库
2、存34,72435,10748,19748,92556,52558,88842,70644,52474,37972,81570,88756,55953,832原料成本小计34,72435,10748,19748,92556,52558,88842,70644,52474,37972,81570,88756,55953,832284,434289,719262,996310,744336,327370,019395,565395,024417,553474,329517,604586,284628,945非流动资产办公设备1,4091,4091,4091,4091,4091,40
3、91,4091,4091,4091,4091,4091,4091,409工厂与设备45,05458,05460,05468,55480,15480,15480,15480,15480,15480,15480,15480,15480,154车辆25,53625,53625,53625,53625,53625,53625,53625,53625,53625,53625,53625,53625,536无形资产10,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,000建设更新--3,300
4、3,3003,3003,3003,3003,3003,3003,3003,3003,3003,300折旧累计(18,824)(20,202)(21,634)(23,242)(25,093)(26,942)(28,793)(30,642)(32,493)(34,343)(36,193)(38,043)(39,892)63,17574,79778,66585,55795,30693,45791,60689,75787,90686,05684,20682,35680,507总资产347,609364,516341,661396,301431,633463,476487,171484,
5、781505,459560,385601,810668,640709,452流动负债应付帐款267,884259,059217,86481,10986,79986,48777,44370,89384,61094,42796,968100,43497,853已开具发票的货款厂房与设备-14,30016,50025,85038,61038,61038,61038,61038,61038,61038,61038,61038,610建设更新--3,6303,630---------小计267,884273,359237,994110,589125,409125,097116,05310
6、9,503123,220133,037135,578139,044136,463其它应付款项15,90013,83313,29322,77214,95716,90425,97315,31012,10825,39918,75021,51726,254贷款-关联机构3,0003,0003,0003,0003,0003,0003,0003,0003,0003,0003,0003,0003,000贷款-股东2,0002,0002,0002,0002,0002,0002,0002,0002,0002,0002,0002,0002,000288,784292,192256,287138,3
7、61145,366147,001147,026129,813140,328163,436159,328165,561167,717非流动负债财务借款4,7654,5654,3654,1653,9653,7653,5653,3653,1652,9652,7652,5652,365债务(分期付款)28,10027,72427,34626,96526,58126,19425,80425,41225,01724,61924,21823,81423,407银行贷款---150,000148,06314