PLEASE ANSWER IN EXCEL FORMAT THAT IS EASILY UNDERSTOOD ONLY, THANK YOU!! (no writing please)

[EXCEL] Percent of sales: Cattail Corporation's financial statements for the fiscal year just ended are shown below:

Cattail Corporation

Income Statement

Net Sales: $1500

Costs: $350

Net Income: $1150

Balance Sheet

Assets $700 = $700

Debt $600

Equity 100 = $700

Cattail management 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 time. Given this information, develop a pro forma income statement for Cattail for the next fiscal year.

Part 2

Given the data for Cattail Corporation in Problem 9, if you assume that all balance sheet items also vary with the change in sales, develop a pro forma balance sheet for Cattail for the next fiscal year. Assuming that the firm did not sell or repurchase stock, what is the cash dividend implied by the pro forma income statement and balance sheet?