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? Battery Unlimited Assumption calma NIS 2012 2013 Average 200 21 2002 20 2024 2019 52 513613 2017 SIA 230 59.410 S100 55.25 500 Income Statement Sales Cost of Sales Gratis SO Depreciation ESIT spense Pretax income comes Netice Didels Addition Balance Sheet Art 52355 511 S2457 SA $180 $1,925 5108 SL19 SUB SI 7471 S013 59.00 9 SLIS sous SLO 5240 SUSO 57 5155 525 S SM 2010 2021 2022 2031 700 2017 5508 2019 S06 50 SUSAS SE30 Marie Securities Accounts Receivable ories Totat current de Net plant and Tor Assets 2018 3609 50 510 $1838 55.542 5230 STE $2.00 SES $2.45 SURSY SAD 5125 58.00 52145 13 $125 $1412 Les Currenties of IT Accounts Payable Actress Total Current Long Term Det Common Stock Bened in Total Shareholder Totalt 11000 5125 $140 5205 51210 5950 5115 55,880 $5,015 58.983 5875 51 135 52990 54065 5723 51.125 $1,2 S60 Proj Assets Prosti AIN 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? Battery Unlimited Assumption calma NIS 2012 2013 Average 200 21 2002 20 2024 2019 52 513613 2017 SIA 230 59.410 S100 55.25 500 Income Statement Sales Cost of Sales Gratis SO Depreciation ESIT spense Pretax income comes Netice Didels Addition Balance Sheet Art 52355 511 S2457 SA $180 $1,925 5108 SL19 SUB SI 7471 S013 59.00 9 SLIS sous SLO 5240 SUSO 57 5155 525 S SM 2010 2021 2022 2031 700 2017 5508 2019 S06 50 SUSAS SE30 Marie Securities Accounts Receivable ories Totat current de Net plant and Tor Assets 2018 3609 50 510 $1838 55.542 5230 STE $2.00 SES $2.45 SURSY SAD 5125 58.00 52145 13 $125 $1412 Les Currenties of IT Accounts Payable Actress Total Current Long Term Det Common Stock Bened in Total Shareholder Totalt 11000 5125 $140 5205 51210 5950 5115 55,880 $5,015 58.983 5875 51 135 52990 54065 5723 51.125 $1,2 S60 Proj Assets Prosti AIN