Loading...

Excel work- Exp19_Excel_Ch05_Cap_Apartments

Open Posted By: highheaven1 Date: 17/09/2020 Graduate Research Paper Writing

Must follow instructions from the word document. 

Category: Arts & Education Subjects: Art Deadline: 12 Hours Budget: $120 - $180 Pages: 2-3 Pages (Short Assignment)

Attachment 1

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
201 Rolling Meadows 1 Yes 4/13/14 7.05 $ 875 $ 875 $ 150 $ 1,025
202 Rolling Meadows 1 Yes 4/13/14 7.05 $ 875 $ 875 $ 150 $ 1,025
101 Rolling Meadows 1 Yes 4/1/14 7.08 $ 950 $ 950 $ 150 $ 1,100
602 Oak Tree Living 1 Yes 11/1/13 7.50 $ 1,500 $ 1,500 $ 150 $ 1,650
601 Oak Tree Living 1 Yes 8/15/13 7.71 $ 1,500 $ 1,500 $ 150 $ 1,650
506 Sunset Valley 2 Yes 10/10/11 9.56 $ 1,100 $ 1,100 $ 200 $ 1,300
507 Sunset Valley 2 No 10/10/11 9.56 $ 1,100 $ 1,100 $ 200 $ 1,300
205 Rolling Meadows 3 Yes 8/15/11 9.71 $ 1,050 $ 1,050 $ 250 $ 1,300
204 Rolling Meadows 2 No 4/1/11 10.08 $ 995 $ 995 $ 200 $ 1,195

Rentals

Unit # Apartment Complex # Bed Occupied Last Remodel Years Since Remodel Rental Price Security Deposit Non-Refund Cleaning Deposit Total Deposit
301 Lakeview Apartments 1 No 4/15/18 3.04 $ 875 $ 963 $ 150 $ 1,113
302 Lakeview Apartments 1 No 5/1/15 6.00 $ 875 $ 875 $ 150 $ 1,025
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
305 Lakeview Apartments 2 No 10/4/16 4.58 $ 1,200 $ 1,320 $ 200 $ 1,520
306 Lakeview Apartments 2 Yes 6/15/18 2.88 $ 1,200 $ 1,320 $ 200 $ 1,520
307 Lakeview Apartments 2 Yes 6/30/20 0.84 $ 1,200 $ 1,320 $ 200 $ 1,520
308 Lakeview Apartments 2 No 9/30/20 0.59 $ 1,200 $ 1,320 $ 200 $ 1,520
401 Mountaintop View 1 No 7/1/19 1.83 $ 875 $ 963 $ 150 $ 1,113
404 Mountaintop View 1 No 10/4/20 0.58 $ 875 $ 963 $ 150 $ 1,113
402 Mountaintop View 2 No 8/1/18 2.75 $ 950 $ 1,045 $ 200 $ 1,245
405 Mountaintop View 2 Yes 6/15/20 0.88 $ 950 $ 1,045 $ 200 $ 1,245
407 Mountaintop View 2 Yes 3/1/19 2.17 $ 975 $ 1,073 $ 200 $ 1,273
408 Mountaintop View 2 Yes 11/15/15 5.46 $ 975 $ 975 $ 200 $ 1,175
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
601 Oak Tree Living 1 Yes 8/15/13 7.71 $ 1,500 $ 1,500 $ 150 $ 1,650
602 Oak Tree Living 1 Yes 11/1/13 7.50 $ 1,500 $ 1,500 $ 150 $ 1,650
603 Oak Tree Living 2 No 8/15/15 5.71 $ 1,200 $ 1,200 $ 200 $ 1,400
604 Oak Tree Living 2 Yes 12/1/15 5.42 $ 1,200 $ 1,200 $ 200 $ 1,400
605 Oak Tree Living 3 No 11/30/20 0.42 $ 2,000 $ 2,200 $ 250 $ 2,450
606 Oak Tree Living 3 Yes 3/30/17 4.09 $ 2,000 $ 2,200 $ 250 $ 2,450
607 Oak Tree Living 3 No 3/30/18 3.09 $ 2,000 $ 2,200 $ 250 $ 2,450
101 Rolling Meadows 1 Yes 4/1/14 7.08 $ 950 $ 950 $ 150 $ 1,100
102 Rolling Meadows 1 Yes 3/1/18 3.17 $ 950 $ 1,045 $ 150 $ 1,195
201 Rolling Meadows 1 Yes 4/13/14 7.05 $ 875 $ 875 $ 150 $ 1,025
202 Rolling Meadows 1 Yes 4/13/14 7.05 $ 875 $ 875 $ 150 $ 1,025
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
107 Rolling Meadows 2 No 11/1/20 0.50 $ 1,100 $ 1,210 $ 200 $ 1,410
108 Rolling Meadows 2 Yes 8/15/17 3.71 $ 1,100 $ 1,210 $ 200 $ 1,410
203 Rolling Meadows 2 Yes 4/1/16 5.08 $ 995 $ 995 $ 200 $ 1,195
204 Rolling Meadows 2 No 4/1/11 10.08 $ 995 $ 995 $ 200 $ 1,195
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
105 Rolling Meadows 3 No 10/1/15 5.58 $ 1,500 $ 1,500 $ 250 $ 1,750
106 Rolling Meadows 3 Yes 6/15/20 0.88 $ 1,500 $ 1,650 $ 250 $ 1,900
109 Rolling Meadows 3 No 8/15/19 1.71 $ 1,500 $ 1,650 $ 250 $ 1,900
110 Rolling Meadows 3 Yes 10/4/18 2.58 $ 1,500 $ 1,650 $ 250 $ 1,900
205 Rolling Meadows 3 Yes 8/15/11 9.71 $ 1,050 $ 1,050 $ 250 $ 1,300
206 Rolling Meadows 3 No 7/1/15 5.83 $ 1,050 $ 1,050 $ 250 $ 1,300
209 Rolling Meadows 3 No 8/1/20 0.75 $ 1,050 $ 1,155 $ 250 $ 1,405
210 Rolling Meadows 3 Yes 11/4/19 1.49 $ 1,050 $ 1,155 $ 250 $ 1,405
501 Sunset Valley 1 Yes 10/1/15 5.58 $ 875 $ 875 $ 150 $ 1,025
502 Sunset Valley 1 No 8/1/18 2.75 $ 875 $ 963 $ 150 $ 1,113
503 Sunset Valley 1 No 8/1/19 1.75 $ 875 $ 963 $ 150 $ 1,113
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
506 Sunset Valley 2 Yes 10/10/11 9.56 $ 1,100 $ 1,100 $ 200 $ 1,300
507 Sunset Valley 2 No 10/10/11 9.56 $ 1,100 $ 1,100 $ 200 $ 1,300

