Buscar

Data Analyst Test

Faça como milhares de estudantes: teste grátis o Passei Direto

Esse e outros conteúdos desbloqueados

16 milhões de materiais de várias disciplinas

Impressão de materiais

Agora você pode testar o

Passei Direto grátis

Faça como milhares de estudantes: teste grátis o Passei Direto

Esse e outros conteúdos desbloqueados

16 milhões de materiais de várias disciplinas

Impressão de materiais

Agora você pode testar o

Passei Direto grátis

Faça como milhares de estudantes: teste grátis o Passei Direto

Esse e outros conteúdos desbloqueados

16 milhões de materiais de várias disciplinas

Impressão de materiais

Agora você pode testar o

Passei Direto grátis

Você viu 3, do total de 27 páginas

Faça como milhares de estudantes: teste grátis o Passei Direto

Esse e outros conteúdos desbloqueados

16 milhões de materiais de várias disciplinas

Impressão de materiais

Agora você pode testar o

Passei Direto grátis

Faça como milhares de estudantes: teste grátis o Passei Direto

Esse e outros conteúdos desbloqueados

16 milhões de materiais de várias disciplinas

Impressão de materiais

Agora você pode testar o

Passei Direto grátis

Faça como milhares de estudantes: teste grátis o Passei Direto

Esse e outros conteúdos desbloqueados

16 milhões de materiais de várias disciplinas

Impressão de materiais

Agora você pode testar o

Passei Direto grátis

Você viu 6, do total de 27 páginas

Faça como milhares de estudantes: teste grátis o Passei Direto

Esse e outros conteúdos desbloqueados

16 milhões de materiais de várias disciplinas

Impressão de materiais

Agora você pode testar o

Passei Direto grátis

Faça como milhares de estudantes: teste grátis o Passei Direto

Esse e outros conteúdos desbloqueados

16 milhões de materiais de várias disciplinas

Impressão de materiais

Agora você pode testar o

Passei Direto grátis

Faça como milhares de estudantes: teste grátis o Passei Direto

Esse e outros conteúdos desbloqueados

16 milhões de materiais de várias disciplinas

Impressão de materiais

Agora você pode testar o

Passei Direto grátis

Você viu 9, do total de 27 páginas

Faça como milhares de estudantes: teste grátis o Passei Direto

Esse e outros conteúdos desbloqueados

16 milhões de materiais de várias disciplinas

Impressão de materiais

Agora você pode testar o

Passei Direto grátis

Prévia do material em texto

