HOW-TO: COMMON SIZE FINANCIAL STATEMENTS

Please help me solve for the blanks, I am using excel to solve so formulas would also be helpful.

Common-Size Financial Statements Abbreviated Income Statements (\$ in Millions) \begin{tabular}{|l|r|l|r|l|} \hline Company & Walmart, Inc. & & \multicolumn{1}{|l|}{ Starbucks } & \\ \hline Account & 1/31/15 & & 9/30/14 & \\ \hline Sales & $491,984 & ? & $16,780 & ? \\ \hline Cost of goods & ($370,593) & ? & ($7,167) & ? \\ \hline Selling, gener & ($94,603) & ? & ($11,545) & ? \\ \hline EBIT & $26,788 & ? & ($1,932) & ? \\ \hline Interest expe & ($2,277) & ? & ($17) & ? \\ \hline Taxes & ($9,069) & ? & $721 & ? \\ \hline Net income & $15,442 & ? & ($1,228) & ? \\ \hline \end{tabular} 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.)