Assignment #1 -Solution
xlsx
keyboard_arrow_up
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
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
Related Documents
Related Questions
Question No. 18
arrow_forward
7:57 En
X
Basic Appraisal Principle... LO :
appraisaltests.com
Basic Appraisal Princi
If a property has a net
operating income of
$50,000 and the
capitalization rate is
9.5%, what is the
estimated value?
(rounded)
$525,000
$50,000
$475,000
$600,000
arrow_forward
8
arrow_forward
PROBLEM 38Barcelona Company owns the following properties on December 31, 2020:a. Land intended for sale - P1,000,000b. Building, in the process of construction for rentals - 3,000,000c. Equipment for lease under operating lease - 500,000d. Land held for undetermined use - 2,500,000e. Building intended for leased out under finance lease - 2,800,000f. Land held for future factory site - 1,200,000g. Building use for rentals. A small part of the buildingis used as a satellite administrative office - 4,000,000h. Hotel building on which Barcelona Company providesmonthly maintenance services - 3,500,000
Requirements:1. How do you classify each of the items mentioned above?2. Compute the investment property on December 31, 2020.
arrow_forward
What do i enter for the actual interest part
arrow_forward
0.4KB/s ll
4G+
1:03 PM
65
וח
00:58:13 Remaining
Multiple Choice
Which of the following items is not
chargeable to the land account?
Expenditures for fence, water system,
sidewalk and pavement
Cost of survey by engineers
Broker's commission and fees for registration
and title transfer
Attorney's fee and any other expenditures for
establishing clean title
57 of 75
II
arrow_forward
Question 15
arrow_forward
Question Content AreaDuring 2023, Jamal and Judy, a married couple, decided to sell their residence,
which had a basis of $300,000. They had owned and occupied the residence for 20 years. To make it more
attractive to prospective buyers, they had the outside painted in April at a cost of $6,000 and paid for the
work immediately. They sold the house in May for $880,000. Broker's commissions and other selling
expenses amounted to $53, 000. Since they both are age 68, the couple decides to move into a rented
apartment. What is the recognized gain? a. $17,000 b. $527,000 c. $0 d. $27,000
arrow_forward
As the owner of a business, Karen needs fire insurance. Her building is worth $726,000 and the contents are valued at $673,000.
Her agent placed the building in structural classification B and area rating 2. Use Table 19-4 to calculate her total premium.
Round your answer to the nearest cent.
arrow_forward
question in ss below
thanks
45
46
42
52
26
arrow_forward
Question No. 13
arrow_forward
* CengageNOW2 | Online teachin x
+
ignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
它 ☆
SU login
O Digital University |..
Tenant Portal - Login
围
eBook
Show Me How
E Print Item
Straight-Line Depreciation
A building acquired at the beginning of the year at a cost of $93,600 has an estimated residual value of $3,600 and an estimated useful life
of 10 years. Determine the following:
a. The depreciable cost
90,000
10
b. The straight-line rate
c. The annual straight-line depreciation
90,000
X
Feedback
V Check My Work
ifference betwee
the asset's initial cost and its residual value. The residual value is the estimated value at
Depreciable cost is the
the end of the useful life.
Straight-line depreciation allocates the depreciable cost of the asset equally over the expected useful life.
10:22 PM
46%
-2°F
12/16/2021
F11
F10
F8
F7
1%/
6.
4.
R.
* CO
5
arrow_forward
Year
2
5678 A WN
3
4
3-Year
33.33%
44.45
14.81
7.41
Property Class
5-Year
20.00%
32.00
19.20
11.52
11.52
5.76
7-Year
14.29%
24.49
17.49
12.49
8.93
8.92
8.93
4.46
arrow_forward
Problem 26-5 (IAA)
(AA) 605 oldoy
Nicko Company purchased a tract of land as a factory site.
An old building was demolished and construction began on
the new building.
Purchase price of land and an old building
Fair value of old building
Cost of demolishing old building
Title insurance and legal fees to purchase land
4,500,000
250,000
300,000
200,000
950,000
8,000,000
100,000
Architect fee
New building construction cost
Survey before construction
Building permit or payment to city hall for
approval of building construction
Excavation before new construction
Liability insurance during construction
New fence surrounding the new building
Driveway, parking bay and safety lighting
Cost of trees, shrubs and other landscaping
Cost of lighting and signage
150,000
200,000
100,000
100,000
550,000
300,000
100,000
1. What is the cost of the land?
a. 4,550,000
b. 4,800,000
c. 4,850,000
d. 4,450,000
2. What is the cost of the new building?
a. 9,700,000
b. 9,750,000
c. 9,800,000
d. 9,950,000
3. What…
arrow_forward
ng Objective 1
S10-1 Determining the cost of an asset
Highland Clothing purchased land, paying $96,000 cash and signing a $300,000 note
payable. In addition, Highland paid delinquent property tax of $1,100, title insurance
costing $600, and $4,600 to level the land and remove an unwanted building. Record
the journal entry for purchase of the land.
arrow_forward
Dear expert solve correctly and in detail =2 upvotes
arrow_forward
Oa. $119,42
Ob. $123,434
Oc. $159,374
Od. $138,273
48
6
A building with an appraisal value of $138,273 is made available at an offer price of $159,374. The purchaser acquires the property for $35,940 in cash, a 90-
day note payable for $24,302, and a mortgage amounting to $59,197. The cost of the building to be reported on the balance sheet is
Y
H
Q Search
&
1-
7
U
ra
8
L
1914
K
IAA
(
9
fio
▶11
O
O
J
L
99+
Std...
PAI
P
MLA Formatting an...
ins
prt sc
General Format // P....
←
delete
Previous
backspace
ENG
INTL
home
InterpreterDetails
enter
Next >
num
lock
5:11 PM
2/19/2023
end
7
home
C
arrow_forward
A v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentM... Q ☆
Tp *
pter 10 HW
eBook
Allocating Payments and Receipts to Fixed Asset Accounts
The following payments and receipts are related to land, land improvements, and buildings acquired for use in a wholesale ceramic business. The receipts are identified by an asterisk.
a.
Fee paid to attorney for title search
$3,200
b.
Cost of real estate acquired as a plant site: Land
335,600
Building (to be demolished)
31,900
C.
Delinquent real estate taxes on property, assumed by purchaser
18,900
Cost of tearing down and removing building acquired in (b)
5,300
e.
Proceeds from sale of salvage materials from old building
3,100*
Special assessment paid to city for extension of water imain to the property
12,600
9.
Architect's and engineer's fees for plans and supervision
46,100
h. Premium on one-year insurance policy during construction
4,400
i.
Cost of filling and grading land
18,500
Money borrowed to pay building contractor
787,000*
k. Cost of…
arrow_forward
solve this answer plsss
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,



Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,

Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
Related Questions
- Question No. 18arrow_forward7:57 En X Basic Appraisal Principle... LO : appraisaltests.com Basic Appraisal Princi If a property has a net operating income of $50,000 and the capitalization rate is 9.5%, what is the estimated value? (rounded) $525,000 $50,000 $475,000 $600,000arrow_forward8arrow_forward
- PROBLEM 38Barcelona Company owns the following properties on December 31, 2020:a. Land intended for sale - P1,000,000b. Building, in the process of construction for rentals - 3,000,000c. Equipment for lease under operating lease - 500,000d. Land held for undetermined use - 2,500,000e. Building intended for leased out under finance lease - 2,800,000f. Land held for future factory site - 1,200,000g. Building use for rentals. A small part of the buildingis used as a satellite administrative office - 4,000,000h. Hotel building on which Barcelona Company providesmonthly maintenance services - 3,500,000 Requirements:1. How do you classify each of the items mentioned above?2. Compute the investment property on December 31, 2020.arrow_forwardWhat do i enter for the actual interest partarrow_forward0.4KB/s ll 4G+ 1:03 PM 65 וח 00:58:13 Remaining Multiple Choice Which of the following items is not chargeable to the land account? Expenditures for fence, water system, sidewalk and pavement Cost of survey by engineers Broker's commission and fees for registration and title transfer Attorney's fee and any other expenditures for establishing clean title 57 of 75 IIarrow_forward
- Question 15arrow_forwardQuestion Content AreaDuring 2023, Jamal and Judy, a married couple, decided to sell their residence, which had a basis of $300,000. They had owned and occupied the residence for 20 years. To make it more attractive to prospective buyers, they had the outside painted in April at a cost of $6,000 and paid for the work immediately. They sold the house in May for $880,000. Broker's commissions and other selling expenses amounted to $53, 000. Since they both are age 68, the couple decides to move into a rented apartment. What is the recognized gain? a. $17,000 b. $527,000 c. $0 d. $27,000arrow_forwardAs the owner of a business, Karen needs fire insurance. Her building is worth $726,000 and the contents are valued at $673,000. Her agent placed the building in structural classification B and area rating 2. Use Table 19-4 to calculate her total premium. Round your answer to the nearest cent.arrow_forward
- question in ss below thanks 45 46 42 52 26arrow_forwardQuestion No. 13arrow_forward* CengageNOW2 | Online teachin x + ignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false 它 ☆ SU login O Digital University |.. Tenant Portal - Login 围 eBook Show Me How E Print Item Straight-Line Depreciation A building acquired at the beginning of the year at a cost of $93,600 has an estimated residual value of $3,600 and an estimated useful life of 10 years. Determine the following: a. The depreciable cost 90,000 10 b. The straight-line rate c. The annual straight-line depreciation 90,000 X Feedback V Check My Work ifference betwee the asset's initial cost and its residual value. The residual value is the estimated value at Depreciable cost is the the end of the useful life. Straight-line depreciation allocates the depreciable cost of the asset equally over the expected useful life. 10:22 PM 46% -2°F 12/16/2021 F11 F10 F8 F7 1%/ 6. 4. R. * CO 5arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education

Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,



Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,

Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education