Question

In: Finance

Performance measures. Table 28.8 gives abbreviated balance sheets and income statements for Walmart. At the end...

Performance measures. Table 28.8 gives abbreviated balance sheets and income statements for Walmart. At the end of fiscal 2017, Walmart had 2,960 million shares outstanding with a share price of $106. The company’s weighted-average cost of capital was about 5%. Assume the marginal corporate tax rate was 35%. Calculate:

  1. Market value added.

  2. Market-to-book ratio.

  3. Economic value added.

  4. Return on start-of-the-year capital.


Fiscal 2017

Fiscal 2016

Income Statement

Net Sales

Cost of goods sold

Selling, general, and administrative expenses

Depreciation

Earnings before interest & tax

Interest expense

Taxable income

Tax

Net Income

$500,343

  373,396

    95,981

    10,529

$ 20,437

      2,178

$ 18,259

      4,600

$ 13,659

$485,873

  361,256

    91,773

    10,080

$ 22,764

      2,267

$ 20.497

      6,204

$ 14,293   





Fiscal 2017

Fiscal 2016

Balance Sheet

Assets

Current assets:

      Cash and marketable securities

     Accounts receivable

     Inventories

     Other current assets

     Total current assets

$6,756

  5,614

43,783

  3,511

$59,664

$6,867

  5,835

43,046

  1,941

$57,689

Fixed assets:

     Net fixed assets

     Other long-term assets

          Total assets

$114,818

   30,040

$204,522

$114,178

   26,825

$198,825

Liabilities & Shareholders’ Equity

Current liabilities:

     Accounts payable

     Other current liabilities

          Total current liabilities

Long-term debt

Other long-term liability

          Total liabilities

          Total shareholders’ equity

          Total liabilities and shareholders’ equity

$46,092

  32,429

$78,521

  36,825

  11,307

$126,653

77,869

$204,522

$41,433

  25,495

$66,928

  42,018

  12,081

$121,027

77,798

$198,825

  1. Market Value Added (MVA) = Market Value of Equity (MVE) - Book Value of Equity (BVE)

MVE = Outstanding shares * Share price = 2,960 shares * $106.00 = $313,760.00

BVE = $313,760.00 - $77,869.00 = $235,891.00

  1. Market-to-book ratio = Market value of equity / Book value of equity

Market-to-book ratio = 313,760 / 77,869 = 4.03

Solutions

Expert Solution

1. Market Value Added (MVA) = Market Value of Equity (MVE) - Book Value of Equity (BVE)

MVE = Outstanding shares * Share price = 2,960 million shares * $106.00 = $313760 million

BVE = Total Assets - Total Liabilities

BVE = $204522-$126653 = $77869

BVE = $313760.00 - $77,869.00 = $235,891.00

2. Market-to-book ratio = Market value of equity / Book value of equity

Market-to-book ratio = 313760 / 77869 = 4.03

3. Economic Value Added = NOPAT – (WACC * Capital invested)

NOPAT = Net Income + Net Interest X (1 – Tax rate)

WACC = Weighted Average Cost of Capital = 5%

Capital invested = Total Assets - Current Liabilities

NOPAT = 13659 + 2178(1-0.35) = $15074.7

Capital invested = 204522-78521 =$126001

Economic Value Added = 15074.7 – (0.05*126001) = $8774.65

4. Return on start-of-the-year capital(ROIC)

​ROIC=NOPAT / Invested Capital ​

ROIC = 15074.7/126001 = 11.96%

       


Related Solutions

