Spreadsheet: 494656d1482554547-pepaid-expense-worksheet-licence
Sheet: Sheet1

 |  |  |  | 2015 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | YTD
# Locations | Description | Amortiza-tion period |  | YEAR END BALANCE | activity | activity | activity | activity | activity | activity | activity | activity | activity | activity | activity | activity | BALANCE | Location | Balance
1157 | ESRD License | 12/15-11/17 |  | 5673.33
 | Accumulated Amortization |  |  |  | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67
1036 | ESRD License | 01/17-12/17 |  |  |  |  |  |  |  |  |  |  |  | 3407.02
 | Accumulated Amortization
1149 | ESRD License | 03/17-02/18
 | Accumulated Amortization
1158
 | ESRD License | 05/15 - 04/17 |  | 3413.36
 | Accumulated Amortization |  |  |  | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33
1161 | ESRD License
 | Accumulated Amortization
1172 | ESRD License | 11/16-10/17 |  |  |  |  |  |  |  |  |  |  |  | 3407.02
 | Accumulated Amortization
1216 | ESRD License | 11/15-10/17 |  | 5426.66
 | Accumulated Amortization |  |  |  | -493.34 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67
1319 | ESRD License | 09/16-10/18
 | Accumulated Amortization |  |  |  |  |  |  |  |  |  |  | 5920 | -246.67 | -246.67
1359 | ESRD License | 01/17-12/17 |  |  |  |  |  |  |  |  |  |  |  | 3407.02
 | Accumulated Amortization
1383 | ESRD License | 01/17-12/17 |  |  |  |  |  |  |  |  |  |  | 3407.02
 | Accumulated Amortization
1287 | ESRD License | 05/16-04/18 |  |  |  | 5120.08
 | Accumulated Amortization |  |  |  |  |  |  |  | -426.67 | -426.67 | -426.67 | -426.67 | -426.67 | -426.67
1477 | ESRD License | 05/16-06/18 |  |  |  |  |  | 5120
 | Accumulated Amortization |  |  |  |  |  |  |  | -426.67 | -426.67 | -426.67 | -426.67 | -426.67 | -426.67
1545 | ESRD License | 05/16-06/18 |  |  |  |  |  | 5120
 | Accumulated Amortization |  |  |  |  |  |  |  | -426.67 | -426.67 | 0 |  | -213.33 | -213.33
1548 | ESRD License | 07/16-06/18 |  |  |  |  |  |  |  | 4320
 | Accumulated Amortization |  |  |  |  |  |  |  |  |  | -180 | -180 | -180 | -180
1600 | ESRD License | 11/16-10/18
 | Accumulated Amortization |  |  |  |  |  |  |  |  |  |  | 4320
1690 | ESRD License | 12/16-11/17 |  |  |  |  |  |  |  |  |  |  | 3407.02
 | Accumulated Amortization
1679 | ESRD License | 11/15-10/17 |  | 3960
 | Accumulated Amortization |  |  |  | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180
1746 | ESRD License | 11/14-10/16 |  | 2466.619999999999
 | Accumulated Amortization |  |  |  | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.59
1746 | ESRD License | 11/16-10/18
 | Accumulated Amortization |  |  |  |  |  |  |  |  |  |  | 5920
1749 | ESRD License | 11/15-10/17 |  | 4693.34
 | Accumulated Amortization |  |  |  | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33
1784 | ESRD License | 03/15-02/17 |  | 2986.700000000001
 | Accumulated Amortization |  |  |  | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33
1818 | ESRD License | 11/14-10/16 |  | 2133.380000000001
 | Accumulated Amortization |  |  |  | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.41
1818 | ESRD License | 11/16-10/18
 | Accumulated Amortization |  |  |  |  |  |  |  |  |  |  | 5120
1820 | ESRD License | 03/15-02/17 |  | 2520
 | Accumulated Amortization |  |  |  | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180
1833 | ESRD License | 12/14-11/16 |  | 1980
 | Accumulated Amortization |  |  |  | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180
1833 | ESRD License | 12/16-11/18 |  |  |  |  |  |  |  |  |  |  | 5120
 | Accumulated Amortization
1870 | ESRD License | 02/15-01/17 |  | 2773.370000000001
 | Accumulated Amortization |  |  |  | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33
1871 | ESRD License | 06/16-05/18 |  |  |  |  | 5920
 | Accumulated Amortization |  |  |  |  |  |  |  |  | -246.67 | -246.67 | -246.67 | -246.67 | -246.67
