I need answers for NOPAT, FCF, reduction increase in debt, repurchase issue of stock.
everything else is correct
2017 Free Cash Flows (All dollar values are provided in millions.) 2018 Sales, ST Invest, Notes Pay. LT Debt factor increase Operating costs as % of sales Cash factor increase Accts. Rec factor increase Inventory factor increase Net Plant & Equip factor increase Acets Pay factor increase Accruals factor increase 1.10 75.00% 1.20 1.20 1.10 Sales Cash as % of sales Accts Rec as % of sales Inventory as % of sales Net Plant & Equip as % of sales Accts Pay as % of sales Accruals as % of Sales $5,000 1.40% 13.00% 15.00% 27.00% 9.00% 7.00% 1.10 Depreciation as % of Net Plant & Equip Interest rate Tax rate 10.00% 10.00% 40.00% 90.00% Operating cost as % of sales Depreciation as % of Net Plant & Equip Interest rate Tax rate Payout rate 85.00% 10.00% 10.00% 40.00% 80.00% Pavonit rate Payout rale 90.00% Payout rate Short-term investments as % of sales Noles payable as % of sales Long-term debt as % of sales Retained earnings multiple factor 80.00% 0.50% 2.00% 20.00% 150 Income Statements Sales 24 Operating costs excluding depreciation 25 Depreciation and amortization 26 Eamnings before interest and taxes 27 Less interest 28 Pre-tax income 29 Taxes 30 Net income available to common stockholders 31 Common dividends 2018 $5.5000 4,125.0 148.5 $1.226.5 1183 $1,1083 4433 $6650 5598.5 2017 $5.0000 4.250.0 135.0 $615.0 107.5 $507.5 203.0 $304.5 $243.6 C B $598.5 D $243.6 2018 2017 31 Common dividends 32 33 Balance Sheets: 34 Assets 35 Cash 36 Short-term investments 37 Accounts receivable 38 Inventories 39 Total current assets 40 Net plant and equipment 41 Total assets 42 Liabilities and Equity 44 Accounts payable Accruals 46 Natac nawala $84.0 27.5 780.0 825.0 $1.716.5 1,485.0 $3 201.5 $70.0 25.0 650.0 750.0 $1,495.0 1.350.0 $2.845.0 45 $5625 420.0 1100 $450.0 350.0 100n D G H 46 Notes payable 47 Total current liabilities 48 Long-term debt 49 Total liabilities 50 Common stock 51 Retained earnings 52 Total common equity 53 Total liabilities and equity 1100 $1,0925 11000 $2,1925 8512 1578 $1,009 0 $3 2015 1000 59000 1,000.0 $1,900.0 853.7 914 $9450 $28450 FORMULAS NOPAT 2018 #N/A NOWC 2018 NOWC2017 5706.5 56700 =(B39-B36)-(B47-B46) =(D39-D36)-(D47-D46) 61 Total net operating capital 2. 1916 RERRAN A66 ROIC2018 C D 61 62 Total net operating capital2018 Total net operating capital 2017 B $2.1915 $2,020,0 -B58+B40 -B59+D40 Free cash flow 2018 #N/A ROIC 2018 33.6% =B26H(1-B157861 68 Uses of free cash flow. 69 After-tax interest payment 70 Reduction (increase) in debt 71 Payment of dividends 72 Repurchase (issue) stock 73 Purchase (sale) of short-term investments Total $71.0 $2925 $598.5 -$25 $2.5 =B27"(1-B15) =B49-049 =B31 =B50-050 =B36-036 #N/A 61 62 Total net operating capital2018 Total net operating capital 2017 $2.1915 $2,0200 B58+840 =B59+D40 64 Free cash flow 2018 #N/A ROIC 2018 =B26H(1-B157B61 $710 =B27"(1-815) #N/A Uses of free cash flow After-tax interest payment Reduction (increase in debt Payment of dividends Repurchase (issue) stock Purchase (sale) of short-term investments Total $5985 =B31 #N/A |$2.5 =B36-036 #N/A 76 2017 Free Cash Flows (All dollar values are provided in millions.) 2018 Sales, ST Invest, Notes Pay. LT Debt factor increase Operating costs as % of sales Cash factor increase Accts. Rec factor increase Inventory factor increase Net Plant & Equip factor increase Acets Pay factor increase Accruals factor increase 1.10 75.00% 1.20 1.20 1.10 Sales Cash as % of sales Accts Rec as % of sales Inventory as % of sales Net Plant & Equip as % of sales Accts Pay as % of sales Accruals as % of Sales $5,000 1.40% 13.00% 15.00% 27.00% 9.00% 7.00% 1.10 Depreciation as % of Net Plant & Equip Interest rate Tax rate 10.00% 10.00% 40.00% 90.00% Operating cost as % of sales Depreciation as % of Net Plant & Equip Interest rate Tax rate Payout rate 85.00% 10.00% 10.00% 40.00% 80.00% Pavonit rate Payout rale 90.00% Payout rate Short-term investments as % of sales Noles payable as % of sales Long-term debt as % of sales Retained earnings multiple factor 80.00% 0.50% 2.00% 20.00% 150 Income Statements Sales 24 Operating costs excluding depreciation 25 Depreciation and amortization 26 Eamnings before interest and taxes 27 Less interest 28 Pre-tax income 29 Taxes 30 Net income available to common stockholders 31 Common dividends 2018 $5.5000 4,125.0 148.5 $1.226.5 1183 $1,1083 4433 $6650 5598.5 2017 $5.0000 4.250.0 135.0 $615.0 107.5 $507.5 203.0 $304.5 $243.6 C B $598.5 D $243.6 2018 2017 31 Common dividends 32 33 Balance Sheets: 34 Assets 35 Cash 36 Short-term investments 37 Accounts receivable 38 Inventories 39 Total current assets 40 Net plant and equipment 41 Total assets 42 Liabilities and Equity 44 Accounts payable Accruals 46 Natac nawala $84.0 27.5 780.0 825.0 $1.716.5 1,485.0 $3 201.5 $70.0 25.0 650.0 750.0 $1,495.0 1.350.0 $2.845.0 45 $5625 420.0 1100 $450.0 350.0 100n D G H 46 Notes payable 47 Total current liabilities 48 Long-term debt 49 Total liabilities 50 Common stock 51 Retained earnings 52 Total common equity 53 Total liabilities and equity 1100 $1,0925 11000 $2,1925 8512 1578 $1,009 0 $3 2015 1000 59000 1,000.0 $1,900.0 853.7 914 $9450 $28450 FORMULAS NOPAT 2018 #N/A NOWC 2018 NOWC2017 5706.5 56700 =(B39-B36)-(B47-B46) =(D39-D36)-(D47-D46) 61 Total net operating capital 2. 1916 RERRAN A66 ROIC2018 C D 61 62 Total net operating capital2018 Total net operating capital 2017 B $2.1915 $2,020,0 -B58+B40 -B59+D40 Free cash flow 2018 #N/A ROIC 2018 33.6% =B26H(1-B157861 68 Uses of free cash flow. 69 After-tax interest payment 70 Reduction (increase) in debt 71 Payment of dividends 72 Repurchase (issue) stock 73 Purchase (sale) of short-term investments Total $71.0 $2925 $598.5 -$25 $2.5 =B27"(1-B15) =B49-049 =B31 =B50-050 =B36-036 #N/A 61 62 Total net operating capital2018 Total net operating capital 2017 $2.1915 $2,0200 B58+840 =B59+D40 64 Free cash flow 2018 #N/A ROIC 2018 =B26H(1-B157B61 $710 =B27"(1-815) #N/A Uses of free cash flow After-tax interest payment Reduction (increase in debt Payment of dividends Repurchase (issue) stock Purchase (sale) of short-term investments Total $5985 =B31 #N/A |$2.5 =B36-036 #N/A 76
