I need help understanding the steps to arrive at each of the answers.

Assume the following are the financial statements of Nike, Inc. Consolidated Statements of Income Year ended May 31 In Millions 2011 2010 Revenues $ 21,862 $ 20,014 Cost of sales 11,354 10,214 Gross profit 10,508 9,800 Demand creation expense 3,248 2,356 Operating overhead expense 4,345 3,970 Total selling and administrative expense 7,593 6,326 Interest expense (income), net Other (income) (33) (49) Income before income taxes 2,944 3,517 Income taxes 811 610 Net income $ 2,133 $2,907 Balance Sheets May 31 2011 2010 In Millions Assets Cash and equivalents Short-term investments Accounts receivable, net Inventories Deferred income taxes 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 Total assets Liabilities and Shareholders' Equity Current portion of long-term debt Notes payable Accounts payable Accrued liabilities Income taxes payable Total current liabilities Long-term debt $ 1,955 $3,079 2,583 2,067 3,138 2,650 2,715 2.041 312 249 594 873 11,297 10,959 2,115 1,932 487 467 205 188 894 873 $ 14,998 $ 14,419 $ 200 187 1,469 1,985 117 3,958 276 $7 139 1,255 1,904 59 3,364 446 Long-term debt Deferred income taxes and other liabilities Total liabilities Common stock at stated value Capital in excess of stated value Accumulated other comprehensive income Retained earnings Total shareholders' equity Total liabilities and shareholders' equity 276 446 921 855 5,155 4,665 3 3 3,944 95 215 5,801 6,095 9,843 9,754 $ 14,998 $ 14,419 We forecast Nike's income statement using the following forecast assumptions: Revenue growth based on growth in revenues from 2010 to 2011 996 Cost of sales/Revenues 51.9% Demand creation expense/Revenues 14.996 Operating overhead expenses/Revenues 19.996 Income taxes/Income before income taxes 27.596 Instructions: Forecast Nike's fiscal year 2012 income statement. Assume no change for: other income and interest expense. Round forecasts to $ millions. Do not use negative signs with your answers in the income statement. Consolidated Statements of Income ($ millions) 2011 2012 Revenues $21,862 $ 23,830 Cost of sales 11,354 12,367 x Gross profit 10,508 Demand creation expense 3,248 Operating overhead expense 4,345 Interest expense, net Other income 33 Income before income taxes 2,944 Income taxes 811 OX Net Income $ 2,133 $ 0x OM We forecast Nike's balance sheet using the following forecast assumptions: 14.496 Accounts receivable/Revenues Inventories/Revenues Deferred income taxes/Revenues Prepaid expenses and other current assets/Revenues 12.496 1.496 2.79% Prepaid expenses and other current assets/Revenues 2.796 L-T deferred income taxes and other assets/Revenues 4.196 Depreciation expense/Prior-year PPE, net (incl. in overhead) 17.39 Amortization expense $24 Accounts payable/Revenues 6.796 Accrued liabilities/Revenues 9.196 Income taxes payable/Revenues 0.596 Deferred income taxes and other liabilities/Revenues 4.296 Capital expenditures/Revenues 2.096 Dividends/Net income 23.496 Current portion of L/T debt due in 2013 $50 Instructions: Forecast Nike's fiscal year 2012 balance sheet. Assume no change for short-term investments, goodwill, notes payable, common stock, capital in excess of stated value and accumulated other comprehensive income. Round forecasts to $ millions. 2011 2012 0 x 0 % $1,955 $ 2,583 3,138 2,715 312 594 11,297 2,115 487 205 894 $14.998 $ ooo Balance Sheet ($ millions) Assets Cash and equivalents Short-term investments Accounts receivable, net Inventories Deferred income taxes 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 Total assets Liabilities and Shareholders' Equity 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 Total liabilities Common stock at stated value Capital in excess of stated value Ox X X X X $200 $ 187 1,469 1,985 117 3,958 276 921 5,155 3 3,944 Capital in excess of stated value Accumulated other comprehensive income Retained earnings Total shareholders' equity Total liabilities and shareholders' equity 3.944 95 5.801 9,843 $14.998 $ OX OX 0x X X X X X X X Instructions: Forecast Nike's fiscal year 2012 statement of cash flows. Use negative signs with your answers below, when appropriate. Nike's Forecasted Statement of Cash Flows ($ millions) 2012 Est. Net income Add: depreciation Add: amortization Change in Accounts receivable Change in Inventories Change in Deferred income taxes Change in Prepaid expenses & other current assets Change in LT Deferred income taxes & other assets Change in Accounts payable Change in Accrued liabilities Change in Income taxes payable Change in LT Deferred income taxes and other liabilities Net cash from operating activities Capital expenditures Net cash from investing activities Dividends Payments of LT debt Net cash from financing activities Net change in cash Beginning cash Ending cash X X X X X X x x Olo od Capital in excess of stated value Accumulated other comprehensive income Retained earnings Total shareholders' equity Total liabilities and shareholders' equity 3.944 95 5.801 9,843 $14.998 $ OX OX 0x X X X X X X X Instructions: Forecast Nike's fiscal year 2012 statement of cash flows. Use negative signs with your answers below, when appropriate. Nike's Forecasted Statement of Cash Flows ($ millions) 2012 Est. Net income Add: depreciation Add: amortization Change in Accounts receivable Change in Inventories Change in Deferred income taxes Change in Prepaid expenses & other current assets Change in LT Deferred income taxes & other assets Change in Accounts payable Change in Accrued liabilities Change in Income taxes payable Change in LT Deferred income taxes and other liabilities Net cash from operating activities Capital expenditures Net cash from investing activities Dividends Payments of LT debt Net cash from financing activities Net change in cash Beginning cash Ending cash X X X X X X x x Olo od Assume the following are the financial statements of Nike, Inc. Consolidated Statements of Income Year ended May 31 In Millions 2011 2010 Revenues $ 21,862 $ 20,014 Cost of sales 11,354 10,214 Gross profit 10,508 9,800 Demand creation expense 3,248 2,356 Operating overhead expense 4,345 3,970 Total selling and administrative expense 7,593 6,326 Interest expense (income), net Other (income) (33) (49) Income before income taxes 2,944 3,517 Income taxes 811 610 Net income $ 2,133 $2,907 Balance Sheets May 31 2011 2010 In Millions Assets Cash and equivalents Short-term investments Accounts receivable, net Inventories Deferred income taxes 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 Total assets Liabilities and Shareholders' Equity Current portion of long-term debt Notes payable Accounts payable Accrued liabilities Income taxes payable Total current liabilities Long-term debt $ 1,955 $3,079 2,583 2,067 3,138 2,650 2,715 2.041 312 249 594 873 11,297 10,959 2,115 1,932 487 467 205 188 894 873 $ 14,998 $ 14,419 $ 200 187 1,469 1,985 117 3,958 276 $7 139 1,255 1,904 59 3,364 446 Long-term debt Deferred income taxes and other liabilities Total liabilities Common stock at stated value Capital in excess of stated value Accumulated other comprehensive income Retained earnings Total shareholders' equity Total liabilities and shareholders' equity 276 446 921 855 5,155 4,665 3 3 3,944 95 215 5,801 6,095 9,843 9,754 $ 14,998 $ 14,419 We forecast Nike's income statement using the following forecast assumptions: Revenue growth based on growth in revenues from 2010 to 2011 996 Cost of sales/Revenues 51.9% Demand creation expense/Revenues 14.996 Operating overhead expenses/Revenues 19.996 Income taxes/Income before income taxes 27.596 Instructions: Forecast Nike's fiscal year 2012 income statement. Assume no change for: other income and interest expense. Round forecasts to $ millions. Do not use negative signs with your answers in the income statement. Consolidated Statements of Income ($ millions) 2011 2012 Revenues $21,862 $ 23,830 Cost of sales 11,354 12,367 x Gross profit 10,508 Demand creation expense 3,248 Operating overhead expense 4,345 Interest expense, net Other income 33 Income before income taxes 2,944 Income taxes 811 OX Net Income $ 2,133 $ 0x OM We forecast Nike's balance sheet using the following forecast assumptions: 14.496 Accounts receivable/Revenues Inventories/Revenues Deferred income taxes/Revenues Prepaid expenses and other current assets/Revenues 12.496 1.496 2.79% Prepaid expenses and other current assets/Revenues 2.796 L-T deferred income taxes and other assets/Revenues 4.196 Depreciation expense/Prior-year PPE, net (incl. in overhead) 17.39 Amortization expense $24 Accounts payable/Revenues 6.796 Accrued liabilities/Revenues 9.196 Income taxes payable/Revenues 0.596 Deferred income taxes and other liabilities/Revenues 4.296 Capital expenditures/Revenues 2.096 Dividends/Net income 23.496 Current portion of L/T debt due in 2013 $50 Instructions: Forecast Nike's fiscal year 2012 balance sheet. Assume no change for short-term investments, goodwill, notes payable, common stock, capital in excess of stated value and accumulated other comprehensive income. Round forecasts to $ millions. 2011 2012 0 x 0 % $1,955 $ 2,583 3,138 2,715 312 594 11,297 2,115 487 205 894 $14.998 $ ooo Balance Sheet ($ millions) Assets Cash and equivalents Short-term investments Accounts receivable, net Inventories Deferred income taxes 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 Total assets Liabilities and Shareholders' Equity 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 Total liabilities Common stock at stated value Capital in excess of stated value Ox X X X X $200 $ 187 1,469 1,985 117 3,958 276 921 5,155 3 3,944 Capital in excess of stated value Accumulated other comprehensive income Retained earnings Total shareholders' equity Total liabilities and shareholders' equity 3.944 95 5.801 9,843 $14.998 $ OX OX 0x X X X X X X X Instructions: Forecast Nike's fiscal year 2012 statement of cash flows. Use negative signs with your answers below, when appropriate. Nike's Forecasted Statement of Cash Flows ($ millions) 2012 Est. Net income Add: depreciation Add: amortization Change in Accounts receivable Change in Inventories Change in Deferred income taxes Change in Prepaid expenses & other current assets Change in LT Deferred income taxes & other assets Change in Accounts payable Change in Accrued liabilities Change in Income taxes payable Change in LT Deferred income taxes and other liabilities Net cash from operating activities Capital expenditures Net cash from investing activities Dividends Payments of LT debt Net cash from financing activities Net change in cash Beginning cash Ending cash X X X X X X x x Olo od Capital in excess of stated value Accumulated other comprehensive income Retained earnings Total shareholders' equity Total liabilities and shareholders' equity 3.944 95 5.801 9,843 $14.998 $ OX OX 0x X X X X X X X Instructions: Forecast Nike's fiscal year 2012 statement of cash flows. Use negative signs with your answers below, when appropriate. Nike's Forecasted Statement of Cash Flows ($ millions) 2012 Est. Net income Add: depreciation Add: amortization Change in Accounts receivable Change in Inventories Change in Deferred income taxes Change in Prepaid expenses & other current assets Change in LT Deferred income taxes & other assets Change in Accounts payable Change in Accrued liabilities Change in Income taxes payable Change in LT Deferred income taxes and other liabilities Net cash from operating activities Capital expenditures Net cash from investing activities Dividends Payments of LT debt Net cash from financing activities Net change in cash Beginning cash Ending cash X X X X X X x x Olo od