Full of Bologna
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% | 0 | 0 | 0 | 0 | 0 | 600 | 5,850 | 5,850 | 5,850 | 5,850 | 5,850 | 5,850 |
Dinner Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 5,850 | 5,850 | 3,900 | 3,900 | 3,900 | 3,900 |
Gift Shop Item Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 180 | 180 | 180 | 180 | 180 | 180 |
Web Shop Sales | 0% | 0 | 0 | 0 | 0 | 0 | 6 | 20 | 25 | 25 | 25 | 25 | 25 |
Catering Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 |
Liquor Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 2,330 | 2,330 | 1,940 | 1,940 | 1,940 | 1,940 |
Wine Bottle Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 240 | 240 | 240 | 240 | 240 | 240 |
Wine by the Glass Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 2,050 | 2,050 | 1,450 | 1,450 | 1,450 | 1,450 |
Beer Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 2,770 | 2,770 | 2,380 | 2,380 | 2,380 | 2,380 |
Chef’s Table in the Vault Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 15 | 15 | 15 | 15 | 15 |
Total Unit Sales | 0 | 0 | 0 | 0 | 0 | 606 | 19,306 | 19,311 | 15,981 | 15,981 | 15,981 | 15,981 | |
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 | $10.50 | $10.50 | $10.50 | $10.50 | $10.50 | $10.50 | $10.50 | $10.50 | $10.50 | $10.50 | $10.50 | $10.50 | |
Dinner Sales | $20.00 | $20.00 | $20.00 | $20.00 | $20.00 | $20.00 | $20.00 | $20.00 | $20.00 | $20.00 | $20.00 | $20.00 | |
Gift Shop Item Sales | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | |
Web Shop Sales | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | |
Catering Sales | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | |
Liquor Sales | $4.50 | $4.50 | $4.50 | $4.50 | $4.50 | $4.50 | $4.50 | $4.50 | $4.50 | $4.50 | $4.50 | $4.50 | |
Wine Bottle Sales | $16.00 | $16.00 | $16.00 | $16.00 | $16.00 | $16.00 | $16.00 | $16.00 | $16.00 | $16.00 | $16.00 | $16.00 | |
Wine by the Glass Sales | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | |
Beer Sales | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | |
Chef’s Table in the Vault Sales | $520.00 | $520.00 | $520.00 | $520.00 | $520.00 | $520.00 | $520.00 | $520.00 | $520.00 | $520.00 | $520.00 | $520.00 | |
Sales | |||||||||||||
Lunch Sales | $0 | $0 | $0 | $0 | $0 | $6,300 | $61,425 | $61,425 | $61,425 | $61,425 | $61,425 | $61,425 | |
Dinner Sales | $0 | $0 | $0 | $0 | $0 | $0 | $117,000 | $117,000 | $78,000 | $78,000 | $78,000 | $78,000 | |
Gift Shop Item Sales | $0 | $0 | $0 | $0 | $0 | $0 | $1,080 | $1,080 | $1,080 | $1,080 | $1,080 | $1,080 | |
Web Shop Sales | $0 | $0 | $0 | $0 | $0 | $36 | $120 | $150 | $150 | $150 | $150 | $150 | |
Catering Sales | $0 | $0 | $0 | $0 | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Liquor Sales | $0 | $0 | $0 | $0 | $0 | $0 | $10,485 | $10,485 | $8,730 | $8,730 | $8,730 | $8,730 | |
Wine Bottle Sales | $0 | $0 | $0 | $0 | $0 | $0 | $3,840 | $3,840 | $3,840 | $3,840 | $3,840 | $3,840 | |
Wine by the Glass Sales | $0 | $0 | $0 | $0 | $0 | $0 | $8,200 | $8,200 | $5,800 | $5,800 | $5,800 | $5,800 | |
Beer Sales | $0 | $0 | $0 | $0 | $0 | $0 | $8,310 | $8,310 | $7,140 | $7,140 | $7,140 | $7,140 | |
Chef’s Table in the Vault Sales | $0 | $0 | $0 | $0 | $0 | $0 | $7,800 | $7,800 | $7,800 | $7,800 | $7,800 | $7,800 | |
Total Sales | $0 | $0 | $0 | $0 | $0 | $6,336 | $220,260 | $220,290 | $175,965 | $175,965 | $175,965 | $175,965 | |
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 | 32.00% | $3.36 | $3.36 | $3.36 | $3.36 | $3.36 | $3.36 | $3.36 | $3.36 | $3.36 | $3.36 | $3.36 | $3.36 |
Dinner Sales | 33.00% | $6.60 | $6.60 | $6.60 | $6.60 | $6.60 | $6.60 | $6.60 | $6.60 | $6.60 | $6.60 | $6.60 | $6.60 |
Gift Shop Item Sales | 48.00% | $1.92 | $1.92 | $1.92 | $1.92 | $1.92 | $1.92 | $1.92 | $1.92 | $1.92 | $1.92 | $1.92 | $1.92 |
Web Shop Sales | 45.00% | $1.92 | $1.92 | $1.92 | $1.92 | $1.92 | $1.92 | $1.92 | $1.92 | $1.92 | $1.92 | $1.92 | $1.92 |
Catering Sales | 34.00% | $640.00 | $640.00 | $640.00 | $640.00 | $640.00 | $640.00 | $640.00 | $640.00 | $640.00 | $640.00 | $640.00 | $640.00 |
Liquor Sales | 20.00% | $1.44 | $1.44 | $1.44 | $1.44 | $1.44 | $1.44 | $1.44 | $1.44 | $1.44 | $1.44 | $1.44 | $1.44 |
Wine Bottle Sales | 30.00% | $5.12 | $5.12 | $5.12 | $5.12 | $5.12 | $5.12 | $5.12 | $5.12 | $5.12 | $5.12 | $5.12 | $5.12 |
Wine by the Glass Sales | 20.00% | $1.28 | $1.28 | $1.28 | $1.28 | $1.28 | $1.28 | $1.28 | $1.28 | $1.28 | $1.28 | $1.28 | $1.28 |
Beer Sales | 20.00% | $0.96 | $0.96 | $0.96 | $0.96 | $0.96 | $0.96 | $0.96 | $0.96 | $0.96 | $0.96 | $0.96 | $0.96 |
Chef’s Table in the Vault Sales | 35.00% | $182.00 | $182.00 | $182.00 | $182.00 | $182.00 | $182.00 | $182.00 | $182.00 | $182.00 | $182.00 | $182.00 | $182.00 |
Direct Cost of Sales | |||||||||||||
Lunch Sales | $0 | $0 | $0 | $0 | $0 | $2,016 | $19,656 | $19,656 | $19,656 | $19,656 | $19,656 | $19,656 | |
Dinner Sales | $0 | $0 | $0 | $0 | $0 | $0 | $38,610 | $38,610 | $25,740 | $25,740 | $25,740 | $25,740 | |
Gift Shop Item Sales | $0 | $0 | $0 | $0 | $0 | $0 | $346 | $346 | $346 | $346 | $346 | $346 | |
Web Shop Sales | $0 | $0 | $0 | $0 | $0 | $12 | $38 | $48 | $48 | $48 | $48 | $48 | |
Catering Sales | $0 | $0 | $0 | $0 | $0 | $0 | $640 | $640 | $640 | $640 | $640 | $640 | |
Liquor Sales | $0 | $0 | $0 | $0 | $0 | $0 | $3,355 | $3,355 | $2,794 | $2,794 | $2,794 | $2,794 | |
Wine Bottle Sales | $0 | $0 | $0 | $0 | $0 | $0 | $1,229 | $1,229 | $1,229 | $1,229 | $1,229 | $1,229 | |
Wine by the Glass Sales | $0 | $0 | $0 | $0 | $0 | $0 | $2,624 | $2,624 | $1,856 | $1,856 | $1,856 | $1,856 | |
Beer Sales | $0 | $0 | $0 | $0 | $0 | $0 | $2,659 | $2,659 | $2,285 | $2,285 | $2,285 | $2,285 | |
Chef’s Table in the Vault Sales | $0 | $0 | $0 | $0 | $0 | $0 | $2,730 | $2,730 | $2,730 | $2,730 | $2,730 | $2,730 | |
Subtotal Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $2,028 | $71,887 | $71,897 | $57,323 | $57,323 | $57,323 | $57,323 |
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 | ||
Manager Day | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 |
Manager Night | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
Manager Lounge/Bar | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
Wait Staff day & night – 16 x 40 hrs x 4.00 p/hr | 0% | $0 | $0 | $0 | $0 | $0 | $1,280 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 |
Dishwasher – 2 x 40 hrs x 7.00 p/hr | 0% | $0 | $0 | $0 | $0 | $0 | $280 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 |
Cooks – 2 day & 3 night = 7 x 40 hrs x 10.00 p/hr | 0% | $0 | $0 | $0 | $0 | $0 | $2,800 | $11,200 | $11,200 | $11,200 | $11,200 | $11,200 | $11,200 |
Bartenders – 4 flex x 40 hrs x 2.50 p/hr | 0% | $0 | $0 | $0 | $0 | $0 | $400 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 |
Executive Chef | 0% | $0 | $0 | $0 | $0 | $0 | $4,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Total Payroll | $0 | $0 | $0 | $0 | $0 | $8,760 | $32,600 | $32,600 | $32,600 | $32,600 | $32,600 | $32,600 |
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 | $0 | $0 | $0 | $0 | $0 | $6,336 | $220,260 | $220,290 | $175,965 | $175,965 | $175,965 | $175,965 | |
Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $2,028 | $71,887 | $71,897 | $57,323 | $57,323 | $57,323 | $57,323 | |
Staff Meals | $0 | $0 | $0 | $0 | $0 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
Other Costs of Goods/DESCOMM/Bank | $0 | $0 | $0 | $0 | $0 | $0 | $5,000 | $5,000 | $3,500 | $3,500 | $3,500 | $3,500 | |
Total Cost of Sales | $0 | $0 | $0 | $0 | $0 | $2,428 | $77,287 | $77,297 | $61,223 | $61,223 | $61,223 | $61,223 | |
Gross Margin | $0 | $0 | $0 | $0 | $0 | $3,908 | $142,973 | $142,993 | $114,742 | $114,742 | $114,742 | $114,742 | |
Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 61.69% | 64.91% | 64.91% | 65.21% | 65.21% | 65.21% | 65.21% | |
Expenses | |||||||||||||
Payroll | $0 | $0 | $0 | $0 | $0 | $8,760 | $32,600 | $32,600 | $32,600 | $32,600 | $32,600 | $32,600 | |
Marketing/Promotion | $0 | $0 | $0 | $0 | $0 | $10,000 | $10,000 | $10,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Employee Healthcare | $0 | $0 | $0 | $0 | $0 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Rent | $0 | $0 | $0 | $0 | $0 | $0 | $1,500 | $2,000 | $2,500 | $3,000 | $3,500 | $4,000 | |
Utilities and Security Services | $0 | $0 | $0 | $500 | $1,000 | $3,600 | $3,600 | $3,600 | $2,600 | $2,600 | $2,600 | $2,600 | |
Ceramic, Glass and Silver Upkeep | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $200 | $200 | $200 | $200 | $200 | |
Accounting Fees | $0 | $0 | $0 | $0 | $0 | $0 | $400 | $400 | $400 | $400 | $400 | $500 | |
Manager Comps & Grease Handouts | $0 | $0 | $0 | $0 | $0 | $0 | $5,000 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
Dues and Subscriptions | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $600 | $0 | |
Legal Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Flowers | $0 | $0 | $0 | $0 | $0 | $0 | $400 | $400 | $400 | $400 | $400 | $400 | |
Travel Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Exterminating | $0 | $0 | $0 | $0 | $0 | $0 | $25 | $25 | $25 | $25 | $25 | $25 | |
Fines and Penalties | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $100 | |
Payroll Processing | $0 | $0 | $0 | $0 | $190 | $60 | $60 | $60 | $60 | $60 | $60 | $60 | |
Insurance, Licensure & RE Taxes | $0 | $0 | $0 | $0 | $0 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | |
Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Maintenance Costs/Repairs | $0 | $0 | $0 | $0 | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Linen and Dry Cleaning | $0 | $0 | $0 | $0 | $0 | $175 | $175 | $175 | $150 | $150 | $150 | $150 | |
Computer Upkeep/Upgrade | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Dish and Cleaning Supplies | $0 | $0 | $0 | $0 | $0 | $0 | $400 | $400 | $400 | $400 | $400 | $400 | |
Office Products Upkeep | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $200 | $200 | $200 | $200 | $200 | $200 |
Paper Product Deliveries | $0 | $0 | $0 | $0 | $0 | $0 | $800 | $800 | $800 | $800 | $800 | $800 | |
Total Operating Expenses | $0 | $0 | $0 | $500 | $1,190 | $26,295 | $60,860 | $59,060 | $53,535 | $54,035 | $55,135 | $55,235 | |
Profit Before Interest and Taxes | $0 | $0 | $0 | ($500) | ($1,190) | ($22,387) | $82,113 | $83,933 | $61,207 | $60,707 | $59,607 | $59,507 | |
EBITDA | $0 | $0 | $0 | ($500) | ($1,190) | ($22,387) | $82,113 | $83,933 | $61,207 | $60,707 | $59,607 | $59,507 | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Taxes Incurred | $0 | $0 | $0 | ($150) | ($357) | ($6,716) | $24,634 | $25,180 | $18,362 | $18,212 | $17,882 | $17,852 | |
Net Profit | $0 | $0 | $0 | ($350) | ($833) | ($15,671) | $57,479 | $58,753 | $42,845 | $42,495 | $41,725 | $41,655 | |
Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | -247.33% | 26.10% | 26.67% | 24.35% | 24.15% | 23.71% | 23.67% |
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 | $0 | $0 | $0 | $0 | $0 | $6,336 | $220,260 | $220,290 | $175,965 | $175,965 | $175,965 | $175,965 | |
Subtotal Cash from Operations | $0 | $0 | $0 | $0 | $0 | $6,336 | $220,260 | $220,290 | $175,965 | $175,965 | $175,965 | $175,965 | |
Additional Cash Received | |||||||||||||
Sales Tax, VAT, HST/GST Received | 6.00% | $0 | $0 | $0 | $0 | $0 | $380 | $13,216 | $13,217 | $10,558 | $10,558 | $10,558 | $10,558 |
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 | $1,000 | $1,000 | $1,000 | $1,000 | $1,100 | $1,200 | $1,400 | $1,300 | $1,300 | |
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 | $0 | $0 | $0 | $1,000 | $1,000 | $7,716 | $234,476 | $234,607 | $187,723 | $187,923 | $187,823 | $187,823 | |
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 | $0 | $0 | $0 | $0 | $0 | $8,760 | $32,600 | $32,600 | $32,600 | $32,600 | $32,600 | $32,600 | |
Bill Payments | $0 | $0 | $0 | $12 | $366 | $1,179 | $15,055 | $126,390 | $127,870 | $97,010 | $100,896 | $101,642 | |
Subtotal Spent on Operations | $0 | $0 | $0 | $12 | $366 | $9,939 | $47,655 | $158,990 | $160,470 | $129,610 | $133,496 | $134,242 | |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
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 | $0 | $0 | $0 | $12 | $366 | $9,939 | $47,655 | $158,990 | $160,470 | $129,610 | $133,496 | $134,242 | |
Net Cash Flow | $0 | $0 | $0 | $988 | $634 | ($2,223) | $186,820 | $75,618 | $27,252 | $58,313 | $54,327 | $53,581 | |
Cash Balance | $40,000 | $40,000 | $40,000 | $40,988 | $41,622 | $39,399 | $226,220 | $301,837 | $329,090 | $387,403 | $441,730 | $495,311 |
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 | $40,000 | $40,000 | $40,000 | $40,000 | $40,988 | $41,622 | $39,399 | $226,220 | $301,837 | $329,090 | $387,403 | $441,730 | $495,311 |
Inventory | $23,878 | $23,878 | $23,878 | $23,878 | $23,878 | $23,878 | $21,851 | $17,972 | $17,974 | $14,331 | $14,331 | $14,331 | $14,331 |
Other Current Assets | $0 | $0 | $0 | $0 | ($1,000) | ($2,000) | ($3,000) | ($4,000) | ($5,100) | ($6,300) | ($7,700) | ($9,000) | ($10,300) |
Total Current Assets | $63,878 | $63,878 | $63,878 | $63,878 | $63,867 | $63,501 | $58,250 | $240,191 | $314,711 | $337,120 | $394,034 | $447,061 | $499,342 |
Long-term Assets | |||||||||||||
Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Assets | $63,878 | $63,878 | $63,878 | $63,878 | $63,867 | $63,501 | $58,250 | $240,191 | $314,711 | $337,120 | $394,034 | $447,061 | $499,342 |
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 | $0 | $0 | $0 | $338 | $805 | $10,845 | $122,092 | $124,641 | $93,647 | $97,508 | $98,252 | $98,320 |
Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $380 | $13,596 | $26,813 | $37,371 | $47,929 | $58,487 | $69,045 |
Subtotal Current Liabilities | $0 | $0 | $0 | $0 | $338 | $805 | $11,225 | $135,688 | $151,454 | $131,018 | $145,437 | $156,739 | $167,364 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $0 | $0 | $0 | $338 | $805 | $11,225 | $135,688 | $151,454 | $131,018 | $145,437 | $156,739 | $167,364 |
Paid-in Capital | $379,309 | $379,309 | $379,309 | $379,309 | $379,309 | $379,309 | $379,309 | $379,309 | $379,309 | $379,309 | $379,309 | $379,309 | $379,309 |
Retained Earnings | ($315,431) | ($315,431) | ($315,431) | ($315,431) | ($315,431) | ($315,431) | ($315,431) | ($315,431) | ($315,431) | ($315,431) | ($315,431) | ($315,431) | ($315,431) |
Earnings | $0 | $0 | $0 | $0 | ($350) | ($1,183) | ($16,854) | $40,625 | $99,379 | $142,224 | $184,719 | $226,444 | $268,099 |
Total Capital | $63,878 | $63,878 | $63,878 | $63,878 | $63,528 | $62,695 | $47,025 | $104,504 | $163,257 | $206,102 | $248,597 | $290,322 | $331,977 |
Total Liabilities and Capital | $63,878 | $63,878 | $63,878 | $63,878 | $63,867 | $63,501 | $58,250 | $240,191 | $314,711 | $337,120 | $394,034 | $447,061 | $499,342 |
Net Worth | $63,878 | $63,878 | $63,878 | $63,878 | $63,528 | $62,695 | $47,025 | $104,504 | $163,257 | $206,102 | $248,597 | $290,322 | $331,977 |