F&R Enterprises Inc. Income Statements 2010 Total Revenue 71,887 Cost of Goods Sold 55,353 Gross Profit 16,534 Variable G&A 884 Fixed G&A 12,000 Fixed Depreciation 1500 Fixed Rent 650 Operating Expenses 15,034 EBIT 1,500 interest Expense 575 Earnings Before Taxes 925 Income Tax Expense 370 Income Before Minority Interest 555 Minority interest 0 555 Net Income 1. Using the Goal Seek Tool find the Net Income breakeven point fo each yea in nunits for the given prices. 2. Using the Goal Seek Tool find the breakeven price with an EBIT of 1500 ar unit sales of 3500 for each year 2011 76,926 59,233 17,693 1,411 12,000 1,500 650 15,561 2,132 600 1,532 613 919 13 932 2012 81,745 62,944 18,801 1,689 12,000 1,500 650 15,839 2,962 540 2,422 969 1,453 -17 1,436 2010 2011 2012 Break Even point in units Brak even with EBIT-1500 Units Sold Price Tax Rate Cost of Good Sold 3,594 20.00 40.0% 77.0% 3,663 21.00 40.0% 77.0% 3,633 22.50 40.0% 770N 370 555 Income Tax Expense Income Before Minority Interest Minority interest Net Income 613 919 13 932 969 1,453 17 1,436 2010 2011 2012 0 555 Break Even point in units Break even with EBIT-1500 Units Sold Price Tax Rate Cost of Good Sold 3,594 20.00 40.0% 77.0% 3,663 21.00 40.0% 77.0% 3,633 22.50 40.0% 77.0% Share Data Basic Shares Diluted Shares Basic EPS Diluted EPS 652 659 0.85 0.84 647 650 1.44 1.43 635 638 2.26 2.25 2012 5 3 3 1 1. Using the Goal Seek Tool find the Net Income breakeven point fo each year in nunits for the given prices. 81,745 62,944 18,801 1,689 12,000 1,500 650 15,839 2,962 540 2. Using the Goal Seek Tool find the breakeven price with an EBIT of 1500 and unit sales of 3500 for each year O 0 1 2 0