XML 48 R37.htm IDEA: XBRL DOCUMENT v3.22.4
INVESTMENT IN UNCONSOLIDATED JOINT VENTURES (Tables)
12 Months Ended
Dec. 31, 2022
2022  
Summary of financial position and income statements relating to investment in unconsolidated joint ventures

  

  

Hamilton

  

  

  

Hamilton

  

Hamilton

  

  

Hamilton

Essex

345

Hamilton

Minuteman

on Main

Dexter

    

Essex 81

    

Development

    

Franklin

    

1025

    

Apts

    

Apts

    

Park

    

Total

ASSETS

Rental Properties

$

5,829,640

$

2,585,680

$

4,810,934

$

78,291

$

4,467,772

$

13,456,133

$

75,907,107

$

107,135,557

Cash & Cash Equivalents

 

985,849

110,907

358,016

29,065

328,742

1,377,250

3,866,113

 

7,055,942

Rent Receivable

 

202,221

78,436

4,915

2,600

9,565

106,165

 

403,902

Real Estate Tax Escrow

 

74,423

27,771

34,842

130,911

 

267,947

Prepaid Expenses & Other Assets  

 

321,912

53,316

111,018

493

26,238

186,990

2,288,330

 

2,988,297

Total Assets

$

7,414,045

$

2,828,339

$

5,307,739

$

112,764

$

4,860,194

$

15,160,849

$

82,167,715

$

117,851,645

LIABILITIES AND PARTNERS’ CAPITAL  

Mortgage Notes Payable

$

9,962,080

$

$

8,676,945

$

$

5,928,736

$

16,873,248

$

124,649,959

$

166,090,968

Accounts Payable & Accrued Expense

 

165,576

43,000

84,025

23,329

162,623

556,239

2,012,851

 

3,047,643

Advance Rental Pmts & Security Deposits

 

310,443

269,326

171,680

463,963

2,950,161

 

4,165,573

Total Liabilities

 

10,438,099

43,000

9,030,296

23,329

6,263,039

17,893,450

129,612,971

173,304,184

Partners’ Capital

 

(3,024,054)

2,785,339

(3,722,557)

89,435

(1,402,845)

(2,732,601)

(47,445,256)

 

(55,452,539)

Total Liabilities and Capital

$

7,414,045

$

2,828,339

$

5,307,739

$

112,764

$

4,860,194

$

15,160,849

$

82,167,715

$

117,851,645

Partners’ Capital %—NERA

 

50

% 

 

50

% 

 

50

% 

 

50

% 

 

50

% 

 

50

% 

 

40

% 

Investment in Unconsolidated Joint Ventures

$

$

1,392,669

$

$

44,718

$

$

$

1,437,387

Distribution and Loss in Excess of investments in Unconsolidated Joint Ventures

$

(1,512,027)

$

$

(1,861,278)

$

$

(701,422)

$

(1,366,300)

$

(18,978,102)

(24,419,129)

Total Investment in Unconsolidated Joint Ventures (Net)

$

(22,981,742)

Total units/condominiums

Apartments

 

48

 

 

40

 

 

42

 

148

 

409

 

687

Commercial

 

1

 

1

 

 

1

 

 

 

 

3

Total

 

49

 

1

 

40

 

1

 

42

 

148

 

409

 

690

Units to be retained

 

49

 

1

 

40

 

1

 

42

 

148

 

409

 

690

Units to be sold

 

 

 

 

 

 

 

 

Units sold through February 1, 2023

 

 

 

 

175

 

 

 

 

175

Unsold units

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Summary of income statement relating to investment in unconsolidated joint ventures

    

    

Hamilton

    

    

    

Hamilton

    

Hamilton

    

    

Hamilton

 Essex

345

Hamilton

Minuteman

on Main

Dexter

Essex 81

Development

Franklin

1025

Apts

Apts

Park

Total

Revenues

Rental Income

$

1,640,480

$

296,313

$

1,516,329

$

102,802

$

1,212,854

$

3,644,802

$

15,136,724

$

23,550,304

Laundry and Sundry Income

 

17,652

245

77,589

135,607

231,093

1,658,132

296,313

1,516,574

102,802

1,212,854

3,722,391

15,272,331

23,781,397

Expenses

Administrative

19,543

6,548

33,656

2,793

14,579

68,948

218,772

364,839

Depreciation and Amortization

478,538

11,709

346,793

3,264

338,919

1,081,096

3,768,367

6,028,686

Management Fees  

75,216

11,468

59,715

4,160

48,548

146,115

316,813

662,035

Operating

229,528

76,108

1,344

129,232

400,489

1,167,733

2,004,434

