{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Annual Forecast - Created by Yuliya Dzeravianka ACC115...

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

View Full Document Right Arrow Icon
Created by Yuliya Dzeravianka ACC115 Winter 2010 07/28/2011 Downtown Internet Café Annual Forecast JAN FEB MAR APR MAY JUN Sales Espresso $13,300 $13,600 $14,200 $14,400 $15,200 $15,500 Drip Coffee $5,800 $6,000 $6,200 $6,200 $6,200 $6,200 Food/Beverages $3,600 $3,800 $3,800 $3,600 $3,800 $3,800 Merchandise $1,000 $1,100 $1,100 $1,500 $1,500 $1,500 Computer $400 $400 $400 $600 $600 $800 Total Sales $24,100 $24,900 $25,700 $26,300 $27,300 $27,800 Expenses Cost of Goods $7,225 $7,480 $7,690 $7,620 $7,940 $8,015 Cost of Merchandise $700 $770 $770 $1,050 $1,050 $1,050 Payroll $9,000 $9,000 $9,000 $7,860 $8,390 $8,740 Internet $325 $325 $325 $325 $325 $325 Building $2,100 $2,100 $2,100 $2,100 $2,100 $2,100 Advertising $600 $600 $600 $600 $600 $600 Capital Assets $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 Miscellaneous $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 Total Expenses $22,750 $23,075 $23,285 $22,355 $23,205 $23,630 Income Net Income $1,350 $1,825 $2,415 $3,945 $4,095 $4,170 Profit Margin 5.60% 7.33% 9.40% 15.00% 15.00% 15.00% Quarter Profit Margin 12.38% 20.16% Income Year-To-Date $9,250 $25,660
Background image of page 1

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

View Full Document Right Arrow Icon
Created by Yuliya Dzeravianka ACC115 Winter 2010 07/28/2011 Downtown Internet Café Annual Forecast JUL AUG SEP OCT NOV DEC ANNUAL $15,200 $15,300 $15,800 $17,900 $18,500 $19,900 $188,800 $6,000 $6,000 $6,500 $6,900 $6,900 $6,900 $75,800 $4,000 $4,000 $4,000 $4,200 $4,400 $4,600 $47,600 $2,000 $2,000 $2,000 $2,000 $2,500 $3,500 $21,700 $800 $800 $600 $600 $600 $600 $7,200 $28,000 $28,100 $28,900 $31,600 $32,900 $35,500 $341,100 $8,000 $8,025 $8,300 $9,065 $9,335 $9,805 $98,500 $1,400 $1,400 $1,400 $1,400 $1,750 $2,450 $15,190 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $105,990 $325 $325 $325 $325 $325 $325 $3,900 $2,100 $2,100 $2,100 $2,100 $2,100 $2,100 $25,200 $600 $600 $600 $600 $600 $600 $7,200 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $18,000 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $15,600 $24,225 $24,250 $24,525 $25,290 $25,910 $27,080 $289,580 $3,775 $3,850 $4,375 $6,310 $6,990 $8,420 $51,520 13.48% 13.70% 15.14% 19.97% 21.25% 23.72% 15.10% 20.26% 28.78% $42,885 $71,660
Background image of page 2
Yuliya Dzeravianka 501980841e103092b78ca884e1e6b1fc7d09b29a.xlsx
Background image of page 3

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

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}