Excel Project 1

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

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

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

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

View Full Document
Total Average \$1,860,400.00 \$372,080.00 \$1,116,240.00 \$223,248.00 \$744,160.00 \$148,832.00

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

View Full Document
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

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online