$6$:$091$ m

$,$ l$65\%$

Week $10-$ Assignment: Horizontal and Vertical Analysis

Question $3$ of $3$

Selected hypothetical financial data of Target and Walmart for $2025$ are presented here $($in millions$).$

$\backslash$table$[[,\backslash$table$[[$Target$],[$Corporation$]],\backslash$table$[[$Walmart$],[$Inc$.]]],[,$Income Statement Data for Year$],[$Net sales,$$66,900,$$$417,000],[$Cost of goods sold,$44,000,308,000],[$Selling and administrative expenses,$14,400,79,000],[$Interest expense,$750,1,800],[$Other income $($expense$),(95),(400)],[$Income tax expense,$1,500,6,600],[$Net income,$$6,155,$$$21,200],[\backslash$table$[[$Balance Sheet Data$],[($End of Year$)]]],[,$$$17,000,$$$45,000],[$Noncurrent assets,$26,800,120,000],[$Total assets,$$43,800,$$$165,000],[$Current liabilities,$$10,000,$$$56,000],[$Long$-$term debt,$17,300,44,000],[$Total stockholders' equity,$16,500,65,000],[$Total liabilities and stockholders' equity,$$43,800,$$$165,000],[,$Beginning$-$of$-$Year Balances$],[$Total assets,$$43,000,$$$165,000],[$Total stockholders' equity,$13,400,64,000],[$Current liabilities,$10,000,56,000],[$Total liabilities,$29,600,101,000],[,$Other Data$],[$Average net accounts receivable,$$7,500,$$$3,900],[$Average inventory,$7,200,32,800],[$Net cash provided by operating activities,$5,500,25,900],[$Capital expenditures,$1,800,12,400],[$Cash dividends paid,$450,4,400]]$

$($a$)$ For each company, compute the following ratios. Assume all sales were on credit. $($Round current ratio answers to $2$ decimal places, e$.$g$.15\mathrm{.}50.$ Round debt to assets ratio to $0$ decimal places, e$.$g$.15\%.$ Enter free cash flow answers in millions. Round all other answers to $1$ decimal place, e$.$g$.1\mathrm{.}8$ or $1\mathrm{.}83\%.$ Use $365$ days for calculations.$)2$