Use a spreadsheet (Excel) to prepare a pro-forma income statement showing the taxes and profit after tax for 2008. Use this spreadsheet to answer...

3. Use a spreadsheet (Excel) to prepare a pro-forma income statement showing the taxes and profit after tax for 2008. 4. Use this spreadsheet to answer the following questions. Return to the original assumptions before answering each question. A. What will be the profit after tax if gross sales decline to $ 1.9 million? B. What is the amount of Federal Tax paid if that rate changes to 32 percent? C. What gross sales are needed to generate an after tax profit of $1,000,000? D. Assume that the federal tax rate is 50%, and first year sales total $5,000,000. What will the net profit be? E. What if the materials could be reduced to $500,000? What would after tax profit be? F. What if fixed overhead is doubled? What would the profit after tax be? G. What if state taxes triple? What will be the after tax profit? H. Assuming everything else to be the same, what would the profit (or loss) be if sales dropped to 500,000, and Fixed Overhead was to increase to 120,000? I. Assume that