Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Number Leelawadee UNABLE TO REFRESH We couldn't get updated values from a linked workbook. ab Manage Workbook Links 5 XVfx -4614.61 C DE F
Number Leelawadee UNABLE TO REFRESH We couldn't get updated values from a linked workbook. ab Manage Workbook Links 5 XVfx -4614.61 C DE F G H > tA > 1810 40 .00 .00 0 L M N 0 P Q R S TUV W X Y Z AA AB AC AAAC AH A Workbook Link 2018 2019 Trailing 12 (Sep. 2020) 2020 Budget Links Settings Select the Operating Year 2017 19 Loss 8 9 10 Revenue and Expense Schedule Austin Apartment 12 ES 13 15 16 17 cy 18 essions Rental Income Vacancy Concessions Credit Loss 2017 2018 2019 Total Per Unit Total Per Unit Total Per Unit Trailing 12 (Sep. 2020) Total Per Unit 2020 Budget Total POTENTIAL GROSS REVENUE Per Unit NEW Change you Now you can choose links and customize r Settings tab. Learn more $5,374,886 $15,183 $5,491,987 $15,514 $5,735,364 $16,202 (242,876) (686) (207,926) (587) (179,876) (508) (14,838) (42) (1,468) (4) (295) (1) $5,874,138 (229,878) 0 $16,594 (649) $5,979,933 (248,899) 0 $16,892 (703) 0 #VALUE! #VALUE! 0 (4,615) (13) 20 Is Model Units #VALUE! #VALUE! 0 (44,614) (126) #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! Refresh All Brea #VALUE! 25 TOTAL RENTAL REVENUE #VALUE! #VALUE! #VALUE! #VALUE! 5,505,964 $15,554 #VALUE! #VALUE! #VALUE! #VALUE! h 27 Income Other Income 187,692 530 226,627 640 205,032 579 173,633 490 215,493 609 28 g Parking Income 90,773 256 80,915 229 87,251 246 88,119 249 86,271 Austin Apartment Ex A File not in the clou 244 29 RUBS 343,552 970 332,489 939 346,599 979 353,371 998 351,274 992 37 EFFECTIVE GROSS REVENUE #VALUE! #VALUE! #VALUE! #VALUE! $6,144,846 $17,358 #VALUE! #VALUE! #VALUE! #VALUE! 38 40 EXPENSES 41 Reimbursable 42 Real Estate Taxes 1,223,680 3,457 1,268,697 3,584 1,355,401 3,829 1,379,595 3,897 1,442,308 4,074 43 Insurance 48,695 138 29,106 82 49,384 140 87,186 246 65,922 186 44 Repairs & Maintenance 89,291 252 101,732 287 91,120 257 88,511 250 82,106 232 45 act Contract Services 126,406 357 181,870 514 181,114 512 207,175 585 176,828 500 46 orate Redecorating 128,797 364 147,167 416 131,049 370 127,017 359 138,148 390 47 11 Payroll 492,384 1,391 492,372 1,391 536,157 1,515 513,934 1,452 539,091 1523 49 50 es 51 52 ine 53 Management Utilities General & Administrative Marketing Reserves for Replacement 156,150 441 161,640 457 170,217 481 164,915 466 174,227 492 359,973 1,017 300,460 849 277,084 783 297,557 841 270,424 764 89,983 254 95,899 271 82,340 233 80,474 227 86,234 244 87.585 247 98.155 277 80.942 229 91.329 0 0 0 0 0 258 0 80.634 228 < = Valuation Inputs Rent Roll Recent Leasing Summary Unit Mix Historicals and Budget Stabilized R&E Dire +
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