EC Meeting Papers January 2018

QUORN GRANGf HOTEL MANAGEMENT ACCOUNTS BALANCE SHEET

Hotel As at

Hotel As at

Hotel As at

Hotel As at

Hotel As at

Hotel As at

Hotel As at

Hotel As at

Hotel As at

Hotel As at

Hotel As at

BALANCE SHEET

30-Nov-17

31-Oct-17

30-Sep-17

31-Aug-17 31-Jul-17 30-Jun-17 30-May-17 30-Apr-17 31-Mar-17 28-Feb-17 31-Jan-17

Fixed Assets Furniture and Fixtures

221,603 204,192

224,597 207,683

221,417 211,174

224,411 227,406 230,400 214,665 218,155 221,646

218,934 225,137

217,729 228,628

219,160 221,155 224,149 232,119 235,611 239,102

Refurbishments

Investments

2 0

2 0

2 0

2 0

2 0

2

2

2

2

2

2

New build

11,508

Total Fixed Assets

425,797

432,282

432,593

439,078 445,563 463,556

444,073

446,359

451,281 456,768 463,253

Current Assets Food Stock Liqour Stock

5,713 7,673

6,171 6,384

4,255 6,089

8,074 8,292

4,371 8,176

6,316 6,333

4,547 3,895

4,153 3,434

5,104 3,862

4,742 4,920

4,653 5,820

Debtors

49,711 28,341 34,463

42,645 104,952 38,228 (81,313) (125,652) (244,500)

32,695 111,777 31,060 (89,909) (125,652) (254,500)

19,705 99,871 33,788

40,712

45,621

47,950 111,247 51,430 (87,466) (125,652) (284,500)

62,677 91,763 56,926

46,836 51,225 91,763 91,763 61,833 19,475 (79,271) (94,392) (125,652) (125,652) (294,500) (294,500)

39,563 91,763 22,801

Other Debtors Prepayments

97,896 100,444

39,446

45,428

Due to/from Hotel & Nursery Due to GFTU Educational Trust

(73,037) (110,655) (166,782)

(98,660) (125,652) (254,500)

(93,500) (125,652) (264,500)

(89,673) (125,652) (274,500)

(96,482) (125,652) (294,500)

(101,310) (85,507) (294,536)

GFTU

Cash at Bank

3,411 1,629

9,585 1,629

7,476 1,631

34,366

66,127

61,434

24,694

59,307

21,317

4,287 1,406

30,938

Petty Cash

1,959

1,404

1,407

1,406

1,406

1,406

1,406

Total Current Assets

(219,534)

(241,869)

(275,081)

(272,758)

(225,522)

(222,844)

(252,449)

(236,969)

(267,302) (336,726)

(284,409)

Current Liabilities Trade Creditors

167,584 18,094

169,873 14,442

136,820 16,635

155,475 167,766 188,338

156,833 19,153

151,853 17,984

140,395 90,858 18,441 23,639

91,113 21,111

Accruals

15,982

16,685

16,976

Other Creditors Deposits Held

409

409

409

406

406

406

366

366

366

366

366

67,656 12,906 44,403

64,876 12,949 68,631

67,507 12,626 52,902

81,042 14,932 37,622

92,274 109,811

98,412 17,033 31,204

99,649 13,183 55,609

98,524 68,433 12,683 13,802 40,953 25,021

68,124 13,399 54,421

PAYE & NIC Payable

13,351 69,032

13,428 49,440

VAT Liability

Provision for Liabilities Total Current Liabilities

2,152

2,152

2,152

2,152

2,152

2,152

2,152

2,152

2,152

2,152

2,152

(313,204)

(333,333)

(289,051)

(307,611)

(361,666)

(380,552)

(325,153)

(340,795)

(313,619) (224,375)

(250,790)

Creditors due > 1 Year Intercompany Loans

(568,719)

(508,719)

(508,719)

(508,719)

(508,719)

(508,719)

(508,719)

(508,719)

(508,719) (508,719)

(508,719)

Net Assets

(675,661)

(651,640)

(640,258)

(650,010)

(650,345)

(648,559)

(642,248)

(640,124)

(638,359) (613,053)

(580,664)

Capital & Reserves Share Capital P & L Account Reserves b/fwd Charge for period

2

2

2

2

2

2

2

2

2

2

2

(529,100) (146,563) (675,661)

(529,100) (122,542) (651,640)

(529,100) (111,160) (640,258)

(529,100) (120,912) (650,010)

(529,100) (121,247) (650,345)

(529,100) (119,461) (648,559)

(529,100) (113,150) (642,248)

(529,100) (111,026) (640,124)

(529,100) (529,100) (109,261) (83,955) (638,359) (613,053)

(529,100) (51,567) (580,664)

Made with FlippingBook flipbook maker