DETAILED PROJECT REPORTOF

PROPOSED 5 STAR LUXURY

RESORT AT

DEWA SHARIF ROAD

DISTRICT BARABANKI, (UTTAR PRADESH)

Prepared by:
Glocal Advisors LLP
(Management and Project Consultants)
AI Apartment, Ground Floor,
Prag Narayan Road, Lucknow-226004
E-Mail: projects@glocaladvisors.in

BAYSTONE ESTATE PRIVATE LIMITED

Regd. Office: Villa no.4, Hotel Site: NEAR DEWA SHARIF
Shalimar Grand 10 Jopling Road, ROAD,Sector-84, District BARABANKI
Lucknow, UP, 226001 (UTTAR PRADESH)

1
Contents
1. INTRODUCTION.......................................................................................................................................... 4
1.1 The Baystone Estate Private Limited ..................................................................................................... 4
1.2 Objective ................................................................................................................................................. 5
1.3 Location .................................................................................................................................................. 5
1.4 Building .................................................................................................................................................. 5
1.5 Title ........................................................................................................................................................ 6
1.6 Technically Feasible and Economic Viability ....................................................................................... 6
2- MARKET OVERVIEW ................................................................................................................................... 6
2.1 Indian Hotel Industry ............................................................................................................................. 6
2.2 Country Trends....................................................................................................................................... 6
2.2.1 Hotel Industry Performance – Growth in Demand and Supply ........................................................... 6
2.2.2 Increasing Contribution from Food & Beverage and Banquets & Conferences to the Revenue Mix ... 7
2.3 International Hotel Industry .................................................................................................................. 7
2.4 Hotel Industry in India ........................................................................................................................... 7
2.5 Size of the industry ................................................................................................................................. 8
2.6 Projections ............................................................................................................................................. 8
2.7 Categorization of Hotels in India ............................................................................................................ 9
- Heritage Hotels ........................................................................................................................................... 9
- Luxury Hotels ........................................................................................................................................... 10
- Budget Hotels ........................................................................................................................................... 10
- Resorts .......................................................................................................................................................... 10
2.8 Important Hotel Groups in India .......................................................................................................... 10
2.9 Latest developments ............................................................................................................................ 11
3.UP Overview ................................................................................................................................................. 13
4- BARABANKI OVERVIEW............................................................................................................................... 14
4.1 About Barabanki .................................................................................................................................. 14
4.2 ACCESSIBILITY........................................................................................................................................... 16
4.3 DEMOGRAPHY ...................................................................................................................................... 16
4.4 INFRASTRUCTURE ................................................................................................................................ 17
4.4.1 Social Infrastructure ...................................................................................................................... 17
4.5 KEY INDUSTRIES IN BARABANKI.......................................................................................................... 17
4.6 OUTLOOK.............................................................................................................................................. 18
5- PROPERTY DETAILS .................................................................................................................................... 19
5.1 LOCATION AND ACCESSIBILITY ............................................................................................................ 19
5.2 NEAR TO DEWA SHARIF SHRINE .......................................................................................................... 19
6- SWOT ANALYSIS .......................................................................................................................................... 19
SWOT Analysis ................................................................................................................................................. 20
2
7- PROJECT DETAILS........................................................................................................................................ 21
7.1SALIENT FEATURES OF THE PROJECT ................................................................................................... 21
7.2- OTHER FEATURES .................................................................................................................................... 22
7.3- RAIN WATER HARVESTING ................................................................................................................... 23
7.4 PARKING .............................................................................................................................................. 23
7.5 POWER REQUIREMENTS ....................................................................................................................... 23
7.6 Eligibility for UP Tourism Policy .................................................................................................... 23
8- ENERGY CONSERVATION MEASURES: .......................................................................................................... 25
9- CONCLUSION ............................................................................................................................................... 26
10- FINANCIAL ANALYSIS ............................................................................................................................... 27
COST OF PROJECT ............................................................................................................................................ 27
COST OF PROJECT – PHASE WISE ............................................................................................................... 28
DETAILS OF PROPSED CONSTRUCTION...................................................................................................... 29
DETAILS OF BLOCKS ................................................................................................................................... 30
MANPOWER REQUIREMENTS: .................................................................................................................... 32
Salary Calculation....................................................................................................................................... 33
Capacity Utilisation: ................................................................................................................................... 34
Plant and Machinery Details ...................................................................................................................... 35
Miscellaneous Fixed Assets Details ............................................................................................................ 36

3
1.INTRODUCTION

1.1 The Baystone Estate Private Limited

Company Identification Number: U70109UP2021PTC151877

Status Active

Incorporation Date 08 September 2021

Company Type Limited By shares

Jurisdiction India

Registered Villa No:4, Shalimar Grand 10 Jopling Road

Address Lucknow, UP-226001 IN

Shobhit Mohan Das,

Director
Directors/ Officers 08-09-2021
DIN: 00229502

Priyanka Gupta, Director,

08-09-2021
DIN: 02248822

4
Baystone Estate Private Limited (hereinafter referred to as
“BEPL”).. BEPL was established with a vision of providing
unmatched comfort and impeccable hospitality standards to its
guests. BEPL hotels create a panorama of new business esthetics.
It will be destination to a various people for their most
memorable weddings and other functions and also host business
executives for the coming decades.

1.2 Objective

The objective of BEPL is to Build a Five Star Luxury hotel on total

plot area of the subject land of 11.5 acres with maximum value
usage for development of hotel, marriage, convention center, spa
resort in the close proximity in Barabanki which is adjoining
Lucknow
1.3 Location

The proposed project is situated at Khajoor Gaon, Barabanki and

focus in the Sufikabir Circuit as identical under the UP Tourism
Policy 2018. The hotel site is located approximately 5km from
Dewa Sharif Shrine.

1.4 Building
All building will be centralized air-conditioned, sprinkler system
and fire fighting alarms system. Mechanical lights and ventilation
will be provided and CFL/LED lighting system will be used.

5
 1.5 Title
The title of the land has been cleared and authenticated by the
company’s legal consultants.

1.6 Technically Feasible and Economic Viability

The project is technically feasible and economically viable proposition.

2- MARKET OVERVIEW

2.1 Indian Hotel Industry

One of the most profitable industries of India is the tourism
and hospitality industry. The sector contributes a noteworthy
amount of foreign exchange to the country’s economy. A key
component of this industry are hotels which until recently
had been posting a robust growth.

2.2 Country Trends

2.2.1 Hotel Industry Performance – Growth in Demand and

Supply

The hotel industry in India is expected to reach a value of INR

1,210.87 Bn by the end of 2023, expanding at a compound
annual growth rate (CAGR) of ~13% during the 2018-2023
period, owing to the high arrival rate of foreign tourists and
business delegates. In 2018, the major hotel brands operating
in India were Marriott International, The Indian Hotels
Company Limited (including brand Ginger), Radisson Hotel
Group, ITC Hotels, Accor Hotels, Hyatt Hotels, Sarovar Hotels,
Intercontinental Hotels Group, Lemon Tree Hotels, and
6
Oberoi Hotels & Resorts. The occupancy rate (percentage of
days for which rooms are booked in a given period) of the
major hotels in India increased at a rate of ~65% between FY
2017 and FY 2018, due to increased demand from business
and leisure travelers, and a slowdown in the addition of new
hotel rooms across the country.

2.2.2 Increasing Contribution from Food & Beverage and

Banquets & Conferences to the Revenue Mix

India continues to receive a greater contribution from both

the Food & Beverage (F&B) and the Banquets & Conferences
department. The Banquets & Conferences segment also
recorded a year-on-year increase of 40% revenue over years .

2.3 International Hotel Industry

The four major BRIC countries (Brazil, Russia, India and

China) continue to be targeted for hotel chain expansion, but
the Chinese market is beginning to look saturated, especially
in the upscale to luxury sector. India and Brazil have
substantial growth potential and Russia has the biggest
development pipeline in Europe.

2.4 Hotel Industry in India

Over the last decade business opportunities in India had

intensified and elevated room rates occupancy levels in India.
'Hotel Industry in India' success story is only second to China
7
 in Asia Pacific. The World Travel and Tourism Council, says
that India ranks 18th in business travel and will be among the
top 5 very soon. India's big success stories includes the new
model for development and growth; a model that is uniquely
made.

2.5 Size of the industry

Indian Hotel Industry has supply of

Size of the Industry 110,000 rooms and about 150000 room in
pipeline to come up

Mumbai, Delhi, Banglore, Goa,

Geographical distribution Hyderabad, Kerala, Jammu and Kashmir,
Madhya Pradesh , Lucknow, Barabanki

Output per annum The industry is set to grow 15% per year

2.6 Projections
Indian Hotel Industry's room rates are most likely to rise
25% annually and occupancy to rise by 80%, over the next
two years. 'Hotel Industry in India is gaining its
competitiveness as a cost effective destination. The 'Hotel
Industry' is likely to add about 60,000 quality rooms,
currently in different stages of planning and development
which would be ready by 2025.
MNC Hotel Industry giants are initiating for Joint Ventures to

8
earn their share of pie in the race. The Indian Government has
approved 300 hotel projects, where half are for the luxury
range. More and more IT Professionals are moving into the
Metro cities as the USD 33 billion software services sector
pushing into the Indian economy. Indian Hotel Industry is set
up to grow by 15% a year. In 2010 as the Delhi capital city of
India hosted the Commonwealth Games there were more
than 50 international budget hotel chains moving into India.
One of the major reasons for the increase in demand for hotel
rooms in the country is due to the boom of information
technology, telecom, retail and real estate. India's increasing
stock market and new business opportunities are always
been attractive for foreign investors and corporate travellers
to look for business opportunities in the country. From 167
countries, today India has finally made its mark on the world
travel map.

2.7 Categorization of Hotels in India

The basic division in India according to the location is as follows:

- Heritage Hotels
These types of hotels reflect the old glory and grandeur of
India as they are mostly the old havelis and mansions of
ancient times which have been turned into Heritage Hotels.
These provide tourists with an opportunity to experience
royal pleasure in traditional ambience. They mostly
concentrate in the princely states of Rajasthan, Delhi, and
9
Madhya Pradesh.
- Luxury Hotels
These Hotels are equipped with world class infrastructural
amenities, they offer the tourists with a fine lodging and
dining experience. They extend a warm welcome to the
customers catering primarily to the upper class executives.

