club project 2011 final

7/29/2019 Club Project 2011 Final

1/27

A Highlights of the Project

B 1 Introduction

2.About the Promoter

3.The Project

4. Marketing Strategies

5.Statutory Requirement

C Project Cost & Sources of Finance

1.Estimates

2.Means of Finance

D Security Offered to Bank

1. Primary Security

2. Collateral Security

E Projections of Performance, Profitability & Repayment

F Repayment Schedule

For SUDHIR SEN & CO

CHARTERED ACCOUNTANTS

PLACE : JODHPUR SUDHIR

DATED : M.NO. 72584

PROP

SUDHIR SEN & CO.

503, DEFENCE COLONYCHOPASNI ROAD, JODHPUR

PH : 9314031555

PROJECT REPORT

Submitted by

HERITAGE MILLENNIUM SPORTS CLUB LIMITED

This project report is prepared as per data and information provided by partner.


2/27

A Highlights of Project1 Name of Enterprise :

2 Constitution : COMPANY

3 Address for correspondenc

Administrative Office & Project : KHASRA NO 11/1

Site : RAJEEV GANDHI NAGAR LINK ROAD

: PAL VILLAGE, JODHPUR

4 Names of Directors : SHRI VIRENDRA S. MEHTA,

BIREN M. PATEL

DHAN PAL R. MEHTA

5 Nature of Business : CLUB HOUSE

6 No. of working days : 365 Days

7 Manpower required : 36 Persons

8 Project Cost : ` ( Lac )

a) Land 390.62

b) Building Construction 1,500.00

c) Plant & Machinery 105.00

d) Furniture & Fixture 50.00

e) Security Deposit 15.00f) Working Capital 10.00

g) Preliminary Expenses 78.00

2,148.62

9 Sources of Funds

a) Term Loan from Bank 828.00

b) Working Capital Loan 7.50

c) Unsecured Loans 1,060.62

d) Capital 5.00

e) Life Membership Fee Capital Receipts 247.50

2,148.62

10 Profitability in Year's : ` ( Lac )

2013-14 2014-15 2015-16 2016-17 2017-18 2018-19

a) Cost of Operations 512.08 513.09 500.61 486.69 474.60 461.80

b) Gross Receipts 664.56 852.85 895.49 921.07 959.45 959.45

c) Net Profit - Before Ta 152.48 339.76 394.88 434.39 484.85 497.65

11 I Year 2nd Year 3rd Year 4th Year 5th Year 6th Year

60% 70% 70% 72% 75% 75%

Minimum Expected

Annual Growth in


3/27

B Introduction

B 1.

B 2 Bio Data of the Directors

Main Director

a) Name : SHRI VIRENDRA S. MEHTA,

b)Father Name : SHRI SHANTILAL HARILAL MEHTA

c) Age : 64 Years

d) Address : R/O- FLAT NO 121, 12TH FLR. BLD. NO C,

RAMBHA NEPEAN SEA ROAD,

MUMBAI-400006

Others

B 3 The Project :

This private limited concern is going to set a club house alongwith star hotel. The hotel industry in the city

of Jodhpur is well in demand. The hotel accomodation and ameneties requirement are regularly increasing in

the city of Jodhpur.

The concern is willing to establish a club with the all required facilities in JDA land. They want to establish a

club with rooms, alongwith, resaturant and Conferance Halls, bars, etc.

The club shall provide all the modern facilities like Air Conditions, Modern Funirture, CCT Tv

security systems, Fitted with latest fire fitting equipments, LCD T.Vs, Hot and Cold Water Facilities,

High Speed Internet Services, 24 hour restaurent facilities and room service. Club shall extend allied

services like arranging cab services, sightseeing etc. The promotor of theclub is intend to provide all *

STAR facilities to the customer of the hotel and will follow all the norms applicabel to * STAR category

Name and Father Name

Shri Virendra S. Mehta s/o Shri Shantilal H.

Shri Dhan Pal R. Mehta s/o Shri Rajendra R

Shri Biren M. Patel S/o Shri Madanlal N. P

All the directors are belonging to the one family and doing the same business


4/27

B 4 Marketing Strategy :

B 5 Statutory Requirement :

MSME Registration : Firm will get registration in due couse.

MAP : Club Map will be approved by the Local Authority.

Star Categorty approral will be taken from the Tourisum Department of Central and State

Consent and NOC from the Rajasthan Polltion Control Board will be taken in due course.

Power Connection : The require power connection will also taken in due course.

Water : Water will be available.

The directors are willing to employee well trained staff for running and supervision of the club. They will

also contact travel agencies and other tour operators for the booking of the hotel. The restaurant is a place

where services are the best advertise and will provide good food with pleasing atomosphere which will

increase the demand day by day

Sales Tax Registration : The Firm will get registration in sales tax department. Tin No 087027110

Jodhpur is one of the major attractions for all foreign tourist visiting India and now also growing

week - end destination for Gujrat, Delhi and NRE residents. The occupancy number of existing

properties in Jodhpur confirm a shortage of rooms in season months and this shortage is likely to

accelerate with the expected increase in number of foreign tourist over the coming years.

Sales and Marketing tools used will be following : local Media advertising, Hoarding, Tie - ups with

credit card companies, sales call to the target segment in country and in key international markets

