1. Calculate Revenue Growth for XYZ over the last 4 years? In one sentence, would you consider this a growth company & why or why not?
2. Calculate the net margin for XYZ for the most recent year. What does this number tell us? If a competitor firm has a net margin is 31%. Is XYZ doing better or worse than the competitor?
l
1. Calculate Revenue Growth for XYZ over the last 4 years? In one sentence, would you consider this a growth company & why or why not?
2. Calculate the net margin for XYZ for the most recent year. What does this number tell us? If a competitor firm has a net margin is 31%. Is XYZ doing better or worse than the competitor?
XYZ, Inc. 2019 46,840.00 14.112.00 32.728.00 10.615.00 9.872.00 2018 42,294.00 13,509.00 28,785.00 10,102.00 9.752.00 0 19.854.00 8.931.00 343 -772 -429 20.487.00 Income Statement (all data in Millions) Year 2016 2017 Revenue 39.807.00 40.122.00 Cost of Goods Sold 14,030.00 12.912.00 Gross Profit 25.777.00 27.210.00 Selling. General, & Admin. Expense 10.017.00 10.074.00 Research & Development 10.261.00 10.339.00 Other Operating Expense 0 0 Total Operating Expense 20.278.00 20,413.00 Operating Income 5,499.00 6,797.00 Interest Income 328 385 Interest Expense -693 -754 Net Interest Income -365 -369 Other Income (Expense) -475 93 Pre-Tax Income 4,659.00 6.521.00 Tax Provision -718 -4,103.00 Tax Rate % 15.41 62.92 Net Income (Continuing Operations) 3.941.00 2.418.00 Net Income (Discontinued Operations) 0 0 Other Income (Minority Interest) -21 -24 Net Income 3.920.00 2,394.00 12 241.00 274 -893 -619 -158 199 8.701.00 -2,508.00 28.82 6,193.00 ol 11.464.00 -1.687.00 14.721 9.777.00 0 27 60 9,843.00 6.220.00 Shares Outstanding 2.679.00 2.580.00 2.787.00 2.748.00 Balance Sheet (all data in Millions) 2016 6,515.00 Year Cash And Cash Equivalents 2017 6.092.00 2018 7,965.00 2019 9.676.00 7,826.00 14,341.00 2.00/00 774 2,402.00 8.498.00 6.873.00 899 8.86.00 7.071.00 0 7,018.00 10,450.00 6,778.00 0 al 0 o 0 0 o 0 o 0 7,018.00 6,873.00 0 7.071.00 0 6,778.00 o 0 0 0 0 0 0 o 0 0 o 4,866.00 4,866.00 Marketable Securities Cash, Cash Equivalents, Marketable Securities Accounts Receivable Notes Receivable Loans Receivable Other Current Receivables Total Receivables Inventories, Raw Materials & Components Inventories. Work in Process Inventories, Inventories Adjustments Inventories, Finished Goods Inventories, Other Total Inventories Other Current Assets Total Current Assets Investments And Advances Land And improvements Buildings And Improvements Machinery, Furniture, Equipment Construction in Progress Other Gross PPE Gross Property. Plant and Equipment Accumulated Depreciation Property, plant and Equipment Intangible Assets Goodwill other Long Term Assets Total Long-Term Assets Total Assets Accounts Payable Total Tax Payable Other Current Payables Current Accrued Expense 4.389.00 30,614.00 11,416.00 412 11,439.00 14.053.00 1,871.00 0 27.775.00 -15,749.00 12.026.00 35,467.00 18.162.00 5.854.00 64,763.00 95,377.00 2.807.00 2.239.00 1.316.00 10.274.00 0 0 O 5,096.00 5.440.00 5.978.00 5,096.00 5.440.00 5.978.00 4,299.00 4.500.00 4,277.00 24,766.00 25,875.00 27,483.00 12,125.00 6.233.00 1.469.00 365 333 343 11,726.00 11.486.00 11,989.00 14,649.00 14,441.00 15,394.00 2,301.00 3.355.00 5,013.00 o o Q 29,041.00 29.615.00 32,739.00 -16,602.00 -16,324.00 -17.686.00 12,439.00 13.291.00 15.033.00 32,467.00 31.357.00 33.621.00 18.284.00 18.253.00 19,425.00 6,075.00 5,881.00 6.771.00 63, 106.00 56.762.00 56,914.00 87,872.00 82,637.00 84,397.00 3,102.00 3.318.00 3.738.00 708 1.971.00 736 1.320.00 1.458.00 1.587.00 10.427.00 10.151.00 12.549.00 22.206.00 19.806.00 22.220.00 22.736.00 o 19.806.00 0 O 22,736.00 o 1.702.00 12.041.00 Total Current Liabilities Long-Term Debt Long-Term Capital Lease Obligation Long-Term Debt & Capital Lease Obligation PensionAnd Retirement Benefit NonCurrent Deferred Liabilities Other Long-Term Liabilities Total Long-Term Liabilities Total Liabilities Common Stock Preferred Stock Retained Earnings Accumulated other comprehensive income (loss) Additional Paid-In Capital Treasury Stock Other Stockholders Equity Total Stockholders Equity Minority interest Total Equity 17,204.00 18.6 34.00 24, 274.00 21,353.00 o o 24,274.00 21.333.00 0 O 3.077.00 2.219.00 8.514.00 11,117.00 37.865.00 34,689.00 35,069.00 53,303.00 1.788.00 1.788.00 o 0 44. 133.00 41.350.00 -5.226.00 -4.910.00 39.939.00 39.902.00 -40.546.00-43.794.00 0 o 40.088.00 34.336.00 220 233 40,308.00 34,569.00 33,549.00 55,735.00 1.788.00 o 1,470.00 11,970.00 36.176.00 58,396.00 1.788.00 46.602.00 -8.193.00 39,660.00 -35.950.00 42,579.00 -5.545.00 38,808.00 -30,929.00 0 26.701.00 181 26,882.00 25.907.00 94 26.001.00 2018 6.193.00 4,319.00 - 418 2019 9.777.00 3,632.00 294 -SOB -901 0 716 -1.584.00 -269 Statement of Cashflow (all data in Millions) Year 2016 2017 Net Income From Continuing Operations 3.941.00 2.418.00 Depreciation, Depletion and Amortization 3.471.00 4.676.00 Change In Receivables -6191 297 Change In Inventory 200 -145 Change in Prepaid Assets 0 0 Change in Payables And Accrued Expense -1.616.00 -3.959.00 Change in Other Working Capital -572 -1.210.00 Change in Working Capital -2.601.00 -3.017.00 Deferred Tax -1.521.00 -2.621.00 Stock Based Compensation 300 312 Asset Impairment Charge 3.948.00 646 Cash from Discontinued Operating Activities 0 Cash Flow from Others 838 6.037.00 Cash Flow from Operations 10,376.00 6,451.00 Purchase of Property, plant. Equipment -1.614.00 -1.888.00 Sale of Property. Plant. Equipment 0 Purchase of Business 780 -396 -940 -1.553.00 309 -2.062.00 -556 417 1.040.00 348 296 0 1.628.00 10,922.00 -2.615.00 1.177.00 13,440.00 -3.473.00 -431 -4.954,00 ol o 0 ol 838 10.376.00 cash from Discontinued Operating Activities Cash Flow from Others Cash Flow from Operations Purchase of Property, plant, Equipment Sale of Property, plant, Equipment Purchase of Business Sale of Business -1.614.00 6.037.00 6.451.00 -1.888.00 0 1.628.00 10,922.00 2,615.00 0 1,177.00 13,440.00 -3.473.00 o ol -780 -3961 -431 -4,954.00 O -15,651.00 14.333.00 -10.739.00 15.664.00 -7.994.00 15,252.00 -3.202.00 8,622.00 O 0 0 CO o 482 38 379 -3,210.00 102 4,314.00 2.679.00 -2.629.00 Purchase of Investment Sale Of Investment Net Intangibles Purchase And Sale Cash From Discontinued Investing Activities Cash From Other Investing Activities Cash Flow from Investing Issuance of Stock Repurchase of Stock Net Issuance of Preferred Stock Net Issuance of Debt Cash Flow for Dividends Other Financing Cash Flow from Financing o -3.434.00 0 -4,014.00 O -9.091.00 ol -4.780.00 O - 1.307.00 837 1.249.00 o - 1.129.00 -3,167.00 304 -10,006.00 -3,124.00 921 -5,172.00 266 -5.693.00 366 -8.861.00 -9.044.00 -13,160.00