Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help with filling the remaining blanks on this parsimonious forecast method table. Q: Use the parsimonious forecast method, to forecast sales, NOPAT, and NOA

Need help with filling the remaining blanks on this parsimonious forecast method table.
Q: Use the parsimonious forecast method, to forecast sales, NOPAT, and NOA for 2020 through 2023 using the following assumptions.
Sales growth 8%
Net operating profit margin (NOPM)2019 ratios rounded to three decimal places
Net operating asset turnover (NOAT), year-end 2019 ratios rounded to three decimal places
Forecast the terminal period value assuming a 2% terminal period growth and using the NOPM and NOAT assumptions above.
Note: Round your final answers to the nearest whole dollar. GIVEN DATA:
Following are income statements and balance sheets for Nike Inc.
NIKE INC.
Consolidated Income Statements
May 31, May 31,
For Year Ended ($ millions)20192018
Revenues $39,117 $36,397
Cost of sales 21,64320,441
Gross profit 17,47415,956
Demand creation expense 3,7533,577
Operating overhead expense 8,9497,934
Total selling and administrative expense 12,70211,511
Interest expense (income), net 4954
Other (income) expense, net (78)66
Income before income taxes 4,8014,325
Income tax expense 7722,392
Net income $4,029 $1,933
NIKE INC.
Consolidated Balance Sheets
May 31, May 31,
$ millions 20192018
Current assets
Cash and equivalents $4,466 $4,249
Short-term investments 197996
Accounts receivable, net 4,2723,498
Inventories 5,6225,261
Prepaid expenses and other current assets 1,9681,130
Total current assets 16,52515,134
Property, plant and equipment, net 4,7444,454
Identifiable intangible assets, net 283285
Goodwill 154154
Deferred income taxes and other assets 2,0112,509
Total assets $23,717 $22,536
Current liabilities
Current portion of long-term debt $6 $6
Notes payable 9336
Accounts payable 2,6122,279
Accrued liabilities 5,0103,269
Income taxes payable 229150
Total current liabilities 7,8666,040
Long-term debt 3,4643,468
Deferred income taxes and other liabilities 3,3473,216
Commitments and contingencies (Note 18)
Shareholders' equity
Common stock at stated value:
Class A convertible315 and 329 shares outstanding --
Class B1,253 and 1,272 shares outstanding 33
Capital in excess of stated value 7,1636,384
Accumulated other comprehensive income (loss)231(92)
Retained earnings 1,6433,517
Total shareholders' equity 9,0409,812
Total liabilities and shareholders' equity $23,717 $22,536c. Use the parsimonious forecast method, as shown in the Analysis Insight box on page 14-5, to forecast sales, NOPAT, and NOA for 2020 through 2023 using the following
assumptions.
Forecast the terminal period value assuming a 2% terminal period growth and using the NOPM and NOAT assumptions above.
Note: Round your final answers to the nearest whole dollar.
image text in transcribed

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

Step: 3

blur-text-image

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

Essentials Of Health Care Finance

Authors: William O. Cleverley, James O. Cleverley, Paula H. Song

7th Edition

0763789291, 978-0763789299

More Books

Students also viewed these Finance questions

Question

Describe the components of identity.

Answered: 1 week ago