such as UK Middle East, and Russia as well as visit to international travel fairs etc.


5/27

C Project Cost & Sources of Finance

C 1

` ( Lac )

a) Land 390.62

b) Building Construction 1,500.00

c) Plant & Machinery 105.00

d) Furniture & Fixture 50.00

e) Security Deposit 15.00

f) Working Capital 10.00

g) Preliminary Expenses 78.00

2,148.62

a) Land

b) Building

c) Plant and machinery

d) Furniture and Fixture

Project Cost Estimates : The total cost of project works out to be Rs. 2148.62 lac. The break up of the

project cost is as under :-

The building will be built on this commercial land according to the plan finalised by the technical experts.

This is a hotel building with all types of modern facilities . Hence all type of the care will be taken for this

buiding.

Estimated cost of all the Furniture and Fixture is Rs. 50 Lac.

The list of the plant and machinery is separately attached. The Plant and Machinery quotations are taken from

different firms and final selection of the supplier and order placing will be done at the time of the installation

of the machinery.

The room furniture will be manufactured and laid according to the map given by the interior experts and

same will be in the good poly wood material. The reception and restaurant furniture will be on theme base

and will be more attractive and unique in the city of Jodhpur.

Estimated cost of all the machinery required is Rs. 105 Lac.

Estimated cost of the Building is Rs.1500 Lac.

The building includes 24 room as delux accomodations. The provision for Reception, Resaturant, Three

Conference hall, Swimming Pool, Tennis Court, Golf, Squash, Gym etc is also in considered in the plan.

The unit has taken the land on 09.12.2010. The area of land appro. 29336 Sq Mtrs. The land is located atprime place of the Jodhpur It is now a days the developing area of the city of Jodhpur. The total cost of the

land is 390.62 lacs


6/27

e) Working Capital

g) Preliminary Expenses

The priliminary expenses inculde the interest during the construction period and also some adminstrative

expenses incured during that period.

The unit is in a service industry and the working capital requirement is not as much as required in the other

business. It requires working capital only for smooth running of the hotel which is only one month's expenses.

And hence only Rs 10 Lac is sufficenet as working capital of this project.


7/27

C 2 Means of Finances : The firm intends to finance the project cost through following means :

` ( Lac )

a) Term Loan from Bank 828.00

b) Working Capital Loan 7.50

c) Unsecured Loans 1,060.62

d) Capital 5.00

e) Life Membership Fee Capital Receipts 247.50, .

c) Unsecured Loans :

D

D1. Secur ty O ere to Ban

D 2 Collateral Security :

Owner : SHRI VIRENDRA S. MEHTA, BIREN M. PATEL, DHANPAL R. MEHTA

Primary Security : All the stocks of raw materials, stores, finished goods, and plant & machinery will be

hypothecated to the Bank. The bank will have a lien over the book debts, land and building will also be

offered as prime security.

f) Profits : As a policy, the proprietor will retain major part of the profits in the business to meet working

capital requirements, expanstion and modernisation of the unit.

The loan is required for consutruction of the of building (Rs. 1500 Lac), purchase of Plant and Machinery

(apx. Rs 105 Lac ) and Furniture and Fixture ( Rs. 50 Lac) totaling cost of the all theses three items will be

Rs 1655 Lac. The firm is seeking Term Loan from Bank to the extent of 50 % of value fo Fixed Assets. The

firm required Total Loan of Rs 828 + 7.50 = 835.50 Lac, the firm intends to repay the Term Loan in 84

months, by monthly instalments.

The firm is intend to invest own capital and will also take loan of Rs 1060.62 Lacs from the close relatives

Club land and building will also be offered as Collateral Security.

a) Term Loan from Bank :

d Ca ital :

b) Working Capital Requirements

The authorised share capital of the concern is Rs 5 Lac which is fully issued and subscribed

It is an service oriented unit First year it requires Rs. 10.00 Lac as working capital against which the

company is seeking a WC Loan of Rs. 7.50 Lac from Bank on renewable on annual basis.

e Life Membershi Fee Ca ital Recei ts

The company is going to set up a club house and in the first year it will take the 250 person as life members.The membership fee taken is amount to Rs 99000/- per person. The total capitalised amount is comes to Rs

247.50 Lac.


8/27

Total Area of Land 29,336.46 SQ. MTRS

18 Bigh 2 Biswa & 9 Biswansi

35,073.05 Sq Yards

` ( Lac )

S.No Particulars of Land Size in Total Sq Actual Cost Paid DLC Value Market

SQ. MTRS Yards as in 2012 Value

a) Khasra No: 11/1

Rajeev Gandhi Nagar Link Road 29,336.46 35,073.05 39,072,230 3,600 126,262,980

Jodhpur

Owner : Shri Virendra S. Mehta, Bir

Dhan Pal R. Mehta

35,073.05 39,072,230 126,262,980

E

F Repayment Schedule

F 1 The firm intends to :

a)Repay the Term Loan over a period of 7 years in 84 monthly instalments ;

b)Renew the Working Capital facility on annual basis

Land Acquire in the year 09-12-

2010

Please refer to the statement marked Annexure and attached herewith. Profitability will constantly improve

every year.


9/27

` ( Lac )

