use excel

Q1 20 pts EFN Data from Epo's 2021 Income statement & balance sheet and 2022 sales forecast are below. Forecast: 2022 Sales growth rate 45.0% Actual Fiscal Year: 2021 Sale STO $3,500,000 Costs $2.050.000 Taxable income $1,450,000 Taxes $362.500 Net income $1,087,500 Dividends $163.125 Addition to RE $924,375 Forecast 2022 Forecast 2022 Assets: Actual Fiscal Year: 2021 Cash $110,000 Acts Receivable 390,000 Inventories 365,000 Net Fixed Assets 1.520.000 CL & Equity Actual Fiscal Year: 2021 Acts Payable $265,950 Accruals 273,817 Notes payable 100,000 LT Debt 521,500 Common Stock 175,300 Retained Earnings 1.048,433 Total Liab & Equity $2,385,000 Total Assets $2,385,000 Epo's fixed assets are at 100% capacity and current asset relationships to sales reflect desired levels for operations. Epo expects to reduce its costs by 10% next year and will face a 30% tax rate. Epo's bank has told them they will not increase the current line of credit. Forecast the pro forma financial statements using a % of sales approach. Show your work above. What is Epo's need for external funds (EFN) in the coming year, 2022? #1 EFN = $ Forecast the pro forma financial statements using a % of sales approach. Show your work above. What is Epo's need for external funds (EFN) in the coming year, 2022? #1 EFN = $ #2 Estimate the sustainable growth rate. #3 What would the impact on EFN be supply chain issues increased costs by 20%? Answer in words and with supporting numbers