Hotel Directors Meeting March 2020

Capital EXPENDITURE

Forecast (PROJECT)

Site Maintence Plan (New Build)

-

Approved on a Project basis

5,700

5,700

-

-

-

Total CAPEX

-

5,700

-

-

-

-

-

-

-

-

-

-

5,700

Quorn Grange Hotel

CASH Flow

JAN

FEB

MAR

APR MAY

JUN

JUL

AUG SEP

OCT

NOV

DEC

TOTAL

FORECAST

Actual

Actual Forecast Forecast Forecast Forecast Forecast Forecast Forecast Forecast Forecast Forecast

Forecast

Operating Profit/Loss

(32,699)

(416)

23,651

31,442

46,902

45,138

44,645

50,992

50,784

21,567

2,174

16,990

301,170 -

Working Capital

26,279

15,320

-

25,000

(50,000)

25,000

25,000

(50,000)

20,000

(20,000)

(70,000)

(20,000)

(73,401)

Capital Expenditure

-

5,700

-

-

-

-

-

-

-

-

-

-

5,700 -

Depreciation

6,500

6,500

6,500

6,500

6,500

6,500

6,500

6,500

6,500

6,500

6,500

6,500

78,000

GFTU Loan

-

-

-

-

-

-

-

-

-

-

-

-

-

Exceptional

-

-

-

-

-

-

-

-

-

-

-

-

-

NET Cash Flow

80

27,104

30,151

62,942

3,402

76,638

76,145

7,492

77,284

8,067

(61,326)

3,490

311,469

Closing Funds

30,840

57,944

88,095

151,037

154,439

231,077

307,223

314,715

391,998

400,065

338,739

342,229

342,229

Hotel Profit Contribution *

80

27,104

30,151

62,942

3,402

76,638

76,145

7,492

77,284

8,067

(61,326)

3,490

311,469

Cash Flow Commentary

The Budgeted Cash Flow Forecast for the year is before GFTU Loan Repayments. The Cash Flow Forecast assumes the Trading Forecast is achieved and that Deposit Trading remains constant.

Revenue & Operating Profit