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

Show more

Calculate Your Essay Price
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more