Submit Case 1 Attached Files Conex (12.133 KB) Complete the minkcase in the attached spreadsheet The beginning numbers are typed into the attached spreadsheet for your convenience The instructions are as follows jadian industies has the following account balance is of December 2010 corded in the The Fim dividend payout 2 and that the stock price on December 11, 2009 at 2.19 and on Dec. 2010 was 542 1 Construct an income statement and a balance sheet for Dec 31, 2010, and 2 determine the firm's free cash low 3 Calculate the financial ratios Perform a DuPont analysis and compare the firm to the industry ratio shilight several financial strengths and weaknesse 42,000,000 63% Sales COGS Portion of COGS that represts purchases Selling and G&A Depreciation Interest Rate Cash Balance Accounts Rec Marketable securities Inventory Fixed Assets Accum Dep through 2009 Accounts Payable Notes payable Accruals LT Bonds outstanding Preferred Stock at par Retained earnings through 2009 Common Stock at par paid-in capital in excess Tax rate Dividend payout ratio Dividends on prefered Number of shares common stock Terms of trade AR Terms of trade AP 75% 1,621,000 800,000 10% 3,689,000 5,423,000 1,836,000 4,118,000 14,811,000 5,160,000 3,136,000 706,000 500,000 3,046,000 100,000 1,628,819 4,000,000 4,500,000 34 25 8. 1,000,000 35 days 45 days YE 2010 ISBS 2009 Industry Ratios Calib -11 - AAE 29 Wrap Text General BI- AED 12Merge Center - $ - % Night Nute NOTICE Excel tot been activated to reping Excel without interruption activite before Saturday, August 2012021 Conditional Formatas Cell Formatting Table Styles Activate 1 M D H G 2,146,000 3578155 27004709 1157242 sales less COGS Gross profit tre Op expenses selling GA Depreciation CA Intent ASSETS Cash Marketable Securities Accounts Receivable Intres Current Food Lee Not fixed Total 1000000 700000 150,000 000 LOGO Liabilities and Equity Accounts Payable Notes Proble Acom Total Current det Stock Comen stock at your Paldia in Retined To 1,119 157.000 27.500 210,000 10.559 11.379,000 5.160,000 5,719,000 1,254,319 10 DOO 75000 Not Income less Dividend paid to vie 321 636925 157534 2009 2010 Liquidity Current ratio Quick ratio 2.89 1.42 3.26 2.19 Acitivty Inventory Turnover Avg collection Avg payment fixes asset turnover total asset turnover 6.71 35.12 50.73 4.32 2.14 6.59 36.17 49.63 4.76 2.33 Debt debt ratio assets-to equity debt-to equity times interest earned 41.93% 39.36% 165.82% 163.13% 31.26% 30.23% 15.72 16.81 Profitability Gross margin Operating profit margin net profit margin earnings per share Return on total assets Return on equity 22.19% 23.74% 19.32% 20.89% 15.11% 17.97% $ 4.36 $ 4.58 32.34% 41.87% 53.63% 68.30% Market price/earnings market/book 5.41 4.19 5.97 4.32 2 3