COST OF PROJECT EXISTING PROPOSED TOTAL

31.03.2012

Land 390.62 - 390.62

Building 147.89 1,352.11 1,500.00

Plant & Machinery 5.94 99.06 105.00

Furniture & Fixture 0.48 49.52 50.00

Investment - Secutiry Deposit - 15.00 15.00

- 10.00 10.00-

15.93 62.07 78.00

560.86 1,587.76 2,148.62

MEANS OF FINANCE

Capital 5.00 - 5.00

-

Life Membership Fee Capitalised - 247.50 247.50

555.86 504.76 1,060.62

Term Loan From Bank - 828.00 828.00

Working Capital Loan - 7.50 7.50

560.86 1,587.76 2,148.62

- - -

Unsecured Loan - Director & Members

Priliminery Expenses

Working Capital

COST OF PROJECT & MEANS OF FINANCE

ANNEXURE - I


RAJIV GANDHI NAGAR LINK ROAD

PAL VILLAGE, JODHPUR


10/27

` ( Lac )

Requarments

Land 390.62

Building 1,500.00

Plant & Machinery 105.00

Furniture & Fixture 50.00 1,655.00

2,045.62

Land 0% -

Buiding 50% 750.00 50.03

Plant & Machinery 50% 52.50

Furniture & Fixture 50% 25.00

827.39

OR SAY 828.00

Loan - From Financial Institute





11/27

1 DETAIL OF LAND

Owner : SHRI VIRENDRA S. MEHTA, BIREN M. PATEL, DHANPAL R. MEHTA

Total Area of Land 29,336.46 SQ. MTRS

18 Bigh 2 Biswa & 9 Biswansi

35,073.05 Sq Yards

` ( Lac )S.No Particulars of Land Size in Total Sq Actual Cost Paid DLC Value Market

SQ. MTRS Yards as in 2012 Value

a) Khasra No: 11/1

Rajeev Gandhi Nagar Link Road 29,336.46 35,073.05 39,072,230 3,600 126,262,980

Jodhpur

Owner : Shri Virendra S. Mehta, Biren M. Patel,

Dhan Pal R. Mehta

35,073.05 39,072,230 126,262,980

2 DETAIL OF BUILDING

As per Report of Engineer

Plot Area 29,336.48

Permissible Hight 30 Mtrs = 95'4"

Permissible F.A.R. 1.00

Total Permissible Floor Area 29,336.48

Build Up Area

Ground Floor Area 6,318.94 Sq Mtrs

First Floor Area 3,527.59 Sq Mtrs

Second Floor Area 904.47 Sq Mtrs

Basement Floor Area 2,917.24 Sq Mtrs

Total Built up Area 13,668.24 Sq Mtrs




Land Acquire in the year 09-12-2010


12/27

S.No Particulars Sq. Mtr Rate - in Sq Mtrs Amount

` `

1 Basement -

Lift, Service Lift and Utility 2,917.24 7,762.23 22,644,287.85

2 Ground Floor 6,318.94 9,425.57 59,559,579.70

Parking , Ramp

Banqet Hall (3) , Kitchan, Store,

Restuarent, Bar, Receiption

Badminton Court, Squash Court (2)

Room (21)

Toilets, Driver Room

Lift, Service Lift and Utility

Gym, Masage Parlor, Areobics Yoga, Sona Etc

3 First Floor - 3,527.59 11,643.35 41,072,947.39

Rooms - 24

Snooker, Carom, Chess Hall

Beauty Parlour,Confirmance Room Disco Thech

Toilets

Lift, Service Lift and Utility

7 Terrace Floor And Second Floor

Lift, Service Lift and Utility 904.47 12,752.24 11,534,013.99

Ground Floor Parking Area, Swimming Pool 9,189,171.07

Boundry Wall ( Artistic Work) 6,000,000.00

13,668.24 150,000,000.00

Average Rate per Sqr Mtrs 10,974.35

Average Rate Per Sqr Feet 989.67


13/27

3 DETAIL OF PLANT AND MACHINERY

S.No Particulars Qty Rate Amount Total

` ` `

MACHINERY

Electronic Items

T.V.- LCD 25 15,000.00 375,000.00

A.C. For Rooms & others 50 17,500.00 875,000.00

Fan 100 1,250.00 125,000.00

Vi Fi System 4 15,000.00 60,000.00

Telephone 50 750.00 37,500.00EPBX - 150 Lines 1 35,000.00

CC TV 10 4,000.00 40,000.00

Computer With Printer 3 30,000.00 90,000.00

Lift 1 LS 1,200,000.00

D.G. Set 2 1,500,000.00

Fire Safty Equipments L.S. 450,000.00

Swimming Pool Filter Plant 1,800,000.00

Other Assessories of Swimming Pools 350,000.00

Pump 4 9,000.00 36,000.00

R.O. Plant 50,000.00

7,023,500.00

Kitchan Utensile and Service Equipment

Kithcan Utensiles & Crokery L.S. 250,000.00

Servie Equipments L.S. 325,000.00575,000.00

GAMES, SPA, GYM AND OTHER MATERIALS 2,500,000.00

Other Miscellaneous Assets 401,500.00

10,500,000.00





14/27

3 DETAIL OF FURNITURE

S.No Particulars Qty Rate Amount Total

` ` `

