Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Introduction In 2015, PayPal was spun off from eBay and provides electronic payment solutions for both consumers and merchants and maintains a focus on online
Introduction In 2015, PayPal was spun off from eBay and provides electronic payment solutions for both consumers and merchants and maintains a focus on online transactions. For this assignment, you will utilize the attached PayPal Financials MS Excel file to create the major financial ratios. There are four sheets in the PayPal Financials MS Excel file; ratios, income statement, balance sheet, and cash flow. Using this file you will calculate and report the ratio data for PayPal for 2013 - 2015 and input the data on the first sheet (Ratios). PayPal Ratios (.xls file) This is an individual assignment Directions Place your ratio calculations in the PayPal Financial MS Excel on the Ratios sheet for 2013 -2015. Provide the formula used to calculate each ratio in the column to the right of your calculations. For example, for calculating the Gross Margin for a company, you would enter Gross Profit / Sales (gross profit divided by sales). When calculating values, you should use the SUM function in MS Excel and reference the values directly from the accounting statements provided. You will find an example for the expectations for calculations and the formulas in the attached file with Gross Margin calculated for 2013 - 2015. B3 4 x fx =SUM('Income Statement'|B2/'Income Statement'!B3) A B D E F 2013 2014 2015 FORMULA 65.26% 64.91% 63.03% Gross Profit/Sales 1 2 PROFITABILITY RATIOS 3 PYPL GROSS MARGIN 4 5 PYPL OPERATION MARGIN 6 7 PYPL NETPROFIT MARGIN 8 9 10 LIQUIDITY RATIO 11 PYPL CURRENT RATIO 12 13 PYPL CASH RATIO 14 15 LEVERAGE RATIOS 16 PYPL DEBT TO EQUITY 17 18 OPERATION RETURNS 19 PYPL ROE 20 21 PYPL ROA 22 23 A E 1 NOORN B D 2013 2014 2015 4,390,000,000 5,209,000,000 5,829,000,000 6,727,000,000 8,025,000,000 9,248,000,000 6,727,000,000 8,025,000,000 9,248,000,000 -2,337,000,000 -2,816,000,000 3,419,000,000 -2,337,000,000 -2,816,000,000 -3,419,000,000 EN -3,299,000,000 -3,941,000,000 4,320,000,000 -2,119,000,000 -2,535,000,000 -2,765,000,000 -1,328,000,000 -1,537,000,000 -1,780,000,000 -791,000,000 -998,000,000 -985,000,000 -727,000,000 -890,000,000 -947,000,000 453,000,000 -516,000,000 -608,000,000 453,000,000 -516,000,000 608,000,000 1,091,000,000 1,268,000,000 1,509,000,000 -7,000,000 -7,000,000 -21,000,000 PYPL_income-statement_Annual_As_Originally_Reported 2 Gross Profit 3 Total Revenue 4 Business Revenue 5 Cost of Revenue 6 Cost of Goods and Services 7 Other Cost of Revenue 8 Operating Income/Expenses Selling, General and Administrative Expenses 10 General and Administrative Expenses 11 Selling and Marketing Expenses 12 Research and Development Expenses 13 Depreciation, Amortization and Depletion 14 Depreciation and Amortization 15 Total Operating Profit/Loss 16 Non-Operating Income/Expenses, Total 17 Total Net Finance Income/Expense 18 Net Interest Income/Expense 19 Interest Expense Net of Capitalized Interest 20 Interest Income 21 Net Investment Income 22 Gain/Loss on Investments and Other Financial Instruments 23 Irregular Income/Expenses 24 Restructuring and Reorganization Income/Expense 25 Other Income/Expense, Non-Operating 26 Pretax Income 27 Provision for Income Tax 28 Net Income from Continuing Operations 29 Net Income after Extraordinary Items and Discontinued Operations 30 Net Income after Non-Controlling/Minority Interests 31 Net Income Available to Common Stockholders 32 Diluted Net Income Available to Common Stockholders 33 Total Revenue as Reported, Supplemental 34 Operating Expense as Reported, Supplemental 35 Total Operating Profit/Loss as Reported, Supplemental 36 Reported Effective Tax Rate 37 Reported Normalized Income 38 Reported Normalized Operating Profit 39 Basic EPS 40 Basic EPS from Continuing Operations 41 Diluted EPS 42 Diluted EPS from Continuing Operations 43 Basic Weighted Average Shares Outstanding 44 Diluted Weighted Average Shares Outstanding 45 Reported Normalized Diluted EPS 46 Basic EPS 47 Diluted EPS 48 Basic WASO 49 Diluted WASO 50 Fiscal year ends in Dec 31 USD 0 0 48,000,000 0 0 48,000,000 -7,000,000 -7,000,000 27,000,000 1,084,000,000 1,261,000,000 1,488,000,000 -129,000,000 -842,000,000 -260,000,000 955,000,000 419,000,000 1,228,000,000 955,000,000 419,000,000 1,228,000,000 955,000,000 419,000,000 1,228,000,000 955,000,000 419,000,000 1,228,000,000 955,000,000 419,000,000 1,228,000,000 6,727,000,000 8,025,000,000 9,248,000,000 -5,636,000,000 6,757,000,000 -7,787,000,000 1,091,000,000 1,268,000,000 1,461,000,000 0.119 0.67 0.175 1,186,000,000 1,343,000,000 1,588,000,000 1,411,000,000 1,648,000,000 1,975,000,000 0.31 1.00 0.31 1.00 0.31 1.00 0.31 1.00 1,251,000,000 1,222,000,000 1,262,000,000 1,229,000,000 1.10 1.29 0.31 1.00 0.31 1.00 1,251,000,000 1,222,000,000 1,262,000,000 1,229,000,000 54 Ratios Income Statement Balance Sheet Cash Flows B D E E GUNDO OWN 2013 2014 19,160,000,000 21,917,000,000 14,620,000,000 17,565,000,000 1,925,000,000 2,230,000,000 1,604,000,000 2,201,000,000 321,000,000 29,000,000 12,428,000,000 14,957,000,000 9,329,000,000 10,677,000,000 2,789,000,000 3,586,000,000 310,000,000 694,000,000 2015 28,881,000,000 20,648,000,000 3,411,000,000 1,393,000,000 2,018,000,000 16,582,000,000 12,398,000,000 4,184,000,000 0 655,000,000 10 13 267,000,000 4,540,000,000 858,000,000 2,403,000,000 328,000,000 162,000,000 166,000,000 378,000,000 4,352,000,000 922,000,000 2,862,000,000 348,000,000 162,000,000 186,000,000 8,233,000,000 1,344,000,000 3,849,000,000 649,000,000 352,000,000 21 A 1 PYPL_balance-sheet_Annual_As_Originally_Reported 2 Total Assets 3 Total Current Assets 4 Cash, Cash Equivalents and Short Term Investments 5 Cash and Cash Equivalents 6 Short Term Investments Trade and Other Receivables, Current 8 Trade/Accounts Receivable, Current 9 Loans Receivable, Current Notes Receivable, Current 11 Prepayments and Deposits, Current 12 Other Current Assets Total Non-Current Assets 14 Net Property, Plant and Equipment 15 Gross Property, Plant and Equipment 16 Properties 17 Land and Improvements 18 Leasehold and Improvements 19 Buildings and Improvements 20 Machinery, Furniture and Equipment Furniture, Fixtures and Office Equipment 22 Construction in Progress and Advance Payments 23 Accumulated Depreciation and Impairment 24 Accumulated Depreciation 25 Net Intangible Assets 26 Gross Goodwill and Other Intangible Assets 27 Goodwill 28 Intangibles other than Goodwill 29 Software and Technology 30 Other Intangible Assets 31 Accumulated Amortization and Impairment 32 Accumulated Amortization of Intangible Assets 33 Accumulated Amortization of Intangibles other than Goodwill 34 Accumulated Amortization of Software and Technology 35 Accumulated Amortization of Other Intangible Assets 36 Total Long Term Investments 37 Other Non-Current Assets 38 Total Liabilities Total Current Liabilities 40 Payables and Accrued Expenses, Current 41 Trade and Other Payables, Current Trade/Accounts Payable, Current Taxes Payable, Current 44 Accrued Expenses, Current 45 Financial Liabilities, Current 46 Current Debt and Capital Lease Obligation 47 Current Debt Ratios Income Statement Balance Sheet Cash Flows 1,983,000,000 2,350,000,000 1,983,000,000 2,350,000,000 92,000,000 164,000,000 -1,545,000,000 - 1,940,000,000 -1,545,000,000 -1,940,000,000 3,445,000,000 3,345,000,000 4,185,000,000 4,162,000,000 3,187,000,000 3,189,000,000 998,000,000 973,000,000 169,000,000 167,000,000 829,000,000 806,000,000 -740,000,000 -817,000,000 -740,000,000 -817,000,000 -740,000,000 -817,000,000 -136,000,000 -153,000,000 -604,000,000 -664,000,000 196,000,000 31,000,000 41,000,000 54,000,000 11,770,000,000 13,669,000,000 11,261,000,000 13,283,000,000 10,158,000,000 12,190,000,000 9,387,000,000 10,756,000,000 9,350,000,000 10,727,000,000 37,000,000 29,000,000 771,000,000 1,434,000,000 1,103,000,000 1,093,000,000 1,103,000,000 1,093,000,000 1.103.000.000 1.093.000.000 297,000,000 3,067,000,000 3,067,000,000 133,000,000 -2,505,000,000 -2,505,000,000 4,427,000,000 5,359,000,000 4,069,000,000 1,290,000,000 245,000,000 1,045,000,000 -932,000,000 -932,000,000 -932,000,000 - 176,000,000 -756,000,000 2,348,000,000 114,000,000 15,122,000,000 13,617,000,000 13,617,000,000 12,438,000,000 12,406,000,000 32,000,000 1,179,000,000 0 39 42 43 OO + D E 45 B 1,103,000,000 1,103,000,000 1,103,000,000 1,103,000,000 509,000,000 509,000,000 509,000,000 509,000,000 1,093,000,000 1,093,000,000 1,093,000,000 1,093,000,000 386,000,000 386,000,000 386,000,000 386,000,000 1,505,000,000 7,390,000,000 7,390,000,000 8,248,000,000 8,248,000,000 56 1,505,000,000 1,505,000,000 13,759,000,000 13,759,000,000 13,100,000,000 13,100,000,000 0 13,100,000,000 -61,000,000 7,451,000,000 110,000,000 8,138,000,000 668,000,000 -9,000,000 0 65 Financial Liabilities, Current 46 Current Debt and Capital Lease Obligation 47 Current Debt 48 Notes Payable, Current Debt 49 Total Non-Current Liabilities 50 Financial Liabilities, Non-Current 51 Long Term Debt and Capital Lease Obligation 52 Long Term Debt 53 Tax Liabilities, Non-Current 54 Deferred Tax Liabilities, Non-Current 55 Total Equity Equity Attributable to Parent Stockholders 57 Paid in Capital 58 Capital Stock 59 Common Stock 60 Preferred Stock 61 Additional Paid in CapitalShare Premium 62 Treasury Stock 63 Retained Earnings/Accumulated Deficit 64 Reserves/Accumulated Comprehensive Income/Losses Other Equity Interest 66 Non-Controlling/Minority Interests 67 Debt Maturity Schedule Total 68 Debt due in Year 1 69 Debt due in Year 2 70 Debt due in Year 3 71 Debt due in Year 4 72 Debt due in Year 5 73 Debt due Beyond 74 Debt - Interests Charges and Other Adjustments 75 Operating Lease Obligation Maturity Schedule Total 76 Operating Lease due in Year 1 77 Operating Lease due in Year 2 78 Operating Lease due in Year 3 79 Operating Lease due in Year 4 80 Operating Lease due in Year 5 81 Operating Lease due Beyond Operating Lease - Interests Charges and Other Adjustments 83 Other Contractual Obligations Maturity Schedule Total 84 Other Contractual Obligations due in Year 1 85 Other Contractual Obligations due in Year 2 Other Contractual Obligations due in Year 3 87 Other Contractual Obligations due in Year 4 88 Other Contractual Obligations due in Year 5 89 Other Contractual Obligations due Beyond 90 Total Lease Liability 82 86 90 Total Lease Liability 91 Total Lease Liability DC Due in year 1 92 Total Lease Liability DC Due in year 2 93 Total Lease Liability OC Due in year 3 94 Total Lease Liability OC Due in year 4 95 Total Lease Liability OC Due in year 5 96 Total Lease Liability C Beyond 97 Total Lease Liability aC Interest Charges and Other Adjustments 98 Total Contractual Obligations 99 Total Contractual Obligations due in year 1 100 Total Contractual Obligations due in year 2 101 Total Contractual Obligations due in year 3 102 Total Contractual Obligations due in year 4 103 Total Contractual Obligations due in year 5 104 Total Contractual Obligations due Beyond 105 Total Contractual Obligations - Interests Charges and Other Adjustments 106 Fiscal year ends in Dec 31 USD 107 108 Ratios Income Statement Balance Sheet Cash Flows + B c D E 4 5 6 7 8 9 2013 1,993,000,000 1,993,000,000 1,993,000,000 955,000,000 1,184,000,000 453,000,000 453,000,000 253,000,000 52,000,000 502,000,000 2014 2,220,000,000 2,220,000,000 2,220,000,000 419,000,000 2,100,000,000 516,000,000 516,000,000 299,000,000 680,000,000 646,000,000 2015 2,546,000,000 2,546,000,000 2,546,000,000 1,228,000,000 1,824,000,000 608,000,000 608,000,000 346,000,000 127,000,000 809,000,000 15 16 -41,000,000 18 A Paste PYPL_cash-flow_Annual_As_Originally_Reported 2 Cash Flow from Operating Activities, Indirect 3 Net Cash Flow from Continuing Operating Activities, Indirect Cash Generated from Operating Activities Income/Loss before Non-Cash Adjustment Total Adjustments for Non-Cash Items Depreciation, Amortization and Depletion, Non-Cash Adjustment Depreciation and Amortization, Non-Cash Adjustment Stock-Based Compensation, Non-Cash Adjustment 10 Taxes, Non-Cash Adjustment 11 Other Provisions, Non-Cash Adjustment 12 Net Investment Income/Loss, Non-Cash Adjustment 13 Gain/Loss on Financial Instruments, Non-Cash Adjustment 14 Unrealized Gain/Loss on Financial Instruments, Non-Cash Adjustment Other Non-Cash Items Excess Tax Benefit from Stock-Based Compensation, Non-Cash Adjustment 17 Irregular Income/Loss, Non-Cash Adjustment Gain/Loss on Disposals, Non-Cash Adjustment 19 Gain/Loss on Disposal/Sale of Other Assets, Non-Cash Adjustment 20 Changes in Operating Capital 21 Change in Trade and Other Receivables 22 Change in Trade/Accounts Receivable 23 Change in Loans Receivable 24 Change in Other Receivables Change in Notes Receivable 26 Change in Other Current Assets 27 Change in Payables and Accrued Expenses 28 Change in Trade and Other Payables Change in Trade/Accounts Payable Change in Taxes Payable Change in Other Payables 32 Change in Trade Notes Payable 33 Change in Accrued Expenses 34 Change in Other Current Liabilities 35 Change in Other Operating Capital 36 Cash Flow from Investing Activities 37 Cash Flow from Continuing Investing Activities 38 Payment for Loan Granted and Repayments Received, Net 39 Purchase/Sale and Disposal of Property, Plant and Equipment, Net Purchase of Property, Plant and Equipment 41 Sale and Disposal of Property, Plant and Equipment Purchase/Sale of Business, Net Purchase/Acquisition of Business 44 Purchase/Sale of Investments, Net Purchase of Investments 46 Sale of Investments -76,000,000 0 0 0 - 146,000,000 80,000,000 1,000,000 0 79,000,000 -299,000,000 -37,000,000 -13,000,000 -26,000,000 -40,000,000 - 40,000,000 -40,000,000 -506,000,000 113,000,000 -22,000,000 14,000,000 121,000,000 25 -62,000,000 71,000,000 71,000,000 -13,000,000 41,000,000 43,000,000 -24,000,000 -223,000,000 77,000,000 42,000,000 37,000,000 -384,000,000 - 165,000,000 - 165,000,000 12,000,000 40,000,000 -217,000,000 29 30 31 PEDRO -2,000,000 -300,000,000 69,000,000 -304,000,000 -1,721,000,000 -1,721,000,000 -793,000,000 -391,000,000 -391,000,000 0 -731,000,000 -731,000,000 -290,000,000 -610,000,000 320,000,000 -39,000,000 -1,546,000,000 -1,546,000,000 -1,023,000,000 -492,000,000 -492,000,000 40 423,000,000 -493,000,000 -6,389,000,000 -6,389,000,000 -819,000,000 -696,000,000 -722,000,000 26,000,000 -1,225,000,000 -1,225,000,000 -4,224,000,000 -7,542,000,000 3,318,000,000 42 43 -2,000,000 -2,000,000 333,000,000 -76,000,000 409,000,000 45 B 320,000,000 409,000,000 484,000,000 -85,000,000 -85,000,000 0 0 -362,000,000 -51,000,000 -51,000,000 D 3,318,000,000 575,000,000 3,079,000,000 3,079,000,000 75,000,000 75,000,000 - 133,000,000 -21,000,000 -21,000,000 -862,000,000 46 Sale of Investments 47 Purchase/Sale of Other Non-Current Assets, Net 48 Other Investing Cash Flow 49 Cash Flow from Financing Activities 50 Cash Flow from Continuing Financing Activities 51 Issuance of/Payments for Common Stock, Net 52 Proceeds from Issuance of Common Stock 53 Payments for Common Stock 54 Issuance of/Repayments for Debt, Net 55 Issuance of/Repayments for Long Term Debt, Net 56 Proceeds from Issuance of Long Term Debt 57 Repayments for Long Term Debt 58 Issuance of/Repayments for Short Term Debt, Net 59 Repayments for Short Term Debt 60 Other Financing Cash Flow 61 Excess Tax Benefit from Share-Based Compensation, Financing Activities 62 Net Movement in Non-Controlling/Minority Interest 63 Cash and Cash Equivalents, End of Period 64 Change in Cash 65 Effect of Exchange Rate Changes 66 Cash and Cash Equivalents, Beginning of Period 67 Change in Cash as Reported, Supplemental 68 Income Tax Paid, Supplemental 69 Interest Paid, Supplemental 70 Fiscal year ends in Dec 31 USD - 133,000,000 -133,000,000 0 76,000,000 -28,000,000 1,604,000,000 187,000,000 3,000,000 1,414,000,000 190,000,000 -28,000,000 -14,000,000 0 41,000,000 -71,000,000 2,201,000,000 623,000,000 -26,000,000 1,604,000,000 597,000,000 -47,000,000 - 19,000,000 -862,000,000 -862,000,000 - 18,000,000 26,000,000 3,858,000,000 1,393,000,000 -764,000,000 -44,000,000 2,201,000,000 -808,000,000 -216,000,000 - 16,000,000 Introduction In 2015, PayPal was spun off from eBay and provides electronic payment solutions for both consumers and merchants and maintains a focus on online transactions. For this assignment, you will utilize the attached PayPal Financials MS Excel file to create the major financial ratios. There are four sheets in the PayPal Financials MS Excel file; ratios, income statement, balance sheet, and cash flow. Using this file you will calculate and report the ratio data for PayPal for 2013 - 2015 and input the data on the first sheet (Ratios). PayPal Ratios (.xls file) This is an individual assignment Directions Place your ratio calculations in the PayPal Financial MS Excel on the Ratios sheet for 2013 -2015. Provide the formula used to calculate each ratio in the column to the right of your calculations. For example, for calculating the Gross Margin for a company, you would enter Gross Profit / Sales (gross profit divided by sales). When calculating values, you should use the SUM function in MS Excel and reference the values directly from the accounting statements provided. You will find an example for the expectations for calculations and the formulas in the attached file with Gross Margin calculated for 2013 - 2015. B3 4 x fx =SUM('Income Statement'|B2/'Income Statement'!B3) A B D E F 2013 2014 2015 FORMULA 65.26% 64.91% 63.03% Gross Profit/Sales 1 2 PROFITABILITY RATIOS 3 PYPL GROSS MARGIN 4 5 PYPL OPERATION MARGIN 6 7 PYPL NETPROFIT MARGIN 8 9 10 LIQUIDITY RATIO 11 PYPL CURRENT RATIO 12 13 PYPL CASH RATIO 14 15 LEVERAGE RATIOS 16 PYPL DEBT TO EQUITY 17 18 OPERATION RETURNS 19 PYPL ROE 20 21 PYPL ROA 22 23 A E 1 NOORN B D 2013 2014 2015 4,390,000,000 5,209,000,000 5,829,000,000 6,727,000,000 8,025,000,000 9,248,000,000 6,727,000,000 8,025,000,000 9,248,000,000 -2,337,000,000 -2,816,000,000 3,419,000,000 -2,337,000,000 -2,816,000,000 -3,419,000,000 EN -3,299,000,000 -3,941,000,000 4,320,000,000 -2,119,000,000 -2,535,000,000 -2,765,000,000 -1,328,000,000 -1,537,000,000 -1,780,000,000 -791,000,000 -998,000,000 -985,000,000 -727,000,000 -890,000,000 -947,000,000 453,000,000 -516,000,000 -608,000,000 453,000,000 -516,000,000 608,000,000 1,091,000,000 1,268,000,000 1,509,000,000 -7,000,000 -7,000,000 -21,000,000 PYPL_income-statement_Annual_As_Originally_Reported 2 Gross Profit 3 Total Revenue 4 Business Revenue 5 Cost of Revenue 6 Cost of Goods and Services 7 Other Cost of Revenue 8 Operating Income/Expenses Selling, General and Administrative Expenses 10 General and Administrative Expenses 11 Selling and Marketing Expenses 12 Research and Development Expenses 13 Depreciation, Amortization and Depletion 14 Depreciation and Amortization 15 Total Operating Profit/Loss 16 Non-Operating Income/Expenses, Total 17 Total Net Finance Income/Expense 18 Net Interest Income/Expense 19 Interest Expense Net of Capitalized Interest 20 Interest Income 21 Net Investment Income 22 Gain/Loss on Investments and Other Financial Instruments 23 Irregular Income/Expenses 24 Restructuring and Reorganization Income/Expense 25 Other Income/Expense, Non-Operating 26 Pretax Income 27 Provision for Income Tax 28 Net Income from Continuing Operations 29 Net Income after Extraordinary Items and Discontinued Operations 30 Net Income after Non-Controlling/Minority Interests 31 Net Income Available to Common Stockholders 32 Diluted Net Income Available to Common Stockholders 33 Total Revenue as Reported, Supplemental 34 Operating Expense as Reported, Supplemental 35 Total Operating Profit/Loss as Reported, Supplemental 36 Reported Effective Tax Rate 37 Reported Normalized Income 38 Reported Normalized Operating Profit 39 Basic EPS 40 Basic EPS from Continuing Operations 41 Diluted EPS 42 Diluted EPS from Continuing Operations 43 Basic Weighted Average Shares Outstanding 44 Diluted Weighted Average Shares Outstanding 45 Reported Normalized Diluted EPS 46 Basic EPS 47 Diluted EPS 48 Basic WASO 49 Diluted WASO 50 Fiscal year ends in Dec 31 USD 0 0 48,000,000 0 0 48,000,000 -7,000,000 -7,000,000 27,000,000 1,084,000,000 1,261,000,000 1,488,000,000 -129,000,000 -842,000,000 -260,000,000 955,000,000 419,000,000 1,228,000,000 955,000,000 419,000,000 1,228,000,000 955,000,000 419,000,000 1,228,000,000 955,000,000 419,000,000 1,228,000,000 955,000,000 419,000,000 1,228,000,000 6,727,000,000 8,025,000,000 9,248,000,000 -5,636,000,000 6,757,000,000 -7,787,000,000 1,091,000,000 1,268,000,000 1,461,000,000 0.119 0.67 0.175 1,186,000,000 1,343,000,000 1,588,000,000 1,411,000,000 1,648,000,000 1,975,000,000 0.31 1.00 0.31 1.00 0.31 1.00 0.31 1.00 1,251,000,000 1,222,000,000 1,262,000,000 1,229,000,000 1.10 1.29 0.31 1.00 0.31 1.00 1,251,000,000 1,222,000,000 1,262,000,000 1,229,000,000 54 Ratios Income Statement Balance Sheet Cash Flows B D E E GUNDO OWN 2013 2014 19,160,000,000 21,917,000,000 14,620,000,000 17,565,000,000 1,925,000,000 2,230,000,000 1,604,000,000 2,201,000,000 321,000,000 29,000,000 12,428,000,000 14,957,000,000 9,329,000,000 10,677,000,000 2,789,000,000 3,586,000,000 310,000,000 694,000,000 2015 28,881,000,000 20,648,000,000 3,411,000,000 1,393,000,000 2,018,000,000 16,582,000,000 12,398,000,000 4,184,000,000 0 655,000,000 10 13 267,000,000 4,540,000,000 858,000,000 2,403,000,000 328,000,000 162,000,000 166,000,000 378,000,000 4,352,000,000 922,000,000 2,862,000,000 348,000,000 162,000,000 186,000,000 8,233,000,000 1,344,000,000 3,849,000,000 649,000,000 352,000,000 21 A 1 PYPL_balance-sheet_Annual_As_Originally_Reported 2 Total Assets 3 Total Current Assets 4 Cash, Cash Equivalents and Short Term Investments 5 Cash and Cash Equivalents 6 Short Term Investments Trade and Other Receivables, Current 8 Trade/Accounts Receivable, Current 9 Loans Receivable, Current Notes Receivable, Current 11 Prepayments and Deposits, Current 12 Other Current Assets Total Non-Current Assets 14 Net Property, Plant and Equipment 15 Gross Property, Plant and Equipment 16 Properties 17 Land and Improvements 18 Leasehold and Improvements 19 Buildings and Improvements 20 Machinery, Furniture and Equipment Furniture, Fixtures and Office Equipment 22 Construction in Progress and Advance Payments 23 Accumulated Depreciation and Impairment 24 Accumulated Depreciation 25 Net Intangible Assets 26 Gross Goodwill and Other Intangible Assets 27 Goodwill 28 Intangibles other than Goodwill 29 Software and Technology 30 Other Intangible Assets 31 Accumulated Amortization and Impairment 32 Accumulated Amortization of Intangible Assets 33 Accumulated Amortization of Intangibles other than Goodwill 34 Accumulated Amortization of Software and Technology 35 Accumulated Amortization of Other Intangible Assets 36 Total Long Term Investments 37 Other Non-Current Assets 38 Total Liabilities Total Current Liabilities 40 Payables and Accrued Expenses, Current 41 Trade and Other Payables, Current Trade/Accounts Payable, Current Taxes Payable, Current 44 Accrued Expenses, Current 45 Financial Liabilities, Current 46 Current Debt and Capital Lease Obligation 47 Current Debt Ratios Income Statement Balance Sheet Cash Flows 1,983,000,000 2,350,000,000 1,983,000,000 2,350,000,000 92,000,000 164,000,000 -1,545,000,000 - 1,940,000,000 -1,545,000,000 -1,940,000,000 3,445,000,000 3,345,000,000 4,185,000,000 4,162,000,000 3,187,000,000 3,189,000,000 998,000,000 973,000,000 169,000,000 167,000,000 829,000,000 806,000,000 -740,000,000 -817,000,000 -740,000,000 -817,000,000 -740,000,000 -817,000,000 -136,000,000 -153,000,000 -604,000,000 -664,000,000 196,000,000 31,000,000 41,000,000 54,000,000 11,770,000,000 13,669,000,000 11,261,000,000 13,283,000,000 10,158,000,000 12,190,000,000 9,387,000,000 10,756,000,000 9,350,000,000 10,727,000,000 37,000,000 29,000,000 771,000,000 1,434,000,000 1,103,000,000 1,093,000,000 1,103,000,000 1,093,000,000 1.103.000.000 1.093.000.000 297,000,000 3,067,000,000 3,067,000,000 133,000,000 -2,505,000,000 -2,505,000,000 4,427,000,000 5,359,000,000 4,069,000,000 1,290,000,000 245,000,000 1,045,000,000 -932,000,000 -932,000,000 -932,000,000 - 176,000,000 -756,000,000 2,348,000,000 114,000,000 15,122,000,000 13,617,000,000 13,617,000,000 12,438,000,000 12,406,000,000 32,000,000 1,179,000,000 0 39 42 43 OO + D E 45 B 1,103,000,000 1,103,000,000 1,103,000,000 1,103,000,000 509,000,000 509,000,000 509,000,000 509,000,000 1,093,000,000 1,093,000,000 1,093,000,000 1,093,000,000 386,000,000 386,000,000 386,000,000 386,000,000 1,505,000,000 7,390,000,000 7,390,000,000 8,248,000,000 8,248,000,000 56 1,505,000,000 1,505,000,000 13,759,000,000 13,759,000,000 13,100,000,000 13,100,000,000 0 13,100,000,000 -61,000,000 7,451,000,000 110,000,000 8,138,000,000 668,000,000 -9,000,000 0 65 Financial Liabilities, Current 46 Current Debt and Capital Lease Obligation 47 Current Debt 48 Notes Payable, Current Debt 49 Total Non-Current Liabilities 50 Financial Liabilities, Non-Current 51 Long Term Debt and Capital Lease Obligation 52 Long Term Debt 53 Tax Liabilities, Non-Current 54 Deferred Tax Liabilities, Non-Current 55 Total Equity Equity Attributable to Parent Stockholders 57 Paid in Capital 58 Capital Stock 59 Common Stock 60 Preferred Stock 61 Additional Paid in CapitalShare Premium 62 Treasury Stock 63 Retained Earnings/Accumulated Deficit 64 Reserves/Accumulated Comprehensive Income/Losses Other Equity Interest 66 Non-Controlling/Minority Interests 67 Debt Maturity Schedule Total 68 Debt due in Year 1 69 Debt due in Year 2 70 Debt due in Year 3 71 Debt due in Year 4 72 Debt due in Year 5 73 Debt due Beyond 74 Debt - Interests Charges and Other Adjustments 75 Operating Lease Obligation Maturity Schedule Total 76 Operating Lease due in Year 1 77 Operating Lease due in Year 2 78 Operating Lease due in Year 3 79 Operating Lease due in Year 4 80 Operating Lease due in Year 5 81 Operating Lease due Beyond Operating Lease - Interests Charges and Other Adjustments 83 Other Contractual Obligations Maturity Schedule Total 84 Other Contractual Obligations due in Year 1 85 Other Contractual Obligations due in Year 2 Other Contractual Obligations due in Year 3 87 Other Contractual Obligations due in Year 4 88 Other Contractual Obligations due in Year 5 89 Other Contractual Obligations due Beyond 90 Total Lease Liability 82 86 90 Total Lease Liability 91 Total Lease Liability DC Due in year 1 92 Total Lease Liability DC Due in year 2 93 Total Lease Liability OC Due in year 3 94 Total Lease Liability OC Due in year 4 95 Total Lease Liability OC Due in year 5 96 Total Lease Liability C Beyond 97 Total Lease Liability aC Interest Charges and Other Adjustments 98 Total Contractual Obligations 99 Total Contractual Obligations due in year 1 100 Total Contractual Obligations due in year 2 101 Total Contractual Obligations due in year 3 102 Total Contractual Obligations due in year 4 103 Total Contractual Obligations due in year 5 104 Total Contractual Obligations due Beyond 105 Total Contractual Obligations - Interests Charges and Other Adjustments 106 Fiscal year ends in Dec 31 USD 107 108 Ratios Income Statement Balance Sheet Cash Flows + B c D E 4 5 6 7 8 9 2013 1,993,000,000 1,993,000,000 1,993,000,000 955,000,000 1,184,000,000 453,000,000 453,000,000 253,000,000 52,000,000 502,000,000 2014 2,220,000,000 2,220,000,000 2,220,000,000 419,000,000 2,100,000,000 516,000,000 516,000,000 299,000,000 680,000,000 646,000,000 2015 2,546,000,000 2,546,000,000 2,546,000,000 1,228,000,000 1,824,000,000 608,000,000 608,000,000 346,000,000 127,000,000 809,000,000 15 16 -41,000,000 18 A Paste PYPL_cash-flow_Annual_As_Originally_Reported 2 Cash Flow from Operating Activities, Indirect 3 Net Cash Flow from Continuing Operating Activities, Indirect Cash Generated from Operating Activities Income/Loss before Non-Cash Adjustment Total Adjustments for Non-Cash Items Depreciation, Amortization and Depletion, Non-Cash Adjustment Depreciation and Amortization, Non-Cash Adjustment Stock-Based Compensation, Non-Cash Adjustment 10 Taxes, Non-Cash Adjustment 11 Other Provisions, Non-Cash Adjustment 12 Net Investment Income/Loss, Non-Cash Adjustment 13 Gain/Loss on Financial Instruments, Non-Cash Adjustment 14 Unrealized Gain/Loss on Financial Instruments, Non-Cash Adjustment Other Non-Cash Items Excess Tax Benefit from Stock-Based Compensation, Non-Cash Adjustment 17 Irregular Income/Loss, Non-Cash Adjustment Gain/Loss on Disposals, Non-Cash Adjustment 19 Gain/Loss on Disposal/Sale of Other Assets, Non-Cash Adjustment 20 Changes in Operating Capital 21 Change in Trade and Other Receivables 22 Change in Trade/Accounts Receivable 23 Change in Loans Receivable 24 Change in Other Receivables Change in Notes Receivable 26 Change in Other Current Assets 27 Change in Payables and Accrued Expenses 28 Change in Trade and Other Payables Change in Trade/Accounts Payable Change in Taxes Payable Change in Other Payables 32 Change in Trade Notes Payable 33 Change in Accrued Expenses 34 Change in Other Current Liabilities 35 Change in Other Operating Capital 36 Cash Flow from Investing Activities 37 Cash Flow from Continuing Investing Activities 38 Payment for Loan Granted and Repayments Received, Net 39 Purchase/Sale and Disposal of Property, Plant and Equipment, Net Purchase of Property, Plant and Equipment 41 Sale and Disposal of Property, Plant and Equipment Purchase/Sale of Business, Net Purchase/Acquisition of Business 44 Purchase/Sale of Investments, Net Purchase of Investments 46 Sale of Investments -76,000,000 0 0 0 - 146,000,000 80,000,000 1,000,000 0 79,000,000 -299,000,000 -37,000,000 -13,000,000 -26,000,000 -40,000,000 - 40,000,000 -40,000,000 -506,000,000 113,000,000 -22,000,000 14,000,000 121,000,000 25 -62,000,000 71,000,000 71,000,000 -13,000,000 41,000,000 43,000,000 -24,000,000 -223,000,000 77,000,000 42,000,000 37,000,000 -384,000,000 - 165,000,000 - 165,000,000 12,000,000 40,000,000 -217,000,000 29 30 31 PEDRO -2,000,000 -300,000,000 69,000,000 -304,000,000 -1,721,000,000 -1,721,000,000 -793,000,000 -391,000,000 -391,000,000 0 -731,000,000 -731,000,000 -290,000,000 -610,000,000 320,000,000 -39,000,000 -1,546,000,000 -1,546,000,000 -1,023,000,000 -492,000,000 -492,000,000 40 423,000,000 -493,000,000 -6,389,000,000 -6,389,000,000 -819,000,000 -696,000,000 -722,000,000 26,000,000 -1,225,000,000 -1,225,000,000 -4,224,000,000 -7,542,000,000 3,318,000,000 42 43 -2,000,000 -2,000,000 333,000,000 -76,000,000 409,000,000 45 B 320,000,000 409,000,000 484,000,000 -85,000,000 -85,000,000 0 0 -362,000,000 -51,000,000 -51,000,000 D 3,318,000,000 575,000,000 3,079,000,000 3,079,000,000 75,000,000 75,000,000 - 133,000,000 -21,000,000 -21,000,000 -862,000,000 46 Sale of Investments 47 Purchase/Sale of Other Non-Current Assets, Net 48 Other Investing Cash Flow 49 Cash Flow from Financing Activities 50 Cash Flow from Continuing Financing Activities 51 Issuance of/Payments for Common Stock, Net 52 Proceeds from Issuance of Common Stock 53 Payments for Common Stock 54 Issuance of/Repayments for Debt, Net 55 Issuance of/Repayments for Long Term Debt, Net 56 Proceeds from Issuance of Long Term Debt 57 Repayments for Long Term Debt 58 Issuance of/Repayments for Short Term Debt, Net 59 Repayments for Short Term Debt 60 Other Financing Cash Flow 61 Excess Tax Benefit from Share-Based Compensation, Financing Activities 62 Net Movement in Non-Controlling/Minority Interest 63 Cash and Cash Equivalents, End of Period 64 Change in Cash 65 Effect of Exchange Rate Changes 66 Cash and Cash Equivalents, Beginning of Period 67 Change in Cash as Reported, Supplemental 68 Income Tax Paid, Supplemental 69 Interest Paid, Supplemental 70 Fiscal year ends in Dec 31 USD - 133,000,000 -133,000,000 0 76,000,000 -28,000,000 1,604,000,000 187,000,000 3,000,000 1,414,000,000 190,000,000 -28,000,000 -14,000,000 0 41,000,000 -71,000,000 2,201,000,000 623,000,000 -26,000,000 1,604,000,000 597,000,000 -47,000,000 - 19,000,000 -862,000,000 -862,000,000 - 18,000,000 26,000,000 3,858,000,000 1,393,000,000 -764,000,000 -44,000,000 2,201,000,000 -808,000,000 -216,000,000 - 16,000,000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started