Financial Accounting: 6.4.2 Debt to Equity Ratio Spreadsheet Consider the following selected accounts from the balance sheet (in millions) for Apple Inc. First, calculate the debt to equity ratio observed in both 2012 and 2013 (hint: do NOT use averages). Then, calculate the debt to equity ratio using the average liabilities and average equity. HOME INSERT DATA fx A D E F. G H 1 2 Receivable, 3 Inventory 4 P.P.&E, net 5 Intangibles, net 6 Total Assets 7 Accounts Payable 8 Accrued Expenses 9 Other Current Liabilities 10 Long Term Debt 11 Other Long Term Liabilities 12 Common Stock 13 Retained Earnings 14 AOCI & Other Equity 15 16 17 Debt to Equity Ratios 18 B 2012 2013 10,930 13,102 791 1.764 15,452 16,597 5,359 5,756 176,064 207,000 21.175 22,367 11,414 13,856 5,953 7.435 16,960 19,312 22,833 16.422 19,764 101,289 104,256 499 -471 2012 2013 AVERAGE 19 20 21 22 23 24 25