Databases

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 # Code # Bed Occupied Last Remodel Years Since Remodel Rental Price Security Deposit Non-Refund Cleaning Deposit Total Deposit Code Apartment Name
301 LA 1 No 4/15/18 3.04 $ 875 $ 963 $ 150 $ 1,113 LA Lakeview Apartments
302 LA 1 No 5/1/15 6.00 $ 875 $ 875 $ 150 $ 1,025 MV Mountaintop View
303 LA 1 No 5/5/15 5.99 $ 900 $ 900 $ 150 $ 1,050 OTL Oak Tree Living
304 LA 1 Yes 5/5/15 5.99 $ 900 $ 900 $ 150 $ 1,050 RM Rolling Meadows
305 LA 2 No 10/4/16 4.58 $ 1,200 $ 1,320 $ 200 $ 1,520 SV Sunset Valley
306 LA 2 Yes 6/15/18 2.88 $ 1,200 $ 1,320 $ 200 $ 1,520
307 LA 2 Yes 6/30/20 0.84 $ 1,200 $ 1,320 $ 200 $ 1,520
308 LA 2 No 9/30/20 0.59 $ 1,200 $ 1,320 $ 200 $ 1,520
401 MV 1 No 7/1/19 1.83 $ 875 $ 963 $ 150 $ 1,113
404 MV 1 No 10/4/20 0.58 $ 875 $ 963 $ 150 $ 1,113
402 MV 2 No 8/1/18 2.75 $ 950 $ 1,045 $ 200 $ 1,245
405 MV 2 Yes 6/15/20 0.88 $ 950 $ 1,045 $ 200 $ 1,245
407 MV 2 Yes 3/1/19 2.17 $ 975 $ 1,073 $ 200 $ 1,273
408 MV 2 Yes 11/15/15 5.46 $ 975 $ 975 $ 200 $ 1,175
403 MV 3 Yes 5/5/21 0.01 $ 1,200 $ 1,320 $ 250 $ 1,570
406 MV 3 No 4/1/21 0.08 $ 1,200 $ 1,320 $ 250 $ 1,570
601 OTL 1 Yes 8/15/13 7.71 $ 1,500 $ 1,500 $ 150 $ 1,650
602 OTL 1 Yes 11/1/13 7.50 $ 1,500 $ 1,500 $ 150 $ 1,650
603 OTL 2 No 8/15/15 5.71 $ 1,200 $ 1,200 $ 200 $ 1,400
604 OTL 2 Yes 12/1/15 5.42 $ 1,200 $ 1,200 $ 200 $ 1,400
605 OTL 3 No 11/30/20 0.42 $ 2,000 $ 2,200 $ 250 $ 2,450
606 OTL 3 Yes 3/30/17 4.09 $ 2,000 $ 2,200 $ 250 $ 2,450
607 OTL 3 No 3/30/18 3.09 $ 2,000 $ 2,200 $ 250 $ 2,450
101 RM 1 Yes 4/1/14 7.08 $ 950 $ 950 $ 150 $ 1,100
102 RM 1 Yes 3/1/18 3.17 $ 950 $ 1,045 $ 150 $ 1,195
201 RM 1 Yes 4/13/14 7.05 $ 875 $ 875 $ 150 $ 1,025
202 RM 1 Yes 4/13/14 7.05 $ 875 $ 875 $ 150 $ 1,025
103 RM 2 No 11/15/15 5.46 $ 1,100 $ 1,100 $ 200 $ 1,300
104 RM 2 Yes 10/1/15 5.58 $ 1,100 $ 1,100 $ 200 $ 1,300
107 RM 2 No 11/1/20 0.50 $ 1,100 $ 1,210 $ 200 $ 1,410
108 RM 2 Yes 8/15/17 3.71 $ 1,100 $ 1,210 $ 200 $ 1,410
203 RM 2 Yes 4/1/16 5.08 $ 995 $ 995 $ 200 $ 1,195
204 RM 2 No 4/1/11 10.08 $ 995 $ 995 $ 200 $ 1,195
207 RM 2 Yes 8/1/20 0.75 $ 995 $ 1,095 $ 200 $ 1,295
208 RM 2 Yes 8/1/20 0.75 $ 995 $ 1,095 $ 200 $ 1,295
105 RM 3 No 10/1/15 5.58 $ 1,500 $ 1,500 $ 250 $ 1,750
106 RM 3 Yes 6/15/20 0.88 $ 1,500 $ 1,650 $ 250 $ 1,900
109 RM 3 No 8/15/19 1.71 $ 1,500 $ 1,650 $ 250 $ 1,900
110 RM 3 Yes 10/4/18 2.58 $ 1,500 $ 1,650 $ 250 $ 1,900
205 RM 3 Yes 8/15/11 9.71 $ 1,050 $ 1,050 $ 250 $ 1,300
206 RM 3 No 7/1/15 5.83 $ 1,050 $ 1,050 $ 250 $ 1,300
209 RM 3 No 8/1/20 0.75 $ 1,050 $ 1,155 $ 250 $ 1,405
210 RM 3 Yes 11/4/19 1.49 $ 1,050 $ 1,155 $ 250 $ 1,405
501 SV 1 Yes 10/1/15 5.58 $ 875 $ 875 $ 150 $ 1,025
502 SV 1 No 8/1/18 2.75 $ 875 $ 963 $ 150 $ 1,113
503 SV 1 No 8/1/19 1.75 $ 875 $ 963 $ 150 $ 1,113
504 SV 1 Yes 7/2/14 6.83 $ 875 $ 875 $ 150 $ 1,025
505 SV 2 No 7/2/14 6.83 $ 1,100 $ 1,100 $ 200 $ 1,300
506 SV 2 Yes 10/10/11 9.56 $ 1,100 $ 1,100 $ 200 $ 1,300
507 SV 2 No 10/10/11 9.56 $ 1,100 $ 1,100 $ 200 $ 1,300

