| 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 | |||||||||||||
| Diesel (gallons) | 0% | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 |
| Gasoline (gallons) | 41% | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 |
| Travel Store | 9% | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 |
| Interstate Travel Restaurant | 3% | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 |
| Rebates, allowances, etc. | 10% | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 |
| Total Unit Sales | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | |
| 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 | |
| Diesel (gallons) | $1.75 | $1.75 | $1.75 | $1.75 | $1.75 | $1.75 | $1.75 | $1.75 | $1.75 | $1.75 | $1.75 | $1.75 | |
| Gasoline (gallons) | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 | |
| Travel Store | $3.75 | $3.75 | $3.75 | $3.75 | $3.75 | $3.75 | $3.75 | $3.75 | $3.75 | $3.75 | $3.75 | $3.75 | |
| Interstate Travel Restaurant | $13.00 | $13.00 | $13.00 | $13.00 | $13.00 | $13.00 | $13.00 | $13.00 | $13.00 | $13.00 | $13.00 | $13.00 | |
| Rebates, allowances, etc. | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | |
| Sales | |||||||||||||
| Diesel (gallons) | $371,875 | $371,875 | $371,875 | $371,875 | $371,875 | $371,875 | $371,875 | $371,875 | $371,875 | $371,875 | $371,875 | $371,875 | |
| Gasoline (gallons) | $131,250 | $131,250 | $131,250 | $131,250 | $131,250 | $131,250 | $131,250 | $131,250 | $131,250 | $131,250 | $131,250 | $131,250 | |
| Travel Store | $71,876 | $71,876 | $71,876 | $71,876 | $71,876 | $71,876 | $71,876 | $71,876 | $71,876 | $71,876 | $71,876 | $71,876 | |
| Interstate Travel Restaurant | $88,049 | $88,049 | $88,049 | $88,049 | $88,049 | $88,049 | $88,049 | $88,049 | $88,049 | $88,049 | $88,049 | $88,049 | |
| Rebates, allowances, etc. | $20,550 | $20,550 | $20,550 | $20,550 | $20,550 | $20,550 | $20,550 | $20,550 | $20,550 | $20,550 | $20,550 | $20,550 | |
| Total Sales | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | |
| 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 | |
| Diesel (gallons) | 8.00% | $1.67 | $1.67 | $1.67 | $1.67 | $1.67 | $1.67 | $1.67 | $1.67 | $1.67 | $1.67 | $1.67 | $1.67 |
| Gasoline (gallons) | 0.00% | $1.40 | $1.40 | $1.40 | $1.40 | $1.40 | $1.40 | $1.40 | $1.40 | $1.40 | $1.40 | $1.40 | $1.40 |
| Travel Store | 0.00% | $0.75 | $0.75 | $0.75 | $0.75 | $0.75 | $0.75 | $0.75 | $0.75 | $0.75 | $0.75 | $0.75 | $0.75 |
| Interstate Travel Restaurant | 0.00% | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 |
| Rebates, allowances, etc. | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Direct Cost of Sales | |||||||||||||
| Diesel (gallons) | $354,875 | $354,875 | $354,875 | $354,875 | $354,875 | $354,875 | $354,875 | $354,875 | $354,875 | $354,875 | $354,875 | $354,875 | |
| Gasoline (gallons) | $122,500 | $122,500 | $122,500 | $122,500 | $122,500 | $122,500 | $122,500 | $122,500 | $122,500 | $122,500 | $122,500 | $122,500 | |
| Travel Store | $14,375 | $14,375 | $14,375 | $14,375 | $14,375 | $14,375 | $14,375 | $14,375 | $14,375 | $14,375 | $14,375 | $14,375 | |
| Interstate Travel Restaurant | $13,546 | $13,546 | $13,546 | $13,546 | $13,546 | $13,546 | $13,546 | $13,546 | $13,546 | $13,546 | $13,546 | $13,546 | |
| Rebates, allowances, etc. | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Direct Cost of Sales | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | |
| 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 | ||
| Steve Smith | 0% | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 |
| Janet Smith | 0% | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 |
| Convenience store/Gas station Manager | 0% | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 |
| Restaurant 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 |
| Assist Manager - Cook | 0% | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 |
| Cook 2 | 0% | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 |
| Cook 3 | 0% | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 |
| Cook 4 | 0% | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 |
| Cook 5 | 0% | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 |
| Cook 6 | 0% | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 | $2,240 |
| Waitress/Waiter | 0% | $984 | $984 | $984 | $984 | $984 | $984 | $984 | $984 | $984 | $984 | $984 | $984 |
| Waitress/Waiter | 0% | $984 | $984 | $984 | $984 | $984 | $984 | $984 | $984 | $984 | $984 | $984 | $984 |
| Waitress/Waiter | 0% | $984 | $984 | $984 | $984 | $984 | $984 | $984 | $984 | $984 | $984 | $984 | $984 |
| Waitress/Waiter | 0% | $984 | $984 | $984 | $984 | $984 | $984 | $984 | $984 | $984 | $984 | $984 | $984 |
| Waitress/Waiter | 0% | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 |
| Waitress/Waiter | 0% | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 |
| Waitress/Waiter | 0% | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 |
| Waitress/Waiter | 0% | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 |
| Waitress/Waiter | 0% | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 |
| Waitress/Waiter | 0% | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 |
| Waitress/Waiter | 0% | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 |
| Waitress/Waiter | 0% | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 |
| Assist. Manager - Cashier | 0% | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 |
| Cashier | 0% | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
| Cashier | 0% | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
| Cashier | 0% | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
| Cashier | 0% | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
| Maintenance | 0% | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | |
| 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 | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 30.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 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | |
| Direct Cost of Sales | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | $505,296 | |
| Gross Margin | $178,304 | $178,304 | $178,304 | $178,304 | $178,304 | $178,304 | $178,304 | $178,304 | $178,304 | $178,304 | $178,304 | $178,304 | |
| Gross Margin % | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | |
| Expenses | |||||||||||||
| Payroll | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | |
| Sales and Marketing and Other Expenses | $18,400 | $18,400 | $18,400 | $18,400 | $18,400 | $18,400 | $18,400 | $18,400 | $18,400 | $18,400 | $18,400 | $18,400 | |
| 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 | |
| Leased Equipment | $4,150 | $4,150 | $4,150 | $4,150 | $4,150 | $4,150 | $4,150 | $4,150 | $4,150 | $4,150 | $4,150 | $4,150 | |
| Utilities | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | |
| Insurance | $7,650 | $7,650 | $7,650 | $7,650 | $7,650 | $7,650 | $7,650 | $7,650 | $7,650 | $7,650 | $7,650 | $7,650 | |
| Rent | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
| Payroll Taxes | 15% | $6,021 | $6,021 | $6,021 | $6,021 | $6,021 | $6,021 | $6,021 | $6,021 | $6,021 | $6,021 | $6,021 | $6,021 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $84,960 | $84,960 | $84,960 | $84,960 | $84,960 | $84,960 | $84,960 | $84,960 | $84,960 | $84,960 | $84,960 | $84,960 | |
| Profit Before Interest and Taxes | $93,344 | $93,344 | $93,344 | $93,344 | $93,344 | $93,344 | $93,344 | $93,344 | $93,344 | $93,344 | $93,344 | $93,344 | |
| EBITDA | $95,844 | $95,844 | $95,844 | $95,844 | $95,844 | $95,844 | $95,844 | $95,844 | $95,844 | $95,844 | $95,844 | $95,844 | |
| Interest Expense | $20,642 | $20,451 | $20,260 | $20,069 | $19,878 | $19,688 | $19,497 | $19,306 | $19,115 | $18,924 | $18,733 | $18,542 | |
| Taxes Incurred | $21,810 | $18,223 | $18,271 | $18,319 | $18,366 | $18,414 | $18,462 | $18,510 | $18,557 | $18,605 | $18,653 | $18,701 | |
| Net Profit | $50,891 | $54,669 | $54,813 | $54,956 | $55,099 | $55,242 | $55,385 | $55,529 | $55,672 | $55,815 | $55,958 | $56,102 | |
| Net Profit/Sales | 7.44% | 8.00% | 8.02% | 8.04% | 8.06% | 8.08% | 8.10% | 8.12% | 8.14% | 8.16% | 8.19% | 8.21% | |
| 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 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | |
| Subtotal Cash from Operations | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | |
| 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 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | $683,600 | |
| 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 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | $40,139 | |
| Bill Payments | $36,030 | $1,064,409 | $586,287 | $586,144 | $586,000 | $585,857 | $585,714 | $585,571 | $585,427 | $585,284 | $585,141 | $584,998 | |
| Subtotal Spent on Operations | $76,169 | $1,104,548 | $626,426 | $626,283 | $626,140 | $625,996 | $625,853 | $625,710 | $625,567 | $625,424 | $625,280 | $625,137 | |
| 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 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | |
| 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 | $99,086 | $1,127,465 | $649,343 | $649,200 | $649,056 | $648,913 | $648,770 | $648,627 | $648,483 | $648,340 | $648,197 | $648,054 | |
| Net Cash Flow | $584,514 | ($443,865) | $34,257 | $34,401 | $34,544 | $34,687 | $34,830 | $34,974 | $35,117 | $35,260 | $35,403 | $35,546 | |
| Cash Balance | $834,514 | $390,650 | $424,907 | $459,308 | $493,852 | $528,539 | $563,369 | $598,343 | $633,459 | $668,719 | $704,123 | $739,669 | |
| 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 | $250,000 | $834,514 | $390,650 | $424,907 | $459,308 | $493,852 | $528,539 | $563,369 | $598,343 | $633,459 | $668,719 | $704,123 | $739,669 |
| Inventory | $65,000 | $555,826 | $555,826 | $555,826 | $555,826 | $555,826 | $555,826 | $555,826 | $555,826 | $555,826 | $555,826 | $555,826 | $555,826 |
| Other Current Assets | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 |
| Total Current Assets | $365,000 | $1,440,340 | $996,476 | $1,030,733 | $1,065,134 | $1,099,677 | $1,134,365 | $1,169,195 | $1,204,168 | $1,239,285 | $1,274,545 | $1,309,948 | $1,345,495 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $1,600,000 | $1,600,000 | $1,600,000 | $1,600,000 | $1,600,000 | $1,600,000 | $1,600,000 | $1,600,000 | $1,600,000 | $1,600,000 | $1,600,000 | $1,600,000 | $1,600,000 |
| 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 | $1,600,000 | $1,597,500 | $1,595,000 | $1,592,500 | $1,590,000 | $1,587,500 | $1,585,000 | $1,582,500 | $1,580,000 | $1,577,500 | $1,575,000 | $1,572,500 | $1,570,000 |
| Total Assets | $1,965,000 | $3,037,840 | $2,591,476 | $2,623,233 | $2,655,134 | $2,687,177 | $2,719,365 | $2,751,695 | $2,784,168 | $2,816,785 | $2,849,545 | $2,882,448 | $2,915,495 |
| 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 | $1,044,866 | $566,749 | $566,610 | $566,472 | $566,333 | $566,195 | $566,056 | $565,918 | $565,779 | $565,641 | $565,502 | $565,364 |
| 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 | $1,044,866 | $566,749 | $566,610 | $566,472 | $566,333 | $566,195 | $566,056 | $565,918 | $565,779 | $565,641 | $565,502 | $565,364 |
| Long-term Liabilities | $2,500,000 | $2,477,083 | $2,454,167 | $2,431,250 | $2,408,333 | $2,385,417 | $2,362,500 | $2,339,583 | $2,316,667 | $2,293,750 | $2,270,833 | $2,247,917 | $2,225,000 |
| Total Liabilities | $2,500,000 | $3,521,949 | $3,020,915 | $2,997,860 | $2,974,805 | $2,951,750 | $2,928,695 | $2,905,640 | $2,882,585 | $2,859,529 | $2,836,474 | $2,813,419 | $2,790,364 |
| Paid-in Capital | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 |
| Retained Earnings | ($785,000) | ($785,000) | ($785,000) | ($785,000) | ($785,000) | ($785,000) | ($785,000) | ($785,000) | ($785,000) | ($785,000) | ($785,000) | ($785,000) | ($785,000) |
| Earnings | $0 | $50,891 | $105,560 | $160,373 | $215,329 | $270,428 | $325,670 | $381,055 | $436,584 | $492,256 | $548,071 | $604,029 | $660,131 |
| Total Capital | ($535,000) | ($484,109) | ($429,440) | ($374,627) | ($319,671) | ($264,572) | ($209,330) | ($153,945) | ($98,416) | ($42,744) | $13,071 | $69,029 | $125,131 |
| Total Liabilities and Capital | $1,965,000 | $3,037,840 | $2,591,476 | $2,623,233 | $2,655,134 | $2,687,177 | $2,719,365 | $2,751,695 | $2,784,168 | $2,816,785 | $2,849,545 | $2,882,448 | $2,915,495 |
| Net Worth | ($535,000) | ($484,109) | ($429,440) | ($374,627) | ($319,671) | ($264,572) | ($209,330) | ($153,945) | ($98,416) | ($42,744) | $13,071 | $69,029 | $125,131 |