Details of this Paper

MGT5000 Midterm exam

Description

solution


Question

Question;MGT 5000 Midterm examTest questions are based on the financial statements below.201320122011Period End Date1/31/20131/31/20121/31/2011Stmt SourceN/A10-K10-KStmt Source Date1/31/20133/26/20133/26/2013Stmt Update TypeOriginalUpdatedUpdatedCurrency CodeUSDUSDUSDTotal Revenue469,162.00446,950.00421,849.00Cost of Revenue352,488.00335,127.00314,946.00Gross Profit116,674.00111,823.00106,903.00Selling,General and Administrative88,873.0085,265.0081,361.00Operating Expenses88,873.0085,265.0081,361.00Operating Income27,801.0026,558.0025,542.00Net Interest Income-2,064.00-2,160.00-2,004.00Pretax Income25,737.0024,398.0023,538.00Provision for Income Tax7,981.007,944.007,579.00Minority Interest757688604Discontinued Operations0-671,034.00Net Income16,999.0015,699.0016,389.00Wal-Mart Stores Inc., Consolidated Balance Sheet (rounded to millions)Assets201320122011Cash, Equiv and Short Term Investments7,781.006,550.007,395.00Cash and Cash Equivalents7,781.006,550.007,395.00Receivables6,768.005,937.005,089.00Inventories43,803.0040,714.0036,318.00Prepaid Assets and Others1,588.001,774.002,960.00Other Current Assets00131Total Current Assets59,940.0054,975.0051,893.00Net Property,Plant,and Equipment116,681.00112,324.00107,878.00Gross Property,Plant,and Equipment171,724.00160,938.00154,489.00Land and Improvements25,612.0023,499.0024,386.00Buildings and Improvements90,686.0084,275.0079,051.00Machinery,Furniture/Equipment43,699.0041,916.0040,885.00Other Properties005,905.00Construction in Progress5,828.005,312.004,262.00Leasehold and Improvements5,899.005,936.000Accumulated Depreciation-55,043.00-48,614.00-46,611.00Goodwill and Other Intangible Assets20,497.0020,651.0016,763.00Goodwill20,497.0020,651.0016,763.00Deferred Costs5,987.005,456.000Other Non-Current Assets004,129.00Total Non-Current Assets143,165.00138,431.00128,770.00Total Assets203,105.00193,406.00180,663.00Liabilities and Shareholders' EquityPayables43,142.0040,095.0033,714.00Accounts Payable38,080.0036,608.0033,557.00Taxes Payable5,062.003,487.00157Accrued Expenses,Current15,957.0015,857.0018,701.00Current Debt12,392.006,022.005,686.00Current Portion of Capital Lease Obligation327326336Other Current Liabilities0047Total Current Liabilities71,818.0062,300.0058,484.00LT Debt and Capital Lease Obligation41,417.0047,079.0043,842.00Long Term Debt38,394.0044,070.0040,692.00Long Term Portion of Capital Lease Obligation3,023.003,009.003,150.00Deferred Liabilities, Non current7,613.007,862.006,682.00Deferred Taxes,Non-Current Liabilities7,613.007,862.006,682.00Minority Interest5,395.004,446.002,705.00Other Non-Current Liabilities519404408Total Non-Current Liabilities and MI54,944.0059,791.0053,637.00Total Liabilities126,762.00122,091.00112,121.00Capital Stock3323420Common Stock3323420Retained Earnings72,978.0068,691.0063,967.00Additional Paid in Capital3,620.003,692.003,577.00Accum Gains/ Losses Not Affecting RE-587-1,410.00646Total Equity76,343.0071,315.0068,542.00Total Liabilities and Equity203,105.00193,406.00180,663.00Ordinary Shares Outstanding3,314.003,418.003,516.00For each of the following, perform the computations, show your work and give your interpretation of the results of your computations.1. Return on average total assets (ROI) for 2013 and 2012.2. Earnings per share for 2013 and 2012.3. Return on equity for 2013 and 20124. Working capital for 2013 and 20125. Current ratio for 2013 and 2012.6. Acid test ratio for 2013 and 2012.7. Trend analysis in Net Sales8. Trend analysis in Net Income9. Price earnings ratio based on the 2013 EPS.10. Trend analysis in inventory.

 

Paper#43407 | Written in 18-Jul-2015

Price : $32
SiteLock