Instructions Print an Income Statement (sometimes called Statement of Operations
ID: 2490485 • Letter: I
Question
Instructions Print an Income Statement (sometimes called Statement of Operations), Balance Sheet (sometimes call ometimes called Statement of Financial Position) and Statement of Stockholders quity from any publicly traded company. Your printed financial statements must be for an entire year. Select the most recent year you can find. You will not need the Cash Flow Statement. Id eally you can select a company that has accounts receivable and inventory 1. Horizontal Analysis Compare the two most recent years on the Balance Sheet. Instructions are found in chapter 14 of the textbook. If there is enough room, you can do your work on the pages you printed from the internet. 2. Vertical Analysis Find the Income Statement. Using net sales as 100%, (if net sales is not shown, use total sales) calculate the percentage of the other amounts down to net income. Any amounts shown below net income can be used with no calculations. Chapter 14 shows how to do this. The most recent year is enough 3. Ratio Analysis Using all three financial statements and the instructions in Chapter 14, see how mucih information you can find for the 13 ratios. You can ask me questions about which accounts to use. Remember that not all companies will have every possible account. Show at least 8 of the 13 ratios described in the chapter. If one has two parts, it counts as two. 4. Your summary of what you learned. Write about what you think the analysis tells you about the company. You are a beginner and your job is to learn and have fun, not worry about being perfect. Your paragraph or paragraphs should be about ½ page printed double spaced or 1 page, hand written. Once you complete your own financial statement analysis, help other students find the account balances on their company financial statements.Explanation / Answer
Answer: For the purpose of calculation financial data of Apple Inc taken from SEC website.
1) Horizontal analysis of balance sheet
CONSOLIDATED BALANCE SHEETS - USD ($)
Answer (2)
Vertical analysis of income statement
CONSOLIDATED STATEMENTS OF OPERATIONS - USD ($)
Answer 3
Following is cashflow of company
CONSOLIDATED STATEMENTS OF CASH FLOWS - USD ($)
Now which ratios you require is not given in question, so I will provide you some general ratios from above noted information for year ended on september, 2015
Gross profit ratio = Gross margin/total net sales = 93,626/233,715 = 40%
Net profit ratio = Net income/total net sales = 53,394/233,715 = 23%
Inventory turnover ratio = cost of sales/inventory = 140,089/2349 = 59.63
receivable turnover ratio = sales/account receivable = 233,715/16,849 = 13.87
Earning per share = total net income/no. of shares outstanding = already given in income statement = basic EPS = $ 9.28 per share
Answer 4:
From analysis of Apple Inc's financial statements, I have annalysed following points
1) Operating income of company increased by 8% & sales of company increased by 28%, this indicates good performance from company in year ended on september 2015
2) Gross margin of company is improved by 10%, which indicates operating efficiency increased in last fiancial year
3) Basic Earning per share of company increased to $ 9.28 from $ 6.49 last year, such increase indicates company has added value to shareholder's fund.
APPLE INC : CIK 0000320193CONSOLIDATED BALANCE SHEETS - USD ($)
Sep. 26, 2015 Sep. 27, 2014 $ in Millions % change in amount of year ending on 2015 from year ended on 2014 Variance (amount in 2015 - amount in 2014) Current assets: Cash and cash equivalents $21,120 $13,844 53% $7,276 Short-term marketable securities 20,481 11,233 82% $9,248 Accounts receivable, less allowances of $82 and $86, respectively 16,849 17,460 -3% ($611) Inventories 2,349 2,111 11% $238 Deferred tax assets 5,546 4,318 28% $1,228 Vendor non-trade receivables 13,494 9,759 38% $3,735 Other current assets 9,539 9,806 -3% ($267) Total current assets 89,378 68,531 30% $20,847 Long-term marketable securities 164,065 130,162 26% $33,903 Property, plant and equipment, net 22,471 20,624 9% $1,847 Goodwill 5,116 4,616 11% $500 Acquired intangible assets, net 3,893 4,142 -6% ($249) Other assets 5,556 3,764 48% $1,792 Total assets 290,479 231,839 25% $58,640 Current liabilities: Accounts payable 35,490 30,196 18% $5,294 Accrued expenses 25,181 18,453 36% $6,728 Deferred revenue 8,940 8,491 5% $449 Commercial paper 8,499 6,308 35% $2,191 Current portion of long-term debt 2,500 0 2500% $2,500 Total current liabilities 80,610 63,448 27% $17,162 Deferred revenue, non-current 3,624 3,031 20% $593 Long-term debt 53,463 28,987 84% $24,476 Other non-current liabilities 33,427 24,826 35% $8,601 Total liabilities $171,124 $120,292 42% $50,832 Commitments and contingencies $0 Shareholders' equity: $0 Common stock and additional paid-in capital, $0.00001 par value: 12,600,000 shares authorized; 5,578,753 and 5,866,161 shares issued and outstanding, respectively $27,416 $23,313 18% $4,103 Retained earnings 92,284 87,152 6% $5,132 Accumulated other comprehensive income -345 1,082 -132% ($1,427) Total shareholders' equity 119,355 111,547 7% $7,808 Total liabilities and shareholders' equity $290,479 $231,839 25% $58,640