Description of this paper

MGT 5000 -Midterm exam

Description

solution


Question

Question;MGT 5000 Midterm exam;Test questions are based on the financial statements below.;2013;2012;2011;Period End Date;1/31/2013;1/31/2012;1/31/2011;Stmt Source;N/A;10-K;10-K;Stmt Source Date;1/31/2013;3/26/2013;3/26/2013;Stmt Update Type;Original;Updated;Updated;Currency Code;USD;USD;USD;Total Revenue;469,162.00;446,950.00;421,849.00;Cost of Revenue;352,488.00;335,127.00;314,946.00;Gross Profit;116,674.00;111,823.00;106,903.00;Selling,General and Administrative;88,873.00;85,265.00;81,361.00;Operating Expenses;88,873.00;85,265.00;81,361.00;Operating Income;27,801.00;26,558.00;25,542.00;Net Interest Income;-2,064.00;-2,160.00;-2,004.00;Pretax Income;25,737.00;24,398.00;23,538.00;Provision for Income Tax;7,981.00;7,944.00;7,579.00;Minority Interest;757;688;604;Discontinued Operations;0;-67;1,034.00;Net Income;16,999.00;15,699.00;16,389.00;Wal-Mart Stores Inc., Consolidated Balance Sheet (rounded to millions);Assets;2013;2012;2011;Cash, Equiv and Short Term Investments;7,781.00;6,550.00;7,395.00;Cash and Cash Equivalents;7,781.00;6,550.00;7,395.00;Receivables;6,768.00;5,937.00;5,089.00;Inventories;43,803.00;40,714.00;36,318.00;Prepaid Assets and Others;1,588.00;1,774.00;2,960.00;Other Current Assets;0;0;131;Total Current Assets;59,940.00;54,975.00;51,893.00;Net Property,Plant,and Equipment;116,681.00;112,324.00;107,878.00;Gross Property,Plant,and Equipment;171,724.00;160,938.00;154,489.00;Land and Improvements;25,612.00;23,499.00;24,386.00;Buildings and Improvements;90,686.00;84,275.00;79,051.00;Machinery,Furniture/Equipment;43,699.00;41,916.00;40,885.00;Other Properties;0;0;5,905.00;Construction in Progress;5,828.00;5,312.00;4,262.00;Leasehold and Improvements;5,899.00;5,936.00;0;Accumulated Depreciation;-55,043.00;-48,614.00;-46,611.00;Goodwill and Other Intangible Assets;20,497.00;20,651.00;16,763.00;Goodwill;20,497.00;20,651.00;16,763.00;Deferred Costs;5,987.00;5,456.00;0;Other Non-Current Assets;0;0;4,129.00;Total Non-Current Assets;143,165.00;138,431.00;128,770.00;Total Assets;203,105.00;193,406.00;180,663.00;Liabilities and Shareholders' Equity;Payables;43,142.00;40,095.00;33,714.00;Accounts Payable;38,080.00;36,608.00;33,557.00;Taxes Payable;5,062.00;3,487.00;157;Accrued Expenses,Current;15,957.00;15,857.00;18,701.00;Current Debt;12,392.00;6,022.00;5,686.00;Current Portion of Capital Lease Obligation;327;326;336;Other Current Liabilities;0;0;47;Total Current Liabilities;71,818.00;62,300.00;58,484.00;LT Debt and Capital Lease Obligation;41,417.00;47,079.00;43,842.00;Long Term Debt;38,394.00;44,070.00;40,692.00;Long Term Portion of Capital Lease Obligation;3,023.00;3,009.00;3,150.00;Deferred Liabilities, Non current;7,613.00;7,862.00;6,682.00;Deferred Taxes,Non-Current Liabilities;7,613.00;7,862.00;6,682.00;Minority Interest;5,395.00;4,446.00;2,705.00;Other Non-Current Liabilities;519;404;408;Total Non-Current Liabilities and MI;54,944.00;59,791.00;53,637.00;Total Liabilities;126,762.00;122,091.00;112,121.00;Capital Stock;332;342;0;Common Stock;332;342;0;Retained Earnings;72,978.00;68,691.00;63,967.00;Additional Paid in Capital;3,620.00;3,692.00;3,577.00;Accum Gains/ Losses Not Affecting RE;-587;-1,410.00;646;Total Equity;76,343.00;71,315.00;68,542.00;Total Liabilities and Equity;203,105.00;193,406.00;180,663.00;Ordinary Shares Outstanding;3,314.00;3,418.00;3,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 2012;4. Working capital for 2013 and 2012;5. Current ratio for 2013 and 2012.;6. Acid test ratio for 2013 and 2012.;7. Trend analysis in Net Sales;8. Trend analysis in Net Income;9. Price earnings ratio based on the 2013 EPS.;10. Trend analysis in inventory.

 

Paper#43832 | Written in 18-Jul-2015

Price : $27
SiteLock