Wasatch Family Fun 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 | ||
Sales | |||||||||||||
Amusement | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Bumper Boats | 0% | $18,605 | $24,806 | $37,209 | $37,209 | $37,209 | $37,209 | $24,806 | $18,605 | $6,202 | $6,202 | $6,202 | $6,202 |
Mini-Golf | 0% | $33,351 | $44,467 | $66,701 | $66,701 | $66,701 | $66,701 | $44,467 | $33,351 | $11,117 | $11,117 | $11,117 | $11,117 |
Go-Carts | 0% | $85,272 | $113,695 | $170,543 | $170,543 | $170,543 | $170,543 | $113,695 | $85,272 | $28,424 | $28,424 | $28,424 | $28,424 |
Gaming Center | 0% | $2,756 | $3,675 | $5,512 | $5,512 | $5,512 | $5,512 | $3,675 | $2,756 | $919 | $919 | $919 | $919 |
Sky Coaster | 0% | $11,025 | $14,700 | $22,050 | $22,050 | $22,050 | $22,050 | $14,700 | $11,025 | $3,675 | $3,675 | $3,675 | $3,675 |
Batting Cages | 0% | $10,336 | $13,781 | $20,671 | $20,671 | $20,671 | $20,671 | $13,781 | $10,336 | $3,445 | $3,445 | $3,445 | $3,445 |
Climbing Walls | 0% | $3,652 | $4,869 | $7,304 | $7,304 | $7,304 | $7,304 | $4,869 | $3,652 | $2,435 | $2,435 | $2,435 | $2,435 |
Air/Foosball | 0% | $1,194 | $1,592 | $2,388 | $2,388 | $2,388 | $2,388 | $1,592 | $1,194 | $796 | $796 | $796 | $796 |
Souvenirs | 0% | $1,838 | $2,450 | $3,675 | $3,675 | $3,675 | $3,675 | $2,450 | $1,838 | $1,225 | $1,225 | $1,225 | $1,225 |
Party Rooms | 0% | $30,016 | $40,021 | $60,031 | $60,031 | $60,031 | $60,031 | $40,021 | $30,016 | $20,010 | $20,010 | $20,010 | $20,010 |
Food & Drinks | 0% | $48,234 | $64,312 | $96,468 | $96,468 | $96,468 | $96,468 | $64,312 | $48,234 | $32,156 | $32,156 | $32,156 | $32,156 |
Total Sales | $246,276 | $328,368 | $492,552 | $492,552 | $492,552 | $492,552 | $328,368 | $246,276 | $110,403 | $110,403 | $110,403 | $110,403 | |
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 | |
Amusement | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Bumper Boats | $4,651 | $6,202 | $9,302 | $9,302 | $9,302 | $9,302 | $6,202 | $4,651 | $1,550 | $1,550 | $1,550 | $1,550 | |
Mini-Golf | $5,003 | $6,670 | $10,005 | $10,005 | $10,005 | $10,005 | $6,670 | $5,003 | $1,668 | $1,668 | $1,668 | $1,668 | |
Go-Carts | $21,318 | $28,424 | $42,636 | $42,636 | $42,636 | $42,636 | $28,424 | $21,318 | $7,106 | $7,106 | $7,106 | $7,106 | |
Gaming Center | $1,378 | $1,837 | $2,756 | $2,756 | $2,756 | $2,756 | $1,837 | $1,378 | $459 | $459 | $459 | $459 | |
Sky Coaster | $2,756 | $3,675 | $5,513 | $5,513 | $5,513 | $5,513 | $3,675 | $2,756 | $919 | $919 | $919 | $919 | |
Batting Cages | $1,550 | $2,067 | $3,101 | $3,101 | $3,101 | $3,101 | $2,067 | $1,550 | $517 | $517 | $517 | $517 | |
Climbing Walls | $913 | $1,217 | $1,826 | $1,826 | $1,826 | $1,826 | $1,217 | $913 | $609 | $609 | $609 | $609 | |
Air/Foosball | $179 | $239 | $358 | $358 | $358 | $358 | $239 | $179 | $119 | $119 | $119 | $119 | |
Souvenirs | $459 | $613 | $919 | $919 | $919 | $919 | $613 | $459 | $306 | $306 | $306 | $306 | |
Party Rooms | $15,008 | $20,010 | $30,016 | $30,016 | $30,016 | $30,016 | $20,010 | $15,008 | $10,005 | $10,005 | $10,005 | $10,005 | |
Food & Drinks | $24,117 | $32,156 | $48,234 | $48,234 | $48,234 | $48,234 | $32,156 | $24,117 | $16,078 | $16,078 | $16,078 | $16,078 | |
Subtotal Direct Cost of Sales | $77,332 | $103,110 | $154,665 | $154,665 | $154,665 | $154,665 | $103,110 | $77,332 | $39,336 | $39,336 | $39,336 | $39,336 |
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 | ||
Operations Personnel | |||||||||||||
John A | 100% | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 |
John B | 100% | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 |
John C | 100% | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 | $1,932 |
John D | 100% | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 |
John E | 100% | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 |
John F | 100% | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 |
John G | 100% | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 |
John H | 100% | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 |
John I | 100% | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 |
John J | 100% | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 |
John K | 100% | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 |
John L | 100% | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 |
John M | 100% | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 |
John N | 100% | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 |
John O | 100% | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 |
John P | 100% | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 |
John Q | 100% | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 |
John R | 100% | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 |
John S | 100% | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 |
John T | 100% | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 |
John U | 100% | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 |
Subtotal | $32,388 | $32,388 | $32,388 | $32,388 | $32,388 | $32,388 | $32,388 | $32,388 | $32,388 | $32,388 | $32,388 | $32,388 | |
Sales and Marketing Personnel | |||||||||||||
Darren Strebel | 100% | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 |
Other | 100% | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 |
Subtotal | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | |
General and Administrative Personnel | |||||||||||||
Joe Hull | 100% | $3,404 | $3,404 | $3,404 | $3,404 | $3,404 | $3,404 | $3,404 | $3,404 | $3,404 | $3,404 | $3,404 | $3,404 |
Rod Schaffer | 100% | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 |
Restaurant Manager | 100% | $3,404 | $3,404 | $3,404 | $3,404 | $3,404 | $3,404 | $3,404 | $3,404 | $3,404 | $3,404 | $3,404 | $3,404 |
Laura Strebel | 100% | $1,748 | $1,748 | $1,748 | $1,748 | $1,748 | $1,748 | $1,748 | $1,748 | $1,748 | $1,748 | $1,748 | $1,748 |
Mark Bergman | 100% | $4,140 | $4,140 | $4,140 | $4,140 | $4,140 | $4,140 | $4,140 | $4,140 | $4,140 | $4,140 | $4,140 | $4,140 |
Subtotal | $14,260 | $14,260 | $14,260 | $14,260 | $14,260 | $14,260 | $14,260 | $14,260 | $14,260 | $14,260 | $14,260 | $14,260 | |
Other Personnel | |||||||||||||
Jack A | 100% | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 |
Jack B | 100% | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 |
Jack C | 100% | $1,748 | $1,748 | $1,748 | $1,748 | $1,748 | $1,748 | $1,748 | $1,748 | $1,748 | $1,748 | $1,748 | $1,748 |
Sara A | 100% | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 | $1,564 |
Subtotal | $6,440 | $6,440 | $6,440 | $6,440 | $6,440 | $6,440 | $6,440 | $6,440 | $6,440 | $6,440 | $6,440 | $6,440 | |
Total People | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | |
Total Payroll | $57,688 | $57,688 | $57,688 | $57,688 | $57,688 | $57,688 | $57,688 | $57,688 | $57,688 | $57,688 | $57,688 | $57,688 |
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 | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.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% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.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 | $246,276 | $328,368 | $492,552 | $492,552 | $492,552 | $492,552 | $328,368 | $246,276 | $110,403 | $110,403 | $110,403 | $110,403 | |
Direct Cost of Sales | $77,332 | $103,110 | $154,665 | $154,665 | $154,665 | $154,665 | $103,110 | $77,332 | $39,336 | $39,336 | $39,336 | $39,336 | |
Operations Payroll | $32,388 | $32,388 | $32,388 | $32,388 | $32,388 | $32,388 | $32,388 | $32,388 | $32,388 | $32,388 | $32,388 | $32,388 | |
Known expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $109,720 | $135,498 | $187,053 | $187,053 | $187,053 | $187,053 | $135,498 | $109,720 | $71,724 | $71,724 | $71,724 | $71,724 | |
Gross Margin | $136,556 | $192,870 | $305,499 | $305,499 | $305,499 | $305,499 | $192,870 | $136,556 | $38,679 | $38,679 | $38,679 | $38,679 | |
Gross Margin % | 55.45% | 58.74% | 62.02% | 62.02% | 62.02% | 62.02% | 58.74% | 55.45% | 35.03% | 35.03% | 35.03% | 35.03% | |
Operating Expenses | |||||||||||||
Sales and Marketing Expenses | |||||||||||||
Sales and Marketing Payroll | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | |
Advertising/Promotion | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
Travel | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Miscellaneous | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Total Sales and Marketing Expenses | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | $6,750 | |
Sales and Marketing % | 2.74% | 2.06% | 1.37% | 1.37% | 1.37% | 1.37% | 2.06% | 2.74% | 6.11% | 6.11% | 6.11% | 6.11% | |
General and Administrative Expenses | |||||||||||||
General and Administrative Payroll | $14,260 | $14,260 | $14,260 | $14,260 | $14,260 | $14,260 | $14,260 | $14,260 | $14,260 | $14,260 | $14,260 | $14,260 | |
Sales and Marketing and Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | |
Insurance | $1,230 | $1,230 | $1,230 | $1,230 | $1,230 | $1,230 | $1,230 | $1,230 | $1,230 | $1,230 | $1,230 | $1,230 | |
Telephone | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | |
Payroll Taxes | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other General and Administrative Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total General and Administrative Expenses | $17,490 | $17,490 | $17,490 | $17,490 | $17,490 | $17,490 | $17,490 | $17,490 | $17,490 | $17,490 | $17,490 | $17,490 | |
General and Administrative % | 7.10% | 5.33% | 3.55% | 3.55% | 3.55% | 3.55% | 5.33% | 7.10% | 15.84% | 15.84% | 15.84% | 15.84% | |
Other Expenses: | |||||||||||||
Other Payroll | $6,440 | $6,440 | $6,440 | $6,440 | $6,440 | $6,440 | $6,440 | $6,440 | $6,440 | $6,440 | $6,440 | $6,440 | |
Consultants | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Office Supplies | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Postal Fees | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Professional Fees | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Housekeeping Supplies | $1,060 | $1,060 | $1,060 | $1,060 | $1,060 | $1,060 | $1,060 | $1,060 | $1,060 | $1,060 | $1,060 | $1,060 | |
Unknown | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
Bad Checks | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | |
Bank Card Fees | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | |
Business License | $35 | $35 | $35 | $35 | $35 | $35 | $35 | $35 | $35 | $35 | $35 | $35 | |
Facility Maintenance | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
Contract/Consultants | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | |
Total Other Expenses | $10,485 | $10,485 | $10,485 | $10,485 | $10,485 | $10,485 | $10,485 | $10,485 | $10,485 | $10,485 | $10,485 | $10,485 | |
Other % | 4.26% | 3.19% | 2.13% | 2.13% | 2.13% | 2.13% | 3.19% | 4.26% | 9.50% | 9.50% | 9.50% | 9.50% | |
Total Operating Expenses | $34,725 | $34,725 | $34,725 | $34,725 | $34,725 | $34,725 | $34,725 | $34,725 | $34,725 | $34,725 | $34,725 | $34,725 | |
Profit Before Interest and Taxes | $101,831 | $158,145 | $270,774 | $270,774 | $270,774 | $270,774 | $158,145 | $101,831 | $3,954 | $3,954 | $3,954 | $3,954 | |
EBITDA | $101,831 | $158,145 | $270,774 | $270,774 | $270,774 | $270,774 | $158,145 | $101,831 | $3,954 | $3,954 | $3,954 | $3,954 | |
Interest Expense | $44,347 | $44,162 | $43,974 | $43,783 | $43,590 | $43,395 | $43,196 | $42,994 | $42,790 | $42,583 | $42,373 | $42,160 | |
Taxes Incurred | $17,245 | $37,615 | $74,844 | $74,907 | $74,971 | $75,035 | $37,933 | $19,416 | ($12,816) | ($12,748) | ($12,678) | ($12,608) | |
Net Profit | $40,239 | $76,369 | $151,956 | $152,084 | $152,213 | $152,344 | $77,016 | $39,420 | ($26,020) | ($25,882) | ($25,741) | ($25,598) | |
Net Profit/Sales | 16.34% | 23.26% | 30.85% | 30.88% | 30.90% | 30.93% | 23.45% | 16.01% | -23.57% | -23.44% | -23.32% | -23.19% |
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 | $246,276 | $328,368 | $492,552 | $492,552 | $492,552 | $492,552 | $328,368 | $246,276 | $110,403 | $110,403 | $110,403 | $110,403 | |
Subtotal Cash from Operations | $246,276 | $328,368 | $492,552 | $492,552 | $492,552 | $492,552 | $328,368 | $246,276 | $110,403 | $110,403 | $110,403 | $110,403 | |
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 | $246,276 | $328,368 | $492,552 | $492,552 | $492,552 | $492,552 | $328,368 | $246,276 | $110,403 | $110,403 | $110,403 | $110,403 | |
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 | $57,688 | $57,688 | $57,688 | $57,688 | $57,688 | $57,688 | $57,688 | $57,688 | $57,688 | $57,688 | $57,688 | $57,688 | |
Bill Payments | $4,945 | $149,881 | $197,264 | $282,903 | $282,776 | $282,646 | $279,558 | $192,181 | $146,820 | $78,731 | $78,592 | $78,451 | |
Subtotal Spent on Operations | $62,633 | $207,569 | $254,952 | $340,591 | $340,464 | $340,334 | $337,246 | $249,869 | $204,508 | $136,419 | $136,280 | $136,139 | |
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 | $8,995 | $9,137 | $9,282 | $9,429 | $9,578 | $9,730 | $9,884 | $10,041 | $10,200 | $10,361 | $10,525 | $10,692 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Long-term Liabilities Principal Repayment | $4,809 | $4,850 | $4,890 | $4,931 | $4,972 | $5,013 | $5,055 | $5,097 | $5,140 | $5,182 | $5,226 | $5,269 | |
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 | $76,437 | $221,556 | $269,124 | $354,951 | $355,014 | $355,077 | $352,185 | $265,007 | $219,848 | $151,962 | $152,031 | $152,100 | |
Net Cash Flow | $169,839 | $106,812 | $223,428 | $137,601 | $137,538 | $137,475 | ($23,817) | ($18,731) | ($109,445) | ($41,559) | ($41,628) | ($41,697) | |
Cash Balance | $369,839 | $476,651 | $700,079 | $837,679 | $975,217 | $1,112,692 | $1,088,875 | $1,070,144 | $960,699 | $919,140 | $877,513 | $835,816 |
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 | $200,000 | $369,839 | $476,651 | $700,079 | $837,679 | $975,217 | $1,112,692 | $1,088,875 | $1,070,144 | $960,699 | $919,140 | $877,513 | $835,816 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $200,000 | $369,839 | $476,651 | $700,079 | $837,679 | $975,217 | $1,112,692 | $1,088,875 | $1,070,144 | $960,699 | $919,140 | $877,513 | $835,816 |
Long-term Assets | |||||||||||||
Long-term Assets | $5,077,925 | $5,077,925 | $5,077,925 | $5,077,925 | $5,077,925 | $5,077,925 | $5,077,925 | $5,077,925 | $5,077,925 | $5,077,925 | $5,077,925 | $5,077,925 | $5,077,925 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Long-term Assets | $5,077,925 | $5,077,925 | $5,077,925 | $5,077,925 | $5,077,925 | $5,077,925 | $5,077,925 | $5,077,925 | $5,077,925 | $5,077,925 | $5,077,925 | $5,077,925 | $5,077,925 |
Total Assets | $5,277,925 | $5,447,764 | $5,554,576 | $5,778,004 | $5,915,604 | $6,053,142 | $6,190,617 | $6,166,800 | $6,148,069 | $6,038,624 | $5,997,065 | $5,955,438 | $5,913,741 |
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,404 | $187,834 | $273,477 | $273,354 | $273,229 | $273,102 | $187,209 | $144,196 | $76,111 | $75,977 | $75,840 | $75,702 |
Current Borrowing | $890,000 | $881,005 | $871,868 | $862,586 | $853,157 | $843,579 | $833,849 | $823,965 | $813,924 | $803,724 | $793,363 | $782,838 | $772,146 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $890,000 | $1,024,409 | $1,059,702 | $1,136,063 | $1,126,511 | $1,116,808 | $1,106,951 | $1,011,174 | $958,120 | $879,835 | $869,340 | $858,678 | $847,848 |
Long-term Liabilities | $3,652,500 | $3,647,691 | $3,642,841 | $3,637,951 | $3,633,020 | $3,628,048 | $3,623,035 | $3,617,980 | $3,612,883 | $3,607,743 | $3,602,561 | $3,597,335 | $3,592,066 |
Total Liabilities | $4,542,500 | $4,672,100 | $4,702,543 | $4,774,014 | $4,759,531 | $4,744,856 | $4,729,986 | $4,629,154 | $4,571,003 | $4,487,578 | $4,471,901 | $4,456,013 | $4,439,914 |
Paid-in Capital | $965,000 | $965,000 | $965,000 | $965,000 | $965,000 | $965,000 | $965,000 | $965,000 | $965,000 | $965,000 | $965,000 | $965,000 | $965,000 |
Retained Earnings | ($229,575) | ($229,575) | ($229,575) | ($229,575) | ($229,575) | ($229,575) | ($229,575) | ($229,575) | ($229,575) | ($229,575) | ($229,575) | ($229,575) | ($229,575) |
Earnings | $0 | $40,239 | $116,608 | $268,564 | $420,648 | $572,861 | $725,205 | $802,221 | $841,642 | $815,621 | $789,740 | $763,999 | $738,401 |
Total Capital | $735,425 | $775,664 | $852,033 | $1,003,989 | $1,156,073 | $1,308,286 | $1,460,630 | $1,537,646 | $1,577,067 | $1,551,046 | $1,525,165 | $1,499,424 | $1,473,826 |
Total Liabilities and Capital | $5,277,925 | $5,447,764 | $5,554,576 | $5,778,004 | $5,915,604 | $6,053,142 | $6,190,617 | $6,166,800 | $6,148,069 | $6,038,624 | $5,997,065 | $5,955,438 | $5,913,741 |
Net Worth | $735,425 | $775,664 | $852,033 | $1,003,989 | $1,156,073 | $1,308,286 | $1,460,630 | $1,537,646 | $1,577,067 | $1,551,046 | $1,525,165 | $1,499,424 | $1,473,826 |