|
|
| HOME | ||||||
| Proforma Income Statement of an Internet café | ||||||
| OFFICERS | (Monthly) | |||||
| MEMBERS | Rental Rate (P) per Hour | 15.00 | 20.00 | 25.00 | 30.00 | |
| MEETINGS | Sales: | |||||
| Recent | Daily | 1,440.00 | 1,920.00 | 2,400.00 | 2,880.00 | |
| First GMM | Monthly | 37,440.00 | 49,920.00 | 62,400.00 | 74,880.00 | |
| PROJECTS | Less: | |||||
| Jamboree | Bldg Rental | 8,000.00 | 8,000.00 | 8,000.00 | 8,000.00 | |
| ISP | 8,800.00 | 8,800.00 | 8,800.00 | 8,800.00 | ||
| Salaries | 15,600.00 | 15,600.00 | 15,600.00 | 15,600.00 | ||
| STATUS | Electricity | 7,000.00 | 7,000.00 | 7,000.00 | 7,000.00 | |
| Water | 300.00 | 300.00 | 300.00 | 300.00 | ||
| Financial | Telephone | 2,500.00 | 2,500.00 | 2,500.00 | 2,500.00 | |
| Office Supplies | 1,000.00 | 1,000.00 | 1,000.00 | 1,000.00 | ||
| Administrative Expense: | ||||||
| Depreciation (comp equip) | 20,833.33 | 20,833.33 | 20,833.33 | 20,833.33 | ||
| Depreciation (Furniture) | 694.44 | 694.44 | 694.44 | 694.44 | ||
| Depreciation (Lease hold) | 2,500.00 | 2,500.00 | 2,500.00 | 2,500.00 | ||
| Taxes: | ||||||
| Sales Tax (3% of gross) | 1,123.20 | 1,497.60 | 1,872.00 | 2,246.40 | ||
| Business Permit | 167.00 | 167.00 | 167.00 | 167.00 | ||
| Total monthly expenses: | 68,517.98 | 68,892.38 | 69,266.78 | 69,641.18 | ||
| Net Profit / (Loss) | (31,077.98) | (18,972.38) | (6,866.78) | 5,238.82 | ||
| ROI (months) | 52.49271465 | |||||
| Max. Sales Potential: | ||||||
| Daily | 2,400.00 | 3,200.00 | 4,000.00 | 4,800.00 | ||
| Monthly | 62,400.00 | 83,200.00 | 104,000.00 | 124,800.00 | ||
| Assumptions: | ||||||
| a) # of computers | 10 | How to increase revenue / Improve ROI | ||||
| b) Operation hours (Hrs / Day) | 16 | Increase Sales | ||||
| c) Occupancy Rate (%) | 60% | - improve occupancy rate | ||||
| e) No of Days / Month | 26 | - increase rental rate | ||||
| f) Salary per staff per day | 150 | Reduce operating expenses | ||||
| g) No. of Staff | 4 | - use lower rate ISPs | ||||
| h) Computer equip life - months | 12 | - reduce manpower | ||||
| i) Computer cost / unit | 25,000.00 | - reduce electricity consumption | ||||
| j) Furniture Costs / PC | 2,500.00 | by shortening opening hours | ||||
| k) Furniture life (months) | 36 | |||||
| l) Lease hold improvements | 60,000.00 | |||||
| m) lease hold life (months) | 24 | |||||
| n) On-going improvements | Not Included | |||||
| o) Software | Not Included | |||||