You were hired by Ln, Inc. test the company with its financial planning and is evaluate the company's performance. The given the wel reemt income and balance sheet of the company below. The experity tutis rule in 20197096 Sales for 2120 are projected to grow by 5 per The dividend payout rate and interest rate will remain content in the new year este ther expenses, cert, fed nets, and access payable in pesty with a new equity or deleted what he the external financing needed ( Eloppent the percent growth? it calledded paytrations well as interest rate and finally, wife, informatie hospity Input UNICORN, Inc. 2019 Income Statement Others Sales Chart Isoles TO 20240 04 15, Niet in O UNICORN, Inc. Halance sheet of Dersler1019 La Aquity Current Act Cub . 35,000 000 Current Account Payable Netsube That l Fixed Net PPAE Resideri Tocal Total Arts Calculation & Output UNICORN, Inc. Proforma Income Statement (2020 Com Pied Auto EBIT Freda Tees Nico Dividende [Add ToRE UNICORN, Inc. Proforma lance Sheet 2010 Current Assets Ace TotalCL TCA Leemed NITAR EFN You were hired by Unicorn, Inc., to assist the company with its financial planning and to evaluate the company's performance. You were also given the most recent income statement and balance sheet of the company (see below). The capacity utilization rate in 2019 was 70%. Sales for 2020 are projected to grow by 5 percent. The dividend payout rate and interest rate will remain constant in the new year. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. If no new equity or debt is issued, what is the external financing needed (EFN) to support the 5 percent sales growth? Hint: calculate dividend payout ratio as well as interest rate and finally, utilize, information about capacity. Input UNICORN, Inc. 2019 Income Statement 900,000 700,000 20,240 Other Inputs Sales Growth Tax rate Capacity Utilization in 2019 5% 3006 704 Sales Costs Other expenses EBIT Interest expense Taxable income Taxes Net income 15,000 Dividends Add to retained earnings 36,000 UNICORN, Inc. Balance Sheet as of December 2019 Assets Liabilities & Equity Current Assets Cash Accounts rec Inventory Total CA 25,000 35.000 80,000 Current Liabilities Accounts Payable Notes Payable TotalCL 60,000 15.000 Long-term debt 150.000 Fixed assets Net PP&E Sharcholder Equity Common stock Retained eaming Total Equity 400.000 11.000 160,000 Total Assets Total L&E Calculation & Output UNICORN, Inc. Proforma Income Statement (2020) Sales Costs Other expenses EBIT Interest expense Taxable income Taxes Net income Dividends Add. To RE Dividend payout ratio Interest Rate Fixed Asset Calculation Full capacity sales Fixed assets sales at full capacity UNICORN, Inc. 150.000 Fixed assets Net PPAE Shareholder Equity Common stock Retained earnings Total Equity 400,000 11.000 160,000 Total Assets Total LAE Calculation & Output UNICORN, Inc. Proforma Income Statement (2020) Sales Costs other EBIT Interesten Taxable income Taxes Net income Dividends A TO RE Dividend payout ratio Interest Rate Fixed Asset Calculation Full capacity sales Fixed assets sales at full capacity UNICORN, Inc. Proforma Balance Sheet (2010) Assets Liabilities & Equity Current Assets Cash Accounts rec lavestors Tot ICA Current Liabilities Accounts Payne Notes Payable TotalCL Long-term deb Net PPE Shareholder Equity Retained earning Total Equity Assets Total LAE EN You were hired by Ln, Inc. test the company with its financial planning and is evaluate the company's performance. The given the wel reemt income and balance sheet of the company below. The experity tutis rule in 20197096 Sales for 2120 are projected to grow by 5 per The dividend payout rate and interest rate will remain content in the new year este ther expenses, cert, fed nets, and access payable in pesty with a new equity or deleted what he the external financing needed ( Eloppent the percent growth? it calledded paytrations well as interest rate and finally, wife, informatie hospity Input UNICORN, Inc. 2019 Income Statement Others Sales Chart Isoles TO 20240 04 15, Niet in O UNICORN, Inc. Halance sheet of Dersler1019 La Aquity Current Act Cub . 35,000 000 Current Account Payable Netsube That l Fixed Net PPAE Resideri Tocal Total Arts Calculation & Output UNICORN, Inc. Proforma Income Statement (2020 Com Pied Auto EBIT Freda Tees Nico Dividende [Add ToRE UNICORN, Inc. Proforma lance Sheet 2010 Current Assets Ace TotalCL TCA Leemed NITAR EFN You were hired by Unicorn, Inc., to assist the company with its financial planning and to evaluate the company's performance. You were also given the most recent income statement and balance sheet of the company (see below). The capacity utilization rate in 2019 was 70%. Sales for 2020 are projected to grow by 5 percent. The dividend payout rate and interest rate will remain constant in the new year. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. If no new equity or debt is issued, what is the external financing needed (EFN) to support the 5 percent sales growth? Hint: calculate dividend payout ratio as well as interest rate and finally, utilize, information about capacity. Input UNICORN, Inc. 2019 Income Statement 900,000 700,000 20,240 Other Inputs Sales Growth Tax rate Capacity Utilization in 2019 5% 3006 704 Sales Costs Other expenses EBIT Interest expense Taxable income Taxes Net income 15,000 Dividends Add to retained earnings 36,000 UNICORN, Inc. Balance Sheet as of December 2019 Assets Liabilities & Equity Current Assets Cash Accounts rec Inventory Total CA 25,000 35.000 80,000 Current Liabilities Accounts Payable Notes Payable TotalCL 60,000 15.000 Long-term debt 150.000 Fixed assets Net PP&E Sharcholder Equity Common stock Retained eaming Total Equity 400.000 11.000 160,000 Total Assets Total L&E Calculation & Output UNICORN, Inc. Proforma Income Statement (2020) Sales Costs Other expenses EBIT Interest expense Taxable income Taxes Net income Dividends Add. To RE Dividend payout ratio Interest Rate Fixed Asset Calculation Full capacity sales Fixed assets sales at full capacity UNICORN, Inc. 150.000 Fixed assets Net PPAE Shareholder Equity Common stock Retained earnings Total Equity 400,000 11.000 160,000 Total Assets Total LAE Calculation & Output UNICORN, Inc. Proforma Income Statement (2020) Sales Costs other EBIT Interesten Taxable income Taxes Net income Dividends A TO RE Dividend payout ratio Interest Rate Fixed Asset Calculation Full capacity sales Fixed assets sales at full capacity UNICORN, Inc. Proforma Balance Sheet (2010) Assets Liabilities & Equity Current Assets Cash Accounts rec lavestors Tot ICA Current Liabilities Accounts Payne Notes Payable TotalCL Long-term deb Net PPE Shareholder Equity Retained earning Total Equity Assets Total LAE EN