FURNITURE

Room Furniture

Bed 25 12,500.00 312,500.00Foam Bed and Pillow 25 6,000.00 150,000.00

Ward Rob 25 7,500.00 187,500.00

Chair 50 1,000.00 50,000.00

Side Table 25 1,500.00 37,500.00

Central Table 25 2,500.00 62,500.00

Dressing Table 25 4,500.00 112,500.00

Photo Frame 75 750.00 56,250.00

Cutain, Bed Cover , Bed Sheet etc 50 4,500.00 225,000.00

1,193,750.00

Receiption, Resturent, Bar and Office Furniture

Receiption Counter 3 125,000.00 375,000.00

Sofa 10 17,500.00 175,000.00

Central Table 3 2,500.00 7,500.00

Side Table 4 1,500.00 6,000.00Chair 10 1,000.00 10,000.00

Office Table 6 7,500.00 45,000.00

Office Furniture L.S. - 100,000.00

Locker 2 15,000.00 30,000.00

Table's for Restaurent 25 4,500.00 112,500.00

Chair 's for Restaurent 150 1,250.00 187,500.00

Table's Conference Room 15 4,500.00 67,500.00

Chair 's for Conference Room 70 1,250.00 87,500.00

News Paper Stand 4 3,500.00 14,000.00

Water Cooler 4 15,000.00 60,000.00

Table's for Bar 25 4,500.00 112,500.00

Chair 's for Bar 150 1,250.00 187,500.00

furniture for Beauty Parlour, Saloon LS 1,000,000.00

2,577,500.00

L.S. 1,228,750.00

5,000,000.00



Receiption, Bar and Passage intirriro



15/27

