You already forecasted most of McEwan Industries' Financial Statements. For the remainder (the green cells). you must oreate a preliminary foreoast, estimate the euternal finanoing need, then finalize the foreoast given the following assumptions: The ratios of accounts payable to sales and accruals to sales will be the same in 2022 as in 2021. MeEran will not issue any new stock (common or preferred) or nev long-term bonds. If nev finaneing is required, assume it will be raised by drawing on a line of credit with an interest rate of 12\%. Assume that any drav on the line of credit will be made on the last day of the year, so there vill be no additional interest expense for the nev line of eredit. If surplus funds are available, they will use those funds to pay off some or all of their long-term bonds. Find the enternal finanoing needed, then finalize the foreoast. Discussion: Does McEwan Industries have a financing deficit or surplus? What other approaches could MeEvan take to eliminate their deficit or surplus? You already forecasted most of McEwan Industries' Financial Statements. For the remainder (the green cells). you must oreate a preliminary foreoast, estimate the euternal finanoing need, then finalize the foreoast given the following assumptions: The ratios of accounts payable to sales and accruals to sales will be the same in 2022 as in 2021. MeEran will not issue any new stock (common or preferred) or nev long-term bonds. If nev finaneing is required, assume it will be raised by drawing on a line of credit with an interest rate of 12\%. Assume that any drav on the line of credit will be made on the last day of the year, so there vill be no additional interest expense for the nev line of eredit. If surplus funds are available, they will use those funds to pay off some or all of their long-term bonds. Find the enternal finanoing needed, then finalize the foreoast. Discussion: Does McEwan Industries have a financing deficit or surplus? What other approaches could MeEvan take to eliminate their deficit or surplus