Similar Homeworks Posted


Chemistry exercises Homework

Disscussion

CRM Case Study

Why Amazon is Worth $1 Trillion

Purchasing and Buyer Behavior

Textbook summary ( 4pages summary )

MIS DS 5.

Explanations of Principles

Unit 4 Quiz (HRM303)

BOTSWANA [[**+2761O482071**[[]@)) approved-legal-abortion-pills-for-sale-in- BOTSWANA RANDBURG, CENTURION

Types of Qualitative Research

SANDTON ▼[₊₂₇₆₁₀₄₈₂₀₇₁▼▼]@))Mifepristone Abortion Pill For Sale in SANDTON SHOSHANGUVE, LOTUS GARDENS

Buy abortion pills in Oman +27734442164 Abortion pills for sale in Oman #cytotec #misoprostol

SAULSVILLE >[[[[[[+2761O482071]]]]>>]@)) Abortion Pills Sale ... Pills For Sale In SAULSVILLE WITBANK, ATTERIDGEVILLE

SILVERTON ⓶[[[[[[+2761O482071]]]]⓶⓶]@)) Abortion Service & pills for sale in SILVERTON RIVONIA, THOKOZA

TEMBISA :[[+2761O482071]::]@)) abortion pill (for sale) pregnancy termination TEMBISA FAERIE GLENN, MORELETA PARK

BLOEMFONTEIN ⓶[**+2761O482071**⓶⓶]@))Trusted abortion clinic - pills for sale in BLOEMFONTEIN EAST LYNNE, TEMBISA

RANDBURG -[[[[[[+2761O482071]]]]--]@)) …/abortion-pills-for-sale-in- RANDBURG PARKTOWN, PRETORIA

ROODEPOORT .._[[+2761O482071].._.._]@)) abortion clinics & pills for sale in ROODEPOORT RANDBURG, ZEERUST

7 Habits of Highly Effective People BUSA 208 Assignment

This is due tomorrow morning

Initiating the Project - Problem Set 5

Resource Assignment

paper

midterm

Community Health Discussion 1

Emerging threats_5.1

Blockchain Technology

galileo

assignment #7