Question

1. Using the balance sheets listed below for the Ensong Corp., (all figures in $millions) calculate the Free Cash Flow and ROIC for 2016 assuming that Ensong reported EBIT of $657 million in 2016, and that their tax rate is 40%. (10 pts.) 2015 2016 2015 2016 Assets Liabilities & Equity Current assets: Current liabilities Accrued wages and 21 $ 105 $ 103 321 339 494548 S 938 $1,011 18 Cash ST Investments Accounts receivable Inventory S 76 $ 98 taxes Accounts payable Notes payable Total Long-term debt: Stockholders equity 246 27 S 544 S 591 S 937 $963 Total Fixed assets Gross plant and equipment $1,727 S2,063 Less: Depreciation197261 Net plant and Preferred stock (10 million shares) S 10 S 10 200 200 777 1049 Common stock and páid-in surplus (100 million shares) equipment $1,530 $1,802 Other long-term Retained earnings assets Total $1,530 S1,802 Total S 987 S1,259 Total assets S2468 S2.813 Total liabilities and equity $2468 $2.813

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Free Cash Flow

It is available cash to the Firm for distribution to Stockholder and Debt-holder.

Free cash Flow = Cash from operation - Capital expenditure

In above case, Free cash Flow for 2016 is $ 181 millions (rounded off). Please refer to below spreadsheet for calculations.

Return on Invested Capital (ROIC)

It is the ratio of Net operating profit after tax to Invested Capital at beginning of period.

ROIC = NOPAT/Invested capital.

In above case - ROIC - 20.49%

Please refer to below spreadsheet for calculations-

