analysis for finance class

profilefislal
fin.xlsx

Sheet1

Net Income Sales Cash Inventory Current Assets Total Assests Current Liabilities Total Eqilty Debt
2013 $ 13,057,000 $ 113,245,000 $ 88,555,000 $ 17,325,000 $ 422,303,000 $ 656,560,000 $ 206,572,000 $ 130,566,000 $ 329,679,000
2014 $ 15,233,000 $ 117,184,000 $ 70,025,000 $ 17,689,000 $ 166,162,000 $ 654,954,000 $ 158,310,000 $ 128,159,000 $ 261,424,000
2015 $ (6,126,000) $ 117,386,000 $ 70,483,000 $ 22,515,000 $ 170,827,000 $ 492,692,000 $ 148,682,000 $ 98,274,000 $ 198,276,000
DuPont Decomposition Liquidity
Return on Equity
NI/Ecuity NI/Sales Sales/Assets Assets/Equity Current ratio Quick Ratio Cash Ratio Check
2013 10.00% 12% 0.17 5.03 2.04 1.96 0.43 10.00%
2014 11.89% 13% 0.18 5.11 1.05 0.94 0.44 11.89%
2015 -6.23% -5% 0.24 5.01 1.15 1.00 0.47 -6.23%