` ( Lac )

REALISATION PER MONTH

1.00 0.60

1 REALISATION - ROOM RENT

a) No of Room Rate Realisation Working Days

Rooms - - - - - -

Delux Room 24 2,500 60,000 365 219.00 131.40

Party/Function/Event - No 30 75,000 2,250,000 3 67.50 40.50

(Only Rent Charges) - - - (Hall)

54 2,310,000

b) Resaturent Receipts From Hotel Stayers and Others

Capacity Average Per Day Working Days

seats Realisation Realisation

Delux Room 48 500 24,000 365 87.60 52.56

Other's - 200 200 350 70,000 365 255.50 153.30

Delux Room 48 800 365 140.16 84.10

Guest Entry Fee 100 800 - 365 292.00 175.20

Temporary members 500 2,500 1 12.50 12.50

Yearly Maintence & Dev

Charges 250 2,000 3 15.00 15.00

YEARLY REALISATIONS AT 100 % and 60 % UTILISATION 1,089.26 664.56

CAPITAL RECEIPTS

Annual Fees(one time) 250 99,000 1 247.50

-

-

247.50

Membership Fees




Utilisation

Membership Fees

Room Rent

Bar/Disco Revenue


16/27

COST

1 COST OF PURCHASES

A)

3,600 365 1,314,000 13.14

Consumable Room ( 55 % of Realisation) 7,920 365 2,890,800 28.91

Consumable Restaurent ( 55 % of Realisation) 23,100 365 8,431,500 84.32

Consumable Party ( 10 % of Realisation) 4,800 365 1,752,000 17.52

Consumable Bar ( 45 % of Realisation) 10,368 365 3,784,320 37.84

POWER - LS 125,000

CONSUMABLES 35,000

WATER 5,000

165,000 165,000 12.00 19.80

C) WAGES & SALARY

SKILLED STAFF 6 12500 75,000

UNSKILLED STAFF 25 5000 125,000

ACCOUNTANTS 2 7500 15,000

CHOWKIDAR 3 3500 10,500

36 225,500

FRIENGE BENEFIT 15 % 33,825 259,325 12 31.12

3 ADMIINISTRATIVE EXPENSES

BANK CHARGES 1,500

PERTOL / CONVERYANCE EXPENSES 7,000

POSTAGE, PRINTING & STATIOENRY 350

TELEPHONE EXPENSES 2,000

TRAVELLING 10,000

ADVERTISEMENT EXPENESES 5,000

INSURANCE EXPENSES 4,500

AUDITING AND OTHER PROFESSIONLA FEE 2,000

PERIODICALS AND BOOKS 2,000

MEETING EXPENSES 7,500

GENERAL EXPENSES 8,150

50,000 50,000 12 6.00

TOTALSALARY

NO OFPERSION

SALARY

Working Days

B) CONSUMABLES & UTILITY-

Per Day

Room - Expenses (10% of Realisation)

TOTAL in Lacs

HERITAGE MILLENNIUM SPORTS CLUB LIMITEDRAJIV GANDHI NAGAR LINK ROAD


PER MONTH MONTH


17/27

5 REPAIR AND MAINTENANCE EXPENSES

PLANT AND MACHINERY @ 2 % OF COST 99,060

BUILDING @ 1 % OF COST 676,055

775,115 7.75

6 DEPRECIATION CHARGES FIXED

LAND 0% -

BUILDING 3.34% 5,010,000

PLANT & MACHINERY 4.75% 498,750

FURNITURE AND FIXTURE 6.33% 316,500 58.25

5,825,250

7 FINANCIAL CHARGES Amount Rate p.a.

1,060.62 9% 9,545,580

828.00 13% 9,792,250

WORKING CAPITAL 7.50 13% 105,000

19,442,830 194.43

8 PRELIMINERY EXPENSES 13.00

TOTAL EXPENSES 512.08

NET SURPLUS SALES REALISATION 664.56

Less TOTAL EXPENESE 512.08

152.48 152.48

TERM LOAN

UNSECURED LOAN


18/27

82,800,000

84 Monthly Installment

Ist Apr 2011

13 % Per Annum

Opening Repayment Closing Monthly Yearly Interest

Balance Balance Interest

- - - - -

2011-12 Sep-11 - - - -

Oct-11 - - - -

Nov-11 - - - -

Dec-11 - - - -

Jan-12 - - - -

Feb-12 - - - -

Mar-12 - - - -

2012-13 Apr-12 1 - - - -

May-12 2 - - - -

Jun-12 3 10,000,000 - 10,000,000 108,333

Jul-12 4 10,000,000 - 20,000,000 216,667

Aug-12 5 10,000,000 - 30,000,000 325,000

Sep-12 6 10,000,000 - 40,000,000 433,333

Oct-12 7 10,000,000 - 50,000,000 541,667

Nov-12 8 10,000,000 - 60,000,000 650,000

Dec-12 9 10,000,000 - 70,000,000 758,333

Jan-13 10 10,000,000 - 80,000,000 866,667

Feb-13 11 2,800,000 - 82,800,000 897,000

Mar-13 12 - - 82,800,000 897,000 56.94

2013-14 Apr-13 13 82,800,000 1,150,000 81,650,000 884,542

May-13 14 81,650,000 1,150,000 80,500,000 872,083

Jun-13 15 80,500,000 1,150,000 79,350,000 859,625

Jul-13 16 79,350,000 1,150,000 78,200,000 847,167

Aug-13 17 78,200,000 1,150,000 77,050,000 834,708




REPAYMENT SCHEDULE AND INTEREST ON TERM LOAN

YEAR MONTHS

Loan Amount Rs. in Lacs

Repayment

Repayment Commencement

Rate of Interest

MONTHS

Repayment will be start from April 2013


19/27

Sep-13 18 77,050,000 1,150,000 75,900,000 822,250

Oct-13 19 75,900,000 1,150,000 74,750,000 809,792

Nov-13 20 74,750,000 1,150,000 73,600,000 797,333

Dec-13 21 73,600,000 1,150,000 72,450,000 784,875

Jan-14 22 72,450,000 1,150,000 71,300,000 772,417

Feb-14 23 71,300,000 1,150,000 70,150,000 759,958

Mar-14 24 70,150,000 1,150,000 69,000,000 747,500 97.92

2014-15 Apr-14 25 69,000,000 1,150,000 67,850,000 735,042

May-14 26 67,850,000 1,150,000 66,700,000 722,583

Jun-14 27 66,700,000 1,150,000 65,550,000 710,125

Jul-14 28 65,550,000 1,150,000 64,400,000 697,667

Aug-14 29 64,400,000 1,150,000 63,250,000 685,208

Sep-14 30 63,250,000 1,150,000 62,100,000 672,750

Oct-14 31 62,100,000 1,150,000 60,950,000 660,292

Nov-14 32 60,950,000 1,150,000 59,800,000 647,833Dec-14 33 59,800,000 1,150,000 58,650,000 635,375

Jan-15 34 58,650,000 1,150,000 57,500,000 622,917

Feb-15 35 57,500,000 1,150,000 56,350,000 610,458

Mar-15 36 56,350,000 1,150,000 55,200,000 598,000 79.98

2015-16 Apr-15 37 55,200,000 1,150,000 54,050,000 585,542

May-15 38 54,050,000 1,150,000 52,900,000 573,083

Jun-15 39 52,900,000 1,150,000 51,750,000 560,625

Jul-15 40 51,750,000 1,150,000 50,600,000 548,167

Aug-15 41 50,600,000 1,150,000 49,450,000 535,708

Sep-15 42 49,450,000 1,150,000 48,300,000 523,250

Oct-15 43 48,300,000 1,150,000 47,150,000 510,792

Nov-15 44 47,150,000 1,150,000 46,000,000 498,333

Dec-15 45 46,000,000 1,150,000 44,850,000 485,875

Jan-16 46 44,850,000 1,150,000 43,700,000 473,417

Feb-16 47 43,700,000 1,150,000 42,550,000 460,958

Mar-16 48 42,550,000 1,150,000 41,400,000 448,500 62.04

2016-17 Apr-16 49 41,400,000 1,150,000 40,250,000 436,042

May-16 50 40,250,000 1,150,000 39,100,000 423,583

Jun-16 51 39,100,000 1,150,000 37,950,000 411,125

Jul-16 52 37,950,000 1,150,000 36,800,000 398,667

Aug-16 53 36,800,000 1,150,000 35,650,000 386,208

Sep-16 54 35,650,000 1,150,000 34,500,000 373,750

Oct-16 55 34,500,000 1,150,000 33,350,000 361,292

Nov-16 56 33,350,000 1,150,000 32,200,000 348,833

Dec-16 57 32,200,000 1,150,000 31,050,000 336,375


20/27

Jan-17 58 31,050,000 1,150,000 29,900,000 323,917

Feb-17 59 29,900,000 1,150,000 28,750,000 311,458

Mar-17 60 28,750,000 1,150,000 27,600,000 299,000 44.10

2017-18 Apr-17 61 27,600,000 1,150,000 26,450,000 286,542

May-17 62 26,450,000 1,150,000 25,300,000 274,083

Jun-17 63 25,300,000 1,150,000 24,150,000 261,625

Jul-17 64 24,150,000 1,150,000 23,000,000 249,167

Aug-17 65 23,000,000 1,150,000 21,850,000 236,708

Sep-17 66 21,850,000 1,150,000 20,700,000 224,250

Oct-17 67 20,700,000 1,150,000 19,550,000 211,792

Nov-17 68 19,550,000 1,150,000 18,400,000 199,333

Dec-17 69 18,400,000 1,150,000 17,250,000 186,875

Jan-18 70 17,250,000 1,150,000 16,100,000 174,417

Feb-18 71 16,100,000 1,150,000 14,950,000 161,958

Mar-18 72 14,950,000 1,150,000 13,800,000 149,500 26.162018-19 Apr-18 73 13,800,000 1,150,000 12,650,000 137,042

May-18 74 12,650,000 1,150,000 11,500,000 124,583

Jun-18 75 11,500,000 1,150,000 10,350,000 112,125

Jul-18 76 10,350,000 1,150,000 9,200,000 99,667

Aug-18 77 9,200,000 1,150,000 8,050,000 87,208

Sep-18 78 8,050,000 1,150,000 6,900,000 74,750

Oct-18 79 6,900,000 1,150,000 5,750,000 62,292

Nov-18 80 5,750,000 1,150,000 4,600,000 49,833

Dec-18 81 4,600,000 1,150,000 3,450,000 37,375

Jan-19 82 3,450,000 1,150,000 2,300,000 24,917

Feb-19 83 2,300,000 1,150,000 1,150,000 12,458

Mar-19 84 1,150,000 1,150,000 - - 8.22

Apr-19 - - - -

82,800,000 37,537,500 375.38


21/27

FIXED ASSETS 2011-12 2012-13 2013-14 2014-15 2015-16 2016-17 2017-18 2018-19

LAND 390.62 390.62 390.62 390.62 390.62 390.62 390.62 390.62

LESS DEP - - - - - - -

390.62 390.62 390.62 390.62 390.62 390.62 390.62 390.62

BUILDING - - 1,500.00 1,449.90 1,401.47 1,354.66 1,309.42 1,265.68

ADDITION - 1,500.00

- 1,500.00 1,500.00 1,449.90 1,401.47 1,354.66 1,309.42 1,265.68

LESS DEP - 50.10 48.43 46.81 45.25 43.73 42.27

- 1,500.00 1,449.90 1,401.47 1,354.66 1,309.42 1,265.68 1,223.41

PLANT & MACHINERY - 5.94 105.00 100.01 95.26 90.74 86.43 82.32

ADDITION 5.94 99.06

5.94 105.00 105.00 100.01 95.26 90.74 86.43 82.32

LESS DEP - 4.99 4.75 4.52 4.31 4.11 3.91

5.94 105.00 100.01 95.26 90.74 86.43 82.32 78.41

FURNITURE - 0.48 50.00 46.84 43.87 41.09 38.49 36.06

ADDITION 0.48 49.52

0.48 50.00 50.00 46.84 43.87 41.09 38.49 36.06

LESS DEP - 3.17 2.96 2.78 2.60 2.44 2.28

0.48 50.00 46.84 43.87 41.09 38.49 36.06 33.77

TOTAL FIXED ASSETS 397.04 2,039.20

DEP - 58.25 56.14 54.11 52.16 50.28 48.47

DEPRECIATION CHART



Rs in Lacs


22/27

` ( Lac )