1873 | ESRD License | 10/15-09/17 |  | 4479.86
 | Accumulated Amortization |  |  |  | -213.38 | -213.38 | -213.38 | -213.38 | -213.38 | -213.38 | -213.38 | -213.38 | -213.38 | -213.38
1874 | ESRD License | 11/15-10/17 |  | 4693.34
 | Accumulated Amortization |  |  |  | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33
1875 | ESRD License | 05/15-04/17 |  | 3413.360000000001
 | Accumulated Amortization |  |  |  | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33
1877 | ESRD License | 11/14-10/16 |  | 2466.619999999999
 | Accumulated Amortization |  |  |  | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.59
1877 | ESRD License
 | Accumulated Amortization |  |  |  |  |  |  |  |  |  |  | 5290
1877 | ESRD License | 11/16-10/18 |  |  |  |  |  |  |  |  |  |  |  | 5920
 | Accumulated Amortization
1878 | ESRD License | 11/15-10/17 |  | 5426.66
 | Accumulated Amortization |  |  |  | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67
1879 | ESRD License | 11/14-10/16 |  | 2466.619999999999
 | Accumulated Amortization |  |  |  | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.59
1879 | ESRD License | 11/16-10/18 |  |  |  |  |  |  |  |  |  |  | 5920
 | Accumulated Amortization
1880 | ESRD License | 11/15-10/17 |  | 4693.34
 | Accumulated Amortization |  |  |  | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33
1881 | ESRD License | 01/16-12/17 |  | 5920
 | Accumulated Amortization |  |  |  | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67
1909 | ESRD License | 05/15 - 04/17 |  | 3413.360000000001
 | Accumulated Amortization |  |  |  | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33
1921 | ESRD License | 11/15-10/17 |  | 3960
 | Accumulated Amortization |  |  |  | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180
1922 | ESRD License | 05/16-04/18 |  |  |  |  | 4320
 | Accumulated Amortization |  |  |  |  |  |  |  | -426.67 | -426.67 | -426.67 | -426.67 | -426.67 | -426.67
2108 | ESRD License | 01/17-12/17 |  |  |  |  |  |  |  |  |  |  | 2520
 | Accumulated Amortization
2109 | ESRD License | 12/16-11/17 |  |  |  |  |  |  |  |  |  |  |  | 2520
 | Accumulated Amortization
2163 | ESRD License | 02/15-01/17 |  | 2773.370000000001
 | Accumulated Amortization |  |  |  | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33
2346 | ESRD License | 10/16-9/17 |  |  |  |  |  |  |  |  |  |  | 2500
 | Accumulated Amortization
2375 | ESRD License | 01/17-12/17 |  |  |  |  |  |  |  |  |  |  | 3407.02
 | Accumulated Amortization
2378 | ESRD License | 09/15-08/17 |  | 3600
 | Accumulated Amortization |  |  |  | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180
2408 | ESRD License | 03/15-02/17 |  | 2520
 | Accumulated Amortization |  |  |  | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180
2410 | ESRD License | 05/15 - 04/17 |  | 3413.360000000001
 | Accumulated Amortization |  |  |  | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33
2411 | ESRD License | 06/16-05/18 |  |  |  |  | 4320
 | Accumulated Amortization |  |  |  |  |  |  |  |  |  | -360 | -180 | -180 | -180
2413 | ESRD License | 08/15-07/17 |  | 3420
 | Accumulated Amortization |  |  |  | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180
2598 | ESRD License | 06/15 - 05/17 |  | 3060
 | Accumulated Amortization |  |  |  | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180
2598 | ESRD License | 06/17-05/19 |  |  |  |  |  |  |  |  |  | 4300
 | Accumulated Amortization
2889 | ESRD License | 07/15-06/16 |  | 1249.98
 | Accumulated Amortization |  |  |  |  | -416.66 | -208.33 | -208.33 | -208.33 | -208.33
2963 | ESRD License | 01/16-12/17 |  | 5120
 | Accumulated Amortization |  |  |  | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33
3041 | ESRD License | 01/17-12/17 |  |  |  |  |  |  |  |  |  |  |  | 3407.02
 | Accumulated Amortization
3102 | ESRD License | 12/16-11/17
 | Accumulated Amortization |  |  |  |  |  |  |  |  |  |  |  | 3407.02
3284 | ESRD License | 09/15-08/17 |  | 3600
 | Accumulated Amortization |  |  |  | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180
3885 | ESRD License | 03/16-02/18 |  | 6720
 | Accumulated Amortization |  |  |  |  |  | -280 | -280 | -280 | -280 | -280 | -280 | -280 | -280
