You are given the following financial information about your company (which matches the exam handout): Income Statement Year 0 Sales $40,000,000.00 -$26,000,000.00 Operating Costs Depreciation -$1,500,000.00 EBIT $12,500,000.00 Interest -$280,000.00 EBT $12,220,000.00 Taxes (40%) -$4,888,000.00 Net Income $7,332,000.00 Dividends Paid Out $2,932,800.00 Assets Year 0 $4,000,000.00 Cash Accounts Receivable $12,000,000.00 Inventories $16,000,000.00 Current Assets $32,000,000.00 Gross Plant & Equipment $15,000,000.00 Less: Depreciation -$6,000,000.00 Net Plant & Equipment $9,000,000.00 Total Assets $41,000,000.00 Liabilities & Equity Year 0 $10.000.000.00 Downblo B Operating Costs Depreciation EBIT Interest EBT Taxes (40%) Net Income Dividends Paid Out Assets Cash Accounts Receivable Inventories Current Assets Gross Plant & Equipment Less: Depreciation Net Plant & Equipment Total Assets Liabilities & Equity Accounts Payable Notes Payable Accruals Current Liabilities Long-Term Debt Common Stock Retained Earnings Total Liabilities & Equity $1,500,000.00 $12,500,000.00 -$280,000.00 $12,220,000.00 -$4,888,000.00 $7,332,000.00 $2,932,800.00 Year 0 $4,000,000.00 $12,000,000.00 $16,000,000.00 $32,000,000.00 $15,000,000.00 -$6,000,000.00 $9,000,000.00 $41,000,000.00 Year 0 $10,000,000.00 $1,500,000.00 $4,000,000.00 $15,500,000.00 $2,000,000.00 $19,800,000.00 $3,700,000.00 $41,000,000.00 a Amazon.com. Spe... 9 Maps VORBIMIT DIDA Retained Earnings www.www.www.ww $3,700,000.00 $41,000,000.00 Total Liabilities & Equity Now make the following assumptions: Sales are expected to increase by 20 percent in Year 1. Operating costs are expected to increase to 64.0 percent of sales. Fixed assets are being used at 90 percent of capacity. Fixed assets are lumpy. If the firm must add fixed assets, it must add a lump-sum of $2,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. All current assets and spontaneous liabilities can be expressed as a percent of sales and will grow proportionately with sales. At the start of the coming year, notes payable and long-term debt will not initially change. However, the notes payable account will be used to fund the AFN for the second pass. 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 12% for the notes payable. The tax rate will remain at 40 percent. The firm will increase its dividend payout rate from 40 percent to 50 percent of net income in Year 1, regardless of whether any new equity is issued. 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 AFN is handled through the notes payable (NP) account, either increasing or reducing NP. Given this information, determine what the return on equity (NI/Equity) is expected to be based on projections after the second pass (ignoring the remaining AFN after the second pass). Enter your answer in decimal format, truncated to 3 decimal places. For example, if your answer is 32.79%, enter "0.327". YouTube You are given the following financial information about your company (which matches the exam handout): Income Statement Year 0 Sales $40,000,000.00 -$26,000,000.00 Operating Costs Depreciation -$1,500,000.00 EBIT $12,500,000.00 Interest -$280,000.00 EBT $12,220,000.00 Taxes (40%) -$4,888,000.00 Net Income $7,332,000.00 Dividends Paid Out $2,932,800.00 Assets Year 0 $4,000,000.00 Cash Accounts Receivable $12,000,000.00 Inventories $16,000,000.00 Current Assets $32,000,000.00 Gross Plant & Equipment $15,000,000.00 Less: Depreciation -$6,000,000.00 Net Plant & Equipment $9,000,000.00 Total Assets $41,000,000.00 Liabilities & Equity Year 0 $10.000.000.00 Downblo B Operating Costs Depreciation EBIT Interest EBT Taxes (40%) Net Income Dividends Paid Out Assets Cash Accounts Receivable Inventories Current Assets Gross Plant & Equipment Less: Depreciation Net Plant & Equipment Total Assets Liabilities & Equity Accounts Payable Notes Payable Accruals Current Liabilities Long-Term Debt Common Stock Retained Earnings Total Liabilities & Equity $1,500,000.00 $12,500,000.00 -$280,000.00 $12,220,000.00 -$4,888,000.00 $7,332,000.00 $2,932,800.00 Year 0 $4,000,000.00 $12,000,000.00 $16,000,000.00 $32,000,000.00 $15,000,000.00 -$6,000,000.00 $9,000,000.00 $41,000,000.00 Year 0 $10,000,000.00 $1,500,000.00 $4,000,000.00 $15,500,000.00 $2,000,000.00 $19,800,000.00 $3,700,000.00 $41,000,000.00 a Amazon.com. Spe... 9 Maps VORBIMIT DIDA Retained Earnings www.www.www.ww $3,700,000.00 $41,000,000.00 Total Liabilities & Equity Now make the following assumptions: Sales are expected to increase by 20 percent in Year 1. Operating costs are expected to increase to 64.0 percent of sales. Fixed assets are being used at 90 percent of capacity. Fixed assets are lumpy. If the firm must add fixed assets, it must add a lump-sum of $2,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. All current assets and spontaneous liabilities can be expressed as a percent of sales and will grow proportionately with sales. At the start of the coming year, notes payable and long-term debt will not initially change. However, the notes payable account will be used to fund the AFN for the second pass. 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 12% for the notes payable. The tax rate will remain at 40 percent. The firm will increase its dividend payout rate from 40 percent to 50 percent of net income in Year 1, regardless of whether any new equity is issued. 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 AFN is handled through the notes payable (NP) account, either increasing or reducing NP. Given this information, determine what the return on equity (NI/Equity) is expected to be based on projections after the second pass (ignoring the remaining AFN after the second pass). Enter your answer in decimal format, truncated to 3 decimal places. For example, if your answer is 32.79%, enter "0.327". YouTube