Particulars 2013-14 2014-15 2015-16 2016-17 2017-18 2018-19

IST IIND IIIRD IVTH VTH VITH

CAPACITY UTILISATION 60% 70% 70% 72% 75% 75%

A REALISATION 664.56 852.85 895.49 921.07 959.45 959.45

B COST

COST OF PURCHASES

A) ALL TYPES MATERIAL 182.73 164.45 164.45 162.39 160.69 157.48

B) CONSUMABLES & UTILITY- 19.80 21.78 23.96 26.35 28.99 31.89

C) WAGES & SALARY 31.12 34.23 37.65 41.42 45.56 50.12

REPAIR AND MAINTENANCE EXPENSES 7.75 8.53 9.38 10.32 11.35 12.48

COST OF SERVICE 241.40 228.99 235.44 240.48 246.59 251.97

ADD OPENING STOCK - 1.00 1.25 1.50 2.00 2.25

LESS CLOSING STOCK 1.00 1.25 1.50 2.00 2.25 2.50COST OF PRODUCTION - B 240.40 228.74 235.19 239.98 246.34 251.72

C Gross Profit A-B 424.16 624.11 660.29 681.10 713.11 707.73

G.P.RATE 63.83 73.18 73.74 73.95 74.32 73.76

C Administrative Overhead

ADMIINISTRATIVE EXPENSES 6.00 6.90 7.94 9.13 10.49 12.07