- Budget Hotels
These kinds of Hotels are like home away from home, they
accommodate customers from upper middle and middle
class. Mostly named as Economy Class Hotels, Business Hotels
and Discount Hotels, the Budget Hotels supports the modern
infrastructural facilities for a comfortable and pleasant stay.

- Resorts

Resort hotels in India are mostly found in hill stations and sea
side tourist destinations. These are located amidst natural
scenic beauty as they are the ideal place to enjoy some
valuable time with family and friends or in solitude.

2.8 Important Hotel Groups in India

Indian Hotel Industry has been booming business and has

also given a boast to tourism business in the country.
Radisson Hotels India, Taj Group of Hotels, Park Group of
Hotels and ITC Hotels are some of the known hotels in the
hotel industry that are famous for unique amenities and
superb accommodation arrangements.
10
There are also the ITC Maurya Delhi, ITC Maratha Mumbai,
and Fort Radisson of Radisson Group in Kolkata, Radisson
Jass Hotel Shimla, The Taj Westend, Bangalore, Taj
Coromandel, Chennai. The major cities like Bangalore,
Hyderabad, Chennai, Gurgaon, Pune and the suburbs of
Mumbai are the areas most attractive for the international
investment and as expected these are the cities with the
largest development pipelines. Combined these cities account
for 89 of the 161 projects in the pipeline and 16,734
guestrooms, which is 68% of the rooms in India's total
pipeline.

2.9 Latest developments

Indian Hotel Industry holds a special place in the

international world of hospitality. India is culturally the
country which would be very well having the most diverse
places in the world. It serves as the vivid kaleidoscope of
landscapes, magnificent historical sites and royal cities, misty
mountain retreats, colorful people, rich cultures, and
festivities. Luxurious, hot and cold, chaotic and tranquil,
ancient and modern - India's soothing extremes rarely fail to
leave a lasting impression. In India Hospitality is a long
running tradition. Whether it might be the majestic
Himalayas and the stark deserts of Rajasthan, or the beautiful
beaches and lush tropical forests, to idyllic villages and
bustling cities, Indian land offers unique opportunities for
11
every individual preference.
Today the accommodation options throughout India have
become extremely diverse and unique from home stays and
tribal huts to stunning heritage mansions and maharaja
palaces. It could be From Kashmir to Kanyakumari, from
Gujarat to Assam; there are different cultures, languages, life
styles, and cuisines. This variety has reflected and increased
by the many forms of accommodations, ranging from the
simplicity of local guest houses to the government bungalows
to the opulent luxury of royal palaces and five star deluxe
hotel suites.

In recent years the Indian government has taken several

steps to boost travel & tourism which have benefited the
hotel industry in the country. The initiatives by the
Government include the abolishment of the inland air travel
tax of 15% to 8%, reduction in excise duty on aviation turbine
fuel and removal of a number of restrictions on outbound
chartered flights, including those relating to frequency and
size of aircraft.

12
Indian Hotel Industry has the best staff for hotels unlike
employees in East Asian hotels who are charming and
gracious, Indian staff is also grooming themselves to take
initiative and discretion of decisions on the spot. Most are
better educated and speak better English than their East
Asian counterparts. Indian hotel industry is to be proud of as
it has much to be so. The real success story of the Indian Hotel
Industry was due to the fact that it took on the global chains
on its own terms and it won.

3.UP Overview

Uttar Pradesh is the fourth largest state in India in terms of

land area. The state's population of 200 Million is equivalent
to the population of Brazil.

Uttar Pradesh, described as the heartland of India, falls under

the influence area of the first two of India’s dedicated freight
corridors – Western Corridor running between Delhi &
Mumbai and Eastern Corridor running between Ludhiana and
Kolkata, connecting it with remote parts of the country.

The investment in Uttar Pradesh will be worthwhile as the

state is amongst India's most popular tourist destinations
with the presence of Taj Mahal, Buddhist places of pilgrimage
such as Sarnath, Shravasti and Kushinagar, and prominent
Hindu pilgrimage places such as Prayagraj, Mathura and
13
Varanasi. The state was ranked first and third in terms of
domestic and foreign tourist arrival, respectively, in 2019.

Uttar Pradesh has several locally specialised business clusters

such as sports items in Meerut, brassware in Moradabad,
perfumes in Kannuaj, leather in Kanpur, shoes in Agra,
embroidered sarees in Varanasi, carpet in Bhadohi, chikan
work in Lucknow, and much more. Thus, business and
investment opportunities in Uttar Pradesh are hugely
emerging.

Uttar Pradesh is known as the food basket of India as it is a

leading producer of several food items. It is also the top
manufacturing destinations in India contributing more than
8% of national manufacturing output. The state is a leading
electronic hardware exporter in the country and has also
emerged as a key hub for the IT/ ITeS and service sector,
including software, captive business process outsourcing
(BPO) and R&D services. Hence, the business community can
explore many lucrative business opportunities in Uttar
Pradesh.

4- BARABANKI OVERVIEW

4.1 About Barabanki

Barabanki district is one of the five districts of Faizabad division
(officially Ayodhya division), in the central Awadh region of Uttar
Pradesh, India. Barabanki city is the administrative headquarters

14
of Barabanki district. Total area of Barabanki district is 3891.5 Sq.
Kms.

It has a population of 2,673,581, with a population density of

686.50 per square kilometre (1,778.0/sq mi).

Barabanki district is situated between 27°19′ and 26°30′ north

latitude, and 80°05′ and 81°51′ east longitude; it runs in a south-
easterly direction, confined by the nearly parallel streams of
the Ghaghara and Gomti. The extreme length of the district from
east to west may be taken at 92 km (57 mi), and the extreme
breadth at 93 km (58 mi); the total area is about
3,900 sq.km (1,504 sq mi). It borders seven other districts of Uttar
Pradesh. With its most northern point it shares borders with
the Sitapur district, while its north-eastern boundary is defined by
the Ghagra, beyond which lie the districts of Bahraich
district and Gonda district. Its eastern border is shared
with Faizabad district, and the Gomti forms a natural boundary to
the south, dividing it from the Amethi district. On the west, it
adjoins the Lucknow district.

In 1856, the district came, with the rest of Oudh State,

under British rule. During the Indian Rebellion of 1857, the whole
of the Barabanki talukdars joined the mutineers, but offered no
serious resistance following the capture of Lucknow.

Barabanki district stretches out in a level plain interspersed with

numerous lakes and marshes. In the upper part of the district the
soil is sandy, while in the lower part it is clay and produces finer
crops.[3] The district is fed by the rivers Ghaghra (forming the
15
northern boundary), Gomti (flowing through the middle of the
district), Kalyani and Rait and their tributaries, for the major part
of the year. Some rivers dry out in the summer, and become
flooded during the rainy season. The changing course of the river
Ghagra alters the land area of the district.

The principal crops are rice, wheat, pulse and other food grains
and sugarcane. Both of the bordering rivers of Barabanki are
navigable. The district is traversed by two lines of the Northern
Railway and North-Eastern Railway, with branches having total
length of 131 km (81 mi). The district roadways include
connections to National Highway 28, state highways and various
link roads.

4.2 ACCESSIBILITY
The district is traversed by two lines of the Northern Railway
and North-Eastern Railway with branches having total length
of 131 km. (81 Miles). The district roadways include
connections to National Highway 28, state highways and
various link roads.

4.3 DEMOGRAPHY
As per Census Report , Barabanki district had a population of
almost 33 Lakh people. The district had a population density
of 740 inhabitants per square kilometer. Barabanki had a sex
ratio of 887 females of every 1000 males and a literacy rate of
47.39%

16
4.4 INFRASTRUCTURE

4.4.1 Social Infrastructure

The first 2 megawatt-capacity solar power plant project of Uttar Pradesh

is situated in Sandauli village of Barabanki district, it was inaugurated on

10 May 2012 and become operational in January 2013. The plant was set

up by Technical Associates Ltd.

4.5 KEY INDUSTRIES IN BARABANKI

Apart from Various cottage industry and Handicrafts industry

some of the major industry location are as follows:-
There are six industrial areas in the District Barabanki,

 UPSIDC Agro Park, Kursi Road, Barabanki

 Industrial Area, Dewa Road, Barabanki
 Industrial Area, Rasool Panah, Fatehpur, Barabanki
 Mini Industrial Area, Ismailpur, Dewa, Barabanki
 Mini Industrial Area Amarsanda, Barabanki
 Mini Industrial Area Sohilpur, Harkh, Barabanki

The companies and factories include:

 India PolyFibres Limited

The Company is engaged in manufacturing of polyester staple
fibre, polyester, and tow with technology from Du Pont, USA.

 U.P. State Spinning Mill, Barabanki

 U.P. State Sugar Corp. Ltd., Barabanki
17
  DSM Sugar, Rauzagaon, Barabanki,
 Hally Industries pvt. Ltd., Barabanki – supplies welding electrodes
and owns a wire-drawing unit and a rice mill
 J.R. Agro Industries Limited – operates a solvent extraction plant
and a vegetable oil refinery.
 J.R. Organics Ltd. (formally Somaiya Organics Ltd.)
 Bharat Rubber Industries – supplies rubber and rubber-related
products/[82]

 Shree Shyam Industries, Tehsil Fatehpur

4.6 OUTLOOK

Considering the proximity of Barabanki and Lucknow and

development of commercial activities, the retail and
residential markets have flourished well in Barabanki .
Companies who have already established their base in
Lucknow are looking for new land options to support the
expansion plans. Due the increasing land rates and costlier
real estate for commercial development, the next preferred
destination for the corporate giants and industries is
Barabanki. With advantage of being planned city and in
capacities of offering the real estate at cheaper price, business
movement is expected towards Barabanki shortly.
Devlopemnt of IT parks and frills like assured returns on
commercial land are bringing in more investors to this belt.
With anticipated demand from commercial sector, supporting
residential and hospitality sector has to keep the pace with
18
the upcoming developments in Barabanki

5- PROPERTY DETAILS

5.1 LOCATION AND ACCESSIBILITY

The proposed project is situated at Khajoor Gaon, Barabanki and

focus in the Sufikabir Circuit as identical under the UP Tourism
Policy 2018. The hotel site is located approximately 5km from
Dewa Sharif Shrine.

5.2 NEAR TO DEWA SHARIF SHRINE