3980 | ESRD License | 07/16-0618 |  |  |  |  |  |  |  | 5120
 | Accumulated Amortization |  |  |  |  |  |  |  |  |  | -213.33 | -213.33 | -213.33 | -213.33
4057 | ESRD License | 02/15-01/17 |  | 1906.629999999999
 | Accumulated Amortization |  |  |  | -146.67 | -146.67 | -146.67 | -146.67 | -146.67 | -146.67 | -146.67 | -146.67 | -146.67 | -146.67
4155 | ESRD License | 09/15-08/17 |  | 4266.68
 | Accumulated Amortization |  |  |  | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33
4171 | ESRD License | 09/16-08/18 |  |  |  |  |  |  |  | 5120
 | Accumulated Amortization |  |  |  |  |  |  |  |  |  |  |  | -213.33 | -213.33
4179 | ESRD License | 06/16-05/18 |  |  |  |  | 5120
 | Accumulated Amortization |  |  |  |  |  |  |  |  | -213.33 | -213.33 | -213.33 | -213.33 | -213.33
4186 | ESRD License | 04/15 - 03/17 |  | 3200.030000000001
 | Accumulated Amortization |  |  |  | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33
4189 | ESRD License | 05/15 - 04/17 |  | 3413.360000000001
 | Accumulated Amortization |  |  |  | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33
4192 | ESRD License | 02/16-01/18 |  | 5120
 | Accumulated Amortization |  |  |  |  | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33
4462 | ESRD License | 11/15-10/17 |  | 5426.66
 | Accumulated Amortization |  |  |  | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67
4646 | ESRD License | 11/16-10/17 |  |  |  |  |  |  |  |  |  |  | 3435
 | Accumulated Amortization
4948 | ESRD License | 03/15-02/17 |  | 2508.299999999999
 | Accumulated Amortization |  |  |  | -179.17 | -179.17 | -179.17 | -179.17 | -179.17 | -179.17 | -179.17 | -179.17 | -179.17 | -179.17
4950 | ESRD License | 06/16-05/17 |  |  |  |  |  |  | 4320
 | Accumulated Amortization |  |  |  |  |  |  |  |  | -360 | -360 | -360 | -360 | -360
5329 | ESRD License | 03/15-02/17 |  | 2520
 | Accumulated Amortization |  |  |  | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180
5446 | ESRD License | 04/15-03/17 |  | 2700
 | Accumulated Amortization |  |  |  | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180
5447 | ESRD License | 09/15-08/17 |  | 3600
 | Accumulated Amortization |  |  |  | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180
5484 | ESRD License | 01/17-12/17 |  |  |  |  |  |  |  |  |  |  |  | 3407.02
 | Accumulated Amortization
5489 | ESRD License | 09/16-08/18 |  |  |  |  |  |  |  |  |  | 5120
 | Accumulated Amortization |  |  |  |  |  |  |  |  |  |  |  | -213.33 | -213.33
5497 | ESRD License | 12/15-11/17 |  | 4140
 | Accumulated Amortization |  |  |  | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180
6079 | ESRD License | 11/15-10/17 |  | 3960
 | Accumulated Amortization |  |  |  | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180
6119 | ESRD License | 12/16-11/17 |  |  |  |  |  |  |  |  |  |  | 3407.02
 | Accumulated Amortization
6132 | ESRD License | 01/17-12/17 |  |  |  |  |  |  |  |  |  |  | 3407.02
 | Accumulated Amortization
6181 | ESRD License | 11/16-10/17 |  |  |  |  |  |  |  |  |  |  |  | 3407.02
 | Accumulated Amortization
6292 | ESRD License | 10/16-09/17
 | Accumulated Amortization |  |  |  |  |  |  |  |  |  |  | 4489 |  | -374.08
6700 | ESRD License | 01/15-12/16 |  | 2160
 | Accumulated Amortization |  |  |  | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180
6700 | ESRD License | 01/17-12/18 |  |  |  |  |  |  |  |  |  |  |  | 4320
 | Accumulated Amortization
6771 | ESRD License | 09/15-08/17 |  | 3600
 | Accumulated Amortization |  |  |  | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180
7049 | ESRD License | 05/16-04/18 |  |  |  |  | 5920
 | Accumulated Amortization |  |  |  |  |  |  |  | -246.67 | -246.67 | -246.67 | -246.67 | -246.67 | -246.67
7174 | ESRD License | 09/16-08/17 |  |  |  |  |  |  |  |  |  |  | 2561
 | Accumulated Amortization |  |  |  |  |  |  |  |  |  |  |  |  | -2561
