help

B C E G A D F G H 1 Statements of Net Income and comprehensive Income 2 Vertical Analyses, Profitability Analyses 3 The Golden Fence Company and Stone Wall Corporation are competitors in manufacturing walls and fences. Their income 4 statements have been provided on the ENTERANSWERS tab. The other information follows: 5 Golden Fence Stone Wall Company Corporation 7 Average Total Assets $ 1,258,287 $ 102,211 8 Average Stockholders' Equity $ 654,3095 74,614 6 10 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you 11 will be marked wrong. 12 B A C D E E 1 1. Prepare common size income statements. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the instructions tab you 2 will be marked wrong.) 3 4 Percent of Sales Golden Fence Stone Wall Company Corporation s (amounts in millions) 6. Sales 7 Cost of Goods Sold 8 Gross Profit 9 Selling, General, and Administrative Expenses 10 Other Operating Expenses 11 Interest Expense 12 Earnings Before Provision for Taxes 13 Provision for Taxes 14 Net Income Golden Fence Stone Wall Company Corporation $ 987,236 S 67,450 678,626 43,370 308,610 24,080 58,636 2,408 12,344 722 24,689 193 212,941 20,757 74,529 7,265 $ 138,412 $ 13,492 D 2. Compute profit margin, return on assets, and return on stockholders' equity. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you -7 will be marked wrong. Use cell references from prior calculations, if applicable.) 18 Golden Fence Company Stone Wall Corporation 19 20 Profit Margin 21 Return on Assets 22 Return on Stockholders' Equity 23