Excel動態(tài)杜邦分析

,3,,,,,,,,,,,,,,,,,,,,,,,,,,

1月,2月,,,,,,,,權(quán)益凈利率,,,,,,,,,,,,標(biāo)簽,權(quán)益凈利率,,,標(biāo)簽,凈利潤,

B,C,,,,,,2月,,4.27%,,,,1.67,,,,,,,,0%,4.27%,115,,0,277.8,250

,,,,,,,1月,,2.60%,,,,,,,,,,,,,0%,0,,,0,0

指標(biāo),行號,,,,,,,,,,,,,,,,,,,,1%,10%,245,,30,300,110

營業(yè)成本,$3,,,,,,資產(chǎn)凈利率,,,,,,權(quán)益乘數(shù),,,,,,,,,,,,,,

銷售費(fèi)用,$8,,,,,,0.85%,,0.07,,,,5.00,,1.67,,,,,,2%,,,,60,,

管理費(fèi)用,$9,,,,,,0.78%,,,,償債能力,,3.33,,,,,,,,,,,,,,

其他費(fèi)用,$29,,,,,,,,,,,,,,,,,,,,3%,,,,90,,

現(xiàn)金有價(jià)證券,$33,,,,,,銷售凈利率,,,,,,資產(chǎn)周轉(zhuǎn)率,,,,,,,,,,,,,,

應(yīng)收賬款,$34,,,,,,5.50%,,0.50,,,,0.16,,0.00,,,,,,4%,,,,120,,

存貨,$35,,,,盈利能力,,5.00%,,,,營運(yùn)能力,,0.16,,,,,,,,,,,,,,

銷售收入,$2,,,,,,,,,,,,,,,,,,,,5%,,,,150,,

其他利潤,$30,,,,凈利潤,,,,銷售收入,,銷售收入,,,,資產(chǎn)總額,,貨幣單位：萬元,,,,,,,,,,

所得稅,$31,,,,277.8,,,,"5,050.0",,"5,050.0",,,,"32,500.0",,,,,,6%,,,,180,,

流動資產(chǎn),$32,,,,250.0,,,,"5,000.0",,"5,000.0",,,,"32,000.0",,,,,,,,,,,,

資產(chǎn)總額,$10,,,,,,,,,,,,,,,,,,,,7%,,,,210,,

資產(chǎn)負(fù)債率,$26,,銷售收入,,全部成本,,其他利潤,,所得稅,,費(fèi)用率,,長期資產(chǎn),,,,流動資產(chǎn),,,,,,,,,,

,,,"5,050.0",,"4,772.3",,0.0,,0.0,,7.50%,,"13,000.0",,,,"19,500.0",,,,8%,,,,240,,

,,,"5,000.0",,"4,750.0",,0.0,,0.0,,7.00%,,"14,000.0",,,,"18,000.0",,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,9%,,,,270,,

,,,營業(yè)成本,,銷售費(fèi)用,,管理費(fèi)用,,其他費(fèi)用,,毛利率,,現(xiàn)金有價(jià)證券,,應(yīng)收賬款,,存貨,,其他流動資產(chǎn),,,,,,,,

,,,"4,393.5",,277.8,,101.0,,0.0,,13.00%,,"8,500.0",,"3,500.0",,"7,500.0",,0.0,,10%,,,,300,,

,,,"4,400.0",,250.0,,100.0,,0.0,,12.00%,,"8,000.0",,"3,000.0",,"7,000.0",,0.0,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,4.27%,,,,277.8,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,本文檔僅作為學(xué)習(xí)之用途，轉(zhuǎn)載請注明出處。,,,,,,,