U Question 6 5 pts You are given the following information about your company: Year 1 (1) Year 1 (20 Income Statement Sales Operating Costs Depreciation EBIT Interest EBT Taxes (40%) Net Income Dividends Paid Out Year 0 $5,000,000.00 $3,000,000.00 -$200,000.00 $1,800,000.00 $70,000.00 $1,730,000.00 $692,000.00 $1,038,000.00 $519,000.00 Year 1 (1) Year 1 (2nd) Assets Cash Accounts Receivable Inventories Current Assets Gross Plant & Equipment Less: Depreciation Net Plant & Equipment Total Assets Year o $500,000.00 $1,500,000.00 $2,500,000.00 $4,500,000.00 $2,000,000.00 $800,000.00 $1,200,000.00 $5,700,000.00 Year 0 Year 1 (1) Liabilities & Equity Year 1 (2nd) Total Assets $5,700,000.00 Year 1 (1) Year 1 (2) Liabilities & Equity Accounts Payable Notes Payable Accruals Current Liabilities Long-Term Debt Common Stock Retained Earnings Total Liabilities & Equity Additional Funds Needed Year 0 $1,250,000.00 $200,000.00 $500,000.00 $1,950,000.00 $500,000.00 $2,100,000.00 $1,150,000.00 $5,700,000.00 $0.00 Now make the following assumptions: Sales are expected to increase by 20 percent in Year 1. The firm expects its cost of good sold (operating cost ratio, excluding depreciation) to be 70% in Year 1. Fixed assets are being used at 80 percent of capacity. Fixed assets are lumpy. If the firm must add fixed assets, it must add a lump sum of $500,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 $1,000,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 firm has already planned to increase its Notes Payable to $250,000 at the beginning of Year 1. The before-tax interest rate on notes payable and long-term debt is, and will remain, at 10.0 Scot The firm expects its cost of good sold (operating cost ratio, excluding depreciation) to be 70% in Year 1 Fixed assets are being used at 80 percent of capacity. Fixed assets are lumpy. If the firm must add fixed assets, it must add a lump sum of $500,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 $1,000,000, regardless of the level of sales. All other assetsland spontaneous liabilities can be expressed as a percent of sales and will grow proportionately with sales. The firm has already planned to increase its Notes Payable to $250,000 at the beginning of Year 1. The before-tax interest rate on notes payable and long-term debt is, and will remain, at 10.0 percent The tax rate will remain at 40 percent. The firm will maintain a dividend payout rate of 50 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 equity. 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 equity, and then determine what the new ROE will be after this is done. Answer in decimal format to 4 decimal places. For example, if your answer is 12.55%, enter "0.1255". MacBook Pro