please show work out in excel format. Thank you

19.10 Percent of sales: Given the data for Cattal Corporation in Problem 19. you assume that all balance sheet items also vary with the change in sales develop a pro forma balance sheet for Cattal for the next fiscaynar. Assuming that the firm did not sell or repurchase stock what the cash dividend implied by the pro forma income tatement and balance shoot 19.9 Percent of antes: Cattal Corporations financial statements for the fiscal year just ended are shown below Cattal Corporation Financial Statements for the Fiscal Yoar Just Endod income Statement Balance Sheet Net Sale $1,500,000 Asos $ 700,000 Dobl s 800,000 COOH 350,000 Equity 100,000 Notinoamo s 1:160.000 Total $ 700.000 Total 5 700,000 Catalmargement expects sales to increase by 14 percent next year. Assume that the financial statement accounts vary directly with changes in sales and that management has no financing plan at this timoGiven this information, develop a pro forma incomo statomont for Cattall for the next fiscal your