Dewa Sharif, Lucknow is a tomb built in the beloved memory

of saint named, Haji Waris Ali Shah. Dewa Sharif is located 25
kms away from Lucknow in the Barabanki district of Uttar
Pradesh. Dewa or Dewa Sharif is one of the most visited
places in Luckknow and is believed to be a significant site of
Muslim heritage. The Dewa Sharif, Lucknow is visited by
many Muslim devotees from all round the world.

Not only by Muslims, Dewa Sharif is visited by other religions

such as Hindus. Best time to visit Dewa Sharif is from October
to November. Under this period almost 200-500 people visit
this Shrine .

Location of Resort near to Dewa Sharif Shrine will make this

resort very profitable and feasible.

6- SWOT ANALYSIS

It is of utmost importance to analyze the development of the

land parcel, in order to assess its current usage and pricing.
We have analyzed the subject site by, studying key aspects

19
 such as marketability, financial terms, long term sustenance,
economic trends and real estate projections for the location
as a whole based upon demand and supply dynamics.

The SWOT matrix below (for the subject land parcel) is aimed
at capturing the essence of the above mentioned features.

SWOT Analysis
STRENGTHS WEAKNESS

Single Ownership Proximity from Central

Business
Good connectivity through NH - 28, Less population of HNI’s/Upper
Middle class in District
Outer Barabanki
Periphery Road.
Only 5 Star Hotel near tourist spot
Dewa Shrine
Nearly located at a distance of 4 Km
from Dewa Sharif
Future projects to be launched in
State Barabanki
Various other luxurious services
offered such as Basket ball court, etc.
OPPORTUNITY THREAT

Pivot establishment of Upper Competition from Hotels

scale hotel in Barabanki Area. situated in nearby district
Lucknow

Various Tie ups with Giant groups of -

the hospitality industry

20
 7- PROJECT DETAILS

7.1SALIENT FEATURES OF THE PROJECT

ITEMS DETAILS
Project Name Proposed Hotel Project
Location Khajoor Road, Near Dewa Sharif Shrine, Barabanki

Resort Project
Plot Area 115000 sq ft
Total built up area 130000 sq ft

No. of Floors Ground Floor+ 3 upper Floor

Total no. of Rooms 120
(Approx) -96 (Double Bedded Standard Rooms)
- 24 suites

Parking Facilities Required parking will be planned within the project

Power requirement & Approx :1600 KVA is the power requirement and it will be
sources sourcedfrom Uttar Pradesh Corporation Limited
Power Backup Approx: 3 D.G. sets of total capacity 2250 KVA capacity (3 X 75
KVA) will be available for power backup in case of power
failure.
Water requirement & Water requirement will be 250KLD
sources Fresh water :125 KLD
Recycled water: 125 KLD
Source: CGWB water supply
Sewage treatment facility: STP of 180 KLD capacity Sewage
Sewage treatment discharge: no untreated sewage will be dischargedoutside the
and disposal project site. The sewage water will be treated
and utilized for flushing green area and in the processing of
cooling HVAC/DG sets.
Green area Total green area 3739 sq m(35% of total plot area) The green
area proposed for plant large leaf trees in theform of
shelter belt with avenue plantation of both side ofroad and
for landscaping area including plantation of herbs
and shrubs .

21
 7.2- OTHER FEATURES
LOCATION The proposed project is situated at Dewa Sharif Road

SITE The proposed project is situated at Khajoor

Gaon, Barabanki and focus in the Sufikabir
Circuit as identical under the UP Tourism Policy
2018. The hotel site is located approximately
5km from Dewa Sharif Shrine.

HOTEL BUILDING The hotel building is located of the Khajoor Road, Near Dewa
Sharif shrine, Barabanki

LAND DEVELOPMENT The proposed land not developed yet and its connectivity
from revenue rasta as per revenue record available.
BUILDING FEATURES All building will be installed with centralized air conditioning;
sprinkler system and fire fighting alarms system are provided.
Mechanic light and ventilation also will be provided and
CFL/LED lighting system will be used.
WATER The water will be source bore well and municipal corporation.
The water will be utilizing drinking and domestic purpose only.
The waste water generated will be treated through STP of
capacity 180 KL. The treated water will be recycling for flushing,
cooling of HVAC towers and green belt developments.
STP The capacity of STP will be 180 KL all waste water outlet pipes
from toilets and kitchen will be connected to sewerage
treatment plant for final treatment. After treatment this water
will be utilized flushing of toilets, cooling of HVAC towers and
green belt developments.
RAIN The rain water harvesting system is provided in the building
WATER torecharge its ground water level.
HARVESTING
POWER REQUIREMENTS The power requirements have been calculated as 1600 KW
connected load. In energy power will be supplied by DG sets.
Capacity of DG sets will be 3 X 750 KVA.

22
 7.3- RAIN WATER HARVESTING

The rain water harvesting system is provided in the building

to recharge its ground water level.

7.4 PARKING
The parking provision will made at Ground Floor.
The area of parking will be at approx 2000 sqft.

7.5 POWER REQUIREMENTS

The power requirements will calculated as 1600 KW

connected load and 2767 KW peak demand load. In energy
power will be supplied by DG sets. Capacity of DG sets will be
3 X 750 KVA and power will be taken from DHBVN.

7.6 Eligibility for UP Tourism Policy

Given project is eligible for UP Tourism Policy as it has met

it’s following conditions:-
 Minimum Investment is more than 10Cr
 Resort will have minimum 30 rooms
 Area of Resort will be more than 2 Acre i.e 11.5 Acres
 The proposed Resort will be a wedding destination with
a 5 star spa and Resort developement
 Resort location is near Dewa Sharif which is approved
tourist destination for this Policy
 Resort is having other facilities such as Swimmig Pool,
Lounges and other Facilities.

23
APPROACH FOR PLANNING
Considering the nature of activities to be conducted and the
various aspects of the project to be developed, our efforts of the
approach for the planning of various systems, shall include the
following consideration:-

- Basic of population has been considered as per NBC guidelines.

- There shall be enough safe, clean domestic water supply

available on a continuous basis to every user.

- Efficient disposal from toilets/wet areas.
- Quick disposal of rain water without flooding.

- Reliable fire fighting systems.

- To plan the system in such a way as to minimize the energy requirements.

- To make the system efficient and cost effective.

- To have proper operation and maintenance system, which could

be controlled centrally and efficiently

- To create minimum nuisance and disturbance to the environment.

- To assist in the development and aesthetic value of the environment and

- Landscaping of the project site.

- All open driveways / roads and concrete roads in slope 1:500.

24
 8- ENERGY CONSERVATION MEASURES:

Energy Conservation measures & Management Plan:

- The orientation of the building will be done in such a way that maximum
daylight is available.
- The orientation of the building would be done in such a manner that most
of glazed areas in north and east.
- Lesser opening will be provided on the west facing walls.
- Landscape and greens areas will be so spaced so as to cool the
surrounding environment, which will reduce energy consumption.
- Green belt in the site will be maintained by the project proponents, which
would have an overall cooling effect on the surroundings.

- Renewable energy technologies will be promoted in the form solar water

heating. Solar water heating system consisting of solar panels of and hot
water storage insulation tank is also proposed.

Following measures have been proposed to reduce energy consumption

for electrical installation :

-In the operational phase, appropriate energy conservation measures and

management plan will be adopted in order to minimize the consumption of
non renewable fuel. The following measures are suggested to be adopted:
-Use of CFL instead of GLS lamps for flat and common areas.
-Use of T5 lamps instead of normal fluorescent lamps in basement.

25
9- CONCLUSION

Barabanki, on the outskirts of Lucknow will have a grand makeover over

the last decade. Barabanki has seen and will also see an increase in
commercial activity with IT/ITES leading the industries

There has been a large push for infrastructure development to cater to

rise in population due to migration to the urban areas all over Barabanki.
The demand for residential space has also increased with the increase of
large migrating population. There have been a large number of retail
spaces have also emerged all over the city

Unfortunately the hospitality sector has lagged behind in this upward

spiral all over. There has been a high mismatch of demand and supply
within this industry. In result, Barabanki hospitality has seen no rise in
both occupancy and ARR over the last 5 years.

First, there is still high growth potential in Barabanki. The commercial

sector rentals have shown great stability in comparison to Lucknow. .

26
10- FINANCIAL ANALYSIS

COST OF PROJECT

The total cost of Proect for the proposed 5 star hotel has been estimated at Rs 8,532
Lacs. The project cost includes Capital expenditure consisting of building & civil
work, Office Equipments, Furniture & Fixtures, Development Charges and certain
preliminary expenses and Preoperative expenses.

COST OF PROJECT
AMOUNT
S.NO PARTICULARS
(in Lacs)
1 Land 600.00
2 Building 4,636.50
3 Plant & Machinery 851.00
4 Miscellaneous Fixed Assets 350.00
5 Preliminary Expenses 10.00
6 Preoperative Expenses 120.00
7 Contingencies 200.00
8 Development Charges 1,765.00
Total 8,532.50

MEANS OF FINANCE

Project will be financed on Promoter’s Contribution and Term Loan as follows:

MEANS OF FINANCE
AMOUNT
S.NO PARTICULARS
(in Lacs)
1 Promoter's Contribution 5,119.50
2 Term Loan 3,413.00

Total 8,532.50

27
COST OF PROJECT – PHASE WISE

Project cost will be done phase wise as follows:

Phase-1: Purchase of Land and initiation of Building charges will be made.

Phase-2: Construction of Banquet Hall and Suites will be completed and will become
operative from Oct 22. Initiation of building construction will be continued.

Phase-3: Construction of building will be almost done and hotel would be ready for
it’s operation after certain development charges in Phase-4.

Phase-4: It is estimated that hotel will be become operative in Phase – 4 i.e from
July 24

COST OF PROJECT

S.N AMOUNT
PARTICULARS Phase-1 Phase-2 Phase-3 Phase-4
O (in Lacs)

1 Land 600.00 - - - 600.00

Building and Development
2 Charges 70.95 3,200.75 2,560.60 569.20 6,401.50

3 Plant & Machinery - 255.30 595.70 - 851.00

4 Miscellaneous Fixed Assets - 105.00 245.00 - 350.00

5 Preliminary Expenses - 3.00 7.00 - 10.00

6 Preoperative Expenses - 36.00 84.00 - 120.00

7 Contingencies - 60.00 140.00 - 200.00