Total Administrative Overhead C 6.00 6.90 7.94 9.13 10.49 12.07

D Cost of Realisation B+C 246.40 235.64 243.13 249.10 256.84 263.79

E Net Profit Before Interest and Depreicaito 418.16 617.21 652.36 671.97 702.62 695.66

( A - D )

F Financial Charges

Interest on Term Loan 97.92 79.98 62.04 44.10 26.16 8.22

Interest on Unsecured Loan- Relative 95.46 127.27 127.27 127.27 127.27 127.27

Interest on Working Capital 1.05 1.05 1.05 1.05 1.05 1.05

Total Financial Charges F 194.43 208.31 190.37 172.43 154.49 136.55

G Depreciation 58.25 56.14 54.11 52.16 50.28 48.47

H Preliminary Expenses W/O 13.00 13.00 13.00 13.00 13.00 13.00

I Profit Before Tax E-F-G-H 152.48 339.76 394.88 434.39 484.85 497.65

J Provision for Dividend 0.50 1.00 1.50 2.00 2.50 3.00

Provision for Tax - Exempted u/s 35 AD

K Profit After Tax / Net Profit 151.98 338.76 393.38 432.39 482.35 494.65

L Add : Depreciation 58.25 56.14 54.11 52.16 50.28 48.47

M Cash Profit or Accruals 223.23 407.90 460.49 497.55 545.63 556.12

N Repayment of loan 138.00 138.00 138.00 138.00 138.00 138.00

Repayment of Unsecured Loan - - - - - -

O Debt Service Coverage Ratio 1.36 2.24 2.61 2.97 3.48 3.86

P Average DSCR 2.75

Ratio

Gross Profit ( Gp/Sales) 63.83 73.18 73.74 73.95 74.32 73.76

Net Profit (before interest & Depreciation) 62.92 72.37 72.85 72.96 73.23 72.51

Net Profit (After Interest & Depreciation) 22.87 39.72 43.93 46.94 50.27 51.56




ESTIMATED COST OF PRODUCTION AND PROFITABLITY


23/27

2013-14 2014-15 2015-16 2016-17 2017-18 2018-19

Ratio

Gross Profit ( Gp/Sales) 63.83 73.18 73.74 73.95 74.32 73.76

Net Profit (before interest & Depreciation) 62.92 72.37 72.85 72.96 73.23 72.51

Net Profit (After Interest & Depreciation) 22.87 39.72 43.93 46.94 50.27 51.56

DSCR

Capacity utilization % 60% 70% 70% 72% 75% 75%

Sales 664.56 852.85 895.49 921.07 959.45 959.45

Net Profit after tax & Withdrawal 151.98 338.76 393.38 432.39 482.35 494.65

Cash accruals 223.23 407.90 460.49 497.55 545.63 556.12

Interest 194.43 208.31 190.37 172.43 154.49 136.55

TOTAL 417.66 616.21 650.86 669.97 700.12 692.66

TL / DPG repayments 138.00 138.00 138.00 138.00 138.00 138.00

Interest 194.43 208.31 190.37 172.43 154.49 136.55

TOTAL 332.43 346.31 328.37 310.43 292.49 274.55

Gross DSCR 1.26 1.78 1.98 2.16 2.39 2.52

Average gross DSCR 2.02

Net DSCR 1.62 2.96 3.34 3.61 3.95 4.03

CASH ACCRUAL/ TL 3.25





24/27

BREAKEVEN POINT

2013-14 2014-15 2015-16 2016-17 2017-18 2018-19

VARIABLE COST

REALISATION 664.56 852.85 895.49 921.07 959.45 959.45

COST OF PRODUCTION 240.40 228.74 235.19 239.98 246.34 251.72

CONTRIBUTION 424.16 624.11 660.29 681.10 713.11 707.73

FIXED COST

ADMINISTRATIVE OVERHEAD 6.00 6.90 7.94 9.13 10.49 12.07

FINANCIAL CHARGES 194.43 208.31 190.37 172.43 154.49 136.55

DEPREICATION 58.25 56.14 54.11 52.16 50.28 48.47

PRELIMINIARY EXPENSES 13.00 13.00 13.00 13.00 13.00 13.00

TOTOL COST OF FIXED ASSETS 271.68 284.35 265.41 246.71 228.26 210.08

NET PROFIT 152.48 339.76 394.88 434.39 484.85 497.65

BEP 0.64 0.46 0.40 0.36 0.32 0.30

FIXED COST / CONTRIBUTION

CASH BREAK EVEN

CONTRIBUTION 424.16 624.11 660.29 681.10 713.11 707.73

FIXED COST

ADMINISTRATIVE OVERHEAD 6.00 6.90 7.94 9.13 10.49 12.07

FINANCIAL CHARGES 194.43 208.31 190.37 172.43 154.49 136.55

TOTAL FIXED COST 200.43 215.21 198.30 181.55 164.98 148.62

NET PROFIT 223.73 408.90 461.99 499.55 548.13 559.12

BEP

FIXED COST / CONTRIBUTION 0.47 0.34 0.30 0.27 0.23 0.21





25/27

Sources of funds 2011-12 2013-14 2014-15 2015-16 2016-17 2017-18 2018-19

