Question

In: Accounting

Using the following information from an annual report, prepare a Common size (vertical analysis) of the...

Using the following information from an annual report, prepare a Common size (vertical analysis) of the consolidated statement of earnings for the fiscal year ended June 30, 2014. (Round percentage answers to one decimal place.)   2 points

(In millions)

Net sales

$18,862

Cost of sales

    10,321

Gross margin

$ 8,541

Selling expenses

General and Administrative expenses

$ 3,043

978

Total operating expenses

$ 4,021

Income from operations

$   4,520

Interest expense

(80)

         

Earnings before income taxes

$ 4,440

Income taxes

      (1,161)

Net earnings

$     3,279

Indicate on the blanks below the letter of the type of activity each of the following transactions represents.

(O = operating activity, I = investing activity, F = financing activity, N = noncash transaction) (8 points)

_____ 1. A corporation sold (issued) 8,000 shares of it’s own common stock for cash.

_____ 2. Sold $200,000 of plant assets for carrying value.(ie no gain or loss)

_____ 3. Paid $120,000 dividend to our shareholders.

_____ 4. Received $1,500 in interest income.

_____ 5. Exchanged 6,000 shares of stock for 15-year bonds.

_____ 6. Paid $121,000 to the IRS for income taxes.

_____ 7. Purchase of another company’s stock

_____ 8. Paying employees

Solutions

Expert Solution

Answer-

VERTICAL ANALYSIS
FOR THE YEAR ENDED JUNE 30,2014
$ in million
PARTICULARS AMOUNT PERCENT
$ $
Sales 18862 100.0
Less- Cost of sales 10321 54.7
Gross profit 8541 45.3
Less-Selling expenses 3043 16.1
General & Administrative expenses 978 5.2
Total operaing expenses 4021 21.3
Income before interest & income taxes 4520 24.0
Less- Interest expense 80 0.4
Income before income taxes 4440 23.5
Less- Income tax expense 1161 6.2
Net income 3279 17.4

Answer-

F 1 A corporation sold (issued) 8,000 shares of it’s own common stock for cash.
I 2 Sold $200,000 of plant assets for carrying value.(ie no gain or loss)
F 3 Paid $120,000 dividend to our shareholders.
O 4 Received $1,500 in interest income.
N 5 Exchanged 6,000 shares of stock for 15-year bonds.
O 6 Paid $121,000 to the IRS for income taxes.
I 7 Purchase of another company’s stock
O 8 Paying employees

Related Solutions

15. Using the following information from an annual report, prepare a Comparative (horizontal) analysis of the...
15. Using the following information from an annual report, prepare a Comparative (horizontal) analysis of the consolidated statements of earnings. (Round percentage answers to one decimal place.) 3 pts (In millions except per share data) June 30, 2010 June 30, 2009 Net sales $12,862 $11,170 Cost of sales     8,321     8,191 Gross margin $ 4,541 $ 2,979 Operating expenses: Selling expenses General and Administrative expenses $2,043     978      $2,000          955   Total operating expenses $ 3,021 $ 2,955...
1. Using Walt Disney Inc. Annual Report income statement, prepare a horizontal and vertical analysis on...
1. Using Walt Disney Inc. Annual Report income statement, prepare a horizontal and vertical analysis on years 2017 and 2016. 2. Perform the following ratios, Current, Debt, Return on Equity on years 2017 and 2016 https://www.thewaltdisneycompany.com/wp-content/uploads/2017-Annual-Report.pdf Return on common stockholders’ equity ratio. Return on asset ratio. Profit margin rate. Earnings per share. Debt to total asset ratio. Current ratio Average collection period. Receivables turnover ratio. Asset turnover ratio.
Prepare a vertical analysis or same size income statement and balance sheet for Pepsi and Coca...
Prepare a vertical analysis or same size income statement and balance sheet for Pepsi and Coca Cola for 2016 and 2017. Write a paragraph highlighting what you learn from the percentages of sales or total assets calculated from the financial statements. Write also about the comparison between 2016 and 2017 and between Coke and Pepsi.
2.) What is vertical analysis, and what is its purpose? What is the purpose of common-size...
2.) What is vertical analysis, and what is its purpose? What is the purpose of common-size statements?
Prepare common-size income statements for Wal-Mart and Starbucks using the January 2014 information for Walmart and...
Prepare common-size income statements for Wal-Mart and Starbucks using the January 2014 information for Walmart and your new pro forma September 2013 information for Starbucks provided in Problems 5 and 6.Which company is doing a better job of getting sales dollars to net income? Where is the one company having an advantage over the other company in turning revenue into net income? Wal-Mart Starbucks Account Jan. 31, 2013 Sep. 30, 2013 Sales $476,294 $14,892 COGS $358,069 $6,382 SG&A $91,763 $5,929...
Common-size financial statements. Prepare common-size income statements for Walmart and Starbucks using the January 2015 and...
Common-size financial statements. Prepare common-size income statements for Walmart and Starbucks using the January 2015 and September 2014 information in the popup window: LOADING... . Which company is doing a better job of getting sales dollars to net income? Where is the one company having an advantage over the other company in turning revenue into net income? Complete the table below: (Round to two decimal places. Net income to three decimal places.) Abbreviated Income Statements ($ in Millions) Company Walmart,...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and September 2014 information in the popup​ window: Which company is doing a better job of getting sales dollars to net​ income? Where is the one company having an advantage over the other company in turning revenue into net​ income? Complete the table​ below: (Round to two decimal places. Net income to three decimal​ places.) Abbreviated Income Statements ($ in Millions) Company Walmart, Inc. Starbucks...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and September 2014 information in the popup​ window:   LOADING... . Which company is doing a better job of getting sales dollars to net​ income? Where is the one company having an advantage over the other company in turning revenue into net​ income? Complete the table​ below:  ​(Round to two decimal places. Net income to three decimal​ places.) Abbreviated Income Statements ($ in Millions) Company Walmart,...
Using information from these web sites, along with other resources, prepare a report that addresses the...
Using information from these web sites, along with other resources, prepare a report that addresses the following issues for your selected country: (1) compare and contrast the corporate governance principles of your selected country with the United States, (2) identify the relevant corporate governance parties and their roles, (3) describe recent challenges related to the corporate governance for your selected country, and (4) list and describe recent corporate governance activities in your selected country.
Using the common size (vertical) balance sheet, identify the significant trends, and compare to the industry...
Using the common size (vertical) balance sheet, identify the significant trends, and compare to the industry standards. FY 2015 % FY 2014 % Industry ASSETS Cash and cash equivalents $                   4,046 10.05% $                   2,210 5.34% 4.20% Inventory                       8,601 21.36%                       8,790 21.23% 19.56% Assets of discontinued operations                          322 0.80%                       1,333 3.22% Other current assets                       1,161 2.88%                       1,754 4.24% 3.32% Total current assets $                 14,130 35.10% $                 14,087 34.02% 30.88% Property and equipment     Land                      ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT