杜邦分析表模板-经典版本
合集下载
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
指标名称 一、获利能力分析 1、长期资本报酬率 2、资本金收益率 3、股东权益报酬率 4、总资产利润率 5、毛利率 6、营业利润率 7、销售净利率 8、成本费用利润率 二、短期偿债能力分析 1、流动比率 2、速动比率 3、现金比率 三、长期偿债能力分析 1、资产负债比率 2、产权比率 3、有形净值债务比率 4、利息保障倍数 5、营运资金长期负债比率 6、长期负债比率 7、融资结构弹性比率 四、资产管理效果分析 1、总资产周转率 2、固定资产周转率 3、流动资产周转率 4、应收账款周转率 5、存货周转率 6、营业周期 五、现金流量分析 1、经营活动净现金比率1 2、经营活动净现金比率2 3、净利润现金保证比率 4、销售收入现金回收比率
152.1% 51,281,216.28 115.8% 41,080,102.07 1.3% 509,669.90 51.2% 105.0% 176.6% 434.8% 0.0% 0.0% 54.4% 52.0% 2247.2% 56.4% 223.0% 236.6% 313.58 8.7% 8.7% 186.9% 8.6% 31,363,560.64 31,363,560.64 31,363,560.64 3,650,250.40 19,917,655.64 0.00 34,613,837.61 40,661,764.32 40,661,764.32 33,969,413.03 35,671,239.78 33,969,413.03
财务比率表
指标说明 （利润总额+利息费用）/（长期负债平均值+所有者权益平均值） 净利润/资本金总额 净利润/股东权益平均值 （利润总额+利息支出净额）/平均资产总值 毛利润/销售收入 （营业利润+利息支出净额）/销售收入 净利润/销售收入 营业利润/（销售成本+销售费用+管理费用+财务费用） 流动资产/流动负债 速动资产/流动负债 （货币资金+有价证券）/流动负债 负债总额/资产总额 负债总额/所有者权益总额 负债总额/（所有者权益-无形资产-递延资产） （税前利润+利息费用）/利息费用 （流动资产-流动负债）/长期负债 长期负债/负债总额 弹性融资/融资总量 产品销售收入净额/平均资产总额 产品销售收入净额/固定资产平均净值 产品销售成本净额/流动资产平均占用额 赊销收入净额/应收账款平均余额 销货成本/存货平均余额 应收账款周转天数+存货周转天数 经营活动净现金流量/流动负债 经营活动净现金流量/负债总额 经营活动净现金流量/净利润 经营活动净现金流量/销售收入 分子数值 37,700,052.63 1,632,512.79 1,632,512.79 2,495,462.57 5,507,007.49 2,549,391.57 1,632,512.79 2,082,741.85 53,470,142.89 40,719,466.05 459,031.68 35,152,927.17 35,152,927.17 35,152,927.17 2,028,812.85 18,317,215.72 0.00 37,322,224.74 35,671,239.78 35,671,239.78 30,164,232.29 35,671,239.78 30,164,232.29
3,051,644.93 3,051,644.93 3,051,644.93 3,051,644.93
比率表
分母数值 33,480,687.39 30,000,000.00 33,480,687.39 68,633,614.56 35,671,239.78 35,671,239.78 35,671,239.78 32,443,581.25 35,152,927.17 35,152,927.17 35,152,927.17 68,633,614.56 33,480,687.39 19,904,573.23 466,649.72 0.00 35,152,927.17 68,633,614.56 68,633,614.56 1,587,357.51 53,470,142.89 15,993,250.07 12,750,676.84 112.6% 5.4% 4.9% 3.6% 15.4% 7.1% 4.6% 6.4% 分子数值 3,650,250.40 2,445,667.77 2,445,667.77 3,884,465.66 6,692,351.29 3,984,405.77 2,445,667.77 2,082,741.85 分母数值 35,452,141.81 30,000,000.00 35,452,141.81 66,815,702.45 40,661,764.32 40,661,764.32 40,661,764.32 35,557,537.07 31,363,560.64 31,363,560.64 31,363,560.64 66,815,702.45 35,452,141.81 22,148,688.57 234,215.26 0.00 31,363,560.64 66,815,702.45 67,724,658.51 1,675,358.74 52,375,679.59 15,113,584.66 11,475,034.53 本年数 10.3% 8.2% 6.9% 5.8% 16.5% 9.8% 6.0% 5.9% 163.5% 131.0% 1.6% 46.9% 88.5% 141.6% 1558.5% 0.0% 0.0% 51.8% 60.0% 2427.0% 64.9% 236.0% 296.0% 274 6.4% 6.4% 82.7% 5.0% 增减 -90.9% 49.8% 41.5% 59.9% 6.6% 37.1% 31.4% -8.8% 7.5% 13.1% 24.4% -8.4% -15.7% -19.8% 258.5% 0.0% 0.0% -4.7% 15.5% 8.0% 15.0% 5.8% 25.1% -12.6% -25.8% -25.8% -55.8% -41.9%
152.1% 51,281,216.28 115.8% 41,080,102.07 1.3% 509,669.90 51.2% 105.0% 176.6% 434.8% 0.0% 0.0% 54.4% 52.0% 2247.2% 56.4% 223.0% 236.6% 313.58 8.7% 8.7% 186.9% 8.6% 31,363,560.64 31,363,560.64 31,363,560.64 3,650,250.40 19,917,655.64 0.00 34,613,837.61 40,661,764.32 40,661,764.32 33,969,413.03 35,671,239.78 33,969,413.03
财务比率表
指标说明 （利润总额+利息费用）/（长期负债平均值+所有者权益平均值） 净利润/资本金总额 净利润/股东权益平均值 （利润总额+利息支出净额）/平均资产总值 毛利润/销售收入 （营业利润+利息支出净额）/销售收入 净利润/销售收入 营业利润/（销售成本+销售费用+管理费用+财务费用） 流动资产/流动负债 速动资产/流动负债 （货币资金+有价证券）/流动负债 负债总额/资产总额 负债总额/所有者权益总额 负债总额/（所有者权益-无形资产-递延资产） （税前利润+利息费用）/利息费用 （流动资产-流动负债）/长期负债 长期负债/负债总额 弹性融资/融资总量 产品销售收入净额/平均资产总额 产品销售收入净额/固定资产平均净值 产品销售成本净额/流动资产平均占用额 赊销收入净额/应收账款平均余额 销货成本/存货平均余额 应收账款周转天数+存货周转天数 经营活动净现金流量/流动负债 经营活动净现金流量/负债总额 经营活动净现金流量/净利润 经营活动净现金流量/销售收入 分子数值 37,700,052.63 1,632,512.79 1,632,512.79 2,495,462.57 5,507,007.49 2,549,391.57 1,632,512.79 2,082,741.85 53,470,142.89 40,719,466.05 459,031.68 35,152,927.17 35,152,927.17 35,152,927.17 2,028,812.85 18,317,215.72 0.00 37,322,224.74 35,671,239.78 35,671,239.78 30,164,232.29 35,671,239.78 30,164,232.29
3,051,644.93 3,051,644.93 3,051,644.93 3,051,644.93
比率表
分母数值 33,480,687.39 30,000,000.00 33,480,687.39 68,633,614.56 35,671,239.78 35,671,239.78 35,671,239.78 32,443,581.25 35,152,927.17 35,152,927.17 35,152,927.17 68,633,614.56 33,480,687.39 19,904,573.23 466,649.72 0.00 35,152,927.17 68,633,614.56 68,633,614.56 1,587,357.51 53,470,142.89 15,993,250.07 12,750,676.84 112.6% 5.4% 4.9% 3.6% 15.4% 7.1% 4.6% 6.4% 分子数值 3,650,250.40 2,445,667.77 2,445,667.77 3,884,465.66 6,692,351.29 3,984,405.77 2,445,667.77 2,082,741.85 分母数值 35,452,141.81 30,000,000.00 35,452,141.81 66,815,702.45 40,661,764.32 40,661,764.32 40,661,764.32 35,557,537.07 31,363,560.64 31,363,560.64 31,363,560.64 66,815,702.45 35,452,141.81 22,148,688.57 234,215.26 0.00 31,363,560.64 66,815,702.45 67,724,658.51 1,675,358.74 52,375,679.59 15,113,584.66 11,475,034.53 本年数 10.3% 8.2% 6.9% 5.8% 16.5% 9.8% 6.0% 5.9% 163.5% 131.0% 1.6% 46.9% 88.5% 141.6% 1558.5% 0.0% 0.0% 51.8% 60.0% 2427.0% 64.9% 236.0% 296.0% 274 6.4% 6.4% 82.7% 5.0% 增减 -90.9% 49.8% 41.5% 59.9% 6.6% 37.1% 31.4% -8.8% 7.5% 13.1% 24.4% -8.4% -15.7% -19.8% 258.5% 0.0% 0.0% -4.7% 15.5% 8.0% 15.0% 5.8% 25.1% -12.6% -25.8% -25.8% -55.8% -41.9%