Summary Constants for Formulas Comparison Date5/1/21 Years Since Remodel5.0 Deposit Older (Rent*1.25)1.0 Deposit Newer (Rent*1.5)1.1 Unit #Apartment Complex# BedOccupiedLast RemodelYears...

1 answer below »
Do this in excel


Summary Constants for Formulas Comparison Date5/1/21 Years Since Remodel5.0 Deposit Older (Rent*1.25)1.0 Deposit Newer (Rent*1.5)1.1 Unit #Apartment Complex# BedOccupiedLast RemodelYears Since RemodelRental PriceSecurity DepositNon-Refund Cleaning DepositTotal Deposit 403Mountaintop View3Yes5/5/210.01$ 1,200$ 1,320$ 250$ 1,570 406Mountaintop View3No4/1/210.08$ 1,200$ 1,320$ 250$ 1,570 605Oak Tree Living3No11/30/200.42$ 2,000$ 2,200$ 250$ 2,450 107Rolling Meadows2No11/1/200.50$ 1,100$ 1,210$ 200$ 1,410 404Mountaintop View1No10/4/200.58$ 875$ 963$ 150$ 1,113 308Lakeview Apartments2No9/30/200.59$ 1,200$ 1,320$ 200$ 1,520 207Rolling Meadows2Yes8/1/200.75$ 995$ 1,095$ 200$ 1,295 208Rolling Meadows2Yes8/1/200.75$ 995$ 1,095$ 200$ 1,295 209Rolling Meadows3No8/1/200.75$ 1,050$ 1,155$ 250$ 1,405 307Lakeview Apartments2Yes6/30/200.84$ 1,200$ 1,320$ 200$ 1,520 405Mountaintop View2Yes6/15/200.88$ 950$ 1,045$ 200$ 1,245 106Rolling Meadows3Yes6/15/200.88$ 1,500$ 1,650$ 250$ 1,900 210Rolling Meadows3Yes11/4/191.49$ 1,050$ 1,155$ 250$ 1,405 109Rolling Meadows3No8/15/191.71$ 1,500$ 1,650$ 250$ 1,900 503Sunset Valley1No8/1/191.75$ 875$ 963$ 150$ 1,113 401Mountaintop View1No7/1/191.83$ 875$ 963$ 150$ 1,113 407Mountaintop View2Yes3/1/192.17$ 975$ 1,073$ 200$ 1,273 110Rolling Meadows3Yes10/4/182.58$ 1,500$ 1,650$ 250$ 1,900 402Mountaintop View2No8/1/182.75$ 950$ 1,045$ 200$ 1,245 502Sunset Valley1No8/1/182.75$ 875$ 963$ 150$ 1,113 306Lakeview Apartments2Yes6/15/182.88$ 1,200$ 1,320$ 200$ 1,520 301Lakeview Apartments1No4/15/183.04$ 875$ 963$ 150$ 1,113 607Oak Tree Living3No3/30/183.09$ 2,000$ 2,200$ 250$ 2,450 102Rolling Meadows1Yes3/1/183.17$ 950$ 1,045$ 150$ 1,195 108Rolling Meadows2Yes8/15/173.71$ 1,100$ 1,210$ 200$ 1,410 606Oak Tree Living3Yes3/30/174.09$ 2,000$ 2,200$ 250$ 2,450 305Lakeview Apartments2No10/4/164.58$ 1,200$ 1,320$ 200$ 1,520 203Rolling Meadows2Yes4/1/165.08$ 995$ 995$ 200$ 1,195 604Oak Tree Living2Yes12/1/155.42$ 1,200$ 1,200$ 200$ 1,400 408Mountaintop View2Yes11/15/155.46$ 975$ 975$ 200$ 1,175 103Rolling Meadows2No11/15/155.46$ 1,100$ 1,100$ 200$ 1,300 104Rolling Meadows2Yes10/1/155.58$ 1,100$ 1,100$ 200$ 1,300 105Rolling Meadows3No10/1/155.58$ 1,500$ 1,500$ 250$ 1,750 501Sunset Valley1Yes10/1/155.58$ 875$ 875$ 150$ 1,025 603Oak Tree Living2No8/15/155.71$ 1,200$ 1,200$ 200$ 1,400 206Rolling Meadows3No7/1/155.83$ 1,050$ 1,050$ 250$ 1,300 303Lakeview Apartments1No5/5/155.99$ 900$ 900$ 150$ 1,050 304Lakeview Apartments1Yes5/5/155.99$ 900$ 900$ 150$ 1,050 302Lakeview Apartments1No5/1/156.00$ 875$ 875$ 150$ 1,025 504Sunset Valley1Yes7/2/146.83$ 875$ 875$ 150$ 1,025 505Sunset Valley2No7/2/146.83$ 1,100$ 1,100$ 200$ 1,300 201Rolling Meadows1Yes4/13/147.05$ 875$ 875$ 150$ 1,025 202Rolling Meadows1Yes4/13/147.05$ 875$ 875$ 150$ 1,025 101Rolling Meadows1Yes4/1/147.08$ 950$ 950$ 150$ 1,100 602Oak Tree Living1Yes11/1/137.50$ 1,500$ 1,500$ 150$ 1,650 601Oak Tree Living1Yes8/15/137.71$ 1,500$ 1,500$ 150$ 1,650 506Sunset Valley2Yes10/10/119.56$ 1,100$ 1,100$ 200$ 1,300 507Sunset Valley2No10/10/119.56$ 1,100$ 1,100$ 200$ 1,300 205Rolling Meadows3Yes8/15/119.71$ 1,050$ 1,050$ 250$ 1,300 204Rolling Meadows2No4/1/1110.08$ 995$ 995$ 200$ 1,195 Rentals Unit #Apartment Complex# BedOccupiedLast RemodelYears Since RemodelRental PriceSecurity DepositNon-Refund Cleaning DepositTotal Deposit 301Lakeview Apartments1No4/15/183.04$ 875$ 963$ 150$ 1,113 302Lakeview Apartments1No5/1/156.00$ 875$ 875$ 150$ 1,025 303Lakeview Apartments1No5/5/155.99$ 900$ 900$ 150$ 1,050 304Lakeview Apartments1Yes5/5/155.99$ 900$ 900$ 150$ 1,050 305Lakeview Apartments2No10/4/164.58$ 1,200$ 1,320$ 200$ 1,520 306Lakeview Apartments2Yes6/15/182.88$ 1,200$ 1,320$ 200$ 1,520 307Lakeview Apartments2Yes6/30/200.84$ 1,200$ 1,320$ 200$ 1,520 308Lakeview Apartments2No9/30/200.59$ 1,200$ 1,320$ 200$ 1,520 401Mountaintop View1No7/1/191.83$ 875$ 963$ 150$ 1,113 404Mountaintop View1No10/4/200.58$ 875$ 963$ 150$ 1,113 402Mountaintop View2No8/1/182.75$ 950$ 1,045$ 200$ 1,245 405Mountaintop View2Yes6/15/200.88$ 950$ 1,045$ 200$ 1,245 407Mountaintop View2Yes3/1/192.17$ 975$ 1,073$ 200$ 1,273 408Mountaintop View2Yes11/15/155.46$ 975$ 975$ 200$ 1,175 403Mountaintop View3Yes5/5/210.01$ 1,200$ 1,320$ 250$ 1,570 406Mountaintop View3No4/1/210.08$ 1,200$ 1,320$ 250$ 1,570 601Oak Tree Living1Yes8/15/137.71$ 1,500$ 1,500$ 150$ 1,650 602Oak Tree Living1Yes11/1/137.50$ 1,500$ 1,500$ 150$ 1,650 603Oak Tree Living2No8/15/155.71$ 1,200$ 1,200$ 200$ 1,400 604Oak Tree Living2Yes12/1/155.42$ 1,200$ 1,200$ 200$ 1,400 605Oak Tree Living3No11/30/200.42$ 2,000$ 2,200$ 250$ 2,450 606Oak Tree Living3Yes3/30/174.09$ 2,000$ 2,200$ 250$ 2,450 607Oak Tree Living3No3/30/183.09$ 2,000$ 2,200$ 250$ 2,450 101Rolling Meadows1Yes4/1/147.08$ 950$ 950$ 150$ 1,100 102Rolling Meadows1Yes3/1/183.17$ 950$ 1,045$ 150$ 1,195 201Rolling Meadows1Yes4/13/147.05$ 875$ 875$ 150$ 1,025 202Rolling Meadows1Yes4/13/147.05$ 875$ 875$ 150$ 1,025 103Rolling Meadows2No11/15/155.46$ 1,100$ 1,100$ 200$ 1,300 104Rolling Meadows2Yes10/1/155.58$ 1,100$ 1,100$ 200$ 1,300 107Rolling Meadows2No11/1/200.50$ 1,100$ 1,210$ 200$ 1,410 108Rolling Meadows2Yes8/15/173.71$ 1,100$ 1,210$ 200$ 1,410 203Rolling Meadows2Yes4/1/165.08$ 995$ 995$ 200$ 1,195 204Rolling Meadows2No4/1/1110.08$ 995$ 995$ 200$ 1,195 207Rolling Meadows2Yes8/1/200.75$ 995$ 1,095$ 200$ 1,295 208Rolling Meadows2Yes8/1/200.75$ 995$ 1,095$ 200$ 1,295 105Rolling Meadows3No10/1/155.58$ 1,500$ 1,500$ 250$ 1,750 106Rolling Meadows3Yes6/15/200.88$ 1,500$ 1,650$ 250$ 1,900 109Rolling Meadows3No8/15/191.71$ 1,500$ 1,650$ 250$ 1,900 110Rolling Meadows3Yes10/4/182.58$ 1,500$ 1,650$ 250$ 1,900 205Rolling Meadows3Yes8/15/119.71$ 1,050$ 1,050$ 250$ 1,300 206Rolling Meadows3No7/1/155.83$ 1,050$ 1,050$ 250$ 1,300 209Rolling Meadows3No8/1/200.75$ 1,050$ 1,155$ 250$ 1,405 210Rolling Meadows3Yes11/4/191.49$ 1,050$ 1,155$ 250$ 1,405 501Sunset Valley1Yes10/1/155.58$ 875$ 875$ 150$ 1,025 502Sunset Valley1No8/1/182.75$ 875$ 963$ 150$ 1,113 503Sunset Valley1No8/1/191.75$ 875$ 963$ 150$ 1,113 504Sunset Valley1Yes7/2/146.83$ 875$ 875$ 150$ 1,025 505Sunset Valley2No7/2/146.83$ 1,100$ 1,100$ 200$ 1,300 506Sunset Valley2Yes10/10/119.56$ 1,100$ 1,100$ 200$ 1,300 507Sunset Valley2No10/10/119.56$ 1,100$ 1,100$ 200$ 1,300 Databases Constants for Formulas Comparison Date5/1/21 Years Since Remodel5.0 Deposit Older (Rent*1.25)1.0 Deposit Newer (Rent*1.5)1.1 Unit #Code# BedOccupiedLast RemodelYears Since RemodelRental PriceSecurity DepositNon-Refund Cleaning DepositTotal DepositCodeApartment Name 301LA1No4/15/183.04$ 875$ 963$ 150$ 1,113LALakeview Apartments 302LA1No5/1/156.00$ 875$ 875$ 150$ 1,025MVMountaintop View 303LA1No5/5/155.99$ 900$ 900$ 150$ 1,050OTLOak Tree Living 304LA1Yes5/5/155.99$ 900$ 900$ 150$ 1,050RMRolling Meadows 305LA2No10/4/164.58$ 1,200$ 1,320$ 200$ 1,520SVSunset Valley 306LA2Yes6/15/182.88$ 1,200$ 1,320$ 200$ 1,520 307LA2Yes6/30/200.84$ 1,200$ 1,320$ 200$ 1,520 308LA2No9/30/200.59$ 1,200$ 1,320$ 200$ 1,520 401MV1No7/1/191.83$ 875$ 963$ 150$ 1,113 404MV1No10/4/200.58$ 875$ 963$ 150$ 1,113 402MV2No8/1/182.75$ 950$ 1,045$ 200$ 1,245 405MV2Yes6/15/200.88$ 950$
exp19excelch05capapartmentsfinalresult-3sdlgpvy.jpg ferreiraexp19excelch05capapartments-jmwsm5cu-ywv1kzid.xlsx ferreiraexp19excelch05capapartments-qy1of45z-jo4i5zij.xlsx exp19excelch05capapartmentsinstructions-gqomyzrc-bdxuj10p.docx
Answered Same DayMar 31, 2021

