--------

refer to second picture FIRST to answer the QUESTIONS. thank you

The nancial management team of Discovery Manufacturing is getting ready for its annual account review with is banker. The company is considering an expansion next year, and this would require additional nancing. The CFO needs to prepare a nancial forecast and determine how much nancing they will need. Last year, Discovery had sales of $100 million and was already operating at capacity. The sales and marketing team is condent this expansion would result in a sales increase of 15%. Balance Sheet (Millions) Assets Liabilities & Shareholder's Equity Cash $7 Accounts Payable $8 Accounts Receivable 12 Accrued Wages 6 Inventory E Accrued Taxes g Current Assets 39 Chrrrent Liabilities 18 Long-term Debt 10 Capital Assets Common Stock 15 Retained Earnings 2 TOTAL Liabilities & Shareholder's Equity TOTAL Assets 78 78 o The aftertax prot margin is 4% ., Dividend payout is 35% QUESTIONS: a) What is the required new funds needed to nance the expansion? b) Prepare a pro-forma balance sheet with any nancing adjustment made to long term debt. Use the template below: c) What is the cunent ratio and total debttoassets ratio for each year? TEMPLATE: Pro-forma Balance Sheet (Millions) Assets Liabilities 8: Shareholder's E I ui Cash Accounts Payable Accounts Receivable Accrued Wages Inventory Accrued Taxes Capital Assets Longterm Debt Common Stock Retained Earnings TOTAL Liabilities & Shareholder's Equity TOTAL Assets