Question: Please provide the formula required for each empty yellow box E27 Name Box A x fx B D E F G H 1 Name Due
Please provide the formula required for each empty yellow box

E27 Name Box A x fx B D E F G H 1 Name Due by 1 Build a Model 2 Chapter: 3 Problem: 9/13/21 5:30 PM 6 20 4 11 5 a. Britton String Corp. manufactures specialty strings for musical instruments and tennis racquets. Its most recent 6 sales were $880 million; operating costs (excluding depreciation) were equal to 85% of sales; net fixed assets were 7 $300 million; depreciation amounted to 10% of net fixed assets; interest expenses were $22 million; the state-plus- 8 federal corporate tax rate was 25%; and it paid 40% of its net income out in dividends. Given this information, 9 construct its income statement. Also calculate total dividends and the addition to retained earnings. Report all dollar 10 figures in millions. 12 The input information required for the problem is outlined in the "Key Input Data" section below. Using this data and the 13 balance sheet above, we constructed the income statement shown below. 14 15 Key Input Data for Britton String Corp. 2022 16 (Millions of dollars) 17 Sales Revenue $880 18 Expenses (excluding depreciation) as a percent of sales 85.0% 19 Net fixed assets $300 20 Depr. as a % of net fixed assets 10.0% 21 Tax rate 25.0% 22 Interest expense $22 23 Dividend Payout Ratio 40% 25 Britton String Corp.: Income Statement 2022 points 26 (Millions of dollars) 27 Sales 0.5 28 Operating costs excluding depreciation 0.5 29 EBITDA 0.5 30 Depreciation Cumberland has no amortization charges) 0.5 31 EBIT 0.5 32 Interest oxponse 0.5 33 EBT 0.5 34 Taxes (25%) 0.5 35 Net income 36 37 Common dividends 0.5 38 Addition to retained earnings 0.5 39 40 b. Britton String's partial balance sheets follow. Britton issued $36 million of new common stock in the most recent 6-20 + 24 5 Road
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
