***********just the vertical**************

i already did the horizontal and the ratios

Ratio Analysis must include Horizontal and Vertical Analysis of the Balance Sheet and Income Statements as well as Find at least 5 items on the balance sheet and 5 items on the income statement horizontal and vertical analysis that differ significantly from the industry and / or prior year give at least one reason as to why it maybe or is different: 1. Current Ratio BR 131 2. Quick Ratio 131-132 3. Inventory turnover (if applicable) 197-198 4. Days Sales in Inventory (if applicable) 198.365/Inventory turnover 5. Accounts Receivables Turnover-198 6. Days Sales in Receivables (if applicable) 198 365/A/R Turnover 7. Profit margin- 199 8. Gross profit margin (if applicable) gross margin/sales 9. Rate of return on total assets 199 10. Rate of return on common stockholder's equity 199 11. Debt: equity Ratio 133 12. Times Interest Earned Ratio 199 13. Earnings Per Share 184 14. Price/ Earnings Ratio Note: Not only should you compute these ratios for at least 2 years for your company, but you need to compute for at least one of your company's competitors. You should then use the ratios to explain in detail what each means and how your company is performing as compared to their competitor and past performance. Industry Average 2018 2017 5,439 2,868 2,571 1,445 100% 53% 47% 37% 63% 27% 32% 3% Keurig Dr. Pepper INC. Income Statement Year Ended December 31, 2018 and 2017 2018 Net sales 7,442 100% $ Cost of sales 3,560 48% $ Gross Profit 3,882 52% $ Selling, General and Administrative Expenses 2,635 35% $ Other operating (income) expenses, net 10 0.1% Income from Operations 237 17% $ Interest Expense 5% $ Interest expense - related party 1% $ Loss on early extinguishment of debt 0.2% $ Other (Income) Expenses, net Imcome before provision (benefit) for income taxes 11% S Provision (benefit) for income taxes 3% $ Net Income 8% $ Less: Net income attributable to employee redeemable non controlling interest and mezzanine equity awards Net income attributable to KDP Earnings per common share: Basic: 0.54 0.01% $ Diluted: 0.53 0.01% $ Weighted average common shares outstanding: Basic: 1086.3 Diluted: 1097.6 27% 3% Uuuuuuuuuuuuu -4% 20% 586 990 20% 1.25 1.24 0.02% 0.02% 0.005% 0.005% 790.5 790.5 4259 4299 Income Statement(Vertical) Balance Sheet(Vertical) Income Statement (Horizontal) Balance S Keurig Dr Pepper INC. Balance Sheet December 31, 2018 and 2017 2018 0.2% Current Assets Cash and Cash equivalents Restricted Cash and restricted cash equivalents Trade accounts receivable.net Inventories Prepaid Expenses Total current assets 44% 1056 Property, plant and Equipment, net Investments in unconsolidated subsidiaries Goodwill Other intangible assets, net Other non-current assets Deferred tax assets Total Assets 2310 186 20011 23967 40.9% 490% 0.5% 48,918 100.0% 100% Liabilities and Stockholders' Equity Current Liabilities Accounts Payable Accrued Expenses Structured Payables Short term borrowing and current portion of long-term obligations Current portion of capital lease and financing obligations Other current liabilities Total Current Liabilities Long-term obligations Long term obligations, related party Capital lease and financing obligations, less current Deferred tax liabilities Other non-current liabilities Total Liabilities Commitments and contingencies Employee redeemable non-controlling interest and mezanine equity awards Stockholder's equity Preferred stock, 50.01 par value, 15,000,000 shares authorised, no share issued Common stock, 5001 par value, 2.000.000.000 md 800,000,000 shares whered. 1405,944,922 and 790,478,141 shares issued and outstanding as of December 31, 2018 and December 31, 2017, respectively Additional paid in capital Retained earnings Accumulated other comprehensive loss) income Total stockholder's equity Total liabilities and stockholder's equity 40.5% 5.8% 0.6% -62.0% (Treasury stock 23% 100.0% 15744 100.0% 100% Income Statement(Vertical) Balance Sheet(Vertical) Income Statement (Horizontal) Balance Sheet (Hr Keurig Dr Pepper INC. Consolidated Statement of Income Year Ended December 31, 2018 and 2017 2018 2017 $ Change % Change Industry Average Net sales $ 7,442 $ 5,439 $ 2,003 36.83% -10% Cost of sales $ 3,560 $ 2,868 $ 692 24.13% -11% Gross Profit $ 3,882 $ 2,571 $ 1,311 50.99% -9% Selling, General and Administrative Expenses 2,635 $ 1,445 $ 1,190 82.35% -19% Other operating (income) expenses, net 10 $ $ 10 -43% Income from Operations 1,237 $ 1,126 $ 111 9.86% 14% Interest Expense 401 $ 111 $ 290 261.26% 9% Interest expense - related party 51 $ 125 $ (74) -59.20% . Loss on early extinguishment of debt 13 $ 90 $ (77) 85.56% Other (Income) Expenses, net (19) $ 51 $ (70) .137.25% -36% Income before provision (benefit) for income taxes 791 $ 749 $ 42 5.61% Provision (benefit) for income taxes 202 $ (253) $ 455 -179.84% Net Income 589 $ 1,002 $ (413) 41.22% Less: Net income attributable to employee redeemable non-controlling interest and mezzanine equity awards 3 $ 12 $ (9) -75.00% Net income attributable to KDP 586 $ 990 $ (404) 40.81% 416% Earnings per common share: Basic: 0.54 $ 1.25 $ (0.71) 56.80% 421% Diluted: 0.53 $ 1.24 $ (0.71) -57.26% 481% Weighted average common shares outstanding Basic: 1086.3 790.5 295.8 37.42% Diluted: 1097.6 790.5 307.1 38.85% S $ -3% Income Statement(Vertical) Balance Sheet(Vertical) Income Statement (Horizontal) Keurig Dr Pepper INC Balance Sheet December 31, 2018 and 2017 2018 2017 9 95 Current Assets Cash and Cash equivalents Restricted Cash and restricted cash equivalents Trade accounts receivable.net Inventories Prepaid Expenses Total current assets 1150 626 483 667 138.10% 384 242 63.02% 94160120. 21% 1056 1,103 104.45% 2159 790 Property, Plant and Equipment, net Investments in unconsolidated subsidiaries Goodwill Other intangble assets, net Other non-current assets Deferred taxas 1,530 89 10,192 20,133 138 (1) 33,174 9819 3834 121 27 15744 192AIN 91.75 103 BONO 525.12% 1140 3.70% 210 71% ** 9 * 1580 720 811 45.57% 403.48% 219 1.239 565.75% 333.33% ties and Stockholders' Equity Current Liabilities Accounts Payable Accrued Expenses Structured Payables Short term borrowing and current portion of long-term obligations Current portion of capital lease and financing obligations Other current liabilities Total Current Liabilities long-term obligations Long-term obligations, related party Capital lease and financing obligations, less current Deferred tax liabilities Other non-current abilities Totales 3064 1815 97 1001 56 8081 3066.67% 3.684 182.56% 11,137 363.48% 1815)100OON 208 214.43% 4.892 474 49% 198 35357% 18.304 226 51% 5 (265) 100.00% Commitments and contingencies Employee redeemable non-controlling interest and meanine equity awards Stockholder's equity Preferred stock, 30.01 par valu, 15,000,000 shares authorised, no shares issued Common stock, $0.01 par valut, 2,000,000,000 and 800,000,000 shares authorized 1,405,944,922 and 790,478,141 shares issued and outstanding as of December 31, 2018 and December 31, 2017, respectively Additional paid in capital Retained earnings Accumulated other comprehensive (los) income Total stockholder's equity Total abilities and stockholder's equity 6377 6 15,094 264 75.00% 236 69% 288 -23131% 204 58% 7398 15,135 210.71 Income Statement(Vertical) Balance Sheet(Vertical) Income Statement (Horizontal) Balance Sheet (Horizontal) Ratios 5 Current Ratio Acid test Ratio Inventory Turnover 8 Days sales in inventory 9 Accounts Receivable turnover 10 Das sales in receivables 11 Profin Mardin 12 Rate ofreturn on assets 13 Rate of return on Stockholder's Equity 14 Debt Ratio 15 Times Interest Farned Ratio 16 Earnings per share Price Farnings Ratio Keurig Dr. Pepper INC Financial Ratios Year ended 2018 2018 Industy Average 0.38 022 7.05 517 9.11 9.66 40.07 7.9 1.8% 4.1% 6.7% 54% 57% 2.75 1.96 $ 0.545 0.89 $ 48.23 Income Statement(Vertical Balance Sheet(Vertical Income Statement (Horizontal Balance Sheet (Horizontal Ratios Ratio Analysis must include Horizontal and Vertical Analysis of the Balance Sheet and Income Statements as well as Find at least 5 items on the balance sheet and 5 items on the income statement horizontal and vertical analysis that differ significantly from the industry and / or prior year give at least one reason as to why it maybe or is different: 1. Current Ratio BR 131 2. Quick Ratio 131-132 3. Inventory turnover (if applicable) 197-198 4. Days Sales in Inventory (if applicable) 198.365/Inventory turnover 5. Accounts Receivables Turnover-198 6. Days Sales in Receivables (if applicable) 198 365/A/R Turnover 7. Profit margin- 199 8. Gross profit margin (if applicable) gross margin/sales 9. Rate of return on total assets 199 10. Rate of return on common stockholder's equity 199 11. Debt: equity Ratio 133 12. Times Interest Earned Ratio 199 13. Earnings Per Share 184 14. Price/ Earnings Ratio Note: Not only should you compute these ratios for at least 2 years for your company, but you need to compute for at least one of your company's competitors. You should then use the ratios to explain in detail what each means and how your company is performing as compared to their competitor and past performance. Industry Average 2018 2017 5,439 2,868 2,571 1,445 100% 53% 47% 37% 63% 27% 32% 3% Keurig Dr. Pepper INC. Income Statement Year Ended December 31, 2018 and 2017 2018 Net sales 7,442 100% $ Cost of sales 3,560 48% $ Gross Profit 3,882 52% $ Selling, General and Administrative Expenses 2,635 35% $ Other operating (income) expenses, net 10 0.1% Income from Operations 237 17% $ Interest Expense 5% $ Interest expense - related party 1% $ Loss on early extinguishment of debt 0.2% $ Other (Income) Expenses, net Imcome before provision (benefit) for income taxes 11% S Provision (benefit) for income taxes 3% $ Net Income 8% $ Less: Net income attributable to employee redeemable non controlling interest and mezzanine equity awards Net income attributable to KDP Earnings per common share: Basic: 0.54 0.01% $ Diluted: 0.53 0.01% $ Weighted average common shares outstanding: Basic: 1086.3 Diluted: 1097.6 27% 3% Uuuuuuuuuuuuu -4% 20% 586 990 20% 1.25 1.24 0.02% 0.02% 0.005% 0.005% 790.5 790.5 4259 4299 Income Statement(Vertical) Balance Sheet(Vertical) Income Statement (Horizontal) Balance S Keurig Dr Pepper INC. Balance Sheet December 31, 2018 and 2017 2018 0.2% Current Assets Cash and Cash equivalents Restricted Cash and restricted cash equivalents Trade accounts receivable.net Inventories Prepaid Expenses Total current assets 44% 1056 Property, plant and Equipment, net Investments in unconsolidated subsidiaries Goodwill Other intangible assets, net Other non-current assets Deferred tax assets Total Assets 2310 186 20011 23967 40.9% 490% 0.5% 48,918 100.0% 100% Liabilities and Stockholders' Equity Current Liabilities Accounts Payable Accrued Expenses Structured Payables Short term borrowing and current portion of long-term obligations Current portion of capital lease and financing obligations Other current liabilities Total Current Liabilities Long-term obligations Long term obligations, related party Capital lease and financing obligations, less current Deferred tax liabilities Other non-current liabilities Total Liabilities Commitments and contingencies Employee redeemable non-controlling interest and mezanine equity awards Stockholder's equity Preferred stock, 50.01 par value, 15,000,000 shares authorised, no share issued Common stock, 5001 par value, 2.000.000.000 md 800,000,000 shares whered. 1405,944,922 and 790,478,141 shares issued and outstanding as of December 31, 2018 and December 31, 2017, respectively Additional paid in capital Retained earnings Accumulated other comprehensive loss) income Total stockholder's equity Total liabilities and stockholder's equity 40.5% 5.8% 0.6% -62.0% (Treasury stock 23% 100.0% 15744 100.0% 100% Income Statement(Vertical) Balance Sheet(Vertical) Income Statement (Horizontal) Balance Sheet (Hr Keurig Dr Pepper INC. Consolidated Statement of Income Year Ended December 31, 2018 and 2017 2018 2017 $ Change % Change Industry Average Net sales $ 7,442 $ 5,439 $ 2,003 36.83% -10% Cost of sales $ 3,560 $ 2,868 $ 692 24.13% -11% Gross Profit $ 3,882 $ 2,571 $ 1,311 50.99% -9% Selling, General and Administrative Expenses 2,635 $ 1,445 $ 1,190 82.35% -19% Other operating (income) expenses, net 10 $ $ 10 -43% Income from Operations 1,237 $ 1,126 $ 111 9.86% 14% Interest Expense 401 $ 111 $ 290 261.26% 9% Interest expense - related party 51 $ 125 $ (74) -59.20% . Loss on early extinguishment of debt 13 $ 90 $ (77) 85.56% Other (Income) Expenses, net (19) $ 51 $ (70) .137.25% -36% Income before provision (benefit) for income taxes 791 $ 749 $ 42 5.61% Provision (benefit) for income taxes 202 $ (253) $ 455 -179.84% Net Income 589 $ 1,002 $ (413) 41.22% Less: Net income attributable to employee redeemable non-controlling interest and mezzanine equity awards 3 $ 12 $ (9) -75.00% Net income attributable to KDP 586 $ 990 $ (404) 40.81% 416% Earnings per common share: Basic: 0.54 $ 1.25 $ (0.71) 56.80% 421% Diluted: 0.53 $ 1.24 $ (0.71) -57.26% 481% Weighted average common shares outstanding Basic: 1086.3 790.5 295.8 37.42% Diluted: 1097.6 790.5 307.1 38.85% S $ -3% Income Statement(Vertical) Balance Sheet(Vertical) Income Statement (Horizontal) Keurig Dr Pepper INC Balance Sheet December 31, 2018 and 2017 2018 2017 9 95 Current Assets Cash and Cash equivalents Restricted Cash and restricted cash equivalents Trade accounts receivable.net Inventories Prepaid Expenses Total current assets 1150 626 483 667 138.10% 384 242 63.02% 94160120. 21% 1056 1,103 104.45% 2159 790 Property, Plant and Equipment, net Investments in unconsolidated subsidiaries Goodwill Other intangble assets, net Other non-current assets Deferred taxas 1,530 89 10,192 20,133 138 (1) 33,174 9819 3834 121 27 15744 192AIN 91.75 103 BONO 525.12% 1140 3.70% 210 71% ** 9 * 1580 720 811 45.57% 403.48% 219 1.239 565.75% 333.33% ties and Stockholders' Equity Current Liabilities Accounts Payable Accrued Expenses Structured Payables Short term borrowing and current portion of long-term obligations Current portion of capital lease and financing obligations Other current liabilities Total Current Liabilities long-term obligations Long-term obligations, related party Capital lease and financing obligations, less current Deferred tax liabilities Other non-current abilities Totales 3064 1815 97 1001 56 8081 3066.67% 3.684 182.56% 11,137 363.48% 1815)100OON 208 214.43% 4.892 474 49% 198 35357% 18.304 226 51% 5 (265) 100.00% Commitments and contingencies Employee redeemable non-controlling interest and meanine equity awards Stockholder's equity Preferred stock, 30.01 par valu, 15,000,000 shares authorised, no shares issued Common stock, $0.01 par valut, 2,000,000,000 and 800,000,000 shares authorized 1,405,944,922 and 790,478,141 shares issued and outstanding as of December 31, 2018 and December 31, 2017, respectively Additional paid in capital Retained earnings Accumulated other comprehensive (los) income Total stockholder's equity Total abilities and stockholder's equity 6377 6 15,094 264 75.00% 236 69% 288 -23131% 204 58% 7398 15,135 210.71 Income Statement(Vertical) Balance Sheet(Vertical) Income Statement (Horizontal) Balance Sheet (Horizontal) Ratios 5 Current Ratio Acid test Ratio Inventory Turnover 8 Days sales in inventory 9 Accounts Receivable turnover 10 Das sales in receivables 11 Profin Mardin 12 Rate ofreturn on assets 13 Rate of return on Stockholder's Equity 14 Debt Ratio 15 Times Interest Farned Ratio 16 Earnings per share Price Farnings Ratio Keurig Dr. Pepper INC Financial Ratios Year ended 2018 2018 Industy Average 0.38 022 7.05 517 9.11 9.66 40.07 7.9 1.8% 4.1% 6.7% 54% 57% 2.75 1.96 $ 0.545 0.89 $ 48.23 Income Statement(Vertical Balance Sheet(Vertical Income Statement (Horizontal Balance Sheet (Horizontal Ratios