50.1K

Verified Solution

Link Copied!

2. Complete a vertical and horizontal analysis on the tabs labeled "Balance Sheet" and "Income Statement". Use Total Assets as your base on the balance sheet to compare assets and Total Liabilities and Shareholders Equity as your base for liabilities. Use Net Sales on the income statement for your vertical analysis.

3. Using the balance sheet and income statement, complete the ratios on the tab labeled "Ratios."

(there is no #1)

Instructions Consolidated_Balance_Sheets Consolidated_Statements_of_ans Ratios Mease Complete the Following: vertical analysis. \begin{tabular}{|c|c|c|c|c|c|} \hline Consolidaied Balance Shects (USD S) & \multirow{2}{*}{ Feb. 01, 2015} & \multirow{2}{*}{ Vertical Analysks } & \multirow{2}{*}{ Feb. 01, 2014} & \multirow{2}{*}{ Vertical Anabysis } & \multirow{2}{*}{ Horizental Analysis } \\ \hline In Millions, ueless otherwise specified & & & & & \\ \hline \multicolumn{6}{|l|}{ Current Assets: } \\ \hline Cash and Cash Equivalents. & $1,723 & & $1,929 & & \\ \hline Receivallex, net & 1.484 & & 1,398 & & \\ \hline Merchandise lnventories & 11,079 & & 11,057 & & \\ \hline Other Current Assets. & 1.016 & & 895 & & \\ \hline Total Current Assets & 15,402 & & 15,279 & & \\ \hline Propeity and Equipesent, at cost & 38,513 & & 39,064 & & \\ \hline \begin{tabular}{l} Less Accumulated Deperciation and \\ Amortization \end{tabular} & 15,793 & & 15,716 & & \\ \hline Net Preperty and Equipment & 22,720 & & 23,348 & & \\ \hline Gooduill & 1,353 & & 1,289 & & \\ \hline Other Asses & $71 & & 602 & & \\ \hline Total Assets & 39,946 & & 40.518 & & \\ \hline \multicolumn{6}{|l|}{ Current L.iabalities: } \\ \hline Shori-Teris Debt & 200 & & 0 & & \\ \hline Accounts Payable & 5,807 & & 5,797 & & \\ \hline Accreed Salaries and Related Evpenses & 1.391 & & 1,428 & & \\ \hline Sales Taves Payable & 43 & & 396 & & \\ \hline Deferred Revenue & 1.468 & & 1.337 & & \\ \hline Incone Taves Payable & 35 & & 12 & & \\ \hline Carrent Insialimeses of Long-Term Debt & 38 & & 33 & & \\ \hline Other Accrued Espenses & 1,006 & & 1.746 & & \\ \hline & 11.269 & & 10,749 & & \\ \hline Long-Term Debt, cucluding current insallments & 16.869 & & 14,691 & & \\ \hline Other Lone-Term Liabilities & 1,44 & & 2,042 & & \\ \hline Deferrad Income Taxes & 642 & & 514 & & \\ \hline Toul Liabilition & 80.624 & & 27,906 & & \\ \hline \\ \hline \\ \hline Paid-Is Capital & 8,85 & & R, 402 & & \\ \hline Retained Farnings & 26,995 & & 23,10 & & \\ \hline \begin{tabular}{l} Accumulatd Other Comprehnsive (Loss) \\ lnconpe \end{tabular} & -452 & & 46 & & \\ \hline \begin{tabular}{l} Treasury Sbock, at cosi, 461 millien shares at \\ Febraary 1, 2015 and 381 million shares at \\ February 2.2014 \end{tabular} & 26,194 & & 19,194 & & \\ \hline Teal Slockholdenatrev Fquily & 9,322 & & 12,522 & & \\ \hline Tocal Liabilitives and Siockholders' Esuity & $39,946 & & 540,518 & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{|c|} Consolidated Statements of Earaings (USD \$) \\ In Millions, execpt Per Share data, unless \\ otherwise speciffed \\ \end{tabular}} & \multicolumn{3}{|c|}{12 Montlis Ended } & \multirow[b]{2}{*}{ Vertical Analysis } & \multirow[b]{2}{*}{ Horimatal Analysin } \\ \hline & Feb. 01.2015 & Vertical Analysis & Fich. 02, 2014 & & \\ \hline \multicolumn{6}{|l|}{ Inconse Statement [Nbstract] } \\ \hline Ceot of Sales & 34,222 & & 51,422 & & \\ \hline GROSS PROFIT & 28,054 & & 27,390 & & \\ \hline \multicolumn{6}{|l|}{ Operating Expenses: } \\ \hline Deperciation and Amortization & 1,651 & & 1,627 & & \\ \hline Tesal Operating Expenses & 18.485 & & 18,224 & & \\ \hline OPLRAIING ENCOME & 10,469 & & 9.166 & & \\ \hline \multicolumn{6}{|l|}{ Iniersut and Other (Inceme) Expense: } \\ \hline Inierest and Investment fincome. & -337 & & -12 & & \\ \hline Interest Evpense & 830 & & 711 & & \\ \hline Other & 0 & & 0 & & \\ \hline Inicrest and Othes, net & 493 & & 690 & & \\ \hline Frovisive for ficeme Tase & 1,631 & & 3,02 & & \\ \hline NIT IAIININGS & 56.345 & & 35.3R5 & & \\ \hline & 1.388 & & 1.425 & & \\ \hline IISIC EAKNINGSPEK SHARI & 54,74 & & 33.7x & & \\ \hline Diluted Weiyhied Awerage Common Shares & 1,346 & & 1,434 & & \\ \hline DLLOTDRARNINGS FHR SHRRI & 3,71 & & 33,76 & & \\ \hline [1] & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline Ratio Analysis & 2015 Ratios \\ \hline Carrent Ratio & & \\ \hline Inventory Turnover Ratio & & \\ \hline Dedbo to Equiry Ratio & & \\ \hline Return em Assets & & \\ \hline Asset Turnover Ratio & & \\ \hline Profit Margin Ratio & & \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer