please answe all parts of question 1 Table 1 Adress city state postal code listing type listing size unit id Listing Price (Hypothetical) Selling Price (Hypothetical) Purchase Price (Hypothetical) 1134 N Rolling Rd Catonsville MD 21228 Lease 4850 222596 $ 110,000 00 $ 106,000 00 $ 95,400 00 8255 Patuxent Range Rd Jessup MD 20794 Lease 7885 221212 $ 121,000 00 $ 116,600 00 $ 104,940 00 307 International Cir Cockeysville MD 21030 Lease 1320 216190 $ 147,800 00 $ 150,000 00 $ 135,000 00 1120 Whistler Ave Baltimore MD 21223 Sale 38000 224760 $ 165,000 00 $ 156,750 00 $ 141,075 00 6958 Aviation Blvd Glen Burnie MD 21061 Lease 10710 217619 $ 165,900 00 $ 159,264 00 $ 143,337 60 307 Washington Ave Towson MD 21204 Lease 6060 229911 $ 180,000 00 $ 175,000 00 $ 157,500 00 800 International Dr Linthicum Heights MD 21090 Lease 22607 221203 $ 181,500 00 $ 172,425 00 $ 155,182 50 201 International Cir Cockeysville MD 21030 Lease 2150 216492 $ 185,500 00 $ 179,000 00 $ 161,100 00 6031 University Blvd Ellicott City MD 21043 Sublease 2800 230257 $ 189,900 00 $ 186,102 00 $ 167,491 80 3301 Childs St Baltimore MD 21226 Lease 2835 221191 $ 215,000 00 $ 195,000 00 $ 175,500 00 104 E Pennsylvania Ave Towson MD 21286 Lease 1220 218153 $ 215,800 00 $ 200,000 00 $ 180,000 00 1106 Business Pkwy S Westminster MD 21157 Lease 15530 217523 $ 219,000 00 $ 215,000 00 $ 193,500 00 72 Loveton Cir Sparks Glencoe MD 21152 Lease 18330 232810 $ 237,380 00 $ 220,000 00 $ 198,000 00 7801 Dorsey Run Rd Jessup MD 20794 Lease 156140 224286 $ 240,900 00 $ 236,500 00 $ 212,850 00 7021 Columbia Gateway Dr Columbia MD 21046 Lease 3890 229576 $ 245,900 00 $ 233,605 00 $ 210,244 50 1419 Forest Dr Annapolis MD 21403 Sale 19100 236310 $ 250,000 00 $ 232,000 00 $ 208,800 00 20 Pleasant Ridge Dr Owings Mills MD 21117 Lease 1877 221213 $ 250,000 00 $ 255,000 00 $ 229,500 00 620 Frederick Rd Catonsville MD 21228 Lease 2900 237052 $ 250,000 00 $ 275,000 00 $ 247,500 00 6250 Old Dobbin Ln Columbia MD 21045 Lease 6160 217151 $ 254,500 00 $ 236,685 00 $ 213,016 50 4660 Wilkens Ave Baltimore MD 21229 Lease 1081 224311 $ 259,900 00 $ 246,905 00 $ 222,214 50 6200 Guardian Gateway Aberdeen Proving Ground MD 21005 Sublease 18090 216575 $ 275,000 00 $ 264,000 00 $ 237,600 00 930 International Dr Linthicum Heights MD 21090 Lease 33537 221205 $ 275,000 00 $ 255,200 00 $ 229,680 00 6901 Security Blvd Woodlawn MD 21244 Lease 9180 230869 $ 275,900 00 $ 250,000 00 $ 225,000 00 1300 Thames St Baltimore MD 21231 Lease 23470 217190 $ 285,750 00 $ 300,000 00 $ 270,000 00 6 Fleet St Annapolis MD 21401 Lease 1580 217368 $ 285,750 00 $ 300,000 00 $ 270,000 00 405 E Joppa Rd Towson MD 21286 Lease 2130 217455 $ 289,900 00 $ 279,000 00 $ 251,100 00 7000 Security Blvd Woodlawn MD 21244 Lease 4056 224894 $ 299,999 00 $ 280,000 00 $ 252,000 00 10629 York Rd Cockeysville MD 21030 Lease 1900 219034 $ 300,000 00 $ 290,000 00 $ 261,000 00 1200 E Joppa Rd Towson MD 21286 Lease 890 219130 $ 300,000 00 $ 300,000 00 $ 270,000 00 6300 Blair Hill Ln Baltimore MD 21209 Lease 22410 230694 $ 300,000 00 $ 250,000 00 $ 225,000 00 180 W Ostend St Baltimore MD 21230 Lease 5000 216826 $ 310,000 00 $ 300,000 00 $ 270,000 00 31 Light St Baltimore MD 21202 Lease 5830 222441 $ 310,000 00 $ 291,400 00 $ 262,260 00 1135 Business Pkwy S Westminster MD 21157 Lease 19900 222547 $ 314,250 00 $ 304,000 00 $ 273,600 00 9160 Guilford Rd Columbia MD 21046 Lease 18520 230744 $ 314,325 00 $ 330,000 00 $ 297,000 00 3444 Ellicott Center Dr Ellicott City MD 21043 Lease 1980 235377 $ 315,250 00 $ 300,000 00 $ 270,000 00 40 York Rd Towson MD 21204 Lease 2920 230995 $ 316,000 00 $ 316,000 00 $ 284,400 00 1129 Business Pkwy S Westminster MD 21157 Lease 18700 222546 $ 325,000 00 $ 320,000 00 $ 288,000 00 1215 E Fort Ave Baltimore MD 21230 Lease 8000 230034 $ 325,000 00 $ 308,750 00 $ 277,875 00 1232 Race Rd Rosedale MD 21237 Sale 2680 224683 $ 325,000 00 $ 302,250 00 $ 272,025 00 125 Airport Dr Westminster MD 21157 Lease 16325 222542 $ 325,000 00 $ 320,000 00 $ 288,000 00 3051 Washington Blvd Baltimore MD 21230 Lease 25920 221223 $ 325,000 00 $ 325,000 00 $ 292,500 00 7235 Standard Dr Hanover MD 21076 Sublease 15970 217294 $ 330,000 00 $ 319,000 00 $ 287,100 00 8620 Guilford Rd Columbia MD 21046 Lease 660 237002 $ 330,000 00 $ 330,000 00 $ 297,000 00 6085 Marshalee Dr Elkridge MD 21075 Lease 13610 216285 $ 335,000 00 $ 330,000 00 $ 297,000 00 7008 Security Blvd Woodlawn MD 21244 Lease 1272 224899 $ 339,999 00 $ 310,000 00 $ 279,000 00 120 Cockeysville Rd Cockeysville MD 21030 Lease 2240 218024 $ 345,000 00 $ 339,999 00 $ 305,999 10 315 N Charles St Baltimore MD 21201 Sale 8206 222493 $ 345,000 00 $ 335,000 00 $ 301,500 00 4408 Washington Blvd Halethorpe MD 21227 Sale 7000 221224 $ 345,000 00 $ 330,000 00 $ 297,000 00 6240 Old Dobbin Ln Columbia MD 21045 Lease 15540 217030 $ 345,670 00 $ 345,000 00 $ 310,500 00 8298 Brock Bridge Rd Laurel MD 20724 Sale 37840 224003 $ 345,675 00 $ 334,400 00 $ 300,960 00 10000 Franklin Square Dr Nottingham MD 21236 Lease 392500 221196 $ 350,000 00 $ 340,000 00 $ 306,000 00 817 Maiden Choice Ln Catonsville MD 21228 Lease 1550 224301 $ 357,500 00 $ 352,000 00 $ 316,800 00 90 Aileron Ct Westminster MD 21157 Lease 1700 234896 $ 357,500 00 $ 339,625 00 $ 305,662 50 910 Ridgebrook Rd Sparks Glencoe MD 21152 Lease 56320 217490 $ 357,500 00 $ 332,475 00 $ 299,227 50 911 N Charles St Baltimore MD 21201 Lease 1650 222505 $ 357,500 00 $ 352,000 00 $ 316,800 00 300 W Fayette St Baltimore MD 21201 Sale 108225 222510 $ 365,750 00 $ 355,000 00 $ 319,500 00 300 E Joppa Rd Baltimore MD 21286 Lease 87280 230249 $ 375,000 00 $ 376,000 00 $ 338,400 00 3300 Childs St Baltimore MD 21226 Lease 5000 221190 $ 375,000 00 $ 330,000 00 $ 297,000 00 200 International Cir Cockeysville MD 21030 Lease 1850 216125 $ 375,500 00 $ 375,500 00 $ 337,950 00 857 Elkridge Landing Rd Linthicum Heights MD 21090 Lease 3434 224354 $ 379,500 00 $ 373,998 90 $ 336,599 01 701 Bestgate Rd Annapolis MD 21401 Lease 1010 236329 $ 380,500 00 $ 365,000 00 $ 328,500 00 7129 Ambassador Rd Milford Mill MD 21244 Sublease 11130 230930 $ 385,000 00 $ 374,000 00 $ 336,600 00 10461 Mill Run Cir Owings Mills MD 21117 Lease 3040 230713 $ 385,900 00 $ 385,900 00 $ 347,310 00 2025 Inverness Ave Baltimore MD 21230 Lease 5000 224544 $ 395,000 00 $ 375,000 00 $ 337,500 00 225 International Cir Cockeysville MD 21030 Lease 8750 232665 $ 395,000 00 $ 380,000 00 $ 342,000 00 47 State Cir Annapolis MD 21401 Lease 3650 219058 $ 399,000 00 $ 350,000 00 $ 315,000 00 1614 Churchville Rd Bel Air MD 21015 Lease 16000 218855 $ 400,000 00 $ 375,000 00 $ 337,500 00 3700 O'Donnell St Baltimore MD 21224 Lease 6300 216411 $ 400,000 00 $ 375,000 00 $ 337,500 00 7004 Security Blvd Woodlawn MD 21244 Lease 662 224895 $ 400,000 00 $ 400,000 00 $ 360,000 00 204 S High St Baltimore MD 21202 Lease 8000 224715 $ 410,000 00 $ 397,700 00 $ 357,930 00 500 Redland Ct Owings Mills MD 21117 Sublease 10380 232767 $ 410,000 00 $ 350,750 00 $ 315,675 00 1018 N Charles St Baltimore MD 21201 Sale 8143 222590 $ 418,000 00 $ 400,000 00 $ 360,000 00 7221 Lee Deforest Dr Columbia MD 21046 Lease 5580 229711 $ 424,490 00 $ 424,490 00 $ 382,041 00 1200 Steuart St Baltimore MD 21230 Lease 3450 216695 $ 425,000 00 $ 415,000 00 $ 373,500 00 137 Mitchells Chance Rd Edgewater MD 21037 Sale 11910 236346 $ 425,815 00 $ 400,000 00 $ 360,000 00 1190 Winterson Rd Linthicum Heights MD 21090 Lease 4070 224266 $ 450,000 00 $ 382,500 00 $ 344,250 00 163 Conduit St Annapolis MD 21401 Sale 1430 236340 $ 450,000 00 $ 400,000 00 $ 360,000 00 22 Light St Baltimore MD 21202 Lease 3828 224294 $ 450,000 00 $ 400,000 00 $ 360,000 00 253 Lewis Ln Havre de Grace MD 21078 Lease 5120 218576 $ 450,000 00 $ 382,500 00 $ 344,250 00 3401 Box Hill Corporate Center Dr Abingdon MD 21009 Lease 2000 218623 $ 450,000 00 $ 400,000 00 $ 360,000 00 7160 Columbia Gateway Dr Columbia MD 21046 Lease 12958 224547 $ 459,800 00 $ 440,000 00 $ 396,000 00 2850 Quarry Lake Dr Baltimore MD 21209 Lease 2100 217311 $ 460,750 00 $ 435,500 00 $ 391,950 00 875 Hollins St Baltimore MD 21201 Lease 17870 230617 $ 467,500 00 $ 456,500 00 $ 410,850 00 9212 Berger Rd Columbia MD 21046 Lease 17380 216733 $ 468,396 50 $ 440,000 00 $ 396,000 00 2405 York Rd Lutherville Timonium MD 21093 Lease 2240 218223 $ 475,000 00 $ 425,250 00 $ 382,725 00 3600 Georgetown Rd Halethorpe MD 21227 Sale 22000 224290 $ 475,000 00 $ 450,000 00 $ 405,000 00 6956 Aviation Blvd Glen Burnie MD 21061 Lease 26000 217676 $ 475,000 00 $ 455,000 00 $ 409,500 00 849 International Dr Linthicum Heights MD 21090 Lease 5410 221204 $ 495,000 00 $ 420,750 00 $ 378,675 00 105 Painters Mill Rd Owings Mills MD 21117 Lease 1150 217338 $ 500,000 00 $ 465,000 00 $ 418,500 00 2809 Boston St Baltimore MD 21224 Sublease 9070 235305 $ 500,000 00 $ 425,000 00 $ 382,500 00 14804 York Rd Sparks Glencoe MD 21152 Lease 10560 217476 $ 515,000 00 $ 485,750 00 $ 437,175 00 7225 Standard Dr Hanover MD 21076 Lease 61650 232644 $ 550,000 00 $ 511,500 00 $ 460,350 00 115 Airport Dr Westminster MD 21157 Lease 8040 222541 $ 555,000 00 $ 500,000 00 $ 450,000 00 67 Holly Branch Ct Glen Arm MD 21057 Lease 2164 232945 $ 555,000 00 $ 565,000 00 $ 508,500 00 210 E Redwood St Baltimore MD 21202 Sale 26593 224540 $ 560,700 00 $ 550,000 00 $ 495,000 00 1099 Winterson Rd Linthicum Heights MD 21090 Lease 1769 224261 $ 565,000 00 $ 535,000 00 $ 481,500 00 95 Carroll St Westminster MD 21157 Lease 3630 229955 $ 566,500 00 $ 534,325 00 $ 480,892 50 6230 Old Dobbin Ln Columbia MD 21045 Lease 4640 217078 $ 589,000 00 $ 575,000 00 $ 517,500 00 8355 Court Ave Ellicott City MD 21043 Lease 2680 232617 $ 610,500 00 $ 550,000 00 $ 495,000 00 730 Frederick Rd Catonsville MD 21228 Lease 1200 221197 $ 621,500 00 $ 588,500 00 $ 529,650 00 3031 Washington Blvd Baltimore MD 21230 Lease 8500 221222 $ 650,000 00 $ 598,000 00 $ 538,200 00 1 N Haven St Baltimore MD 21224 Lease 25000 230647 $ 725,000 00 $ 645,250 00 $ 580,725 00 11311 McCormick Rd Cockeysville MD 21031 Lease 10610 216351 $ 750,250 00 $ 700,000 00 $ 630,000 00 7125 Thomas Edison Dr Columbia MD 21046 Lease 3894 221221 $ 797,500 00 $ 709,775 00 $ 638,797 50 8235 Patuxent Range Rd Jessup MD 20794 Lease 49350 224515 $ 825,275 00 $ 770,000 00 $ 693,000 00 300 Redland Ct Owings Mills MD 21117 Sublease 4320 232728 $ 1,250,000 00 $1,225,000 00 $ 1,102,500 00 275 West St Annapolis MD 21401 Lease 2388 224903 $ 1,500,120 00 $1,400,000 00 $ 1,260,000 00 Table 2 Address 849 International Dr 7008 Security Blvd 10461 Mill Run Cir 14804 York Rd 6085 Marshalee Dr 7129 Ambassador Rd 8235 Patuxent Range Rd 6956 Aviation Blvd 6200 Guardian Gateway 253 Lewis Ln 8298 Brock Bridge Rd 210 E Redwood St 1018 N Charles St 225 International Cir 2809 Boston St 2405 York Rd 2025 Inverness Ave 1200 Steuart St 7221 Lee Deforest Dr 9212 Berger Rd 620 Frederick Rd 9160 Guilford Rd 3300 Childs St 701 Bestgate Rd 911 N Charles St 137 Mitchells Chance Rd 3031 Washington Blvd 8255 Patuxent Range Rd 1135 Business Pkwy S 275 West St 31 Light St 7000 Security Blvd 1300 Thames St Question 1 Use Data1 Sheet In this sheet, you have (i) Table 1 contains a full list of all (107) properties with all detail information (ii) Table 2 contains a short list of about 33 records of property 1a Find the Total value of Selling Price for the list of properties in Table 2 1b Find the Total profit for the 33 properties in Table 2 Profit for each property Selling price Purchase price

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 03, 2024

