can you please show me how this problem will laid out and reference every cells answer. thank you

A B G 3 1 Financial Forecasting Zapatera Enterprises is evaluating its financing requirements for the coming year. The firm has only been in business for one year, but its CFO predicts that the firm's operating expenses, current assets and current liabilities will remain at their current proportion of sales. Last year was a big year for fixed asset purchases, but they are projected to remain at their current proportion of sales for 2021. Last year Zapatera has 12 million in sales with net income of $1.2 million. The firm anticipates that next year's sales will reach $16 million with net Income rising to $1.8 million. Given the company is new they are not planning on paying out any dividend in 2021 11 12 The firm's 2020 balance sheet is below and you are asked to prepare a forecast of the 2021 balance sheet and determine the amount of discretionary financing needed for 2021. 9 10 13 16 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Balance Sheet Current Assets Net Fixed Assets Total Assets Accounts Payable Long-term debt Total abilities Common Stock Pald-in capital Retained earnings Common equity Total Lia & Com Eq 2020 $3,000,000.00 $6,000,000.00 $9,000,000.00 $2,500,000.00 $2,500,000.00 $5,000,000.00 $1,000,000.00 $1,800,000.00 $1,200,000.00 $4,000,000.00 $9,000,000.00 30