Obtain the balance sheet and income statement from a company of your choice from their latest...

 

 

Transcribed Image Text:

Obtain the balance sheet and income statement from a company of your choice from their latest 10-K annual reports. This information is found on the SEC website (www.sec.gov). Access the Quick EDGAR tutorial. Click on "Companies and Other Filers." Fill in your company name one and find the 10-K. Look for companies that allow you to transfer their financial information to EXCEL (will have "Interactive Data"). Click on "View EXCEL Document" then SAVE. Open the file saved (remember to click on the tab for the statements). Cut and paste all years shown of the balance sheet and income statement into a new EXCEL spreadsheet. Omit any extraneous information (e.g., # shares of stock issued, outstanding, eps for other than the net income, etc.), Compute the ratios and financial analysis for each company as indicated below: 1. Horizontal analysis of the balance sheet and income statement (% change from year to year) for all the years presented. 2. Vertical analysis of the balance sheet and income statement for all years shown. 3. Ratio Analysis (Illustration 5A-1 p. 232) for two years for each company a. Current ratio b. Quick ratio c. Profit Margin on Sales d. Price-Earnings ratio (you will have to google stock price on the balance sheet date) e. Debt to Assets ratio SUBMIT THE FOLLOWING: 1. Spreadsheet pages with balance sheets and income statements in landscape format. 2. Ratio analysis and % change computations (may be on the spreadsheets above) 3. An analysis describing your company's health based on what you discovered in all of the analyses you performed (not just ratio analysis). CONSOLIDATED BALANCE SHEETS- USD ($) $ in Millions 2 Current assets: 3 Cash and cash equivalents 4 Marketable securities. 5 Accounts receivable, net i 6 Inventories 7 Vendor non-trade receivables 8 Other current assets 9 Total current assets 10 Non-current assets: 11 Marketable securities 12 Property, plant and equipment, net 13 Other non-current assets 14 Total non-current assets 15 Total assets 16 Current liabilities: 17 Accounts payable 18 Other current liabilities, 19 Deferred revenue 20 Commercial paper 21 Term debt 22 Total current liabilities. 23 Non-current liabilities: 24 Deferred revenue 25 Term debt 26 Other non current liabilities 27 Total non-current liabilities 28 Total liabilities 29 Commitments and contingencies 30 Shareholders' equity Ready CONSOLIDATED BALANCE SHEETS → CONSOLIDATED BALANCE SHEETS (Pa B Sep. 29, 2018 $25,913 40,388 23,186 3,956 25,809 12,087 131,339 170,799 41,304 22,283 234,386 365,725 55,888 32,687 7,543 11,964 8,784 116,866 2,797 93,735 45,180 141,712 258,578 Sep. 30, 2017 $ 20,289 53,892 17,874 4,855 17,799 13,936 128,645 194,714 33,783 18,177 246,674 375,319 44,242 30,551 7,548 11,977 6,496 100,814 2,836 97,207 40,415 140,458 241,272 D CONSOLIDATED STATEMENTS OF SHAR E 12 Property, plant and equipment, net 13 Other non-current assets 14 Total non-current assets. 15 Total assets 16 Current liabilities: 17 Accounts payable 18 Other current liabilities 19 Deferred revenue 20 Commercial paper 21 Term debt. 22 Total current liabilities 23 Non-current liabilities: 24 Deferred revenue 25 Term debt 26 Other non-current liabilities 27 Total non-current liabilities 28 Total liabilities 29 Commitments and contingencies 30 Shareholders' equity: Common stock and additional paid-in capital, 50.00001 par value: 12,600,000 shares authorized, 31 4,754,986 and 5,126,201 shares issued and outstanding, respectively 32 Retained earnings 33 Accumulated other comprehensive income/(loss) 34 Total shareholders' equity 35 Total liabilities and shareholders' equity 36 37 38 39 40 KA 4 Ready CONSOLIDATED BALANCE SHEETS CONSOLIDATED BALANCE SHEETS (Pa B 41,304 22,283 234,386 365,725 55,888 32,687 7,543 11,964 8,784 116,866 2,797 93,735 45,180 141,712 258,578 40,201 70,400 (1,454) 107,147 $365,725 C 33,783 18,177 246,674 375,319 44,242 30,551 7,548 11,977 6,496 100,814 2,836 97,207 40,415 140,458 241,272 35,867 98,330 (150) 134,047 $375,319 D CONSOLIDATED STATEMENTS OF SHAR E CONSOLIDATED STATEMENTS OF OPERATIONS- USD ($) shares in Thousands, $ in Millions 3 Income Statement [Abstract] 4 Net sales 5 Cost of sales 6 Gross margin 7 Operating expenses: 8 Research and development 9 Selling, general and administrative 10 Total operating expenses 11 Operating income 12 Other income/fexpense), net 13 Income before provision for income taxes 14 Provision for income taxes 15 Net income 16 Earnings per share: 17 Basic (in dollars per share) 18 Diluted (in dollars per share) 19 Shares used in computing earnings per share: 20 Basic (in shares) 21 Diluted (in shares) 22 23 24 25 26 27 28 29 30 Ready CONSOLIDATED STATEMENTS OF OPER CONSOLIDATED STATEMENTS OF COMP B Sep. 29, 2018 $ 265,595 163,756 101,839 14,236 16,705 30,941 70,898 2,005 72,903 13,372 $59,531 $12.01 $11.91 4,955,377 5,000,109 C 12 Months Ended Sep. 30, 2017 $229,234 141,048 88,186 11,581 15,261 26,842 61,344 2,745 64,089 15,738 $48,351 $9.27 $9.21 5,217,242 5,251,692 D Sep. 24, 2016 CONSOLIDATED STATEMENTS OF $215,639 131,376 84,263 10,045 14,194 24,239 60,024 1,348 61,372 15,685 $ 45,687 $8.35 $8.31 5,470,820 5,500,281 E Obtain the balance sheet and income statement from a company of your choice from their latest 10-K annual reports. This information is found on the SEC website (www.sec.gov). Access the Quick EDGAR tutorial. Click on "Companies and Other Filers." Fill in your company name one and find the 10-K. Look for companies that allow you to transfer their financial information to EXCEL (will have "Interactive Data"). Click on "View EXCEL Document" then SAVE. Open the file saved (remember to click on the tab for the statements). Cut and paste all years shown of the balance sheet and income statement into a new EXCEL spreadsheet. Omit any extraneous information (e.g., # shares of stock issued, outstanding, eps for other than the net income, etc.), Compute the ratios and financial analysis for each company as indicated below: 1. Horizontal analysis of the balance sheet and income statement (% change from year to year) for all the years presented. 2. Vertical analysis of the balance sheet and income statement for all years shown. 3. Ratio Analysis (Illustration 5A-1 p. 232) for two years for each company a. Current ratio b. Quick ratio c. Profit Margin on Sales d. Price-Earnings ratio (you will have to google stock price on the balance sheet date) e. Debt to Assets ratio SUBMIT THE FOLLOWING: 1. Spreadsheet pages with balance sheets and income statements in landscape format. 2. Ratio analysis and % change computations (may be on the spreadsheets above) 3. An analysis describing your company's health based on what you discovered in all of the analyses you performed (not just ratio analysis). CONSOLIDATED BALANCE SHEETS- USD ($) $ in Millions 2 Current assets: 3 Cash and cash equivalents 4 Marketable securities. 5 Accounts receivable, net i 6 Inventories 7 Vendor non-trade receivables 8 Other current assets 9 Total current assets 10 Non-current assets: 11 Marketable securities 12 Property, plant and equipment, net 13 Other non-current assets 14 Total non-current assets 15 Total assets 16 Current liabilities: 17 Accounts payable 18 Other current liabilities, 19 Deferred revenue 20 Commercial paper 21 Term debt 22 Total current liabilities. 23 Non-current liabilities: 24 Deferred revenue 25 Term debt 26 Other non current liabilities 27 Total non-current liabilities 28 Total liabilities 29 Commitments and contingencies 30 Shareholders' equity Ready CONSOLIDATED BALANCE SHEETS → CONSOLIDATED BALANCE SHEETS (Pa B Sep. 29, 2018 $25,913 40,388 23,186 3,956 25,809 12,087 131,339 170,799 41,304 22,283 234,386 365,725 55,888 32,687 7,543 11,964 8,784 116,866 2,797 93,735 45,180 141,712 258,578 Sep. 30, 2017 $ 20,289 53,892 17,874 4,855 17,799 13,936 128,645 194,714 33,783 18,177 246,674 375,319 44,242 30,551 7,548 11,977 6,496 100,814 2,836 97,207 40,415 140,458 241,272 D CONSOLIDATED STATEMENTS OF SHAR E 12 Property, plant and equipment, net 13 Other non-current assets 14 Total non-current assets. 15 Total assets 16 Current liabilities: 17 Accounts payable 18 Other current liabilities 19 Deferred revenue 20 Commercial paper 21 Term debt. 22 Total current liabilities 23 Non-current liabilities: 24 Deferred revenue 25 Term debt 26 Other non-current liabilities 27 Total non-current liabilities 28 Total liabilities 29 Commitments and contingencies 30 Shareholders' equity: Common stock and additional paid-in capital, 50.00001 par value: 12,600,000 shares authorized, 31 4,754,986 and 5,126,201 shares issued and outstanding, respectively 32 Retained earnings 33 Accumulated other comprehensive income/(loss) 34 Total shareholders' equity 35 Total liabilities and shareholders' equity 36 37 38 39 40 KA 4 Ready CONSOLIDATED BALANCE SHEETS CONSOLIDATED BALANCE SHEETS (Pa B 41,304 22,283 234,386 365,725 55,888 32,687 7,543 11,964 8,784 116,866 2,797 93,735 45,180 141,712 258,578 40,201 70,400 (1,454) 107,147 $365,725 C 33,783 18,177 246,674 375,319 44,242 30,551 7,548 11,977 6,496 100,814 2,836 97,207 40,415 140,458 241,272 35,867 98,330 (150) 134,047 $375,319 D CONSOLIDATED STATEMENTS OF SHAR E CONSOLIDATED STATEMENTS OF OPERATIONS- USD ($) shares in Thousands, $ in Millions 3 Income Statement [Abstract] 4 Net sales 5 Cost of sales 6 Gross margin 7 Operating expenses: 8 Research and development 9 Selling, general and administrative 10 Total operating expenses 11 Operating income 12 Other income/fexpense), net 13 Income before provision for income taxes 14 Provision for income taxes 15 Net income 16 Earnings per share: 17 Basic (in dollars per share) 18 Diluted (in dollars per share) 19 Shares used in computing earnings per share: 20 Basic (in shares) 21 Diluted (in shares) 22 23 24 25 26 27 28 29 30 Ready CONSOLIDATED STATEMENTS OF OPER CONSOLIDATED STATEMENTS OF COMP B Sep. 29, 2018 $ 265,595 163,756 101,839 14,236 16,705 30,941 70,898 2,005 72,903 13,372 $59,531 $12.01 $11.91 4,955,377 5,000,109 C 12 Months Ended Sep. 30, 2017 $229,234 141,048 88,186 11,581 15,261 26,842 61,344 2,745 64,089 15,738 $48,351 $9.27 $9.21 5,217,242 5,251,692 D Sep. 24, 2016 CONSOLIDATED STATEMENTS OF $215,639 131,376 84,263 10,045 14,194 24,239 60,024 1,348 61,372 15,685 $ 45,687 $8.35 $8.31 5,470,820 5,500,281 E

Answer rating: 100% (QA)

FEDEX COMPANY FedEx Corporation formerly Federal Express Corporation and later FDX Corporation is an American multinational conglomerate holding compa... View the full answer