Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

5.2%? 5-16. Forecasting with Parsimonious Method and Estimating Share Value Using the DCF Model Following are income statements and balance sheets for Nike Inc. NIKE

image text in transcribed

image text in transcribed

5.2%? 5-16. Forecasting with Parsimonious Method and Estimating Share Value Using the DCF Model Following are income statements and balance sheets for Nike Inc. NIKE INC. Consolidated Income Statements May 31, 2019 May 31, 2018 For Year Ended ($ millions) $39,117 21,643 17,474 3,753 8,949 $36,397 20,441 15,956 3,577 7,934 Revenues Cost of sales. Gross profit.... Demand creation expense Operating overhead expense Total selling and administrative expense Interest expense (income), net. Other (income) expense, net Income before income taxes Income tax expense Net income... 12,702 49 (78) 11,511 54 66 4.801 772 4,325 2,392 $ 4,029 $ 1,933 NIKE INC. Consolidated Balance Sheets May 31, 2019 May 31, 2018 $ millions Current assets Cash and equivalents Short-term investments. Accounts receivable, net. Inventories Prepaid expenses and other current assets Total current assets ...... Property, plant and equipment, net Identifiable intangible assets, net Goodwill ....... Deferred income taxes and other assets $ 4,249 996 3,498 5,261 1,130 $ 4,466 197 4,272 5,622 1,968 16,525 4,744 283 154 2,011 15,134 4,454 285 154 2,509 Total assets $23,717 $22,536 $ $ Current liabilities Current portion of long-term debt Notes payable Accounts payable Accrued liabilities Income taxes payable. Total current liabilities. Long-term debt Deferred income taxes and other liabilities Commitments and contingencies (Note 18) Shareholders' equity 6 9 2,612 5,010 229 6 336 2,279 3,269 150 7,866 3,464 3,347 6,040 3,468 3,216 continued from previous page May 31, 2019 May 31, 2018 S millions Common stock at stated value: Class A convertible-315 and 329 shares outstanding. Class B-1,253 and 1,272 shares outstanding Capital in excess of stated value Accumulated other comprehensive income (loss) Retained earnings.. Total shareholders' equity Total liabilities and shareholders' equity. 3 7,163 231 1,643 3 6,384 (92) 3,517 9,040 $23,717 9,812 $22,536 Required a. Compute net operating assets (NOA) and net nonoperating obligations (NNO) for 2019. The com- pany's NNO is negative because cash exceeds debt. b. Compute net operating profit after tax (NOPAT) for 2019 assuming a federal and state statutory tax rate of 22%. c. Use the parsimonious forecast method, as shown in the Analysis Insight box in Exhibit 13.2, to fore- cast sales, NOPAT, and NOA for 2020 through 2023 using the following assumptions. Sales growth..... Net operating profit margin (NOPM). Net operating asset turnover (NOAT), year-end... 8% 2019 ratios rounded to three decimal places 2019 ratios rounded to three decimal places atine Forecast the terminal period value assuming a 2% terminal period growth and using the NOPM and NOAT assumptions above. d. Estimate the value of a share of Nike's common stock using the discounted cash flow (DCF) model as of May 31, 2019; assume a discount rate (WACC) of 6.8% and common shares outstanding of 1,682 million. e. Nike's stock closed at $86.70 on July 23, 2019, the date the Form 10-K was filed with the SEC. How does your valuation estimate compare with this closing price? What do you believe are some reasons for the difference? What investment decision is suggested from your results? 5.2%? 5-16. Forecasting with Parsimonious Method and Estimating Share Value Using the DCF Model Following are income statements and balance sheets for Nike Inc. NIKE INC. Consolidated Income Statements May 31, 2019 May 31, 2018 For Year Ended ($ millions) $39,117 21,643 17,474 3,753 8,949 $36,397 20,441 15,956 3,577 7,934 Revenues Cost of sales. Gross profit.... Demand creation expense Operating overhead expense Total selling and administrative expense Interest expense (income), net. Other (income) expense, net Income before income taxes Income tax expense Net income... 12,702 49 (78) 11,511 54 66 4.801 772 4,325 2,392 $ 4,029 $ 1,933 NIKE INC. Consolidated Balance Sheets May 31, 2019 May 31, 2018 $ millions Current assets Cash and equivalents Short-term investments. Accounts receivable, net. Inventories Prepaid expenses and other current assets Total current assets ...... Property, plant and equipment, net Identifiable intangible assets, net Goodwill ....... Deferred income taxes and other assets $ 4,249 996 3,498 5,261 1,130 $ 4,466 197 4,272 5,622 1,968 16,525 4,744 283 154 2,011 15,134 4,454 285 154 2,509 Total assets $23,717 $22,536 $ $ Current liabilities Current portion of long-term debt Notes payable Accounts payable Accrued liabilities Income taxes payable. Total current liabilities. Long-term debt Deferred income taxes and other liabilities Commitments and contingencies (Note 18) Shareholders' equity 6 9 2,612 5,010 229 6 336 2,279 3,269 150 7,866 3,464 3,347 6,040 3,468 3,216 continued from previous page May 31, 2019 May 31, 2018 S millions Common stock at stated value: Class A convertible-315 and 329 shares outstanding. Class B-1,253 and 1,272 shares outstanding Capital in excess of stated value Accumulated other comprehensive income (loss) Retained earnings.. Total shareholders' equity Total liabilities and shareholders' equity. 3 7,163 231 1,643 3 6,384 (92) 3,517 9,040 $23,717 9,812 $22,536 Required a. Compute net operating assets (NOA) and net nonoperating obligations (NNO) for 2019. The com- pany's NNO is negative because cash exceeds debt. b. Compute net operating profit after tax (NOPAT) for 2019 assuming a federal and state statutory tax rate of 22%. c. Use the parsimonious forecast method, as shown in the Analysis Insight box in Exhibit 13.2, to fore- cast sales, NOPAT, and NOA for 2020 through 2023 using the following assumptions. Sales growth..... Net operating profit margin (NOPM). Net operating asset turnover (NOAT), year-end... 8% 2019 ratios rounded to three decimal places 2019 ratios rounded to three decimal places atine Forecast the terminal period value assuming a 2% terminal period growth and using the NOPM and NOAT assumptions above. d. Estimate the value of a share of Nike's common stock using the discounted cash flow (DCF) model as of May 31, 2019; assume a discount rate (WACC) of 6.8% and common shares outstanding of 1,682 million. e. Nike's stock closed at $86.70 on July 23, 2019, the date the Form 10-K was filed with the SEC. How does your valuation estimate compare with this closing price? What do you believe are some reasons for the difference? What investment decision is suggested from your results

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Reporting Financial Statement Analysis And Valuation A Strategic Perspective

Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

8th Edition

1285190904, 978-1305176348, 1305176340, 978-1285190907

More Books

Students also viewed these Finance questions