Begin with the partial model in the file Ch02 P14 Build a Model.xlsx on the textbook's Web site.

a. 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 calculate total dividends and the addition to retained earnings. (Hint: Start with the partial model in the file and report all dollar figures in thousands to reduce clutter.)

b. The partial balance sheets of Cumberland Industries are shown here. Cumberland issued $10,000,000 of new common stock in 2016. Using this information and the results from Part a, fill in the missing values for common stock, retained earnings, total common equity, and total liabilities and equity.

Cumberland Industries: Balance Sheets as of December 31

(Thousands of Dollars)

c. Construct the statement of cash flows for 2016.

2 1 Total current assets $249,770$210,234 Total current liabilities Total liabilities $154,146 $123,896 Total common equity Total liabilities and equity $128,774