07-25-19 - BOARD BOOK

Frenchman's Creek Inc.

Financial Statements

Cash Flow 19-20

Actual May-19

Actual Jun-19

Forecast

Forecast

Forecast

Forecast

Forecast Nov-19

Forecast

Forecast

Forecast

Forecast

Forecast

Annual

Year End Balance

000's

Jul-19

Aug-19

Sep-19

Oct-19

Dec-19

Jan-20

Feb-20

Mar-20

Apr-20

Total

Operating Activities

Beg Bal

19/20

7,200 $

Beginning Cash Balance

91

269 484

142

24

137

(123) (529)

(198) (259)

(292) (590)

(152)

142 293

37

(76)

(0)

Projected Net Income (Loss)

6,150 1,994

1,331

5

(266)

2,198

230

(2,486)

(933)

(521)

5,628 1,745

(Increase)/ Decrease in A/R

24 31

24 34

16 35

20

23

23

23

17

17

18

24 45

20

249

(Increase) /Decrease Renovation A/R

828

(25)

(54) (22)

(80) (19)

(74) (36)

3

(18)

(31)

135 552

0

828

(Increase)/Decrease in Inventory

2,244 1,641 2,912 1,319 1,764 7,603

(125) (245)

(462)

(312)

36

77

90

113

108 212 131

(0) (0)

2,244 1,641 2,912 1,097 2,035 7,913

(Increase)/Decrease in Prepaid Exp.

151 211

135 343

(294)

393 232

331

(426) (417)

389

(518)

(15) (33) (19)

(114) (550)

Payables increase/(Decrease)

(76) (19)

384

80

(326)

20

0

Accruals Increase/ (Decrease)

(19) (67)

(18)

(18)

(18)

(18)

(18)

(18)

(19)

(19)

(19)

(222)

Bank of America Loan (WF as of 07/02/19)

24

(114)

(4)

58

80

52

38

51

42

30

80

272 310

Reserves Increase/(Decrease)

903

918

859

859 717

(829)

(882)

(876)

(873)

(878)

(874) (364)

1,118

865

Deferred Income

1,940

1,543

1,091

2,120

(1,138)

(2,229)

(1,575)

(1,177)

(800)

(40)

88

Net Cash Provided (Used) Operations

New Home Sales

Funded in the Year

5

4

4

1

-

-

-

-

-

-

-

-

14

Financing Activities Issuance of Membership Certificates (14)

815

700

700

175

- -

- -

- -

- -

- -

- -

- -

- -

2,390

2,390

(331)

(256)

(231)

(60)

(878)

(878)

Redemption of Membership Certificates

194

195

193

193

49

47

46

46

46

47

201

192

1,450

1,450

Capital Contributions

(240)

(437)

(789)

(327)

(428)

(135)

(161)

(59)

(119)

(112)

(101)

(14)

(2,920)

(2,920)

Acquisition of Property & Equipment

202

202

202

202

202

202

202

202

202

202

202

202

2,428

2,428

Change in 2019 Renovation Equity

(12)

(19)

(11)

(11)

(6)

(15)

(1)

(3)

(1)

(2)

(3)

(7)

(90)

(90)

Change in BOH & Fit Equity

628

386

65

172

(182)

100

87

187

128

135

299

374

2,380

2,380

Net Cash Provided (Used) Capital

2,568

1,929

1,156

890

1,937

(1,038)

(2,142)

(1,388)

(1,049)

(229)

(500)

334

2,467

Net Cash Balance Capital/Operations

9,768

11,697

12,853

13,743

15,680

14,642

12,500

11,112

10,063

9,834

9,334

9,668

9,668

Ending Total Cash Balance

7,200

202 575

202 230

202

202

202

202

202

202

202

202

202

202

2,428

Less 2019 Renovation Assessment (WF)

1,170

-

-

-

-

-

-

-

-

-

-

805

Less Home Turn Tranche (WF)

-

777

432

202

202

202

202

202

202

202

202

202

202

3,233

4,402

Wells Fargo Pledge Account

1,170

400

400

400

400

400

400

400

400

400

400

400

400

Less Water Front Maintenance Fund

7,421 5,818

8,918 7,274

9,871 8,174

10,559

12,294 11,021

11,053 10,211

8,709 8,069

7,119 6,609

5,868 5,266

5,437 4,828

4,734 4,389

4,865 6,743

Total Unrestricted Funds

6,031

9,275

Prior Year Cash Balance 18-19

31/88

7/17/20195:39 PM