F & R Enterprises Inc. Income Statements 2010 2011 2012 Total Revenue Cost of Goods Sold Gross Profit Variable G&A Fixed G&A Fixed Depreciation Fixed Rent Operating Expenses EBIT Interest Expense Earnings Before Taxes Income Tax Expense Income Before Minority Interest Minority Interest Net Income 1,887 74,17875,387 55,35357,117 58,048 6,534 17,061 17,339 884 1,4111,689 2,000 12,00012,000 500 1,500 1,500 650 5,034 15,561 15,839 500 1,500 540 Using the Goal Seek Tool find the Net Income breakeven point fo each year Using the Goal Seek Tool find the breakeven point with an EBIT of 1500 13 650 650 15 500 575 925 370 17 600 360 576 17 559 2012 13 553 2010 2011 Break Even point in units Break even with EBIT 1500 Units Sold 3,5943,6633,633 0.0020.25 20.75 40,0% 40,0% 40,0% 77.0% 77.0% 77.0% Tax Rate Cost of Good Sold Share Data Basic Shares Diluted Shares Basic EPS Diluted EPS 635 638 0.88 0.88 647 0.85 0.84 0.85 0.85