Based on the excel information provided, please answer the following using excel formula's:

1. Assume you are sitting in a board meeting discussing the firms plans for sales growth. You are telling the board that you expect to grow sales by 20 %. After explaining your plan, a board member asks you for an estimate of how much funding you will need in 2020. What is your answer if you use the formula for External Funds Needed?
2. Now assume the board member asks whether or not you can achieve the growth holding your capital structure constant. What is your answer?

A B C D E F G H K L 1 2 3 4 5 Assets: Cash Accounts Receivable Inventory Total Current Balance Sheet Liab+Eq: Acc Payable Accruals Total Current 2019 2018 $ 160 $ 154 $ 575 $ 455 $ 555 $ 450 $ 1,290 $ 1,059 2019 2018 $ 266 $ 100 $ 200 $ 150 $ 466 $ 250 6 Income Statement 2019 Sales $ 1,509 Cost of Goods Sold $ 900 Depreciation $ 90 Operating Income $ 519 7 00 O 350 Long-Term Debt Total Liab $ $ 380 $ 846 $ 10 600 70 Net Fixed Assets Total Assets $ 1,650 $ 1,400 $ 2,940 $ 2,459 Interest Expense Pre-tax Income $ $ 11 449 12 13 Taxes 212 $ $ Net Income 237 14 15 Common @ Par $ Capital Surplus $ Retained Earnings $ Treasury Stock $ Total Eq $ Total Liab & Eq $ 55 $ 45 585 $ 494 1,504 $ 1,370 (50) $ (50) 2,094 $ 1,859 2,940 $ 2,459 16 103 Dividends Addition to RE's $ $ 17 134 18 19 20 A B C D E F G H K L 1 2 3 4 5 Assets: Cash Accounts Receivable Inventory Total Current Balance Sheet Liab+Eq: Acc Payable Accruals Total Current 2019 2018 $ 160 $ 154 $ 575 $ 455 $ 555 $ 450 $ 1,290 $ 1,059 2019 2018 $ 266 $ 100 $ 200 $ 150 $ 466 $ 250 6 Income Statement 2019 Sales $ 1,509 Cost of Goods Sold $ 900 Depreciation $ 90 Operating Income $ 519 7 00 O 350 Long-Term Debt Total Liab $ $ 380 $ 846 $ 10 600 70 Net Fixed Assets Total Assets $ 1,650 $ 1,400 $ 2,940 $ 2,459 Interest Expense Pre-tax Income $ $ 11 449 12 13 Taxes 212 $ $ Net Income 237 14 15 Common @ Par $ Capital Surplus $ Retained Earnings $ Treasury Stock $ Total Eq $ Total Liab & Eq $ 55 $ 45 585 $ 494 1,504 $ 1,370 (50) $ (50) 2,094 $ 1,859 2,940 $ 2,459 16 103 Dividends Addition to RE's $ $ 17 134 18 19 20