Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

what should I recommend the company for the future within 50 to 75 words based on the ratios they have XIA 5 = ibm-balance-sheet-annual -

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedwhat should I recommend the company for the future within 50 to 75 words based on the ratios they have

XIA 5 = ibm-balance-sheet-annual - Excel ? - X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW > AutoSum - Calibri 12 Wrap Text General P. Z % Cut EL Copy Format Painter A H Insert Delete Format Fill- Paste BI U - A E 9 Merge & Center - $ % 4.0 .00 00 0 Conditional Format as Cell Formatting Table Styles Styles Clear - Sort & Find & Filter Select- Editing Clipboard Font Alignment Number Cells G72 : X fx A B D E F G H 1 J K L M N 0 P Q R S 1 2017 - 2018 11604 12234 - 618 608 - 2019 8313 696 9009 -0.2629 32507 1619 -4715 12222 2019 77147 -0.0307 40659 36488 20604 5989 -1616 2017 79139 -0.0098 42196 36943 19680 12842 - 0.506 - 2018 79591 0.0057 42655 36936 19366 5379 -0.0483 39711 41180 - 1583 - 5590 1682 -4469 -5870 - 126 -341 24977 24871 38420 15006 49146 10792 2386 49735 - 11116 24929 12014 2 BALANCE SHEET 3 Year 4 Cash & Equivalents 5 Short-Term Investme 6 Cash & Cash Equivale 7 Cash Growth 8 Receivables 9 Inventory 10 Other Current Assets 11 Total Current Assets 12 Property, Plant & Equ 13 Long-Term Investmer 14 Goodwill and Intangil 15 Other Long-Term Ass 16 Total Long-Term Asse 17 Total Assets 18 Accounts Payable 19 Deferred Revenue 20 Current Debt 21 Other Current Liabilit 22 Total Current Liabiliti 23 Long-Term Debt 11511 INCOME STATEMENT Year Revenue Revenue Growth Cost of Revenue Gross Profit Selling, General & Ad Research & Developn Other Operating Expe Operating Expenses Operating Income Interest Expense / Inc Other Expense / Incoi Pretax Income Income Tax Net Income Shares Outstanding (! Shares Outstanding (! Shares Change EPS (Basic) EPS (Diluted) EPS Growth 12065 723 615 2074 73457 23229 -5 1344 5 10162 39352 21706 4 2783 40530 21192 75621 11395 731 11347 2619 8728 912 5642 5753 125356 9431 74236 123382 6558 14610 6451 113766 152186 4896 15877 10177 6751 37701 887 933 937 15298 893 10207 6987 -0.0236 6852 8627 -0.0272 10.63 10.56 916 -0.0223 9.57 9.52 0.5505 6.17 6.14 38227 37363 57981 39837 -0.504 35605 Bacan 0.1092 49 Sheet JS READY + 93% Type here to search e E ENG 8:23 PM 9/13/2020 XI 5 = ibm-balance-sheet-annual - Excel ? - X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW A > AutoSum - Calibri 12 Wrap Text General * Cut ED Copy Format Painter P. Z FA H Insert Delete Format Fill- Paste BIU A E 9 Merge & Center $ % 4.0 .00 00 0 Conditional Format as Cell Formatting Table Styles Styles Clear - Sort & Find & Filter - Select Editing Clipboard Font Alignment Number 5 Cells G72 : X fx D E F G J K L M N 0 P Q R S 2074 2783 1344 723 615 2386 39352 73457 -5 4 5 10162 23229 40530 21192 75621 21706 11395 5642 113766 74236 731 9431 152186 123382 6558 5753 11347 2619 8728 912 916 125356 6451 887 933 4896 15877 10177 893 937 14610 10207 15298 6987 -0.0272 -0.0223 -0.0236 6751 6852 10.63 9.57 6.17 38227 8627 37363 39837 9.52 37701 57981 6.14 -0.504 B 13 Long-Term Investmer 14 Goodwill and Intangil 15 Other Long-Term Ass 16 Total Long-Term Asse 17 Total Assets 18 Accounts Payable 19 Deferred Revenue 20 Current Debt 21 Other Current Liabilit 22 Total Current Liabiliti 23 Long-Term Debt 24 Other Long-Term Liab 25 Total Long-Term Liabi 26 Total Liabilities 27 Total Debt 28 Debt Growth 29 Common Stock 30 Retained Earnings 31 Comprehensive Incor 32 Shareholders' Equity 33 Total Liabilities and E 34 Net Cash / Debt 35 Net Cash / Debt Grow 35605 32620 68225 H 1 I Interest Expense / Inc Other Expense / Incoi Pretax Income Income Tax Net Income Shares Outstanding ! Shares Outstanding (! Shares Change EPS (Basic) EPS (Diluted) EPS Growth Free Cash Flow Per St Dividend Per Share Dividend Growth Gross Margin Operating Margin Profit Margin FCF Margin Effective Tax Rate EBITDA EBITDA Margin EBIT EBIT Margin 0.5505 12.64 30431 10.56 0.1092 13.98 6.43 0.0354 70268 35520 93501 131202 68158 6.21 106452 0.0525 45812 0.464 0.473 0.149 0.152 0.4878 -113516 -0.0216 -112920 107631 46824 0.1104 -108940 153126 -26592 14.38 5.9 0.0727 0.467 0.152 0.073 0.169 0.495 16551 0.209 0.122 162954 0.161 159206 -29490 -28597 0.072 17594 125225 17565 0.228 20841 152043 -59149 0.7609 16796 123248 -33590 -0.0115 0.11 0.145 0.231 16550 0.208 12070 0.152 -33982 11506 0.149 0.0101 12010 0.152 AC41 Sheet JS READY + 93% Type here to search e 1 ENG 8:23 PM 9/13/2020 XI 5 = ibm-balance-sheet-annual - Excel ? - X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW A > AutoSum - Calibri 12 AA Wrap Text General P. Z * Cut Be Copy Format Painter FA H Insert Delete Format Fill- Paste BIU A E 9 Merge & Center $ - % 4.0 .00 00 0 Conditional Format as Cell Formatting Table Styles Styles Clear - Sort & Find & Filter Select- Editing Clipboard Font Alignment Number Cells G72 : X fx E F G K L M N 0 P Q R S 719 23.49 A B B 37 Working Capital 38 Book Value Per Share 39 D 10919 18.42 H I J market price per shar $121.46 $113.03 $154.81 12372 18.86 40 2019 2018 2017 1.02 1.29 1.33 0.976 1.242 1.289 0.119 0.239 0.115 41 42 Liquididty ratios formula 43 Current ratio CA/CL 44 Quick ratio (CA-inventroy)/CL 45 Cash Ratio cash/CL 46 47 Lon-term solvency ratios 48 DR 49 D/E 50 TIE (Times Interest earned ratio 51 CCR (Cash Coverage ratio) 52 53 Asset utilization Ratios 54 ITO (inventory turnover) 55 DSI (days of sales in Inventory 56 Receivable TO 57 DSO 58 APTO Accounts payables Turnover 59 DCS (days of credit from suppliers ) co CATC Sheet JS 1.360 1.468 1.430 6.491 5.739 5.796 8.56 16.69 19.53 4.052827381 10.4979253 12.1447154 25.360 26.656 25.114 14.534 14.393 2.004 2.373 182.112 1.074 153.798 8.305 43.952 co 13.546 1.922 356.211 1.025 356.211 339.808 AT READY + 93% Type here to search e ENG 8:23 PM 9/13/2020 XI 5 = ibm-balance-sheet-annual - Excel ? - X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW A > AutoSum - Calibri 12 Wrap Text General * Cut ED Copy Format Painter P. Z FA H Insert Delete Format Fill- Paste BIU A 9 Merge & Center $ % 4.0 .00 00 0 Conditional Format as Cell Formatting Table Styles Styles Clear - Sort & Find & Filter Select- Editing Clipboard Font Alignment Number Cells G72 : Xfx D F G H 1 K L M N o P Q R S E 14.534 2.373 153.798 8.305 B 55 DSI (days of sales in Inventory 56 Receivable TO 57 DSO 58 APTO Accounts payables Turnover 59 DCS (days of credit from suppliers ) 60 FATO 61 TATO 62 63 Profitability ratios 64 PM 14.393 2.004 182.112 1.074 339.808 1.072 0.645 13.546 1.922 356.211 1.025 356.211 1.047 0.631 43.952 0.678 0.507 0.110 0.073 0.122 0.062 0.071 0.046 65 ROA 66 ROE 0.083 0.077 0.053 67 68 Market Value ratios 69 M/B 70 PER 0.949 $0.09 0.913 $0.08 1.326 $0.04 71 ptos 72 $1.40 1.29516352 1.82511442 73 74 75 76 77 Sheet JS READY E + 93% Type here to search e 1 ENG 8:23 PM 9/13/2020

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting Reporting and Analysis

Authors: James M. Wahlen, Jefferson P. Jones, Donald Pagach

2nd edition

9781305727557, 1285453824, 9781337116619, 130572755X, 978-1285453828

Students also viewed these Finance questions