Answer To: Summary Constants for Formulas Comparison Date5/1/21 Years Since Remodel5.0 Deposit Older...

Payal answered on Mar 31 2021
164 Votes
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
    301    Lakeview Apartments    1    No    4/15/18    3.04    $ 875    $ 963    $ 150    $ 1,113
    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
        Lakeview Apartments Average                                $ 1,059
    404    Mountaintop View    1    No    10/4/20    0.58    $ 875    $ 963    $ 150    $ 1,113
    401    Mountaintop View    1    No    7/1/19    1.83    $ 875    $ 963    $ 150    $ 1,113
        Mountaintop View Average                                $ 1,113
    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
        Oak Tree Living Average                                $ 1,650
    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
    101    Rolling Meadows    1    Yes    4/1/14    7.08    $ 950    $ 950    $ 150    $ 1,100
        Rolling Meadows Average                                $ 1,086
    503    Sunset Valley    1    No    8/1/19    1.75    $ 875    $ 963    $ 150    $ 1,113
    502    Sunset Valley    1    No    8/1/18    2.75    $ 875    $ 963    $ 150    $ 1,113
    501    Sunset Valley    1    Yes    10/1/15    5.58    $ 875    $ 875    $ 150    $ 1,025
    504    Sunset Valley    1    Yes    7/2/14    6.83    $ 875    $ 875    $ 150    $ 1,025
        Sunset Valley Average                                $ 1,069
    308    Lakeview Apartments    2    No    9/30/20    0.59    $ 1,200    $ 1,320    $ 200    $ 1,520
    307    Lakeview Apartments    2    Yes    6/30/20    0.84    $ 1,200    $ 1,320    $ 200    $ 1,520
    306    Lakeview Apartments    2    Yes    6/15/18    2.88    $ 1,200    $ 1,320    $ 200    $ 1,520
    305    Lakeview Apartments    2    No    10/4/16    4.58    $ 1,200    $ 1,320    $ 200    $ 1,520
        Lakeview Apartments Average                                $ 1,520
    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
    402    Mountaintop View    2    No    8/1/18    2.75    $ 950    $ 1,045    $ 200    $ 1,245
    408    Mountaintop View    2    Yes    11/15/15    5.46    $ 975    $ 975    $ 200    $ 1,175
        Mountaintop View Average                                $ 1,234
    604    Oak Tree Living    2    Yes    12/1/15    5.42    $ 1,200    $ 1,200    $ 200    $ 1,400
    603    Oak Tree Living    2    No    8/15/15    5.71    $ 1,200    $ 1,200    $ 200    $ 1,400
        Oak Tree Living Average                                $ 1,400
    107    Rolling Meadows    2    No    11/1/20    0.50    $ 1,100    $ 1,210    $ 200    $ 1,410
    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
    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
    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
    204    Rolling Meadows    2    No    4/1/11    10.08    $ 995    $ 995    $ 200    $ 1,195
        Rolling Meadows Average                                $ 1,300
    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
        Sunset Valley Average                                $ 1,300
    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
        Mountaintop View Average                                $ 1,570
    605    Oak Tree Living    3    No    11/30/20    0.42    $ 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
    606    Oak Tree Living    3    Yes    3/30/17    4.09    $ 2,000    $ 2,200    $ 250    $ 2,450
        Oak Tree Living Average                                $ 2,450
    209    Rolling Meadows    3    No    8/1/20    0.75    $ ...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?