Calculate net operating working capital

Reference no: EM131518655

Question: Start with the partial model in the file IFM9 Ch07 P10 Build a Model.xls from the ThomsonNOW Web site. Cumberland Industries' most recent balance sheets (in thousands of dollars) are shown below and in the partial model in the file:

a. The company's sales for 2006 were $455,150,000, and EBITDA was 15 percent of sales. Furthermore, depreciation amounted to 11 percent of net fixed assets, interest charges were $8,575,000, the state-plus-federal corporate tax rate was 40 percent, and Cumberland pays 40 percent of its net income out in dividends. Given this information, construct Cumberland's 2006 income statement. (Hint: Start with the partial model in the file.)

b. Next, construct the firm's statement of retained earnings for the year ending December 31, 2006, and then its 2006 statement of cash flows.

c. Calculate net operating working capital, total net operating capital, net operating profit after taxes, and free cash flow for 2006.

d. Calculate the firm's EVA and MVA for 2006. Assume that Cumberland had 10 million shares outstanding, that the year-end closing stock price was $17.25 per share, and its after-tax cost of capital (WACC) was 12 percent.

Reference no: EM131518655

Questions Cloud

Statement the most reasonable possible : Fill in the blanks of the statement below to make the statement the most reasonable possible.

Discuss the du pont equation : Profit margins and turnover ratios vary from one industry to another. What differences would you expect to find between a grocery chain such as Safeway.

Explain why adjusting entries are necessary in accounting : Explain why the FASB requires the use of accrual basis accounting for financial external reporting. Explain why adjusting entries are necessary in accounting.

How the new tool or intervention may be integrated : A descriptive and reflective discussion of how the new tool or intervention may be integrated into practice that is supported by sound research.

Calculate net operating working capital : Start with the partial model in the file IFM9 Ch07 P10 Build a Model.xls from the ThomsonNOW Web site. Cumberland Industries' most recent balance sheets.

The quality and depth of information : elect one article from the results at each level of the hierarchy. Compare the articles based on the quality and depth of information.

Distinguish between entrepreneurship and small business : What characteristics increase the likelihood of success for entrepreneurs and small business owners? Distinguish between entrepreneurship and small business.

Show how it calculates this credit : The Herrmann Company has made $150,000 before taxes during each of the last 15 years, and it expects to make $150,000 a year before taxes in the future.

Create two tables containing data : Create two tables containing data with at least 4 columns and 4 rows of data each so that the tables clearly are not union-compatible

User Account

All Pages