Begin with the partial model in the file Ch06 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 net income out in dividends. Given this information, construct its income statement. Also calculate total dividends and the addition to retained earnings. Report all dollar figures in millions. 

b. Britton String’s partial balance sheets follow. Britton issued $36 million of new common stock in the most recent year. 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. 

c. Construct the statement of cash flows for 2022.

Britton String Corp.: Balance Sheets as of December 31 (Millions of Dollars) Assets Cash and cash equivalents Short-term investments Accounts receivable Inventories Total current assets Net fixed assets Total assets Liabilities and Equity Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained earnings Total common equity Total liabilities and equity 2022 $ 70 46 120 264 $500 300 $800 $73 49 30 $152 217 $369 285 146 $431 $800 2021 $ 60 42 140 196 $438 262 $700 $ 64 60 39 $163 178 $341 249 110 $359 $700