Annual Forecast

Annual Forecast - Created by Yuliya Dzeravianka ACC115...

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

View Full Document Right Arrow Icon

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

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

Unformatted text preview: 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 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...
View Full Document

Page1 / 6

Annual Forecast - Created by Yuliya Dzeravianka ACC115...

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

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