4 Moons Pizzeria
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 | |
By 