1.Net Profit after 152.48 339.76 394.88 434.39 484.85 497.65

depreciation

2. Depreciation 58.25 56.14 54.11 52.16 50.28 48.47

3. Preliminary 13.00 13.00 13.00 13.00 13.00 13.00

expenses

4. Increase in

Capital Receipts - Membership Fee 247.50 - - - - - -

5. Increase in

unsecured loans 504.76 - - - - - -

6. Increase in

term loans 828.00 - - - - - -

7. Increase in

working capital 7.50 - - - - - -

8. Increase in

creditors - 1.00 (0.00) - - - -

Total 1,587.76 224.73 408.90 461.99 499.55 548.13 559.12

Uses of funds

1. Increase in

Fixed assets 1,500.69 - - - - -

2. Increase ininvestments. 15.00 - 200.00 200.00 200.00 400.00 400.00

3. Increase in

Prel. expenses 62.07 - - - - -

4. Increase in

stocks - 1.00 0.25 0.25 0.50 0.25 0.25

5. Increase in

debtors - 12.74 3.61 0.82 0.49 0.74 -

6. Decrease in

term loan 138.00 138.00 138.00 138.00 138.00 138.00

7. Decrease in

unsecured loan - - - - - - -

8. Income Tax - 0.50 1.00 1.50 2.00 2.50 3.00

9. Withdrawal - - - - - -

Total 1,577.76 152.24 342.86 340.57 340.99 541.49 541.25

Opening Balance - 10.00 82.49 148.52 269.95 428.51 435.15

Net Surplus 10.00 72.49 66.04 121.43 158.56 6.64 17.87

Closing Balance 10.00 82.49 148.52 269.95 428.51 435.15 453.02

10.00 82.49 148.52 269.95 428.51 435.15 453.02

- 0.00 - - - - -





26/27

Material Amount

1 Stock

3600 15 54,000

Consumable Room ( 55 % of Realisation) 7920 15 118,800

Consumable Restaurent ( 55 % of Realisation) 23100 15 346,500

Consumable Party ( 10 % of Realisation) 4800 1 4,800

Consumable Bar ( 45 % of Realisation) 10368 15 155,520

CONSUMABLE ITEMS- OTHERS - 61,055

2 Wages & Salary, Administrative Expenses = One Month Expenses 259,325

1,000,000TOTAL REQUIREMENT OF WORKING CAPITAL




Room - Expenses (10% of Realisation)

Number

of Day

Requirement of Working Capital


27/27

` ( Lac )

FIXED ASSETS 2011-12 2012-13 2013-14 2014-15 2015-16 2016-17 2017-18 2018-19

TOTAL FIXED ASSET 544.93 544.93 2,045.62 1,987.37 1,931.23 1,877.11 1,824.96 1,774.68

LESS DEPRECIATION - 1,500.69 58.25 56.14 54.11 52.16 50.28 48.47

544.93 2,045.62 1,987.37 1,931.23 1,877.11 1,824.96 1,774.68 1,726.21

INVESTMENT - 15.00 15.00 215.00 415.00 615.00 1,015.00 1,415.00

FOR EXPANSION OF PROJECT

CURRENT ASSETS - - - - - - -

CLOSING STOCK - 1.00 1.25 1.50 2.00 2.25 2.50

SUNDRY DEBTORS - 12.74 16.36 17.17 17.66 18.40 18.40

CASH IN HAND - 10.00 82.49 148.52 269.95 428.51 435.15 453.02

PRILIMINERY EXPENSES 15.93 78.00 65.00 52.00 39.00 26.00 13.00 -

560.86 2,148.62 2,163.60 2,364.36 2,619.74 2,914.13 3,258.48 3,615.13

LIABILITIES 2011-12 2012-13 2013-14 2014-15 2015-16 2016-17 2017-18 2018-19

CAPITAL 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00

ADDITIONAL - - - - - - - -

5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00

PROFIT AND LOSS ACCOUNT

OPENING BALANCE - - - 151.98 490.74 884.12 1,316.51 1,798.86

ADD PROFIT - 152.48 339.76 394.88 434.39 484.85 497.65

- 152.48 491.74 885.62 1,318.51 1,801.36 2,296.51

LESS WITHDRAWAL & TAX - 0.50 1.00 1.50 2.00 2.50 3.00

- 151.98 490.74 884.12 1,316.51 1,798.86 2,293.51

LIFE MEMBERSHIP FEE CAPITALISED 247.50 247.50 247.50 247.50 247.50 247.50 247.50

UNSECURED LOAN 555.86 1,060.62 1,060.62 1,060.62 1,060.62 1,060.62 1,060.62 1,060.62

TERM LOAN 828.00 690.00 552.00 414.00 276.00 138.00 -

WORKING CAPITAL LOAN - 7.50 7.50 7.50 7.50 7.50 7.50 7.50

TRADE CREDITORS - 1.00 1.00 1.00 1.00 1.00 1.00

560.86 2,148.62 2,163.60 2,364.36 2,619.74 2,914.13 3,258.48 3,615.13

- - - - - - - -

NOTE : EXCESS CASH AVAILABLE WILL BE UTILISED FOR EXPANSATION OF THE PROJECT.

PORJECTED BALANCE SHEET



club project 2011 final

Documents