Freds Farm has the following costs and returns last year. $200,000 in revenue, $100,000 in input costs, $45,000 in labor, and $20,000 in overhead expenses. He paid $10,500 in income taxes. Use this information to answer the following questions. Hint: You will need to build the sensitivity analysis spread sheet.

1. How much before tax profit did Fred have last year and what is his average tax rate? What was his net income after tax?

2. Fred is considering raising his prices. What will a 10% increase in Freds prices do to his net income? (Provide new net income, and percentage change)

3. Fred is concerned that prices for his inputs (seed, fertilizer, fuel, et) may increase. What happens if Freds input prices increase by 5%? ((Provide new net income, and percentage change)

4. Fred is considering expanding. He would like to increase by 15%. He feels his labor would only increase by 5% and overhead would not increase. What would the results of the expansion be? (Provide new net income, and percentage change)