Total 8,532.50

28
DETAILS OF PROPSED CONSTRUCTION

Proposed cost in construction of building would be Rs. 4635 Lacs. And including
development charges would be Rs. 6401.5 Lacs . It is estimated that per square foot
cost would be Rs. 3566 and total built-up area would be 1,30,000 sq ft.

Development charges estimation would be Rs. 1765 Lacs which would include :

 High glass teakwood doors

 Aluminium windows
 Tiles
 Marble Flooring
 Plant and Machinery,
 Railings, Etc.

Detailed breakup is as follows:

Amount
Built up Area (in (in
Particulars Specification Sqft) Rate/sqft Lacs)
ROOMS 35000
SUITES 21000
BANQUET 25000
RCC Framed Structure
SPA, RECEPTION,
DINING, HEALTH
CLUB 49000
Total Building Cost 130000 3566.154 4636
High class Teakwood doors 100
Glazed Aluminium Window 20
Ceramic Tiles 150
Sanitary Fittings 50
Hot & Cold Water Supply 10
Development Marble Flooring 100
Charges (Including
Clubs, Lounges, Bar, Bath Tubs 75
Dine-in) Architect Fees 50
Interior Designing 1000
Water Tank 20
False Ceiling 50
Railing with Designs 40
Decorative Lightings 100
Total Development Charges 1765

29
DETAILS OF BLOCKS

Total area of Land is 115000 sqft which would be bifurcated in Closed area of 66950
Sqft and Open area of 48050 sqft.

There would be 8 blocks for Suites. Each Block will have 3 Suites comprising total of
24 Suites.

There would be 4 Blocks of Rooms each Block having 24 Rooms.

In total there would be 96 Rooms and 24 Suites. Detailed breakup of Block is given
as follows:

Blocks For Rooms

Block-1
Ground Floor -1 Room 2500 400 2900
1 st Floor (8 Rooms) 2800 0 2800
2 nd Floor (8 Rooms) 2800 0 2800
3 rd Floor (7 Rooms) 2800 0 2800
Total 10900 400 11300

Block-2
Ground Floor -1 Room 2500 400 2900
1 st Floor (8 Rooms) 2800 0 2800
2 nd Floor (8 Rooms) 2800 0 2800
3 rd Floor (7 Rooms) 2800 0 2800
Total 10900 400 11300

Block-3
Ground Floor -1 Room 2500 400 2900
1 st Floor (8 Rooms) 2800 0 2800
2 nd Floor (8 Rooms) 2800 0 2800
3 rd Floor (7 Rooms) 2800 0 2800
Total 10900 400 11300

Block-4
Ground Floor -1 Room 2500 400 2900
1 st Floor (8 Rooms) 2800 0 2800
2 nd Floor (8 Rooms) 2800 0 2800
30
3 rd Floor (7 Rooms) 2800 0 2800
Total 10900 400 11300

Block for other services

Gym 5000 5000
Miscellaneous Area such as for
Balconies - 10000 10000
Banquet 0 25000 25000
Dinning 2500 0 2500
Swimming 1650 0 1650
Spa 750 0 750
Sports & Other Activities 2130 3410 5540

Parks - 1000 1000

Galleries - 1000 1000

Parking - 2000 2000

Total 7030 47410 54440

Block for Suites

Covered Open Total
Particulars Area Area Area
Block-1 (3 Suites) 2040 30 2070
Block-2 (3 Suites) 2040 30 2070
Block-3 (3 Suites) 2040 30 2070
Block-4 (3 Suites) 2040 30 2070
Block-5 (3 Suites) 2040 30 2070
Block-6 (3 Suites) 2040 30 2070
Block-7 (3 Suites) 2040 30 2070
Block-8 (3 Suites) 2040 30 2070
Total 16320 240 16560

31
MANPOWER REQUIREMENTS:

Estimation Manpower requirement will be as follows:

S.n FY- FY- FY- FY- FY- FY- FY- FY- FY- FY-
o Particulars 23 24 25 26 27 28 29 30 31 32
General
1 Manager 1 1 1 1 2 2 2 2 2 2
Front Office
2 Manager 1 1 1 1 2 2 2 2 2 2
Food &
Beverages
3 Manager 1 3 4 4 5 5 5 5 5 5
Finance
4 Controller 1 1 2 2 3 3 3 4 4 4
House Keeping
5 Supervisor 0 1 2 2 2 2 2 2 2 2
Marketing
6 Executive 2 2 4 4 4 4 4 4 4 4
7 Stewards 5 5 8 10 10 10 10 10 10 10
8 Cooks 10 10 15 15 20 25 30 30 30 30
Kitchen
9 Helpers 10 20 25 25 25 25 30 30 35 37
10 Room Boys 10 20 25 25 25 25 25 25 25 25
11 Waiters 15 25 30 30 30 35 35 40 45 50
12 Receptionist 1 2 2 2 2 2 2 2 2 2
Repairs &
Maintenance
13 Staff 4 6 8 8 10 12 12 12 15 18
Administrative
14 Staff 5 10 10 12 15 15 16 16 18 18
15 Security Staff 2 5 5 5 5 5 5 5 5 5
Attendants/Bel
l Boys/ Lift
16 Man 0 15 15 15 15 16 20 20 25 25

32
Salary Calculation

For purpose of salary calculation it is estimated that salary per month will be as
following according to their job roles:

S.n
o Particulars 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
General 15000 15500 16000 17000 18000 19000 20000 21000 22000 23000
1 Manager 0 0 0 0 0 0 0 0 0 0
Front Office 10000 11000 12000 13000 14000 15000 16000 17000 18000 19000
2 Manager 0 0 0 0 0 0 0 0 0 0
Food &
Beverages 10000 10500 11000 11500 12000 12500 13000 13500 14000 14500
3 Manager 0 0 0 0 0 0 0 0 0 0
Finance
4 Controller 30000 35000 40000 45000 50000 55000 60000 65000 70000 75000
House
Keeping
5 Supervisor 25000 30000 35000 40000 45000 50000 55000 60000 65000 70000
Marketing
6 Executive 20000 25000 30000 35000 40000 45000 50000 55000 60000 65000
7 Stewards 15000 17000 19000 21000 23000 25000 27000 29000 31000 33000
8 Cooks 25000 30000 35000 40000 45000 50000 55000 60000 65000 70000
Kitchen
9 Helpers 10000 12000 14000 16000 18000 20000 22000 24000 26000 28000
10 Room Boys 10000 12000 14000 16000 18000 20000 22000 24000 26000 28000
11 Waiters 8000 9000 10000 11000 12000 13000 14000 15000 16000 17000
12 Receptionist 10000 11000 12000 13000 14000 15000 16000 17000 18000 19000
Repairs &
Maintenance
13 Staff 10000 11000 12000 13000 14000 15000 16000 17000 18000 19000
Administrativ
14 e Staff 10000 11000 12000 13000 14000 15000 16000 17000 18000 19000
15 Security Staff 10000 11000 12000 13000 14000 15000 16000 17000 18000 19000
Attendants/B
ell Boys/ Lift
16 Man 10000 11000 12000 13000 14000 15000 16000 17000 18000 19000

33
Capacity Utilisation:

Capacity utilization of proposed 5 Star hotel will be as follows:

Installed Capacity
Total No. of Rooms 120
Standard Air conditioned Double
Occupancy 96
Suites 24

Capacity Utilisation (For Suites)

Ist year i.e year ending 31-03-2023 25%
IInd year i.e year ending 31-03-2024 30%
IIIrd year i.e year ending 31-03-2025 35%
IVth year i.e year ending 31-03-2026 35%
Vth year i.e year ending 31-03-2027 40%
VIth year i.e year ending 31-03-2028 40%
VIIth year i.e year ending 31-03-2029 50%
VIIIth year i.e year ending 31-03-
50%
2030
IXth year i.e year ending 31-03-2031 50%
Xth year i.e year ending 31-03-2032 50%

Capacity Utilisation (Rooms)

Ist year i.e year ending 31-03-2023 0%
IInd year i.e year ending 31-03-2024 0%
IIIrd year i.e year ending 31-03-2025 20%
IVth year i.e year ending 31-03-2026 20%
Vth year i.e year ending 31-03-2027 25%
VIth year i.e year ending 31-03-2028 25%
VIIth year i.e year ending 31-03-2029 30%
VIIIth year i.e year ending 31-03-
30%
2030
IXth year i.e year ending 31-03-2031 40%
Xth year i.e year ending 31-03-2032 40%

34
Plant and Machinery Details

Estmated cost of Plant & Machinery would be Rs. 851 Lacs which would comprise
Elevators, Air conditioning Plants, Transformers and such other equipments
mentioned below:-
Plant and Machinery Details
Amount (In
Particulars Lacs)

Elevators -

Air Conditioning Plants 500.00

Filtration and Water Softening Plant 10.00

DG Set 500 KVA 25.00

Health Club Equipment 100.00

Transformer 15.00

Fire Fighting System 20.00

Refrigerators 25.00

Cold Storage & Deep Freeze 10.00

Kitchen Equipments 25.00

Water Pumps 4.00

EPABX System 8.00

Dish Antenna & Reciver Sets 8.00

Colour TV's 60.00

Audio System & Speakers 15.00

Hot Water Generator 10.00

Digital Projection Equipments 16.00

35
 Total 851.00

Miscellaneous Fixed Assets Details

Estmated cost of Plant & Machinery would be Rs. 350 Lacs which would comprise
Crockery Items, Golf cart cars , Utensils and such other equipments mentioned
below:-

Miscellaneous Fixed Assets

Amount (In
Particulars Lacs)
Interior Furnishing of Guest
Rooms 90.00

Furniture & Fixtures 50.00

General Table Covers and
Napkins Holder 5.00

Crockery Items, Glassware 50.00

Office Equipments 25.00

Utensils 20.00

Golf cart Cars 50.00

Vehicles 40.00

House Keeping Items 20.00

Total 350.00

36
PROJECTED REVENUE SUMMARY:
The projected balance sheets of the unit over a period of 10 operational years in the
perspective have been computed and presented in Annexure-7 of the Financial
Sheet

PROJECTED BALANCE SHEET:

The projected balance sheets of the unit over a period of 10 operational years in the
perspective have been computed and presented in Annexure-8 of the Financial
Sheets

PROJECTED PROFITABILITY ANALYSIS

