qmb proyect
eduardo350
GroupProjectData.xlsxIncm Stmt
| Miami Investigations, Inc. | ||||||||||||
| Income Statement 2016 | Expansion Forecast | Expansion Forecast | Expansion Forecast | Expansion Forecast | Expansion Forecast | |||||||
| Miami, FL Office | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||||||
| REVENUES | ||||||||||||
| Services | $ 10,000,000 | $ 1,000,000 | $ 2,000,000 | $ 3,500,000 | $ 5,000,000 | $ 6,500,000 | ||||||
| Total Revenues | $ 10,000,000 | $ 1,000,000 | $ 2,000,000 | $ 3,500,000 | $ 5,000,000 | $ 6,500,000 | ||||||
| EXPENSES | ||||||||||||
| Salaries | 4,100,000 | 325,000 | 325,000 | 325,000 | 325,000 | 325,000 | ||||||
| Rent expense | 60,000 | 8,200 | 8,200 | 8,200 | 8,200 | 8,200 | ||||||
| Utlities expense | 6,200 | 2,800 | 2,800 | 2,800 | 2,800 | 2,800 | ||||||
| Office supplies | 625,000 | 75,000 | 75,000 | 75,000 | 75,000 | 75,000 | ||||||
| Office equipment | - | 500,000 | - | - | - | - | ||||||
| Subscriptions & licensing | 1,200,000 | 75,000 | 75,000 | 75,000 | 75,000 | 75,000 | ||||||
| Total Expenses | $ 5,991,200 | $ 986,000 | $ 486,000 | $ 486,000 | $ 486,000 | $ 486,000 | ||||||
| Net Income (Loss) | $ 4,008,800 | $ 14,000 | $ 1,514,000 | $ 3,014,000 | $ 4,514,000 | $ 6,014,000 | ||||||
Income
| Median Household Income | ||||
| Broward County | Miami-Dade County | |||
| City | Income | City | Income | |
| Coconut Creek | 52,800 | Aventura | 60,222 | |
| Cooper City | 90,133 | Coral Gables | 93,934 | |
| Coral Springs | 66,430 | Cutler Bay | 61,847 | |
| Dania Beach | 41,566 | Doral | 72933 | |
| Davie | 59,680 | Florida City | 25,840 | |
| Deerfield Beach | 40,626 | Hialeah | 29,249 | |
| Ft. Lauderdale | 50,778 | Hialeah Gardens | 41,592 | |
| Hallandale | 34,216 | Homestead | 40,959 | |
| Hollywood | 46,791 | Key Biscayne | 121,434 | |
| Lauderdale Lakes | 31,497 | Miami | 31,051 | |
| Lauderdale-by-the-Sea | 63,052 | Miami Beach | 44,342 | |
| Lauderhill | 37,429 | Miami Gardens | 38,253 | |
| Margate | 42,786 | Miami Lakes | 66,601 | |
| Miramar | 65,282 | Miami Shores | 97,500 | |
| North Lauderdale | 41,932 | Miami Springs | 53,688 | |
| Parkland | 130,107 | North Miami | 36,537 | |
| Pembroke Pines | 61,279 | North Miami Beach | 38,387 | |
| Plantation | 66,647 | Opa Locka | 18,134 | |
| Pompano Beach | 41,321 | Palmetto Bay | 106,324 | |
| Sunrise | 49,806 | South Miami | 58,047 | |
| Tamarac | 43,235 | Sunny Isles Beach | 47,183 | |
| Weston | 93,814 | Surfside | 78,443 | |
| Wilton Manors | 52,996 | Sweetwater | 31665 | |
| Source: US Census Bureau |
Customers
| Service_ID | Cust_Type |
| FRAUD2 | Business |
| WKRCOMP | Consumer |
| CORP1 | Business |
| PERS1 | Consumer |
| PERS1 | Consumer |
| WKRCOMP | Business |
| BACKGRD | Business |
| FRAUD2 | Business |
| PERS1 | Consumer |
| COMPF | Consumer |
| PERS1 | Consumer |
| BACKGRD | Consumer |
| FRAUD2 | Business |
| COMPF | Business |
| COMPF | Consumer |
| FRAUD2 | Consumer |
| BACKGRD | Consumer |
| WKRCOMP | Consumer |
| PERS1 | Consumer |
| CORP1 | Business |
| COMPF | Consumer |
| FRAUD2 | Business |
| FRAUD2 | Business |
| PERS1 | Consumer |
| WKRCOMP | Consumer |
| COMPF | Business |
| BACKGRD | Business |
| BACKGRD | Business |
| FRAUD2 | Consumer |
| BACKGRD | Consumer |
Services
| Svc_ID | Service | Price |
| BACKGRD | Background checks | $75.00 |
| COMPF | Computer fraud and forensics | $1,300.00 |
| CORP1 | Corporate investigations | $2,500.00 |
| FRAUD2 | Fraud and theft investigations | $500.00 |
| PERS1 | Infidelity and personal investigations | $350.00 |
| WKRCOMP | Worker’s compensation investigations | $800.00 |
