Belle Epoque Dinner Theatre
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 | ||
| Unit Sales | |||||||||||||
| Lunch Sales | 0% | 5,130 | 5,940 | 10,395 | 10,395 | 10,395 | 5,940 | 5,130 | 5,130 | 5,130 | 5,130 | 5,130 | 5,130 |
| High Tea Sales | 0% | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 |
| Dinner Sales | 0% | 2,970 | 3,780 | 10,395 | 10,395 | 10,395 | 5,000 | 5,000 | 4,000 | 3,700 | 3,500 | 3,700 | 3,500 |
| Dinner Show Sales | 0% | 2,727 | 5,427 | 8,640 | 8,640 | 8,640 | 7,000 | 6,000 | 5,000 | 5,000 | 4,000 | 3,000 | 4,000 |
| Bar Sales | 0% | 1,350 | 1,350 | 5,400 | 5,400 | 5,400 | 1,350 | 1,350 | 1,350 | 1,350 | 1,350 | 1,350 | 1,350 |
| Be In the Show Sales | 0% | 270 | 270 | 270 | 270 | 270 | 270 | 270 | 270 | 270 | 270 | 270 | 270 |
| Catering Sales | 0% | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 2 | 0 | 0 | 0 |
| Total Unit Sales | 13,257 | 17,577 | 35,910 | 35,911 | 35,911 | 20,370 | 18,560 | 16,560 | 16,262 | 15,060 | 14,260 | 15,060 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Lunch Sales | $14.00 | $14.00 | $14.00 | $14.00 | $14.00 | $14.00 | $14.00 | $14.00 | $14.00 | $14.00 | $14.00 | $14.00 | |
| High Tea Sales | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | |
| Dinner Sales | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | |
| Dinner Show Sales | $55.00 | $55.00 | $55.00 | $55.00 | $55.00 | $55.00 | $55.00 | $55.00 | $55.00 | $55.00 | $55.00 | $55.00 | |
| Bar Sales | $20.00 | $20.00 | $35.00 | $35.00 | $35.00 | $20.00 | $20.00 | $20.00 | $20.00 | $20.00 | $20.00 | $20.00 | |
| Be In the Show Sales | $65.00 | $65.00 | $65.00 | $65.00 | $65.00 | $65.00 | $65.00 | $65.00 | $65.00 | $65.00 | $65.00 | $65.00 | |
| Catering Sales | $0.00 | $0.00 | $0.00 | $9,000.00 | $10,000.00 | $0.00 | $0.00 | $0.00 | $5,000.00 | $0.00 | $0.00 | $0.00 | |
| Sales | |||||||||||||
| Lunch Sales | $71,820 | $83,160 | $145,530 | $145,530 | $145,530 | $83,160 | $71,820 | $71,820 | $71,820 | $71,820 | $71,820 | $71,820 | |
| High Tea Sales | $14,580 | $14,580 | $14,580 | $14,580 | $14,580 | $14,580 | $14,580 | $14,580 | $14,580 | $14,580 | $14,580 | $14,580 | |
| Dinner Sales | $71,280 | $90,720 | $249,480 | $249,480 | $249,480 | $120,000 | $120,000 | $96,000 | $88,800 | $84,000 | $88,800 | $84,000 | |
| Dinner Show Sales | $149,985 | $298,485 | $475,200 | $475,200 | $475,200 | $385,000 | $330,000 | $275,000 | $275,000 | $220,000 | $165,000 | $220,000 | |
| Bar Sales | $27,000 | $27,000 | $189,000 | $189,000 | $189,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | |
| Be In the Show Sales | $17,550 | $17,550 | $17,550 | $17,550 | $17,550 | $17,550 | $17,550 | $17,550 | $17,550 | $17,550 | $17,550 | $17,550 | |
| Catering Sales | $0 | $0 | $0 | $9,000 | $10,000 | $0 | $0 | $0 | $10,000 | $0 | $0 | $0 | |
| Total Sales | $352,215 | $531,495 | $1,091,340 | $1,100,340 | $1,101,340 | $647,290 | $580,950 | $501,950 | $504,750 | $434,950 | $384,750 | $434,950 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Lunch Sales | 38.00% | $5.32 | $5.32 | $5.32 | $5.32 | $5.32 | $5.32 | $5.32 | $5.32 | $5.32 | $5.32 | $5.32 | $5.32 |
| High Tea Sales | 38.00% | $6.84 | $6.84 | $6.84 | $6.84 | $6.84 | $6.84 | $6.84 | $6.84 | $6.84 | $6.84 | $6.84 | $6.84 |
| Dinner Sales | 36.00% | $8.64 | $8.64 | $8.64 | $8.64 | $8.64 | $8.64 | $8.64 | $8.64 | $8.64 | $8.64 | $8.64 | $8.64 |
| Dinner Show Sales | 25.00% | $13.75 | $13.75 | $13.75 | $13.75 | $13.75 | $13.75 | $13.75 | $13.75 | $13.75 | $13.75 | $13.75 | $13.75 |
| Bar Sales | 36.00% | $7.20 | $7.20 | $12.60 | $12.60 | $12.60 | $7.20 | $7.20 | $7.20 | $7.20 | $7.20 | $7.20 | $7.20 |
| Be In the Show Sales | 25.00% | $16.25 | $16.25 | $16.25 | $16.25 | $16.25 | $16.25 | $16.25 | $16.25 | $16.25 | $16.25 | $16.25 | $16.25 |
| Catering Sales | 55.00% | $0.00 | $0.00 | $0.00 | $4,950.00 | $5,500.00 | $0.00 | $0.00 | $0.00 | $2,750.00 | $0.00 | $0.00 | $0.00 |
| Direct Cost of Sales | |||||||||||||
| Lunch Sales | $27,292 | $31,601 | $55,301 | $55,301 | $55,301 | $31,601 | $27,292 | $27,292 | $27,292 | $27,292 | $27,292 | $27,292 | |
| High Tea Sales | $5,540 | $5,540 | $5,540 | $5,540 | $5,540 | $5,540 | $5,540 | $5,540 | $5,540 | $5,540 | $5,540 | $5,540 | |
| Dinner Sales | $25,661 | $32,659 | $89,813 | $89,813 | $89,813 | $43,200 | $43,200 | $34,560 | $31,968 | $30,240 | $31,968 | $30,240 | |
| Dinner Show Sales | $37,496 | $74,621 | $118,800 | $118,800 | $118,800 | $96,250 | $82,500 | $68,750 | $68,750 | $55,000 | $41,250 | $55,000 | |
| Bar Sales | $9,720 | $9,720 | $68,040 | $68,040 | $68,040 | $9,720 | $9,720 | $9,720 | $9,720 | $9,720 | $9,720 | $9,720 | |
| Be In the Show Sales | $4,388 | $4,388 | $4,388 | $4,388 | $4,388 | $4,388 | $4,388 | $4,388 | $4,388 | $4,388 | $4,388 | $4,388 | |
| Catering Sales | $0 | $0 | $0 | $4,950 | $5,500 | $0 | $0 | $0 | $5,500 | $0 | $0 | $0 | |
| Subtotal Direct Cost of Sales | $110,097 | $158,529 | $341,882 | $346,832 | $347,382 | $190,699 | $172,640 | $150,250 | $153,158 | $132,180 | $120,158 | $132,180 | |
| 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 | ||
| Executive Chef Joachim Oignons-owner | 0% | $4,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
| Serving Staff Manager | 0% | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
| Sommelier/Bar Manager | 0% | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
| Performance Manager | 0% | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
| Host/Serving Staff | 0% | $10,752 | $10,752 | $10,752 | $10,752 | $10,752 | $10,752 | $10,752 | $10,752 | $10,752 | $10,752 | $10,752 | $10,752 |
| Kitchen Staff | 0% | $14,112 | $14,112 | $14,112 | $14,112 | $14,112 | $14,112 | $14,112 | $14,112 | $14,112 | $14,112 | $14,112 | $14,112 |
| Performance Staff | 0% | $10,368 | $10,368 | $10,368 | $10,368 | $10,368 | $10,368 | $10,368 | $10,368 | $10,368 | $10,368 | $10,368 | $10,368 |
| Bar Staff | 0% | $2,688 | $2,688 | $2,688 | $2,688 | $2,688 | $2,688 | $2,688 | $2,688 | $2,688 | $2,688 | $2,688 | $2,688 |
| Bookkeeper/Office Assistant | 0% | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | $51,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | |
| 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 | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 8.20% | 8.20% | 8.20% | 8.20% | 8.20% | 8.20% | 8.20% | 8.20% | 8.20% | 8.20% | 8.20% | 8.20% | |
| Tax Rate | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | $352,215 | $531,495 | $1,091,340 | $1,100,340 | $1,101,340 | $647,290 | $580,950 | $501,950 | $504,750 | $434,950 | $384,750 | $434,950 | |
| Direct Cost of Sales | $110,097 | $158,529 | $341,882 | $346,832 | $347,382 | $190,699 | $172,640 | $150,250 | $153,158 | $132,180 | $120,158 | $132,180 | |
| Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $110,097 | $158,529 | $341,882 | $346,832 | $347,382 | $190,699 | $172,640 | $150,250 | $153,158 | $132,180 | $120,158 | $132,180 | |
| Gross Margin | $242,118 | $372,966 | $749,458 | $753,508 | $753,958 | $456,591 | $408,311 | $351,701 | $351,593 | $302,771 | $264,593 | $302,771 | |
| Gross Margin % | 68.74% | 70.17% | 68.67% | 68.48% | 68.46% | 70.54% | 70.28% | 70.07% | 69.66% | 69.61% | 68.77% | 69.61% | |
| Expenses | |||||||||||||
| Payroll | $51,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | |
| Sales and Marketing and Other Expenses | $2,846 | $3,671 | $3,671 | $3,671 | $3,671 | $3,671 | $12,671 | $13,671 | $13,671 | $14,251 | $13,671 | $3,671 | |
| Depreciation | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
| MICROS syterm, phones, security, fire, computer upgrades | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $10,000 | $0 | $0 | |
| Exterminating | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | |
| Ceramic/Glass/Silver Upkeep | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| Maintenance/Repairs | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
| Linen and Dry Cleaning | $175 | $175 | $175 | $175 | $175 | $175 | $175 | $175 | $175 | $175 | $175 | $175 | |
| Dish and Cleaning Supplies | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
| Office Products Upkeep | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| Paper Products Upkeep | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | |
| Utilities | $1,430 | $1,430 | $1,430 | $1,430 | $1,430 | $1,430 | $2,430 | $3,430 | $3,430 | $3,430 | $3,430 | $3,430 | |
| Insurance | $717 | $717 | $717 | $717 | $717 | $717 | $717 | $717 | $717 | $717 | $717 | $717 | |
| Rent | $1,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | |
| Employee Healthcare | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
| Comps/Donations/Handouts | 15% | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
| Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Operating Expenses | $66,613 | $73,438 | $73,438 | $73,438 | $73,438 | $73,438 | $83,438 | $85,438 | $85,438 | $96,018 | $85,438 | $75,438 | |
| Profit Before Interest and Taxes | $175,505 | $299,528 | $676,020 | $680,070 | $680,520 | $383,153 | $324,872 | $266,262 | $266,154 | $206,752 | $179,154 | $227,333 | |
| EBITDA | $176,505 | $300,528 | $677,020 | $681,070 | $681,520 | $384,153 | $325,872 | $267,262 | $267,154 | $207,752 | $180,154 | $228,333 | |
| Interest Expense | $311 | $303 | $295 | $288 | $280 | $272 | $265 | $257 | $249 | $242 | $234 | $226 | |
| Taxes Incurred | $43,799 | $74,806 | $168,931 | $169,946 | $170,060 | $95,720 | $81,152 | $66,501 | $66,476 | $51,628 | $44,730 | $56,777 | |
| Net Profit | $131,396 | $224,419 | $506,793 | $509,837 | $510,180 | $287,161 | $243,456 | $199,504 | $199,429 | $154,883 | $134,190 | $170,330 | |
| Net Profit/Sales | 37.31% | 42.22% | 46.44% | 46.33% | 46.32% | 44.36% | 41.91% | 39.75% | 39.51% | 35.61% | 34.88% | 39.16% | |
| 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 | $352,215 | $531,495 | $1,091,340 | $1,100,340 | $1,101,340 | $647,290 | $580,950 | $501,950 | $504,750 | $434,950 | $384,750 | $434,950 | |
| Subtotal Cash from Operations | $352,215 | $531,495 | $1,091,340 | $1,100,340 | $1,101,340 | $647,290 | $580,950 | $501,950 | $504,750 | $434,950 | $384,750 | $434,950 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 7.00% | $24,655 | $37,205 | $76,394 | $77,024 | $77,094 | $45,310 | $40,667 | $35,137 | $35,333 | $30,447 | $26,933 | $30,447 |
| 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 | $376,870 | $568,700 | $1,167,734 | $1,177,364 | $1,178,434 | $692,600 | $621,617 | $537,087 | $540,083 | $465,397 | $411,683 | $465,397 | |
| 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 | $51,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | $52,920 | |
| Bill Payments | $4,932 | $152,261 | $288,870 | $619,528 | $539,007 | $527,194 | $229,424 | $273,304 | $237,848 | $251,615 | $214,824 | $191,498 | |
| Subtotal Spent on Operations | $56,852 | $205,181 | $341,790 | $672,448 | $591,927 | $580,114 | $282,344 | $326,224 | $290,768 | $304,535 | $267,744 | $244,418 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | $24,655 | $37,205 | $76,394 | $77,024 | $77,094 | $45,310 | $40,667 | $35,137 | $35,333 | $30,447 | $26,933 | $30,447 | |
| Principal Repayment of Current Borrowing | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | |
| Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Long-term Liabilities Principal Repayment | $575 | $575 | $575 | $575 | $575 | $575 | $575 | $575 | $575 | $575 | $575 | $575 | |
| 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 | $100,000 | |
| Subtotal Cash Spent | $82,532 | $243,411 | $419,209 | $750,497 | $670,046 | $626,449 | $324,035 | $362,386 | $327,126 | $336,007 | $295,701 | $375,890 | |
| Net Cash Flow | $294,338 | $325,289 | $748,525 | $426,867 | $508,388 | $66,151 | $297,581 | $174,701 | $212,957 | $129,390 | $115,981 | $89,507 | |
| Cash Balance | $344,758 | $670,047 | $1,418,571 | $1,845,438 | $2,353,826 | $2,419,978 | $2,717,559 | $2,892,260 | $3,105,216 | $3,234,606 | $3,350,587 | $3,440,094 | |
| 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 | $50,420 | $344,758 | $670,047 | $1,418,571 | $1,845,438 | $2,353,826 | $2,419,978 | $2,717,559 | $2,892,260 | $3,105,216 | $3,234,606 | $3,350,587 | $3,440,094 |
| Inventory | $75,000 | $55,048 | $79,265 | $170,941 | $173,416 | $173,691 | $95,349 | $86,320 | $75,125 | $76,579 | $66,090 | $60,079 | $66,090 |
| Other Current Assets | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 |
| Total Current Assets | $142,420 | $416,807 | $766,312 | $1,606,513 | $2,035,854 | $2,544,517 | $2,532,327 | $2,820,879 | $2,984,385 | $3,198,795 | $3,317,696 | $3,427,666 | $3,523,184 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 | $175,000 |
| Accumulated Depreciation | $0 | $1,000 | $2,000 | $3,000 | $4,000 | $5,000 | $6,000 | $7,000 | $8,000 | $9,000 | $10,000 | $11,000 | $12,000 |
| Total Long-term Assets | $175,000 | $174,000 | $173,000 | $172,000 | $171,000 | $170,000 | $169,000 | $168,000 | $167,000 | $166,000 | $165,000 | $164,000 | $163,000 |
| Total Assets | $317,420 | $590,807 | $939,312 | $1,778,513 | $2,206,854 | $2,714,517 | $2,701,327 | $2,988,879 | $3,151,385 | $3,364,795 | $3,482,696 | $3,591,666 | $3,686,184 |
| 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 | $143,016 | $268,127 | $601,560 | $521,090 | $519,598 | $220,272 | $265,393 | $229,420 | $244,427 | $208,469 | $184,274 | $209,488 |
| Current Borrowing | $5,420 | $4,970 | $4,520 | $4,070 | $3,620 | $3,170 | $2,720 | $2,270 | $1,820 | $1,370 | $920 | $470 | $20 |
| Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Current Liabilities | $5,420 | $147,986 | $272,647 | $605,630 | $524,710 | $522,768 | $222,992 | $267,663 | $231,240 | $245,797 | $209,389 | $184,744 | $209,508 |
| Long-term Liabilities | $40,000 | $39,425 | $38,850 | $38,275 | $37,700 | $37,125 | $36,550 | $35,975 | $35,400 | $34,825 | $34,250 | $33,675 | $33,100 |
| Total Liabilities | $45,420 | $187,411 | $311,497 | $643,905 | $562,410 | $559,893 | $259,542 | $303,638 | $266,640 | $280,622 | $243,639 | $218,419 | $242,608 |
| Paid-in Capital | $450,420 | $450,420 | $450,420 | $450,420 | $450,420 | $450,420 | $450,420 | $450,420 | $450,420 | $450,420 | $450,420 | $450,420 | $450,420 |
| Retained Earnings | ($178,420) | ($178,420) | ($178,420) | ($178,420) | ($178,420) | ($178,420) | ($178,420) | ($178,420) | ($178,420) | ($178,420) | ($178,420) | ($178,420) | ($278,420) |
| Earnings | $0 | $131,396 | $355,815 | $862,608 | $1,372,444 | $1,882,624 | $2,169,785 | $2,413,241 | $2,612,745 | $2,812,173 | $2,967,057 | $3,101,247 | $3,271,576 |
| Total Capital | $272,000 | $403,396 | $627,815 | $1,134,608 | $1,644,444 | $2,154,624 | $2,441,785 | $2,685,241 | $2,884,745 | $3,084,173 | $3,239,057 | $3,373,247 | $3,443,576 |
| Total Liabilities and Capital | $317,420 | $590,807 | $939,312 | $1,778,513 | $2,206,854 | $2,714,517 | $2,701,327 | $2,988,879 | $3,151,385 | $3,364,795 | $3,482,696 | $3,591,666 | $3,686,184 |
| Net Worth | $272,000 | $403,396 | $627,815 | $1,134,608 | $1,644,444 | $2,154,624 | $2,441,785 | $2,685,241 | $2,884,745 | $3,084,173 | $3,239,057 | $3,373,247 | $3,443,576 |
By 
