Stock doesn't come u twice that's just the pictures. If you could please provide the formulas used so I can study off of them thank you.

The answers I need are the ones in yellow and it's the excel formulas I need.

ABC Company, Financial Model Value Drivers Sales growth Costs of goods sold/Sales Current assets/Sales Curetlabilities/Sales Net fixed assets growth rate Depreciation rate (of the avera Interest rate on debt Interest earned on cash balances Tax rate Dividend payout ratio 12% 45% 22% 20% Additional model assumptions 1. Cash balance remains constant, and the firm will not issue new shares or repurchase any existing shares 2. Debt is the plug 10% 8% 4% 36% 25% Part A. Construct pro forma income statements and pro forma balance sheets for the next 5 years Year Income statement Sales Costs of goods sold Depreciation Interest payments on debt Interest earned on cash Profit before tax Taxes Profit after tax Dividends Retained earnings 2 4 5 2,240,000 1,008,000 2,000,000 (900,000) (250,000) (300,000) 18,400 568,400 624) 363,776 (90,944) 272,832 2,508,800 2,809,856 3,147,039 1,128,960 1,264,435 1,416,167 3,524,683 1,586,108 #REF! Balance sheet 460,000 440,000 Cash Current assets Fixed assets At cost 4,000,000 (500,000) 3,500,000 4,400,000 Accumulate Depreciation Net fixed assets Total assets Crrt liabilities Debt Stock (1,500,000 shares) 400,000 3,000,000 750,000 ABC Company, Financial Model Value Drivers Sales growth Costs of goods sold/Sales Current assets/Sales Curetlabilities/Sales Net fixed assets growth rate Depreciation rate (of the avera Interest rate on debt Interest earned on cash balances Tax rate Dividend payout ratio 12% 45% 22% 20% Additional model assumptions 1. Cash balance remains constant, and the firm will not issue new shares or repurchase any existing shares 2. Debt is the plug 10% 8% 4% 36% 25% Part A. Construct pro forma income statements and pro forma balance sheets for the next 5 years Year Income statement Sales Costs of goods sold Depreciation Interest payments on debt Interest earned on cash Profit before tax Taxes Profit after tax Dividends Retained earnings 2 4 5 2,240,000 1,008,000 2,000,000 (900,000) (250,000) (300,000) 18,400 568,400 624) 363,776 (90,944) 272,832 2,508,800 2,809,856 3,147,039 1,128,960 1,264,435 1,416,167 3,524,683 1,586,108 #REF! Balance sheet 460,000 440,000 Cash Current assets Fixed assets At cost 4,000,000 (500,000) 3,500,000 4,400,000 Accumulate Depreciation Net fixed assets Total assets Crrt liabilities Debt Stock (1,500,000 shares) 400,000 3,000,000 750,000