M13 C D Information from Balance Sheet of Ensong Co In $ millions Total Fixed Assets Current Assets Current Liabilities Long Term Debt retained 100% of its Income as Income statement not provided 2015 2016 1530 1802 938 1011 544 591 937 963 987 1259 Assuming Ensong co 2016 In $ millions 272 181 453 204 657 Net Income (EAT Add Tax | EBT Add Interest (EBIT-EBT -|EBIT EBIT Depreciation Retained Earnin Tax Rate Cash Non-cashWorking Capital 376 399 657 197261 777 1049 40% 21 10 Computation of Free Cash Flow of Esnsong Co 2016 12 13 14 15 16 17 18 19 20 21 657 181 64 23 336 181 EBIT 18 Less Tax Add Depreciation Less Increase in non-cash working Capital Less Capital Expenditure Free Cash Flow (FCF Computation of Return on Invested Capital (ROIC 2016 Invested Capital (opening Balance) Net Operationg Profit after tax (NOPAT) ROIC 1924 394 20.49% 23 24

Formula reference-

123 Xf122/121 E F G K L M Information from Balance Sheet of Ensong Co 2(In $ millions Total Fixed Assets Current Assets 2015 1530 938 2016 1802 1011 591 963 1259 Assuming Enson retained 100% of its income as Income statement not provided In $ millions Net Income (EAT D11-C11 (14/(1-D12) D12 4+15 D9-16 16+17 5 Current Liabilities Add Tax 937 987 6 Long Term Debt EBT AddInterest (EBIT-EBT -EBIT EBIT 657 261 1049 0.4 21 D4-D13-D5 197 10 Depreciation 11 Retained Earnin 12 13 Cash 14 Non-cashWorking Capital 15 16 Computation of Free Cash Flow of Es 2016 Tax Rate EBIT 18 18 Less Tax Add Depreciation Less Increase in non-cash working Capital Less Capital Expenditure -D10-C10 D14-C14 -D3-C3+114 112-113+114-115-116 Free Cash Flow (FCF 18 Computation of Return on Invested Capital (ROIC 20 21 2016 C6+C7 .112( 1-D12 -122/121 Invested Capital (opening Balance) Net rationg Profit after tax (NOPAT 23 24

Add a comment
Know the answer?
Add Answer to:
1. Using the balance sheets listed below for the Ensong Corp., (all figures in $millions) calculate...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as...

    Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents 14,000 15,000 Accounts receivable 30,000 35,000 33,070 29,000 Inventories $ 83,070 Total current assets $73,000 Net plant and equipment 50,000 46,000 Total assets $133,070 $119,000 Liabilities and Equity Accounts payable $10,500 9,000 Accruals 7,100 6,000 Notes payable 6,600 5,050 $ 24,200 20,050 Total current liabilities Long-term bonds 10,000 10,000 Total liabilities 34,200 30,050 Common stock...

  • Balance Sheets as of December 31 2016 2015 $ 14,000 1 Cash and equivalents Accounts receivable...

    Balance Sheets as of December 31 2016 2015 $ 14,000 1 Cash and equivalents Accounts receivable Inventories 12,000 25,000 23,000 $71.705 60,000 48,000 $120,705 $108,000 30,000 27,705 Total current assets Net plant and equipment Total assets 49,000 Liabilities and Equity $ 10.9008,500 7,000 5.050 s 25,20020,550 20,000 s 45.200 40.550 40,000 27.450 $75.5055 67450 $108.000 Accounts payable 7.500 Notes payable 6.800 Total current liabilities Long-term bonds 20,000 Total liabilities Common stock (4,000 shares) Retained earnings 40,000 Common equity Total liabilities...

  • Help Arlington Corporation's financial statements (dollars and shares are in milions) are provided here. Balance Sheets...

    Help Arlington Corporation's financial statements (dollars and shares are in milions) are provided here. Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents Accounts receivable Inventories $ 15,00014,000 30,000 28,000 80,325 $72,000 49,000 $134,325 $121,000 35,000 30,325 Total current assets Net plant and equipment Total assets 54,000 Liabilities and Equity Accounts payable Accruals Notes payable $ 10,400 8,500 7,500 6,700 $24,600 6,000 5,300 $19,800 Total current liabilities Liabilities and Equity Accounts payable Accruals Notes payable $ 10,400...

  • Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents Accounts receivable Inventories s13,000...

    Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents Accounts receivable Inventories s13,000 35,000 34,620 82,620 50,000 $132,620 s 12,000 25,000 22,000 59,000 49,000 $108,000 Total current assets Net plant and equipment Total assets Enter your answers in millions. For example, an answer of $25,000,00D,000 should be entered as 25,000. a. What was net operating working capital for 2015 and 20167 2015 S million Liabiwties and Equity Accounts payable Accruals Notes payable 2016 million 10,800 8,000 6,200...

  • Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents Accounts receivable Inventories $15,000...

    Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents Accounts receivable Inventories $15,000 14,000 30,000 .28,000 $81,235 $72,000 47,000 $119,000 35,000 31,235 Total current assets Net plant and equipment Total assets 50,000 $131,235 Liabilities and Equity Accounts payable Accruals Notes payable $10,000 7,100 7,000 8,500 7,000 5,150 Total current liabilities Long-term bonds Total liabilities Common stock (4,000 shares) Retained earnings 20,000 44,100 60,000 27,135 87,135 $131,235 $ 24,100 20,650 20,000 $40,650 60,000 18,350 $ 78,350 $119,000 Common...

  • FREE CASH FLOW Arlington Corporation's financial statements (dollars and shares are in millions) are provided here....

    FREE CASH FLOW Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents $  14,000 $  11,000 Accounts receivable 35,000 30,000 Inventories 31,975 28,000   Total current assets $ 80,975 $ 69,000 Net plant and equipment 50,000 45,000 Total assets $130,975 $114,000 Liabilities and Equity Accounts payable $ 10,500 $  9,500 Accruals 7,800 7,000 Notes payable 6,700 5,250   Total current liabilities $ 25,000 $ 21,750 Long-term bonds 10,000 10,000...

  • Columbia Sportswear Company reported the following in recent balance sheets (amounts in millions). (in millions) September...

    Columbia Sportswear Company reported the following in recent balance sheets (amounts in millions). (in millions) September 30, 2016 December 31, 2015 Assets Current Assets Cash $ 529 $ 540 Accounts Receivable 1,356 542 Inventories 1,650 704 Prepaid Rent 92 51 Total Current Assets 3,627 1,837 Software 560 208 Equipment 1,909 682 Total Assets $ 6,096 $ 2,727 Liabilities and Shareholders'​ Equity Liabilities Current Liabilities Accounts Payable $ 966 $ 699 Notes Payable (short-term) 0 2 Income Taxes Payable 91 5...

  • FREE CASH FLOW Arlington Corporation's financial statements (dollars and shares are in millions) are provided here....

    FREE CASH FLOW Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents $  13,000 $  11,000 Accounts receivable 25,000 20,000 Inventories 24,910 19,000   Total current assets $ 62,910 $ 50,000 Net plant and equipment 49,000 47,000 Total assets $111,910 $97,000 Liabilities and Equity Accounts payable $ 10,200 $  8,000 Accruals 7,900 7,000 Notes payable 7,000 5,250   Total current liabilities $ 25,100 $ 20,250 Long-term bonds 20,000 20,000...

  • Glocal Inc.: December 31: Balance Sheets (Millions of Dollars) Assets 2015 2016 iabilities and Equity Cash...

    Glocal Inc.: December 31: Balance Sheets (Millions of Dollars) Assets 2015 2016 iabilities and Equity Cash and equivalents 2016 2015 290 300 Accounts Payable Notes Payable Accruals Short-term investments 170 50 60 50 Accounts Receivable Inventories 190 140 300 400 130 200 350 300 Current Liabilities Total Current Assets 490 390 1,000 1,050 Long-Term Bonds 600 400 Total Liabilities Preferred stock 1,090 790 Net Plant and Equipment 30 40 1,000 550 Common Stock 200 170 Retained Earnings Total Common Equity...

  • Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as...

    Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2019 2018 Assets Cash and equivalents $  13,000 $  11,000 Accounts receivable 35,000 30,000 Inventories 30,380 26,000   Total current assets $ 78,380 $ 67,000 Net plant and equipment 46,000 45,000 Total assets $124,380 $112,000 Liabilities and Equity Accounts payable $ 10,300 $  8,000 Accruals 7,700 6,000 Notes payable 6,300 5,050   Total current liabilities $ 24,300 $ 19,050 Long-term bonds 15,000 15,000   Total liabilities $...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT