CH05 excel apartments capstone

HershY2002

Hackett_Exp19_Excel_Ch05_Cap_Apartments.xlsx

Home >Business & Finance homework help >Accounting homework help >CH05 excel apartments capstone

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