Pizzeria del Causamali

Start your own business plan »

Pizzeria Business Plan

Appendix

Sales Forecast
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales
Pizza 0% $7,200 $12,600 $11,160 $12,000 $11,460 $11,340 $11,820 $11,160 $11,320 $11,640 $10,560 $11,640
Breadsticks 0% $1,000 $1,750 $1,550 $1,667 $1,592 $1,575 $1,642 $1,550 $1,642 $1,617 $1,467 $1,617
Beer 0% $2,000 $3,500 $3,100 $3,333 $3,183 $3,150 $3,283 $3,100 $3,283 $3,233 $2,933 $3,233
Drinks 0% $2,720 $4,760 $4,216 $4,533 $4,329 $4,284 $4,465 $4,216 $4,465 $4,397 $3,989 $4,397
Total Sales $12,920 $22,610 $20,026 $21,533 $20,564 $20,349 $21,210 $20,026 $20,710 $20,887 $18,949 $20,887
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Pizza 32% $2,304 $4,032 $3,571 $3,840 $3,667 $3,629 $3,782 $3,571 $3,622 $3,725 $3,379 $3,725
Breadsticks 20% $200 $350 $310 $333 $318 $315 $328 $310 $328 $323 $293 $323
Beer 20% $400 $700 $620 $667 $637 $630 $657 $620 $657 $647 $587 $647
Drinks 5% $136 $238 $211 $227 $216 $214 $223 $211 $223 $220 $199 $220
Subtotal Direct Cost of Sales $3,040 $5,320 $4,712 $5,067 $4,839 $4,788 $4,991 $4,712 $4,831 $4,915 $4,459 $4,915
Personnel Plan
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Kitchen Leads 0% $2,340 $2,340 $2,340 $2,340 $2,340 $2,340 $2,340 $2,340 $2,340 $2,340 $2,340 $2,340
Kitchen/Wait 0% $3,120 $3,120 $3,120 $3,120 $3,120 $3,120 $3,120 $3,120 $3,120 $3,120 $3,120 $3,120
Dishwasher 0% $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300
Owner 0% $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750
Delivery 0% $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300
Total People 12 12 12 12 12 12 12 12 12 12 12 12
Total Payroll $8,810 $8,810 $8,810 $8,810 $8,810 $8,810 $8,810 $8,810 $8,810 $8,810 $8,810 $8,810
General Assumptions
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00%
Long-term Interest Rate 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00%
Tax Rate 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Profit and Loss
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales $12,920 $22,610 $20,026 $21,533 $20,564 $20,349 $21,210 $20,026 $20,710 $20,887 $18,949 $20,887
Direct Cost of Sales $3,040 $5,320 $4,712 $5,067 $4,839 $4,788 $4,991 $4,712 $4,831 $4,915 $4,459 $4,915
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $3,040 $5,320 $4,712 $5,067 $4,839 $4,788 $4,991 $4,712 $4,831 $4,915 $4,459 $4,915
Gross Margin $9,880 $17,290 $15,314 $16,467 $15,726 $15,561 $16,220 $15,314 $15,880 $15,973 $14,491 $15,973
Gross Margin % 76.47% 76.47% 76.47% 76.47% 76.47% 76.47% 76.47% 76.47% 76.68% 76.47% 76.47% 76.47%
Expenses
Payroll $8,810 $8,810 $8,810 $8,810 $8,810 $8,810 $8,810 $8,810 $8,810 $8,810 $8,810 $8,810
Sales and Marketing and Other Expenses $500 $750 $750 $750 $750 $750 $750 $750 $250 $250 $500 $500
Depreciation $170 $170 $170 $170 $170 $170 $170 $170 $170 $170 $170 $170
Rent $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Utilities $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Insurance $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350
Payroll Taxes 15% $670 $670 $670 $670 $670 $670 $670 $670 $670 $670 $670 $670
Website Hosting and Maintenance 15% $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $12,350 $12,600 $12,600 $12,600 $12,600 $12,600 $12,600 $12,600 $12,100 $12,100 $12,350 $12,350
Profit Before Interest and Taxes ($2,470) $4,690 $2,714 $3,866 $3,125 $2,961 $3,619 $2,714 $3,779 $3,872 $2,140 $3,622
EBITDA ($2,300) $4,860 $2,884 $4,036 $3,295 $3,131 $3,789 $2,884 $3,949 $4,042 $2,310 $3,792
Interest Expense $102 $100 $98 $96 $94 $92 $90 $88 $85 $83 $81 $79
Taxes Incurred ($772) $1,377 $785 $1,131 $910 $861 $1,059 $788 $1,108 $1,137 $618 $1,063
Net Profit ($1,801) $3,213 $1,831 $2,639 $2,122 $2,008 $2,471 $1,838 $2,586 $2,652 $1,441 $2,480
Net Profit/Sales -13.94% 14.21% 9.14% 12.26% 10.32% 9.87% 11.65% 9.18% 12.49% 12.70% 7.61% 11.87%
Pro Forma Cash Flow
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Cash Received
Cash from Operations
Cash Sales $12,920 $22,610 $20,026 $21,533 $20,564 $20,349 $21,210 $20,026 $20,710 $20,887 $18,949 $20,887
Subtotal Cash from Operations $12,920 $22,610 $20,026 $21,533 $20,564 $20,349 $21,210 $20,026 $20,710 $20,887 $18,949 $20,887
Additional Cash Received
Sales Tax, VAT, HST/GST Received 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Investment Received $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $12,920 $22,610 $20,026 $21,533 $20,564 $20,349 $21,210 $20,026 $20,710 $20,887 $18,949 $20,887
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Expenditures from Operations
Cash Spending $8,810 $8,810 $8,810 $8,810 $8,810 $8,810 $8,810 $8,810 $8,810 $8,810 $8,810 $8,810
Bill Payments $9,590 $2,921 $9,309 $9,037 $10,016 $9,381 $9,359 $9,806 $9,113 $9,189 $9,254 $8,409
Subtotal Spent on Operations $18,400 $11,731 $18,119 $17,847 $18,826 $18,191 $18,169 $18,616 $17,923 $17,999 $18,064 $17,219
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Principal Repayment of Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $18,900 $12,231 $18,619 $18,347 $19,326 $18,691 $18,669 $19,116 $18,423 $18,499 $18,564 $17,719
Net Cash Flow ($5,980) $10,379 $1,407 $3,187 $1,238 $1,658 $2,541 $910 $2,288 $2,388 $386 $3,168
Cash Balance $17,120 $27,499 $28,906 $32,093 $33,331 $34,989 $37,530 $38,440 $40,728 $43,116 $43,501 $46,670
Pro Forma Balance Sheet
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Assets Starting Balances
Current Assets
Cash $23,100 $17,120 $27,499 $28,906 $32,093 $33,331 $34,989 $37,530 $38,440 $40,728 $43,116 $43,501 $46,670
Inventory $6,000 $2,960 $1,862 $1,649 $1,773 $1,694 $1,676 $1,747 $1,649 $1,691 $1,720 $1,561 $1,720
Other Current Assets $5,250 $5,250 $5,250 $5,250 $5,250 $5,250 $5,250 $5,250 $5,250 $5,250 $5,250 $5,250 $5,250
Total Current Assets $34,350 $25,330 $34,611 $35,805 $39,116 $40,275 $41,915 $44,527 $45,339 $47,669 $50,086 $50,312 $53,640
Long-term Assets
Long-term Assets $20,300 $20,300 $20,300 $20,300 $20,300 $20,300 $20,300 $20,300 $20,300 $20,300 $20,300 $20,300 $20,300
Accumulated Depreciation $0 $170 $340 $510 $680 $850 $1,020 $1,190 $1,360 $1,530 $1,700 $1,870 $2,040
Total Long-term Assets $20,300 $20,130 $19,960 $19,790 $19,620 $19,450 $19,280 $19,110 $18,940 $18,770 $18,600 $18,430 $18,260
Total Assets $54,650 $45,460 $54,571 $55,595 $58,736 $59,725 $61,195 $63,637 $64,279 $66,439 $68,686 $68,742 $71,900
Liabilities and Capital Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Current Liabilities
Accounts Payable $9,500 $2,611 $9,008 $8,702 $9,703 $9,070 $9,031 $9,503 $8,806 $8,880 $8,975 $8,089 $9,267
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $9,500 $2,611 $9,008 $8,702 $9,703 $9,070 $9,031 $9,503 $8,806 $8,880 $8,975 $8,089 $9,267
Long-term Liabilities $25,000 $24,500 $24,000 $23,500 $23,000 $22,500 $22,000 $21,500 $21,000 $20,500 $20,000 $19,500 $19,000
Total Liabilities $34,500 $27,111 $33,008 $32,202 $32,703 $31,570 $31,031 $31,003 $29,806 $29,380 $28,975 $27,589 $28,267
Paid-in Capital $46,000 $46,000 $46,000 $46,000 $46,000 $46,000 $46,000 $46,000 $46,000 $46,000 $46,000 $46,000 $46,000
Retained Earnings ($25,850) ($25,850) ($25,850) ($25,850) ($25,850) ($25,850) ($25,850) ($25,850) ($25,850) ($25,850) ($25,850) ($25,850) ($25,850)
Earnings $0 ($1,801) $1,412 $3,243 $5,883 $8,005 $10,014 $12,484 $14,323 $16,909 $19,561 $21,003 $23,483
Total Capital $20,150 $18,349 $21,562 $23,393 $26,033 $28,155 $30,164 $32,634 $34,473 $37,059 $39,711 $41,153 $43,633
Total Liabilities and Capital $54,650 $45,460 $54,571 $55,595 $58,736 $59,725 $61,195 $63,637 $64,279 $66,439 $68,686 $68,742 $71,900
Net Worth $20,150 $18,349 $21,562 $23,393 $26,033 $28,155 $30,164 $32,634 $34,473 $37,059 $39,711 $41,153 $43,633