Multifamily Expenses_Solution

.xlsx

School

University of Florida *

*We aren’t endorsed by this school

Course

6045

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

32

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 49,573 Other Income 127,574 Total Income $2,078,842 Revenue & Expense 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% 11 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%
In-place Expenses % Per Unit Total Repairs & Maintenance 400 60,000 Turnover 150 22,500 Marketing 150 22,500 General & Administrative 250 37,500 Payroll 600 90,000 Management Fees 3.0% 380 57,051 Utilities 300 45,000 Real Estate Taxes 2,667 400,000
Property Insurance 200 30,000 Subtotal $5,097 $764,551 Capital Reserves 200 30,000 Total $5,297 $794,551 Other Revenue Expense RET Growth Growth Growth 0.0% 0.0% 0.0% 3.0% 2.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.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%
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