Below are three documents the two excel worksheets are complete they are just there to help answer the questions in the word document. SO basically all i need help on is the word document, answering short answers.

ACCT 100 Financial Statement Project Use the attached financial statements and the company's main corporate web-site (not the retail web-site) to answer the following questions: 1. What type of business is each company? How do you know this? What things in industry or the economy are impacting the operations of this company? 2. Compare 2-3 accounts on the balance sheet between the companies. Discuss the accounts and what they mean. 3. Compare 2-3 accounts on the income statement between the companies. Discuss the accounts and what they mean. 4. What key items from these financial statements do you feel are important for an interested person to learn about? Hint: Level of liabilities vs. equity, net income or loss, gross profit. Along with this, how would you explain the importance of these financial statements to a friend who hasn't had accounting before? 5. Compute and discuss the following ratios. Did the ratios or percentages improve from the previous year or decline? Do you see any trends in the financial statements that may cause these ratios to improve or decline? Current Ratio - Current Assets/Current Liabilities Return on Assets - Net Income/Total Assets Return on Equity - Net Income/Total Equity Common-sized analysis - (% of sales or % of assets) (These are completed in the attached financial statements - you will just need to evaluate). How does the gross profit percentage compare to the net profit percentage? Would you expect these to be different? Why? Horizontal Analysis - (year-to-year trends) (These are completed in the attached financial statements - you will just need to evaluate). Do you feel the companies are improving or declining? 5. Overall, which company do you think is performing better? List two to three reasons why you think this. ACCT 100 Financial Statement Project Go to the discussion board and post your answers to these questions. Read two classmates responses and reply. Consolidated Statements of Operations (USD $) In Millions, except Per Share data, unless otherwise specified Income Statement [Abstract] Sales Credit card revenues Total revenues Cost of sales Gross Profit Selling, general and administrative expenses Credit card expenses Depreciation and amortization Gain on receivables transaction Earnings from continuing operations before interest expense and income taxes Net interest expense Earnings from continuing operations before income taxes Provision for income taxes Net earnings from continuing operations Discontinued operations, net of tax Net (loss)/earnings Basic (loss)/earnings per share 12 Months Ended Jan. 31, 2015 % of Total Revenues Feb. 01, 2014 % of Total Revenues $72,618 0 72,618 51,278 21,340 100% 0% 100% 71% 29% $71,279 0 71,279 50,039 21,240 100% 0% 100% 70% 30% 14,676 0 2,129 0 20% 0% 3% 0% 14,465 0 1,996 -391 20% 0% 3% -1% 4,535 882 6% 1% 5,170 1,049 7% 1% 3,653 1,204 2,449 -4,085 ($1,636) 5% 2% 3% -6% -2% 4,121 1,427 2,694 -723 $1,971 6% 2% 4% -1% 3% of Total Feb. 02, 2013 % Revenues $ change % of change $71,960 1,341 73,301 50,568 22,733 98% 2% 100% 69% 31% $658 ($1,341) ($683) $710 ($1,393) 1% -100% -1% 1% -6% 14,643 467 2,044 -161 20% 1% 3% 0% $33 ($467) $85 $161 0% -100% 4% -100% 5,740 684 8% 1% ($1,205) $198 -21% 29% 5,056 1,741 3,315 -316 $2,999 7% 2% 5% 0% 4% ($1,403) ($537) ($866) ($3,769) ($4,635) -28% -31% -26% 1193% -155% Consolidated Statements of Financial Position (USD $) In Millions, unless otherwise specified Assets Cash and cash equivalents, including shortterm investments of $1,520 and $3 Inventory Assets of discontinued operations Other current assets Total current assets Property and equipment Land Buildings and improvements Fixtures and equipment Computer hardware and software Construction-in-progress Accumulated depreciation Property and equipment, net Noncurrent assets of discontinued operations Other noncurrent assets Total assets Liabilities and shareholders' investment Accounts payable Accrued and other current liabilities Current portion of long-term debt and other borrowings Liabilities of discontinued operations Total current liabilities Long-term debt and other borrowings Deferred income taxes Noncurrent liabilities of discontinued operations Other noncurrent liabilities Total noncurrent liabilities Shareholders' investment Total shareholders' investment Total liabilities and shareholders' investment Jan. 31, 2015 $2,210 8,790 1,333 1,754 14,087 6,127 26,614 5,346 2,553 424 -15,106 25,958 442 917 41,404 % of Assets 5% 21% 3% 4% 34% 0% 15% 64% 13% 6% 1% -36% 63% % of Feb. 01, 2014 Assets $670 8,278 793 1,832 11,573 6,143 25,984 5,199 2,395 757 -14,066 26,412 5,461 1,107 44,553 7,759 3,783 1% 2% 100% 0% 19% 9% 91 103 11,736 12,705 1,321 193 1,452 15,671 2% 19% 2% 4% 26% 0% 14% 58% 12% 5% 2% -32% 59% $ change $1,540 $512 $540 ($78) $2,514 ($16) $630 $147 $158 ($333) ($1,040) ($454) ($5,019) ($190) ($3,149) 7,335 3,610 12% 2% 100% 0% 16% 8% 0% 0% 28% 31% 3% 1,143 689 12,777 11,429 1,349 3% 2% 29% 26% 3% ($1,052) ($586) ($1,041) $1,276 ($28) 1,296 1,471 15,545 16,231 3% 3% 35% 0% 36% ($1,103) ($19) $126 13,997 0% 4% 38% 0% 34% $41,404 100% $44,553 100% ($3,149) $424 $173 ($2,234) % of change 230% 6% 68% -4% 22% 0% 2% 3% 7% -44% 7% -2% -92% -17% -7% 6% 5% -92% -85% -8% 11% -2% -85% -1% 1% -14% -7% Consolidated Statements of Financial Position (Parenthetical) (USD $) In Millions, except Share data, unless otherwise specified Statement of Financial Position [Abstract] Cash and cash equivalents, short-term investments Common Stock, shares authorized Common Stock, par value (in dollars per share) Common Stock, shares issued Common Stock, shares outstanding Preferred Stock, shares authorized Preferred Stock, par value (in dollars per share) Preferred Stock, shares issued Preferred Stock, shares outstanding Jan. 31, 2015 Feb. 01, 2014 $1,520 $3 6,000,000,000 6,000,000,000 $0.08 640,213,987 640,213,987 5,000,000 $0.08 632,930,740 632,930,740 5,000,000 $0.01 0 0 $0.01 0 0 Consolidated Statements of Cash Flows (USD $) In Millions, unless otherwise specified Operating activities Net (loss)/earnings Losses from discontinued operations, net of tax Net earnings from continuing operations Adjustments to reconcile net earnings to cash provided by operations: Depreciation and amortization Share-based compensation expense Deferred income taxes Gain on receivables transaction Loss on debt extinguishment Noncash losses/(gains) and other, net (a) Changes in operating accounts: Accounts receivable originated at Target Proceeds on sale of accounts receivable originated at Target Inventory Other assets Accounts payable and accrued liabilities Cash provided by operating activitiesb_x0014_continuing operations Cash required for operating activitiesb_x0014_discontinued operations Cash provided by operations Investing activities Expenditures for property and equipment Proceeds from disposal of property and equipment Change in accounts receivable originated at third parties Proceeds from sale of accounts receivable originated at third parties Cash paid for acquisitions, net of cash assumed Other investments Cash (required for)/ provided by investing activitiesb_x0014_continuing operations Cash required for investing activitiesb_x0014_discontinued operations Cash required for investing activities Financing activities Change in commercial paper, net Reductions of short-term debt Additions to long-term debt Jan. 31, 2015 ($1,636) -4,085 2,449 2,129 71 7 0 285 40 0 0 -512 -115 777 5,131 -692 4,439 -1,786 95 0 0 -20 106 -1,605 -321 -1,926 -80 0 1,993 Reductions of long-term debt Dividends paid Repurchase of stock Stock option exercises and related tax benefit Other Cash required for financing activities Effect of exchange rate changes on cash and cash equivalents Net increase/(decrease) in cash and cash equivalents Cash and cash equivalents at beginning of period Cash and cash equivalents at end of period Supplemental information Interest paid, net of capitalized interest Income taxes paid Property and equipment acquired through capital lease obligations -2,079 -1,205 0 373 0 -998 0 1,515 695 2,210 871 1,251 $88 [1] Includes net write-offs of credit card receivables prior to the sale of our U.S. 2, 2013. [2] [3] Includes cash of our discontinued operations of $25 million, $59 million and Includes cash of our discontinued operations of $25 million and $59 million f 12 Months Ended Feb. 01, 2014 n. 31, 2015 $1,971 -723 2,694 [1] 1,996 106 58 -391 445 121 [1] 157 2,703 -504 -79 213 7,519 -999 6,520 -1,886 70 121 3,002 -157 130 1,280 -1,551 -271 -890 0 0 -3,463 -1,006 -1,461 456 0 -6,364 26 -89 [2],[3] 784 [2],[3] [3] 695 [2],[3] 1,043 1,386 $132 ard receivables prior to the sale of our U.S. consumer credit card receivables on March 13, 2013, and bad debt expense on credit card d operations of $25 million, $59 million and $98 million for 2014, 2013 and 2012, respectively. d operations of $25 million and $59 million for 2013 and 2012, respectively. Feb. 02, 2013 $2,999 -316 3,315 2,044 102 67 -161 0 220 [1] -217 0 160 -155 193 5,568 -243 5,325 -2,346 66 254 0 0 102 -1,924 -931 -2,855 970 -1,500 1,971 -1,529 -869 -1,875 360 -16 -2,488 8 -10 794 [2] 784 [2],[3] 697 1,603 $251 d debt expense on credit card receivables during the twelve months ended February Consolidated Statements of Cash Flows (Parenthetical) (USD $) In Millions, unless otherwise specified Statement of Cash Flows [Abstract] Cash and cash equivalents, discontinued operations Jan. 31, 2015 Feb. 01, 2014 Feb. 02, 2013 $25 $59 $98 Consolidated Statements of Shareholders' Investment (USD $) In Millions, except Share data, unless Jan. 31, 2015 otherwise specified Increase (Decrease) in Stockholders' Equity Balance Balance (in shares) Net (loss)/income Other comprehensive income Dividends declared Repurchase of stock Repurchase of stock (in shares) Stock options and awards Balance Balance (in shares) Common Stock Increase (Decrease) in Stockholders' Equity Balance Balance (in shares) Repurchase of stock Repurchase of stock (in shares) Stock options and awards Stock options and awards (in shares) Balance Balance (in shares) Additional Paid-in Capital Increase (Decrease) in Stockholders' Equity Balance Stock options and awards Balance Retained Earnings Increase (Decrease) in Stockholders' Equity Balance Net (loss)/income Dividends declared Repurchase of stock Balance Accumulated Other Comprehensive Income/ (Loss) 3 Months Ended 3-May-14 $16,231 632,930,740 -2,640 418 13,997 640,213,987 Feb. 01, 2014 4-May-13 $16,558 520 498 16,231 632,930,740 53 632,900,000 53 640,200,000 54 645,300,000 53 632,900,000 4,470 4,899 3,925 4,470 12,599 9,644 13,155 12,599 Increase (Decrease) in Stockholders' Equity Balance Other comprehensive income Balance -891 ($599) -576 ($891) 12 Months Ended Jan. 31, 2015 Feb. 01, 2014 Feb. 02, 2013 $16,231 632,930,740 -1,636 292 -1,273 -46 -800,000 429 13,997 640,213,987 $16,558 $15,821 1,971 -315 -1,051 -1,478 -21,900,000 546 16,231 632,930,740 2,999 105 -903 -1,903 -32,200,000 439 16,558 8,100,000 53 640,200,000 54 645,300,000 -2 -21,900,000 1 9,500,000 53 632,900,000 56 669,300,000 -3 -32,200,000 1 8,200,000 54 645,300,000 4,470 429 4,899 3,925 545 4,470 3,487 438 3,925 12,599 -1,636 -1,273 -46 9,644 13,155 1,971 -1,051 -1,476 12,599 12,959 2,999 -903 -1,900 13,155 -891 292 ($599) -576 -315 ($891) -681 105 ($576) 53 632,900,000 -800,000 Consolidated Statements of Shareholders' Investment (Parenthetical) (USD $) 3 Months Ended Jan. 31, 2015 Nov. 01, 2014 Aug. 02, 2014 3-May-14 Statement of Stockholders' Equity [Abstract] Dividends declared per share (in dollars per share) $0.52 $0.52 $0.52 $0.43 3 Months Ended 12 Months Ended Feb. 01, 2014 Nov. 02, 2013 Aug. 03, 2013 4-May-13 Jan. 31, 2015 Feb. 01, 2014 Feb. 02, 2013 $0.43 $0.43 $0.43 $0.36 $1.99 $1.65 $1.38 Consolidated Statements Of Income (USD $) In Millions, except Per Share data, unless otherwise specified Revenues: Net sales Membership and other income Total revenues Costs and expenses: Cost of sales Gross Profit Operating, selling, general and administrative expenses Operating income Interest: Debt Capital leases Interest income Interest, net Income from continuing operations before income taxes Provision for income taxes: Total provision for income taxes Income from continuing operations Income from discontinued operations, net of income taxes Consolidated net income Less consolidated net income attributable to noncontrolling interest Net Income 12 Months Ended Jan. 31, 2015 % of Total Revenues Jan. 31, 2014 % of Total Revenues Jan. 31, 2013 % of Total $ Change Revenues % of change $482,229 3,422 485,651 99% 1% 100% $473,076 3,218 476,294 99% 1% 100% $465,604 3,047 468,651 99% $16,625 1% $375 100% $17,000 4% 12% 4% 365,086 120,565 75% 25% 358,069 118,225 75% 25% 352,297 116,354 75% $12,789 25% $4,211 4% 4% 93,418 27,147 19% 6% 91,353 26,872 88,629 27,725 19% 6% $4,789 ($578) 5% -2% 2,161 300 -113 2,348 0% 0% 0% 0% 2,072 263 -119 2,216 19% 6% 0% 0% 0% 0% 0% 1,977 272 -186 2,063 0% 0% 0% 0% $184 $28 $73 $285 9% 10% -39% 14% 24,799 5% 24,656 25,662 5% ($863) -3% 7,985 16,814 2% 3% 8,105 16,551 5% 0% 2% 3% 7,958 17,704 2% 4% $27 ($890) 0% -5% 285 17,099 0% 4% 144 16,695 0% 4% 52 17,756 0% 4% $233 ($657) 448% -4% -736 $16,363 0% 3% -673 $16,022 0% 3% -757 $16,999 0% 4% $21 ($636) -3% -4% Consolidated Balance Sheets (USD $) Jan. 31, 2015 In Millions, unless otherwise specified Current assets: Cash and cash equivalents Receivables, net Inventories Prepaid expenses and other Current assets of discontinued operations Total current assets Property and equipment: Property and equipment, net Property under capital leases: Property under capital leases, net Goodwill Other assets and deferred charges Total assets Current liabilities: Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Obligations under capital leases due within one year Current liabilities of discontinued operations Total current liabilities Long-term debt Long-term obligations under capital leases Deferred income taxes and other Redeemable noncontrolling interest Commitments and contingencies Equity: Total equity Total liabilities, redeemable noncontrolling interest, and equity % of Assets Jan. 31, 2014 % of Assets $9,135 6,778 45,141 2,224 0 63,278 4% 3% 22% 1% 0% 31% $7,281 6,677 44,858 1,909 460 61,185 4% 3% 22% 1% 0% 30% 114,280 56% 115,364 56% 2,375 18,102 5,671 203,706 1% 9% 3% 100% 2,543 19,510 6,149 204,751 1% 10% 3% 100% 1,592 38,410 19,152 1,021 4,810 1% 19% 9% 1% 2% 7,670 37,415 18,793 966 4,103 4% 18% 9% 0% 2% 287 0% 309 0% 0 65,272 41,086 2,606 8,805 0 0% 32% 20% 1% 4% 0% 89 69,345 41,771 2,788 8,017 1,491 0% 34% 20% 1% 4% 1% 85,937 42% 81,339 40% $203,706 100% $204,751 100% % of $ change change $1,854 $101 $283 $315 ($460) $2,093 $0 ($1,084) 25% 2% 1% 17% -100% 3% ($168) ($1,408) ($478) ($1,045) -7% -7% -8% -1% ($6,078) $995 $359 $55 $707 -79% 3% 2% 6% 17% ($22) -7% ($89) ($4,073) ($685) ($182) $788 ($1,491) -100% -6% -2% -7% 10% -100% $4,598 6% ($1,045) -1% -1% Consolidated Statement Of Shareholders' Equity (USD $) In Millions Redeemable noncontrolling interest at Jan. 31, 2012 Balances at Jan. 31, 2012 Balances, in shares at Jan. 31, 2012 Consolidated net income Other comprehensive income, net of income taxes Cash dividends declared Purchase of Company stock (in shares) Purchase of Company stock Nonredeemable noncontrolling interest of acquired entity Other, in shares Other Consolidated net income, net of tax, attributable to redeemable noncontrolling interest Less other comprehensive income (loss) attributable to redeemable noncontrolling interest Other change in redeemable noncontrolling interest Redeemable noncontrolling interest at Jan. 31, 2013 Balances at Jan. 31, 2013 Balances, in shares at Jan. 31, 2013 Consolidated net income Other comprehensive income, net of income taxes Cash dividends declared Purchase of Company stock (in shares) Purchase of Company stock Redemption value adjustment of redeemable noncontrolling interest Other, in shares Other Consolidated net income, net of tax, attributable to redeemable noncontrolling interest Less other comprehensive income (loss) attributable to redeemable noncontrolling interest Redemption value adjustment of redeemable noncontrolling interest Other change in redeemable noncontrolling interest Total Common stock $404 75,761 342 3,418 Capital in excess of par value 3,692 17,683 961 -5,361 -7,709 -115 -11 -357 11 1 285 469 -66 73 51 -9 519 81,738 332 3,314 3,620 16,617 -2,720 -6,139 -6,557 -87 -9 -1,019 -294 -1,019 6 -581 78 -66 1,019 -59 55 Redeemable noncontrolling interest at Jan. 31, 2014 Balances at Jan. 31, 2014 Balances, in shares at Jan. 31, 2014 Consolidated net income Other comprehensive income, net of income taxes Cash dividends declared Purchase of Company stock (in shares) Purchase of Company stock Other, in shares Other Purchase of redeemable noncontrolling interest Less other comprehensive income (loss) attributable to redeemable noncontrolling interest Redeemable noncontrolling interest at Jan. 31, 2015 Balances at Jan. 31, 2015 Balances, in shares at Jan. 31, 2015 1,491 81,339 323 3,233 2,362 17,099 -4,718 -6,185 -980 -618 -13 -1 8 1 -29 129 -1,491 0 0 $85,937 $323 3,228 $2,462 Retained earnings 68,691 Accumulated other comprehensive income (loss) -1,410 16,999 Total Walmart shareholders' equity 71,315 16,999 823 -5,361 823 -5,361 -7,341 -7,709 -10 276 72,978 -587 16,022 76,343 16,022 -2,409 -6,139 -2,409 -6,139 -6,254 -6,557 -1,019 -41 14 76,566 -2,996 16,363 76,255 16,363 -4,172 -6,185 -4,172 -6,185 -950 -980 -17 113 $85,777 ($7,168) $81,394 Nonredeemable Noncontrolling interest 4,446 684 138 469 -342 5,395 595 -311 -595 5,084 736 -546 -731 $4,543 Consolidated Statement Of Shareholders' Equity (Parenthetical) (USD $) 12 Months Ended Jan. 31, 2015 Jan. 31, 2014 Jan. 31, 2013 Statement of Stockholders' Equity [Abstract] Dividends declared per common share $1.92 $1.88 $1.59 Consolidated Statements Of Cash Flows 12 Months Ended (USD $) In Millions, unless otherwise specified Jan. 31, 2015 Jan. 31, 2014 Jan. 31, 2013 Cash flows from operating activities: Consolidated net income $17,099 $16,695 $17,756 Income from discontinued operations, net of income taxes -285 -144 -52 Income from continuing operations 16,814 16,551 17,704 Adjustments to reconcile consoliated net income to net cash provided by operating activities: Depreciation and amortization Deferred income taxes Other operating activities Changes in certain assets and liabilities, net of effects of acquisitions: 9,173 -503 785 8,870 -279 938 8,478 -133 602 Receivables, net Inventories Accounts payable Accrued liabilities Accrued income taxes Net cash provided by operating activities Cash flows from investing activities: Payments for property and equipment Proceeds from the disposal of property and equipment -569 -1,229 2,678 1,249 166 28,564 -566 -1,667 531 103 -1,224 23,257 -614 -2,759 1,061 271 981 25,591 -12,174 -13,115 -12,898 570 727 532 671 -192 -11,125 0 -138 -12,526 0 -271 -12,637 -6,288 5,174 -3,904 -6,185 -1,015 -600 -1,844 -409 -15,071 911 7,072 -4,968 -6,139 -6,683 -426 -296 -260 -10,789 2,754 211 -1,478 -5,361 -7,600 -282 -132 -58 -11,946 -514 -442 223 1,854 -500 1,231 7,281 9,135 7,781 7,281 6,550 7,781 Proceeds from the disposal of certain operations Other investing activities Net cash used in investing activities Cash flows from financing activities: Net change in short-term borrowings Proceeds Payments of long-term debt Dividends paid Purchase of Company stock Dividends paid to noncontrolling interest Purchase of noncontrolling interest Other financing activities Net cash used in financing activities Effect of exchange rates on cash and cash equivalents Net increase (decrease) in cash and cash equivalents Cash and cash equivalents at beginning of year Cash and cash equivalents at end of year Supplemental disclosure of cash flow information: Income taxes paid Interest paid 8,169 $2,433 8,641 $2,362 7,304 $2,262