you do not need the financials IN excel

You are given the following financial information about your company: Year 1 (15) Year 1 (2nd) Income Statement Sales Operating costs Depreciation EBIT Interest Year 0 $11,000,000.00 -$7,150,000.00 $700,000.00 $3,150,000.00 -$280,000.00 $2,870,000.00 -$1,148,000.00 $1,722,000.00 $516,600.00 Taxes (40%) Net Income Dividends Paid Out Additional Funds Needed Now make the following assumptions: Sales are expected to increase by 25 percent in Year 1. Operating costs will remain 65% of Sales. Fixed assets are being used at 75 percent of capacity Fixed assets are lumpy. If the firm must add fixed assets, it must add a lump-sum of $3,000,000. Fixed assets are currently being depreciated on a straight line basis over a 10-year period. New fixed assets will also be depreciated on a straight line basis over 10 years. In the future, the firm wishes to maintain its cash balance at a constant level of $900,000, regardless of the level of sales. All other assets and spontaneous liabilities can be expressed as a percent of sales and will grow proportionately with sales. The before-tax interest rate on notes payable and long-term debt is currently 8 percent. Over the coming year it will remain at 8% for the long-term debt, but will increase to 10% for the notes payable. The belle coming year it will remain at 8 For LLIU payable The tax rate will remain at 40 percent. Because of a special tax bill, the firm will increase its dividend payout rate to 100 percent of net income in Year 1. regardless of whether any new equity is issued. The firm has decided that any additional funds needed (AFN) will be raised by issuing new common stock Using the spreadsheet method, and given the information above, do a first pass and calculate the additional funds needed, then do a second pass, assuming that all funds are raised by the issuance of new common stock, and determine the new return on equity that will then arise. Answer in decimal format, to 3 decimal places, truncated. For example, if your answer is 12.28%, enter "0.122" You are given the following financial information about your company: Year 1 (15) Year 1 (2nd) Income Statement Sales Operating costs Depreciation EBIT Interest Year 0 $11,000,000.00 -$7,150,000.00 $700,000.00 $3,150,000.00 -$280,000.00 $2,870,000.00 -$1,148,000.00 $1,722,000.00 $516,600.00 Taxes (40%) Net Income Dividends Paid Out Additional Funds Needed Now make the following assumptions: Sales are expected to increase by 25 percent in Year 1. Operating costs will remain 65% of Sales. Fixed assets are being used at 75 percent of capacity Fixed assets are lumpy. If the firm must add fixed assets, it must add a lump-sum of $3,000,000. Fixed assets are currently being depreciated on a straight line basis over a 10-year period. New fixed assets will also be depreciated on a straight line basis over 10 years. In the future, the firm wishes to maintain its cash balance at a constant level of $900,000, regardless of the level of sales. All other assets and spontaneous liabilities can be expressed as a percent of sales and will grow proportionately with sales. The before-tax interest rate on notes payable and long-term debt is currently 8 percent. Over the coming year it will remain at 8% for the long-term debt, but will increase to 10% for the notes payable. The belle coming year it will remain at 8 For LLIU payable The tax rate will remain at 40 percent. Because of a special tax bill, the firm will increase its dividend payout rate to 100 percent of net income in Year 1. regardless of whether any new equity is issued. The firm has decided that any additional funds needed (AFN) will be raised by issuing new common stock Using the spreadsheet method, and given the information above, do a first pass and calculate the additional funds needed, then do a second pass, assuming that all funds are raised by the issuance of new common stock, and determine the new return on equity that will then arise. Answer in decimal format, to 3 decimal places, truncated. For example, if your answer is 12.28%, enter "0.122