4 Moons Pizzeria

Start your own business plan »

Pizzeria Franchise 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
Total Restaurant Sales 0% $28,750 $57,500 $57,788 $58,076 $58,366 $58,658 $58,952 $59,246 $59,542 $59,840 $60,139 $60,440
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $28,750 $57,500 $57,788 $58,076 $58,366 $58,658 $58,952 $59,246 $59,542 $59,840 $60,139 $60,440
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
Cost of Sales $5,750 $11,500 $11,557 $11,616 $11,673 $11,732 $11,791 $11,849 $11,909 $11,968 $12,028 $12,088
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $5,750 $11,500 $11,557 $11,616 $11,673 $11,732 $11,791 $11,849 $11,909 $11,968 $12,028 $12,088
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
Wages 18% $10,000 $10,350 $10,402 $10,454 $10,506 $10,558 $10,611 $10,664 $10,718 $10,771 $10,825 $10,879
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 14 14 14 14 14 14 14 14 14 14 14 14
Total Payroll $10,000 $10,350 $10,402 $10,454 $10,506 $10,558 $10,611 $10,664 $10,718 $10,771 $10,825 $10,879
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 $28,750 $57,500 $57,788 $58,076 $58,366 $58,658 $58,952 $59,246 $59,542 $59,840 $60,139 $60,440
Direct Cost of Sales $5,750 $11,500 $11,557 $11,616 $11,673 $11,732 $11,791 $11,849 $11,909 $11,968 $12,028 $12,088
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $5,750 $11,500 $11,557 $11,616 $11,673 $11,732 $11,791 $11,849 $11,909 $11,968 $12,028 $12,088
Gross Margin $23,000 $46,000 $46,231 $46,460 $46,693 $46,926 $47,161 $47,397 $47,633 $47,872 $48,111 $48,352
Gross Margin % 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00%
Expenses
Payroll $10,000 $10,350 $10,402 $10,454 $10,506 $10,558 $10,611 $10,664 $10,718 $10,771 $10,825 $10,879
Marketing/Promotion 4% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Rent $4,242 $4,242 $4,242 $4,242 $4,242 $4,242 $4,242 $4,242 $4,242 $4,242 $4,242 $4,242
Royalty fees 5% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Equip rent/repair $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Utilities 11% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Admin charges $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Total Operating Expenses $17,242 $17,592 $17,644 $17,696 $17,748 $17,800 $17,853 $17,906 $17,960 $18,013 $18,067 $18,121
Profit Before Interest and Taxes $5,758 $28,408 $28,587 $28,764 $28,945 $29,126 $29,308 $29,491 $29,673 $29,859 $30,044 $30,231
EBITDA $8,258 $30,908 $31,087 $31,264 $31,445 $31,626 $31,808 $31,991 $32,173 $32,359 $32,544 $32,731
Interest Expense $2,013 $2,001 $1,989 $1,977 $1,966 $1,954 $1,942 $1,930 $1,918 $1,905 $1,893 $1,881
Taxes Incurred $1,124 $7,922 $7,979 $8,036 $8,094 $8,152 $8,210 $8,268 $8,327 $8,386 $8,445 $8,505
Net Profit $2,622 $18,485 $18,619 $18,751 $18,886 $19,020 $19,156 $19,293 $19,429 $19,567 $19,706 $19,845
Net Profit/Sales 9.12% 32.15% 32.22% 32.29% 32.36% 32.43% 32.49% 32.56% 32.63% 32.70% 32.77% 32.83%
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 $28,750 $57,500 $57,788 $58,076 $58,366 $58,658 $58,952 $59,246 $59,542 $59,840 $60,139 $60,440
Subtotal Cash from Operations $28,750 $57,500 $57,788 $58,076 $58,366 $58,658 $58,952 $59,246 $59,542 $59,840 $60,139 $60,440
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 $28,750 $57,500 $57,788 $58,076 $58,366 $58,658 $58,952 $59,246 $59,542 $59,840 $60,139 $60,440
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 $10,000 $10,350 $10,402 $10,454 $10,506 $10,558 $10,611 $10,664 $10,718 $10,771 $10,825 $10,879
Bill Payments $263 $8,538 $27,619 $26,300 $26,404 $26,506 $26,612 $26,717 $26,822 $26,929 $27,034 $27,142
Subtotal Spent on Operations $10,263 $18,888 $38,021 $36,753 $36,910 $37,065 $37,224 $37,382 $37,539 $37,700 $37,860 $38,021
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 $0 $1,993 $2,005 $2,017 $2,028 $2,040 $2,052 $2,064 $2,076 $2,088 $2,100 $2,113
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 $10,263 $20,881 $40,026 $38,770 $38,938 $39,105 $39,276 $39,446 $39,615 $39,788 $39,960 $40,134
Net Cash Flow $18,487 $36,619 $17,762 $19,306 $19,428 $19,553 $19,676 $19,800 $19,927 $20,052 $20,179 $20,306
Cash Balance $105,773 $142,393 $160,154 $179,460 $198,888 $218,441 $238,117 $257,918 $277,845 $297,897 $318,076 $338,382
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 $87,286 $105,773 $142,393 $160,154 $179,460 $198,888 $218,441 $238,117 $257,918 $277,845 $297,897 $318,076 $338,382
Inventory $10,000 $4,250 $5,750 $5,779 $5,808 $5,837 $5,866 $5,896 $5,925 $5,955 $5,984 $6,014 $6,044
Other Current Assets $41,775 $41,775 $41,775 $41,775 $41,775 $41,775 $41,775 $41,775 $41,775 $41,775 $41,775 $41,775 $41,775
Total Current Assets $139,061 $151,798 $189,918 $207,708 $227,043 $246,499 $266,082 $285,788 $305,617 $325,574 $345,656 $365,865 $386,201
Long-term Assets
Long-term Assets $99,732 $99,732 $99,732 $99,732 $99,732 $99,732 $99,732 $99,732 $99,732 $99,732 $99,732 $99,732 $99,732
Accumulated Depreciation $0 $2,500 $5,000 $7,500 $10,000 $12,500 $15,000 $17,500 $20,000 $22,500 $25,000 $27,500 $30,000
Total Long-term Assets $99,732 $97,232 $94,732 $92,232 $89,732 $87,232 $84,732 $82,232 $79,732 $77,232 $74,732 $72,232 $69,732
Total Assets $238,793 $249,030 $284,650 $299,940 $316,775 $333,731 $350,814 $368,020 $385,349 $402,806 $420,388 $438,097 $455,933
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 $0 $7,616 $26,743 $25,420 $25,521 $25,620 $25,722 $25,824 $25,924 $26,028 $26,130 $26,234 $26,338
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 $0 $7,616 $26,743 $25,420 $25,521 $25,620 $25,722 $25,824 $25,924 $26,028 $26,130 $26,234 $26,338
Long-term Liabilities $345,000 $345,000 $343,007 $341,002 $338,985 $336,957 $334,917 $332,865 $330,801 $328,725 $326,637 $324,537 $322,424
Total Liabilities $345,000 $352,616 $369,750 $366,422 $364,506 $362,577 $360,639 $358,689 $356,725 $354,753 $352,767 $350,771 $348,762
Paid-in Capital $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000
Retained Earnings ($266,207) ($266,207) ($266,207) ($266,207) ($266,207) ($266,207) ($266,207) ($266,207) ($266,207) ($266,207) ($266,207) ($266,207) ($266,207)
Earnings $0 $2,622 $21,107 $39,725 $58,476 $77,362 $96,382 $115,538 $134,831 $154,260 $173,828 $193,533 $213,378
Total Capital ($106,207) ($103,585) ($85,100) ($66,482) ($47,731) ($28,845) ($9,825) $9,331 $28,624 $48,053 $67,621 $87,326 $107,171
Total Liabilities and Capital $238,793 $249,030 $284,650 $299,940 $316,775 $333,731 $350,814 $368,020 $385,349 $402,806 $420,388 $438,097 $455,933
Net Worth ($106,207) ($103,585) ($85,100) ($66,482) ($47,731) ($28,845) ($9,825) $9,331 $28,624 $48,053 $67,621 $87,326 $107,171
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 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Long-term Interest Rate 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00%
Tax Rate 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