17. What will net operating income be on the contribution format income statement for the projected Year 16 year end? 18. How much cash is projected to be added by the end of Year 16 from operating activities? 19. How much cash is the company projected to have at the end of Year 16? 20. What is the interest rate on the company's note payable? Page 3 of 6 Foxtrot Manufacturing Company, LLC Latest Operating Year Proforma for Year 15% | Next Operating 16% Functional Format Income Statement Year 1s Year 16 # units sold Average price per unit Sales revenue Less: cost of goods sold Gross margin Less: marketing & selling expenses Less: general & administrative e Net operating income Less: other expenses (interest) Net income before taxes 100,000 $10.00 $1,000,000 600,000 400,000 | 230,000 70,000 100,000 10,220 89,780 29,627 110,000 $10.10 100% $1,111,0001 100% ! 650,000 461,000 41.49% 40.0% 240,000 80,000 141,000 9,380 131,620 39.486 $92.134) Less: allowance for income taxes Net income after taxes 8.2929% $60.153 | 6.0153% | Latest Operating Proforma for Year 15 Foxtrot Manufacturing Company, LLC Selected Data from the Contribution Format Income Statement Variable expenses Fixed ex Next Operating Year 16 $550,000 $420,000 $500,000 $400,000 Foxtrot Manufacturing Company, LLC Fair Market Value Balance Sheets- Year End Year 15 Latest Operating Year 15% Proforma for Year |Next Operating 116% Year 16 120,000 Cash Short term securities Accounts receivable Inventory Total: current assets Fixed assets $110,000 $75,000 100,000 80,000 300,000 300,000 Other/intangible assets Total assets $600,000 100,000 140,000 240,000 360,000 $600,000 105,000 128,000 233,000 Accounts payable Notes payable Total liabilities ul Total liabilities& equity Page 4 of Foxtrot Manufacturing Company LLC Cash Flow Statement Latest Operating Proforma for Next Year 15 Operating Year 16 Operating Activities Net Income Depreciation Other non-cash expenses Increase/decrease in accounts receivable Increase/decrease in inventories Increase/decrease in accounts payable Subtotal: Net Cash from Operating Activities 30,000 0 $92,134 30,000 0 Long-term Investing Activities Purchase or sale of fixed assets Subtotal: Net Cash Used in Investing Activities 0 0 0 Financing Activities Increase/decrease in notes payable increase/decrease in bonds outstanding Payment of dividends to stockholders Sale or repurchase of stock Subtotal: Net Cash from Financing Activities 12,000 -12,000 0 0 0 -12,000 0 0 0 -12,000 Summary Net Increase in Cash Cash & Equivalents at the Beginning of the Year Total: Cash& Equivalents at the End of the Year