Renting

25,926

32,332

9,873

51,327

91,041

210,499

Repairs and Maintenance

185,275

3,180

184,057

106,689

626,909

1,694,941

2,801,051

Taxes and Insurance

266,024

63,139

182,098

18,513

153,117

513,699

2,503,801

3,700,391

 

1,280,050

96,044

914,759

30,074

800,957

2,888,583

9,761,468

15,771,935

Income Before Other Income

 

378,082

200,269

601,815

72,728

411,897

833,808

5,510,863

8,009,462

Other Income (Loss)

Interest Expense

 

(412,329)

(351,175)

(237,851)

(759,704)

(5,081,626)

(6,842,685)

Other(Expense)

 

(81,360)

(81,360)

 

(412,329)

(351,175)

(237,851)

(841,064)

(5,081,626)

(6,924,045)

Net (Loss) Income

$

(34,247)

$

200,269

$

250,640

$

72,728

$

174,046

$

(7,256)

$

429,237

$

1,085,417

Net (Loss) Income —NERA 50%

    

$

(17,124)

$

100,134

$

125,319

$

36,364

$

87,023

$

(3,628)

328,088

Net Income —NERA 40%

    

$

171,695

171,695

$

499,783

Schedule of future annual mortgage maturities

Hamilton

345

Hamilton

Hamilton on

Dexter

 

Period End

    

Essex 81

    

Franklin

    

Minuteman

    

Main Apts

    

Park

    

Total

 

12/31/2023

$

$

230,791

$

$

$

$

230,791

12/31/2024

 

239,883

16,900,000

17,139,883

12/31/2025

 

10,000,000

249,333

10,249,333

12/31/2026

259,155

259,155

12/31/2027

269,364

269,364

Thereafter

7,465,041

6,000,000

125,000,000

138,465,041

10,000,000

8,713,567

6,000,000

16,900,000

125,000,000

166,613,567

Less: unamortized deferred financing costs

(37,920)

(36,622)

(71,264)

(26,752)

(350,041)

(522,599)

$

9,962,080

$

8,676,945

$

5,928,736

$

16,873,248

$

124,649,959

$

166,090,968

2021  
Summary of financial position and income statements relating to investment in unconsolidated joint ventures

  

  

Hamilton

  

  

  

Hamilton

  

Hamilton

  

  

Hamilton

Essex

345

Hamilton

Minuteman

on Main

Dexter

    

Essex 81

    

Development

    

Franklin

    

1025

    

Apts

    

Apts

    

Park

    

Total

ASSETS

Rental Properties

$

6,263,331

$

2,588,169

$

5,062,602

$

81,555

$

4,697,616

$

14,334,539

$

78,755,698

$

111,783,510

Cash & Cash Equivalents

 

333,699

 

98,674

 

155,627

 

11,845

 

156,058

 

565,171

 

2,070,558

 

3,391,632

Rent Receivable

 

232,521

 

68,828

 

9,905

 

6,111

 

6,999

 

37,750

 

175,213

 

537,327

Real Estate Tax Escrow

 

76,651

 

 

29,999

 

 

36,451

 

109,588

 

 

252,689

Prepaid Expenses & Other Assets

 

301,043

 

62,399

 

117,197

 

446

 

24,009

 

181,941

 

2,102,717

 

2,789,752

Total Assets

$

7,207,245

$

2,818,070

$

5,375,330

$

99,957

$

4,921,133

$

15,228,989

$

83,104,186

$

118,754,910

LIABILITIES AND PARTNERS’ CAPITAL

Mortgage Notes Payable

$

9,948,291

$

$

8,892,331

$

$

5,920,552

$

16,857,197

$

124,585,336

$

166,203,707

Accounts Payable & Accrued Expense

 

68,265

 

3,000

 

52,392

 

3,251

 

48,145

 

188,012

 

670,624

 

1,033,689

Advance Rental Pmts& Security Deposits

 

180,497

 

 

228,803

 

 

159,324

 

434,126

 

2,522,719

 

3,525,469

Total Liabilities

 

10,197,053

3,000

9,173,526

3,251

6,128,021

17,479,335

127,778,679

170,762,865

Partners’ Capital

 

(2,989,808)

 

2,815,070

 

(3,798,196)

 

96,706

 

(1,206,888)

 

(2,250,346)

 

(44,674,493)

 

(52,007,955)

Total Liabilities and Capital

$

7,207,245

$

2,818,070

$

5,375,330

$

99,957

4,921,133

$

15,228,989

$

83,104,186

$

118,754,910

Partners’ Capital %—NERA

 

50

% 

50

% 

 

50

% 

 

50

% 

 