Projected Profitability of the unit at different levels of a capacity utilisation
envisaged over a period of 10 years in the perspective have been computed and
presented at Annexure-9.

PROJECTED CASH FLOW ANALYSIS

The projected cash flow analysis of the unit over a period of 10 operational years in
the perspective have been computed and presented in Annexure-10 of the
Financials Sheets.

DEPRECIATION
The depreciation has been calculated on the Written Down Value Method for
Income Tax Purposes. The Fixed Assets of the company have been broadly classified
into seven heads for the purpose and applicable rates of depreciation have been
charged. Detailed Calculation of the depreciation charged on the assets have been
calculated and annexed as Annexure-11 of the Financial sheets.

TERM LOAN REPAYMENT SCHEDULE

The term loan repayment schedule has been annexed as Annexure-12 of the
Financial sheets.

37
Based on the assumptions mentioned above and financial detailed project
report given in following annexures:

38
 INDEX
S.no Contents Annexure
1 Cost of Project and Means of Finance 1
2 Cost of Project Phase Wise 1A
3 Proposed Construction Plan 2
4 Block wise details 3
5 Salary Detail and Manpower 4
6 Installed Capacity & Capacity Utilisation 5
7 Plant & Machinery Details 6
8 Revenue Summary 7
9 Projected Balance Sheet 8
10 Projected Profitability Statement 9
11 Projected Cash Flow 10
12 Depreciation Schedule 11
13 Term Loan Repayment Schedule 12
 BAYSTONE ESTATE PVT LTD.

Annexure-1
COST OF PROJECT AND MEANS OF FINANCE

COST OF PROJECT
AMOUNT
S.NO PARTICULARS
(in Lacs)
1 Land 600.00
2 Building 4,636.50
3 Plant & Machinery 851.00
4 Miscellaneous Fixed Assets 350.00
5 Preliminary Expenses 10.00
6 Preoperative Expenses 120.00
7 Contingencies 200.00
8 Development Charges 1,765.00
Total 8,532.50

MEANS OF FINANCE
AMOUNT
S.NO PARTICULARS
(in Lacs)
1 Promoter's Contribution 5,119.50
2 Term Loan 3,413.00
Total 8,532.50
 BAYSTONE ESTATE PVT LTD.

Annexure-1A
COST OF PROJECT (Phase wise)

COST OF PROJECT
AMOUNT
S.NO PARTICULARS Phase-1 Phase-2 Phase-3 Phase-4
(in Lacs)
1 Land 600.00 - - - 600.00
2 Building and Development Charges 70.95 3,200.75 2,560.60 569.20 6,401.50
3 Plant & Machinery - 255.30 595.70 - 851.00
4 Miscellaneous Fixed Assets - 105.00 245.00 - 350.00
5 Preliminary Expenses - 3.00 7.00 - 10.00
6 Preoperative Expenses - 36.00 84.00 - 120.00
7 Contingencies - 60.00 140.00 - 200.00
Total 8,532.50
BAYSTONE ESTATE PVT LTD.
Annexure-2
DETAILS OF PROPOSED CONSTRUCTION

Amount
Particulars Specification Built up Area (in Sqft) Rate/sqft (in Lacs)
ROOMS 35000
SUITES 21000
BANQUET 25000
RCC Framed Structure

SPA, RECEPTION, DINING,

HEALTH CLUB 49000
Total Building Cost 130000 3566.154 4636
High class Teakwood doors 100
Glazed Aluminium Window 20
Ceramic Tiles 150
Sanitary Fittings 50
Hot & Cold Water Supply 10
Development Charges Marble Flooring 100
(Including Clubs, Lounges, Bar, Bath Tubs 75
Dine-in) Architect Fees 50
Interior Designing 1000
Water Tank 20
False Ceiling 50
Railing with Designs 40
Decorative Lightings 100
Total Development Charges 1765
 BAYSTONE ESTATE PVT LTD.
Annexure-3
Computation of Ground Cover and Open Area

Area Details
Covered Area (In sqft) 66950
Open Area (In sqft) 48050
Total Area (In sqft) 115000

Block for Suites

Particulars Covered Area Open Area Total Area
Block-1 (3 Suites) 2040 30 2070
Block-2 (3 Suites) 2040 30 2070
Block-3 (3 Suites) 2040 30 2070
Block-4 (3 Suites) 2040 30 2070
Block-5 (3 Suites) 2040 30 2070
Block-6 (3 Suites) 2040 30 2070
Block-7 (3 Suites) 2040 30 2070
Block-8 (3 Suites) 2040 30 2070
Total 16320 240 16560

Blocks For Rooms

Block-1
Ground Floor -1 Room 2500 400 2900
1 st Floor (8 Rooms) 2800 0 2800
2 nd Floor (8 Rooms) 2800 0 2800
3 rd Floor (7 Rooms) 2800 0 2800
Total 10900 400 11300

Block-2
Ground Floor -1 Room 2500 400 2900
1 st Floor (8 Rooms) 2800 0 2800
2 nd Floor (8 Rooms) 2800 0 2800
3 rd Floor (7 Rooms) 2800 0 2800
Total 10900 400 11300

Block-3
Ground Floor -1 Room 2500 400 2900
1 st Floor (8 Rooms) 2800 0 2800
2 nd Floor (8 Rooms) 2800 0 2800
3 rd Floor (7 Rooms) 2800 0 2800
Total 10900 400 11300

Block-4
Ground Floor -1 Room 2500 400 2900
1 st Floor (8 Rooms) 2800 0 2800
2 nd Floor (8 Rooms) 2800 0 2800
3 rd Floor (7 Rooms) 2800 0 2800
Total 10900 400 11300

Block for other services

Miscellaneous Area such as for Balconies - 15000 15000
Banquet 0 25000 25000
Dinning 2500 0 2500
Swimming 1650 0 1650
Spa 750 0 750
Sports & Other Activities 2130 3410 5540
Parks - 1000 1000
Galleries - 1000 1000
Parking - 2000 2000
Total 7030 47410 54440
 BAYSTONE ESTATE PVT LTD.
Annexure-4
Manpower Requirements and Salary Details

For the year ending 31-03-2023

Annual Salary
S.no Particulars No Salary Per Month per person Salary Per Month (In Lacs)
1 General Manager 1 150000 150000 18
2 Front Office Manager 1 100000 100000 12
3 Food & Beverages Manager 1 100000 100000 12
4 Finance Controller 1 30000 30000 3.6
5 House Keeping Supervisor 0 25000 0 0
6 Marketing Executive 2 20000 40000 4.8
7 Stewards 5 15000 75000 9
8 Cooks 10 25000 250000 30
9 Kitchen Helpers 10 10000 100000 12
10 Room Boys 10 10000 100000 12
11 Waiters 15 8000 120000 14.4
12 Receptionist 1 10000 10000 1.2
13 Repairs & Maintenance Staff 4 10000 40000 4.8
14 Administrative Staff 5 10000 50000 6
15 Security Staff 2 10000 20000 2.4
16 Attendants/Bell Boys/ Lift Man 0 10000 0 0
Total 142.2

For the year ending 31-03-2024

Annual Salary
S.no Particulars No Salary Per Month per person Salary Per Month (In Lacs)
1 General Manager 1 155000 155000 18.6
2 Front Office Manager 1 110000 110000 13.2
3 Food & Beverages Manager 3 105000 315000 37.8
4 Finance Controller 1 35000 35000 4.2
5 House Keeping Supervisor 1 30000 30000 3.6
6 Marketing Executive 2 25000 50000 6
7 Stewards 5 17000 85000 10.2
8 Cooks 10 30000 300000 36
9 Kitchen Helpers 20 12000 240000 28.8
10 Room Boys 20 12000 240000 28.8
11 Waiters 25 9000 225000 27
12 Receptionist 2 11000 22000 2.64
13 Repairs & Maintenance Staff 6 11000 66000 7.92
14 Administrative Staff 10 11000 110000 13.2
15 Security Staff 5 11000 55000 6.6
16 Attendants/Bell Boys/ Lift Man 15 11000 165000 19.8
Total 264.36

For the year ending 31-03-2025

Annual Salary
S.no Particulars No Salary Per Month per person Salary Per Month (In Lacs)
1 General Manager 1 160000 160000 19.2
2 Front Office Manager 1 120000 120000 14.4
3 Food & Beverages Manager 4 110000 440000 52.8
4 Finance Controller 2 40000 80000 9.6
5 House Keeping Supervisor 2 35000 70000 8.4
6 Marketing Executive 4 30000 120000 14.4
7 Stewards 8 19000 152000 18.24
8 Cooks 15 35000 525000 63
9 Kitchen Helpers 25 14000 350000 42
10 Room Boys 25 14000 350000 42
11 Waiters 30 10000 300000 36
12 Receptionist 2 12000 24000 2.88
13 Repairs & Maintenance Staff 8 12000 96000 11.52
14 Administrative Staff 10 12000 120000 14.4
15 Security Staff 5 12000 60000 7.2
16 Attendants/Bell Boys/ Lift Man 15 12000 180000 21.6
Total 377.64
 For the year ending 31-03-2026
Annual Salary
S.no Particulars No Salary Per Month per person Salary Per Month (In Lacs)
1 General Manager 1 170000 170000 20.4
2 Front Office Manager 1 130000 130000 15.6
3 Food & Beverages Manager 4 115000 460000 55.2
4 Finance Controller 2 45000 90000 10.8
5 House Keeping Supervisor 2 40000 80000 9.6
6 Marketing Executive 4 35000 140000 16.8
7 Stewards 10 21000 210000 25.2
8 Cooks 15 40000 600000 72
9 Kitchen Helpers 25 16000 400000 48
10 Room Boys 25 16000 400000 48
11 Waiters 30 11000 330000 39.6
12 Receptionist 2 13000 26000 3.12
13 Repairs & Maintenance Staff 8 13000 104000 12.48
14 Administrative Staff 12 13000 156000 18.72
15 Security Staff 5 13000 65000 7.8
16 Attendants/Bell Boys/ Lift Man 15 13000 195000 23.4
Total 426.72

For the year ending 31-03-2027

