杜邦分析报表(自动公式计算)

整理文档很辛苦,赏杯茶钱您下走!

免费阅读已结束,点击下载阅读编辑剩下 ...

阅读已结束,您可以下载文档离线阅读编辑

资源描述

索引号:Z10-1编制人:复核人:报表项目索引上期数本期数本期各项目比重本期比上期增减数本期比上期增减比率重大或异常项目现金C12,306,287.86############36.32%8,434,830.20365.73%关注银行存款C20.00%--OK其他货币资金C30.00%--OK短期投资C40.00%--OK应收票据C50.00%--OK应收股利0.00%--OK应收利息0.00%--OK应收帐款C69,079,630.055,196,280.8517.57%-3,883,349.20-42.77%OK减:坏帐准备C60.00%--OK应收帐款净值9,079,630.055,196,280.8517.57%-3,883,349.20-42.77%OK预付帐款C7578,737.031.96%578,737.03∞关注其他应收款C82,566,918.914,526,813.8415.31%1,959,894.9376.35%关注应收补贴款0.00%--OK应收出口退税0.00%--OK内部往来(借)C90.00%--OK存货C1010,112,646.826,279,735.6421.24%-3,832,911.18-37.90%OK待摊费用C11151,905.23548,710.591.86%396,805.36261.22%关注0.00%--OK流动资产合计24,217,388.8727,871,396.0194.25%3,654,007.1415.09%OK长期股权投资C120.00%--OK长期债权投资0.00%--OK固定资产C134,208,437.044,221,007.9614.27%12,570.920.30%OK减:累计折旧C131,995,121.922,524,092.078.54%528,970.1526.51%OK固定资产净值2,213,315.121,696,915.895.74%-516,399.23-23.33%OK减:固定资产减值准备0.00%--OK固定资产净额2,213,315.121,696,915.895.74%-516,399.23-23.33%OK固定资产清理0.00%--OK在建工程C140.00%--OK工程物资0.00%--OK固定资产合计2,213,315.121,696,915.895.74%-516,399.23-23.33%OK无形资产C1531,214.893,214.890.01%-28,000.00-89.70%关注0.00%--OK无形资产合计31,214.893,214.890.01%-28,000.00-89.70%关注长期待摊费用C160.00%--OK0.00%--OK0.00%--OK其他资产合计--0.00%--OK递延税款借项0.00%--OK0.00%--OK资产合计26,461,918.8829,571,526.79100.00%3,109,607.9111.75%OK结算期:年月日页次:日期:年月日日期:年月日客户名称:项目:分析报表(资产)索引号:Z10-2编制人:复核人:报表项目索引上期数本期数本期各项目比重本期比上期增减数本期比上期增减比率短期借款D13,000,000.003,000,000.0010.14%-0.00%应付票据D20.00%--应付帐款D310,962,221.948,663,831.0129.30%-2,298,390.93-20.97%内部往来(贷)C90.00%--预收帐款D42,987,497.934,921,467.5916.64%1,933,969.6664.74%应付工资D5.000.00%--应付福利费/基金D60.00%--应交税金D748,845.90675,573.592.28%626,727.691283.07%其他应交款D8349.6239,292.670.13%38,943.0511138.68%应付利润D90.00%--应付利息0.00%--其他应付款D102,362,043.552,460,888.868.32%98,845.314.18%预提费用D110.00%--预计负债0.00%--递延收益0.00%--一年内到期的长期负债0.00%--流动负债合计19,360,958.9419,761,053.7266.82%400,094.782.07%长期借款D120.00%--应付债券D130.00%--长期应付款D140.00%--长期负债合计--0.00%--待转销汇兑损益0.00%--其他负债合计0.00%--递延税款贷项0.00%--负债合计19,360,958.9419,761,053.7266.82%400,094.782.07%实收资本E11,500,000.001,500,000.005.07%-0.00%中方投资0.00%--外方投资--0.00%--资本公积E20.00%--盈余公积E3-156,620.05-156,620.05-0.53%-0.00%本年利润E40.00%--未分配利润E45,757,579.998,467,093.1228.63%2,709,513.1347.06%所有者权益合计7,100,959.949,810,473.0733.18%2,709,513.1338.16%负债及所有者权益合计26,461,918.8829,571,526.79100.00%3,109,607.9111.75%结算期:年月日页次:日期:年月日日期:年月日客户名称:项目:分析报表(负债)重大或异常项目资产行次年初数期末数OK流动负债OK短期借款463,000,000.003,000,000.00OK应付票据47OK应付帐款4810,962,221.948,663,831.01关注预收帐款492,987,497.934,921,467.59OK其他应付款502,362,043.552,460,888.86OK应付工资51关注应付福利款520.000.00关注未交税金5348,845.90675,573.59OK未付利润540.000.00OK其他未交款55349.6239,292.67OK预提费用560.000.00OK一年内到期的长期负债57OK其他流动负债58OKOKOK流动负债合计6519,360,958.9419,761,053.72OKOK长期负债:OK长期借款66OK应付债卷67OK长期应付款68OK其他长期负债75OK长期负债合计760.000.00OKOK所有者权益:OK实收资本781,500,000.001,500,000.00OK资本公积79OK盈余公积80-156,620.05-156,620.05OK未分配利润815,757,579.998,467,093.12OK所有者权益合计857,100,959.949,810,473.07OKOKOK负债及所有者权益总计9026,461,918.8829,571,526.79页次:日期:年月日日期:年月日索引号:Z10-3编制人:复核人:报表项目索引上期数本期数本期各项目比重本期比上期增减数本期比上期增减比率主营业务收入F130,128,642.2934,011,935.88100.00%3,883,293.5912.89%其中:出口收入0.00%--减:折扣与折让F10.00%--主营业务收入净额30,128,642.2934,011,935.88100.00%3,883,293.5912.89%减:主营业务税金及附加F3269,390.38386,635.641.14%117,245.2643.52%主营业务成本F223,057,316.6321,024,131.0861.81%-2,033,185.55-8.82%其中:出口成本0.00%--主营业务毛利7,071,325.6612,987,804.8038.19%5,916,479.1483.67%减:营业费用F41,083,112.972,369,839.846.97%1,286,726.87118.80%管理费用F57,400,719.747,502,834.2322.06%102,114.491.38%财务费用F645,659.48-344,067.70-1.01%-389,727.18-853.55%其中:利息支出0.00%--汇兑损益0.00%--主营业务利润5,718,822.3110,231,329.3230.08%4,512,507.0178.91%加:其他业务收入F70.00%--减:其他业务支出0.00%--营业利润-1,727,556.913,072,562.799.03%4,800,119.70-277.86%加:投资收益F8-166,002.86-0.49%-166,002.86∞补贴收入0.00%--营业外收入F997,990.56287,900.000.85%189,909.44193.80%减:营业外支出F1041,620.0051,363.310.15%9,743.3123.41%利润总额-1,671,186.353,143,096.629.24%4,814,282.97-288.08%减:所得税F1168,228.91335,798.760.99%267,569.85392.16%净利润-1,739,415.262,807,297.868.25%4,546,713.12-261.39%加:年初未分配利润-0.00%--其他转入0.00%--可供分配的利润--0.00%--减:提取法定盈余公积0.00%--提取法定公益金0.00%--提取职工奖励及福利基金0.00%--提取储备基金0.00%--提取企业发展基金0.00%--利润归还投资0.00%--可供投资者分配的利润0.00%--减:应付优先股股利0.00%--提取任意盈余公积0.00%--应付普通股股利0.00%--0.00%--未分配利润--0.00%--结算期:年月日页次:日期:年月日日期:年月日客户名称:项目:分析报表(损益)8.25%重大或异常项目编制单位:合并OKOK项目本年数本年数OK一,商品销售收入30,128,642.2934,011,935.88OK减:销售折扣与折让OK商品销售收入净额30,128,642.2934,011,935.88OK减:商品销售成本23,057,316.6321,024,131.08OK毛利润7,071,325.6612,987,804.80关注减:产品销售费用1,083,112.972,369,839.84关注商品销售税金及附加269,390.38386,635.64OK关注OK二,商品销售利润5,718,822.3110,231,329.32OK加:代购代销收入关注OKOK三,主营业务利润5,718,822.3110,231,329.32关注加:其他业务利润关注减:管理费用7,400,719.747,502,834.23OK其中:上交上级管理费话关注财务费用45,659.48-344,067.70OK其中:利息支出关注汇兑损失关注关注四,营业利润-1,727,556.913,072,562.79OK加:投资收益OK补贴收入OK营业外收入97,990.56287,900.00OK减:营业外支出41,620.0051,363.31OK加:以前年度损益调整-166,002.86OKOKOK五,利润总额-1,671,186.353,143,096.62OK减:所得税68,228.91335,798.76OKOKOK六,净利润-1,739,415.262,807,297.86OKOK企业负责人:OK页次:日期:年月日日期:年月日索引号:Z10-4编制人:复核人:一、指标说明1、企业经营成果指标:权益净利率(净资产收益率)2、指标解析:(1)权益净利率=销售净利率*总资产周转率*权益乘数(2)销售净利率=净利润/主营业务收入(3)总资产周转率=主营业务收入/期末总资产(4)权益乘数=期

1 / 8
下载文档,编辑使用

©2015-2020 m.777doc.com 三七文档.

备案号:鲁ICP备2024069028号-1 客服联系 QQ:2149211541

×
保存成功