Create Common Size Financial Statements for both companies and both years.

Divide all Balance Sheet accounts by Total Assets. Divide all Income Statement accounts by Total Revenue.

 

Transcribed Image Text:

5 6 7 Common Size Balance Sheet 8 9 Cash 10 Accounts Receivable 11 Inventories - Total 12 Other Current Assets 13 Current Assets - Total 14 15 Prop, Plant & Equipment (Gros 16 Accumulated Depreciation 17 Prop, Plant & Equipment(Net) 18 Other NonCurrent Assets 19 Assets - Total 20 21 22 Accounts Payable - Trade 23 Other Current Liabilities 24 Current Liabilities - Total 25 26 NonCurrent Liabilities 27 Liabilities - Total 28 29 Total Equity 34 25 Rovanua Intal 4 Ready Sheet1 Accessibility: Investigate Q Search Your Company 1: APPLIED MATERIALS INC + 2020 Dollars 5,351 3,111 D 3,904 1,003 13,369 4,632 (2,776) 1,856 7,128 4,463 3,474 6,854 962 5,085 10,206 26,291 20,556 4,071 13,174 12,758 (2,542) (5,157) (4,795) 1,529 8,017 7,963 7,289 3,432 2,823 19,024 37,740 31,342 101 958 2,836 2,248 3,489 6,838 6,036 4,447 9,674 8,284 6,363 15,299 15,003 10,810 24,973 23,287 8,214 12,767 37,740 22,353 1,124 30 31 Liabilities and Stockholders Eq 22,353 32 33 3,335 4,459 7,316 11,775 10,578 2020 Dollars 17.202 2019 Common Commo nSize Dollars Size 3,129 PRE 2,641 19,024 2019 Commo nSize Dollars Common Size % Change HA %Change Your Company 2: O 2020 Common Dollars Size 9,889 B 2020 Common Dollars Size AA 520 NIKE INC-CLB 2019 Commo Dollars nSize 8,348 2,749 7,367 2,092 8,055 31,342 2019 Dollars 27 102 Commo nSize 121% A + C 1:1 7 Screenshot (4).png G46 4 32 83 A 34 35 Revenue - Total 36 Cost of Goods Sold 37 Gross Profit (Loss) 38 39 Selling, Gen and Admin Expen: 40 R&D Expense 41 "Operating Income" 42 43 Other (Gain)/Loss Net 44 Interest Expense 45 Pretax Income 46 Income Taxes - Total 47 "Other" <---Dave Plug 48 Net Income (Loss) 49 2020 Ratios Only 50 Current Ratio 51 Working Capital 52 Accounts Receivable Turnover 53 Average Collection Period 54 Inventory Turnover 55 Days Inventory Held 56 57 Debt To Assets 58 Debt to Equity 59 Times Interest Earned 50 61 Asset Turnover 52 Return on Assets 63 Return on Equity 54 55 2020 17,202 9,130 8,072 3,221 2,234 2,617 Commo Common Dollars nSize Dollars Size 14,608 7,859 6,749 (1,756) 207 4,166 547 3,619 D Company 1 2019 3,014 2,054 1,681 (1,825) 237 3,269 563 E 2,706 (Ctrl)- F G %Change H T 2020 Common Dollars Size 44,538 23,797 20,741 12,811 7,930 973 296 6,661 934 5,727 Company 2 K 2019 Commo Dollars InSize 37,403 20,441 16,962 13,126 3,836 798 151 2,887 348 L M 2,539 N %Change Which is better? Company 1 or Do Not Use Do Not Use 5 6 7 Common Size Balance Sheet 8 9 Cash 10 Accounts Receivable 11 Inventories - Total 12 Other Current Assets 13 Current Assets - Total 14 15 Prop, Plant & Equipment (Gros 16 Accumulated Depreciation 17 Prop, Plant & Equipment(Net) 18 Other NonCurrent Assets 19 Assets - Total 20 21 22 Accounts Payable - Trade 23 Other Current Liabilities 24 Current Liabilities - Total 25 26 NonCurrent Liabilities 27 Liabilities - Total 28 29 Total Equity 34 25 Rovanua Intal 4 Ready Sheet1 Accessibility: Investigate Q Search Your Company 1: APPLIED MATERIALS INC + 2020 Dollars 5,351 3,111 D 3,904 1,003 13,369 4,632 (2,776) 1,856 7,128 4,463 3,474 6,854 962 5,085 10,206 26,291 20,556 4,071 13,174 12,758 (2,542) (5,157) (4,795) 1,529 8,017 7,963 7,289 3,432 2,823 19,024 37,740 31,342 101 958 2,836 2,248 3,489 6,838 6,036 4,447 9,674 8,284 6,363 15,299 15,003 10,810 24,973 23,287 8,214 12,767 37,740 22,353 1,124 30 31 Liabilities and Stockholders Eq 22,353 32 33 3,335 4,459 7,316 11,775 10,578 2020 Dollars 17.202 2019 Common Commo nSize Dollars Size 3,129 PRE 2,641 19,024 2019 Commo nSize Dollars Common Size % Change HA %Change Your Company 2: O 2020 Common Dollars Size 9,889 B 2020 Common Dollars Size AA 520 NIKE INC-CLB 2019 Commo Dollars nSize 8,348 2,749 7,367 2,092 8,055 31,342 2019 Dollars 27 102 Commo nSize 121% A + C 1:1 7 Screenshot (4).png G46 4 32 83 A 34 35 Revenue - Total 36 Cost of Goods Sold 37 Gross Profit (Loss) 38 39 Selling, Gen and Admin Expen: 40 R&D Expense 41 "Operating Income" 42 43 Other (Gain)/Loss Net 44 Interest Expense 45 Pretax Income 46 Income Taxes - Total 47 "Other" <---Dave Plug 48 Net Income (Loss) 49 2020 Ratios Only 50 Current Ratio 51 Working Capital 52 Accounts Receivable Turnover 53 Average Collection Period 54 Inventory Turnover 55 Days Inventory Held 56 57 Debt To Assets 58 Debt to Equity 59 Times Interest Earned 50 61 Asset Turnover 52 Return on Assets 63 Return on Equity 54 55 2020 17,202 9,130 8,072 3,221 2,234 2,617 Commo Common Dollars nSize Dollars Size 14,608 7,859 6,749 (1,756) 207 4,166 547 3,619 D Company 1 2019 3,014 2,054 1,681 (1,825) 237 3,269 563 E 2,706 (Ctrl)- F G %Change H T 2020 Common Dollars Size 44,538 23,797 20,741 12,811 7,930 973 296 6,661 934 5,727 Company 2 K 2019 Commo Dollars InSize 37,403 20,441 16,962 13,126 3,836 798 151 2,887 348 L M 2,539 N %Change Which is better? Company 1 or Do Not Use Do Not Use

Answer rating: 100% (QA)

To create common size financial statements for both companies in both years you need to convert the ... View the full answer