please answe all parts of question 1 Table 1 Adress city state postal_code listing_type listing_size unit_id Listing Price (Hypothetical) Selling Price (Hypothetical) Purchase Price (Hypothetical)

please answe all parts of question 1

Table 1
Adress	city	state	postal_code	listing_type	listing_size	unit_id	Listing Price (Hypothetical)	Selling Price (Hypothetical)	Purchase Price (Hypothetical)
1134 N Rolling Rd	Catonsville	MD	21228	Lease	4850	222596	$ 110,000.00	$ 106,000.00	$ 95,400.00
8255 Patuxent Range Rd	Jessup	MD	20794	Lease	7885	221212	$ 121,000.00	$ 116,600.00	$ 104,940.00
307 International Cir	Cockeysville	MD	21030	Lease	1320	216190	$ 147,800.00	$ 150,000.00	$ 135,000.00
1120 Whistler Ave	Baltimore	MD	21223	Sale	38000	224760	$ 165,000.00	$ 156,750.00	$ 141,075.00
6958 Aviation Blvd	Glen Burnie	MD	21061	Lease	10710	217619	$ 165,900.00	$ 159,264.00	$ 143,337.60
307 Washington Ave	Towson	MD	21204	Lease	6060	229911	$ 180,000.00	$ 175,000.00	$ 157,500.00
800 International Dr	Linthicum Heights	MD	21090	Lease	22607	221203	$ 181,500.00	$ 172,425.00	$ 155,182.50
201 International Cir	Cockeysville	MD	21030	Lease	2150	216492	$ 185,500.00	$ 179,000.00	$ 161,100.00
6031 University Blvd	Ellicott City	MD	21043	Sublease	2800	230257	$ 189,900.00	$ 186,102.00	$ 167,491.80
3301 Childs St	Baltimore	MD	21226	Lease	2835	221191	$ 215,000.00	$ 195,000.00	$ 175,500.00
104 E Pennsylvania Ave	Towson	MD	21286	Lease	1220	218153	$ 215,800.00	$ 200,000.00	$ 180,000.00
1106 Business Pkwy S	Westminster	MD	21157	Lease	15530	217523	$ 219,000.00	$ 215,000.00	$ 193,500.00
72 Loveton Cir	Sparks Glencoe	MD	21152	Lease	18330	232810	$ 237,380.00	$ 220,000.00	$ 198,000.00
7801 Dorsey Run Rd	Jessup	MD	20794	Lease	156140	224286	$ 240,900.00	$ 236,500.00	$ 212,850.00
7021 Columbia Gateway Dr	Columbia	MD	21046	Lease	3890	229576	$ 245,900.00	$ 233,605.00	$ 210,244.50
1419 Forest Dr	Annapolis	MD	21403	Sale	19100	236310	$ 250,000.00	$ 232,000.00	$ 208,800.00
20 Pleasant Ridge Dr	Owings Mills	MD	21117	Lease	1877	221213	$ 250,000.00	$ 255,000.00	$ 229,500.00
620 Frederick Rd	Catonsville	MD	21228	Lease	2900	237052	$ 250,000.00	$ 275,000.00	$ 247,500.00
6250 Old Dobbin Ln	Columbia	MD	21045	Lease	6160	217151	$ 254,500.00	$ 236,685.00	$ 213,016.50
4660 Wilkens Ave	Baltimore	MD	21229	Lease	1081	224311	$ 259,900.00	$ 246,905.00	$ 222,214.50
6200 Guardian Gateway	Aberdeen Proving Ground	MD	21005	Sublease	18090	216575	$ 275,000.00	$ 264,000.00	$ 237,600.00
930 International Dr	Linthicum Heights	MD	21090	Lease	33537	221205	$ 275,000.00	$ 255,200.00	$ 229,680.00
6901 Security Blvd	Woodlawn	MD	21244	Lease	9180	230869	$ 275,900.00	$ 250,000.00	$ 225,000.00
1300 Thames St	Baltimore	MD	21231	Lease	23470	217190	$ 285,750.00	$ 300,000.00	$ 270,000.00
6 Fleet St	Annapolis	MD	21401	Lease	1580	217368	$ 285,750.00	$ 300,000.00	$ 270,000.00
405 E Joppa Rd	Towson	MD	21286	Lease	2130	217455	$ 289,900.00	$ 279,000.00	$ 251,100.00
7000 Security Blvd	Woodlawn	MD	21244	Lease	4056	224894	$ 299,999.00	$ 280,000.00	$ 252,000.00
10629 York Rd	Cockeysville	MD	21030	Lease	1900	219034	$ 300,000.00	$ 290,000.00	$ 261,000.00
1200 E Joppa Rd	Towson	MD	21286	Lease	890	219130	$ 300,000.00	$ 300,000.00	$ 270,000.00
6300 Blair Hill Ln	Baltimore	MD	21209	Lease	22410	230694	$ 300,000.00	$ 250,000.00	$ 225,000.00
180 W Ostend St	Baltimore	MD	21230	Lease	5000	216826	$ 310,000.00	$ 300,000.00	$ 270,000.00
31 Light St	Baltimore	MD	21202	Lease	5830	222441	$ 310,000.00	$ 291,400.00	$ 262,260.00
1135 Business Pkwy S	Westminster	MD	21157	Lease	19900	222547	$ 314,250.00	$ 304,000.00	$ 273,600.00
9160 Guilford Rd	Columbia	MD	21046	Lease	18520	230744	$ 314,325.00	$ 330,000.00	$ 297,000.00
3444 Ellicott Center Dr	Ellicott City	MD	21043	Lease	1980	235377	$ 315,250.00	$ 300,000.00	$ 270,000.00
40 York Rd	Towson	MD	21204	Lease	2920	230995	$ 316,000.00	$ 316,000.00	$ 284,400.00
1129 Business Pkwy S	Westminster	MD	21157	Lease	18700	222546	$ 325,000.00	$ 320,000.00	$ 288,000.00
1215 E Fort Ave	Baltimore	MD	21230	Lease	8000	230034	$ 325,000.00	$ 308,750.00	$ 277,875.00
1232 Race Rd	Rosedale	MD	21237	Sale	2680	224683	$ 325,000.00	$ 302,250.00	$ 272,025.00
125 Airport Dr	Westminster	MD	21157	Lease	16325	222542	$ 325,000.00	$ 320,000.00	$ 288,000.00
3051 Washington Blvd	Baltimore	MD	21230	Lease	25920	221223	$ 325,000.00	$ 325,000.00	$ 292,500.00
7235 Standard Dr	Hanover	MD	21076	Sublease	15970	217294	$ 330,000.00	$ 319,000.00	$ 287,100.00
8620 Guilford Rd	Columbia	MD	21046	Lease	660	237002	$ 330,000.00	$ 330,000.00	$ 297,000.00
6085 Marshalee Dr	Elkridge	MD	21075	Lease	13610	216285	$ 335,000.00	$ 330,000.00	$ 297,000.00
7008 Security Blvd	Woodlawn	MD	21244	Lease	1272	224899	$ 339,999.00	$ 310,000.00	$ 279,000.00
120 Cockeysville Rd	Cockeysville	MD	21030	Lease	2240	218024	$ 345,000.00	$ 339,999.00	$ 305,999.10
315 N Charles St	Baltimore	MD	21201	Sale	8206	222493	$ 345,000.00	$ 335,000.00	$ 301,500.00
4408 Washington Blvd	Halethorpe	MD	21227	Sale	7000	221224	$ 345,000.00	$ 330,000.00	$ 297,000.00
6240 Old Dobbin Ln	Columbia	MD	21045	Lease	15540	217030	$ 345,670.00	$ 345,000.00	$ 310,500.00
8298 Brock Bridge Rd	Laurel	MD	20724	Sale	37840	224003	$ 345,675.00	$ 334,400.00	$ 300,960.00
10000 Franklin Square Dr	Nottingham	MD	21236	Lease	392500	221196	$ 350,000.00	$ 340,000.00	$ 306,000.00
817 Maiden Choice Ln	Catonsville	MD	21228	Lease	1550	224301	$ 357,500.00	$ 352,000.00	$ 316,800.00
90 Aileron Ct	Westminster	MD	21157	Lease	1700	234896	$ 357,500.00	$ 339,625.00	$ 305,662.50
910 Ridgebrook Rd	Sparks Glencoe	MD	21152	Lease	56320	217490	$ 357,500.00	$ 332,475.00	$ 299,227.50
911 N Charles St	Baltimore	MD	21201	Lease	1650	222505	$ 357,500.00	$ 352,000.00	$ 316,800.00
300 W Fayette St	Baltimore	MD	21201	Sale	108225	222510	$ 365,750.00	$ 355,000.00	$ 319,500.00
300 E Joppa Rd	Baltimore	MD	21286	Lease	87280	230249	$ 375,000.00	$ 376,000.00	$ 338,400.00
3300 Childs St	Baltimore	MD	21226	Lease	5000	221190	$ 375,000.00	$ 330,000.00	$ 297,000.00
200 International Cir	Cockeysville	MD	21030	Lease	1850	216125	$ 375,500.00	$ 375,500.00	$ 337,950.00
857 Elkridge Landing Rd	Linthicum Heights	MD	21090	Lease	3434	224354	$ 379,500.00	$ 373,998.90	$ 336,599.01
701 Bestgate Rd	Annapolis	MD	21401	Lease	1010	236329	$ 380,500.00	$ 365,000.00	$ 328,500.00
7129 Ambassador Rd	Milford Mill	MD	21244	Sublease	11130	230930	$ 385,000.00	$ 374,000.00	$ 336,600.00
10461 Mill Run Cir	Owings Mills	MD	21117	Lease	3040	230713	$ 385,900.00	$ 385,900.00	$ 347,310.00
2025 Inverness Ave	Baltimore	MD	21230	Lease	5000	224544	$ 395,000.00	$ 375,000.00	$ 337,500.00
225 International Cir	Cockeysville	MD	21030	Lease	8750	232665	$ 395,000.00	$ 380,000.00	$ 342,000.00
47 State Cir	Annapolis	MD	21401	Lease	3650	219058	$ 399,000.00	$ 350,000.00	$ 315,000.00
1614 Churchville Rd	Bel Air	MD	21015	Lease	16000	218855	$ 400,000.00	$ 375,000.00	$ 337,500.00
3700 O'Donnell St	Baltimore	MD	21224	Lease	6300	216411	$ 400,000.00	$ 375,000.00	$ 337,500.00
7004 Security Blvd	Woodlawn	MD	21244	Lease	662	224895	$ 400,000.00	$ 400,000.00	$ 360,000.00
204 S High St	Baltimore	MD	21202	Lease	8000	224715	$ 410,000.00	$ 397,700.00	$ 357,930.00
500 Redland Ct	Owings Mills	MD	21117	Sublease	10380	232767	$ 410,000.00	$ 350,750.00	$ 315,675.00
1018 N Charles St	Baltimore	MD	21201	Sale	8143	222590	$ 418,000.00	$ 400,000.00	$ 360,000.00
7221 Lee Deforest Dr	Columbia	MD	21046	Lease	5580	229711	$ 424,490.00	$ 424,490.00	$ 382,041.00
1200 Steuart St	Baltimore	MD	21230	Lease	3450	216695	$ 425,000.00	$ 415,000.00	$ 373,500.00
137 Mitchells Chance Rd	Edgewater	MD	21037	Sale	11910	236346	$ 425,815.00	$ 400,000.00	$ 360,000.00
1190 Winterson Rd	Linthicum Heights	MD	21090	Lease	4070	224266	$ 450,000.00	$ 382,500.00	$ 344,250.00
163 Conduit St	Annapolis	MD	21401	Sale	1430	236340	$ 450,000.00	$ 400,000.00	$ 360,000.00
22 Light St	Baltimore	MD	21202	Lease	3828	224294	$ 450,000.00	$ 400,000.00	$ 360,000.00
253 Lewis Ln	Havre de Grace	MD	21078	Lease	5120	218576	$ 450,000.00	$ 382,500.00	$ 344,250.00
3401 Box Hill Corporate Center Dr	Abingdon	MD	21009	Lease	2000	218623	$ 450,000.00	$ 400,000.00	$ 360,000.00
7160 Columbia Gateway Dr	Columbia	MD	21046	Lease	12958	224547	$ 459,800.00	$ 440,000.00	$ 396,000.00
2850 Quarry Lake Dr	Baltimore	MD	21209	Lease	2100	217311	$ 460,750.00	$ 435,500.00	$ 391,950.00
875 Hollins St	Baltimore	MD	21201	Lease	17870	230617	$ 467,500.00	$ 456,500.00	$ 410,850.00
9212 Berger Rd	Columbia	MD	21046	Lease	17380	216733	$ 468,396.50	$ 440,000.00	$ 396,000.00
2405 York Rd	Lutherville-Timonium	MD	21093	Lease	2240	218223	$ 475,000.00	$ 425,250.00	$ 382,725.00
3600 Georgetown Rd	Halethorpe	MD	21227	Sale	22000	224290	$ 475,000.00	$ 450,000.00	$ 405,000.00
6956 Aviation Blvd	Glen Burnie	MD	21061	Lease	26000	217676	$ 475,000.00	$ 455,000.00	$ 409,500.00
849 International Dr	Linthicum Heights	MD	21090	Lease	5410	221204	$ 495,000.00	$ 420,750.00	$ 378,675.00
105 Painters Mill Rd	Owings Mills	MD	21117	Lease	1150	217338	$ 500,000.00	$ 465,000.00	$ 418,500.00
2809 Boston St	Baltimore	MD	21224	Sublease	9070	235305	$ 500,000.00	$ 425,000.00	$ 382,500.00
14804 York Rd	Sparks Glencoe	MD	21152	Lease	10560	217476	$ 515,000.00	$ 485,750.00	$ 437,175.00
7225 Standard Dr	Hanover	MD	21076	Lease	61650	232644	$ 550,000.00	$ 511,500.00	$ 460,350.00
115 Airport Dr	Westminster	MD	21157	Lease	8040	222541	$ 555,000.00	$ 500,000.00	$ 450,000.00
67 Holly Branch Ct	Glen Arm	MD	21057	Lease	2164	232945	$ 555,000.00	$ 565,000.00	$ 508,500.00
210 E Redwood St	Baltimore	MD	21202	Sale	26593	224540	$ 560,700.00	$ 550,000.00	$ 495,000.00
1099 Winterson Rd	Linthicum Heights	MD	21090	Lease	1769	224261	$ 565,000.00	$ 535,000.00	$ 481,500.00
95 Carroll St	Westminster	MD	21157	Lease	3630	229955	$ 566,500.00	$ 534,325.00	$ 480,892.50
6230 Old Dobbin Ln	Columbia	MD	21045	Lease	4640	217078	$ 589,000.00	$ 575,000.00	$ 517,500.00
8355 Court Ave	Ellicott City	MD	21043	Lease	2680	232617	$ 610,500.00	$ 550,000.00	$ 495,000.00
730 Frederick Rd	Catonsville	MD	21228	Lease	1200	221197	$ 621,500.00	$ 588,500.00	$ 529,650.00
3031 Washington Blvd	Baltimore	MD	21230	Lease	8500	221222	$ 650,000.00	$ 598,000.00	$ 538,200.00
1 N Haven St	Baltimore	MD	21224	Lease	25000	230647	$ 725,000.00	$ 645,250.00	$ 580,725.00
11311 McCormick Rd	Cockeysville	MD	21031	Lease	10610	216351	$ 750,250.00	$ 700,000.00	$ 630,000.00
7125 Thomas Edison Dr	Columbia	MD	21046	Lease	3894	221221	$ 797,500.00	$ 709,775.00	$ 638,797.50
8235 Patuxent Range Rd	Jessup	MD	20794	Lease	49350	224515	$ 825,275.00	$ 770,000.00	$ 693,000.00
300 Redland Ct	Owings Mills	MD	21117	Sublease	4320	232728	$ 1,250,000.00	$1,225,000.00	$ 1,102,500.00
275 West St	Annapolis	MD	21401	Lease	2388	224903	$ 1,500,120.00	$1,400,000.00	$ 1,260,000.00

Table 2

Address

849 International Dr

7008 Security Blvd

10461 Mill Run Cir

14804 York Rd

6085 Marshalee Dr

7129 Ambassador Rd

8235 Patuxent Range Rd

6956 Aviation Blvd

6200 Guardian Gateway

253 Lewis Ln

8298 Brock Bridge Rd

210 E Redwood St

1018 N Charles St

225 International Cir

2809 Boston St

2405 York Rd

2025 Inverness Ave

1200 Steuart St

7221 Lee Deforest Dr

9212 Berger Rd

620 Frederick Rd

9160 Guilford Rd

3300 Childs St

701 Bestgate Rd

911 N Charles St

137 Mitchells Chance Rd

3031 Washington Blvd

8255 Patuxent Range Rd

1135 Business Pkwy S

275 West St

31 Light St

7000 Security Blvd

1300 Thames St

Question 1: Use Data1 Sheet

In this sheet, you have:

(i) Table 1 contains a full list of all (107) properties with all detail information.

(ii) Table 2 contains a short list of about 33 records of property

1a. Find the Total value of Selling Price for the list of properties in Table 2

1b. Find the Total profit for the 33 properties in Table 2

Profit for each property = Selling price Purchase price

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

Step: 3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

How To Achieve Financial Stability And Sustainability

