Interstate Travel Center
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 | |||||||||||||
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 |