50

% 

 

50

% 

 

40

% 

Investment in Unconsolidated Joint Ventures

$

$

1,407,535

$

$

48,353

$

$

$

$

1,455,888

Distribution and Loss in Excess of investments in Unconsolidated Joint Ventures

$

(1,494,905)

$

$

(1,899,098)

$

$

(603,445)

$

(1,125,174)

$

(17,869,798)

 

(22,992,420)

Total Investment in Unconsolidated Joint Ventures (Net)

$

(21,536,532)

Total units/condominiums

Apartments

48

40

0

42

148

409

687

Commercial

1

1

1

3

Total

49

1

40

176

42

148

409

690

Units to be retained

49

1

40

1

42

148

409

690

Units to be sold

Units sold through February 1, 2022

175

175

Unsold units

Summary of income statement relating to investment in unconsolidated joint ventures

    

    

Hamilton

    

    

Hamilton

    

Hamilton

    

    

Hamilton

Essex

345

Hamilton

Minuteman

on Main

Dexter

  

Essex 81

Development

Franklin

1025

Apts

Apts

Park

Total

Revenues

Rental Income

$

1,609,397

$

391,878

$

1,360,472

$

98,135

$

1,139,865

$

3,370,478

$

12,866,983

$

20,837,208

Laundry and Sundry Income

 

12,761

1,494

3,913

38,697

97,781

154,646

 

1,622,158

391,878

1,361,966

98,135

1,143,778

3,409,175

12,964,764

20,991,854

Expenses

Administrative

 

76,338

2,875

31,566

2,812

16,450

68,008

205,460

403,509

Depreciation and Amortization

 

479,512

20,298

343,834

3,264

338,362

1,089,225

3,742,118

6,016,613

Management Fees

 

52,617

12,922

54,178

3,801

45,541

131,221

274,882

575,162

Operating

 

168,160

58,667

334

98,115

432,061

1,023,732

1,781,069

Renting

 

101,328

54,672

4,419

90,842

460,718

711,979

Repairs and Maintenance

 

159,593

520

129,548

120,626

624,475

1,814,342

2,849,104

Taxes and Insurance

 

261,145

60,764

175,183

19,467

144,533

451,937

2,426,021

3,539,050

 

1,298,693

97,379

847,648

29,678

768,046

2,887,769

9,947,273

15,876,486

Income Before Other Income

 

323,465

294,499

514,318

68,457

375,732

521,406

3,017,491

5,115,368

Other Income (Loss)

Interest Expense

 

(246,339)

(359,036)

(237,845)

(759,698)

(5,055,677)

(6,658,595)

Interest income

1,222

1,222

 

(246,339)

(359,036)

(237,845)

(759,698)

(5,054,455)

(6,657,373)

Net Income (Loss)

$

77,126

$

294,499

$

155,282

$

68,458

$

137,887

$

(238,292)

$

(2,036,964)

$

(1,542,005)

Net Income (Loss)—NERA 50%

    

$

38,563

$

147,249

$

77,641

$

34,229

$

68,944

$

(119,147)

247,478

Net Income —NERA 40%

    

$

(814,786)

(814,786)

$

(567,308)

2020  
Summary of financial position and income statements relating to investment in unconsolidated joint ventures

  

  

Hamilton

  

  

  

Hamilton

  

Hamilton

  

  

Hamilton

Essex

345

Hamilton

Minuteman

on Main

Dexter

    

Essex 81

    

Development

    

Franklin

    

1025

    

Apts

    

Apts

    

Park

    

Total

ASSETS

Rental Properties

  

$

6,649,177

$

2,590,659

$

5,373,751

$

84,819

$

4,998,436

$

15,239,672

$

80,763,418

$

115,699,932

Cash & Cash Equivalents

 

252,878

 

55,322

 

156,073

 

13,443

 

159,599

 

520,150

 

2,425,085

 

3,582,550

Rent Receivable

 

28,181

 

 

37,127

 

3,005

 

3,816

 

65,511

 

515,411

 

653,051

Real Estate Tax Escrow

 

71,203

 

 

19,874

 

 

35,849

 

106,199

 

 

233,125

Prepaid Expenses & Other Assets

 

281,503

 

80,008

 

89,636

 

407

 

23,198

 

148,796

 

1,471,134

 

2,094,682

Total Assets

$

7,282,942

$

2,725,989

$

5,676,461

$

101,674

$

5,220,898

$

16,080,328

$

85,175,048

$

122,263,340

LIABILITIES AND PARTNERS’ CAPITAL

Mortgage Notes Payable

$

9,934,502

$

$

9,099,301

$

$

5,912,368

$