Authors: Dr Javnyuy Joybert Joybert

1st Edition

131236789X, 978-1312367890

More Books

Students also viewed these Finance questions

Question

It will probably take about three months for your business to start earning a profit. Do you agree or disagree? Why? If you disagree, how long do you expect it to take? What are the three most...

Answered: 1 week ago

Question

★★★★★

Tara Harris opened Tara's Maids Cleaning Service, Ltd. on July 1, 2017. During July, the company completed the following transactions. July 1 Shareholders invested 15,000 cash in the business in...

Answered: 1 week ago

Question

★★★★★

please answe all parts of question 1 Table 1 Adress city state postal_code listing_type listing_size unit_id Listing Price (Hypothetical) Selling Price (Hypothetical) Purchase Price (Hypothetical)...

Answered: 1 week ago

Question

★★★★★

You have $126,000 on deposit with no outstanding checks or uncleared deposits. One day you write a check for $58,000. a. Does this create a disbursement float or a collection float? b. What is your...

Answered: 1 week ago

Question

★★★★★

Identify family members you have had contact with from infancy, including biological and adoptive parents, foster parents etc. Recall memories and events where race, gender, class, sexual...

Answered: 1 week ago

Question

★★★★★

1)Dow Chemical is to deliver $1 million of chemicals to an Indian firm in one year. The one year-forward rate is 40 rupee per dollar (INR/$) and the sale is invoiced in Rupees. at the forward rate of...

Answered: 1 week ago

Question

★★★★★

What economic circumstances gave rise to the Keynesian approach to understanding the workings of the economy? What are the principal differences between the Keynesian and Classical approaches to...

Answered: 1 week ago

Question

★★★★★

Exam Content You studied change models in Week 1. This week you began to consider the impact of individuals in terms of productivity. In this assessment, you will craft an approach to changing the...

Answered: 1 week ago

Question

★★★★★

The following summarized data (amounts in millions) are taken from the September 26, 2020, and September 28, 2019, comparative financial statements of Apple Incorporated, a company that designs,...

Answered: 1 week ago

Previous Question Next Question