主表及财务指标分析模板.xls

资产负债表!编制单位:资产行次年初数期末数负债和股东权益行次年初数流动资产:流动负债:货币资金1!ASC("ZW,1001,1009,,,,年初余额")!ASC("ZW,1001,1009,,,,期末余额")短期借款68!ASC("ZW,2101,2101,,,,年初余额")短期投资2!ASC("ZW,1101,1101,,,,年初余额")-ASC("ZW,1102,1102,,,,年初余额")!ASC("ZW,1101,1101,,,,期末余额")-ASC("ZW,1102,1102,,,,期末余额")应付票据69!ASC("ZW,2111,2111,,,,年初余额")应收票据3!ASC("ZW,1111,1111,,,,年初余额")!ASC("ZW,1111,1111,,,,期末余额")应付账款70!ASC("ZW,2121,2121,,,,贷方年初余额")+ASC("ZW,1151,1151,,,,贷方年初余额")应收股利4!ASC("ZW,1121,1121,,,,年初余额")!ASC("ZW,1121,1121,,,,期末余额")预收账款71!ASC("ZW,2131,2131,,,,贷方年初余额")+ASC("ZW,1131,1131,,,,贷方年初余额")应收利息5!ASC("ZW,1122,1122,,,,年初余额")!ASC("ZW,1122,1122,,,,期末余额")应付工资72!ASC("ZW,2151,2151,,,,年初余额")应收账款6!ASC("ZW,1131,1131,,,,借方年初余额")+ASC("ZW,2131,2131,,,,借方年初余额")-ASC("ZW,1141,1141,,,,年初余额")!ASC("ZW,1131,1131,,,,借方期末余额")+ASC("ZW,2131,2131,,,,借方期末余额")-ASC("ZW,1141,1141,,,,期末余额")应付福利费73!ASC("ZW,2153,2153,,,,年初余额")其他应收款7!ASC("ZW,1133,1133,,,,年初余额")!ASC("ZW,1133,1133,,,,期末余额")应付股利74!ASC("ZW,2161,2161,,,,年初余额")预付账款8!ASC("ZW,1151,1151,,,,借方年初余额")+ASC("ZW,2121,2121,,,,借方年初余额")!ASC("ZW,1151,1151,,,,借方期末余额")+ASC("ZW,2121,2121,,,,借方期末余额")应交税金75!ASC("ZW,2171,2171,,,,年初余额")应收补贴款9!ASC("ZW,1161,1161,,,,年初余额")!ASC("ZW,1161,1161,,,,期末余额")其他应交款80!ASC("ZW,2176,2176,,,,年初余额")存货10!ASC("ZW,1201,1271,,,,年初余额")-ASC("ZW,1281,1281,,,,年初余额")+ASC("ZW,1291,1291,,,,年初余额")-ASC("ZW,2141,2141,,,,年初余额")+ASC("ZW,4101,4107,,,,年初余额")!ASC("ZW,1201,1271,,,,期末余额")-ASC("ZW,1281,1281,,,,