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

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

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

This preview shows page 1 out of 3 pages.

#### You've reached the end of your free preview.

Want to read all 3 pages?

Unformatted text preview: Spatula City Forecase Income Statement 201 Q1 2012 Q2 2012 Sales \$ 719,939 \$ 697,009 Cost of Goods Sold \$ 138,385 \$ 127,738 Gross Margin 0.81 0.82 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 Net Income \$ 184,146 \$ 174,310 Spatula City ase Income Statement 2012 Q3 2012 \$ 706,504 \$ 134,042 0.81 81% \$ 224,020 \$ 70,000 \$ 102,500 \$ 396,520 \$ 175,941 Q4 2012 \$ 730,078 \$ 236,645 0.68 68% \$ 379,036 \$ 125,000 \$ 182,500 \$ 686,536 \$ (193,104) Pie! 26% 25% 25% 24% \$800,000 \$600,000 \$400,000 \$200,000 \$-­‐ Q1 2012 \$(200,000) \$(400,000) Q2 2012 Q3 2012 Q1 2012 Q2 2012 Q3 2012 Q4 2012 Sales Net Income Q4 2012 ...
View Full Document

• Winter '14
• Kitt