Prudential Checklist

THE NHP FOUNDATION AND ITS AFFILIATED ENTITIES

SUPPLEMENTARY INFORMATION - CONTINUED

UNAUDITED CONSOLIDATING STATEMENT OF ACTIVITIES - SUMMARY - CONTINUED

Year ended December 31, 2017 __________

Operation

Real Estates

Tax Credits

Other

Elimination

NHPF

Pathways

Interstate

Entities

Entities

Entities

Entries

Total

Salaries and benefits

5,926,679

1,088,360

-

3,439,741

4,949,790

27,381

-

15,431,951

Facilities and maintenance

-

-

-

4,631,476

4,137,350

-

-

8,768,826

Interest

326,527

-

-

5,927,476

8,327,104

-

(2,642,984)

11,938,123

Utilities

-

-

-

2,059,869

3,335,964

-

-

5,395,833

Insurance

73,086

-

-

1,099,944

1,669,246

-

-

2,842,276

Real estate taxes

-

-

-

379,099

2,356,006

-

-

2,735,105

Property management fees

-

-

-

904,672

1,394,675

-

-

2,299,347

Asset management fees

-

-

-

266,277

149,958

30,000

(383,338)

62,897

Accounting expense

108,175

18,000

-

191,854

233,680

2,500

-

554,209

Legal

244,788

7,504

-

163,829

231,622

-

-

647,743

Management and administration

1,856,223

512,353

434

2,408,187

3,935,095

-

(118,349)

8,593,943

Consulting expense

1,134,434

21,600

-

89,329

139,642

-

-

1,385,005

Marketing

301,917

11,995

-

85,865

154,145

-

-

553,922

Travel

674,338

108,524

-

5,601

5,941

-

-

794,404

Bad debt expense

2,740,408

35,000

-

440,513

235,537

-

(2,740,408)

711,050

Directors fee expense

15,000

-

-

-

-

-

-

15,000

Resident service fees

804,136

-

-

-

-

-

(804,136)

-

Contributions expense

1,000

-

524,013

39,314,416

-

707,634

(37,104,210)

3,442,853

Other financial expense and

-

-

-

71,949

135,304

1,560,000

(780,000)

987,253

Depreciation

94,602

-

-

3,376,833

8,815,170

-

-

12,286,605

Amortization

745

-

-

3,898

196,526

-

-

201,169

Other losses (income) in investment in housing funds

2,866,163

-

-

(319)

-

(31,656,815)

28,790,648

(323)

Total expense

17,168,221

1,803,336

524,447

64,860,509

40,402,755

(29,329,300)

(15,782,777)

79,647,191

Excess of expense over revenue (expenses over revenue)

20,972,427

(305,137)

(745,421)

4,326,273

(7,253,703)

29,821,842

(22,244,674)

24,571,607

Excess of expenses over revenue attributable to noncontrolling interests

-

-

-

-

7,252,979

-

-

7,252,979

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

$

20,972,427

$

(305,137)

$

(745,421)

$

4,326,273

$

(724)

$

29,821,842

$

(22,244,674)

$

31,824,586

- 57 -

Powered by