1441 Montiel Road, Escondido

FINANCIAL ANALYSIS

ANNUAL PRO FORMA (BEFORE DEBT)

1441 Montiel OM

Analysis Date: 2/6/2019

Annual Pro Forma (Before Debt)

Year Count

Mark to Market

In-Place

Per RSF

1

2

3

4

5

6

7

8

9

10

11

Fiscal Year Ending - April

May-01-19

FYE 2020 FYE 2020 FYE 2021

FYE 2022 FYE 2023 FYE 2024 FYE 2025 FYE 2026 FYE 2027 FYE 2028 FYE 2029 FYE 2030

Operating Measures Operating Disbursements/Rentable Square Foot

-$2.89 12.0% 0.0% 12.0%

-$2.89

-$2.91 6.7% 0.0% 6.7% 0.0%

-$2.98

-$3.04 0.0% 5.0% 5.0% 25.9%

-$3.13 0.0% 5.0% 5.0% 24.9%

-$3.21 0.0% 5.0% 5.0% 0.0%

-$3.28

-$3.35

-$3.44

-$3.52

-$3.60 2.0% 3.0% 5.0% 0.0% 97.8%

-$3.69

Absorption/Turnover Vacancy Percentage Vacancy/Credit Loss Percentage Total Economic Vacancy Percentage

13.3% 0.0% 13.3%

0.0% 5.0% 5.0% 0.0%

1.1%

2.7% 2.3% 5.0%

0.0% 5.0% 5.0% 0.0%

0.0% 5.0% 5.0% 0.0%

1.1%

3.9% 5.0% 0.0% 98.8%

3.9% 5.0% 0.0% 98.8%

In-Place Lease Rollover Occupancy Percentage

34.8%

85.6%

85.6%

92.8% 100.0% 100.0% 100.0% 100.0%

97.1% 100.0% 100.0%

Operating Receipts Rental Receipts

Potential Base Rental Receipts Absorption/Turnover Vacancy

$749,850 $700,920

$14.11 -1.08 -0.36 12.68 2.38 0.00 15.06 0.00 15.06 -0.47 -0.09 -0.09 -0.12 -0.45 -1.67 -0.01

$705,585 $720,943 $738,618 $758,975 $790,806 $809,501

$831,563 $853,319 $876,747 $908,532 $928,870

-107,736

-107,736

-53,865 -17,955 633,765 119,037

0

0

0 0

0 -10,407

-25,980

0 0

0

-21,141

-12,065 -14,478 902,327 167,922

Base Rent Abatements

0

0

0 -17,490

0

-12,489

-31,176

0 -25,369

Total Rental Receipts

642,114 144,384

593,184 106,212

720,943

721,128 139,057

758,975 790,806 786,605

774,407

853,319 876,747

862,022 164,426

Operating Disbursements Recoveries

136,312

142,979

146,790

147,441

146,911

157,688

161,548

Other Income

0

0

0

0

0

0

0

0

0

0

0

0

0

Total Operating Receipts before Vacancy/Credit Loss

786,498

699,396

752,802

857,255

860,185

901,954 937,596 934,046

921,318 1,011,007 1,038,295 1,026,448 1,070,249

Vacancy/Credit Loss

0

0

0 -42,863

-43,009 -45,098 -46,880

-36,816

-21,385

-50,550

-51,915

-31,238

-42,051

Total Operating Receipts

786,498

699,396

752,802

814,392

817,176 856,856

890,716 897,230 899,933 960,457

986,380 995,210 1,028,198

Operating Disbursements Utilities Repairs & Maintenance

-23,328 -4,704 -4,608 -6,000 -20,976 -83,328

-23,328 -4,704 -4,608 -6,000 -20,976 -83,328

-23,327 -4,705 -4,602 -6,000 -22,584

-24,027 -4,846 -4,740

-24,748 -4,992 -4,882 -6,365 -24,515

-25,490 -26,255

-27,042 -5,454 -5,335 -6,956 -26,917 -91,996

-27,854 -28,689

-29,550 -30,436

-31,350 -6,323 -6,185 -8,063

-5,141

-5,296 -5,180 -6,753 -26,721 -90,193

-5,618 -5,495 -7,164 -26,998 -93,836

-5,787 -5,660 -7,379 -28,814 -95,713

-5,960 -5,830 -7,601 -29,591 -97,627

-6,139 -6,005 -7,829

Landscaping

-5,029 -6,556 -25,706

Insurance

-6,180

Management Fee

-24,432

-29,856 -30,846

-83,324 -84,990 -86,690 -88,424

-99,580

-101,571

[1] Property Taxes

Non-Recoverable

-1,440

-1,440

-718

0

0

0

0

-138

-346

0

0

-282

-160

Total Operating Disbursements

-$144,384

-$144,384

-2.91

-145,260 -149,215

-152,192 -156,346 -160,398 -163,838

-167,311

-172,042

-176,159

-180,127 -184,498 815,083 843,700

$642,114

$555,012

12.15

607,542

665,177 664,984 700,510 730,318

733,392

732,622

788,415

810,221

Net Operating Income

Other Operating Receipts/(Disbursements) Tenant Improvements

-7.18

-359,100 -33,240

0 -68,757 0 -53,749

0 0

0

-58,281

-145,486

0 0

0 -118,387

-67,564 -33,184 -10,077 -110,825

Leasing Commissions

-0.66 -0.15

0 -28,625

-71,455 -8,954

0

-58,146 -9,784 -186,317

Capital Reserves

-7,499

-7,723

-7,955

-8,194

-8,440

-8,693

-9,222 -9,222

-9,499 -9,499

Total Other Operating Receipts/(Disbursements)

-8.00

-399,839

-7,723

-130,461

-8,194

-8,440 -95,599 -225,895

$4.15 $207,703 $657,454 $534,523 $692,316 $721,878 $637,793 $506,727 $779,193 $800,722 $628,766 $732,875

Non-Leveraged Operating Receipts/(Disbursements)

[1] Property Taxes have been re-assessed based on Mid-Point Pricing, and have been adjusted to reflect ongoing partial tax exemption from educational tenant.

Mid-Point Pricing - $9,860,000 Capitalization Rate

6.5%

5.6%

6.2%

6.2% 2.1% 2.1%

6.7% 6.7% 4.4%

6.7% 5.4% 4.7%

7.1%

7.4% 7.3% 5.7%

7.4% 6.5% 5.8%

7.4% 5.1% 5.7%

8.0% 7.9% 6.0%

8.2% 8.1% 6.2%

8.3% 6.4% 6.3%

8.6% 7.4% 6.4%

Cash on Cash Return

Mark to Market

In-Place Cap Rate

Year 1

7.0% 5.3%

Avg. Cash on Cash Return

Cap Rate

OFFERING MEMORANDUM

51

Made with FlippingBook - professional solution for displaying marketing and sales documents online