F&R Enterprises Inc. Income Statements 2010 Total Revenue 71,887 Cast of Goods Sold 55,353 Gross Profit 16,514 Variable GBA 84 Fixed GRA 12.000 Fixed Depreciation 1500 The Rent 650 Operating Expenses 15,034 1,500 Interest Expense 525 Earnings Before Taxes 925 Income Tax Expense 370 Income Before Minority interest 555 Minority interest O 555 Net Income 1. Using the Goal Seek Tool find the Net Income breakeven point for each year in nunits for the given prices 2. Uning the Goat Seck Yool find the breakeven price with an eart of 1500 and unit sales of 3500 for each year 2011 2012 76,926 81,745 59,233 62,944 17.693 18,01 1,411 1,609 12,000 12,000 1,500 1,500 650 650 15,561 15,239 2,132 2.962 600 540 1,532 2,422 61 919 1,453 13 -17 932 1.436 6 2010 2011 2012 Break Evert point in units Rreak even with T 1500 Units Sold Price Tax Rate Cost of Good sold 3,594 20.00 400 2701 3,663 21.00 40.ON 77.00 3633 22 50 40.00 77.00 Share Data Operating Expenses EBIT Interest Expense Earnings Before Taxes Income Tax Expense Income Before Minority interest Minority interest Net Income 15,034 15,561 1,500 2,132 575 600 925 1,532 370 613 555 919 0 13 555 932 15,839 2,962 540 2,422 969 1,453 -17 1,436 2010 2011 2012 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.ON 77.0% 3,633 22.50 40.0% 77.0% 652 659 Share Data Basic Shares Diluted Shares Basic EPS Diluted EPS 642 650 1.44 1.43 635 638 2.26 2.25 0.85 0.84 F&R Enterprises Inc. Income Statements 2010 Total Revenue 71,887 Cast of Goods Sold 55,353 Gross Profit 16,514 Variable GBA 84 Fixed GRA 12.000 Fixed Depreciation 1500 The Rent 650 Operating Expenses 15,034 1,500 Interest Expense 525 Earnings Before Taxes 925 Income Tax Expense 370 Income Before Minority interest 555 Minority interest O 555 Net Income 1. Using the Goal Seek Tool find the Net Income breakeven point for each year in nunits for the given prices 2. Uning the Goat Seck Yool find the breakeven price with an eart of 1500 and unit sales of 3500 for each year 2011 2012 76,926 81,745 59,233 62,944 17.693 18,01 1,411 1,609 12,000 12,000 1,500 1,500 650 650 15,561 15,239 2,132 2.962 600 540 1,532 2,422 61 919 1,453 13 -17 932 1.436 6 2010 2011 2012 Break Evert point in units Rreak even with T 1500 Units Sold Price Tax Rate Cost of Good sold 3,594 20.00 400 2701 3,663 21.00 40.ON 77.00 3633 22 50 40.00 77.00 Share Data Operating Expenses EBIT Interest Expense Earnings Before Taxes Income Tax Expense Income Before Minority interest Minority interest Net Income 15,034 15,561 1,500 2,132 575 600 925 1,532 370 613 555 919 0 13 555 932 15,839 2,962 540 2,422 969 1,453 -17 1,436 2010 2011 2012 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.ON 77.0% 3,633 22.50 40.0% 77.0% 652 659 Share Data Basic Shares Diluted Shares Basic EPS Diluted EPS 642 650 1.44 1.43 635 638 2.26 2.25 0.85 0.84