The main goal here is to elaborate and prepare 1. pro forma income statement (using the fixed cost data)2. pro forma balance sheet (include a retained earnings adjustment account)3. Analyze these financial statements and comment on the resulting required external financing. Data: Projected sales are $6,000,000. Costs of goods sold in 2012 include $1,000,000 in fixed costs. Operating expenses in 2012 include $250,000 in fixed costs. Interest expenses remain unchanged. The company will pay cash dividends in an amount equal to 40% of net profits after taxes. Inventories and cash will double. Marketable securities, notes payable, long-term debt and common stock will remain unchanged. Accounts receivable, accounts payable, and other current liabilities will change in direct response to the change in sales. During the year a new computer system will be purchased at a cost of $356,000. Total depreciation expenses for the year will be $110,000. The tax rate will remain at 40%.please include the following accounts negotiable values $100,0000 buildings and facilities $ 820,000 accumulated depreciation $150,000 Please fill in the information for the following pro forma income statement and balance sheet using the data provided above. Pro Forma Income Statementsales minus cost of sales gross profits minus operating expenses operating profits minus financial expenses net profits before taxes minus taxes (rate 40%) net profits after taxes minus dividends retained earnings Proforma Balance Sheet Assets cash stock market values accounts receivable inventories total circulating assets fixed assets total assets