SQL
	1
	The music research department has asked you to identify the 10 loudest songs (a negative level is louder).
	Use join to extract the requested data from tracks and features tables.
	tracks			features
	id	text	>	song_id	text
	name	text		loudness	int
	release_date	int
	song_id is a foreign key from the table tracks
	Complete de code filling the yellow spaces to return the output
	SELECT		features.loudness
	FROM 	tracks
		features
	ON	tracks.id = 
	ORDER BY	features.loudness, tracks.name
		;
	Expected Output
	name	loudness
	It Takes Time	-16
	A Day In The Life - Remastered 2009	-14
	Baby It's You - Remastered 2009	-12
	Bored	-12
	Michelle - Remastered 2009	-12
	Love Of My Life - Remastered 2011	-11
	When I'm Sixty-Four - Take 2	-11
	Your Mother Should Know - Remastered 2009	-11
	bad guy (with Justin Bieber)	-11
	Bring It On	-10
	2
	For each artist name, count the number of songs listed in the tracks table
	artists			tracks
	id	int	>	id	int
	followers	text		name	text
	name	text		artist_id	text
	popularity	int		release_date	text
	artist_id is a foreign key from the table artist
	Complete de code filling the yellow spaces to return the output
	SELECT	artist.name,		AS song_count
	FROM
	LEFT JOIN	artists
		tracks.artist_id=
		artists.name
	ORDER BY song_count			,artists.name
	Expected Output
	name	song_count
	Die drei ???	137
	Queen	33
	Daddy Yankee	19
	The Beatles	19
	BTS	16
	For Questions 3 and 4 consider the 'people' table below
	people
	id	name	age
	1	Michel	18
	2	Jose Lucas	28
	3	Jose Eduardo	26
	4	Francisco	35
	5	Bruno	27
	6	Daniel	31
	7	Diego	33
	3
	What is the correct query to return all columns and rows from the People table?
	Highlight in yellow the correct answer below:
	A. SELECT id FROM ALL People
	B. SELECT * FROM People
	C. SELECT all columns FROM People
	D. SELECT * FROM table People
	E. SELECT all rows FROM People
	4
	Which SQL command will select all name and age from people that contains Jose on its name?
	Highlight in yellow the correct answer below:
	A. SELECT * FROM people WHERE name = 'Jose'
	B. SELECT name, age FROM people WHERE name LIKE '%Jose%'
	C. SELECT name, age FROM people WHERE name in 'Jose'
	D. SELECT * FROM people WHERE name CONTAINS '%Jose%'
	E. none of the above.
	5
	Consider the delinquency table below.
	delinquency
	client_id	client	property	current_owed
	1	Ridley, LLC	House 1	85639.90
	2	Housing ABC	Alfred Mansion	15063.63
	1	Ridley, LLC	House 1	6547.85
	3	Kara Communities	El Dorado Building	0.00
	1	Ridley, LLC	House 2	9600.00
	1	Ridley, LLC	House 2	8523.13
	4	Real Estate Masters	Skyscraper 	0.00
	Which SQL statement will return the total current_owed amount for Ridley, LLC's properties?
	Highlight in yellow the correct answer below:
	A. SELECT client, property, SUM(current_owed) FROM delinquency WHERE client = 'Ridley, LLC' GROUP BY client, property
	B. SELECT current_owed FROM delinquency WHERE client = 'Ridley, LLC'
	C. SELECT SUM(*) FROM delinquency WHERE client = 'Ridley, LLC' GROUP BY *
	D. SELECT client,property, SUM(currrent_owed) FROM delinquency WHERE property = 'House1' AND 'House2' GROUP BY client,property
	E. None of the above.
	6
	Net Move Ins is a leasing KPI that calculates the the difference between move ins and move outs for a property. Consider the following table.
	resident_summary
	client_id	client	property	move_in	move_out
	1	Ridley, LLC	House 1	1.00	3.00
	1	Ridley, LLC	House 2	2.00	1.00
	1	Ridley, LLC	House 3	0.00	0.00
	1	Ridley, LLC	House 4	3.00	2.00
	1	Ridley, LLC	House 5	0.00	1.00
	Using SQL commands, the data analyst calculated the net_move_in value for all Ridley, LLC's properties.
	Highlight in yellow the correct answer below:
	A. SELECT client_id, client, property, move_in - move_out FROM resident_summary
	B. SELECT client_id, client, property, SUM(move_in - move_out) AS net_move_ins FROM resident_summary
	C. SELECT client_id, client, property, move_in - move_out AS net_move_ins FROM resident_summary
	D. SELECT client_id, client, property, net_move_ins FROM resident_summary
	E. None of the above.
	7
	A data analyst need to check june/2023's values for Income, Expenses and Net Operating Income for Riverside Manor, a property from the client named Real Estate Masters. To do so, he needs to compare the values from the dashboards Widgets to the it's source reports. Knowing the report's name, he can download it from the data storage. Given this, consider the following table schema.
	income_statement
	table_name	data_type
	id	integer
	client	varchar(50)
	property	varchar(50)		Expected Output
	report_name	varchar(100)
	income	decimal		income_statement
	expenses	decimal		client	property	report_name	report_month	report_year
	net_operating_income	decimal		Real Estate Masters	Riverside Manor	riv_manor_income_statement.xlsx	6	2023
	report_month	integer
	report_year	integer
	Which of the following SQL statement will return the desired result. Check the the output table to answer the question.
	Highlight in yellow the correct answer below:
	A. SELECT client, property, report_name, net_operating_income, report_month, report_year FROM income_statement WHERE client = 'Real Estate Masters' AND property = 'Riverside Manor' AND report_month = 6 AND report_year = 2023
	B. SELECT client, property, report_name, report_month, report_year FROM income_statement WHERE client = 'Real Estate Masters' AND property = 'Riverside Manor' AND report_month = 'june' AND report_year = 2023
	C. SELECT * FROM income_statement WHERE client = 'Real Estate Masters' AND property = 'Riverside Manor' AND report_month = 6 AND report_year = 2023
	D. SELECT client, property, report_name, report_month, report_year FROM income_statement WHERE client = 'Real Estate Masters' AND property = 'Riverside Manor' AND report_month = 6 AND report_year = 2023
	E. None of the above.
	8
	Consider the following table.
	rent_rolls
	id	client	property	market_rent	rent	as_of	report_name	imported_on
	1	Ridley, LLC	House 1	4500.00	4500.56	5/31/23	rent_roll_h1.xlsx	31/5/23 5:22
	2	Housing ABC	Alfred Mansion	2500.00	2500.00	5/31/23	rent_roll_AM.xlsx	31/5/23 5:22
	3	Kara Communities	El Dorado Building	1733.00	1733.00	5/31/23	rent_roll_ELB.xlsx	31/5/23 5:22
	4	Real Estate Masters	Riverside Manor	960.00	960.00	5/31/23	rent_roll_RM.xlsx	31/5/23 5:22
	Which option contains the correct data type for each field in the table above?
	Highlight in yellow the correct answer below:
	A. id - integer; client - varchar; property - varchar; market_rent - decimal; rent - decimal; as_of - date; report_name - varchar; imported_on - datetime.
	B. id - integer; client - varchar; property - varchar; market_rent - decimal; rent - decimal; as_of - datetime; report_name - varchar; imported_on - datetime.
	C. id - integer; client - varchar; property - varchar; market_rent - integer; rent - decimal; as_of - date; report_name - varchar; imported_on - datetime.
	D. id - integer; client - varchar; property - varchar; market_rent - decimal; rent - integer; as_of - date; report_name - varchar; imported_on - datetime.
	E. id - integer; client - varchar; property - varchar; market_rent - integer; rent - integer; as_of - date; report_name - varchar; imported_on - datetime.
Finances
	To answer the following questions, consider the Income Statement present in "Income Statement" tab.
	9	What is the Total Income for the month of June 2018?
	10	What is the Total Net Profit/Loss this report in 2018?
	11	How do you calculate the Net Operating Income for the month of Dec 2018? Show the math equation needed to calculate the result with the actual numbers
		Consider the following Balance Sheet:
					12	How much is the Total Cash?						15	Which of the following accounts is NOT considered an Equity account?
		Assets				(Highlight in yellow the correct answer below)							(Highlight in yellow the correct answer below)
		 Current Assets				A.	$31,607						A.	Member Equity
		 Operating Cash		$7,836		B.	$7,836						B.	Retained Earnings (Loss)
		 Cash Reserves		$23,771		C.	$23,771						C.	Net Income (Loss)Total Current Assets		$31,607		D.	$3,380,273						D.	Securiy Deposit Payable
		 Long Term Assets				E.	$3,356,502						E.	Distributions
		 Buildings		$2,169,279
		 Furnishings and Fixtures		$250,899	13	Which of the following accounts are considered Fixed Assets?						16	How much is the Return on Assets from this company?
		 Land		$928,488		(Highlight in yellow the correct answer below)							(Highlight in yellow the correct answer below)
		 Total Long Term Assets		$3,348,666		A.	Buildings and Land.						A.	-3.89
		Total Assets		$3,380,273		B.	Land, Funishing and Fixtures						B.	-3.93
						C. 	Buildings, Furnishing and Fixtures						C.	-415.85
		Liabilities and Equity				D.	Buildings, Furnishing and Fixtures, Land						D.	0
		 Due to Related Party		$3,852,900		E. 	Land.						E.	-15.19
		 Security Deposit Payable		$40,789
		 Member Equity		-$1,390,991	14	How much is the Current Ratio?						17	How much is the Return on Equity from this company?
		 Distributions		$63,236		(Highlight in yellow the correct answer below)							(Highlight in yellow the correct answer below)
		 Retained Earnings (Loss)		$1,972,609		A.	$0						A.	-3.38
		 Net Income (Loss)		-$131,438		B.	$0.81						B.	-3.89
		 Total Equity		-$513,416		C.	$12,319						C.	25.60
		Total Liabilities and Equity		$3,380,273		D	$1						D.	-415.85
						E.	-$0.81						E.	-3.93
