excel for Accounting

profileyasooo1
extra_credit_template_-_aapl.xlsx

Sheet1

In Millions of USD (except for per share items) 52 weeks ending 2016-09-24 52 weeks ending 2015-09-26 52 weeks ending 2014-09-27 52 weeks ending 2013-09-28
Revenue 215,639.00 233,715.00 182,795.00 170,910.00
Other Revenue, Total - - - -
Total Revenue 215,639.00 233,715.00 182,795.00 170,910.00
Cost of Revenue, Total 131,376.00 140,089.00 112,258.00 106,606.00
Gross Profit 84,263.00 93,626.00 70,537.00 64,304.00
Selling/General/Admin. Expenses, Total 14,194.00 14,329.00 11,993.00 10,830.00
Research & Development 10,045.00 8,067.00 6,041.00 4,475.00
Depreciation/Amortization - - - -
Interest Expense(Income) - Net Operating - - - -
Unusual Expense (Income) - - - -
Other Operating Expenses, Total - - - -
Total Operating Expense 155,615.00 162,485.00 130,292.00 121,911.00
Operating Income 60,024.00 71,230.00 52,503.00 48,999.00
Interest Income(Expense), Net Non-Operating - - - -
Gain (Loss) on Sale of Assets - - - -
Other, Net -1,195.00 -903 -311 -24
Income Before Tax 61,372.00 72,515.00 53,483.00 50,155.00
Income After Tax 45,687.00 53,394.00 39,510.00 37,037.00
Minority Interest - - - -
Equity In Affiliates - - - -
Net Income Before Extra. Items 45,687.00 53,394.00 39,510.00 37,037.00
Accounting Change - - - -
Discontinued Operations - - - -
Extraordinary Item - - - -
Net Income 45,687.00 53,394.00 39,510.00 37,037.00

Sheet2

In Millions of USD (except for per share items) As of 2016-09-24 As of 2015-09-26 As of 2014-09-27 As of 2013-09-28
Cash & Equivalents - - - -
Short Term Investments 58,554.00 30,212.00 14,845.00 31,841.00
Cash and Short Term Investments 67,155.00 41,601.00 25,077.00 40,546.00
Accounts Receivable - Trade, Net 15,754.00 16,849.00 17,460.00 13,102.00
Receivables - Other - - - -
Total Receivables, Net 29,299.00 30,343.00 27,219.00 20,641.00
Total Inventory 2,132.00 2,349.00 2,111.00 1,764.00
Prepaid Expenses - - - -
Other Current Assets, Total 8,283.00 15,085.00 14,124.00 10,335.00
Total Current Assets 106,869.00 89,378.00 68,531.00 73,286.00
Property/Plant/Equipment, Total - Gross 61,245.00 49,257.00 39,015.00 28,519.00
Accumulated Depreciation, Total -34,235.00 -26,786.00 -18,391.00 -11,922.00
Goodwill, Net 5,414.00 5,116.00 4,616.00 1,577.00
Intangibles, Net 3,206.00 3,893.00 4,142.00 4,179.00
Long Term Investments 170,430.00 164,065.00 130,162.00 106,215.00
Other Long Term Assets, Total 8,757.00 5,422.00 3,764.00 5,146.00
Total Assets 321,686.00 290,345.00 231,839.00 207,000.00
Accounts Payable 37,294.00 35,490.00 30,196.00 22,367.00
Accrued Expenses 20,951.00 24,169.00 7,689.00 4,782.00
Notes Payable/Short Term Debt 8,105.00 8,499.00 6,308.00 0
Current Port. of LT Debt/Capital Leases 3,500.00 2,500.00 - -
Other Current liabilities, Total 9,156.00 9,952.00 19,255.00 16,509.00
Total Current Liabilities 79,006.00 80,610.00 63,448.00 43,658.00
Long Term Debt 75,427.00 53,329.00 28,987.00 16,960.00
Capital Lease Obligations - - - -
Total Long Term Debt 75,427.00 53,329.00 28,987.00 16,960.00
Total Debt 87,032.00 64,328.00 35,295.00 16,960.00
Deferred Income Tax 26,019.00 24,062.00 20,259.00 16,489.00
Minority Interest - - - -
Other Liabilities, Total 12,985.00 12,989.00 7,598.00 6,344.00
Total Liabilities 193,437.00 170,990.00 120,292.00 83,451.00
Redeemable Preferred Stock, Total - - - -
Preferred Stock - Non Redeemable, Net - - - -
Common Stock, Total 31,251.00 27,416.00 23,313.00 19,764.00
Additional Paid-In Capital - - - -
Retained Earnings (Accumulated Deficit) 96,364.00 92,284.00 87,152.00 104,256.00
Treasury Stock - Common - - - -
Other Equity, Total 596 -1,117.00 -282 -296
Total Equity 128,249.00 119,355.00 111,547.00 123,549.00
Total Liabilities & Shareholders' Equity 321,686.00 290,345.00 231,839.00 207,000.00

Answer Sheet

Name:
Section:
1. Working capital:
Calculate the following measures by entering each numerator and denominator.
Calculated
Ratio Numerator Denominator Value
2. Current ratio
3. Acid-Test (Quick) ratio
4. Accounts receivable turnover $0
5. Number of days' sales in receivables 365
6. Inventory turnover $0
7. Number of days' sales in inventory 365
8 Return on Common Stockholders' Equity $0
9. Debt to stockholders' equity
10. Number of times interest charges earned
https://finance.yahoo.com/q/is?s=BA+Income+Statement&annual
https://www.msn.com/en-us/money/stockdetails/financials/fi-126.1.BA.NYS
https://www.google.com/finance?q=NYSE%3ABA&fstype=ii&ei=Yuf9WLCiGcOqjAGTi7KYAg
https://finance.yahoo.com/q/is?s=BA+Income+Statement&annual https://www.msn.com/en-us/money/stockdetails/financials/fi-126.1.BA.NYS https://www.google.com/finance?q=NYSE%3ABA&fstype=ii&ei=Yuf9WLCiGcOqjAGTi7KYAg