Annual Salary
S.no Particulars No Salary Per Month per person Salary Per Month (In Lacs)
1 General Manager 2 180000 360000 43.2
2 Front Office Manager 2 140000 280000 33.6
3 Food & Beverages Manager 5 120000 600000 72
4 Finance Controller 3 50000 150000 18
5 House Keeping Supervisor 2 45000 90000 10.8
6 Marketing Executive 4 40000 160000 19.2
7 Stewards 10 23000 230000 27.6
8 Cooks 20 45000 900000 108
9 Kitchen Helpers 25 18000 450000 54
10 Room Boys 25 18000 450000 54
11 Waiters 30 12000 360000 43.2
12 Receptionist 2 14000 28000 3.36
13 Repairs & Maintenance Staff 10 14000 140000 16.8
14 Administrative Staff 15 14000 210000 25.2
15 Security Staff 5 14000 70000 8.4
16 Attendants/Bell Boys/ Lift Man 15 14000 210000 25.2
Total 562.56
 For the year ending 31-03-2028
Annual Salary
S.no Particulars No Salary Per Month per person Salary Per Month (In Lacs)
1 General Manager 2 190000 380000 45.6
2 Front Office Manager 2 150000 300000 36
3 Food & Beverages Manager 5 125000 625000 75
4 Finance Controller 3 55000 165000 19.8
5 House Keeping Supervisor 2 50000 100000 12
6 Marketing Executive 4 45000 180000 21.6
7 Stewards 10 25000 250000 30
8 Cooks 25 50000 1250000 150
9 Kitchen Helpers 25 20000 500000 60
10 Room Boys 25 20000 500000 60
11 Waiters 35 13000 455000 54.6
12 Receptionist 2 15000 30000 3.6
13 Repairs & Maintenance Staff 12 15000 180000 21.6
14 Administrative Staff 15 15000 225000 27
15 Security Staff 5 15000 75000 9
16 Attendants/Bell Boys/ Lift Man 16 15000 240000 28.8
Total 654.6

For the year ending 31-03-2029

Annual Salary
S.no Particulars No Salary Per Month per person Salary Per Month (In Lacs)
1 General Manager 2 200000 400000 48
2 Front Office Manager 2 160000 320000 38.4
3 Food & Beverages Manager 5 130000 650000 78
4 Finance Controller 3 60000 180000 21.6
5 House Keeping Supervisor 2 55000 110000 13.2
6 Marketing Executive 4 50000 200000 24
7 Stewards 10 27000 270000 32.4
8 Cooks 30 55000 1650000 198
9 Kitchen Helpers 30 22000 660000 79.2
10 Room Boys 25 22000 550000 66
11 Waiters 35 14000 490000 58.8
12 Receptionist 2 16000 32000 3.84
13 Repairs & Maintenance Staff 12 16000 192000 23.04
14 Administrative Staff 16 16000 256000 30.72
15 Security Staff 5 16000 80000 9.6
16 Attendants/Bell Boys/ Lift Man 20 16000 320000 38.4
Total 763.2

For the year ending 31-03-2030

Annual Salary
S.no Particulars No Salary Per Month per person Salary Per Month (In Lacs)
1 General Manager 2 210000 420000 50.4
2 Front Office Manager 2 170000 340000 40.8
3 Food & Beverages Manager 5 135000 675000 81
4 Finance Controller 4 65000 260000 31.2
5 House Keeping Supervisor 2 60000 120000 14.4
6 Marketing Executive 4 55000 220000 26.4
7 Stewards 10 29000 290000 34.8
8 Cooks 30 60000 1800000 216
9 Kitchen Helpers 30 24000 720000 86.4
10 Room Boys 25 24000 600000 72
11 Waiters 40 15000 600000 72
12 Receptionist 2 17000 34000 4.08
13 Repairs & Maintenance Staff 12 17000 204000 24.48
14 Administrative Staff 16 17000 272000 32.64
15 Security Staff 5 17000 85000 10.2
16 Attendants/Bell Boys/ Lift Man 20 17000 340000 40.8
Total 837.6
 For the year ending 31-03-2031
Annual Salary
S.no Particulars No Salary Per Month per person Salary Per Month (In Lacs)
1 General Manager 2 220000 440000 52.8
2 Front Office Manager 2 180000 360000 43.2
3 Food & Beverages Manager 5 140000 700000 84
4 Finance Controller 4 70000 280000 33.6
5 House Keeping Supervisor 2 65000 130000 15.6
6 Marketing Executive 4 60000 240000 28.8
7 Stewards 10 31000 310000 37.2
8 Cooks 30 65000 1950000 234
9 Kitchen Helpers 35 26000 910000 109.2
10 Room Boys 25 26000 650000 78
11 Waiters 45 16000 720000 86.4
12 Receptionist 2 18000 36000 4.32
13 Repairs & Maintenance Staff 15 18000 270000 32.4
14 Administrative Staff 18 18000 324000 38.88
15 Security Staff 5 18000 90000 10.8
16 Attendants/Bell Boys/ Lift Man 25 18000 450000 54
Total 943.2

For the year ending 31-03-2032

Annual Salary
S.no Particulars No Salary Per Month per person Salary Per Month (In Lacs)
1 General Manager 2 230000 460000 55.2
2 Front Office Manager 2 190000 380000 45.6
3 Food & Beverages Manager 5 145000 725000 87
4 Finance Controller 4 75000 300000 36
5 House Keeping Supervisor 2 70000 140000 16.8
6 Marketing Executive 4 65000 260000 31.2
7 Stewards 10 33000 330000 39.6
8 Cooks 30 70000 2100000 252
9 Kitchen Helpers 37 28000 1036000 124.32
10 Room Boys 25 28000 700000 84
11 Waiters 50 17000 850000 102
12 Receptionist 2 19000 38000 4.56
13 Repairs & Maintenance Staff 18 19000 342000 41.04
14 Administrative Staff 18 19000 342000 41.04
15 Security Staff 5 19000 95000 11.4
16 Attendants/Bell Boys/ Lift Man 25 19000 475000 57
Total 1028.76
 BAYSTONE ESTATE PVT LTD.
Annexure-5
Installed Capacity and Capacity Utilisation

Installed Capacity
Total No. of Rooms 120
Standard Air conditioned Double Occupancy 96
Suites 24

Capacity Utilisation (For Suites)

Ist year i.e year ending 31-03-2023 25%
IInd year i.e year ending 31-03-2024 30%
IIIrd year i.e year ending 31-03-2025 35%
IVth year i.e year ending 31-03-2026 35%
Vth year i.e year ending 31-03-2027 40%
VIth year i.e year ending 31-03-2028 40%
VIIth year i.e year ending 31-03-2029 50%
VIIIth year i.e year ending 31-03-2030 50%
IXth year i.e year ending 31-03-2031 50%
Xth year i.e year ending 31-03-2032 50%

Capacity Utilisation (Rooms)

Ist year i.e year ending 31-03-2023 0%
IInd year i.e year ending 31-03-2024 0%
IIIrd year i.e year ending 31-03-2025 20%
IVth year i.e year ending 31-03-2026 20%
Vth year i.e year ending 31-03-2027 25%
VIth year i.e year ending 31-03-2028 25%
VIIth year i.e year ending 31-03-2029 30%
VIIIth year i.e year ending 31-03-2030 30%
IXth year i.e year ending 31-03-2031 40%
Xth year i.e year ending 31-03-2032 40%
 BAYSTONE ESTATE PVT LTD.
Annexure-6
I
Plant and Machinery Details
Particulars Amount (In Lacs)
Elevators -
Air Conditioning Plants 500.00
Filtration and Water Softening Plant 10.00
DG Set 500 KVA 25.00
Health Club Equipment 100.00
Transformer 15.00
Fire Fighting System 20.00
Refrigerators 25.00
Cold Storage & Deep Freeze 10.00
Kitchen Equipments 25.00
Water Pumps 4.00
EPABX System 8.00
Dish Antenna & Reciver Sets 8.00
Colour TV's 60.00
Audio System & Speakers 15.00
Hot Water Generator 10.00
Digital Projection Equipments 16.00
Total 851.00

II Miscellaneous Fixed Assets

Particulars Amount (In Lacs)
Interior Furnishing of Guest Rooms 90.00
Furniture & Fixtures 50.00
General Table Covers and Napkins Holder 5.00
Crockery Items, Glassware 50.00
Office Equipments 25.00
Utensils 20.00
Golf cart Cars 50.00
Vehicles 40.00
House Keeping Items 20.00
Total 350.00
 BAYSTONE ESTATE PVT LTD.
REVENUE SUMMARY Annexure-7
I ROOM RENT
Particulars 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
Rooms Occupied - - 20 20 24 24 29 29 39 39
Room Rent 7,500.00 7,500.00 7,500.00 8,000.00 8,000.00 8,000.00 8,000.00 8,500.00 8,500.00 8,500.00
Suits Occupied per day 6 8 9 9 10 10 12 12 12 12
Suits Rent per day 12,000.00 12,000.00 12,000.00 12,000.00 12,000.00 12,000.00 12,000.00 12,000.00 12,000.00 12,000.00
Tota Rent Revenue per Day (In Lacs) 0.72 0.96 2.58 2.68 3.12 3.12 3.76 3.91 4.76 4.76
No. of Days Operative in year 180.00 365.00 365.00 365.00 365.00 365.00 365.00 365.00 365.00 365.00
Total Rent Revenue per year (in Lacs) 129.60 350.40 941.70 978.20 1,138.80 1,138.80 1,372.40 1,425.33 1,735.58 1,735.58

II Other Revenue
Particulars 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
Food and Beverages Revenue 64.80 175.20 470.85 489.10 569.40 569.40 686.20 712.66 867.79 867.79
Banquet Hall Revenue 450.00 742.50 816.75 698.78 1,317.69 1,449.46 1,594.40 1,753.85 1,929.23 2,122.15
Bar Revenue 51.84 140.16 376.68 391.28 455.52 455.52 548.96 570.13 694.23 694.23

Misc service revenue such as Sports Club

and Swimming Pool Revenue, etc. 77.76 210.24 565.02 586.92 683.28 683.28 823.44 855.20 1,041.35 1,041.35
Total Revenue from Other Services 644.40 1,268.10 2,229.30 2,166.08 3,025.89 3,157.66 3,653.00 3,891.83 4,532.59 4,725.52
 BAYSTONE ESTATE PVT LTD.
Annexure-8

PROJECTED BALANCE SHEET FOR THE FINANCIAL YEAR ENDING……

Figures (in Lacs)
Particulars 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032

LIABILITIES