Income Statement
	Income Statement
	123 Charlotte
	Accrual Basis
	Jan 2018 - Dec 2018
	Account	Account Name	1/2018	2/2018	3/2018	4/2018	5/2018	6/2018	7/2018	8/2018	9/2018	10/2018	11/2018	12/2018	Total
	Income
	Net Potential Rent
	4000	Gross Market Rent	495,963.00	495,963.00	495,963.00	495,963.00	495,963.00	495,963.00	492,244.50	498,951.00	495,963.00	495,963.00	495,963.00	495,963.00	5,950,825.50
	4001	Gain/Loss to Lease	(10,752.93)	(54,627.47)	(6,105.15)	(38,595.18)	(12,131.00)	(6,448.89)	(5,140.73)	(11,182.35)	(4,761.30)	(10,057.50)	(10,428.00)	(7,279.02)	(177,509.51)
		Net Potential Rent	485,210.07	441,335.53	489,857.85	457,367.82	483,832.00	489,514.11	487,103.77	487,768.65	491,201.70	485,905.50	485,535.00	488,683.98	5,773,315.99
	Adjustments to Potential
	4100	Vacancy	(43,173.00)	(39,123.00)	(43,866.00)	(92,644.00)	(91,507.00)	(95,734.00)	(89,496.00)	(87,369.00)	(90,694.00)	(87,778.00)	(82,922.00)	(84,877.00)	(929,183.00)
	4112	Employee Units	(6,146.00)	(4,289.00)	(4,289.00)	(4,289.00)	(4,289.00)	(4,289.00)	(4,289.00)	(2,436.00)	(2,436.00)	(2,436.00)	(2,436.00)	(3,729.00)	(45,353.00)
	4120	Concessions	(3,645.82)	(2,763.83)	(2,830.82)	(6,075.57)	(5,508.95)	(4,564.99)	(7,077.83)	(4,539.33)	(4,836.33)	(5,536.33)	(6,306.33)	(13,401.94)	(67,088.07)
	4121	Concessions-Gift Cards	13,550.00	8,150.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	21,700.00
	4130	Bad Debt	(16,399.58)	(9,865.14)	(10,710.13)	(10,579.32)	(5,161.27)	(5,765.22)	(5,296.00)	(5,469.37)	(6,890.46)	(7,380.86)	(7,936.38)	(12,124.65)	(103,578.38)
		Adjustments to Potential	(55,814.40)	(47,890.97)	(61,695.95)	(113,587.89)	(106,466.22)	(110,353.21)	(106,158.83)	(99,813.70)	(104,856.79)	(103,131.19)	(99,600.71)	(114,132.59)	(1,123,502.45)
		Net Rental Revenue	429,395.67	246,332.72	264,875.95	191,323.99	216,088.45	215,989.53	218,577.02	225,365.40	222,611.01	220,805.81	224,089.29	211,656.73	2,725,374.88
	Other Income
	4200	Accelerated Rent	0.00	3,007.85	3,262.15	0.00	5,885.00	0.00	245.64	2,631.99	0.00	0.00	3,107.24	0.00	18,139.87
	4205	Administrative Fees	2,650.00	700.00	600.00	1,900.00	1,600.00	340.00	7,800.00	400.00	700.00	700.00	900.00	15,025.00	33,315.00
	4210	Application Fees	1,435.00	(1,155.00)	1,050.00	1,225.00	1,505.00	1,820.00	(1,400.00)	1,785.00	1,575.00	1,715.00	1,610.00	(665.00)	10,500.00
	4215	Bad Debt Collections	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	195.00	0.00	0.00	195.00
	4211	Deferment Plan Fee	75.00	0.00	0.00	(75.00)	400.00	825.00	0.00	0.00	0.00	0.00	0.00	0.00	1,225.00
	4230	Key & Lockout Fees	(50.00)	50.48	0.00	50.00	175.00	50.00	50.00	1,465.00	185.00	150.00	775.00	2,489.56	5,390.04
	4235	Late Fee Income	10,920.00	(2,105.00)	5,315.00	2,485.00	5,445.00	2,255.00	1,964.00	3,855.00	3,000.00	1,825.00	2,860.00	2,305.00	40,124.00
	4250	Legal/Collection Fees	0.00	0.00	0.00	0.00	0.00	0.00	1,050.00	0.00	0.00	350.00	350.00	0.00	1,750.00
	4255	NSF Fee Income	400.00	400.00	120.00	320.00	240.00	120.00	160.00	80.00	240.00	320.00	80.00	320.00	2,800.00
	4260	Pet Fees	1,330.00	280.00	980.00	560.00	665.00	875.00	1,715.00	2,800.00	1,400.00	1,750.00	920.00	560.00	13,835.00
	4265	Resident Damage/Cleaning Fees	(1,106.25)	978.15	(85.00)	8,286.15	1,767.47	5,345.00	5,360.54	2,650.00	1,329.80	1,067.00	81,525.00	(10,091.96)	97,025.90
	4270	Sublease Fees	3,369.15	509.15	1,035.30	1,035.30	1,552.95	517.65	0.00	0.00	526.15	602.65	0.00	2,586.80	11,735.10
	4275	Transfer Fees	200.00	600.00	200.00	0.00	0.00	0.00	300.00	(200.00)	0.00	0.00	600.00	400.00	2,100.00
	4276	Electric Income	14,909.11	16,077.04	6,688.50	8,336.62	6,469.19	5,353.16	8,984.82	0.00	5,345.80	4,328.85	16,794.47	14,801.39	108,088.95
	4279	Pest Control	1,748.49	1,987.71	1,776.01	1,471.99	1,416.00	1,436.00	1,456.00	1,472.00	1,492.00	1,484.00	1,512.00	1,464.00	18,716.20
	4280	Vending Income	0.00	41.16	0.00	0.00	0.00	0.00	35.48	0.00	0.00	0.00	0.00	0.00	76.64
	4281	Utility Billing Income	2,998.49	172.78	2,226.01	2,513.99	1,932.00	1,936.00	5,510.00	1,622.00	1,942.00	1,788.00	2,109.43	8,672.00	33,422.70
	4285	Other Income	(50.00)	(200.00)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	(400.00)	0.00	0.00	(650.00)
	4310	Collection Agency Fees	0.00	(1,814.60)	(3,643.06)	(93.63)	(1,713.31)	0.00	(206.84)	(1,059.52)	0.00	(449.69)	(1,147.33)	0.00	(10,127.98)
	4335	Parking & Garage Rental Income	825.00	850.00	850.00	825.00	775.00	715.00	724.00	724.00	724.00	724.00	689.00	1,150.00	9,575.00
	4342	Barnacle Income	0.00	0.00	0.00	0.00	0.00	720.00	(510.00)	510.00	0.00	0.00	175.00	200.00	1,095.00
	4350	Renters Insurance Income	469.60	498.00	607.50	490.50	438.00	471.00	112.50	519.00	538.50	475.50	531.00	381.00	5,532.10
	4355	Resident Fines	618.75	284.21	1,991.63	2,700.00	2,694.93	529.17	591.22	1,233.32	466.67	96.25	22,437.99	66.00	33,710.14
	4365	Short Term Lease Premium	390.00	390.00	390.00	715.00	520.00	115.00	180.00	180.00	180.00	0.00	0.00	715.00	3,775.00
	4399	Bad Debt - Other	(14,181.86)	(4,741.09)	(2,596.78)	(5,213.53)	(2,573.59)	(2,187.47)	(2,852.20)	0.00	(446.72)	0.00	0.00	(1,258.88)	(36,052.12)
		Other Income	26,950.48	16,810.84	20,767.26	27,532.39	29,193.64	21,235.51	31,270.16	20,667.79	19,198.20	16,721.56	135,828.80	39,119.91	405,296.54
		Income	456,346.15	263,143.56	285,643.21	218,856.38	245,282.09	237,225.04	249,847.18	246,033.19	241,809.21	237,527.37	359,918.09	250,776.64	3,130,671.42
	Operating Expenses
	General & Administrative
	5001	Call Center - Resident	452.76	452.76	452.76	452.76	452.76	452.76	452.76	322.05	452.76	452.76	452.76	452.76	5,302.41
	5002	Cell Phones	60.16	60.16	60.16	60.16	55.16	55.16	55.16	55.16	55.16	55.16	55.16	55.16	681.92
	5003	Clubhouse	860.94	607.75	531.46	584.46	181.14	154.89	154.89	308.82	154.89	154.89	154.89	541.15	4,390.17
	5006	Dues & Subscriptions	0.00	0.00	0.00	64.62	64.62	64.62	64.62	311.20	97.54	165.74	165.74	203.69	1,202.39
	5007	EE Background Checks	0.00	161.96	0.00	0.00	0.00	0.00	176.95	0.00	0.00	89.98	0.00	0.00	428.89
	5008	EE Recruiting Expense	0.00	0.00	357.10	0.00	0.00	0.00	20.00	0.00	0.00	0.00	0.00	20.00	397.10
	5009	Employee Relations	133.25	47.43	21.10	326.64	105.10	249.12	85.57	0.00	0.00	132.78	119.74	527.39	1,748.12
	5035	Pandemic Expenses	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	581.17	381.08	166.32	1,128.57
	5029	Entrata-Core	519.75	519.75	519.75	519.75	519.75	519.75	519.75	369.70	719.75	569.25	569.25	569.25	6,435.45
	5030	AP Processing	106.65	98.44	32.88	61.86	40.20	45.21	86.37	43.78	32.99	38.81	43.34	43.00	673.53
	5033	Late Fees	0.00	35.40	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	35.40
	5023	Entrata-Resident Verify	313.75	158.75	220.00	301.25	253.75	450.00	1,178.75838.44	492.50	627.50	1,035.00	833.75	6,703.44
	5011	Eviction Fees	0.00	0.00	276.69	0.00	700.00	0.00	1,148.87	814.10	0.00	0.00	626.69	0.00	3,566.35
	5012	Legal Fees	0.00	0.00	0.00	11.00	0.00	318.34	0.00	0.00	0.00	0.00	0.00	266.29	595.63
	5013	Licenses & Permits	0.00	0.00	0.00	0.00	725.27	725.27	725.27	725.27	725.27	975.27	725.27	725.27	6,052.16
	5016	Office Equipment Expense	195.22	195.22	0.00	0.00	0.00	0.00	146.85	0.00	359.18	0.00	0.00	0.00	896.47
	5017	Office Supplies	91.21	427.05	173.49	111.05	46.76	233.35	204.40	50.19	0.00	57.23	690.56	246.66	2,331.95
	5018	Other Computer & Software Expense	28.16	0.00	251.43	539.64	(55.75)	0.00	179.88	851.28	168.96	112.64	191.88	0.00	2,268.12
	5019	Parking Permits	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	260.72	0.00	262.28	523.00
	5020	Postage - General	606.14	324.00	228.48	45.70	83.05	32.49	134.10	27.37	35.35	31.93	38.51	58.20	1,645.32
	5021	Printing/Copying	0.00	0.00	199.40	120.92	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	320.32
	5022	Resident Payment Processing Fees	825.23	650.13	540.58	475.23	492.99	524.33	547.73	1,236.51	1,602.56	616.55	552.68	478.36	8,542.88
	5024	Telephone Service	135.06	135.40	136.74	138.14	135.24	134.24	137.40	145.46	192.48	202.48	192.48	148.56	1,833.68
	5025	Training & Seminars	67.65	67.65	250.65	67.55	67.65	67.65	67.65	142.65	56.10	56.10	56.10	56.10	1,023.50
	5027	Uniforms	0.00	17.95	0.00	0.00	82.95	30.95	0.00	0.00	0.00	0.00	30.95	0.00	162.80
		General & Administrative	4,395.93	3,959.80	4,252.67	3,880.73	3,950.64	4,058.13	6,086.97	6,241.98	5,145.49	5,180.96	6,082.08	5,654.19	58,889.57
	Management Fee
	5200	Property Management Fee	12,063.46	10,602.35	7,594.57	9,063.50	9,916.89	9,041.87	8,286.39	7,133.43	7,749.94	8,617.80	9,427.71	(69,061.21)	30,436.70
		Management Fee	12,063.46	10,602.35	7,594.57	9,063.50	9,916.89	9,041.87	8,286.39	7,133.43	7,749.94	8,617.80	9,427.71	(69,061.21)	30,436.70
	Advertising
	5300	Brochures/Flyers	9.88	1,940.18	48.40	100.80	90.75	122.94	0.00	17.93	0.00	1.00	0.00	138.50	2,470.38
	5301	Call Center - Leasing	113.19	113.19	113.19	113.19	113.19	113.19	113.19	80.51	113.19	113.19	113.19	113.19	1,325.60
	5302	Communication/Text Messaging Service	368.00	174.00	294.36	394.80	323.70	215.64	562.00	368.00	368.00	283.74	273.84	273.00	3,899.08
	5303	Giveaways and Prizes	25.00	0.00	105.44	0.00	54.95	105.95	336.51	156.75	0.00	0.00	0.00	0.00	784.60
	5305	Leasing Promotional Activities	50.00	168.45	40.00	0.00	494.54	1,355.95	1,250.00	0.00	1,812.50	0.00	3,625.00	812.50	9,608.94
	5307	Mass Mailer	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	1,833.27	0.00	0.00	1,833.27
	5309	Model Decor	0.00	0.00	84.90	249.27	28.60	8.80	390.66	0.00	0.00	0.00	0.00	0.00	762.23
	5310	Online Advertising	2,630.27	2,140.51	1,933.00	2,843.62	1,560.14	1,904.75	2,069.00	3,588.58	2,871.44	2,576.80	2,746.84	3,943.49	30,808.44
	5315	Resident Promotional Activities	1,119.60	847.17	496.17	762.42	85.79	563.90	311.52	100.62	0.00	0.00	0.00	0.00	4,287.19
	5316	Resident Referrals	1,100.00	0.00	400.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	1,500.00
	5317	Signs/Banners/Billboards	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	217.66	143.64	0.00	471.00	832.30
	5318	Sponsorships	0.00	0.00	0.00	0.00	500.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	500.00
	5320	Website Costs	37.00	7.00	7.00	14.00	14.00	14.00	14.00	0.00	7.00	7.00	7.00	1,010.94	1,138.94
	5323	Leasing Incentives	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	307.85	0.00	0.00	307.85
	5325	Resident Retention	0.00	149.36	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	149.36
		Advertising	5,452.94	5,539.86	3,522.46	4,478.10	3,265.66	4,405.12	5,046.88	4,312.39	5,389.79	5,266.49	6,765.87	6,762.62	60,208.18
	Repairs & Maintenance
	5400	R&M Appliance	124.63	0.00	0.00	0.00	327.93	57.21	0.00	0.00	0.00	0.00	130.46	615.33	1,255.56
	5401	R&M Blinds	0.00	0.00	(531.17)	0.00	498.09	0.00	567.22	0.00	0.00	0.00	348.81	373.57	1,256.52
	5403	R&M Carpet/Vinyl/Tile	4,600.00	(281.21)	0.00	2,139.36	942.02	(942.02)	570.99	0.00	0.00	32.97	0.00	0.00	7,062.11
	5404	R&M Common Areas	0.00	16.49	53.99	0.00	0.00	0.00	0.00	0.00	214.92	0.00	0.00	0.00	285.40
	5405	R&M Doors & Windows	18.37	0.00	0.00	0.00	0.00	0.00	0.00	0.00	179.70	0.00	0.00	0.00	198.07
	5406	R&M Electrical	0.00	3.83	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	2,127.99	0.00	2,131.82
	5410	R&M Exterior Building - Painting	29.25	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	389.16	0.00	418.41
	5411	R&M Fencing & Gates	197.95	94.97	1,085.95	150.00	95.90	225.00	47.95	0.00	600.00	0.00	0.00	0.00	2,497.72
	5412	R&M Fire & Safety	621.45	170.00	0.00	0.00	1,485.00	340.00	190.00	0.00	0.00	0.00	1,920.00	0.00	4,726.45
	5414	R&M HVAC	464.95	904.83	39.60	0.00	1,557.03	0.00	0.00	0.00	741.72	0.00	3,293.07	849.76	7,850.96
	5415	R&M Keys & Locks	767.55	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	497.42	0.00	1,264.97
	5416	R&M Landscape	0.00	185.00	0.00	0.00	0.00	0.00	450.00	0.00	0.00	0.00	0.00	27.48	662.48
	5417	R&M Lighting & Fixtures	2,554.03	4,061.59	105.59	1,210.95	(266.14)	251.40	359.50	0.00	0.00	0.00	2,408.57	44.92	10,730.41
	5418	R&M Other	10.91	0.00	0.00	0.00	1,873.40	0.00	(125.26)	0.00	(35.36)	0.00	10.80	38.00	1,772.49
	5419	R&M Parking Lots & Sidewalks	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	87.14	0.00	87.14
	5420	R&M Plumbing	11.15	265.63	26.90	0.00	620.00	203.45	0.00	0.00	0.00	0.00	1,392.40	114.62	2,634.15
	5421	R&M Pool	(266.14)	128.88	262.87	0.00	0.00	592.34	0.00	335.77	0.00	0.00	221.08	299.76	1,574.56
	5423	R&M Supplies	248.85	4.49	118.23	107.99	111.93	690.72	311.06	296.96	741.01	(545.60)	457.12	121.62	2,664.38
	5425	R&M Vehicle/Golf Cart	1,014.60	0.00	0.00	0.00	0.00	(1,014.60)	176.00	0.00	0.00	0.00	0.00	0.00	176.00
	5431	R&M Pest Control	536.43	0.00	13.18	134.90	99.00	39.23	0.00	0.00	48.55	0.00	0.00	0.00	871.29
		Repairs & Maintenance	10,933.98	5,554.50	1,175.14	3,743.20	7,344.16	442.73	2,547.46	632.73	2,490.54	(512.63)	13,284.02	2,485.06	50,120.89
	Turnover
	5500	Cleaning	(1,517.13)	6,987.00	1,155.00	0.00	0.00	0.00	840.00	335.94	0.00	0.00	0.00	0.00	7,800.81
	5510	Flooring - Cleaning & Repair	2,889.47	1,211.66	0.00	0.00	0.00	120.00	505.00	0.00	0.00	502.40	32.97	254.89	5,516.39
	5520	General Contract Labor Turnover	4,083.57	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	4,083.57
	5530	Interior Repairs	0.00	0.00	0.00	2,275.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	2,275.00
	5540	Painting	(310.00)	720.04	0.00	0.00	0.00	42.74	0.00	0.00	0.00	0.00	449.49	0.00	902.27
	5560	Waste Disposal	3,767.29	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	84.96	0.00	3,852.25
	5550	Supplies	0.00	348.16	0.00	0.00	0.00	2,909.34	0.00	0.00	0.00	0.00	1,175.32	85.87	4,518.69
		Turnover	8,913.20	9,266.86	1,155.00	2,275.00	0.00	3,072.08	1,345.00	335.94	0.00	502.40	1,742.74	340.76	28,948.98
	Contract Services
	5610	Cleaning Contract Services	400.00	400.00	400.00	400.00	200.00	(100.00)	290.00	0.00	0.00	0.00	0.00	0.00	1,990.00
	5625	Exterminating Contract Services	431.67	431.67	431.67	431.66	406.67	423.33	330.00	516.67	258.33	423.33	423.33	423.33	4,931.66
	5630	Fire & Safety Monitoring/Inspection Contract	2,447.22	(2,152.78)	407.22	407.22	407.22	407.22	407.22	247.22	247.22	309.72	572.22	47.22	3,754.14
	5635	Fitness Equipment Contract Services	0.00	0.00	250.00	0.00	0.00	250.00	0.00	0.00	0.00	0.00	0.00	0.00	500.00
	5640	General Labor Contract Services	0.00	0.00	0.00	0.00	0.00	0.00	232.00	58.00	0.00	0.00	0.00	0.00	290.00
	5650	Landscaping Contract Services	1,975.00	1,975.00	1,975.00	1,475.00	(500.00)	1,450.00	1,450.00	2,950.00	1,475.00	1,475.00	1,475.00	1,475.00	18,650.00
	5665	Security Officer Services	2,745.00	2,790.00	2,790.00	2,018.05	1,396.75	1,986.24	1,977.36	1,936.80	2,157.36	1,977.36	2,132.64	2,067.36	25,974.92
	5670	Security System Contract Services	360.00	360.00	360.00	360.00	360.00	360.00	360.00	360.00	360.00	360.00	360.00	360.00	4,320.00
	5685	Trash Contract Services	890.82	1,395.76	1,654.71	1,477.90	1,477.03	1,462.86	1,443.37	1,104.50	944.55	947.35	1,461.45	2,803.60	17,063.90
		Contract Services	9,249.71	5,199.65	8,268.60	6,569.83	3,747.67	6,239.65	6,489.95	7,173.19	5,442.46	5,492.76	6,424.647,176.51	77,474.62
	Payroll
	5700	Office Salaries	7,517.00	6,495.28	5,248.78	4,267.88	5,369.53	3,681.52	2,517.04	8,318.40	10,143.94	7,787.72	7,800.76	7,797.00	76,944.85
	5705	Office - OT	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	699.96	699.96
	5710	Leasing Salaries	1,662.23	2,398.45	2,352.00	2,455.52	2,507.20	2,239.72	1,273.44	2,156.17	2,853.03	2,149.98	2,295.72	2,240.00	26,583.46
	5715	Leasing - OT	0.00	336.39	63.42	121.80	36.33	30.24	65.73	64.05	24.31	171.15	198.03	1,766.52	2,877.97
	5740	Leasing Commissions	0.00	0.00	0.00	1,440.00	1,350.00	1,350.00	1,350.00	2,165.00	1,580.00	1,700.00	1,350.00	2,210.00	14,495.00
	5720	Maintenance Salaries	7,017.66	6,512.94	6,016.89	6,112.24	6,515.77	5,816.33	3,977.98	7,019.33	7,495.20	6,282.00	6,822.00	7,147.00	76,735.34
	5725	Maintenance - OT	48.83	189.27	118.20	31.00	16.23	71.85	117.74	363.85	72.55	266.51	108.23	1,618.26	3,022.52
	5748	Staff Augmentation	4,390.01	4,390.01	4,390.01	4,390.01	2,345.95	1,871.80	2,041.44	2,041.44	2,041.44	2,041.44	2,041.44	2,041.44	34,026.43
	5749	Staff Redeployment	3,521.01	2,664.86	2,984.74	1,326.55	3,426.25	3,045.56	3,426.25	3,426.25	2,664.86	1,903.47	2,284.17	2,855.21	33,529.18
	5750	Property Bonuses	0.00	1,800.00	0.00	0.00	2,308.33	4,583.33	2,083.33	2,083.33	2,083.33	3,733.33	2,083.33	2,083.33	22,841.64
	5760	Payroll Taxes	1,356.89	1,395.12	1,141.36	1,265.04	1,877.02	1,198.78	772.95	1,668.73	1,724.33	1,900.45	1,742.31	1,990.43	18,033.41
	5770	Workers Comp Insurance	415.36	454.60	353.38	365.14	371.89	301.57	209.35	432.86	469.30	0.00	705.34	352.67	4,431.46
	5780	Payroll Benefits	1,454.85	1,357.48	1,049.50	1,079.50	1,049.50	1,049.50	1,109.50	1,456.34	1,212.34	(608.14)	3,719.56	1,552.14	15,482.07
	5795	AB Service Fees	446.67	469.29	376.10	388.71	401.57	463.69	216.24	500.62	558.76	0.00	0.00	0.00	3,821.65
	5785	401K Contribution	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	858.07	(63.46)	63.46	858.07
		Payroll	27,830.51	28,463.69	24,094.38	23,243.39	27,575.57	25,703.89	19,160.99	31,696.37	32,923.39	28,185.98	31,087.43	34,417.42	334,383.01
	Utility
	5800	Electric Common Area	4,138.21	3,728.16	3,037.13	3,345.85	3,304.88	3,336.06	3,172.27	1,974.71	2,989.04	2,715.54	3,620.77	3,681.56	39,044.18
	5801	Electric Resident Units	29,998.09	29,716.36	20,143.99	20,552.66	17,012.17	21,183.78	19,078.82	14,868.05	17,245.80	21,338.49	22,247.75	21,513.76	254,899.72
	5802	Electric Vacant Units	480.79	484.85	506.36	1,147.49	1,020.91	703.41	1,695.92	440.60	505.57	3,299.70	3,553.50	4,163.23	18,002.33
	5820	Gas Common Area	0.00	0.00	673.24	6.95	219.47	0.00	0.00	0.00	0.00	0.00	414.43	0.00	1,314.09
	5843	Water & Sewer	8,369.85	8,543.68	8,570.94	8,742.51	7,819.78	8,994.98	7,809.33	5,512.29	5,371.90	10,810.56	12,318.72	8,235.10	101,099.64
	5860	Cable	5,218.44	5,218.43	5,218.43	5,208.65	5,214.36	5,464.48	5,464.37	5,672.33	5,256.41	5,464.37	5,464.96	5,463.38	64,328.61
	5870	Internet	4,637.71	4,637.71	4,637.71	4,643.21	4,643.21	4,870.60	4,889.16	5,003.12	4,755.20	4,909.16	4,888.96	4,889.16	57,404.91
		Utility	52,843.09	52,329.19	42,787.80	43,647.32	39,234.78	44,553.31	42,109.87	33,471.10	36,123.92	48,537.82	52,509.09	47,946.19	536,093.48
	Taxes and Insurance
	6000	Real Estate Taxes	25,693.60	(15,978.93)	22,463.55	23,212.33	23,212.33	21,714.77	23,212.33	23,032.33	23,212.33	23,392.33	23,212.33	23,212.33	239,591.63
	6100	Personal Property Taxes	539.25	(425.46)	464.61	599.90	480.10	449.12	480.10	480.10	480.10	480.10	480.10	480.10	4,988.12
	6300	State Privilege Taxes	0.00	0.00	0.00	0.00	0.00	0.00	120.00	0.00	0.00	0.00	0.00	0.00	120.00
	6500	Property Insurance	5,658.10	5,846.69	5,658.10	5,846.70	5,846.69	5,469.50	5,833.92	5,713.81	6,802.51	6,111.48	6,111.48	6,111.48	71,010.46
	6600	Other Insurance	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	39.00	39.00
		Taxes and Insurance	31,890.95	(10,557.70)	28,586.26	29,658.93	29,539.12	27,633.39	29,646.35	29,226.24	30,494.94	29,983.91	29,803.91	29,842.91	315,749.21
		Operating Expenses	163,573.77	110,358.20	121,436.88	126,560.00	124,574.49	125,150.17	120,719.86	120,223.37	125,760.47	131,255.49	157,127.49	65,564.45	1,492,304.64
		Net Operating Income	131,035.69	152,785.36	164,206.33	92,296.38	120,707.60	112,074.87	129,127.32	125,809.82	116,048.74	106,271.88	202,790.60	185,212.19	1,638,366.78
	Ordinary Capital Expenditures
	9000	Cap Ex - Apartment Furnishings	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	1,161.00	0.00	0.00	10,449.00	11,610.00
	9005	Cap Ex - Appliances	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	970.82	970.82
	9010	Cap Ex - Carpet	0.00	0.00	0.00	0.00	0.00	942.02	428.58	0.00	0.00	1,852.92	0.00	0.00	3,223.52
	9020	Cap Ex - Clubhouse	0.00	0.00	0.00	0.00	0.00	0.00	2,080.00	439.79	0.00	0.00	0.00	0.00	2,519.79
	9025	Cap Ex - Flooring	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	1,204.78	0.00	1,204.78
	9065	Cap Ex - Pool & Pool Furniture	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	52.24	234.70	0.00	0.00	286.94
	9080	Cap Ex - Signs	0.00	0.00	0.00	0.00	0.00	843.90	0.00	0.00	0.00	0.00	0.00	0.00	843.90
	Cap Ex - Mechanical Systems
	9031	Cap Ex - HVAC	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	589.34	0.00	589.34
	9091	Cap Ex - Water Heaters	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	418.00	0.00	0.00	0.00	418.00
		Cap Ex - Mechanical Systems	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	418.00	0.00	589.34	0.00	1,007.34
		Ordinary Capital Expenditures	0.00	0.00	0.00	0.00	0.00	1,785.92	2,508.58	439.79	1,631.24	2,087.62	1,794.12	11,419.82	21,667.09
	Financial Income
	4400	Interest Income	(2.62)	(1.23)	(1.17)	(528.16)	(1.53)	(1.46)	(1.08)	(0.76)	(0.53)	(12.43)	(0.64)	(0.65)	(552.26)
		Financial Income	(2.62)	(1.23)	(1.17)	(528.16)	(1.53)	(1.46)	(1.08)	(0.76)	(0.53)	(12.43)	(0.64)	(0.65)	(552.26)
		Net Profit/Loss Before Debt Service	131,038.31	152,786.59	164,207.50	92,824.54	120,709.13	110,290.41	126,619.82	125,370.79	114,418.03	104,196.69	200,997.12	173,793.02	1,617,251.95
	Debt Service
	7000	Interest Expense	67,770.50	69,934.35	67,594.54	69,751.84	69,664.47	65,087.93	69,471.03	67,144.41	69,284.92	0.00	66,963.60	69,097.37	751,764.96
		Debt Service	67,770.50	69,934.35	67,594.54	69,751.84	69,664.47	65,087.93	69,471.03	67,144.41	69,284.92	0.00	66,963.60	69,097.37	751,764.96
		Net Profit/Loss After Debt Service	63,267.81	82,852.24	96,612.96	23,072.70	51,044.66	45,202.48	57,148.79	58,226.38	45,133.11	104,196.69	134,033.52	104,695.65	865,486.99
	Other Non-Operating Expenses
	7900	Casualty Loss	0.00	0.00	12,023.40	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	12,023.40
		Other Non-Operating Expenses	0.00	0.00	12,023.40	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	12,023.40
	Ownership Expenses
	8000	Asset Management Fee	5,170.05	4,543.87	3,254.82	3,884.36	4,250.10	3,875.09	3,551.31	3,057.18	3,321.40	3,693.35	4,040.45	(32,919.09)	9,722.89
	8010	Asset Mgmt - Transportation & Hotels	2,660.77	506.13	55.56	0.00	0.00	0.00	2,760.46	0.00	0.00	0.00	0.00	0.00	5,982.92
	8015	Asset Mgmt - Meals & Entertainment	214.46	42.70	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	257.16
	8100	Accounting Fees	0.00	0.00	0.00	0.00	2,044.06	1,677.83	15,999.60	1,982.19	1,982.19	1,982.19	1,982.19	1,982.19	29,632.44
	8110	Filing and Legal Fees	4,926.50	15,502.50	4,245.52	19,177.50	(500.00)	255.10	3,953.67	1,674.00	1,900.00	950.00	725.00	3,250.00	56,059.79
	8120	Professional Consulting Fees	214.28	214.28	10,039.00	214.28	214.28	187.50	187.50	187.50	375.00	187.50	187.50	187.50	12,396.12
		Ownership Expenses	13,186.06	20,809.48	17,594.90	23,276.14	6,008.44	5,995.52	26,452.54	6,900.87	7,578.59	6,813.04	6,935.14	(27,499.40)	114,051.32
		Net Profit/Loss After Ownership Expenses	50,081.75	62,042.76	66,994.66	(203.44)	45,036.22	39,206.96	30,696.25	51,325.51	37,554.52	97,383.65	127,098.38	132,195.05	739,412.27
	Depreciation & Amortization
	8500	Depreciation Expense	92,373.01	92,400.29	92,474.29	92,588.12	92,502.74	91,965.42	92,164.13	92,768.21	92,466.17	92,466.17	92,466.17	92,466.17	1,109,100.89
	8600	Amortization Expense	2,934.90	2,934.90	2,934.90	2,934.90	2,934.90	2,934.93	2,934.90	2,934.90	2,934.90	2,934.90	2,934.90	2,934.90	35,218.83
		Depreciation& Amortization	95,307.91	95,335.19	95,409.19	95,523.02	95,437.64	94,900.35	95,099.03	95,703.11	95,401.07	95,401.07	95,401.07	95,401.07	1,144,319.72
		Net Profit/Loss	(45,226.16)	(33,292.43)	(28,414.53)	(95,726.46)	(50,401.42)	(55,693.39)	(64,402.78)	(44,377.60)	(57,846.55)	1,982.58	31,697.31	36,793.98	(404,907.45)
	Additional Capital Expenditures
	9300	Cap Ex - Renov. - Construction Mngt Fee	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	114.19	146.13	845.95	(306.88)	799.39
	9266	Cap Ex - Renov. - Pool Furniture	0.00	0.00	0.00	0.00	0.00	0.00	0.00	1,256.57	0.00	0.00	0.00	0.00	1,256.57
	9269	Cap Ex - Renov. - Security Gates & Cameras	0.00	0.00	0.00	0.00	2,800.00	0.00	1,500.00	0.00	0.00	0.00	0.00	0.00	4,300.00
		Additional Capital Expenditures	0.00	0.00	0.00	0.00	2,800.00	0.00	1,500.00	1,256.57	114.19	146.13	845.95	(306.88)	6,355.96
		Net Profit/Loss After Additional Cap Ex	(45,226.16)	(33,292.43)	(28,414.53)	(95,726.46)	(53,201.42)	(55,693.39)	(65,902.78)	(45,634.17)	(57,960.74)	1,836.45	30,851.36	37,100.86	(411,263.41)