Financial Ratios. Look again at Table 28.8 from P. 3., which gives abbreviated balance sheets and...
Financial Ratios. Look again at Table 28.8 from P. 3., which gives abbreviated balance sheets and income statements for Walmart. Assume Walmart had a 35% marginal corporate tax rate in 2017. Calculate the following using balance sheet figures from the start of the year: Return on assets. Operating profit margin. Sales-to-assets ratio. Inventory turnover. Debt-equity ratio. Fiscal 2017 Fiscal 2016 Income Statement Net Sales Cost of goods sold Selling, general, and administrative expenses Depreciation Earnings before interest & tax Interest...
Compute and Analyze Measures for DuPont Disaggregation Analysis Balance sheets and income statements for Costco Wholesale...
Compute and Analyze Measures for DuPont Disaggregation Analysis Balance sheets and income statements for Costco Wholesale Corporation follow. Consolidated Statements of Earnings For Fiscal Years Ended ($ millions) September 1, 2013 September 2, 2012 August 28, 2011 Revenue Net Sales $102,870 $97,062 $87,048 Membership fees 2,286 2,075 1,867 Total revenue 105,156 99,137 88,915 Operating expenses Merchandise costs 91,948 86,823 77,739 Selling, general and administrative 10,104 9,518 8,691 Preopening expenses 51 37 46 Operating Income 3,053 2,759 2,439 Other income (expense)...
Compute and Interpret Measures for DuPont Disaggregation Analysis Balance sheets and income statements for 3M Company...
Compute and Interpret Measures for DuPont Disaggregation Analysis Balance sheets and income statements for 3M Company follow. 3M Company Consolidated Statements of Income For Years Ended Dec. 31 ($ millions) 2015 2014 2013 Net sales $30,274 $31,821 $30,871 Operating expenses Cost of sales 15,383 16,447 16,106 Selling, general & administrative expenses 6,182 6,469 6,384 Research, development & related expenses 1,763 1,770 1,715 Total operating expenses 23,328 24,686 24,205 Operating income 6,946 7,135 6,666 Interest expense and income Interest expense 149...
Compute and Interpret Measures for DuPont Disaggregation Analysis Balance sheets and income statements for 3M Company...
Compute and Interpret Measures for DuPont Disaggregation Analysis Balance sheets and income statements for 3M Company follow. 3M Company Consolidated Statements of Income For Years Ended Dec. 31 ($millions) 2015 2014 2013 Net sales $30,674 $31,821 $30,871 Operating expenses Cost of sales 15,383 16,447 16,106 Selling, general & administrative expenses 6,182 6,469 6,384 Research, development & related expenses 1,763 1,770 1,715 Total operating expenses 23,328 24,686 24,205 Operating income 7,346 7,135 6,666 Interest expense and income Interest expense 149 142...
Which of the following is a difference between balance sheets and income statements? a. Balance sheets...
Which of the following is a difference between balance sheets and income statements? a. Balance sheets are also known as profit and loss statements, whereas income statements are also known as statements of financial position. b. Balance sheets are used to track a business's liquidity, efficiency, and profitability over time compared to other businesses in its industry, whereas income statements are quantitative plans through which managers decide how to allocate available money to best accomplish company goals. c. Balance sheets...
The comparative balance sheets and income statements for Gypsy Company follow. Balance Sheets As of December...
The comparative balance sheets and income statements for Gypsy Company follow. Balance Sheets As of December 31 Year 2 Year 1 Assets Cash $ 25,779 $ 2,523 Accounts receivable 2,158 1,295 Inventory 6,559 6,149 Equipment 18,948 43,638 Accumulated depreciation—equipment (7,717 ) (17,493 ) Land 19,647 9,607 Total assets $ 65,374 $ 45,719 Liabilities and equity Accounts payable (inventory) $ 2,552 $ 4,122 Long-term debt 2,728 6,236 Common stock 24,100 10,000 Retained earnings 35,994 25,361 Total liabilities and equity $ 65,374...
The comparative balance sheets and income statements for Gypsy Company follow. Balance Sheets As of December...
The comparative balance sheets and income statements for Gypsy Company follow. Balance Sheets As of December 31 2017 2016   Assets      Cash $ 23,243 $ 2,651      Accounts receivable 2,237 1,342      Inventory 6,202 5,814      Equipment 22,837 44,607      Accumulated depreciation—equipment (9,806 ) (16,588 )      Land 14,214 8,184   Total assets $ 58,927 $ 46,010   Liabilities and equity      Accounts payable (inventory) $ 2,671 $ 4,315      Long-term debt 2,695 6,160      Common stock 20,700 10,500      Retained earnings 32,861 25,035   Total liabilities and equity $ 58,927 $ 46,010...
The comparative balance sheets and income statements for Munoz Company follow: Balance Sheets As of December...
The comparative balance sheets and income statements for Munoz Company follow: Balance Sheets As of December 31 Year 2 Year 1 Assets Cash $ 22,554 $ 2,987 Accounts receivable 1,813 1,088 Inventory 6,503 6,097 Equipment 19,699 43,369 Accumulated depreciation—equipment (5,974 ) (15,475 ) Land 19,269 9,039 Total assets $ 63,864 $ 47,105 Liabilities and equity Accounts payable (inventory) $ 2,738 $ 4,423 Long-term debt 2,860 6,538 Common stock 25,200 11,500 Retained earnings 33,066 24,644 Total liabilities and equity $ 63,864...
The following table shows an abbreviated income statement and balance sheet for Quick Burger Corporation for...
The following table shows an abbreviated income statement and balance sheet for Quick Burger Corporation for 2019. INCOME STATEMENT OF QUICK BURGER CORP., 2019 (Figures in $ millions) Net sales $ 27,583 Costs 17,585 Depreciation 1,418 Earnings before interest and taxes (EBIT) $ 8,580 Interest expense 533 Pretax income 8,047 Federal taxes (@ 21%) 1,690 Net income $ 6,357 BALANCE SHEET OF QUICK BURGER CORP., 2019 (Figures in $ millions)   Assets 2019 2018 Liabilities and Shareholders' Equity 2019 2018 Current...
The following table shows an abbreviated income statement and balance sheet for Quick Burger Corporation for...
The following table shows an abbreviated income statement and balance sheet for Quick Burger Corporation for 2019. INCOME STATEMENT OF QUICK BURGER CORP., 2019 (Figures in $ millions) Net sales $ 27,575 Costs 17,577 Depreciation 1,410 Earnings before interest and taxes (EBIT) $ 8,588 Interest expense 525 Pretax income 8,063 Federal taxes (@ 21%) 1,693 Net income $ 6,370 BALANCE SHEET OF QUICK BURGER CORP., 2019 (Figures in $ millions)   Assets 2019 2018 Liabilities and Shareholders' Equity 2019 2018 Current...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT