Battey Unlimited Financial Planning and Forecasting Assignment Based on information provided in the Excel template, construct a financial model by projecting balance sheet and income statement data for the company for the next five years. In building your pro-forma financial forecasts, identify operating assumptions on the basis of the most recent three- year average of balance sheet and income statement data. Estimate the AFN needed for each of the next five years on the basis of the following financing plans: a) AFN obtained by issuing long term debt b) 50% of AFN obtained by issuing long term debt and balance 50% AFN obtained by issuing short term debt. c) AFN obtained by issuing equity d) 50% AFN obtained by issuing long term debt and 50% by equity Compare the AFN needed, Debt/Asset Ratio, TIE, ROE, Earnings per share and dividends per share for each of the above four financing plans. Which plan would you recommend?