ERP沙盘模拟资产负债表表格文件下载.xls
- 文档编号:5161864
- 上传时间:2023-05-04
- 格式:XLS
- 页数:58
- 大小:381.50KB
ERP沙盘模拟资产负债表表格文件下载.xls
《ERP沙盘模拟资产负债表表格文件下载.xls》由会员分享,可在线阅读,更多相关《ERP沙盘模拟资产负债表表格文件下载.xls(58页珍藏版)》请在冰点文库上搜索。
第第1年年资资产产负负债债表表用用户户名名ABCDEFGH现现金金84313515212333130应应收收款款400000000在在制制品品40000000产产成成品品00000000原原料料000003260流流动动资资产产合合计计128313515212365730厂厂房房04004040000机机器器设设备备2500002500在在建建工工程程53080704505095固固定定资资产产合合计计30708011085255095资资产产总总计计15810111512529761107125长长期期负负债债1004006024005070短短期期负负债债006000000所所得得税税00000000负负债债合合计计10040606024005070股股东东资资本本8080808080808080利利润润留留存存00000000年年度度净净利利-22-19-25-15-23-19-23-25所所有有者者权权益益合合计计5861556557615755负负债债和和所所有有者者权权益益总总计计1581011151252976110712558615565576157555256605449485850所所有有者者权权益益合合计计ABCDEFGHIJKLMNOP所有者权益合计84313515212333130281613329241404386400000000000000004000000040220200000000000000000000000326000080160141283135152123657303216135392415843100流流动动资资产产统统计计ABCDEFGHIJKLMNOP现金应收款在制品产成品原料流动资产合计0400404000000000404002500002500300155030005308070450509530501010856045503070801108525509560502515851308550资资产产分分析析ABCDEFGHIJKLMNOP厂房机器设备在建工程固定资产合计100400602400507001010006024070100006000000400000000000000000000000010040606024005070401010006024070100负负债债分分析析ABCDEFGHIJKLMNOP长期负债短期负债所得税负债合计808080808080808080808080808080800000000000000000-22-19-25-15-23-19-23-25-28-24-20-26-31-32-22-305861556557615755525660544948585015810111512529761107125926616054109288128150负负债债分分析析ABCDEFGHIJKLMNOP股东资本利润留存年度净利所有者权益合计负债和所有者权益总计808080808080808080808080808080800000000000000000-22-19-25-15-23-19-23-25-28-24-20-26-31-32-22-305861556557615755525660544948585015810111512529761107125926616054109288128150负负债债分分析析ABCDEFGHIJKLMNOP股东资本利润留存年度净利所有者权益合计负债和所有者权益总计IJKLMNOP281613329241404386000000004022020000000000000801601432161353924158431000000040400300155030003050101085604550605025158513085509266160541092881281500101000602407010040000000000000000401010006024070100808080808080808000000000-28-24-20-26-31-32-22-305256605449485850926616054109288128150第第1年年资资产产负负债债表表84313515212333130281613329241404386400000000000000004000000040220200000000000000000000000326000080160141283135152123657303216135392415843100流流动动资资产产统统计计ABCDEFGHIJKLMNOP现金应收款在制品产成品原料流动资产合计0400404000000000404002500002500300155030005308070450509530501010856045503070801108525509560502515851308550资资产产分分析析ABCDEFGHIJKLMNOP厂房机器设备在建工程固定资产合计100400602400507001010006024070100006000000400000000000000000000000010040606024005070401010006024070100负负债债分分析析ABCDEFGHIJKLMNOP长期负债短期负债所得税负债合计808080808080808080808080808080800000000000000000-22-19-25-15-23-19-23-25-28-24-20-26-31-32-22-305861556557615755525660544948585015810111512529761107125926616054109288128150负负债债分分析析ABCDEFGHIJKLMNOP股东资本利润留存年度净利所有者权益合计负债和所有者权益总计808080808080808080808080808080800000000000000000-22-19-25-15-23-19-23-25-28-24-20-26-31-32-22-305861556557615755525660544948585015810111512529761107125926616054109288128150负负债债分分析析ABCDEFGHIJKLMNOP股东资本利润留存年度净利所有者权益合计负债和所有者权益总计第第1年年资资产产负负债债表表用用户户名名ABCDEFGH现现金金84313515212333130应应收收款款400000000在在制制品品40000000产产成成品品00000000原原料料000003260流流动动资资产产合合计计128313515212365730厂厂房房04004040000机机器器设设备备2500002500在在建建工工程程53080704505095固固定定资资产产合合计计30708011085255095资资产产总总计计15810111512529761107125长长期期负负债债1004006024005070短短期期负负债债006000000所所得得税税00000000负负债债合合计计10040606024005070股股东东资资本本8080808080808080利利润润留留存存00000000年年度度净净利利-22-19-25-15-23-19-23-25所所有有者者权权益益合合计计5861556557615755负负债债和和所所有有者者权权益益总总计计1581011151252976110712558615565576157555256605449485850所所有有者者权权益益合合计计ABCDEFGHIJKLMNOP所有者权益合计84313515212333130281613329241404386400000000000000004000000040220200000000000000000000000326000080160141283135152123657303216135392415843100流流动动资资产产统统计计ABCDEFGHIJKLMNOP现金应收款在制品产成品原料流动资产合计0400404000000000404002500002500300155030005308070450509530501010856045503070801108525509560502515851308550资资产产分分析析ABCDEFGHIJKLMNOP厂房机器设备在建工程固定资产合计100400602400507001010006024070100006000000400000000000000000000000010040606024005070401010006024070100负负债债分分析析ABCDEFGHIJKLMNOP长期负债短期负债所得税负债合计808080808080808080808080808080800000000000000000-22-19-25-15-23-19-23-25-28-24-20-26-31-32-22-305861556557615755525660544948585015810111512529761107125926616054109288128150负负债债分分析析ABCDEFGHIJKLMNOP股东资本利润留存年度净利所有者权益合计负债和所有者权益总计808080808080808080808080808080800000000000000000-22-19-25-15-23-19-23-25-28-24-20-26-31-32-22-305861556557615755525660544948585015810111512529761107125926616054109288128150负负债债分分析析ABCDEFGHIJKLMNOP股东资本利润留存年度净利所有者权益合计负债和所有者权益总计IJKLMNOP281613329241404386000000004022020000000000000801601432161353924158431000000040400300155030003050101085604550605025158513085509266160541092881281500101000602407010040000000000000000401010006024070100808080808080808000000000-28-24-20-26-31-32-22-305256605449485850926616054109288128150第第1年年资资产产负负债债表表84313515212333130281613329241404386400000000000000004000000040220200000000000000000000000326000080160141283135152123657303216135392415843100流流动动资资产产统统计计ABCDEFGHIJKLMNOP现金应收款在制品产成品原料流动资产合计0400404000000000404002500002500300155030005308070450509530501010856045503070801108525509560502515851308550资资产产分分析析ABCDEFGHIJKLMNOP厂房机器设备在建工程固定资产合计100400602400507001010006024070100006000000400000000000000000000000010040606024005070401010006024070100负负债债分分析析ABCDEFGHIJKLMNOP长期负债短期负债所得税负债合计808080808080808080808080808080800000000000000000-22-19-25-15-23-19-23-25-28-24-20-26-31-32-22-305861556557615755525660544948585015810111512529761107125926616054109288128150负负债债分分析析ABCDEFGHIJKLMNOP股东资本利润留存年度净利所有者权益合计负债和所有者权益总计808080808080808080808080808080800000000000000000-22-19-25-15-23-19-23-25-28-24-20-26-31-32-22-305861556557615755525660544948585015810111512529761107125926616054109288128150负负债债分分析析ABCDEFGHIJKLMNOP股东资本利润留存年度净利所有者权益合计负债和所有者权益总计第第1年年资资产产负负债债表表用用户户名名ABCDEFGH现现金金84313515212333130应应收收款款400000000在在制制品品40000000产产成成品品00000000原原料料000003260流流动动资资产产合合计计128313515212365730厂厂房房04004040000机机器器设设备备2500002500在在建建工工程程53080704505095固固定定资资产产合合计计30708011085255095资资产产总总计计15810111512529761107125长长期期负负债债1004006024005070短短期期负负债债006000000所所得得税税00000000负负债债合合计计10040606024005070股股东东资资本本8080808080808080利利润润留留存存00000000年年度度净净利利-22-19-25-15-23-19-23-25所所有有者者权权益益合合计计5861556557615755负负债债和和所所有有者者权权益益总总计计1581011151252976110712558615565576157555256605449485850所所有有者者权权益益合合计计ABCDEFGHIJKLMNOP所有者权益合计84313515212333130281613329241404386400000000000000004000000040220200000000000000000000000326000080160141283135152123657303216135392415843100流流动动资资产产统统计计ABCDEFGHIJKLMNOP现金应收款在制品产成品原料流动资产合计0400404000000000404002500002500300155030005308070450509530501010856045503070801108525509560502515851308550资资产产分分析析ABCDEFGHIJKLMNOP厂房机器设备在建工程固定资产合计100400602400507001010006024070100006000000400000000000000000000000010040606024005070401010006024070100负负债债分分析析ABCDEFGHIJKLMNOP长期负债短期负债所得税负债合计808080808080808080808080808080800000000000000000-22-19-25-15-23-19-23-25-28-24-20-26-31-32-22-305861556557615755525660544948585015810111512529761107125926616054109288128150负负债债分分析析ABCDEFGHIJKLMNOP股东资本利润留存年度净利所有者权益合计负债和所有者权益总计808080808080808080808080808080800000000000000000-22-19-25-15-23-19-23-25-28-24-20-26-31-32-22-305861556557615755525660544948585015810111512529761107125926616054109288128150负负债债分分析析ABCDEFGHIJKLMNOP股东资本利润留存年度净利所有者权益合计负债和所有者权益总计IJKLMNOP281613329241404386000000004022020000000000000801601432161353924158431000000040400300155030003050101085604550605025158513085509266160541092881281500101000602407010040000000000000000401010006024070100808080808080808000000000-28-24-20-26-31-32-22-305256605449485850926616054109288128150第第1年年资资产产负负债债表表84313515212333130281613329241404386400000000000000004000000040220200000000000000000000000326000080160141283135152123657303216135392415843100流流动动资资产产统统计计ABCDEFGHIJKLMNOP现金应收款在制品产成品原料流动资产合计0400404000000000404002500002500300155030005308070450509530501010856045503070801108525509560502515851308550资资产产分分析析ABCDEFGHIJKLMNOP厂房机器设备在建工程固定资产合计100400602400507001010006024070100006000000400000000000000000000000010040606024005070401010006024070100负负债债分分析析ABCDEFGHIJKLMNOP长期负债短期负债所得税负债合计808080808080808080808080808080800000000000000000-22-19-25-15-23-19-23-25-28-24-20-26-31-32-22-305861556557615755525660544948585015810111512529761107125926616054109288128150负负债债分分析析ABCDEFGHIJKLMNOP股东资本利润留存年度净利所有者权益合计负债和所有者权益总计808080808080808080808080808080800000000000000000-22-19-25-15-23-19-23-25-28-24-20-26-31-32-22-305861556557615755525660544948585015810111512529761107125926616054109288128150负负债债分分析析ABCDEFGHIJKLMNOP股东资本利润留存年度净利所有者权益合计负债和所有者权益总计第第1年年资资产产负负债债表表用用户户名名ABCDEFGH现现金金84313515212333130应应收收款款400000000在在制制品品40000000产产成成品品00000000原原料料000003260流流动动资资产产合合计计128313515212365730厂厂房房04004040000机机器器设设备备2500002500在在建建工工程程53080704505095固固定定资资产产合合计计30708011085255095资资产产总总计计15810111512529761107125长长期期负负债债1004006024005070短短期期负负债债006000000所所得得税税00000000负负债债合合计计10040606024005070股股东东资资本本8080808080808080利利润润留留存存00000000年年度度净净利利-22-19-25-15-23-19-23-25所所有有者者权权益益合合计计5861556557615755负负债债和和所所有有者者权权益益总总计计1581011151252976110712558615565576157555256605449485850所所有有者者权权益益合合计计ABCDEFGHIJKLMNOP所有者权益合计58615565576157555256605449485850所所有有者者权权益益合合计计ABCDEFGHIJKLMNOP所有者权益合计84313515212333130281613329241404386400000000000000004000000040220200000000000000000000000326000080160141283135152123657303216135392415843100流流动动资资产产统统计计ABCDEFGHIJKLMNOP现金应收款在制品产成品原料流动资产合计0400404000000000404002500002500300155030005308070450509530501010856045503070801108525509560502515851308550资资产产分分析析ABCDEFGHIJKLMNOP厂房机器设备在建工程固定资产合计84313515212333130281613329241404386400000000000000004000000040220200000000000000000000000326000080160141283135152123657303216135392415843100流流动动资资产产统统计计ABCDEFGHIJKLMNOP现金应收款在制品产成品原料流动资产合计0400404000000000404002500002500300155030005308070450509530501010856045503070801108525509560502515851308550资资产产分分析析ABCDEFGHIJKLMNOP厂房机器设备在建工程固定资产合计100400602400507001010006024070100006000000400000000000000000000000010040606024005070401010006024070100负负债债分分析析ABCDEFGHIJKLMNOP长期负债短期负债所得税负债合计808080808080808080808080808080800000000000000000-22-19-25-15-23-19-23-25-28-24-20-26-31-32-22-305861556557615755525660544948585015810111512529761107125926616054109288128150负负债债分分析析ABCDEFGHIJKLMNOP股东资本利润留存年度净利所有者权益合计负债和所有者权益总计100400602400507001010006024070100006000000400000000000000000000000010040606024005070401010006024070100负负债债分分析析ABCDEFGHIJKLMNOP长期负债短期负债所得税负债合计808080808080808080808080808080800000000000000000-22-19-25-15-23-19-23-25-28-24-20-26-31-32-22-30586155
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- ERP 沙盘 模拟 资产负债表