16,841,145

$

124,520,713

$

166,308,029

Accounts Payable & Accrued Expense  

 

68,741

 

3,200

 

87,731

 

2,924

 

50,514

 

156,923

 

675,771

 

1,045,804

Advance Rental Pmts& Security Deposits

 

208,851

 

 

227,908

 

 

137,792

 

424,314

 

2,216,093

 

3,214,958

Total Liabilities

 

10,212,094

3,200

9,414,940

2,924

6,100,674

17,422,382

127,412,577

170,568,791

Partners’ Capital

 

(2,929,152)

 

2,722,789

 

(3,738,479)

 

98,750

 

(879,776)

 

(1,342,054)

(42,237,529)

 

(48,305,451)

Total Liabilities and Capital

$

7,282,942

$

2,725,989

$

5,676,461

$

101,674

$

5,220,898

$

16,080,328

$

85,175,048

$

122,263,340

Partners’ Capital %—NERA

 

50

% 

 

50

% 

 

50

% 

 

50

% 

 

50

% 

 

50

% 

 

40

% 

Investment in Unconsolidated Joint Ventures

$

$

1,361,395

$

$

49,375

$

$

$

 

1,410,770

Distribution and Loss in Excess of investments in Unconsolidated Joint Ventures

$

(1,464,576)

$

$

(1,869,240)

$

$

(439,888)

$

(671,027)

$

(16,895,012)

 

(21,339,743)

$

(19,928,974)

Total units/condominiums

Apartments

 

48

 

 

40

 

175

 

42

 

148

 

409

 

862

Commercial

 

1

 

1

 

 

1

 

 

 

 

3

Total

 

49

 

1

 

40

 

176

42

 

148

 

409

 

865

Units to be retained

 

49

 

1

 

40

 

1

 

42

 

148

 

409

 

690

Units to be sold

 

 

 

 

 

 

 

 

Units sold through February 1, 2021

 

 

 

 

 

 

 

 

Unsold units

 

 

 

 

 

 

 

 

Unsold units with deposits for future sale as of February 1, 2021

 

 

 

 

 

 

 

 

Summary of income statement relating to investment in unconsolidated joint ventures

    

    

Hamilton

    

    

    

Hamilton

    

Hamilton

    

    

Hamilton

Essex

345

Hamilton

Minuteman

on Main

Dexter

Essex 81

Development

Franklin

1025

Apts

Apts

Park

Total

Revenues

Rental Income

$

874,212

$

19,848

$

1,516,648

$

96,223

$

1,165,027

$

3,497,639

$

14,607,212

$

21,776,809

Laundry and Sundry Income

 

12,495

 

 

604

 

 

2,951

 

35,302

 

78,361

 

129,713

 

886,707

19,848

1,517,252

96,223

1,167,978

3,532,941

14,685,573

21,906,522

Expenses

Administrative

 

20,296

 

4,026

36,431

12,995

13,603

59,014

181,332

 

327,697

Depreciation and Amortization

 

488,315

 

20,297

339,513

3,264

348,994

1,059,165

3,696,822

 

5,956,370

Management Fees

 

42,958

 

2,203

57,986

3,529

46,275

132,513

294,565

 

580,029

Operating

 

79,195

 

67,885

276

102,397

362,318

1,021,480

 

1,633,551

Renting

 

22,782

 

52,571

7,994

73,837

309,112

 

466,296

Repairs and Maintenance

 

128,728

 

3,180

138,991

95,185

513,642

1,562,154

 

2,441,880

Taxes and Insurance

 

256,162

 

61,612

 

167,456

 

17,416

 

144,664

 

449,692

 

2,286,872

 

3,383,874

 

1,038,436

 

91,318

 

860,833

 

37,480

 

759,112

 

2,650,181

 

9,352,337

 

14,789,697

Income Before Other Income

 

(151,729)

 

(71,470)

 

656,419

 

58,743

 

408,866

 

882,760

 

5,333,236

 

7,116,825

Other Income (Loss)

Interest Expense

 

(299,161)

(369,742)

(238,233)

(765,692)

(5,069,899)

(6,742,727)

Gain on sale of real estate

 

 

(299,161)

(369,742)

(238,233)

(765,692)

(5,069,899)

(6,742,727)

Net Income (Loss)

$

(450,890)

$

(71,470)

$

286,677

$

58,744

$

170,632

$

117,068

$

263,337

$

374,098

Net Income (Loss)—NERA 50%

    

$

(225,445)

$

(35,735)

$

143,339

$

29,372

$

85,316

$

58,534

 

55,381

Net Income —NERA 40%

    

$

105,335

 

105,335

$

160,715