Exp19_excel_ch05_cap_apartments

Summary
Constants for Formulas
Comparison Date 5/1/21
Years Since Remodel 5.0
Deposit Older (Rent*1.25) 1.0
Deposit Newer (Rent*1.5) 1.1
Unit # Apartment Complex # Bed Occupied Last Remodel Years Since Remodel Rental Price Security Deposit Non-Refund Cleaning Deposit Total Deposit
403 Mountaintop View 3 Yes 5/5/21 0.01 $ 1,200 $ 1,320 $ 250 $ 1,570
406 Mountaintop View 3 No 4/1/21 0.08 $ 1,200 $ 1,320 $ 250 $ 1,570
605 Oak Tree Living 3 No 11/30/20 0.42 $ 2,000 $ 2,200 $ 250 $ 2,450
107 Rolling Meadows 2 No 11/1/20 0.50 $ 1,100 $ 1,210 $ 200 $ 1,410
404 Mountaintop View 1 No 10/4/20 0.58 $ 875 $ 963 $ 150 $ 1,113
308 Lakeview Apartments 2 No 9/30/20 0.59 $ 1,200 $ 1,320 $ 200 $ 1,520
207 Rolling Meadows 2 Yes 8/1/20 0.75 $ 995 $ 1,095 $ 200 $ 1,295
208 Rolling Meadows 2 Yes 8/1/20 0.75 $ 995 $ 1,095 $ 200 $ 1,295
209 Rolling Meadows 3 No 8/1/20 0.75 $ 1,050 $ 1,155 $ 250 $ 1,405
307 Lakeview Apartments 2 Yes 6/30/20 0.84 $ 1,200 $ 1,320 $ 200 $ 1,520
405 Mountaintop View 2 Yes 6/15/20 0.88 $ 950 $ 1,045 $ 200 $ 1,245
106 Rolling Meadows 3 Yes 6/15/20 0.88 $ 1,500 $ 1,650 $ 250 $ 1,900
210 Rolling Meadows 3 Yes 11/4/19 1.49 $ 1,050 $ 1,155 $ 250 $ 1,405
109 Rolling Meadows 3 No 8/15/19 1.71 $ 1,500 $ 1,650 $ 250 $ 1,900
503 Sunset Valley 1 No 8/1/19 1.75 $ 875 $ 963 $ 150 $ 1,113
401 Mountaintop View 1 No 7/1/19 1.83 $ 875 $ 963 $ 150 $ 1,113
407 Mountaintop View 2 Yes 3/1/19 2.17 $ 975 $ 1,073 $ 200 $ 1,273
110 Rolling Meadows 3 Yes 10/4/18 2.58 $ 1,500 $ 1,650 $ 250 $ 1,900
402 Mountaintop View 2 No 8/1/18 2.75 $ 950 $ 1,045 $ 200 $ 1,245
502 Sunset Valley 1 No 8/1/18 2.75 $ 875 $ 963 $ 150 $ 1,113
306 Lakeview Apartments 2 Yes 6/15/18 2.88 $ 1,200 $ 1,320 $ 200 $ 1,520
301 Lakeview Apartments 1 No 4/15/18 3.04 $ 875 $ 963 $ 150 $ 1,113
607 Oak Tree Living 3 No 3/30/18 3.09 $ 2,000 $ 2,200 $ 250 $ 2,450
102 Rolling Meadows 1 Yes 3/1/18 3.17 $ 950 $ 1,045 $ 150 $ 1,195
108 Rolling Meadows 2 Yes 8/15/17 3.71 $ 1,100 $ 1,210 $ 200 $ 1,410
606 Oak Tree Living 3 Yes 3/30/17 4.09 $ 2,000 $ 2,200 $ 250 $ 2,450
305 Lakeview Apartments 2 No 10/4/16 4.58 $ 1,200 $ 1,320 $ 200 $ 1,520
203 Rolling Meadows 2 Yes 4/1/16 5.08 $ 995 $ 995 $ 200 $ 1,195
604 Oak Tree Living 2 Yes 12/1/15 5.42 $ 1,200 $ 1,200 $ 200 $ 1,400
408 Mountaintop View 2 Yes 11/15/15 5.46 $ 975 $ 975 $ 200 $ 1,175
103 Rolling Meadows 2 No 11/15/15 5.46 $ 1,100 $ 1,100 $ 200 $ 1,300
104 Rolling Meadows 2 Yes 10/1/15 5.58 $ 1,100 $ 1,100 $ 200 $ 1,300
105 Rolling Meadows 3 No 10/1/15 5.58 $ 1,500 $ 1,500 $ 250 $ 1,750
501 Sunset Valley 1 Yes 10/1/15 5.58 $ 875 $ 875 $ 150 $ 1,025
603 Oak Tree Living 2 No 8/15/15 5.71 $ 1,200 $ 1,200 $ 200 $ 1,400
206 Rolling Meadows 3 No 7/1/15 5.83 $ 1,050 $ 1,050 $ 250 $ 1,300
303 Lakeview Apartments 1 No 5/5/15 5.99 $ 900 $ 900 $ 150 $ 1,050
304 Lakeview Apartments 1 Yes 5/5/15 5.99 $ 900 $ 900 $ 150 $ 1,050
302 Lakeview Apartments 1 No 5/1/15 6.00 $ 875 $ 875 $ 150 $ 1,025
504 Sunset Valley 1 Yes 7/2/14 6.83 $ 875 $ 875 $ 150 $ 1,025
505 Sunset Valley 2 No 7/2/14 6.83 $ 1,100 $ 1,100 $ 200 $ 1,300