BROKER OPINION OF VALUE 150 Units | Built 1987 144 W. Calle Primera San Ysidro, CA 92173
INVESTMENT ADVISORS BRANDON GRISHAM
Senior Managing Director 253.653.3313 brandon.grisham@berkadia.com
RACHEL PARSONS
Senior Managing Director 949.242.4082 rachel.parsons@berkadia.com
JORDAN SKYLES
Director 208.631.4981 jordan.skyles@berkadia.com
JEFF IRISH
Senior Managing Director 208.286.5013 jeff.irish@berkadia.com
MIKE TERRY
Director 425.761.1640 mike.terry@berkadia.com
ADAM TOMBERG
Director 425.999.1152 adam.tomberg@berkadia.com
BOISE OFFICE 6225 North Meeker Place Suite 210 Boise, ID 83713
IRVINE OFFICE 3333 Michelson Drive Suite 620 Irvine CA 92612 www.Berkadia.com
FINANCIAL ANALYSIS
3
BOV
PRICE PER UNIT
PROFORMA NOI
PROFORMA
$31,500,000
$210,000
$1,845,708
5.86%
CAP R ATE
UNIT MIX
SET-ASIDE
NUMBER OF UNITS
UNIT SIZE (RSF)
AVERAGE RENT
PROFORMA INCREASE
PROFORMA RENT
MAX RENT
PROJECTED UA
MAX NET RENT
1 BD 1 BTH - Unrenovated
80%
28
650
$1,399
$604
$2,003
$2,068
$65
$2,003
1 BD 1 BTH - Partially Renovated
80%
1
650
$1,737
$266
$2,003
$2,068
$65
$2,003
1 BD 1 BTH - Renovated
80%
7
650
$1,699
$304
$2,003
$2,068
$65
$2,003
36
23,400
$52,791
$19,317
$72,108
$74,448
$72,108
650
$1,466
$537
$2,003
$2,068
$2,003
UNIT TYPE
1 BD UNIT TOTAL 1 BD UNIT AVG 2 BD 1 BTH - Unrenovated
80%
48
716
$1,643
$756
$2,399
$2,482
$83
$2,399
2 BD 1 BTH - Partially Renovated
80%
3
716
$2,090
$309
$2,399
$2,482
$83
$2,399
2 BD 1 BTH - Renovated
80%
5
716
$2,322
$77
$2,399
$2,482
$83
$2,399
2 BD 2 BTH - Unrenovated
80%
28
763
$1,654
$745
$2,399
$2,482
$83
$2,399
2 BD 2 BTH - Renovated
80%
2
763
$2,292
$107
$2,399
$2,482
$83
$2,399
86
62,986
$147,635
$58,679
$206,314
$213,452
$206,314
732
$1,717
$682
$2,399
$2,482
$2,399
2 BD UNIT TOTAL 2 BD UNIT AVG 3 BD 2 BTH - Unrenovated
80%
22
850
$2,022
$743
$2,765
$2,867
$102
$2,765
3 BD 2 BTH - Partially Renovated
80%
2
850
$2,555
$211
$2,765
$2,867
$102
$2,765
3 BD 2 BTH - Renovated
80%
4
850
$2,684
$81
$2,765
$2,867
$102
$2,765
28
23,800
$60,324
$17,096
$77,420
$80,276
$77,420
850
$2,154
$611
$2,765
$2,867
$2,765
110,186
$260,750
$95,092
$355,842
$368,176
$355,842
735
$1,738
$2,372
$2,455
$2,372
3 BD UNIT TOTAL 3 BD UNIT AVG
TOTAL AVERAGE
150
*The unit mix above was based on the 11/7/23 rent roll and estimated Utility Allowances calculated on the Housing Authority of the County of San Diego worksheet effective 12/1/2022. Average Rent above reflects the average of in-place rents for each floorplan for units without subsidy vouchers. As of the 11/7/23 rent roll, there are 9 units that are occupied by a tenant with a subsidy voucher accounting for 2.87% of total rental revenue.
4
RENT & INCOME LIMITS
Area Median Income: $116,800
San Diego County Effective Year: 2023
Unit Breakdown by Unit Type
19%
PROPERTY INCOME LIMITS
24%
57%
1 BD
2 BD
3 BD
Average Rents to Max Net Rents $3,000
$2,154
$2,003
$2,000
$1,717 $1,466
$1,000 $500 $0 1 BD
2 BD Average Rent
5
INCOME
80%
1 Person
$77,200
2 Person
$88,240
3 Person
$99,280
4 Person
$110,240
5 Person
$119,120
6 Person
$127,920
7 Person
$136,720
MAXIMUM ALLOWABLE RENTS Set Aside
Unit Type
# of Units
Max Rent
UA
Max Net Rent
80%
1 BD
36
$2,068
$65
$2,003
80%
2 BD
86
$2,482
$83
$2,399
80%
3 BD
28
$2,867
$102
$2,765
$2,765 $2,399
$2,500
$1,500
Mar at Chavez will be required to hold the maximum rent charged at or below a level considered appropriate for the households that have incomes at or below 80% of the local Area Median Income (AMI) for the county.
Net Max Rent
3 BD
HISTORICAL RENT & INCOME LIMITS SAN DIEGO COUNTY | CALIFORNIA AMI GROWTH
2 BD 80% RENT GROWTH $2,700
$121,000 $116,000 $111,000 $106,000
5 Yr Avg
7.44%
$2,500
5 Yr Avg
7.23%
10 Yr Avg
4.99%
$2,300
10 Yr Avg
5.31%
$101,000
$2,100
$96,000
$1,900
$91,000
$1,700
$86,000
$1,500
$81,000
$1,300
$76,000 $71,000
$1,100
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2023
2024
FMR GROWTH 1, 2, & 3 BD UNITS $3,000 $2,800
5 Yr Avg
6.29%
$2,600
10 Yr Avg
7.57%
$2,400 $2,200 $2,000 $1,800 $1,600 $1,400 2014
6
2015
2016
2017
2018
2019
2020
2021
2022
FINANCIAL SUMMARY
Name Address City, State, Zip County Market Segment
PROPERTY INFORMATION
Mar at Chavez 144 W. Calle Primera San Ysidro, CA 92173 San Diego Family
Year Built QCT/DDA Designated Opportunity Zone
1987 Yes No
Total Number of Units Net Rentable Square Feet
150 110,186 SF
FINANCIAL SUMMARY PRICING FIGURES - WITH PROPOSED NEW FINANCING BROKER'S OPINION OF VALUE Price per Unit Price per SF PROFORMA 10-Year Leveraged Cash IRR%* Closing Cost Capital Expense Total Acquisition Cost
Low $29,500,000 $196,667 $267.73
High $31,500,000 $210,000 $285.88
22.00%
19.56%
$150,000 $2,175,000 $31,825,000
$150,000 $2,175,000 $33,825,000
*IRR Analysis assumes $150,000 in Closing Costs, $14,500 per unit in Capital Expense, 7.00% exit cap, with a 3.00% cost of sale.
7
IMPORTANT INFORMATION & DISCLAIMER: The information contained herein is assumed to be correct and market-supported. Output produced from this model should not be considered an appraisal. Projections are forecasts and are not to be considered fact. The information contained in this file is privileged and confidential; it is intended only for use by Berkadia® and their clients. This file may not be reproduced physically or in electronic format without the express written consent of Berkadia. Not responsible for errors and omissions.
FINANCIAL SUMMARY FINANCING PROPOSED NEW FINANCING
Low Agency 75.00% 6.00% 36 30 1.24
High Agency 72.63% 6.00% 36 30 1.20
Total Acquisition Cost Total Loan Amount Loan Fee @ 1.00% Down Payment
$31,825,000 $22,125,000 $221,250 $9,921,250
$33,825,000 $22,880,000 $228,800 $11,173,800
Annual Debt Service - I/O Annual Debt Service - P&I
$1,327,500 $1,591,807
$1,372,800 $1,646,126
Date of Evaluation 10-Year Treasury Note as of Date of Evaluation
12/5/2023 4.21%
12/5/2023 4.21%
Program Loan to Value % Interest Rate Interest Only Period (Months) Amortization Period (Years) Debt Coverage Ratio
8
VITAL DATA YE 2022 CAP Rate NOI Year 1 Debt Service Net Cash Flow After Debt Service Cash on Cash %
Low 4.81% $1,417,772 $1,327,500 $90,272 0.91%
High 4.50% $1,417,772 $1,372,800 $44,972 0.40%
Trailing-12 (October '23) CAP Rate NOI Year 1 Debt Service Net Cash Flow After Debt Service Cash on Cash %
Low 5.54% $1,634,230 $1,327,500 $306,730 3.09%
High 5.19% $1,634,230 $1,372,800 $261,430 2.34%
T-3 Revenue /T-12 Expenses CAP Rate NOI Year 1 Debt Service Net Cash Flow After Debt Service Cash on Cash %
Low 6.10% $1,799,486 $1,327,500 $471,986 4.76%
High 5.71% $1,799,486 $1,372,800 $426,686 3.82%
T-3 Revenue / Underwritten Exp CAP Rate NOI Year 1 Debt Service Net Cash Flow After Debt Service Cash on Cash %
Low 5.96% $1,759,287 $1,327,500 $431,787 4.35%
High 5.59% $1,759,287 $1,372,800 $386,487 3.46%
PROFORMA CAP Rate NOI Year 1 Debt Service Net Cash Flow After Debt Service Cash on Cash %
Low 6.26% $1,845,708 $1,327,500 $518,208 5.22%
High 5.86% $1,845,708 $1,372,800 $472,908 4.23%
IN T E R E S T R AT E S E N S I T I V I T Y INTEREST RATE SENSITIVITY
9
Interest Rate
6.00%
6.10%
6.20%
6.30%
6.40%
6.50%
6.60%
6.70%
6.80%
6.90%
7.00%
Loan Amount
$22,880,000
$22,636,643
$22,397,359
$22,162,020
$21,930,548
$21,702,866
$21,478,898
$21,258,571
$21,041,812
$20,828,553
$20,618,723
Proforma NOI Year 1 Debt Service Lev. Cash Flow DCR
$1,845,708 $1,372,800 $472,908 1.34
$1,845,708 $1,380,835 $464,873 1.34
$1,845,708 $1,388,636 $457,071 1.33
$1,845,708 $1,396,207 $449,500 1.32
$1,845,708 $1,403,555 $442,153 1.32
$1,845,708 $1,410,686 $435,021 1.31
$1,845,708 $1,417,607 $428,100 1.30
$1,845,708 $1,424,324 $421,384 1.30
$1,845,708 $1,430,843 $414,865 1.29
$1,845,708 $1,437,170 $408,538 1.28
$1,845,708 $1,443,311 $402,397 1.28
Sale Price Acquisition Basis Equity Required Proforma Cash on Cash Proforma Cap Rate
$31,500,000 $36,607,600 $11,173,800 4.23% 5.86%
$31,066,788 $36,174,388 $10,983,945 4.23% 5.94%
$30,643,182 $35,750,782 $10,799,623 4.23% 6.02%
$30,228,956 $35,336,556 $10,620,736 4.23% 6.11%
$29,823,871 $34,931,471 $10,447,123 4.23% 6.19%
$29,427,694 $34,535,294 $10,278,628 4.23% 6.27%
$29,040,198 $34,147,798 $10,115,100 4.23% 6.36%
$28,661,163 $33,768,763 $9,956,392 4.23% 6.44%
$28,290,375 $33,397,975 $9,802,362 4.23% 6.52%
$27,927,624 $33,035,224 $9,652,871 4.23% 6.61%
$27,572,708 $32,680,308 $9,507,786 4.23% 6.69%
Estimated Change in Value
$0
($435,000)
($855,000)
($1,270,000)
($1,675,000)
($2,070,000)
($2,460,000)
($2,840,000)
($3,210,000)
($3,570,000)
($3,925,000)
INCOME & EXPENSES
Trailing-12 (October '23)
YE 2022
PER UNIT
(8.42%)
$2,992,302 ($251,871) $2,740,431
$19,949 ($1,679) $18,270
(19.41%)
1.32% 3.04% 0.00% 4.37%
($36,254) ($83,440) $0 ($119,694)
($242) ($556) $0 ($798)
1.74% 0.15% 0.00% 1.89%
$2,620,737
Other Income Late Fees Application Fees Lease Termination Fees Damage & Cleaning Fees Misc. Other Income Total Other Income EFFECTIVE GROSS INCOME
OPERATIONAL ANALYSIS
T-3 Revenue / T-12 Expenses
PER UNIT
T-3 Revenue / Underwritten Exp
PER UNIT
PER UNIT
PROFORMA
PER UNIT
$4,270,104 ($854,021) $3,416,083 10.99%
$28,467 ($5,693) $22,774 (1)
($170,804) ($17,080) $0 ($187,885)
($1,139) (2) ($114) $0 ($1,253)
INCOME Gross Potential Rent Gain (Loss) to Lease POTENTIAL RENTAL INCOME % Increase over Prior Year Economic Loss Vacancy Loss Bad Debt Concessions Total Economic Loss NET RENTAL INCOME
$3,598,325 ($698,556) $2,899,769 5.81%
$23,989 ($4,657) $19,332
(23.19%)
$4,007,040 ($929,280) $3,077,760 6.14%
$26,714 ($6,195) $20,518
(23.19%)
($50,566) ($4,246) $0 ($54,812)
($337) ($28) $0 ($365)
2.05% 0.15% 0.00% 2.19%
$17,472
$2,844,957
$6,000 $1,807 $0 $640 $18,276 $26,723
$40 $12 $0 $4 $122 $178
$2,647,460
$17,650
$4,007,040 ($929,280) $3,077,760 0.00%
$26,714 ($6,195) $20,518
(20.00%)
($63,040) ($4,507) $0 ($67,547)
($420) ($30) $0 ($450)
2.05% 0.15% 0.00% 2.19%
($63,040) ($4,507) $0 ($67,547)
($420) ($30) $0 ($450)
5.00% 0.50% 0.00% 5.50%
$18,966
$3,010,213
$20,068
$3,010,213
$20,068
$3,228,199
$21,521
$15,825 $3,192 $1,628 $969 $1,572 $23,186
$106 $21 $11 $6 $10 $155
$15,825 $3,192 $1,628 $969 $1,572 $23,186
$106 $21 $11 $6 $10 $155
$15,825 $3,192 $1,628 $969 $1,572 $23,186
$106 $21 $11 $6 $10 $155
$15,825 $3,192 $1,628 $969 $1,572 $23,186
$106 $21 $11 $6 $10 $155
$2,868,143
$19,121
$3,033,400
$20,223
$3,033,400
$20,223
$3,251,385
$21,676
EXPENSES FIXED OPERATIONAL EXPENSE Real Estate Property Taxes Property Insurance Expense Property Utility Expense TOTAL FIXED OPERATIONAL EXP
16.34% 3.19% 4.44% 23.97%
$432,648 $84,414 $117,526 $634,589
$2,884 $563 $784 $4,231
14.79% 3.64% 2.17% 20.61%
$424,337 $104,342 $62,310 $590,989
$2,829 $696 $415 $3,940
14.79% 3.64% 2.17% 20.61%
$424,337 $104,342 $62,310 $590,989
$2,829 $696 $415 $3,940
12.53% 3.96% 2.05% 18.54%
$380,041 $120,000 $62,310 $562,350
$2,534 $800 $415 $3,749
11.69% 3.69% 5.80% 21.17%
$380,041 $120,000 $188,424 $688,465
$2,534 $800 $1,256 $4,590
VARIABLE OPERATIONAL EXPENSE Maint. Contract Services Repairs & Maintenance Administrative Expenses Leasing & Marketing Payroll and Salary Expenses Property Management Fee Non-Profit Fee TOTAL VARIABLE OPERATIONAL EXP
3.66% 5.58% 1.66% 1.01% 6.49% 2.39% 0.00% 20.78%
$96,787 $147,769 $43,904 $26,745 $171,701 $63,194 $0 $550,099
$645 $985 $293 $178 $1,145 $421 $0 $3,667
2.35% 4.32% 0.13% 0.96% 10.65% 2.43% 0.00% 20.85%
$67,481 $123,934 $3,685 $27,504 $305,504 $69,816 $0 $597,924
$450 $826 $25 $183 $2,037 $465 $0 $3,986
2.35% 4.32% 0.13% 0.96% 10.65% 2.43% 0.00% 20.85%
$67,481 $123,934 $3,685 $27,504 $305,504 $69,816 $0 $597,924
$450 $826 $25 $183 $2,037 $465 $0 $3,986
2.22% 4.09% 1.63% 0.91% 10.04% 2.50% 0.59% 21.98%
$67,481 $123,934 $49,320 $27,504 $304,688 $75,835 $18,000 $666,763
$450 $826 $329 $183 $2,031 $506 $120 $4,445
2.08% 3.81% 1.52% 0.85% 9.37% 2.50% 0.55% 20.67%
$67,481 $123,934 $49,320 $27,504 $304,688 $81,285 $18,000 $672,212
$450 $826 $329 $183 $2,031 $542 $120 $4,481
TOTAL FIXED & VARIABLE EXPENSES
44.75%
$1,184,688
$7,898
41.45%
$1,188,914
$7,926
41.45%
$1,188,914
$7,926
40.52%
$1,229,113
$8,194
41.85%
$1,360,677
$9,071
$45,000
$300
$45,000
$300
$45,000
$300
$45,000
$300
$45,000
$300
$1,229,688
$8,198
$1,233,914
$8,226
$1,233,914
$8,226
$1,274,113
$8,494
$1,405,677
$9,371
$1,417,772
$9,452
$1,634,230
$10,895
$1,799,486
$11,997
$1,759,287
$11,729
$1,845,708
$12,305
Reserves & Replacements TOTAL OPERATING EXPENSES
10
NET OPERATING INCOME
46.45%
43.02%
43.02%
42.00%
43.23%
(3) (4) (5)
(6) (7) (8)
NOTES TO INCOME & EXPENSES NOTES TO PROFORMA (1)
Potential Rental Income: Analysis reflects the Proforma rents as displayed on the Unit Mix Page, annualized. A 20% loss to lease is included as the higher rents are implemented and burned off by Year 4 of the analysis.
(2)
Vacancy: Based on the rent roll from 11/7/2023, physical occupancy is 99%. Analysis initially uses a 5.0% vacancy factor that is reduced to 4.0% in Year 4, where it remains for the rest of the analysis.
(3)
Real Estate Taxes: See notes below.
(4)
Insurance: Based on $800 per unit as an estimate of market underwriting.
(5)
Utilities: Per Client correspondence, a buyer will be required to phase out Water/Sewer rebilling as they bring units into compliance with a new regulatory agreement associated with the Welfare Exemption. Therefore, income from the property's Water/Sewer Rebill program is removed in the Proforma.
(6)
Administrative Expenses: Cable income of $45,635 in March 2023 has been removed from the analysis as it assumed to be non-recurring.
(7)
Payroll and Salary Expenses: Based on the Payroll Analysis below which assumes that costs are shared between the Mar at Cottonwood, Mar at Chavez, and Mar at Primera properties on a pro rata basis.
(8)
Non-Profit Fee: This analysis assumes a buyer includes the involvement of a non-profit organization to continue benefitting from the partial property tax exemption going forward. An annual estimated fee of $120 per unit is included in the analysis.
REAL ESTATE TAX ANALYSIS Parcel #: 666-150-26-00
Land Improvement Personal Property Total Market Value Exemptions Value after Exemptions Assessment Ratio Assessed Value
2022-2023 $14,000,000 $21,307,611 $58,277 $35,365,888 $0 $35,365,888 100.00% $35,365,888
2023-2024 $14,280,000 $21,733,763 $76,118 $36,089,881 $0 $36,089,881 100.00% $36,089,881
Proforma $14,420,000 $17,019,975 $60,025 $31,500,000
Tax Rate Ad Valorem Taxes Special Assessments Total Taxes Due
1.206% $426,343 $287 $426,629
1.206% $446,132 $302 $446,434
1.206% $379,739 $302 $380,041
Sale Price $31,500,000
Reassess To 100.00%
$31,500,000
100.00%
$31,500,000 100.00% $31,500,000
Notes It is assumed that the property will begin to benefit from the Welfare Property tax exemption under Property Tax Rule 140, subdivision (b) starting in Year 2 of the analysis. However, it is unknown how many units currently qualify for the exemption; the analysis assumes 50% of the units will be eligible for the Exemption in Year 2, and the remainder of the units will become eligible in Year 3. The Proforma property tax expense is estimated by assuming a decrease in the market value to 100% of the High BOV Price and then applying the current millage rate. Furthermore, it will receive a 50% exemption in the Year 2 and a 100% exemption in Year 3, afterwards property taxes are estimated by assuming a 3.0% increase in special assessments.
PAYROLL ANALYSIS
11
Position Manager Admin Assistant Maintenance Super Maint. Assistant Misc. Subtotal PR Tax/Benefits Total Portfolio Payroll Expense Pro Rate Share of Expenses Total Payroll
FTE 1 2 1 2 1 7
Rate $35.00 $28.50 $35.00 $28.50 $28.50 25.00%
7
Annual $72,800 $118,560 $72,800 $118,560 $59,280 $442,000 $110,500 $552,500 55% $304,688
CASH FLOW PROPERTY CASH FLOW ANALYSIS - ASSUMPTIONS CASH FLOW SUMMARY Gross Potential Rent Growth Loss to Lease Vacancy Bad Debt Concessions Other Income Growth Property Taxes Insurance Utilities Property Management Fee Other Expenses Replacement Reserves
12
1 Year 1
2 Year 2
3 Year 3
4 Year 4
5 Year 5
6 Year 6
7 Year 7
8 Year 8
9 Year 9
10 Year 10
NA -20.00% 5.00% 0.50% 0.00% NA NA NA NA 2.50% NA NA
2.50% -14.00% 5.00% 0.50% 0.00% 3.00% -48.50% 3.00% 3.00% 2.50% 3.00% 0.00%
2.50% -7.00% 5.00% 0.50% 0.00% 3.00% -99.84% 3.00% 3.00% 2.50% 3.00% 0.00%
2.50% 0.00% 4.00% 0.50% 0.00% 3.00% 3.00% 3.00% 3.00% 2.50% 3.00% 0.00%
2.50% 0.00% 4.00% 0.50% 0.00% 3.00% 3.00% 3.00% 3.00% 2.50% 3.00% 0.00%
2.50% 0.00% 4.00% 0.50% 0.00% 3.00% 3.00% 3.00% 3.00% 2.50% 3.00% 0.00%
2.50% 0.00% 4.00% 0.50% 0.00% 3.00% 3.00% 3.00% 3.00% 2.50% 3.00% 0.00%
2.50% 0.00% 4.00% 0.50% 0.00% 3.00% 3.00% 3.00% 3.00% 2.50% 3.00% 0.00%
2.50% 0.00% 4.00% 0.50% 0.00% 3.00% 3.00% 3.00% 3.00% 2.50% 3.00% 0.00%
2.50% 0.00% 4.00% 0.50% 0.00% 3.00% 3.00% 3.00% 3.00% 2.50% 3.00% 0.00%
CASH FLOW CASH FLOW SUMMARY
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
Year 7
Year 8
Year 9
INCOME Gross Potential Rent Gain (Loss) to Lease POTENTIAL RENTAL INCOME
$4,270,104 ($854,021) $3,416,083
$4,376,857 ($612,760) $3,764,097
$4,486,278 ($314,039) $4,172,239
$4,598,435 $0 $4,598,435
$4,713,396 $0 $4,713,396
$4,831,231 $0 $4,831,231
$4,952,012 $0 $4,952,012
$5,075,812 $0 $5,075,812
$5,202,707 $0 $5,202,707
$5,332,775 $0 $5,332,775
Economic Operational Loss Vacancy Loss Bad Debt Concessions Total Operational Loss
($170,804) ($17,080) $0 ($187,885)
($188,205) ($18,820) $0 ($207,025)
($208,612) ($20,861) $0 ($229,473)
($183,937) ($22,992) $0 ($206,930)
($188,536) ($23,567) $0 ($212,103)
($193,249) ($24,156) $0 ($217,405)
($198,080) ($24,760) $0 ($222,841)
($203,032) ($25,379) $0 ($228,412)
($208,108) ($26,014) $0 ($234,122)
($213,311) ($26,664) $0 ($239,975)
NET RENTAL INCOME
$3,228,199
$3,557,071
$3,942,765
$4,391,505
$4,501,293
$4,613,825
$4,729,171
$4,847,400
$4,968,585
$5,092,800
$23,186
$23,882
$24,598
$25,336
$26,096
$26,879
$27,686
$28,516
$29,372
$30,253
$3,251,385
$3,580,953
$3,967,364
$4,416,842
$4,527,389
$4,640,705
$4,756,857
$4,875,917
$4,997,957
$5,123,053
OPERATIONAL EXPENSES FIXED OPERATIONAL EXPENSE Real Estate Property Taxes Property Insurance Expense Property Utility Expense TOTAL FIXED OPERATIONAL EXP
$380,041 $120,000 $188,424 $688,465
$195,721 $123,600 $194,077 $513,398
$320 $127,308 $199,899 $327,528
$330 $131,127 $205,896 $337,353
$340 $135,061 $212,073 $347,474
$350 $139,113 $218,435 $357,898
$360 $143,286 $224,989 $368,635
$371 $147,585 $231,738 $379,694
$382 $152,012 $238,690 $391,085
$394 $156,573 $245,851 $402,818
VARIABLE OPERATIONAL EXPENSE Maint. Contract Services Repairs & Maintenance Administrative Expenses Leasing & Marketing Payroll and Salary Expenses Property Management Fee Non-Profit Fee
$67,481 $123,934 $49,320 $27,504 $304,688 $81,285 $18,000
$69,506 $127,652 $50,800 $28,329 $313,828 $89,524 $18,000
$71,591 $131,482 $52,324 $29,179 $323,243 $99,184 $18,000
$73,739 $135,426 $53,894 $30,055 $332,940 $110,421 $18,000
$75,951 $139,489 $55,510 $30,956 $342,928 $113,185 $18,000
$78,229 $143,674 $57,176 $31,885 $353,216 $116,018 $18,000
$80,576 $147,984 $58,891 $32,842 $363,813 $118,921 $18,000
$82,994 $152,423 $60,658 $33,827 $374,727 $121,898 $18,000
$85,483 $156,996 $62,477 $34,842 $385,969 $124,949 $18,000
$88,048 $161,706 $64,352 $35,887 $397,548 $128,076 $18,000
TOTAL VARIABLE OPERATIONAL EXP
$672,212
$697,639
$725,003
$754,474
$776,020
$798,198
$821,027
$844,527
$868,716
$893,617
TOTAL FIXED & VARIABLE EXPENSE
$1,360,677
$1,211,037
$1,052,531
$1,091,828
$1,123,494
$1,156,096
$1,189,662
$1,224,221
$1,259,802
$1,296,435
$45,000
$45,000
$45,000
$45,000
$45,000
$45,000
$45,000
$45,000
$45,000
$45,000
TOTAL OPERATING EXPENSES
$1,405,677
$1,256,037
$1,097,531
$1,136,828
$1,168,494
$1,201,096
$1,234,662
$1,269,221
$1,304,802
$1,341,435
PROPERTY NET OPERATING INCOME
$1,845,708
$2,324,916
$2,869,833
$3,280,014
$3,358,896
$3,439,609
$3,522,195
$3,606,696
$3,693,155
$3,781,618
1ST MTG DEBT SERVICE EXPENSES First Mortgage Interest First Mortgage Principal TOTAL 1ST MTG DEBT SERVICE
$1,372,800 $0 $1,372,800
$1,372,800 $0 $1,372,800
$1,372,800 $0 $1,372,800
$1,365,157 $280,969 $1,646,126
$1,347,827 $298,299 $1,646,126
$1,329,429 $316,697 $1,646,126
$1,309,896 $336,230 $1,646,126
$1,289,158 $356,968 $1,646,126
$1,267,141 $378,985 $1,646,126
$1,243,766 $402,360 $1,646,126
CASH FLOW AFTER DEBT SERVICE
$472,908
$952,116
$1,497,033
$1,633,888
$1,712,770
$1,793,483
$1,876,069
$1,960,570
$2,047,030
$2,135,492
DEBT SERVICE COVERAGE RATIO INDICATED CAPITALIZATION RATE CASH ON CASH RETURN
1.34 5.86% 4.23%
1.69 7.38% 8.52%
2.09 9.11% 13.40%
1.99 10.41% 14.62%
2.04 10.66% 15.33%
2.09 10.92% 16.05%
2.14 11.18% 16.79%
2.19 11.45% 17.55%
2.24 11.72% 18.32%
2.30 12.01% 19.11%
Total Other Income EFFECTIVE GROSS INCOME
Replacement Reserves
13
Year 10
INVESTMENT ADVISORS BRANDON GRISHAM
Senior Managing Director 253.653.3313 brandon.grisham@berkadia.com
JORDAN SKYLES
Director 208.631.4981 jordan.skyles@berkadia.com
JEFF IRISH
Senior Managing Director 208.286.5013 jeff.irish@berkadia.com
MIKE TERRY
Director 425.761.1640 mike.terry@berkadia.com
ADAM TOMBERG
Director 425.999.1152 adam.tomberg@berkadia.com
RACHEL PARSONS
BOISE OFFICE 6225 North Meeker Place Suite 210 Boise, ID 83713
IRVINE OFFICE
Senior Managing Director 949.242.4082 rachel.parsons@berkadia.com
3333 Michelson Drive Suite 620 Irvine CA 92612 www.Berkadia.com
DISCLAIMER & CONFIDENTIALITY The material contained in this document is confidential, furnished solely for the purpose of considering investment in the property described therein and is not to be copied and/ or used for any purpose or made available to any other person without the express written consent of Berkadia Real Estate Advisors LLC and Berkadia Real Estate Advisors Inc. In accepting this, the recipient agrees to keep all material contained herein confidential. This information package has been prepared to provide summary information to prospective purchasers and to establish a preliminary level of interest in the property described herein. It does not, however, purport to present all material information regarding the subject property, and it is not a substitute for a thorough due diligence investigation. In particular, Berkadia Real Estate Advisors LLC, Berkadia Real Estate Advisors Inc. and Seller have not made any investigation of the actual property, the tenants, the operating history, financial reports, leases, square footage, age or any other aspect of the property, including but not limited to any potential environmental problems that may exist and make no warranty or representation whatsoever concerning these issues. The information contained in this information package has been obtained from sources we believe to be reliable; however, Berkadia Real Estate Advisors LLC, Berkadia Real Estate Advisors Inc. and Seller have not conducted any investigation regarding these matters and make no warranty or representation whatsoever regarding the accuracy or completeness of the information provided. Any pro formas, projections, opinions, assumptions or estimates used are for example only and do not necessarily represent the current or future performance of the property. Berkadia Real Estate Advisors LLC and Berkadia Real Estate Advisors Inc. and Seller strongly recommend that prospective purchasers conduct an in-depth investigation of every physical and financial aspect of the property to determine if the property meets their needs and expectations. We also recommend that prospective purchasers consult with their tax, financial and legal advisors on any matter that may affect their decision to purchase the property and the subsequent consequences of ownership. All parties are advised that in any property the presence of certain kinds of molds, funguses, or other organisms may adversely affect the property and the health of some individuals. Berkadia Real Estate Advisors LLC and Berkadia Real Estate Advisors Inc. recommend, if prospective buyers have questions or concerns regarding this issue, that prospective buyers conduct further inspections by a qualified professional. The Seller retains the right to withdraw, modify or cancel this offer to sell at any time and without any notice or obligation. Any sale is subject to the sole and unrestricted approval of Seller, and Seller shall be under no obligation to any party until such time as Seller and any other necessary parties have executed a contract of sale containing terms and conditions acceptable to Seller and such obligations of Seller shall only be those in such contract of sale. For more information on these and other Berkadia® exclusive listings, please visit our website at www.Berkadia.com Berkadia®, a joint venture of Berkshire Hathaway and Jefferies Financial Group, is an industry leading commercial real estate company providing comprehensive capital solutions and investment sales advisory and research services for multifamily and commercial properties. Berkadia® is amongst the largest, highest rated and most respected primary, master and special servicers in the industry. © 2023 Berkadia Proprietary Holding LLC Berkadia® is a trademark of Berkadia Proprietary Holding LLC Investment sales and real estate brokerage businesses are conducted exclusively by Berkadia Real Estate Advisors LLC and Berkadia Real Estate Advisors Inc. Commercial mortgage loan origination and servicing businesses are conducted exclusively by Berkadia Commercial Mortgage LLC and Berkadia Commercial Mortgage Inc. Tax credit syndication business is conducted exclusively by the Tax Credit Syndication group. In California, Berkadia Real Estate Advisors Inc. conducts business under CA Real Estate Broker License #01931050; Adrienne Barr, CA DRE Lic. # 01308753. Berkadia Commercial Mortgage LLC conducts business under CA Finance Lender & Broker Lic. #988-0701; and Berkadia Commercial Mortgage Inc. under CA Real Estate Broker Lic. #01874116. This proposal is not intended to solicit commercial mortgage loan brokerage business in Nevada. For state licensing details, visit: http://www.berkadia.com/licensing.
BERKADIA.COM / 800.446.2226 a Berkshire Hathaway and Jefferies Financial Group company
© 2023 Berkadia Proprietary Holding LLC. Berkadia® is a trademark of Berkadia Proprietary Holding LLC. Investment sales and real estate brokerage businesses are conducted exclusively by Berkadia Real Estate Advisors LLC and Berkadia Real Estate Advisors Inc. Commercial mortgage loan origination and servicing businesses are conducted exclusively by Berkadia Commercial Mortgage LLC and Berkadia Commercial Mortgage Inc. Tax credit syndication business is conducted exclusively by the Tax Credit Syndication group. This advertisement is not intended to solicit commercial mortgage loan brokerage business in Nevada. In California, Berkadia Real Estate Advisors Inc. conducts business under CA Real Estate Broker License #01931050; Adrienne Barr, CA DRE Lic. # 01308753. Berkadia Commercial Mortgage LLC conducts business under CA Finance Lender & Broker Lic. #988-0701; and Berkadia Commercial Mortgage Inc. under CA Real Estate Broker Lic. #01874116. For state licensing details for the above entities, visit: www.berkadia.com/licensing.