Perform trend analysis of the key financial ratios (i.e., liquidity ratios, asset management ratios, debt management ratios, profitability ratios, market value ratios) of the company for 3-5 years.
I tried putting in excel, but chegg would't let me it said my question was to long.
Report Date 12/28/2019 12/29/2018 12/30/2017 12/31/2016 12/26/2015 Currency Audit Status USD Not Available USD Not Qualified USD Not Qualified USD Not Qualified USD Not Qualified Yes Yes Yes Consolidated Scale Yes Thousands Yes Thousands Thousands Thousands Thousands 5509000 229000 10610000 8900000 9158000 6967000 9096000 2913000 6447000 1480000 7927000 105000 7822000 8721000 272000 1997000 6079000 1164000 7243000 101000 7142000 5956000 1197000 7153000 129000 7024000 5709000 1119000 6828000 134000 6694000 1315000 5497000 1070000 6567000 130000 6437000 1312000 Cash & cash equivalents Short-term investments Restricted cash Trade receivables Other receivables Total accounts receivable, gross Less allowance - accounts receivabl Accounts & notes receivable, net Raw materials Raw materials & packaging Work-in-process Finished goods Inventories Prepaid expenses & other current a Total current assets Land Buildings & improvements Machinery & equipment, including fl Construction in progress Property, plant & equipment, gross Less: accumulated depreciation Property, plant & equipment, net Amortizable intangible assets, net Goodwill Other indefinite-lived intangible asse Indefinite-lived intangible assets Investments in noncontrolled affiliate Deferred income taxes Non-current notes & accounts receiv Deferred marketplace spending Pension plans Operating lease, right-of-use asset Other assets Other assets 1395000 200000 1743000 3338000 747000 17645000 1130000 9314000 29390000 3169000 43003000 23698000 19305000 1433000 15501000 14610000 30111000 2683000 4359000 85000 147000 846000 1548000 385000 3011000 1312000 178000 1638000 3128000 633000 21893000 1078000 894 1000 27715000 2430000 40164000 22575000 17589000 1644000 14808000 14181000 28989000 2409000 4364000 86000 112000 269000 1344000 167000 1436000 2947000 1546000 31027000 1148000 8796000 27018000 2144000 39106000 21866000 17240000 1268000 14744000 12570000 27314000 2042000 150000 1258000 2723000 1547000 27089000 1153000 8306000 25277000 2082000 36818000 20227000 16591000 1237000 14430000 12196000 26626000 1950000 161000 1247000 2720000 1865000 23031000 1184000 8061000 24764000 1738000 35747000 19430000 16317000 1270000 14177000 11811000 25988000 2311000 59000 134000 374000 105000 140000 53000 140000 159000 60000 293000 760000 346000 913000 338000 636000 391000 750000 78547000 2848000 77648000 3953000 73000 4026000 7213000 2541000 1755000 1329000 1997000 79804000 4020000 1385000 80000 5485000 6727000 2390000 1785000 1161000 74129000 4401000 2257000 234000 6892000 6158000 2444000 1770000 1097000 69667000 3109000 770000 192000 4071000 5546000 2319000 1759000 104 1000 50 Total assets 51 Current maturities of long-term debt 52 Commercial paper 53 Other borrowings 54 Short-term debt obligations 55 Accounts payable 56 Accrued marketplace spending 67 Accrued compensation & benefits 58 Dividends payable 59 SodaStream International Ltd (Soda 60 Current lease liabilities 61 Other current liabilities 62 Accounts payable & other current li 63 Total current liabilities 64 Notes 65 Other long-term debt obligations 66 Total long-term debt obligations 67 Less: current maturities of long-term 68 Long-term debt obligations 69 Other liabilities 70 Deferred income taxes 71 Total liabilities 72 Preferred stock 73 Repurchased preferred stock 74 Common stock 75 Capital in excess of par value 76 Retained earnings 77 Currency translation adjustment 78 Cash flow hedges, net of tax 79 Pension & retiree medical, net of ta 30 Unrealized gain on securities, net of 81 Available-for-sale securities 32 Other accumulated other compreher 33 Accumulated other comprehensive i 84 Repurchased common stock, in exc 85 Total PepsiCo, Inc. common shareh 36 Noncontrolling interests 87 Total equity 72000 2920000 8013000 2765000 1835000 1351000 58000 442000 3077000 17541000 20461000 31968000 28000 31996000 2848000 29148000 9979000 4091000 63679000 3277000 18112000 22138000 32222000 26000 32248000 3953000 28295000 9114000 3499000 63046000 2954000 15017000 20502000 37785000 31000 37816000 4020000 33796000 11283000 3242000 68823000 41000 197000 24000 3996000 52839000 -10277000 47000 -2804000 2774000 14243000 21135000 34419000 35000 34454000 4401000 30053000 6669000 5073000 62930000 41000 192000 24000 4091000 52518000 - 11386000 83000 -2645000 64000 2842000 13507000 17578000 32286000 36000 32322000 3109000 29213000 5887000 4959000 57637000 41000 186000 24000 4076000 50472000 -11080000 37000 -2329000 88000 23000 3886000 61946000 - 11290000 -3000 -2988000 23000 3953000 59947000 -11918000 87000 -3271000 -19000 - 14300000 36769000 14786000 82000 14868000 2000 - 19000 -15119000 34286000 14518000 84000 14602000 -4000 - 19000 -13057000 32757000 11045000 92000 10981000 -35000 -13919000 31468000 11246000 104000 11199000 -35000 -13319000 29185000 12068000 107000 120300000 Report Date 12/28/2019 12/29/2018 12/30/2017 12/31/2016 12/26/2015 Currency Audit Status USD Not Available USD Not Qualified USD Not Qualified USD Not Qualified USD Not Qualified Yes Yes Yes Consolidated Scale Yes Thousands Yes Thousands Thousands Thousands Thousands 5509000 229000 10610000 8900000 9158000 6967000 9096000 2913000 6447000 1480000 7927000 105000 7822000 8721000 272000 1997000 6079000 1164000 7243000 101000 7142000 5956000 1197000 7153000 129000 7024000 5709000 1119000 6828000 134000 6694000 1315000 5497000 1070000 6567000 130000 6437000 1312000 Cash & cash equivalents Short-term investments Restricted cash Trade receivables Other receivables Total accounts receivable, gross Less allowance - accounts receivabl Accounts & notes receivable, net Raw materials Raw materials & packaging Work-in-process Finished goods Inventories Prepaid expenses & other current a Total current assets Land Buildings & improvements Machinery & equipment, including fl Construction in progress Property, plant & equipment, gross Less: accumulated depreciation Property, plant & equipment, net Amortizable intangible assets, net Goodwill Other indefinite-lived intangible asse Indefinite-lived intangible assets Investments in noncontrolled affiliate Deferred income taxes Non-current notes & accounts receiv Deferred marketplace spending Pension plans Operating lease, right-of-use asset Other assets Other assets 1395000 200000 1743000 3338000 747000 17645000 1130000 9314000 29390000 3169000 43003000 23698000 19305000 1433000 15501000 14610000 30111000 2683000 4359000 85000 147000 846000 1548000 385000 3011000 1312000 178000 1638000 3128000 633000 21893000 1078000 894 1000 27715000 2430000 40164000 22575000 17589000 1644000 14808000 14181000 28989000 2409000 4364000 86000 112000 269000 1344000 167000 1436000 2947000 1546000 31027000 1148000 8796000 27018000 2144000 39106000 21866000 17240000 1268000 14744000 12570000 27314000 2042000 150000 1258000 2723000 1547000 27089000 1153000 8306000 25277000 2082000 36818000 20227000 16591000 1237000 14430000 12196000 26626000 1950000 161000 1247000 2720000 1865000 23031000 1184000 8061000 24764000 1738000 35747000 19430000 16317000 1270000 14177000 11811000 25988000 2311000 59000 134000 374000 105000 140000 53000 140000 159000 60000 293000 760000 346000 913000 338000 636000 391000 750000 78547000 2848000 77648000 3953000 73000 4026000 7213000 2541000 1755000 1329000 1997000 79804000 4020000 1385000 80000 5485000 6727000 2390000 1785000 1161000 74129000 4401000 2257000 234000 6892000 6158000 2444000 1770000 1097000 69667000 3109000 770000 192000 4071000 5546000 2319000 1759000 104 1000 50 Total assets 51 Current maturities of long-term debt 52 Commercial paper 53 Other borrowings 54 Short-term debt obligations 55 Accounts payable 56 Accrued marketplace spending 67 Accrued compensation & benefits 58 Dividends payable 59 SodaStream International Ltd (Soda 60 Current lease liabilities 61 Other current liabilities 62 Accounts payable & other current li 63 Total current liabilities 64 Notes 65 Other long-term debt obligations 66 Total long-term debt obligations 67 Less: current maturities of long-term 68 Long-term debt obligations 69 Other liabilities 70 Deferred income taxes 71 Total liabilities 72 Preferred stock 73 Repurchased preferred stock 74 Common stock 75 Capital in excess of par value 76 Retained earnings 77 Currency translation adjustment 78 Cash flow hedges, net of tax 79 Pension & retiree medical, net of ta 30 Unrealized gain on securities, net of 81 Available-for-sale securities 32 Other accumulated other compreher 33 Accumulated other comprehensive i 84 Repurchased common stock, in exc 85 Total PepsiCo, Inc. common shareh 36 Noncontrolling interests 87 Total equity 72000 2920000 8013000 2765000 1835000 1351000 58000 442000 3077000 17541000 20461000 31968000 28000 31996000 2848000 29148000 9979000 4091000 63679000 3277000 18112000 22138000 32222000 26000 32248000 3953000 28295000 9114000 3499000 63046000 2954000 15017000 20502000 37785000 31000 37816000 4020000 33796000 11283000 3242000 68823000 41000 197000 24000 3996000 52839000 -10277000 47000 -2804000 2774000 14243000 21135000 34419000 35000 34454000 4401000 30053000 6669000 5073000 62930000 41000 192000 24000 4091000 52518000 - 11386000 83000 -2645000 64000 2842000 13507000 17578000 32286000 36000 32322000 3109000 29213000 5887000 4959000 57637000 41000 186000 24000 4076000 50472000 -11080000 37000 -2329000 88000 23000 3886000 61946000 - 11290000 -3000 -2988000 23000 3953000 59947000 -11918000 87000 -3271000 -19000 - 14300000 36769000 14786000 82000 14868000 2000 - 19000 -15119000 34286000 14518000 84000 14602000 -4000 - 19000 -13057000 32757000 11045000 92000 10981000 -35000 -13919000 31468000 11246000 104000 11199000 -35000 -13319000 29185000 12068000 107000 120300000
