Excel HW 1 (Solution) - Spatula City 2012 Forecast Summary - Spatula City Forecase Income Statement 2012 Q1 2012 Q2 2012 Sales $ 719,939 $ 697,009 Cost

Excel HW 1 (Solution) - Spatula City 2012 Forecast Summary...

  • Homework Help
  • AugustoRamirez
  • 2
  • 100% (1) 1 out of 1 people found this document helpful

This preview shows page 1 out of 2 pages.

You've reached the end of your free preview.

Want to read both pages?

Unformatted text preview: Spatula City Forecase Income Statement 2012 Q1 2012 Q2 2012 Sales $ 719,939 $ 697,009 Cost of Goods Sold $ 138,385 $ 127,738 Gross Margin $ 581,554 $ 569,271 GM % 81% 82% Sales Expense $ 224,909 $ 222,460 Marketing Expense $ 70,000 $ 70,000 G&A Expense $ 102,500 $ 102,500 Total Operating Expense $ 397,409 $ 394,960 Operating Income (EBITDA) $ 184,146 $ 174,310 Net Income $ 184,146 $ 174,310 Spatula City case Income Statement 2012 Q3 2012 Q4 2012 $ 706,504 $ 730,078 $ 134,042 $ 236,645 $ 572,461 $ 493,433 81% 68% $ 224,020 $ 379,036 $ 70,000 $ 125,000 $ 102,500 $ 182,500 $ 396,520 $ 686,536 $ 175,941 $ (193,104) $ 175,941 $ (193,104) ...
View Full Document

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes