Multifamily Revenues_Method 1_Solution

.xlsx

School

University of Florida *

*We aren’t endorsed by this school

Course

6045

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

16

Uploaded by Colonel_World_Turkey15

Report
Inputs Property Overview Name Multifamily Property Type Multifamily Location Boston, MA Units 150 Year Built 2015 Acquisition Assumptions Acquisition Date 12/31/2020 Hold Period Purchase Price Acquisition Closing Costs Drivers In-place Income (T-3) Assumption Total Occupancy 88% Effective Rent / Month $1,220 Net Effective Rent 2,195,977 Vacancy Loss (262,880) Non-Revenue Units 0.7% (15,555) Bad Debt 0.7% (15,848) Total Rental Income $1,901,695
Utility Reimbursement 45,238 Other Income 131,909 Total Income $2,078,842 Revenue Assumptions Rent Year Occupancy Growth 1 90% 0.0% 2 91% 2.0% 3 92% 3.0% 4 93% 3.0% 5 93% 3.0% 6 93% 3.0% 7 93% 3.0% 8 93% 3.0% 9 93% 3.0% 10 93% 3.0% Capital Expenditures Schedule Start End Duration Defensive Offensive 3/31/2021 3/31/2022 12 Months Unit Renovations Units Renovated Remaining Units 100% 150 Units Renovated / Month 13 Cost / Unit $6,000 Rent Premium $125 ROI 25.0%
Other Revenue Growth 0.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% Unit Mix Type Size Count % of Total Studio 500 15 10.0% 1 BR, 1 BA 750 80 53.3% 2 BR, 2 BA 1,250 50 33.3% 3 BR, 2 BA 1,500 5 3.3% Total 917 150 100%
Model Acq Date 12/31/2020 Size 150 T-3 T-12 Units Unrenovated Units Renovated Unrenovated Effective Rent Renovated Effective Rent Rent Growth INCOME Net Effective Rent 2,195,977 2,167,002 Vacancy Loss (262,880) (259,411) Non-Revenue Units (15,555) (15,349) Bad Debt (15,848) (15,639) Total Rental Income $1,901,695 $1,876,603 Effective Rent / Month $1,220 $1,204 Physical Occupancy 88% 88% Utility Reimbursement 45,238 44,641 Other Revenue 131,909 130,169 Total Other Revenue $177,147 $174,810 TOTAL INCOME $2,078,842 $2,051,413
Year 0 Year 1 Year 1 Year 1 Year 1 Year 1 Month 0 Month 1 Month 2 Month 3 Month 4 Month 5 12/31/2020 1/31/2021 2/28/2021 3/31/2021 4/30/2021 5/31/2021 150 150 150 138 125 113 13 25 38 $1,220 $1,220 $1,220 $1,220 $1,220 $1,220 $1,345 $1,345 $1,345 $1,345 $1,345 $1,345 182,998 182,998 184,561 186,123 187,686 (18,300) (18,300) (18,456) (18,612) (18,769) (1,296) (1,296) (1,307) (1,318) (1,329) (1,321) (1,321) (1,332) (1,343) (1,354) $162,081 $162,081 $163,465 $164,849 $166,233 $1,220 $1,220 $1,230 $1,241 $1,251 90% 90% 90% 90% 90% 3,770 3,770 3,770 3,770 3,770 10,992 10,992 10,992 10,992 10,992 $14,762 $14,762 $14,762 $14,762 $14,762 $176,844 $176,844 $178,228 $179,611 $180,995
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