Equity Capital 60.50 60.50 60.50 60.50 60.50 60.50 60.50 60.50 60.50 60.50 60.50
Authorised Share Capital 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00
Paid Up Share Capital 60.50 60.50 60.50 60.50 60.50 60.50 60.50 60.50 60.50 60.50 60.50

Secured Loans 3,321.72 3,121.98 2,896.91 2,643.29 2,357.51 2,035.48 1,672.61 1,263.72 802.97 283.78

Unsecured Loans 610.45 1,027.50 4,489.80 5,059.00 4,559.00 4,059.00 3,559.00 2,559.00 1,559.00 559.00 -

Reserve and Surplus

Opening Balance - - 81.70 166.01 537.95 917.75 1,739.32 2,616.05 3,804.47 5,135.11 6,881.72
Add: Profit/(Loss) during the year - 81.70 84.30 371.95 379.80 821.57 876.73 1,188.42 1,330.64 1,746.61 1,842.65
- 81.70 166.01 537.95 917.75 1,739.32 2,616.05 3,804.47 5,135.11 6,881.72 8,724.37

Current Liabilities
Provision for Taxation 28.11 29.01 127.98 130.68 282.69 301.67 408.92 457.86 600.98 634.03
Sundry Creditors 32.00 71.00 146.00 149.00 186.00 195.00 225.00 238.00 276.00 286.00
Other Liabilties - 42.29 87.18 89.38 111.03 116.65 134.98 142.79 165.24 171.42

Total (A) 670.95 4,551.54 7,980.59 8,915.53 8,549.61 8,796.04 8,884.35 8,865.48 8,856.97 9,346.41 10,160.11

Particulars 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032

ASSETS

Fixed Assets
Gross Block 600.00 1,090.25 1,955.09 8,090.32 7,609.08 7,168.83 6,764.53 6,392.01 6,047.80 5,728.95 5,432.93
Less: Depreciation - 36.86 195.33 481.24 440.25 404.30 372.52 344.21 318.85 296.03 275.39
Net Block 600.00 1,053.39 1,759.77 7,609.08 7,168.83 6,764.53 6,392.01 6,047.80 5,728.95 5,432.93 5,157.53

Capital WIP 70.95 3,200.75 5,761.35 - - - - - - - -

Non -Current Assets

Security Deposit - 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00

Current Assets
Sundry Debtors - 11.00 23.00 45.00 44.00 58.00 60.00 70.00 74.00 88.00 90.00
Preliminary Expenses Write Off - 10.00 8.00 6.00 4.00 2.00 - - - - -
Cash & Cash Equivalents 0.00 176.40 328.47 1,155.45 1,232.78 1,871.52 2,332.34 2,647.67 2,954.01 3,725.48 4,812.57

Total (B) 670.95 4,551.54 7,980.59 8,915.53 8,549.61 8,796.04 8,884.35 8,865.48 8,856.97 9,346.41 10,160.11
 BAYSTONE ESTATE PVT LTD.
Annexure-9

PROJECTED PROFIT AND LOSS A/C FOR THE FINANCIAL YEAR ENDING……….
Figures in Lacs
S.No Particulars 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032

A REVENUE

i Room Revenue - 129.60 350.40 941.70 978.20 1,138.80 1,138.80 1,372.40 1,425.33 1,735.58 1,735.58
ii Revene from Other Services - 644.40 1,268.10 2,229.30 2,166.08 3,025.89 3,157.66 3,653.00 3,891.83 4,532.59 4,725.52

Total (A) 774.00 1,618.50 3,171.00 3,144.28 4,164.69 4,296.46 5,025.40 5,317.16 6,268.17 6,461.09

B EXPENSES
i Salaries & Wages - 142.20 264.36 377.64 426.72 562.56 654.60 763.20 837.60 943.20 1,028.76
ii Tie-up expenses - 46.44 97.11 190.26 188.66 249.88 257.79 301.52 319.03 376.09 387.67
iii Administrative and General Expenses - 77.40 161.85 317.10 314.43 416.47 429.65 502.54 531.72 626.82 646.11
iv Repairs and Maintenance - - 35.20 152.18 143.38 135.29 127.84 120.96 114.58 108.66 103.15
v Upkeep Services - 15.48 32.37 63.42 62.89 83.29 85.93 100.51 106.34 125.36 129.22
vi Advertisement & Commission - 12.96 35.04 94.17 97.82 113.88 113.88 137.24 142.53 173.56 173.56
vii F&B Costs - 38.88 105.12 282.51 293.46 341.64 341.64 411.72 427.60 520.67 520.67
viii Insurance - - 17.60 76.09 71.69 67.65 63.92 60.48 57.29 54.33 51.58
ix Power & Fuel - 38.70 80.93 158.55 157.21 208.23 214.82 251.27 265.86 313.41 323.05
x Rent, Rates and Taxes - 7.74 16.19 31.71 31.44 41.65 42.96 50.25 53.17 62.68 64.61
xi Preliminary Expenses Writeoff - - 2.00 2.00 2.00 2.00 2.00 - - - -
xii Finance Cost 202.52 387.86 362.53 333.98 301.82 265.57 224.73 178.71 126.85 68.42
xiii Event Expenses 45.00 74.25 81.68 69.88 131.77 144.95 159.44 175.38 192.92 212.22
xiv Depreciation - 36.86 195.33 481.24 440.25 404.30 372.52 344.21 318.85 296.03 275.39

TOTAL (B) - 664.18 1505.19 2671.07 2633.80 3060.43 3118.06 3428.07 3528.66 3920.58 3984.40

C PBT - 109.82 113.31 499.93 510.48 1,104.26 1,178.40 1,597.34 1,788.50 2,347.59 2,476.69

D Provision For Taxation 28.11 29.01 127.98 130.68 282.69 301.67 408.92 457.86 600.98 634.03

E PAT - 81.70 84.30 371.95 379.80 821.57 876.73 1,188.42 1,330.64 1,746.61 1,842.65

Note: It is assumed that business operations have been startd from 01-10-2022 for Banquets and Suites and from July' 24 for rooms.
 BAYSTONE ESTATE PVT LTD.
Annexure-10
Figures In Lacs
PROJECTED CASH FLOW STATEMENT FOR THE YEAR ENDING ……..
S. No Particulars 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032

A Sources of Funds
1 Profit After Tax - 81.70 84.30 371.95 379.80 821.57 876.73 1,188.42 1,330.64 1,746.61 1,842.65
2 Depreciation - 36.86 195.33 481.24 440.25 404.30 372.52 344.21 318.85 296.03 275.39
3 Capital Introduced 60.50 - - - - - - - - - -
4 Unsecured Loans 610.45 417.05 3,462.30 569.20 -500.00 -500.00 -500.00 -1,000.00 -1,000.00 -1,000.00 -559.00
5 Term Loan 3,413.00
5 Increase/(Decrease) In creditors - 32.00 39.00 75.00 3.00 37.00 9.00 30.00 13.00 38.00 10.00
6 Increase/(Decrease) In Other Liabilities - 28.11 43.18 143.87 4.90 173.65 24.60 125.58 56.74 165.58 39.23
7 Decrease/(Increase) in Debtors - -11.00 -12.00 -22.00 1.00 -14.00 -2.00 -10.00 -4.00 -14.00 -2.00
8 Decrease/(Increase) in other Current Assets - -10.00 2.00 2.00 2.00 2.00 2.00 - - - -

Total (A) 670.95 3,987.73 3,814.11 1,621.25 330.95 924.52 782.85 678.21 715.23 1,232.21 1,606.28

B Disposition of Funds

1 Purchase of Fixed Assets 600.00 419.30 901.70 - - - - - - - -

2 Capital WIP 70.95 3,200.75 2,560.60 569.20 - - - - - - -
3 Repayment of Term Loan - 91.28 199.74 225.07 253.62 285.78 322.03 362.87 408.89 460.75 519.18
4 Security Deposit Paid - 100.00

Total (B) 670.95 3,811.33 3,662.04 794.27 253.62 285.78 322.03 362.87 408.89 460.75 519.18

Net Cash Surplus - 176.40 152.07 826.98 77.33 638.74 460.82 315.34 306.34 771.46 1,087.09

Opening Cash & Cash Equivalents - - 176.40 328.47 1,155.45 1,232.78 1,871.52 2,332.34 2,647.67 2,954.01 3,725.48

Closing Cash & Cash Equivalents - 176.40 328.47 1,155.45 1,232.78 1,871.52 2,332.34 2,647.67 2,954.01 3,725.48 4,812.57
 BAYSTONE ESTATE PVT LTD.
Annexure-11
Depreciation Schedule at WDV Figures in Lacs

Rate 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
Expenses 70.95 3200.75 2560.60 569.20 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Capitalised in Building 70.95 6,330.55 - - - - - -
Capital WIP Total 70.95 3,200.75 5,761.35 - - - - - - - -
Depreciation 0% - - - - - - - - - -
Cl WDV - - - - - - - - - -

Rate 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
Op WDV 69.18 65.72 6,076.45 5,772.63 5,484.00 5,209.80 4,949.31 4,701.84 4,466.75
Addition 70.95 - 6,330.55 - - - - - - -
Building Total 70.95 69.18 6,396.27 6,076.45 5,772.63 5,484.00 5,209.80 4,949.31 4,701.84 4,466.75
Depreciation 5% 1.77 3.46 319.81 303.82 288.63 274.20 260.49 247.47 235.09 223.34
Cl WDV 69.18 65.72 6,076.45 5,772.63 5,484.00 5,209.80 4,949.31 4,701.84 4,466.75 4,243.41

Rate 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
Op WDV 295.82 885.71 752.86 639.93 543.94 462.35 393.00 334.05 283.94
Addition 319.80 746.20 - - - - - - - -
Plant & Machinery Total 319.80 1,042.02 885.71 752.86 639.93 543.94 462.35 393.00 334.05 283.94
Depreciation 15% 23.99 156.30 132.86 112.93 95.99 81.59 69.35 58.95 50.11 42.59
Cl WDV 295.82 885.71 752.86 639.93 543.94 462.35 393.00 334.05 283.94 241.35

