23
V. PLANNED FINANCING
A. Projected income statements for first year’s operation
Bagels $82,493 $69,744 $78,744 $68,994 $299,975
Beverages $27,317 $23,095 $26,076 $22,847 $99,335
Soups/Salads $14,025 $11,857 $13,388 $11,730 $51,000
Breakfast Meals $11,441 $9,673 $10,921 $9,569 $41,604
Revenue $135,276 $114,369 $129,129 $113,141 $491,915
Total Net Revenue $135,276 $114,369 $129,129 $113,141 $491,915
Bagels $15,203 $12,853 $15,238 $12,715 $56,009
Packaging $3,594 $3,038 $3,602 $3,006 $13,240
Eggs & Bread $7,653 $6,470 $7,305 $6,400 $27,828
Vegetables $964 $815 $966 $806 $3,551
Other Supplies $4,590 $3,881 $4,601 $3,839 $16,911
Cost of Sold Goods $32,004 $27,057 $31,711 $26,766 $117,538
Employee Wages $29,459 $24,906 $28,120 $24,639 $107,124
Payroll Tax $4,191 $3,543 $4,001 $3,505 $15,240
Worker’s Comp Insurance $993 $840 $948 $831 $3,612
Health & Insurance $1,036 $876 $989 $867 $3,768
Labor Costs $35,679 $30,165 $34,058 $29,841 $129,743
Electric/Gas $1,630 $1,378 $1,556 $1,363 $5,927
Telephone & DSL $1,521 $1,286 $1,452 $1,272 $5,531
Utilities $3,151 $2,664 $3,008 $2,636 $11,459
Software & Hardware $1,323 $1,119 $1,263 $1,107 $4,812
Credit Card Fees $752 $636 $718 $629 $2,735
Contract Services $393 $332 $375 $328 $1,428
Loan Payments $4,746 $4,746 $4,746 $4,746 $18,984
Other Operating Costs $7,214 $6,833 $7,102 $6,810 $27,959
Cleaning Supplies $479 $405 $457 $400 $1,741
Promotions $635 $537 $606 $532 $2,310
Rent $13,025 $11,012 $12,433 $10,894 $47,364
Ovens & Cookers $2,003 $1,694 $1,912 $1,675 $7,284
Common Area
Maintenance
$2,831 $2,394 $2,703 $2,368 $10,296
Transportation Costs $5,596 $4,730 $5,341 $4,679 $20,346
Controllable Costs $24,569 $20,772 $23,452 $20,548 $89,341
Total Operating Expenses $102,617 $87,491 $99,331 $86,601 $376,040
Net Income Before Taxes $32,659 26,878 $29,798 $26,540 $115,875
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Total
Figure 5.1: Projected Yearly Income Statement