Excel Project 1 - $279,060.00 $55,812.00 $186,040.00...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Cassandra's Home Shopping Center Pro Forma Income Statement for Years 2005-2010 2005 2006 2007 2008 2009 Sales $250,000.00 $300,000.00 $360,000.00 $432,000.00 $518,400.00 Cost-of-Goods Sold $150,000.00 $180,000.00 $216,000.00 $259,200.00 $311,040.00 Gross Margin $100,000.00 $120,000.00 $144,000.00 $172,800.00 $207,360.00 Marketing Expenses $37,500.00 $45,000.00 $54,000.00 $64,800.00 $77,760.00 Admin. Expenses $25,000.00 $30,000.00 $36,000.00 $43,200.00 $51,840.00 Misc. Expenses $12,500.00 $15,000.00 $18,000.00 $21,600.00 $25,920.00 Total Expenses $75,000.00 $90,000.00 $108,000.00 $129,600.00 $155,520.00 Net Income $25,000.00 $30,000.00 $36,000.00 $43,200.00 $51,840.00 Annual Growth 1.2 Cost-of-Goods Sold 0.6 Marketing Expenses 0.15 Admin. Expenses 0.1 Misc. Expenses 0.05
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Total Average $1,860,400.00 $372,080.00 $1,116,240.00 $223,248.00 $744,160.00 $148,832.00
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $279,060.00 $55,812.00 $186,040.00 $37,208.00 $93,020.00 $18,604.00 $558,120.00 $111,624.00 $186,040.00 $37,208.00 2005 2006 2007 2008 2009 Total Average $0.00 $200,000.00 $400,000.00 $600,000.00 $800,000.00 $1,000,000.00 $1,200,000.00 $1,400,000.00 $1,600,000.00 $1,800,000.00 $2,000,000.00 Cost-of-Goods Sold Row 9 Admin. Expenses Total Expenses Net Income Sales Cost-of-Goods Sold Gross Margin Row 9 Marketing Expenses Admin. Expenses Misc. Expenses Total Expenses Row 14 Net Income $372,080.00 $223,248.00 $148,832.00 $55,812.00 $37,208.00 $18,604.00 $111,624.00 $37,208.00 Average 2005-2009 Expenses/Income Sales Cost-of-Goods Sold Gross Margin Marketing Expenses Admin. Expenses Misc. Expenses Total Expenses Net Income...
View Full Document

Page1 / 4

Excel Project 1 - $279,060.00 $55,812.00 $186,040.00...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online