Need excel functions! Please help!

E F G H I J K M N O Information from the financial statements of the Heir Jordan Corporation are shown below. Prepare the pro forma financial statements and calculate EFN, assuming a 15 percent increase in sales, no new external debt or equity financing, and a constant payout ratio. Sales Costs Cash Accounts receivable Inventory Net plant and equipment Accounts payable Notes payable Long-term debt Common stock Retained earnings Dividends Net income UUA AGUA SAU AU 46,000 37,600 2,950 4,100 6,400 41,300 2,400 5,400 28,000 15,000 3,950 2,880 6,552 Increase in sales Tax rate 15% 21% Complete the following analysis. Do not hard code values in your calculations. Payout ratio 43.96% ... Sheet1 ... + O + + 30% READY Attempt(s) 7/10 Hint Pro forma income statement Sales Costs Taxable income Taxes Net income Dividends Addition to retained earnings Assets Current assets Cash Accounts receivable Inventory Total Balance Sheet Liabilities and Owners' equity Current liabilities Accounts payable Notes payable Total Long-term debt Fixed assets Net plant and equipment Owners' equity Common stock Retained earnings Total Total liabilities and owners' equity Total assets External financing needed ... Sheet1 ... + READY 0 0 0 - + 30%