Add-in Problem Sorry, we couldn't find Solver.dam. Is it possible it was moved, renamed or deleted? D30 B C D E F G H The following information is available about the company. Please, present in Excel: Pro-forms Income statement as well as Balance sheet. Finally, calculate external financing needed in this 1 case (hint: use capacity utilization rate] 2 Input area: 3 Income statement Balance sheet 4 15,000 Current assets 4,100 Current liabilities 2,100 5 Costs 11,400 Fixed assets Long-term debt 3,700 6 Taxable income Equity 7 Taxes Total assets 22,500 Total 8 Net income g 10 Other Inputs 11 Payout ratio 40% 12 Capacity Utilization in the Last Year 95.0% 13 Sales Growth 15% 14 Tax rate 30% 15 16 17 Calculation & Output 18 Sales 19 Full Capacity Sales 20 Fixed assets/sales at full capacity 21 Pro forma income statement Pro forma balance sheet 22 Sales Current assets Current liabilities 23 Costs Fixed assets Long-term debt 24 Taxable income Equity 25 Taxes (30%) Total Total L&E 26 Net income 27 Dividends 28 Add. To RE 29 30 External financing 31 32 33 34 35 for Quiz q7 for Quiz q8 for Quiz q9 for Quiz q10 + where you can enter a new image height or width. Check the box to scale image. By deselecting Resample Image before you adjust the size, details as a new name to preserve the original image. Change the Size of a Picture in Windows