MGT 5000 Midterm exam
Test questions are based on the financial
statements below.
NYSE: WMT74.21at 1:40pm EST on Sept 25
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
.gif” alt=”http://cpc.db3.s-msn.com/MSN/sc/i/56/7ea18882ca5be34bbe384a9f52bd78.gif”>
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
.gif” alt=”http://cpc.db3.s-msn.com/MSN/sc/i/56/7ea18882ca5be34bbe384a9f52bd78.gif”>
Net
Property,Plant,and Equipment
116,681.00
112,324.00
107,878.00
.gif” alt=”http://cpc.db3.s-msn.com/MSN/sc/i/56/7ea18882ca5be34bbe384a9f52bd78.gif”>
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
.gif” alt=”http://cpc.db3.s-msn.com/MSN/sc/i/56/7ea18882ca5be34bbe384a9f52bd78.gif”>
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
.gif” alt=”http://cpc.db3.s-msn.com/MSN/sc/i/56/7ea18882ca5be34bbe384a9f52bd78.gif”>
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
.gif” alt=”http://cpc.db3.s-msn.com/MSN/sc/i/56/7ea18882ca5be34bbe384a9f52bd78.gif”>
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
.gif” alt=”http://cpc.db3.s-msn.com/MSN/sc/i/56/7ea18882ca5be34bbe384a9f52bd78.gif”>
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
.gif” alt=”http://cpc.db3.s-msn.com/MSN/sc/i/56/7ea18882ca5be34bbe384a9f52bd78.gif”>
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.00
For 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.
MGT 5000 Midterm examTest questions are based on the financial
statements below.NYSE: WMT74.21at 1:40pm EST on Sept 25201320122011Period 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)Assets201320122011.gif” alt=”http://cpc.db3.s-msn.com/MSN/sc/i/56/7ea18882ca5be34bbe384a9f52bd78.gif”>Cash,
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.00.gif” alt=”http://cpc.db3.s-msn.com/MSN/sc/i/56/7ea18882ca5be34bbe384a9f52bd78.gif”>Net
Property,Plant,and Equipment116,681.00112,324.00107,878.00.gif” alt=”http://cpc.db3.s-msn.com/MSN/sc/i/56/7ea18882ca5be34bbe384a9f52bd78.gif”>Gross
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.00.gif” alt=”http://cpc.db3.s-msn.com/MSN/sc/i/56/7ea18882ca5be34bbe384a9f52bd78.gif”>Goodwill
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’ Equity.gif” alt=”http://cpc.db3.s-msn.com/MSN/sc/i/56/7ea18882ca5be34bbe384a9f52bd78.gif”>Payables43,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.00.gif” alt=”http://cpc.db3.s-msn.com/MSN/sc/i/56/7ea18882ca5be34bbe384a9f52bd78.gif”>LT
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.00.gif” alt=”http://cpc.db3.s-msn.com/MSN/sc/i/56/7ea18882ca5be34bbe384a9f52bd78.gif”>Deferred
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.00.gif” alt=”http://cpc.db3.s-msn.com/MSN/sc/i/56/7ea18882ca5be34bbe384a9f52bd78.gif”>Capital
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.
Recent Comments