7187 | ESRD Parking Commission | 11/12-10/17 |  | 4984.429999999992
 | Accumulated Amortization |  |  |  | -226.56 | -226.56 | -226.56 | -226.56 | -226.56 | -226.56 | -226.56 | -226.56 | -226.56 | -226.56
7187 | Parking Commission | 12/12-10/17 |  | 513.3999999999995
 | Accumulated Amortization |  |  |  | -23.33 | -23.33 | -23.33 | -23.33 | -23.33 | -23.33 | -23.33 | -23.33 | -23.33 | -23.33
7187 | ESRD License | 11/16-10/17 |  |  |  |  |  |  |  |  |  |  |  | 3407.02
 | Accumulated Amortization
7182 | ESRD License | 01/17-12/17 |  |  |  |  |  |  |  |  |  |  | 3407.02
 | Accumulated Amortization
7186 | ESRD License | 11/16-10/17 |  |  |  |  |  |  |  |  |  |  | 3407.02
 | Accumulated Amortization
7192 | ESRD License | 11/16-10/17 |  |  |  |  |  |  |  |  |  |  | 3407.02
 | Accumulated Amortization
7195 | ESRD License | 11/16-10/17 |  |  |  |  |  |  |  |  |  |  | 3407.02
 | Accumulated Amortization
7431 | ESRD License | 10/16-09/17 |  |  |  |  |  |  |  |  |  | 4854
 | Accumulated Amortization |  |  |  |  |  |  |  |  |  |  |  |  | -404.5
7552 | ESRD License | 03/16-02/18 |  | 4320
 | Accumulated Amortization |  |  |  | -180 | -180 | -180 | -180 | -180 | -180 |  |  |  | -180
7394 | ESRD License | 07/16-06/18 |  |  |  |  |  |  | 4320
 | Accumulated Amortization |  |  |  |  |  |  |  |  |  | -360 | -180 | -180 | -180
7405 | ESRD License | 05/16-04/17 |  |  |  |  |  |  | 4134.03
 | Accumulated Amortization |  |  |  |  |  |  |  |  |  | -1033.5 | -344.5 | -344.5 | -344.5
7430 | ESRD License | 07/16-06/18 |  |  |  |  |  |  | 4360
 | Accumulated Amortization |  |  |  |  |  |  |  |  |  | -4360 | 4380 | -547.5 | -182.5
7494 | ESRD License | 07/16-06/17 |  |  |  |  |  |  |  | 4492.09
 | Accumulated Amortization |  |  |  |  |  |  |  |  |  | -374.34 | -374.34 | -374.34 | -374.34
8393 | ESRD License | 06/16-6/18 |  |  |  |  |  |  | 4320
 | Accumulated Amortization |  |  |  |  |  |  |  |  | -360 | -360 | -360 | -360 | -360
8399 | ESRD License | 07/15-06/17 |  | 5040
 | Accumulated Amortization |  |  |  | -280 | -280 | -280 | -280 | -280 | -280 | -280 | -280 | -280 | -280
8433 | ESRD License | 08/15-07/17 |  | 2786.65
 | Accumulated Amortization |  |  |  | -146.67 | -146.67 | -146.67 | -146.67 | -146.67 | -146.67 | -146.67 | -146.67 | -146.67 | -146.67
8803 | ESRD License | 11/14-10/16 |  | 2360
 | Accumulated Amortization |  |  |  | -236 | -236 | -236 | -236 | -236 | -236 | -236 | -236 | -236 | -236
8556 | ESRD License | 01/17-12/17 |  |  |  |  |  |  |  |  |  |  | 2520
 | Accumulated Amortization
8803 | ESRD License | 11/16-10/18 |  |  |  |  |  |  |  |  |  | 5920
 | Accumulated Amortization
8853 | ESRD License | 11/15-10/17 |  | 3960
 | Accumulated Amortization |  |  |  | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180
8857 | ESRD License | 11/15-10/17 |  | 3960
 | Accumulated Amortization |  |  |  | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180 | -180
8860 | ESRD License | 10/15-11/17 |  | 4693.34
 | Accumulated Amortization |  |  |  | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33 | -213.33
9208 | ESRD License | 06/16-05/18 |  |  |  | 4300
 | Accumulated Amortization |  |  |  |  |  | -119.44 | -119.44 | -119.44 |  |  | -187.6 | -187.6 | -187.6
9462 | ESRD License | 09/16-10/17 |  |  |  |  |  |  |  |  |  | 4300
 | Accumulated Amortization |  |  |  |  |  |  |  |  |  |  |  | -358.33 | -358.33
Total Business Licenses, Registrations and Permits