Live Look At A Retail Deal

This is a live look at a deal I'm underwriting...

Hey guys,

It’s Mo –

Recent Retail Deal I Did

Recently, I was a co-GP on a retail deal in PHX. It was a multi-tenant retail that was majority filled up and was a value add play. We bought it for around a 7.8% cap rate for $8.075mm. The NOI was around $655k and we think we can bump it up and stabilize a 9.5% stabilized yield or $767k NOI.

Assume a 7% cap rate and we think the stabilized value is $10.98mm or ~$11mm.

Not bad at all. I can do a case study on it when it gets stabilized 🙂 

This has me hunting for retail deals and I am going to show you my thought process. I’ve learned this from my mentor/friend Kevin.

The Example:

This deal is a 10.6k sq ft multitenant retail building in Antioch, CA. Annual rent is $72.7k, pro forma is $130k.

The building is 10960 sq ft, but 4560 (41.6% of building) SQFT is vacant, so this could present some upside if you find someone to lease it up.

Value Add Strategies:

  • Lease “end cap” of 4560 sq ft to another bank

  • Chop it up into 2-3 different suites between 1500-2700 sq ft.

  • Bill back CAM’s to tenants & mark-to-market rents & lease end cap

Underwriting

Here is the underwriting model below (link to Google Sheets):

There’s CAM (common area maintenance).

One value add strategy is to bill it back.

Usually, upon lease renewal, you can bill it back. You HAVE to honor existing leases. So the month-to-month (MTM) tenant, you can add back CAM.

CAM is used to maintain common areas, so sweep parking lots, fix lighting, paint asphalt.

Usually, there is a reserves budget baked into the accounts with security deposits for when capital expenditures (improvements) need to happen.

Capex = restripe parking lots, add lighting. Anything to improve the value of the property.

Pricing

The price is currently unlisted. This means the value is in the eye of the beholder.

This is advertised as a value-add deal, so we’re going to take the monthly rent and subtract estimated expenses and take the “Owner Net OpEx” or owner net operating expenses.

This gives us $72.7k in gross income

Expenses are $22.55k net to owner.

NOI = $50.1k on actuals.

Values are to the left, cap rate is on the right.

$835,966.67

6.00%

$771,661.54

6.50%

$716,542.86

7.00%

Pro Forma

Pro forma is whatever the hypothetical “value add” plan is.

We’re assuming we will lease the vacant space for $1/ SQFT annually.

This adds $54.7k in GROSS income. This is the income schedule for pro forma

12 Month Proforma

Tenant

SF

LED

$/ SF

Monthly Rent, MG

Annual Rent

1

Vacant

4560

1

4,560.00

54,720.00

2

Global AutoParts

4200

8/31/2025

0.71

2,982.00

35,784.00

3

Family Cuts

1000

1.7

1,700.00

20,400.00

4

Floors Near Me

1200

7/31/2024

1.29

1,548.00

18,576.00

10960

$72,708.00

Less Expenses

$22,550.00

NOI

$50,158.00

Values after pro forma rent

This is base case of $1 PSF in the 41% vacancy. This makes us a cool $1mm profit!

$1,782,166.67

6.00%

$1,645,076.92

6.50%

$1,527,571.43

7.00%

Not bad – not so fast.

For argument sake, we are assuming no leasing commissions + capex into our model. This is NOT the way we would normally do it, but simplicity sake*

Value Add Strategies

Lease “end cap” of 4560 sq ft to another bank

Leasing the end cap is a viable strategy. We would assume this is the path of least resistance and we' can do it for $1 PSF is gross rents. This seems easiest and we would have to add TIs (tenant improvements) and leasing commissions into the cost model.

Look at model above.

Chop it up into 2-3 different suites between 1500-2700 sq ft.

This would add more capex to our deal but we could possibly bring up rents to a premium.

12 Month Proforma

Tenant

SF

LED

$/ SF

Monthly Rent, MG

Annual Rent