Rate 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
Op WDV 39.90 124.11 111.70 100.53 90.48 81.43 73.29 65.96 59.36
Addition 42.00 98.00 - - - - - - - -
Furniture & Fixtures Total 42.00 137.90 124.11 111.70 100.53 90.48 81.43 73.29 65.96 59.36
Depreciation 10% 2.10 13.79 12.41 11.17 10.05 9.05 8.14 7.33 6.60 5.94
Cl WDV 39.90 124.11 111.70 100.53 90.48 81.43 73.29 65.96 59.36 53.43

Rate 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
Op WDV 6.00 14.10 8.46 5.08 3.05 1.83 1.10 0.66 0.39
Addition 7.50 17.50 - - - - - - - -
Computers & Printers Total 7.50 23.50 14.10 8.46 5.08 3.05 1.83 1.10 0.66 0.39
Depreciation 40% 1.50 9.40 5.64 3.38 2.03 1.22 0.73 0.44 0.26 0.16
Cl WDV 6.00 14.10 8.46 5.08 3.05 1.83 1.10 0.66 0.39 0.24

Rate 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
Op WDV 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00
Addition 600.00 - - - - - - - - -
Land Total 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00
Depreciation 0% - - - - - - - - - - -
Cl WDV 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00

Rate 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
Op WDV 42.50 70.13 59.61 50.67 43.07 36.61 31.11 26.45 22.48
Addition 50.00 40.00 - - - - - - - -
Vehicles Total 50.00 82.50 70.13 59.61 50.67 43.07 36.61 31.11 26.45 22.48
Depreciation 30% 7.50 12.38 10.52 8.94 7.60 6.46 5.49 4.67 3.97 3.37
Cl WDV 42.50 70.13 59.61 50.67 43.07 36.61 31.11 26.45 22.48 19.11

Rate 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
Op WDV - 600.00 1,010.89 1,689.64 7,549.47 7,118.16 6,721.46 6,355.40 6,016.69 5,702.51 5,410.45
Addition 600.00 490.25 901.70 6,330.55 - - - - - - -
Total Total 600.00 1,090.25 1,955.09 8,090.32 7,609.08 7,168.83 6,764.53 6,392.01 6,047.80 5,728.95 5,432.93
Depreciation - 36.86 195.33 481.24 440.25 404.30 372.52 344.21 318.85 296.03 275.39
Cl WDV 600.00 1,053.39 1,759.77 7,609.08 7,168.83 6,764.53 6,392.01 6,047.80 5,728.95 5,432.93 5,157.53
 BAYSTONE ESTATE PVT LTD

TERM LOAN REPAYMENT SCHEDULE

Annexure-12
(Figures in Lacs)
EMI CALCULATOR
LOAN AMOUNT 3,413.00
RATE OF INTEREST PER ANNUM 12.00%
RATE OF INTEREST PER MONTH 1.000%
NO OF INSTALLMENT 120.00
GESTATION PERIOD (IN MONTHS) 0.00
EMI 48.967

CALCULATION OF DETAILS OF EMI

Months EMI Interest Principal Repayment O/S Principal

Oct-22 48.97 34.13 14.84 3,398.16
Nov-22 48.97 33.98 14.99 3,383.18
Dec-22 48.97 33.83 15.13 3,368.04
Jan-23 48.97 33.68 15.29 3,352.76
Feb-23 48.97 33.53 15.44 3,337.32
Mar-23 48.97 33.37 15.59 3,321.72
Total 293.80 202.52 91.28 FY 22-23
Apr-23 48.97 33.22 15.75 3,305.98
May-23 48.97 33.06 15.91 3,290.07
Jun-23 48.97 32.90 16.07 3,274.00
Jul-23 48.97 32.74 16.23 3,257.78
Aug-23 48.97 32.58 16.39 3,241.39
Sep-23 48.97 32.41 16.55 3,224.83
Oct-23 48.97 32.25 16.72 3,208.12
Nov-23 48.97 32.08 16.89 3,191.23
Dec-23 48.97 31.91 17.05 3,174.18
Jan-24 48.97 31.74 17.22 3,156.95
Feb-24 48.97 31.57 17.40 3,139.55
Mar-24 48.97 31.40 17.57 3,121.98
Total 587.60 387.86 199.74 FY 23-24
Apr-24 48.97 31.22 17.75 3,104.24
May-24 48.97 31.04 17.92 3,086.31
Jun-24 48.97 30.86 18.10 3,068.21
Jul-24 48.97 30.68 18.28 3,049.92
Aug-24 48.97 30.50 18.47 3,031.46
Sep-24 48.97 30.31 18.65 3,012.80
Oct-24 48.97 30.13 18.84 2,993.97
Nov-24 48.97 29.94 19.03 2,974.94
Dec-24 48.97 29.75 19.22 2,955.72
Jan-25 48.97 29.56 19.41 2,936.31
Feb-25 48.97 29.36 19.60 2,916.71
Mar-25 48.97 29.17 19.80 2,896.91
Total 587.60 362.53 225.07 FY 24-25
Apr-25 48.97 28.97 20.00 2,876.91
May-25 48.97 28.77 20.20 2,856.71
Jun-25 48.97 28.57 20.40 2,836.31
Jul-25 48.97 28.36 20.60 2,815.71
Aug-25 48.97 28.16 20.81 2,794.90
Sep-25 48.97 27.95 21.02 2,773.88
Oct-25 48.97 27.74 21.23 2,752.66
Nov-25 48.97 27.53 21.44 2,731.22
Dec-25 48.97 27.31 21.65 2,709.56
Jan-26 48.97 27.10 21.87 2,687.69
Feb-26 48.97 26.88 22.09 2,665.60
Mar-26 48.97 26.66 22.31 2,643.29
Total 587.60 333.98 253.62 FY 25-26
Apr-26 48.97 26.43 22.53 2,620.76
May-26 48.97 26.21 22.76 2,598.00
Jun-26 48.97 25.98 22.99 2,575.01
Jul-26 48.97 25.75 23.22 2,551.79
Aug-26 48.97 25.52 23.45 2,528.35
Sep-26 48.97 25.28 23.68 2,504.66
Oct-26 48.97 25.05 23.92 2,480.74
Nov-26 48.97 24.81 24.16 2,456.58
Dec-26 48.97 24.57 24.40 2,432.18
Jan-27 48.97 24.32 24.64 2,407.54
Feb-27 48.97 24.08 24.89 2,382.65
Mar-27 48.97 23.83 25.14 2,357.51
Total 587.60 301.82 285.78 FY 26-27
Apr-27 48.97 23.58 25.39 2,332.11
May-27 48.97 23.32 25.65 2,306.47
Jun-27 48.97 23.06 25.90 2,280.57
Jul-27 48.97 22.81 26.16 2,254.41
Aug-27 48.97 22.54 26.42 2,227.98
Sep-27 48.97 22.28 26.69 2,201.30
Oct-27 48.97 22.01 26.95 2,174.34
Nov-27 48.97 21.74 27.22 2,147.12
Dec-27 48.97 21.47 27.50 2,119.62
Jan-28 48.97 21.20 27.77 2,091.85
Feb-28 48.97 20.92 28.05 2,063.81
Mar-28 48.97 20.64 28.33 2,035.48
Total 587.60 265.57 322.03 FY 27-28
Apr-28 48.97 20.35 28.61 2,006.87
May-28 48.97 20.07 28.90 1,977.97
Jun-28 48.97 19.78 29.19 1,948.78
Jul-28 48.97 19.49 29.48 1,919.30
Aug-28 48.97 19.19 29.77 1,889.53
Sep-28 48.97 18.90 30.07 1,859.46
Oct-28 48.97 18.59 30.37 1,829.08
Nov-28 48.97 18.29 30.68 1,798.41
Dec-28 48.97 17.98 30.98 1,767.43
Jan-29 48.97 17.67 31.29 1,736.13
Feb-29 48.97 17.36 31.61 1,704.53
Mar-29 48.97 17.05 31.92 1,672.61
Total 587.60 224.73 362.87 FY 28-29
Apr-29 48.97 16.73 32.24 1,640.37
May-29 48.97 16.40 32.56 1,607.80
Jun-29 48.97 16.08 32.89 1,574.92
Jul-29 48.97 15.75 33.22 1,541.70
Aug-29 48.97 15.42 33.55 1,508.15
Sep-29 48.97 15.08 33.89 1,474.26
Oct-29 48.97 14.74 34.22 1,440.04
Nov-29 48.97 14.40 34.57 1,405.47
Dec-29 48.97 14.05 34.91 1,370.56
Jan-30 48.97 13.71 35.26 1,335.30
Feb-30 48.97 13.35 35.61 1,299.69
Mar-30 48.97 13.00 35.97 1,263.72
Total 587.60 178.71 408.89 FY 29-30
Apr-30 48.97 12.64 36.33 1,227.39
May-30 48.97 12.27 36.69 1,190.69
Jun-30 48.97 11.91 37.06 1,153.63
Jul-30 48.97 11.54 37.43 1,116.20
Aug-30 48.97 11.16 37.80 1,078.40
Sep-30 48.97 10.78 38.18 1,040.22
Oct-30 48.97 10.40 38.56 1,001.65
Nov-30 48.97 10.02 38.95 962.70
Dec-30 48.97 9.63 39.34 923.36
Jan-31 48.97 9.23 39.73 883.63
Feb-31 48.97 8.84 40.13 843.50
Mar-31 48.97 8.43 40.53 802.97
Total 587.60 126.85 460.75 FY 30-31
Apr-31 48.97 8.03 40.94 762.03
May-31 48.97 7.62 41.35 720.68
Jun-31 48.97 7.21 41.76 678.92
Jul-31 48.97 6.79 42.18 636.75
Aug-31 48.97 6.37 42.60 594.15
Sep-31 48.97 5.94 43.03 551.12
Oct-31 48.97 5.51 43.46 507.67
Nov-31 48.97 5.08 43.89 463.78
Dec-31 48.97 4.64 44.33 419.45
Jan-32 48.97 4.19 44.77 374.68
Feb-32 48.97 3.75 45.22 329.46
Mar-32 48.97 3.29 45.67 283.78
Total 587.60 68.42 519.18 FY 31-32
Apr-32 48.97 2.84 46.13 237.66
May-32 48.97 2.38 46.59 191.07
Jun-32 48.97 1.91 47.06 144.01
Jul-32 48.97 1.44 47.53 96.48
Aug-32 48.97 0.96 48.00 48.48
Sep-32 48.97 0.48 48.49 (0.00)
Total 293.80 10.01 283.79 FY 32-33