please show formulas using excel cells for example: = D7*D9

AB D E F G H J K 1 2 The most recent financial statements for Hornick, Inc., are shown below (assuming no income taxes). Assets and costs are proportional to sales. Debt and equity are not. No dividends are paid. Next year's sales are projected to be $8,968. What is the external financing needed? Income statement Sales Balance sheet 21,700 Debt 7,600 Assets $ $ 9,100 Costs 5,180 Equity 12,600 9 Net income $ 2,420 Total $ 21,700 Total $ 21,700 10 11 Next year's sales $ 8,968 12 13 14 Complete the following analysis. Do not hard code values in your calculations. 15 16 Percent increase in sales 18.00% 17 18 Pro forma income statement Pro forma balance sheet Sales Assets Debt 20 Costs Equity Total Total FR 17011 456700 8 2822 19 21 Net income www READY Sheet1 Inno 4 C Sales Costs Net income External financing D E F G Assets Total H Debt Equity Total K