Assignment #1 -Solution

xlsx

School

Johns Hopkins University *

*We aren’t endorsed by this school

Course

BU1923

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

12

Uploaded by CorporalOpossumMaster935

Report
Assignment #1 BU.241.630.41.FA23 Real Estate Products and Emerging Trends Answer Sheet Question 1 $15,438,984 2a Refer to row 46 on tab '2. Pro Forma' 2b $7,077,049
Assignment #1 BU.241.630.41.FA23 Real Estate Products and Emerging Trends Pro Forma Subject Property: 419 Vanderbilt Ave Gross Building SF: 60,720 Year Built: 1930 Total # Units: 49 419 Vanderbilt Pro Forma Assumptions Per Unit 2021 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Year 11 Income: Free Market Rent 3.00% $907,200 $907,200 $934,416 $962,448 $991,322 $1,021,062 $1,051,693 $1,083,244 $1,115,742 $1,149,214 $1,183,690 $1,219,201 Rent Controlled Rent 3.00% 6,126 6,126 6,310 6,499 6,694 6,895 7,102 7,315 7,534 7,760 7,993 8,233 Rent Stabilized Rent 3.00% 418,090 418,090 430,633 443,552 456,858 470,564 484,681 499,221 514,198 529,624 545,513 561,878 Other Income 3.00% - - - - - - - - - - - - Potential Gross Income $1,331,416 $1,331,416 $1,371,358 $1,412,499 $1,454,874 $1,498,520 $1,543,476 $1,589,780 $1,637,474 $1,686,598 $1,737,196 $1,789,312 Less: Free Market Rent Vacancy (1) 2.00% $25,402 $18,144 $18,688 $19,249 $19,826 $20,421 $21,034 $21,665 $22,315 $22,984 $23,674 $24,384 Rent Controlled Vacancy (1) 2.00% #NAME? 123 126 130 134 138 142 146 151 155 160 165 Rent Stabilized Vavancy (1) 2.00% #NAME? 8,362 8,613 8,871 9,137 9,411 9,694 9,984 10,284 10,592 10,910 11,238 Total Vacancy $37,280 $26,628 $27,427 $28,250 $29,097 $29,970 $30,870 $31,796 $32,749 $33,732 $34,744 $35,786 Effective Gross Income $1,294,136 $1,304,788 $1,343,931 $1,384,249 $1,425,777 $1,468,550 $1,512,606 $1,557,985 $1,604,724 $1,652,866 $1,702,452 $1,753,525 Expenses: Insurance 3.50% $473 $23,177 $23,177 $23,988 $24,828 $25,697 $26,596 $27,527 $28,490 $29,488 $30,520 $31,588 $32,693 Common Area Utilities 3.50% 123 6,027 6,027 6,238 6,456 6,682 6,916 7,158 7,409 7,668 7,936 8,214 8,502 Heat/Fuel 3.50% 586 28,714 28,714 29,719 30,759 31,836 32,950 34,103 35,297 36,532 37,811 39,134 40,504 Water & Sewer 3.50% 1,017 49,833 49,833 51,577 53,382 55,251 57,185 59,186 61,257 63,401 65,621 67,917 70,294 Payroll & Related 3.50% 231 11,319 11,319 11,715 12,125 12,550 12,989 13,443 13,914 14,401 14,905 15,427 15,967 Reserve for Replacement 3.50% 150 7,350 7,350 7,607 7,874 8,149 8,434 8,729 9,035 9,351 9,679 10,017 10,368 Management Fee 3.00% 792 38,824 39,144 40,318 41,527 42,773 44,056 45,378 46,740 48,142 49,586 51,074 52,606 Repairs & Maintenance 3.50% 469 23,000 23,000 23,805 24,638 25,501 26,393 27,317 28,273 29,262 30,287 31,347 32,444 Total Operating Expenses $3,842 $188,244 $188,564 $194,968 $201,590 $208,438 $215,519 $222,842 $230,415 $238,246 $246,344 $254,718 $263,377 Real Estate Taxes 3.50% $258,292 $258,292 $267,332 $276,689 $286,373 $296,396 $306,770 $317,507 $328,620 $340,121 $352,025 $364,346 Other Expenses 3.50% - - - - - - - - - - - - Total Expenses $446,536 $446,856 $462,300 $478,279 $494,811 $511,915 $529,612 $547,922 $566,865 $586,465 $606,743 $627,724 Net Operating Income $847,600 $857,932 $881,631 $905,970 $930,966 $956,635 $982,994 $1,010,063 $1,037,859 $1,066,401 $1,095,709 $1,125,802 Debt Service $951,601 $951,601 $951,601 $951,601 $951,601 $951,601 $951,601 $951,601 $951,601 $951,601 $951,601 Net Cash Flow After Debt Service ($93,669) ($69,969) ($45,630) ($20,635) $5,034 $31,394 $58,462 $86,258 $114,800 $144,108 $174,201 (1) Note that a 2.80% vacancy rate is used for 2021 vacancy for calcualting the Income Capitalization Rate value. A 2.00% vacancy rate was utilized for the 10 year discounted cash flow. 2021 NOI $847,600 Year 11 NOI $1,125,802 Cap Rate 5.49% Cap Rate 4.00% Income Cap Value $15,438,984 Income Cap Value $28,145,042
Assignment #1 BU.241.630.41.FA23 Real Estate Products and Emerging Trends RS = Rent Stabilized Subject Property Rent Roll FM = Free Market RC = Rent Controlled Subject Property: 419 Vanderbilt Avenue, Brooklyn, New York 11238 Gross Building SF: 60,720 Year Built: 1930 Total # Units: 49 Free Rent Units Type Unit Count Monthly Rent Annual Rent Studio 2 4,600 55,200 1BR 4 11,150 133,800 2BR 8 29,800 357,600 3BR 2 9,650 115,800 4BR 4 20,400 244,800 Total 20 75,600 907,200 Step #1 No Status Rooms Beds Bed Type Monthly Rent Annual Rent Verified Monthly Verified Annual 1 RS 5 3 3BR 989 11,864 989 11,864 2 RS 6 4 4BR 1,128 13,530 1,128 13,530 3 RS 3 1 1BR 2,773 33,272 2,773 33,272 4 RS 3 2 2BR 718 8,616 718 8,616 5 RS 4 2 2BR 779 9,346 779 9,346 9 FM 3 1 1BR 2,650 31,800 2,650 31,800 7 RS 2 0 Studio 929 11,149 929 11,149 8 SUPER 4 2 2BR N/A N/A - - 21 FM 3 1 1BR 2,800 33,600 2,800 33,600 29 FM 3 1 1BR 2,850 34,200 2,850 34,200 45 FM 3 1 1BR 2,850 34,200 2,850 34,200 6 FM 4 2 2BR 4,050 48,600 4,050 48,600 13 RS 3 1 1BR 1,038 12,455 1,038 12,455 14 RS 4 2 2BR 1,385 16,623 1,385 16,623 12 FM 4 2 2BR 3,500 42,000 3,500 42,000 15 FM 4 2 2BR 4,300 51,600 4,300 51,600 17 RS 4 2 2BR 1,283 15,391 1,283 15,391 20 FM 4 2 2BR 3,550 42,600 3,550 42,600 33 FM 4 2 2BR 3,600 43,200 3,600 43,200 36 FM 4 2 2BR 3,700 44,400 3,700 44,400 39 FM 4 2 2BR 3,650 43,800 3,650 43,800 22 RS 4 2 2BR 880 10,558 880 10,558 23 RS 4 2 2BR 1,545 18,539 1,545 18,539 24 RS 2 0 Studio 2,300 27,600 2,300 27,600 25 RS 4 2 2BR 1,213 14,559 1,213 14,559 26 RS 5 3 3BR 1,202 14,419 1,202 14,419 41 FM 4 2 2BR 3,450 41,400 3,450 41,400 28 RS 4 2 2BR 1,408 16,900 1,408 16,900 10 FM 5 3 3BR 4,850 58,200 4,850 58,200 30 RS 4 2 2BR 1,213 14,555 1,213 14,555 31 RS 4 2 2BR 1,244 14,929 1,244 14,929 18 FM 5 3 3BR 4,800 57,600 4,800 57,600 11 FM 6 4 4BR 4,850 58,200 4,850 58,200 34 RS 5 3 3BR 2,145 25,739 2,145 25,739 19 FM 6 4 4BR 5,300 63,600 5,300 63,600 27 FM 6 4 4BR 5,000 60,000 5,000 60,000 37 RS 3 1 1BR 1,143 13,711 1,143 13,711 38 RS 4 2 2BR 1,499 17,987 1,499 17,987 35 FM 6 4 4BR 5,250 63,000 5,250 63,000 40 RS 2 0 Studio 884 10,602 884 10,602 16 FM 2 0 Studio 2,300 27,600 2,300 27,600 42 RS 5 3 3BR 1,627 19,523 1,627 19,523 43 RS 6 4 4BR 2,049 24,590 2,049 24,590 44 RS 4 2 2BR 1,261 15,126 1,261 15,126 32 FM 2 0 Studio 2,300 27,600 2,300 27,600 46 RS 4 2 2BR 775 9,294 775 9,294 47 RC 4 2 2BR 337 4,040 337 4,040 48 RC 2 0 Studio 174 2,086 174 2,086 49 RS 4 2 2BR 1,434 17,211 1,434 17,211
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Total 110,951 1,331,416 110,951 1,331,416
Assignment #1 BU.241.630.41.FA23 Real Estate Products and Emerging Trends Comparable Data Rent Comparables Cap Rate Comparables Room Type Min Max Average Location Sale Date GBA # Units Cap Rate Studio 1,900 2,325 2,094 665 Saint Marks Avenue 3/30/2020 17,790 21 5.61% 1BR 2,095 2,995 2,585 275 Martense Street 1/17/2020 8,979 8 5.75% 2BR 3,200 4,500 3,883 205 East 17th Street 8/20/2019 64,268 54 4.83% 3BR 4,500 5,000 4,756 1169 Flatbush Avenue 8/5/2019 32,970 28 5.00% 4BR 4,499 5,500 5,124 564 Saint John's Place 6/28/2019 136,864 193 5.75% 629 Ocean Parkway 6/21/2019 61,440 65 6.00% Average 53,719 62 5.49% No Location Unit Type Date Leaed Monthly Rent Annual Rent 1 278 Clinton Avenue Studio 5/31/2022 1,900 22,800 2 266 Washingon Avenue Studio 2/25/2022 2,325 27,900 3 515 Clinton Avenue Studio 3/3/2022 2,100 25,200 4 536 Clinton Avenue Studio 2/13/2022 2,050 24,600 5 468 Grand Avenue 1BR 6/3/2022 2,750 33,000 6 258 Clinton Avenue 1BR 5/28/2022 2,500 30,000 7 196 Clinton Avenue 1BR 5/26/2022 2,095 25,140 8 96 Hall Street 1BR 5/27/2022 2,995 35,940 9 1007 Atlantic Avenue 2BR 6/1/2022 4,035 48,420 10 463 Clinton Avenue 2BR 5/25/2022 3,795 45,540 11 10 Lexington Avenue 2BR 5/22/2022 3,200 38,400 12 538 Washington Avenue 2BR 5/18/2022 4,500 54,000 13 260 Washington Avenue 3BR 5/8/2022 4,547 54,564 14 478 Grand Avenue 3BR 4/24/2022 4,500 54,000 15 79 Clifton Place 3BR 3/21/2022 4,975 59,700 16 112 Leffersts Place 3BR 2/24/2022 5,000 60,000 17 200 Saint James Place 4BR 3/28/2022 4,499 N/A 18 141 Greene Avenue 4BR 3/16/2022 5,500 66,000 19 37 Lexington nAvenue 4BR 8/30/2022 5,195 62,340 20 86 Clinton Avenue 4BR 7/23/2019 5,300 63,600
Assignment #1 BU.241.630.41.FA23 Real Estate Products and Emerging Trends Amorization Schedule Subject Property: 419 Vanderbilt Avenue, Brooklyn, New York 11238 Original Loan Net New Cash Value For Loan: $15,438,984 Year 11 NOI: $1,125,802 Loan-To-Value %: 70.00% Cap Rate 4.00% Loan Amount: $10,807,289 Year 10 Value: $28,145,042 Interest Rate: 8.00% Loan-To-Value %: 80% Debt Service: ($951,601) New Mortgage: $22,516,034 Term (Years): 30 Less: O/S Balance: ($9,480,662) Mortgage Constant: 8.81% Cash Proceeds: $13,035,371 Less - Prior Amort: ($1,326,627) Less - Original Equity: ($4,631,695) Net New Cash: $7,077,049 No Debt Service Interest Principal Balance 0 $10,807,288.83 1 ($79,300.06) $72,048.59 ($7,251.46) $10,800,037.36 2 ($79,300.06) $72,000.25 ($7,299.81) $10,792,737.55 3 ($79,300.06) $71,951.58 ($7,348.47) $10,785,389.08 4 ($79,300.06) $71,902.59 ($7,397.46) $10,777,991.62 5 ($79,300.06) $71,853.28 ($7,446.78) $10,770,544.84 6 ($79,300.06) $71,803.63 ($7,496.42) $10,763,048.41 7 ($79,300.06) $71,753.66 ($7,546.40) $10,755,502.01 8 ($79,300.06) $71,703.35 ($7,596.71) $10,747,905.30 9 ($79,300.06) $71,652.70 ($7,647.35) $10,740,257.95 10 ($79,300.06) $71,601.72 ($7,698.34) $10,732,559.61 11 ($79,300.06) $71,550.40 ($7,749.66) $10,724,809.95 12 ($79,300.06) $71,498.73 ($7,801.32) $10,717,008.63 13 ($79,300.06) $71,446.72 ($7,853.33) $10,709,155.30 14 ($79,300.06) $71,394.37 ($7,905.69) $10,701,249.61 15 ($79,300.06) $71,341.66 ($7,958.39) $10,693,291.22 16 ($79,300.06) $71,288.61 ($8,011.45) $10,685,279.77 17 ($79,300.06) $71,235.20 ($8,064.86) $10,677,214.91 18 ($79,300.06) $71,181.43 ($8,118.62) $10,669,096.28 19 ($79,300.06) $71,127.31 ($8,172.75) $10,660,923.54 20 ($79,300.06) $71,072.82 ($8,227.23) $10,652,696.30 21 ($79,300.06) $71,017.98 ($8,282.08) $10,644,414.22 22 ($79,300.06) $70,962.76 ($8,337.30) $10,636,076.93 23 ($79,300.06) $70,907.18 ($8,392.88) $10,627,684.05 24 ($79,300.06) $70,851.23 ($8,448.83) $10,619,235.22 25 ($79,300.06) $70,794.90 ($8,505.16) $10,610,730.06 26 ($79,300.06) $70,738.20 ($8,561.86) $10,602,168.21 27 ($79,300.06) $70,681.12 ($8,618.94) $10,593,549.27 28 ($79,300.06) $70,623.66 ($8,676.39) $10,584,872.88 29 ($79,300.06) $70,565.82 ($8,734.24) $10,576,138.64 30 ($79,300.06) $70,507.59 ($8,792.47) $10,567,346.17 31 ($79,300.06) $70,448.97 ($8,851.08) $10,558,495.09 32 ($79,300.06) $70,389.97 ($8,910.09) $10,549,585.00 33 ($79,300.06) $70,330.57 ($8,969.49) $10,540,615.51 34 ($79,300.06) $70,270.77 ($9,029.29) $10,531,586.22 35 ($79,300.06) $70,210.57 ($9,089.48) $10,522,496.74 36 ($79,300.06) $70,149.98 ($9,150.08) $10,513,346.66 37 ($79,300.06) $70,088.98 ($9,211.08) $10,504,135.58 38 ($79,300.06) $70,027.57 ($9,272.49) $10,494,863.10 39 ($79,300.06) $69,965.75 ($9,334.30) $10,485,528.80 40 ($79,300.06) $69,903.53 ($9,396.53) $10,476,132.26 41 ($79,300.06) $69,840.88 ($9,459.18) $10,466,673.09 42 ($79,300.06) $69,777.82 ($9,522.24) $10,457,150.85 43 ($79,300.06) $69,714.34 ($9,585.72) $10,447,565.14 44 ($79,300.06) $69,650.43 ($9,649.62) $10,437,915.51 45 ($79,300.06) $69,586.10 ($9,713.95) $10,428,201.56 46 ($79,300.06) $69,521.34 ($9,778.71) $10,418,422.85
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
47 ($79,300.06) $69,456.15 ($9,843.90) $10,408,578.94 48 ($79,300.06) $69,390.53 ($9,909.53) $10,398,669.41 49 ($79,300.06) $69,324.46 ($9,975.59) $10,388,693.82 50 ($79,300.06) $69,257.96 ($10,042.10) $10,378,651.72 51 ($79,300.06) $69,191.01 ($10,109.05) $10,368,542.67 52 ($79,300.06) $69,123.62 ($10,176.44) $10,358,366.23 53 ($79,300.06) $69,055.77 ($10,244.28) $10,348,121.95 54 ($79,300.06) $68,987.48 ($10,312.58) $10,337,809.38 55 ($79,300.06) $68,918.73 ($10,381.33) $10,327,428.05 56 ($79,300.06) $68,849.52 ($10,450.54) $10,316,977.51 57 ($79,300.06) $68,779.85 ($10,520.21) $10,306,457.30 58 ($79,300.06) $68,709.72 ($10,590.34) $10,295,866.96 59 ($79,300.06) $68,639.11 ($10,660.94) $10,285,206.02 60 ($79,300.06) $68,568.04 ($10,732.02) $10,274,474.00 61 ($79,300.06) $68,496.49 ($10,803.56) $10,263,670.44 62 ($79,300.06) $68,424.47 ($10,875.59) $10,252,794.85 63 ($79,300.06) $68,351.97 ($10,948.09) $10,241,846.76 64 ($79,300.06) $68,278.98 ($11,021.08) $10,230,825.68 65 ($79,300.06) $68,205.50 ($11,094.55) $10,219,731.13 66 ($79,300.06) $68,131.54 ($11,168.52) $10,208,562.61 67 ($79,300.06) $68,057.08 ($11,242.97) $10,197,319.64 68 ($79,300.06) $67,982.13 ($11,317.93) $10,186,001.72 69 ($79,300.06) $67,906.68 ($11,393.38) $10,174,608.34 70 ($79,300.06) $67,830.72 ($11,469.33) $10,163,139.00 71 ($79,300.06) $67,754.26 ($11,545.80) $10,151,593.21 72 ($79,300.06) $67,677.29 ($11,622.77) $10,139,970.44 73 ($79,300.06) $67,599.80 ($11,700.25) $10,128,270.18 74 ($79,300.06) $67,521.80 ($11,778.26) $10,116,491.93 75 ($79,300.06) $67,443.28 ($11,856.78) $10,104,635.15 76 ($79,300.06) $67,364.23 ($11,935.82) $10,092,699.33 77 ($79,300.06) $67,284.66 ($12,015.39) $10,080,683.93 78 ($79,300.06) $67,204.56 ($12,095.50) $10,068,588.44 79 ($79,300.06) $67,123.92 ($12,176.13) $10,056,412.30 80 ($79,300.06) $67,042.75 ($12,257.31) $10,044,154.99 81 ($79,300.06) $66,961.03 ($12,339.02) $10,031,815.97 82 ($79,300.06) $66,878.77 ($12,421.28) $10,019,394.69 83 ($79,300.06) $66,795.96 ($12,504.09) $10,006,890.59 84 ($79,300.06) $66,712.60 ($12,587.45) $9,994,303.14 85 ($79,300.06) $66,628.69 ($12,671.37) $9,981,631.77 86 ($79,300.06) $66,544.21 ($12,755.84) $9,968,875.93 87 ($79,300.06) $66,459.17 ($12,840.88) $9,956,035.04 88 ($79,300.06) $66,373.57 ($12,926.49) $9,943,108.55 89 ($79,300.06) $66,287.39 ($13,012.67) $9,930,095.89 90 ($79,300.06) $66,200.64 ($13,099.42) $9,916,996.47 91 ($79,300.06) $66,113.31 ($13,186.75) $9,903,809.72 92 ($79,300.06) $66,025.40 ($13,274.66) $9,890,535.06 93 ($79,300.06) $65,936.90 ($13,363.16) $9,877,171.91 94 ($79,300.06) $65,847.81 ($13,452.24) $9,863,719.66 95 ($79,300.06) $65,758.13 ($13,541.93) $9,850,177.74 96 ($79,300.06) $65,667.85 ($13,632.21) $9,836,545.53 97 ($79,300.06) $65,576.97 ($13,723.09) $9,822,822.45 98 ($79,300.06) $65,485.48 ($13,814.57) $9,809,007.87 99 ($79,300.06) $65,393.39 ($13,906.67) $9,795,101.20 100 ($79,300.06) $65,300.67 ($13,999.38) $9,781,101.82 101 ($79,300.06) $65,207.35 ($14,092.71) $9,767,009.11 102 ($79,300.06) $65,113.39 ($14,186.66) $9,752,822.44 103 ($79,300.06) $65,018.82 ($14,281.24) $9,738,541.20 104 ($79,300.06) $64,923.61 ($14,376.45) $9,724,164.76 105 ($79,300.06) $64,827.77 ($14,472.29) $9,709,692.46 106 ($79,300.06) $64,731.28 ($14,568.77) $9,695,123.69 107 ($79,300.06) $64,634.16 ($14,665.90) $9,680,457.79 108 ($79,300.06) $64,536.39 ($14,763.67) $9,665,694.12 109 ($79,300.06) $64,437.96 ($14,862.10) $9,650,832.02 110 ($79,300.06) $64,338.88 ($14,961.18) $9,635,870.85 111 ($79,300.06) $64,239.14 ($15,060.92) $9,620,809.93 112 ($79,300.06) $64,138.73 ($15,161.32) $9,605,648.61 113 ($79,300.06) $64,037.66 ($15,262.40) $9,590,386.21 114 ($79,300.06) $63,935.91 ($15,364.15) $9,575,022.06 115 ($79,300.06) $63,833.48 ($15,466.58) $9,559,555.48
116 ($79,300.06) $63,730.37 ($15,569.69) $9,543,985.79 117 ($79,300.06) $63,626.57 ($15,673.48) $9,528,312.31 118 ($79,300.06) $63,522.08 ($15,777.97) $9,512,534.33 119 ($79,300.06) $63,416.90 ($15,883.16) $9,496,651.17 120 ($79,300.06) $63,311.01 ($15,989.05) $9,480,662.12 x 121 ($79,300.06) $63,204.41 ($16,095.64) $9,464,566.48 122 ($79,300.06) $63,097.11 ($16,202.95) $9,448,363.53 123 ($79,300.06) $62,989.09 ($16,310.97) $9,432,052.57 124 ($79,300.06) $62,880.35 ($16,419.71) $9,415,632.86 125 ($79,300.06) $62,770.89 ($16,529.17) $9,399,103.69 126 ($79,300.06) $62,660.69 ($16,639.37) $9,382,464.32 127 ($79,300.06) $62,549.76 ($16,750.29) $9,365,714.03 128 ($79,300.06) $62,438.09 ($16,861.96) $9,348,852.07 129 ($79,300.06) $62,325.68 ($16,974.38) $9,331,877.69 130 ($79,300.06) $62,212.52 ($17,087.54) $9,314,790.15 131 ($79,300.06) $62,098.60 ($17,201.46) $9,297,588.70 132 ($79,300.06) $61,983.92 ($17,316.13) $9,280,272.56 133 ($79,300.06) $61,868.48 ($17,431.57) $9,262,840.99 134 ($79,300.06) $61,752.27 ($17,547.78) $9,245,293.21 135 ($79,300.06) $61,635.29 ($17,664.77) $9,227,628.44 136 ($79,300.06) $61,517.52 ($17,782.53) $9,209,845.90 137 ($79,300.06) $61,398.97 ($17,901.08) $9,191,944.82 138 ($79,300.06) $61,279.63 ($18,020.42) $9,173,924.40 139 ($79,300.06) $61,159.50 ($18,140.56) $9,155,783.83 140 ($79,300.06) $61,038.56 ($18,261.50) $9,137,522.34 141 ($79,300.06) $60,916.82 ($18,383.24) $9,119,139.10 142 ($79,300.06) $60,794.26 ($18,505.80) $9,100,633.30 143 ($79,300.06) $60,670.89 ($18,629.17) $9,082,004.13 144 ($79,300.06) $60,546.69 ($18,753.36) $9,063,250.77 145 ($79,300.06) $60,421.67 ($18,878.39) $9,044,372.38 146 ($79,300.06) $60,295.82 ($19,004.24) $9,025,368.14 147 ($79,300.06) $60,169.12 ($19,130.94) $9,006,237.21 148 ($79,300.06) $60,041.58 ($19,258.48) $8,986,978.73 149 ($79,300.06) $59,913.19 ($19,386.87) $8,967,591.87 150 ($79,300.06) $59,783.95 ($19,516.11) $8,948,075.76 151 ($79,300.06) $59,653.84 ($19,646.22) $8,928,429.54 152 ($79,300.06) $59,522.86 ($19,777.19) $8,908,652.34 153 ($79,300.06) $59,391.02 ($19,909.04) $8,888,743.30 154 ($79,300.06) $59,258.29 ($20,041.77) $8,868,701.53 155 ($79,300.06) $59,124.68 ($20,175.38) $8,848,526.15 156 ($79,300.06) $58,990.17 ($20,309.88) $8,828,216.27 157 ($79,300.06) $58,854.78 ($20,445.28) $8,807,770.99 158 ($79,300.06) $58,718.47 ($20,581.58) $8,787,189.41 159 ($79,300.06) $58,581.26 ($20,718.79) $8,766,470.61 160 ($79,300.06) $58,443.14 ($20,856.92) $8,745,613.69 161 ($79,300.06) $58,304.09 ($20,995.97) $8,724,617.73 162 ($79,300.06) $58,164.12 ($21,135.94) $8,703,481.79 163 ($79,300.06) $58,023.21 ($21,276.84) $8,682,204.94 164 ($79,300.06) $57,881.37 ($21,418.69) $8,660,786.25 165 ($79,300.06) $57,738.58 ($21,561.48) $8,639,224.77 166 ($79,300.06) $57,594.83 ($21,705.22) $8,617,519.55 167 ($79,300.06) $57,450.13 ($21,849.93) $8,595,669.62 168 ($79,300.06) $57,304.46 ($21,995.59) $8,573,674.03 169 ($79,300.06) $57,157.83 ($22,142.23) $8,551,531.80 170 ($79,300.06) $57,010.21 ($22,289.84) $8,529,241.95 171 ($79,300.06) $56,861.61 ($22,438.44) $8,506,803.51 172 ($79,300.06) $56,712.02 ($22,588.03) $8,484,215.48 173 ($79,300.06) $56,561.44 ($22,738.62) $8,461,476.86 174 ($79,300.06) $56,409.85 ($22,890.21) $8,438,586.64 175 ($79,300.06) $56,257.24 ($23,042.81) $8,415,543.83 176 ($79,300.06) $56,103.63 ($23,196.43) $8,392,347.40 177 ($79,300.06) $55,948.98 ($23,351.07) $8,368,996.33 178 ($79,300.06) $55,793.31 ($23,506.75) $8,345,489.58 179 ($79,300.06) $55,636.60 ($23,663.46) $8,321,826.12 180 ($79,300.06) $55,478.84 ($23,821.22) $8,298,004.90 181 ($79,300.06) $55,320.03 ($23,980.02) $8,274,024.88 182 ($79,300.06) $55,160.17 ($24,139.89) $8,249,884.99 183 ($79,300.06) $54,999.23 ($24,300.82) $8,225,584.16
184 ($79,300.06) $54,837.23 ($24,462.83) $8,201,121.33 185 ($79,300.06) $54,674.14 ($24,625.91) $8,176,495.42 186 ($79,300.06) $54,509.97 ($24,790.09) $8,151,705.33 187 ($79,300.06) $54,344.70 ($24,955.35) $8,126,749.98 188 ($79,300.06) $54,178.33 ($25,121.72) $8,101,628.25 189 ($79,300.06) $54,010.86 ($25,289.20) $8,076,339.05 190 ($79,300.06) $53,842.26 ($25,457.80) $8,050,881.26 191 ($79,300.06) $53,672.54 ($25,627.52) $8,025,253.74 192 ($79,300.06) $53,501.69 ($25,798.37) $7,999,455.38 193 ($79,300.06) $53,329.70 ($25,970.35) $7,973,485.02 194 ($79,300.06) $53,156.57 ($26,143.49) $7,947,341.53 195 ($79,300.06) $52,982.28 ($26,317.78) $7,921,023.75 196 ($79,300.06) $52,806.83 ($26,493.23) $7,894,530.52 197 ($79,300.06) $52,630.20 ($26,669.85) $7,867,860.67 198 ($79,300.06) $52,452.40 ($26,847.65) $7,841,013.01 199 ($79,300.06) $52,273.42 ($27,026.64) $7,813,986.38 200 ($79,300.06) $52,093.24 ($27,206.81) $7,786,779.56 201 ($79,300.06) $51,911.86 ($27,388.19) $7,759,391.37 202 ($79,300.06) $51,729.28 ($27,570.78) $7,731,820.59 203 ($79,300.06) $51,545.47 ($27,754.59) $7,704,066.00 204 ($79,300.06) $51,360.44 ($27,939.62) $7,676,126.39 205 ($79,300.06) $51,174.18 ($28,125.88) $7,648,000.51 206 ($79,300.06) $50,986.67 ($28,313.39) $7,619,687.12 207 ($79,300.06) $50,797.91 ($28,502.14) $7,591,184.98 208 ($79,300.06) $50,607.90 ($28,692.16) $7,562,492.82 209 ($79,300.06) $50,416.62 ($28,883.44) $7,533,609.38 210 ($79,300.06) $50,224.06 ($29,075.99) $7,504,533.39 211 ($79,300.06) $50,030.22 ($29,269.83) $7,475,263.55 212 ($79,300.06) $49,835.09 ($29,464.97) $7,445,798.59 213 ($79,300.06) $49,638.66 ($29,661.40) $7,416,137.19 214 ($79,300.06) $49,440.91 ($29,859.14) $7,386,278.04 215 ($79,300.06) $49,241.85 ($30,058.20) $7,356,219.84 216 ($79,300.06) $49,041.47 ($30,258.59) $7,325,961.25 217 ($79,300.06) $48,839.74 ($30,460.32) $7,295,500.93 218 ($79,300.06) $48,636.67 ($30,663.38) $7,264,837.55 219 ($79,300.06) $48,432.25 ($30,867.81) $7,233,969.74 220 ($79,300.06) $48,226.46 ($31,073.59) $7,202,896.15 221 ($79,300.06) $48,019.31 ($31,280.75) $7,171,615.40 222 ($79,300.06) $47,810.77 ($31,489.29) $7,140,126.12 223 ($79,300.06) $47,600.84 ($31,699.22) $7,108,426.90 224 ($79,300.06) $47,389.51 ($31,910.54) $7,076,516.36 225 ($79,300.06) $47,176.78 ($32,123.28) $7,044,393.07 226 ($79,300.06) $46,962.62 ($32,337.44) $7,012,055.64 227 ($79,300.06) $46,747.04 ($32,553.02) $6,979,502.62 228 ($79,300.06) $46,530.02 ($32,770.04) $6,946,732.58 229 ($79,300.06) $46,311.55 ($32,988.51) $6,913,744.07 230 ($79,300.06) $46,091.63 ($33,208.43) $6,880,535.64 231 ($79,300.06) $45,870.24 ($33,429.82) $6,847,105.82 232 ($79,300.06) $45,647.37 ($33,652.68) $6,813,453.14 233 ($79,300.06) $45,423.02 ($33,877.04) $6,779,576.10 234 ($79,300.06) $45,197.17 ($34,102.88) $6,745,473.22 235 ($79,300.06) $44,969.82 ($34,330.24) $6,711,142.99 236 ($79,300.06) $44,740.95 ($34,559.10) $6,676,583.88 237 ($79,300.06) $44,510.56 ($34,789.50) $6,641,794.39 238 ($79,300.06) $44,278.63 ($35,021.43) $6,606,772.96 239 ($79,300.06) $44,045.15 ($35,254.90) $6,571,518.05 240 ($79,300.06) $43,810.12 ($35,489.94) $6,536,028.12 241 ($79,300.06) $43,573.52 ($35,726.54) $6,500,301.58 242 ($79,300.06) $43,335.34 ($35,964.71) $6,464,336.87 243 ($79,300.06) $43,095.58 ($36,204.48) $6,428,132.39 244 ($79,300.06) $42,854.22 ($36,445.84) $6,391,686.55 245 ($79,300.06) $42,611.24 ($36,688.81) $6,354,997.74 246 ($79,300.06) $42,366.65 ($36,933.41) $6,318,064.33 247 ($79,300.06) $42,120.43 ($37,179.63) $6,280,884.70 248 ($79,300.06) $41,872.56 ($37,427.49) $6,243,457.21 249 ($79,300.06) $41,623.05 ($37,677.01) $6,205,780.20 250 ($79,300.06) $41,371.87 ($37,928.19) $6,167,852.01 251 ($79,300.06) $41,119.01 ($38,181.04) $6,129,670.97 252 ($79,300.06) $40,864.47 ($38,435.58) $6,091,235.39
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
253 ($79,300.06) $40,608.24 ($38,691.82) $6,052,543.57 254 ($79,300.06) $40,350.29 ($38,949.77) $6,013,593.80 255 ($79,300.06) $40,090.63 ($39,209.43) $5,974,384.37 256 ($79,300.06) $39,829.23 ($39,470.83) $5,934,913.54 257 ($79,300.06) $39,566.09 ($39,733.97) $5,895,179.57 258 ($79,300.06) $39,301.20 ($39,998.86) $5,855,180.71 259 ($79,300.06) $39,034.54 ($40,265.52) $5,814,915.20 260 ($79,300.06) $38,766.10 ($40,533.96) $5,774,381.24 261 ($79,300.06) $38,495.87 ($40,804.18) $5,733,577.06 262 ($79,300.06) $38,223.85 ($41,076.21) $5,692,500.85 263 ($79,300.06) $37,950.01 ($41,350.05) $5,651,150.80 264 ($79,300.06) $37,674.34 ($41,625.72) $5,609,525.08 265 ($79,300.06) $37,396.83 ($41,903.22) $5,567,621.86 266 ($79,300.06) $37,117.48 ($42,182.58) $5,525,439.28 267 ($79,300.06) $36,836.26 ($42,463.79) $5,482,975.48 268 ($79,300.06) $36,553.17 ($42,746.89) $5,440,228.60 269 ($79,300.06) $36,268.19 ($43,031.87) $5,397,196.73 270 ($79,300.06) $35,981.31 ($43,318.75) $5,353,877.98 271 ($79,300.06) $35,692.52 ($43,607.54) $5,310,270.45 272 ($79,300.06) $35,401.80 ($43,898.25) $5,266,372.19 273 ($79,300.06) $35,109.15 ($44,190.91) $5,222,181.29 274 ($79,300.06) $34,814.54 ($44,485.51) $5,177,695.77 275 ($79,300.06) $34,517.97 ($44,782.09) $5,132,913.69 276 ($79,300.06) $34,219.42 ($45,080.63) $5,087,833.05 277 ($79,300.06) $33,918.89 ($45,381.17) $5,042,451.88 278 ($79,300.06) $33,616.35 ($45,683.71) $4,996,768.17 279 ($79,300.06) $33,311.79 ($45,988.27) $4,950,779.90 280 ($79,300.06) $33,005.20 ($46,294.86) $4,904,485.05 281 ($79,300.06) $32,696.57 ($46,603.49) $4,857,881.56 282 ($79,300.06) $32,385.88 ($46,914.18) $4,810,967.38 283 ($79,300.06) $32,073.12 ($47,226.94) $4,763,740.44 284 ($79,300.06) $31,758.27 ($47,541.79) $4,716,198.65 285 ($79,300.06) $31,441.32 ($47,858.73) $4,668,339.92 286 ($79,300.06) $31,122.27 ($48,177.79) $4,620,162.12 287 ($79,300.06) $30,801.08 ($48,498.98) $4,571,663.15 288 ($79,300.06) $30,477.75 ($48,822.30) $4,522,840.85 289 ($79,300.06) $30,152.27 ($49,147.78) $4,473,693.06 290 ($79,300.06) $29,824.62 ($49,475.44) $4,424,217.63 291 ($79,300.06) $29,494.78 ($49,805.27) $4,374,412.35 292 ($79,300.06) $29,162.75 ($50,137.31) $4,324,275.05 293 ($79,300.06) $28,828.50 ($50,471.56) $4,273,803.49 294 ($79,300.06) $28,492.02 ($50,808.03) $4,222,995.46 295 ($79,300.06) $28,153.30 ($51,146.75) $4,171,848.70 296 ($79,300.06) $27,812.32 ($51,487.73) $4,120,360.97 297 ($79,300.06) $27,469.07 ($51,830.98) $4,068,529.99 298 ($79,300.06) $27,123.53 ($52,176.52) $4,016,353.46 299 ($79,300.06) $26,775.69 ($52,524.37) $3,963,829.09 300 ($79,300.06) $26,425.53 ($52,874.53) $3,910,954.57 301 ($79,300.06) $26,073.03 ($53,227.03) $3,857,727.54 302 ($79,300.06) $25,718.18 ($53,581.87) $3,804,145.67 303 ($79,300.06) $25,360.97 ($53,939.09) $3,750,206.58 304 ($79,300.06) $25,001.38 ($54,298.68) $3,695,907.90 305 ($79,300.06) $24,639.39 ($54,660.67) $3,641,247.23 306 ($79,300.06) $24,274.98 ($55,025.08) $3,586,222.15 307 ($79,300.06) $23,908.15 ($55,391.91) $3,530,830.25 308 ($79,300.06) $23,538.87 ($55,761.19) $3,475,069.06 309 ($79,300.06) $23,167.13 ($56,132.93) $3,418,936.13 310 ($79,300.06) $22,792.91 ($56,507.15) $3,362,428.98 311 ($79,300.06) $22,416.19 ($56,883.86) $3,305,545.11 312 ($79,300.06) $22,036.97 ($57,263.09) $3,248,282.02 313 ($79,300.06) $21,655.21 ($57,644.84) $3,190,637.18 314 ($79,300.06) $21,270.91 ($58,029.14) $3,132,608.04 315 ($79,300.06) $20,884.05 ($58,416.00) $3,074,192.04 316 ($79,300.06) $20,494.61 ($58,805.44) $3,015,386.59 317 ($79,300.06) $20,102.58 ($59,197.48) $2,956,189.11 318 ($79,300.06) $19,707.93 ($59,592.13) $2,896,596.98 319 ($79,300.06) $19,310.65 ($59,989.41) $2,836,607.57 320 ($79,300.06) $18,910.72 ($60,389.34) $2,776,218.23 321 ($79,300.06) $18,508.12 ($60,791.94) $2,715,426.30
322 ($79,300.06) $18,102.84 ($61,197.21) $2,654,229.08 323 ($79,300.06) $17,694.86 ($61,605.20) $2,592,623.89 324 ($79,300.06) $17,284.16 ($62,015.90) $2,530,607.99 325 ($79,300.06) $16,870.72 ($62,429.34) $2,468,178.65 326 ($79,300.06) $16,454.52 ($62,845.53) $2,405,333.12 327 ($79,300.06) $16,035.55 ($63,264.50) $2,342,068.62 328 ($79,300.06) $15,613.79 ($63,686.27) $2,278,382.35 329 ($79,300.06) $15,189.22 ($64,110.84) $2,214,271.51 330 ($79,300.06) $14,761.81 ($64,538.25) $2,149,733.26 331 ($79,300.06) $14,331.56 ($64,968.50) $2,084,764.76 332 ($79,300.06) $13,898.43 ($65,401.63) $2,019,363.14 333 ($79,300.06) $13,462.42 ($65,837.64) $1,953,525.50 334 ($79,300.06) $13,023.50 ($66,276.55) $1,887,248.95 335 ($79,300.06) $12,581.66 ($66,718.40) $1,820,530.55 336 ($79,300.06) $12,136.87 ($67,163.19) $1,753,367.36 337 ($79,300.06) $11,689.12 ($67,610.94) $1,685,756.42 338 ($79,300.06) $11,238.38 ($68,061.68) $1,617,694.74 339 ($79,300.06) $10,784.63 ($68,515.43) $1,549,179.32 340 ($79,300.06) $10,327.86 ($68,972.19) $1,480,207.12 341 ($79,300.06) $9,868.05 ($69,432.01) $1,410,775.11 342 ($79,300.06) $9,405.17 ($69,894.89) $1,340,880.22 343 ($79,300.06) $8,939.20 ($70,360.86) $1,270,519.37 344 ($79,300.06) $8,470.13 ($70,829.93) $1,199,689.44 345 ($79,300.06) $7,997.93 ($71,302.13) $1,128,387.31 346 ($79,300.06) $7,522.58 ($71,777.47) $1,056,609.84 347 ($79,300.06) $7,044.07 ($72,255.99) $984,353.85 348 ($79,300.06) $6,562.36 ($72,737.70) $911,616.15 349 ($79,300.06) $6,077.44 ($73,222.62) $838,393.53 350 ($79,300.06) $5,589.29 ($73,710.77) $764,682.77 351 ($79,300.06) $5,097.89 ($74,202.17) $690,480.60 352 ($79,300.06) $4,603.20 ($74,696.85) $615,783.74 353 ($79,300.06) $4,105.22 ($75,194.83) $540,588.91 354 ($79,300.06) $3,603.93 ($75,696.13) $464,892.78 355 ($79,300.06) $3,099.29 ($76,200.77) $388,692.01 356 ($79,300.06) $2,591.28 ($76,708.78) $311,983.23 357 ($79,300.06) $2,079.89 ($77,220.17) $234,763.06 358 ($79,300.06) $1,565.09 ($77,734.97) $157,028.09 359 ($79,300.06) $1,046.85 ($78,253.20) $78,774.89 360 ($79,300.06) $525.17 ($78,774.89) ($0.00)
Assignment #1 BU.241.630.41.FA23 Real Estate Products and Emerging Trends Comparable Data Expense Data Location Min Max Mean Median Insurance 434 502 473 477 Common Are 64 199 123 114 Heat/Fuel 454 685 586 595 Water & Sew 1,003 1,039 1,017 1,009 Payroll & Rel 200 283 231 220 Repairs & Ma 452 582 503 481 Average 2,607 3,290 2,933 2,896 Historical 2018 Historical 2019 Proforma 2020/2021 Expense $/Annum $/unit $/Annum $/Unit $/Annum $/Unit Real Estate T 238,440 4,866 248,412 5,070 258,292 5,271 Insurance 36,000 735 38,274 781 37,000 755 Common Are 9,800 200 9,344 191 10,000 204 Water & Sew 49,000 1,000 50,508 1,031 48,000 980 Fuel 57,000 1,163 57,056 1,164 60,000 1,224 Payroll 49,000 1,000 81,765 1,669 44,000 898 Repairs & Ma 54,848 1,119 62,643 1,278 23,000 469
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help