1

Tenant 1

2280

1.25

2,850.00

34,200.00

2

Tenant 2

2280

1.25

2,850.00

34,200.00

3

Global AutoParts

4200

8/31/2025

0.71

2,982.00

35,784.00

4

Family Cuts

1000

1.7

1,700.00

20,400.00

5

Floors Near Me

1200

7/31/2024

1.29

1,548.00

18,576.00

10960

143,160.00

Less Owner Net OpEx

22550

Proforma NOI

120,610.00

This assumes we can bring up our pro forma NOI to $120k. We can increase the value of this from $1.7-2.0mm (depending on cap rate).

Proforma NOI

120,610.00

$2,010,166.67

6.00%

$1,855,538.46

6.50%

$1,723,000.00

7.00%

Mark-to-market rents & lease vacant

This is a simple strategy. We lease the vacant at $1 PSF and increase rents by 5%.

12 Month Proforma

Tenant

SF

LED

$/ SF

Monthly Rent, MG

Annual Rent

1

Vacant

4560

$1.00

4,560.00

54,720.00

2

Global AutoParts

4200

8/31/2025

$0.75

2,982.00

35,784.00

3

Family Cuts

1000

$1.79

1,700.00

20,400.00

4

Floors Near Me

1200

7/31/2024

$1.35

1,548.00

18,576.00

10960

129,480.00

Less Owner Net OpEx

22550

Proforma NOI

106,930.00

This would increase pro forma NOI to $106.9k and values would be ranging from $1.527-$1.78mm.

$1,782,166.67

6.00%

$1,645,076.92

6.50%

$1,527,571.43

7.00%

Pricing & Value Add:

Down payment

30.00%

Value

$716,542.86

Down payment value

$214,962.86

Loan details

Balance

$501,580.00

Interest Rate

6.50%

Years of Payments

25

Yearly Payment

-$32,602.70

We have a down payment of 30% ($215k) and our debt is $32.6k yearly, assuming 25 year amortization and 6.5% interest.

Assume we do the value add in the first 6 months (rare) and this is what our cash flow looks like.

Proforma NOI

106,930.00

Debt

-$32,602.70

Free Cash Flow

$74,327.30

So we are making $74k in FCF on a down payment of $215k after the value add.

Free Cash Flow

$74,327.30

Down Payment

$214,962.86

Return on Equity Y1

34.58%

Say we refi this and this is what my math is at…

Purchase Math

Down payment

30.00%

Value

$716,542.86

Down payment value

$214,962.86

Loan details

Balance

$501,580.00

Interest Rate

6.50%

Years of Payments

25

Yearly Payment

-$32,602.70

Free Cash Flow

$74,327.30

Down Payment

$214,962.86

Return on Equity Y1

34.58%

Refi

Value

$1,782,166.67

New LTV

70%

Loan Value

$1,247,516.67

Interest Rate

6.50%

Years of Payments

25

Pro Forma NOI

106,930.00

Debt Payment Refi

-$81,088.58

FCF

25,841.42

Net Proceeds (including down payment)

$319,687.14

This assumes the new value is $1.78mm, we are taking 70% out (new debt is $1.247mm).

Our new cash flow is $25.8k and we walk away with a check for almost $320k. This net proceed number assumes the difference after the pro forma NOI and paying back our initial down payment of $215k.

Assumptions

It’s a lot of work and heavily spreadsheet math. I have not checked our rent assumptions and using what the broker gave me.

Be sure to do your due diligence. Review ALL leases and understand what they actually mean.

We did not add any capex into this & assumed the tenants are funding their own TI’s. This may or may not happen in the real world. It’s highly dependent on your lease.

Model here and deck here.

Summary

Multitenant retail with value add components can be a great way to make some money. This deal can work, but requires a lot of leasing activity and TI’s which may lower your return.

Hope you enjoyed this and I’m actively looking for retail deals with my partner. If you’d like to invest, please email me.

Thank you,

Mo