Prudential Checklist

THE NHP FOUNDATION AND ITS AFFILIATED ENTITIES

SUPPLEMENTARY INFORMATION - CONTINUED

UNAUDITED CONSOLIDATING STATEMENT OF ACTIVITIES - REAL ESTATE ENTITIES - CONTINUED

Year ended December 31, 2017 __________

Asmara

The Grove at Trinity Mills

Creek Hollow

Heritage Square

The Highlands

Stone Ridge

Magnolia

Milliken Affordable

Rent revenue

$

846,528

$

1,017,223

$

1,072,919

$

2,523,700

$

1,461,489

$

753,853

$

- -

-

-

-

-

-

-

Contribution income - non-affiliates

Interest income Other revenue

9

9

7

24

8

4

459,293

120,226

17,880

101,958

263,890

116,549

39,689

6,115

Gain (loss) on sale of properties

3,302,542

3,821,387

4,082,693

12,501,056

7,862,709

5,726,603

-

4,269,305

4,856,499

5,257,577

15,288,670

9,440,755

6,520,149

465,408

Total revenue

Salaries and benefits

141,293 364,239 70,308 96,790 72,790

126,239 234,473

157,303 408,717 51,444 64,621 44,680

258,017 581,727

151,220 595,445 146,006 284,506 66,007

87,307 192,401 137,430 46,673 43,461 30,182 30,292

- - - - - - - - - - - - - - -

Facilities and maintenance

Interest Utilities

8,130

(162,641)

72,583 37,579

202,711 102,575

Insurance

Real estate taxes

-

-

-

-

-

Property management fees Asset management fees

37,597 17,147

40,546 20,004

45,786 19,451

110,153 50,609 20,966

63,522 29,081 13,253

-

Accounting expense

7,796 6,912

7,276 2,330

8,835 4,460

1,480

Legal

4,284

6,841

-

Management and administration

119,578

108,909

100,983

194,143

174,929

54,012

-

-

-

-

-

8,545 4,630

Consulting expense

Marketing

8,230

5,649

6,425

1,958

6,602

Bad debt expense

24,242

27,970

30,243

49,160

21,227

13,791

335

61

114

46

468

-

Travel

Contributions expense

2,783,335

4,421,626

4,119,237

11,509,185

4,937,984

425,725 85,325

174,542

Depreciation Amortization

88,716

87,688

72,631

227,907

234,164

- - -

- -

- -

- -

- -

- -

-

26,041

Other financial expense and acquisition fee

Other losses (income) in

-

-

-

-

-

-

-

investment in housing funds

Total expense

3,839,308

5,201,063

5,134,930

13,150,800

6,731,255

1,187,295

174,542

Excess of revenue over expenses (expenses over revenue) attributable to the Organization - continued operations

429,997

(344,564)

122,647

2,137,870

2,709,500

5,332,854

290,866

Excess of revenue over expenses attributable to the Organization - discontinued operations

-

-

-

-

-

-

-

Excess of revenue over expenses (expenses over revenue) attributable to the Organization

$

429,997

$

(344,564)

$

122,647

$

2,137,870

$

2,709,500

$

5,332,854

$

290,866

- 64 -

Powered by