2-19 Begin with the partial model in the file Ch02 Build a Model.xlsx on the textbook's...
Build a Model: Free Cash Flows, EVA, and MVABegin with the partial model in the file Ch06 P15 Build a Model.xls on the textbook’s Web site.a. Using the financial statements shown below for Lan & Chen Technologies, calculate net operating working capital, total net operating capital, net operating profit after taxes, free cash flow, and return on invested capital for 2015. (Hint: Start with the partial model in the file and report all dollar figures in thousands to reduce clutter.)b....
Begin with the partial model in the file Ch02 P20 Build a Model.xlsx on the textbook's Web site a. Britton String Corp. manufactures specialty strings for musical instruments and tennis racquets. Its most recent sales were $880 million; operating costs (excluding depreciation) were equal to 85% of sales; net fixed assets were $300 million; depreciation amounted to 10% of net fixed assets, interest expenses were $22 million; the state-plus-federal corporate tax rate was 25%; and it paid 40% of its...
Begin with the partial model in the file Ch02 P14
Build a Model.xlsx on the textbook’s Web site.
The 2016 sales of Cumberland Industries were $455,000,000;
operating costs (excluding depreciation) were equal to 85% of
sales; net fixed assets were $67,000,000; depreciation amounted to
10% of net fixed assets; interest expenses were $8,550,000; the
state-plus-federal corporate tax rate was 40%; and Cumberland paid
25% of its net income out in dividends. Given this information,
construct Cumberland’s 2016 income statement. Also...
Spreadsheet Problems 2-18 Start with the partial model in the file Ch 02 Build a Model.xlsx at the textbook's website. Build a Model: Cumberland Industries' most recent balance sheets (in thousands of dollars) are shown Financial Statements, below and in the partial model in the file: EVA, and MVA 2015 2014 Cash Short-term investments Accounts receivable Inventories Total current assets Net fixed assets Total assets Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common steck $...
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 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...
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...
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...
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...
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...