CIS107 Homework 1
Collegeman
singleton.xlsxDocumentation
| Singleton Property Management | |
| Author: | |
| Date: | |
| Purpose: | To compare vacancy rates among rental properties in Los Angeles |
Yearly Rates
| Singleton Property Management | High | Low | ||||||
| Analysis of Property Vacancy Rates (in unit months) | ||||||||
| Rental Income | Building | Units | 2015 Income | 2016 Income | % Increase | |||
| 1431 1st Ave. | 12 | $ 258,000.00 | $ 271,920.00 | |||||
| 47 Park St. | 52 | 754,860.75 | 788,877.00 | |||||
| 2011 N. Sheridan St. | 32 | 669,760.00 | 669,232.00 | |||||
| 153-155 Lake Rd. | 6 | 179,200.00 | 179,302.00 | |||||
| 2099 Harrison Ave. | 18 | 264,600.00 | 275,134.55 | |||||
| 415 9th Ave. | 37 | 801,540.00 | 808,622.00 | |||||
| 1632 8th Blvd. | 56 | 994,080.00 | 977,360.00 | |||||
| 9853 O'Rourke Pl. | 12 | 377,880.00 | 345,414.00 | |||||
| Total | 225 | $ 4,299,920.75 | $ 4,315,861.55 | |||||
| Vacancies | Building | Units | 2015 Vacancies | 2016 Vacancies | % Increase | |||
| 1431 1st Ave. | 12 | 15 | 12 | |||||
| 47 Park St. | 52 | 77 | 69 | |||||
| 2011 N. Sheridan St. | 32 | 16 | 27 | |||||
| 153-155 Lake Rd. | 6 | 2 | 3 | |||||
| 2099 Harrison Ave. | 18 | 6 | 4 | |||||
| 415 9th Ave. | 37 | 6 | 15 | |||||
| 1632 8th Blvd. | 56 | 18 | 29 | |||||
| 9853 O'Rourke Pl. | 12 | 3 | 8 | |||||
| Total | 225 | 143 | 167 | |||||
Monthly Rates
| Singleton Property Management | ||||||||
| Analysis of Monthly Property Vacancy Rates | ||||||||
| Units Vacant in 2015 | ||||||||
| Month | 1st | Park | Sheridan | Lake | Harrison | 9th | 8th | O'Rourke |
| Jan | 0 | 3 | 1 | 0 | 1 | 1 | 0 | 0 |
| Feb | 1 | 4 | 0 | 1 | 0 | 1 | 0 | 0 |
| Mar | 0 | 4 | 0 | 1 | 0 | 1 | 1 | 0 |
| Apr | 1 | 6 | 2 | 0 | 1 | 1 | 2 | 0 |
| May | 2 | 8 | 0 | 0 | 2 | 0 | 1 | 0 |
| Jun | 3 | 9 | 0 | 0 | 1 | 0 | 3 | 0 |
| Jul | 2 | 11 | 2 | 0 | 1 | 0 | 4 | 0 |
| Aug | 1 | 10 | 3 | 0 | 0 | 2 | 3 | 0 |
| Sep | 0 | 2 | 4 | 0 | 0 | 0 | 2 | 0 |
| Oct | 2 | 6 | 3 | 0 | 0 | 0 | 2 | 1 |
| Nov | 2 | 8 | 1 | 0 | 0 | 0 | 0 | 1 |
| Dec | 1 | 6 | 0 | 0 | 0 | 0 | 0 | 1 |
| Units Vacant in 2016 | ||||||||
| Month | 1st | Park | Sheridan | Lake | Harrison | 9th | 8th | O'Rourke |
| Jan | 1 | 7 | 1 | 0 | 0 | 0 | 0 | 1 |
| Feb | 1 | 5 | 2 | 0 | 0 | 0 | 0 | 1 |
| Mar | 0 | 5 | 4 | 0 | 1 | 0 | 2 | 1 |
| Apr | 1 | 8 | 5 | 0 | 1 | 1 | 5 | 0 |
| May | 2 | 10 | 6 | 0 | 0 | 2 | 7 | 0 |
| Jun | 2 | 15 | 4 | 1 | 0 | 2 | 6 | 1 |
| Jul | 3 | 5 | 2 | 1 | 0 | 3 | 5 | 2 |
| Aug | 1 | 4 | 1 | 1 | 1 | 3 | 2 | 2 |
| Sep | 0 | 5 | 0 | 0 | 1 | 2 | 1 | 0 |
| Oct | 0 | 2 | 0 | 0 | 0 | 2 | 0 | 0 |
| Nov | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 |
| Dec | 1 | 1 | 2 | 0 | 0 | 0 | 1 | 0 |
| Net Increase | ||||||||
| Month | 1st | Park | Sheridan | Lake | Harrison | 9th | 8th | O'Rourke |
| Jan | 1 | 4 | 0 | 0 | -1 | -1 | 0 | 1 |
| Feb | 0 | 1 | 2 | -1 | 0 | -1 | 0 | 1 |
| Mar | 0 | 1 | 4 | -1 | 1 | -1 | 1 | 1 |
| Apr | 0 | 2 | 3 | 0 | 0 | 0 | 3 | 0 |
| May | 0 | 2 | 6 | 0 | -2 | 2 | 6 | 0 |
| Jun | -1 | 6 | 4 | 1 | -1 | 2 | 3 | 1 |
| Jul | 1 | -6 | 0 | 1 | -1 | 3 | 1 | 2 |
| Aug | 0 | -6 | -2 | 1 | 1 | 1 | -1 | 2 |
| Sep | 0 | 3 | -4 | 0 | 1 | 2 | -1 | 0 |
| Oct | -2 | -4 | -3 | 0 | 0 | 2 | -2 | -1 |
| Nov | -2 | -6 | -1 | 0 | 0 | 0 | 0 | -1 |
| Dec | 0 | -5 | 2 | 0 | 0 | 0 | 1 | -1 |
