UFO RESTAURANT
CASHFLOW FORECAST
Year One
| Pre- | |||||||||||||
| Opening | July | Aug. | Sept. | Oct. | Nov. | Dec. | Jan. | Feb. | Mar. | Apr. | May | June | |
| Sources | |||||||||||||
| Stock | $7,500,000 | ||||||||||||
| Sales | $0 | $90,556 | $83,009 | $75,463 | $75,463 | $67,917 | $60,370 | $75,463 | $75,463 | $75,463 | $75,463 | $75,463 | $75,463 |
| Paid in | |||||||||||||
| Capital | $500,000 | ||||||||||||
| Uses of Cash |
(preopening) | ||||||||||||
| Land | 1,000,000 | ||||||||||||
| Building &Fixtures |
6,000,000 | ||||||||||||
| Liquor License |
250,000 | ||||||||||||
| Opening Inventory |
75,000 | ||||||||||||
| Deposits | 30,000 | ||||||||||||
| Opening Promotion |
140,000 | ||||||||||||
| Architect/ Engineer |
250,000 | ||||||||||||
| Accounting/ Legal |
25,000 | ||||||||||||
| Travel | 10,000 | ||||||||||||
| Uses-Monthly | |||||||||||||
| Owners Draw | 0 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 |
| Expenses | 0 | 84,547 | 84,547 | 84,547 | 84,547 | 84,547 | 84,547 | 84,547 | 84,547 | 84,547 | 84,547 | 84,547 | 84,547 |
| Total Uses | 7,780,000 | 104,547 | 104,547 | 104,547 | 104,547 | 104,547 | 104,547 | 104,547 | 104,547 | 92,547 | 92,547 | 92,547 | 92,547 |
| Working Capital | $220,000 | (13,991) | (21,537) | (29,084) | (29,084) | (36,630) | (44,176) | (29,084) | (29,084) | (17,084) | (17,084) | (17,084) | (17,084) |
| Cumulative | 206,009 | 184,472 | 155,388 | 126,304 | 89,674 | 45,498 | 16,414 | (12,669) | (29,753) | (46,837) | (63,920) | ($81,004) |