How to analyze the historical growth or reduction rate of key items in Balance sheet, Income statement (Intel)

Assets Fiscal year is January-December. All values USD millions. 2015 2016 2017 2018 2019 5-year trend # Cash & Short Term Investments 25.31B 17.1B 14B 11.65B 13.12B Cash Only 15.31B 5.56B 3.43B 3.02B 4.19B Short-Term Investments 10.01B 11.54B 10.57B 8.63B 8.93B + Total Accounts Receivable 5.53B 5.07B 5.68B 6.88B 7.74B Accounts Receivables, Net 4.79B 4.69B 5.61B 6.72E 7.66B Accounts Receivables, Gross 4.83B 4.73B 5.63B 6.76B 7.66B Bad Debt/Doubtful Accounts (40M) (37M) (25M) (33M) Other Receivables 743M 384M 71M 162M 76M Inventories 5.17B 5.55B 6.98B 7.25B 8.74B ************************ Finished Goods 1.74B 1.67B 2.03B 1.93B 1.68B Work in Progress 2.89B 3.19B 4.21B 4.51B 6.23B Raw Materials 532M 695M 738M 813M 840M Progress Payments & Other Other Current Assets 2.31B 7.78B 2.84B 3B 1.64B Miscellaneous Current Assets 2.31B 7.78B 2.84B 3B 1.64B Total Current Assets 38.32B 35.51B 29.5B 28.79B 31.24B Liabilities & Shareholders' Equity 2015 2016 2017 2018 2019 5-year trend ST Debt & Current Portion LT Debt 2.63B 4.63B 1.78B 1.26B 3.87B Short Term Debt 41M 25M 37M 500M 175M Current Portion of Long Term Debt 2.59B 4.61B 1.74B 761M 3.69B Accounts Payable 2.06B 2.48B 2.93B 3.82B 4.13B Income Tax Payable 272M 329M 1.4B 366M 575M Other Current Liabilities 10.68B 12.86B 11.32B 11.18B 13.74B Dividends Payable Accrued Payroll 4.44B 4.97B 5.23B 5.32B 5.95B Miscellaneous Current Liabilities 6.24B 7.9B 6.09B 5.85B 7.79B Total Current Liabilities 15.65B 20.3B 17.42B 16.63B 22.31B Long-Term Debt 20.93B 21.53B 25.9B 25.52B 25.84B Long-Term Debt excl. Capitalized Leases 20.93B 21.53B 25.9B 25.52B 25.46B Non-Convertible Debt 20.93B 21.53B 25.9B 25.52B 25.46B Convertible Debt Capitalized Lease Obligations Provision for Risks & Charges 1.51B 1.94B 1.56B 1.13B 1.63B Deferred Taxes (97M) 823M 2.21B 543M 835M Deferred Taxes - Credit 954M 1.73B 3.05B 1.67B 2.04B Deferred Taxes - Debit 1.05B 907M 840M 1.12B 1.21B Other Liabilities 1.33B 1.6B 6.31B 8.47B 7.2B Other Liabilities (excl. Deferred Income) 804M 1.53B 6.31B 6.42B 5.83B Deferred Income 530M 65M 2.05B 1.37B Total Liabilities 40.37B 47.1B 54.23B 53.4B 59.02B Non-Equity Reserves Preferred Stock (Carrying Value) Redeemable Preferred Stock Non-Redeemable Preferred Stock + Common Equity (Total) 61.09B 66.23B 69.02B 74.56B 77.5B Common Stock Par/Carry Value 23.41B 25.37B 26.07B 25.37B 25.26B Retained Earnings 37.61B 40.75B 42.08B 50.17B 53.52B ESOP Debt Guarantee Cumulative Translation Adjustment/Unrealized For. Exch. Gain (515M) (519M) (26M) (33M) 48M Unrealized Gain/Loss Marketable Securities 1.75B 2.16B 1.75B Revaluation Reserves Treasury Stock + Total Shareholders' Equity 61.09B 66.23B 69.02B 74.56B 77.5B Accumulated Minority Interest Total Equity 61.09B 66.23B 69.02B 74.56B 77.5B Liabilities & Shareholders' Equity 101.46B 113.33B 123.25B 127.96B 136.52B Copyright 2020 FactSet Research Systems Inc. All rights reserved. Source FactSet Fundamentals. Fiscal year is January-December. All values USD millions 2015 2016 2017 2018 2019 5-year trend + Sales/Revenue 55.36B 59.39B 62.76B 70.85B 71.97B # Cost of Goods Sold (COGS) incl. D&A 20.65B 23.43B 23.78B 27.3B 30.038 null COGS excluding D&A 11.94B 15.64B 15.65B 18.21B 19.2B Depreciation & Amortization Expense 8.71B 7.79B 8.13B 9.09B 10.83B Depreciation 7.82B 6.27B 6.750 7.52B 9.2B Amortization of Intangibles 890M 1.52B 1.38B 1.57B 1.62B + Gross Income 34.7B 35.96B 38.99B 43.55B 41.94B 2015 2016 2017 2018 2019 5-year trend + SG&A Expense 19.84B 21.15B 20.54B 20.36B 19.51B ************************ Research & Development 11.95B 12.75B 13.08B 13.58B 13.36B Other SG&A 7.88B 8.4B 7.46B 6.77B 6.15B Other Operating Expense Unusual Expense 251M 1.68B 1.76B 158M (227M) EBIT after Unusual Expense (251M) 13.14B (1.76B) 23.04B 22.66B Non Operating Income/Expense (98M) 349M 3.87B 308M 1.41B Non-Operating Interest Income 124M 222M 441M 438M 483M Equity in Affiliates (Pretax) (95M) (38M) + Interest Expense 337M 733M 646M 468M 489M Gross Interest Expense 595M 868M 959M 964M 961M Interest Capitalized 258M 135M 313M 496M 472M + Pretax Income 14.21B 12.94B 12.94 20.35B 23.32B 24.06B Income Tax 2.79B 2.62B 10.75B 2.26B Income Tax - Current Domestic 2.87B 1.33B 8.33B 2.78B 3.01B L. 1.43B L. 1.06B ull Income Tax - Current Foreign 842M 756M 899M 1.1B ************* Income Tax-Deferred Domestic (918M) 532M 1.52B (1.618) 522M Income Tax - Deferred Foreign Income Tax Credits Equity in Affiliates Other After Tax Income (Expense) Consolidated Net Income 11.42B 10.32B 9.6B 21.05B 21.05B Minority Interest Expense + Net Income 11.42B 10.32B 9.6B 21.05B 21.05B Assets Fiscal year is January-December. All values USD millions. 2015 2016 2017 2018 2019 5-year trend # Cash & Short Term Investments 25.31B 17.1B 14B 11.65B 13.12B Cash Only 15.31B 5.56B 3.43B 3.02B 4.19B Short-Term Investments 10.01B 11.54B 10.57B 8.63B 8.93B + Total Accounts Receivable 5.53B 5.07B 5.68B 6.88B 7.74B Accounts Receivables, Net 4.79B 4.69B 5.61B 6.72E 7.66B Accounts Receivables, Gross 4.83B 4.73B 5.63B 6.76B 7.66B Bad Debt/Doubtful Accounts (40M) (37M) (25M) (33M) Other Receivables 743M 384M 71M 162M 76M Inventories 5.17B 5.55B 6.98B 7.25B 8.74B ************************ Finished Goods 1.74B 1.67B 2.03B 1.93B 1.68B Work in Progress 2.89B 3.19B 4.21B 4.51B 6.23B Raw Materials 532M 695M 738M 813M 840M Progress Payments & Other Other Current Assets 2.31B 7.78B 2.84B 3B 1.64B Miscellaneous Current Assets 2.31B 7.78B 2.84B 3B 1.64B Total Current Assets 38.32B 35.51B 29.5B 28.79B 31.24B Liabilities & Shareholders' Equity 2015 2016 2017 2018 2019 5-year trend ST Debt & Current Portion LT Debt 2.63B 4.63B 1.78B 1.26B 3.87B Short Term Debt 41M 25M 37M 500M 175M Current Portion of Long Term Debt 2.59B 4.61B 1.74B 761M 3.69B Accounts Payable 2.06B 2.48B 2.93B 3.82B 4.13B Income Tax Payable 272M 329M 1.4B 366M 575M Other Current Liabilities 10.68B 12.86B 11.32B 11.18B 13.74B Dividends Payable Accrued Payroll 4.44B 4.97B 5.23B 5.32B 5.95B Miscellaneous Current Liabilities 6.24B 7.9B 6.09B 5.85B 7.79B Total Current Liabilities 15.65B 20.3B 17.42B 16.63B 22.31B Long-Term Debt 20.93B 21.53B 25.9B 25.52B 25.84B Long-Term Debt excl. Capitalized Leases 20.93B 21.53B 25.9B 25.52B 25.46B Non-Convertible Debt 20.93B 21.53B 25.9B 25.52B 25.46B Convertible Debt Capitalized Lease Obligations Provision for Risks & Charges 1.51B 1.94B 1.56B 1.13B 1.63B Deferred Taxes (97M) 823M 2.21B 543M 835M Deferred Taxes - Credit 954M 1.73B 3.05B 1.67B 2.04B Deferred Taxes - Debit 1.05B 907M 840M 1.12B 1.21B Other Liabilities 1.33B 1.6B 6.31B 8.47B 7.2B Other Liabilities (excl. Deferred Income) 804M 1.53B 6.31B 6.42B 5.83B Deferred Income 530M 65M 2.05B 1.37B Total Liabilities 40.37B 47.1B 54.23B 53.4B 59.02B Non-Equity Reserves Preferred Stock (Carrying Value) Redeemable Preferred Stock Non-Redeemable Preferred Stock + Common Equity (Total) 61.09B 66.23B 69.02B 74.56B 77.5B Common Stock Par/Carry Value 23.41B 25.37B 26.07B 25.37B 25.26B Retained Earnings 37.61B 40.75B 42.08B 50.17B 53.52B ESOP Debt Guarantee Cumulative Translation Adjustment/Unrealized For. Exch. Gain (515M) (519M) (26M) (33M) 48M Unrealized Gain/Loss Marketable Securities 1.75B 2.16B 1.75B Revaluation Reserves Treasury Stock + Total Shareholders' Equity 61.09B 66.23B 69.02B 74.56B 77.5B Accumulated Minority Interest Total Equity 61.09B 66.23B 69.02B 74.56B 77.5B Liabilities & Shareholders' Equity 101.46B 113.33B 123.25B 127.96B 136.52B Copyright 2020 FactSet Research Systems Inc. All rights reserved. Source FactSet Fundamentals. Fiscal year is January-December. All values USD millions 2015 2016 2017 2018 2019 5-year trend + Sales/Revenue 55.36B 59.39B 62.76B 70.85B 71.97B # Cost of Goods Sold (COGS) incl. D&A 20.65B 23.43B 23.78B 27.3B 30.038 null COGS excluding D&A 11.94B 15.64B 15.65B 18.21B 19.2B Depreciation & Amortization Expense 8.71B 7.79B 8.13B 9.09B 10.83B Depreciation 7.82B 6.27B 6.750 7.52B 9.2B Amortization of Intangibles 890M 1.52B 1.38B 1.57B 1.62B + Gross Income 34.7B 35.96B 38.99B 43.55B 41.94B 2015 2016 2017 2018 2019 5-year trend + SG&A Expense 19.84B 21.15B 20.54B 20.36B 19.51B ************************ Research & Development 11.95B 12.75B 13.08B 13.58B 13.36B Other SG&A 7.88B 8.4B 7.46B 6.77B 6.15B Other Operating Expense Unusual Expense 251M 1.68B 1.76B 158M (227M) EBIT after Unusual Expense (251M) 13.14B (1.76B) 23.04B 22.66B Non Operating Income/Expense (98M) 349M 3.87B 308M 1.41B Non-Operating Interest Income 124M 222M 441M 438M 483M Equity in Affiliates (Pretax) (95M) (38M) + Interest Expense 337M 733M 646M 468M 489M Gross Interest Expense 595M 868M 959M 964M 961M Interest Capitalized 258M 135M 313M 496M 472M + Pretax Income 14.21B 12.94B 12.94 20.35B 23.32B 24.06B Income Tax 2.79B 2.62B 10.75B 2.26B Income Tax - Current Domestic 2.87B 1.33B 8.33B 2.78B 3.01B L. 1.43B L. 1.06B ull Income Tax - Current Foreign 842M 756M 899M 1.1B ************* Income Tax-Deferred Domestic (918M) 532M 1.52B (1.618) 522M Income Tax - Deferred Foreign Income Tax Credits Equity in Affiliates Other After Tax Income (Expense) Consolidated Net Income 11.42B 10.32B 9.6B 21.05B 21.05B Minority Interest Expense + Net Income 11.42B 10.32B 9.6B 21.05B 21.05B