Looking for some help with these financial ratios. Specifically, the formulas to type in that correlate with each cell in the key financials. Hope that
Looking for some help with these financial ratios. Specifically, the formulas to type in that correlate with each cell in the key financials. Hope that makes sense, thank you! For example; like I did with the current ratio- I typed a formula and selected cells that resulted in the answer. I could then drag that across to apply to all the following cells.
You're right, I accidentally cropped out the cell reference numbers/letters. I am looking for the cell formulas if possible, thanks again!
Updated image should be attached!
Financials: Cash Recievables Inventory ppE Depreciation Assets (total) 1 Accounts payable 2 LTD 3 Liabilities Stockholders equity 5 Sales (net) 5 COGS Selling, general, and admin expenses 3 incomes taxes incomes before extrordinary items net income 1 EPS before extrordinary items 2 EPS excluding extrordinary items 2012 2013 2014 2015 2016 29,129.00 40,546.00 25,077.00 41,601.00 67,155.00 18,692.00 20,641.00 27,219.00 30,343.00 29,999.00 791.00 1,764.00 2,111.00 2,349.00 2,132.00 15,245.00 16,597.00 20,624.00 22,471.00 27,010.00 6,435.00 11,922.00 18,391.00 26,786.00 34,235.00 176,064.00 207,000.00 231,839.00 290,479.00 321,686.00 21,175.00 22,367.00 30,196.00 35,490.00 37,294.00 0.00 16,960.00 28,987.00 53,463.00 75,427.00 57,854.00 83,451.00 120,292.00 171,124.00 193,437.00 118,210.00 123,549.00 111,547.00 119,355.00 128,249.00 156,508.00 170,910.00 182,795.00 233,715.00 215,091.00 84,641.00 99,849.00 104,312.00 129,589.00 121,576.00 13,421.00 15,305.00 18,034.00 22,396.00 24,239.00 14,030.00 13,118.00 13,973.00 19,121.00 15,685.00 41,733.00 37,037.00 39,510.00 53,394.00 45,687.00 41,733.00 37,037.00 39,510.00 53,394.00 45,867.00 44.64 40.03 6.49 9.28 8.35 44.15 39.75 6.45 9.22 8.31 UI 2012 2013 2014 2015 2016 Ratios: 5 EPS 7 ROA 3 ROE GPM 1 NPM 2 Current Ratio 3 Quick Ratio Leverage Debt-to-equity 5 L-T Debt Ratio -Asset to equity 3 Fixed asset turnover 3 Asset turnover 2.30 2.81 1.80 2.09 2.66 A B C D E F G 1 2 3 4 Financials: 5 Cash 6 Recievables 7 Inventory 8 ppE 9 Depreciation 10 Assets (total) 11 Accounts payable 12 LTD 13 Liabilities 14 Stockholders equity 15 Sales (net) 16 COGS 17 Selling, general, and admin expenses 18 incomes taxes 19 incomes before extrordinary items 20 net income 21 EPS before extrordinary items 22 EPS excluding extrordinary items 23 24 25 Ratios: 26 EPS 27 ROA 28 ROE 29 GPM 30 OPM 31 NPM 32 Current Ratio 33 Quick Ratio 34 Leverage 35 Debt-to-equity 36 L-T Debt Ratio 37 Asset to equity 38 Fixed asset turnover 39 Asset turnover 40 2012 2013 2014 2015 2016 29,129.00 40,546.00 25,077.00 41,601.00 67,155.00 18,692.00 20,641.00 27,219.00 30,343.00 29,999.00 791.00 1,764.00 2,111.00 2,349.00 2,132.00 15,245.00 16,597.00 20,624.00 22,471.00 27,010.00 6,435.00 11,922.00 18,391.00 26,786.00 34,235.00 176,064.00 207,000.00 231,839.00 290,479.00 321,686.00 21,175.00 22,367.00 30,196.00 35,490.00 37,294.00 0.00 16,960.00 28,987.00 53,463.00 75,427.00 57,854.00 83,451.00 120,292.00 171,124.00 193,437.00 118,210.00 123,549.00 111,547.00 119,355.00 128,249.00 156,508.00 170,910.00 182,795.00 233,715.00 215,091.00 84,641.00 99,849.00 104,312.00 129,589.00 121,576.00 13,421.00 15,305.00 18,034.00 22,396.00 24,239.00 14,030.00 13,118.00 13,973.00 19,121.00 15,685.00 41,733.00 37,037.00 39,510.00 53,394.00 45,687.00 41,733.00 37,037.00 39,510.00 53,394.00 45,867.00 44.64 40.03 6.49 9.28 8.35 44.15 39.75 6.45 9.22 8.31 2012 2013 2014 2015 2016 2.30 2.81 1.80 2.09 2.66
