|
|
|
| Assumptions | |||||||||||
| Food Cost is : | 40% | of Max | $6.99 | per person | |||||||
| Bar Cost is: | 30% | of Max | $1.89 | per person | |||||||
| Room Food Cost : | 50% | of Max | $12.00 | per order | |||||||
| Room Bar Cost: | 100% | of | $2.99 | per room | |||||||
| Food Supply Cost | 25% | of Food Cost | |||||||||
| Laundry Cost: | $0.15 | per Item | |||||||||
| Uniform Cost: | $7.00 | per emp per week | |||||||||
| Building Area: | 7,446 | Main | |||||||||
| 6,298 | Second | ||||||||||
| 5,234 | Third | ||||||||||
| 18,978 | Total | $117.61 | per sq ft | Construction Cost | |||||||
| Land Area: | 54,450 | sq ft | $8.00 | per sq ft | Purchase Price | ||||||
| Operating | $120,000.00 | Capital | $2,787,602.58 | Total Investment | |||||||
| Financial Factors: | 0.10 | APR | 10 | Years | 30% | Equity | |||||
| Economic Factor: | 2.4% | Inflation | |||||||||
| Investor | $836,280.77 | Investment | 5 | Years | |||||||
| Gas Factors: | $180.00 | Common | $1.75 | per room | |||||||
| Electric Factors: | $350.00 | Common | $1.25 | per room | |||||||
| Water Factors: | $19.24 | Base | $1.04 | per Kgal | 400 | Gal/room/day | |||||
| Sewer Rate: | $0.002948 | per Gallon | |||||||||
| Phone Rate: | 7 | Lines @ | $37.00 | per Line | $38.00 | Features | |||||
| Irrigation: | $25.00 | per Acre | |||||||||
| Amortization Schedule | |||||||||||
| Total Project | Investor Account | ||||||||||
| Balance | Interest | Principle | Payment | Balance | Interest | Principle | Payment | ||||
| $1,951,321.81 | $836,280.77 | ||||||||||
| 1 | $1,948,764.97 | $23,230.02 | $2,556.84 | $25,786.86 | 12 | $919,908.85 | $83,628.08 | $(83,628.08) | $0.00 | ||
| 2 | $1,939,217.81 | $16,239.71 | $9,547.15 | $25,786.86 | 24 | $760,867.29 | $83,628.08 | $159,041.56 | $242,669.64 | ||
| 3 | $1,929,591.10 | $16,160.15 | $9,626.71 | $25,786.86 | 36 | $594,284.38 | $76,086.73 | $166,582.91 | $242,669.64 | ||
| 4 | $1,919,884.16 | $16,079.93 | $9,706.94 | $25,786.86 | 48 | $411,043.18 | $59,428.44 | $183,241.20 | $242,669.64 | ||
| 5 | $1,910,096.34 | $15,999.03 | $9,787.83 | $25,786.86 | 60 | $209,477.86 | $41,104.32 | $201,565.32 | $242,669.64 | ||
| 6 | $1,900,226.95 | $15,917.47 | $9,869.39 | $25,786.86 | 72 | $0.00 | $20,947.79 | $209,477.86 | $230,425.65 | ||
| 7 | $1,890,275.31 | $15,835.22 | $9,951.64 | $25,786.86 | |||||||
| 8 | $1,880,240.74 | $15,752.29 | $10,034.57 | $25,786.86 | |||||||
| 9 | $1,870,122.55 | $15,668.67 | $10,118.19 | $25,786.86 | |||||||
| 10 | $1,859,920.05 | $15,584.35 | $10,202.51 | $25,786.86 | |||||||
| 11 | $1,849,632.52 | $15,499.33 | $10,287.53 | $25,786.86 | |||||||
| 12 | $1,839,259.26 | $15,413.60 | $10,373.26 | $25,786.86 | |||||||
| 24 | $1,705,616.55 | $183,925.93 | $133,642.71 | $317,568.64 | |||||||
| 36 | $1,558,609.57 | $170,561.65 | $147,006.98 | $317,568.64 | |||||||
| 48 | $1,396,901.88 | $155,860.96 | $161,707.68 | $317,568.64 | |||||||
| 60 | $1,219,023.44 | $139,690.19 | $177,878.45 | $317,568.64 | |||||||
| 72 | $1,023,357.14 | $121,902.34 | $195,666.29 | $317,568.64 | |||||||
| 84 | $808,124.22 | $102,335.71 | $215,232.92 | $317,568.64 | |||||||
| 96 | $571,368.00 | $80,812.42 | $236,756.22 | $317,568.64 | |||||||
| 108 | $310,936.16 | $57,136.80 | $260,431.84 | $317,568.64 | |||||||
| 120 | $(0.00) | $31,093.62 | $310,936.16 | $342,029.78 | |||||||