Detailed Project Report (DPR)

of
KHUSHI MANDAP DECORATORS

Prepared by :
Siddharth Arora
Subsidy Consultant
Khandawa, Madhya Pradesh

76071 #####
CONTENTS

1. EXECUTIVE SUMMARY

1.1 Project Snapshot – Introduction and Overview

1.2 Profile of Promoters, Business Owners

1.3 Employment Details

1.4 Cost of Project

1.5 Means of Finance

1.6 Existing Obligations

2. PROJECT VIABILITY & MARKET STUDIES

2.1 Feasibility Studies

2.2 Industry Analysis

2.3 Market Potential

2.4 Current Scenario

2.5 Challenges and Solutions

2.6 SWOT Analysis

3. FINANCIAL DATA & RATIOS

3.1 Summary of Funding Facility

3.2 Projected Balance Sheet

3.3 Projected Operating Statement

3.4 BS Annexure - Fixed Assets Schedule

3.5 P&L Annexure - Indirect Expenses

3.6 Projected Cash Flow Statement

3.7 Synopsis of Balance Sheet

3.8 Debt Service Coverage Ratio Analysis

3.9 Financial Indicators & Ratio

3.10 Current Ratio

3.11 Sensitivity Analysis

3.12 Break Even Analysis

3.13 Security Margin

3.14 Loan Repayment Summary

3.15 CMA Data

3.16 Summary Points

3.17 Notes & Assumptions

 DPR of Khushi Mandap Decorators

1. EXECUTIVE SUMMARY

1.1 Project Snapshot – Introduction and Overview

Name of the Entity – Khushi Mandap Decorators

Constitution – Proprietorship

Name of the Owner(s) – Mrs. Savitri Yashwant Jadhav

Address of the entity – Station Road, Lonkheda, Tal. Shahada, Dist. Nandurbar

Maharashtra - 425409

Business Description – Mandap Decorators

(Main service is providing decoration for Wedding Mandap, Reception, Flower

arrangement, Lighting Decoration, Stage Backdrops, Gate Decoration, Generator &

Furniture for parties)

Funding Amount Details – Term Loan of Rs. 6 lakhs for 5 years

and Cash Credit of Rs. 3 lakhs

The demand for mandap designers and decorators wedding services is dependent upon

the personal income of the consumer and/or their families, as well as consumer

preferences for their wedding ceremony. As there are so many different organizations

that must coordinate to create a wedding, competition is often steep within this

industry. Some businesses offer more than one mandap designers and decorators

wedding service in order to generate increased revenue, while others specialize in one

Page 4 of 50
 DPR of Khushi Mandap Decorators

sector of the mandap designers and decorators wedding service industry and focus on

supremely efficient and effective in that unique area.

As the owner Mrs. Jadhav having a good business connection and tremendous

experiance in the locality, it is easier to carry out the business more efficiently and the

goodwill of the Business unit has been created at a greater extent.

Page 5 of 50
 DPR of Khushi Mandap Decorators

1.2 Profile of Promoters, Business Owners

Mrs. Savitri Yashwant Jadhav is having more than 10 years’ experience in the mandap

business. He has been working in Nandurbar district and nearby area efficiently and

with maximum client satisfaction.

Khushi Mandap Decorators is having a staff of more than 20 people which is dedicated

towards best quality services to their clients and Mrs. Jadhav being the owner ensures

the same. The driving force behind every business is increased revenue and high profits.

Service provider should be confident about the service they are providing as well as

their own ability to successfully, gain the trust, arouse an interest and eventually

convince them. The Business owners are having all such qualities inherently and were

able to develop the same during the business course of their other respective

businesses. Convincing a prospective customer to avail the service is not an easy task.

Convincing is an art and requires patience; applicant is skillful in such task & it can be

considered as a plus point for an entity.

Page 6 of 50
 DPR of Khushi Mandap Decorators

1.3 Employment Details

One should insist to increase the employment levels of the country. In the light of this,

entrepreneurs and professionals & service providers help the economy by generating

employment in urban and rural areas.

In coming years and decades, India is expected to witness significant demographic

growth and expansion in the working age population. To absorb such labor force in the

future, all the sectors viz. manufacturing, service, trading and agriculture would need to

play an important role. Currently service sector accounts for approximately 7% to 8% of

the total employment in the country, which is well below its true potential.

Number of Employees at present in Khushi Mandap Decorators – 20 employess

Page 7 of 50
 DPR of Khushi Mandap Decorators

1.4 Cost of Project

Estimating the cost of a project varies based on the industry, the type and scope of the

project undertaken and the time frame for completing the project. While the variables

of any given project may change according to circumstances, there are 3 main elements

of project costing found in most all project cost estimations.

Material Costs - All materials necessary for a project are included in material costs.

Materials are anything the project manager purchases to aid in or conduct the project.

Operating Costs - The operating costs of a project include the fees associated with

purchasing project supplies, paying rent and associated costs on a facility or location for

the project to take place, the cost of permitting, inspections and daily operations.

Such costs can further be divided into 2 types viz. capital expenditure and revenue

expenditure.

Detailed particulars about the cost have been provided hereunder :

Sr. Particulars Amount Rs. (in

No. Lacs)
1 Asset Addition 8.00
2 Plant & Machinery --
3 Equipments --
4 Furniture & Fixtures --
5 Land (Industrial) --
6 Working Capital 4.00
Total Cost in Rs. 12.00

Page 8 of 50
 DPR of Khushi Mandap Decorators

1.5 Means of Finance

MEANS OF FINANCE (Rs. in lakhs)

Term Loan 6.00

Cash Credit 3.00

Own Contribution 3.00

Total 12.00

1.6 Existing Obligations

The business owners are not having any heavy existing obligations with regards to this
mandap business. Although, all the documents in that connection have been attached
in the proposal file.

Page 9 of 50
 DPR of Khushi Mandap Decorators

2. PROJECT VIABILITY & MARKET STUDIES

2.1 Feasibility Studies

In order to carry on a feasibility study of business in service sector, we need a detailed

understanding of:

 our service

 the industry we will be competing in

 the nature of the market

 the amount of capital needed

Filling a viable gap in the market is key to the success of the business in service sector.

The service should be unique, solve an existing or potential problem, and provide an

incentive for your customers to switch to it – be it quality, price, or improvement.

Knowing the competitors (either direct or indirect) in the target market, and how the

invention or product compares on functionality, durability, appearance and price.

Page 10 of 50
 DPR of Khushi Mandap Decorators

A feasibility analysis evaluates the project’s potential for success; therefore, perceived

objectivity is an essential factor in the credibility of the study for potential investors

and lending institutions. One of the prerequisites for a successful business or unit is

to have the technically feasible business model. A technical feasibility evaluates the

details of how you propose to deliver a product or service to customers. Think

materials, labour, transportation, where your business will be located, and

the technology that will be necessary to bring all this together.

Mandapa in Indian architecture is a pillared outdoor hall for public. It is used for

conducting religious discourses. The couple is given royal chairs to sit on during the

ceremony, while the parents sit beside them watching each ritual take place. The

unskilled labour are required for the service. Due to abundant availability of labour,

proper facilities & land productivity of business rises. Thereby providing the mandap

designer and decorators service in market with a continuous service delivery. So

business grow at very fast rate at in the globe. The working hours of this service is very

flexible, so they grab more customer & earning more profit.

A detailed financial feasibility study has also been carried out based on the current

demand – supply analysis and data & assumption-based projections ; which has been

separately presented in the FINANCIAL FEASIBILITY section in (3) Financial Data &

Ratios. ‘Sensitivity analysis’ and ‘assessed bank finance’ studies will help in

ascertaining the financial viability of the project.

Page 11 of 50
 DPR of Khushi Mandap Decorators

2.2 Industry Analysis

The mandap designers and decorators service in India is composed of a variety of sub-

group service establishments that work cooperatively to create a wedding event.

These mandap designers and decorators sub-groups may include - wedding

invitations, bakeries for the wedding cake, jewelers for wedding rings, event

transportation, event photography and/or videography, wedding planning services,

formal wedding attire, wedding locations, banquet/reception locations, catering, and

the securing of those individuals qualified to preside over wedding ceremonies.

The mandap designers and decorators service is globally diverse, and there are a

variety of types and traditions that are involved in ceremonies between ethnic groups,

countries, and cultures. These traditions are based on both religion and the personal

Page 12 of 50
 DPR of Khushi Mandap Decorators

preferences of the parties involved. Most wedding ceremonies involve the couple

reciting and/or exchanging vows. Though traditional vows have been customary,

recently couples have more often been choosing to create their own vows. There is

also typically a giving of a symbol between both parties, this symbol may be rings,

flowers, money, or other symbolic offerings, in addition, the master of ceremonies

involved in the wedding will usually issue statement proclaiming the parties to be

legally married. Celebrations frequently follow the wedding ceremony.

The demand for mandap designers and decorators wedding services is dependent

upon the personal income of the consumer and/or their families, as well as consumer

preferences for their wedding ceremony. As there are so many different organizations

that must coordinate to create a wedding, competition is often steep within this

industry. Some businesses offer more than one mandap designers and decorators

wedding service in order to generate increased revenue, while others specialize in one

sector of the mandap designers and decorators wedding service industry and focus

on supremely efficient and effective in that unique area.

India’s service sector itself is expected to grow from $ 115 billion to $ 360 billion by

2032.

On the basis various factors related to industry analysis, a detailed scrutiny was

carried out by the promoters / business owners and to conclude, based on the SWOT

and Porter’s five forces business model, they found the industry very demanding and

scope for the business is unrestricted.

Page 13 of 50
 DPR of Khushi Mandap Decorators

2.3 Market Potential

 The Indian mandap designers and decorators wedding service market was valued
at USD $88.7 billion in the year of 2018, which is expected to reach USD $122.6
billion by the year of 2024, registering CAGR of 7.8% during the forecast period of
2019–2024.

 The Indian mandap designers and decorators wedding service market is expected
to increase at a CAGR of 12.06% from the period of 2021 and reach USD $121.3
billion by the year of 2023.

 The Indian mandap designers and decorators wedding service market size is
projected to grow from USD $74.1 billion in the year of 2016 to USD $130.9 billion
by the year of 2025, at a CAGR of 9.04% during the forecast period.

Page 14 of 50
 DPR of Khushi Mandap Decorators

 The Indian mandap designers and decorators wedding service market is expected
to grow at a CAGR of 14.1% to nearly USD $192.6 billion by the year of 2025, and
at a CAGR of 11.0% to USD $223.3 billion by the year of 2030.

 The Indian mandap designers and decorators wedding service market is presumed
to reach the valuation of nearly USD $232.28 billion by the year of 2026 from USD
$158.15 billion in the year of 2019 with a CAGR of 15.02% under the study period
of from the year of 2020 - 2026.

 The Indian mandap designers and decorators wedding service market expected to
have a CAGR of 11.6% from the year of 2019 to 2024, to reach a market size of USD
$123.00 billion by the end of the year 2027.

Page 15 of 50
 DPR of Khushi Mandap Decorators

2.4 Current Scenario

 The Indian mandap designers and decorators service market is expectedly increase
from USD $49.6 billion in the year of 2019 to USD $86.9 billion in the year of 2020
at a compound annual growth rate (CAGR) of 8.5%.

 The Indian mandap designers and decorators service market size was valued at
USD $78.2 billion in the year of 2018 and is expected to register a CAGR of 9.1%
over the period.

Page 16 of 50
 DPR of Khushi Mandap Decorators

 In India the revenue in the Indian mandap designers and decorators service market
segment is projected to reach USD $89.8 million in the year of 2020.

 In the India with 75%, the wedding mandap designers and decorators is the mostly
preferred for the wedding planner’s service market segment in the year of 2019 in
the selected region.

 In the India the average revenue per user in the Indian wedding mandap designers
and decorators service market segment is expectedly to increase to USD $138.15
by the year of 2021.

 In the year of 2020 a share mandap designers and decorators services market is
42.6% in India.

 The Indian market size of the mandap designers and decorators service markets
industry is expected to increase 17.0% by the year of 2021.

Page 17 of 50
 DPR of Khushi Mandap Decorators

2.5 Challenges & Solutions

1. Aggressively Competitive Industry -

The mandap designers and decorators service is a competitive business. People end
up spending close to 30% of their life’s savings on weddings. Therefore negotiations
are an integral part of this industry. Additionally, new vendors mushroom up almost
overnight with highly competitive and attractive offers. These competitors often
provide tempting packages to attract customers. While facing such competition, there
is a likelihood of over-commitment with unrealistic costs. The biggest danger of over-
commitment is the inability to deliver or deliver below the committed standards. This
can seriously damage their reputation and reduce business. The best way to tackle
competition is staying firm on their pricing structure and focusing wholeheartedly on
delivering the best possible service.

2. Ensuring the Privacy and Safety of Premium Clients -

It takes a lot of hard work and commitment to get VIP clients. It also becomes a
daunting task to ensure the privacy and safety of premium clients. VIP clients often
demand the highest security and a complete ban of gate-crashers. The most assured
way to fulfil these demands is to collaborate with the best in the business. Only top
security agencies with an excellent track record of managing VIP safety should be
hired.

3. Managing Time while Delivering the Best -

The reputation of a mandap designers and decorators are depends on the D-Day
execution. The tall talks and great promises are put to test when D-Day arrives.

Page 18 of 50
 DPR of Khushi Mandap Decorators

Managing the availability and decoration of the venue is a crucial aspect. Often venues
have back to back weddings and the agency gets access to the venue much later than
desired. At such times it is difficult to deliver everything that was promised. The safest
way to deal with this problem is practice execution in as little time as possible.
Preparing for a massive time-crunch and leaving some room for review and
refurbishing is extremely important.

4. Tightrope Walk of Last Minute Demands -

A wedding is incomplete without surprises and not all can be pleasant. More often
than not there will be last-minute demands from clients and their relatives about
decor, catering, music and lighting arrangements. Be ready to face all such demands.
Make a checklist of possible surprises and a quick method to resolve the same.

5. Venue – Rules and Regulations -

Venues are the most important feature of any wedding. The greatness of a wedding
depends on the selection of the venue. Each venue and location comes with its specific
rules and regulations. At times the clients are unaware of these finer details which can
lead to some serious problems. Ensure that they have officially and explicitly made
their self-aware of all the rules and also informed the clients well within time.

6. Pleasing Them All -

A good mandap designers and decorators are takes orders while a truly great wedding
decorators listens to everything that everyone has to say. Sincerity can raise
expectations and increase demands. It is always a great idea to differentiate a genuine
demand from a mere whim. Talk to the clients about the practical aspects of fulfilling

Page 19 of 50
 DPR of Khushi Mandap Decorators

everyone’s demands. Choose what is best for the client while avoiding any
unpleasantness.

7. Unpredictable Variables -

Weddings are full of surprises even if they have done everything to plan it all. There
are certain unpredictable factors like rain, storm, and technical glitches. Always have
an alternative plan ready to deal with unpredictable situations. Keep their clients
informed about the weather forecast and possible technical glitches. If required then
draw up a list of variables beyond their control and draft a disclaimer.

Page 20 of 50
 DPR of Khushi Mandap Decorators

2.6 SWOT Analysis

SWOT analysis can be applied by analyzing and observing the things that affect the

four factors, then apply them in the picture in the SWOT matrix, apply the strengths

map to take advantage of the opportunities, how to overcome the weaknesses that

prevent the advantages of opportunities are able to deal with the threats that exist,

and the last is how to overcome the weaknesses that can make threats become real

or create a new threat. Determining the direction of development of a business is

strongly influenced by many factors, namely internal and external factors .

A SWOT analysis is an incredibly simple, yet powerful tool to help you develop your

business strategy, whether you’re building a start-up or guiding an existing company.

SWOT stands for Strengths, Weaknesses, Opportunities, and Threats.

SWOT Analysis is a strategic planning method used to evaluate strengths, weaknesses,

opportunities, and threats, in a project business. These four factors are called SWOT

(strengths, weaknesses, opportunities, and threats). This process involves the specific

determination and objectives of a manufacturing or business project that identifies

internal and external factors.

One may think that they already know everything that they need to do, to succeed,

but a SWOT analysis will force them to look at the business in new ways and from new

directions.

Page 21 of 50
 DPR of Khushi Mandap Decorators

Strengths

o Availability of services regardless time

o Geographic availability of services

o Speed of service delivery

o Low capital intensity

o Rapid Industrial growth

o Increase in foreign investments

o Lower response time and efficient services

Weaknesses

o Lack of Data privacy protection

o Unfriendly interface that has as a result the misjudgement of the service provision

o Lack of transparency in overall processes

o More dependability on other country for goods, machinery, new techniques etc.

o Lack of capital for all start up in service sector

o More skilled employees & workers are required

o Lack of skills and knowledge

Opportunities

o Appearance of new partners/alliances via new type of service provision

o New customer segments

o Chances to meet ecological, medical and ergonomic requirements

Page 22 of 50
 DPR of Khushi Mandap Decorators

o Collaboration and communication opportunities between departments of large

institutions with many branches

o Potential for improved effectiveness and efficiency through transformations

o Development of business connection

o Growing Market potential in India

Threats

o Inadequate budgets decline in real terms (inflation)

o Unstable macroeconomic and political environment

o Retrenchments most of the times begin from the bottom with the community

service providers

o Low internet connectivity in rural areas

o Changing in customer needs, taste and preference

Page 23 of 50
 DPR of Khushi Mandap Decorators

SUMMARY OF FUNDING FACILITY

COST OF PROJECT Rs in lakhs

Particulars Amount Rs.

Asset Addition 8.00

Working Capital Requirement 4.00

Total 12.00

SOURCES OF FUND Rs in lakhs

Particulars Amount Rs.

Term Loan 6.00

Cash Credit 3.00
Own Contribution 3.00

Total 12.00

Page 24 of 50
 DPR of Khushi Mandap Decorators

PROJECTED BALANCE SHEET rupees in lakhs

Audited Tentative Projected

Particulars
FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 FY 2026
I LIABILITIES
A DEBT LIABILITIES
Secured Loans 18.58 18.93 3.17 2.02 0.73 - -
(excluding installments for 1 year)
Existing Loans (if any) - - 16.09 13.68 11.63 9.88 8.40

Total Secured Loans 18.58 18.93 19.26 15.69 12.36 9.88 8.40

Unsecured Loans - - - - - - -
Total Unsecured Loans - - - - - - -
A. Total Outside Liabilities 18.58 18.93 19.26 15.69 12.36 9.88 8.40

B CURRENT LIABILITES
Cash Credit / OD / DLOD - - 3.00 3.00 3.00 3.00 3.00
Sundry Creditors - - - - - - -
Provisions - - - - - - -
Short Term Borrowings from Banks/Others (up to 1 year)- - - - - - -
Advance Payment from Customer/s - - - - - - -
Creditors for Capital Goods - - - - - - -
Other Current Liabilities - - - - - - -

B. Total Current Liabilities - - 3.00 3.00 3.00 3.00 3.00

TOTAL OUTSIDE LIABILITIES(A+B) 18.58 18.93 22.26 18.69 15.36 12.88 11.40
NET WORTH
Capital Balance
Opening Balace / Share Capital (incl. Reserves) 62.74 67.79 68.72 77.93 84.62 92.05 100.63
Own Contribution for Business - - 3.00 - - - -
Surplus (+) or deficit (-) in P&L Account 5.05 9.93 9.10 9.78 10.74 12.13 13.03
Drawings - - (2.89) (3.09) (3.31) (3.54) (3.79)
Any other item (+)/(-) - (9.00) - - - - -

SUB TOTAL 67.79 68.72 77.93 84.62 92.05 100.63 109.87

TOTAL LIABILITIES 86.37 87.65 100.19 103.31 107.41 113.51 121.27

Page 25 of 50
 DPR of Khushi Mandap Decorators

PROJECTED BALANCE SHEET rupees in lakhs

Audited Tentative Projected

Particulars
FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 FY 2026

II ASSETS
CURRENT ASSETS - - - - -
Cash & Bank 0.49 1.72 2.43 3.80 4.36 8.93 13.54
Stock in hand - - - - - - -
Sundry Debtors & Receivables - 4.25 1.35 1.73 1.85 1.98 2.12
Advances to Staff or Creditors - - - - - - -
Deposits - - - - - - -
Security Deposit & TDS, Taxes (Advance, etc.) - - - 2.00 2.40 2.88 3.46
Export & Other Receivables - - - - - - -
Other Current Assets (Mandap Stock) 8.80 12.80 15.80 16.12 16.44 16.77 17.10

TOTAL CURRENT ASSETS 9.29 18.77 19.58 23.65 25.05 30.56 36.22

INVESTMENTS 0.17 0.17 5.00 5.00 8.50 9.80 12.50

OTHER NON-CURRENT ASSETS - - - - - - -

FIXED ASSETS
GROSS BLOCK 90.48 76.91 68.71 75.61 74.67 73.85 73.15
Addition : - - 8.00 - - - -
Less : Depreciation 13.57 8.20 1.10 0.95 0.81 0.70 0.60
NET BLOCK 76.91 68.71 75.61 74.67 73.85 73.15 72.55

TOTAL ASSETS 86.37 87.65 100.19 103.31 107.41 113.51 121.27

- - - - - - -

Page 26 of 50
 DPR of Khushi Mandap Decorators

PROJECTED OPERATING STATEMENT rupees in lakhs

Audited Tentative Projected

Particulars
FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 FY 2026
1. GROSS INCOME
Domestic Revenue 9.91 19.86 23.43 25.31 27.08 28.98 31.01
Export Revenue - - - - - - -
Less : GST / Other Duties / Return - - - - - - -

SUB TOTAL 9.91 19.86 23.43 25.31 27.08 28.98 31.01

2. COST OF SALES
Opening Stock - - - - - - -

Purchases (+) 3.83 7.92 9.19 10.07 10.78 11.53 12.34

Direct Labour (Wages) (+) 0.02 0.50 0.66 0.76 0.81 0.87 0.93
Power & Fuel (+) - - - - - - -
Other prime costs (+) - - - - - - -
Closing Stock (-) - - - - - - -
SUB TOTAL 3.85 8.42 9.84 10.83 11.59 12.40 13.27
Gross Profit % 61.15% 57.60% 58.00% 57.20% 57.20% 57.20% 57.20%

3. INDIRECT COSTS 1.01 1.51 1.61 1.73 1.80 1.90 2.02

OPERATING PROFIT 5.05 9.93 11.98 12.75 13.69 14.67 15.72
Non Operating Income - - - - - - -

Interest and Financial Charges

Cash Credit 0.32 0.32 0.32 0.32 0.32
- -
Term Loan 0.45 0.51 0.39 0.26 0.12
Any Existing Funding Facility (TL) - - - - - - -
Any Existing Funding Facility (other than TL) - - - - - - -
Depreciation - - 1.10 0.95 0.81 0.70 0.60
NET PROFIT BEFORE TAX 5.05 9.93 10.12 10.98 12.17 13.39 14.68
Net Profit % 50.96% 50.00% 43.18% 43.38% 44.95% 46.22% 47.35%

Provision for Income Tax - - 1.02 1.20 1.43 1.27 1.65

PROFIT AFTER TAX (PAT) 5.05 9.93 9.10 9.78 10.74 12.13 13.03

Page 27 of 50
 DPR of Khushi Mandap Decorators

FIXED ASSETS ANNEXURE

1 Computers Rate Of Depreciation 40%

Year Opening Additions During the Year Deletions Total Depreciation Closing
Balance Before Oct. After Oct. Balance

Year 1 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Year 2 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Year 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Year 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Year 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Year 6 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Year 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2 Plant & Machinery Rate Of Depreciation 15%

Year Opening Additions During the Year Deletions Total Depreciation Closing
Balance Before Oct. After Oct. Balance

Year 1 0.00 6.00 0.00 0.00 6.00 0.90 5.10

Year 2 5.10 0.00 0.00 0.00 5.10 0.77 4.34
Year 3 4.34 0.00 0.00 0.00 4.34 0.65 3.68
Year 4 3.68 0.00 0.00 0.00 3.68 0.55 3.13
Year 5 3.13 0.00 0.00 0.00 3.13 0.47 2.66
Year 6 2.66 0.00 0.00 0.00 2.66 0.40 2.26
Year 7 2.26 0.00 0.00 0.00 2.26 0.34 1.92

3 Plant Shed Construction Rate Of Depreciation 10%

Year Opening Additions During the Year Deletions Total Depreciation Closing
Balance Before Oct. After Oct. Balance

Year 1 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Year 2 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Year 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Year 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Year 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Year 6 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Year 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00

4 Furniture & Fixtures Rate Of Depreciation 10%

Year Opening Additions During the Year Deletions Total Depreciation Closing
Balance Before Oct. After Oct. Balance

Year 1 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Year 2 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Year 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Year 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Year 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Year 6 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Year 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Page 28 of 50
 DPR of Khushi Mandap Decorators

FIXED ASSETS ANNEXURE

5 Plots & Land Rate Of Depreciation 0%

Year Opening Additions During the Year Deletions Total Depreciation Closing
Balance Before Oct. After Oct. Balance

Year 1 68.71 0.00 0.00 0.00 68.71 0.00 68.71

Year 2 68.71 0.00 0.00 0.00 68.71 0.00 68.71
Year 3 68.71 0.00 0.00 0.00 68.71 0.00 68.71
Year 4 68.71 0.00 0.00 0.00 68.71 0.00 68.71
Year 5 68.71 0.00 0.00 0.00 68.71 0.00 68.71
Year 6 68.71 0.00 0.00 0.00 68.71 0.00 68.71
Year 7 68.71 0.00 0.00 0.00 68.71 0.00 68.71

6 Building & Civil Works Rate Of Depreciation 10%

Year Opening Additions During the Year Deletions Total Depreciation Closing
Balance Before Oct. After Oct. Balance

Year 1 0.00 2.00 0.00 0.00 2.00 0.20 1.80

Year 2 1.80 0.00 0.00 0.00 1.80 0.18 1.62
Year 3 1.62 0.00 0.00 0.00 1.62 0.16 1.46
Year 4 1.46 0.00 0.00 0.00 1.46 0.15 1.31
Year 5 1.31 0.00 0.00 0.00 1.31 0.13 1.18
Year 6 1.18 0.00 0.00 0.00 1.18 0.12 1.06
Year 7 1.06 0.00 0.00 0.00 1.06 0.11 0.96

7 Transport Vehicles & Other Assets Rate Of Depreciation 15%

Year Opening Additions During the Year Deletions Total Depreciation Closing
Balance Before Oct. After Oct. Balance

Year 1 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Year 2 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Year 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Year 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Year 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Year 6 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Year 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00

SUMMARY
Year Opening Additions During the Year Deletions Total Depreciation Closing
Balance Before Oct. After Oct. Balance

Year 1 68.71 8.00 0.00 0.00 76.71 1.10 75.61

Year 2 75.61 0.00 0.00 0.00 75.61 0.95 74.67
Year 3 74.67 0.00 0.00 0.00 74.67 0.81 73.85
Year 4 73.85 0.00 0.00 0.00 73.85 0.70 73.15
Year 5 73.15 0.00 0.00 0.00 73.15 0.60 72.55
Year 6 72.55 0.00 0.00 0.00 72.55 0.52 72.04
Year 7 72.04 0.00 0.00 0.00 72.04 0.45 71.59

Page 29 of 50
 DPR of Khushi Mandap Decorators

INDIRECT EXPENSES ANNEXURE

rupees in lakhs

Projected
Sn. Particulars
FY 2022 FY 2023 FY 2024 FY 2025 FY 2026

1 Accounting & Audit - - - - -

2 Bank Charges 0.12 0.13 0.13 0.14 0.15
3 Electricity Expenses 0.21 0.22 0.24 0.25 0.27
4 Rent 0.54 0.59 0.59 0.62 0.65
5 Telephone Expenses 0.17 0.18 0.19 0.20 0.21
6 Printing & Stationery - - - -
7 Professional Fees - - - -
8 Salaries - - - -
9 Fuel & Travelling Expenses 0.57 0.61 0.65 0.70 0.75
10 Repairs & Maintenance - - - -

TOTAL 1.61 1.73 1.80 1.90 2.02

Page 30 of 50
 DPR of Khushi Mandap Decorators

PROJECTED CASH FLOW STATEMENT

rupees in lakhs

Projections
Sr No Particulars
FY 2022 FY 2023 FY 2024 FY 2025 FY 2026

A CASH FLOW FROM OPERATING ACTIVITIES

Net Profit Before Tax 10.12 10.98 12.17 13.39 14.68

Adjustments for:
Depreciation 1.10 0.95 0.81 0.70 0.60
Interest & Finance Charges debited to Profit & Loss Account 0.76 0.82 0.71 0.58 0.44
Operating Profit before Working Capital Changes 11.98 12.75 13.69 14.67 15.72

Adjustments for:
Decrease/(Increase) in Receivables 2.90 (0.39) (0.12) (0.13) (0.14)
Decrease/(Increase) in Inventories - - - - -

Decrease/(Increase) in Other asset - (2.00) (0.40) (0.48) (0.58)

Decrease/(Increase) in Other receivables - - - - -
Decrease/(Increase) in Advance Tax Payments (3.00) (0.32) (0.32) (0.33) (0.34)
Increase/(Decrease) in Payables - - - - -
Increase/(Decrease) in Short Term Borrowings - - - - -
Increase/(Decrease) in Capital Goods creditors & others - - - - -

Cash generated from operations 11.88 10.04 12.85 13.73 14.67

Income Tax paid (1.02) (1.20) (1.43) (1.27) (1.65)
Net Cash flow from Operating activities 10.86 8.85 11.41 12.46 13.02

B CASH FLOW FROM INVESTING ACTIVITIES

Cash Credit 3.00 - - - -
Own Contribution for Business 3.00 - - - -
Purchase of Assets (8.00) -
Loan and Advances - - - - -
Investments & Other Assets (4.83) - (3.50) (1.30) (2.70)
Net Cash used in Investing activities (6.83) - (3.50) (1.30) (2.70)

Page 31 of 50
 DPR of Khushi Mandap Decorators

PROJECTED CASH FLOW STATEMENT

rupees in lakhs

Projections
Sr No Particulars
FY 2022 FY 2023 FY 2024 FY 2025 FY 2026

C CASH FLOW FROM FINANCING ACTIVITIES

Loan Disbursement / Repayment 0.33 (3.57) (3.34) (2.48) (1.48)
Drawings by Propritor (2.89) (3.09) (3.31) (3.54) (3.79)
Interest paid for Cash Credit Limit (0.32) (0.32) (0.32) (0.32) (0.32)
Interest paid for Term Loan Limit (0.45) (0.51) (0.39) (0.26) (0.12)
Increase/(Decrease) in Capital Account Items - - - - -
Increase/(Decrease) in Contingent Liabilities - - - - -
Unsecured Loans & Quasi Capital - - - - -
Net Cash used in Financing Activities (3.32) (7.48) (7.35) (6.60) (5.71)

Net increase in cash & Cash Equivalents 0.71 1.37 0.56 4.57 4.61

Cash and Cash equivalents as at the beginning of the year 1.72 2.43 3.80 4.36 8.93
Cash and Cash equivalents as at the end of the year 2.43 3.80 4.36 8.93 13.54
Net increase in cash & Cash Equivalents 0.71 1.37 0.56 4.57 4.61

Page 32 of 50
 DPR of Khushi Mandap Decorators

SYNOPSIS OF BALANCE SHEET

rupees in lakhs

Projected
Particulars
FY 2022 FY 2023 FY 2024 FY 2025 FY 2026

Source of Funds
Share capital 77.93 84.62 92.05 100.63 109.87
Reserves & surplus / any other item - - - -
Secured loans : Short term 3.00 3.00 3.00 3.00 3.00
: Long term 19.26 15.69 12.36 9.88 8.40
Unsecured loans - - - - -
Other liabilities - - - - -
Total 100.19 103.31 107.41 113.51 121.27

Uses of Funds
Fixed assets (Gross Block) 76.71 75.61 74.67 73.85 73.15
Less : Depreciation 1.10 0.95 0.81 0.70 0.60
Net block 75.61 74.67 73.85 73.15 72.55
Investments & Other Assets 5.00 5.00 8.50 9.80 12.50
Inventories - - - - -
Sundry Debtors 1.35 1.73 1.85 1.98 2.12
Cash & Bank balances 2.43 3.80 4.36 8.93 13.54
Loans & advances to others - - - - -
Other Current Assets 15.80 18.12 18.84 19.65 20.56
(Less current liabilities) - - - - -
(Less provisions) - - - - -
NET CURRENT ASSETS 24.58 28.65 33.55 40.36 48.72
Misc. expenditure (to the extent not written
- - - - -
off or adjusted
Total 100.19 103.31 107.41 113.51 121.27

Page 33 of 50
 DPR of Khushi Mandap Decorators

DEBT SERVICE COVERAGE RATIO ANALYSIS

Projections
PARTICULARS
FY 2022 FY 2023 FY 2024 FY 2025 FY 2026
Net Profit After Interest & Tax 9.10 9.78 10.74 12.13 13.03
(+) Depriciation 1.10 0.95 0.81 0.70 0.60
(+) Bank Interest 0.45 0.51 0.39 0.26 0.12

Net Cash Inflow 10.64 11.24 11.94 13.09 13.75

Bank Interest 0.45 0.51 0.39 0.26 0.12

Principal Repayment of Installment 1.79 2.11 2.23 2.36 2.88

Net Cash Outflow 2.23 2.62 2.62 2.62 3.00

Debt Service Coverage Ratio 4.77 4.29 4.56 4.99 4.58

Page 34 of 50
 DPR of Khushi Mandap Decorators

FINANCIALS INDICATORS
Sr. Projections
PARTICULARS
No. FY 2022 FY 2023 FY 2024 FY 2025 FY 2026

1 SALES(a) 23.43 25.31 27.08 28.98 31.01

2 OTHER INCOME(b) 0.00 0.00 0.00 0.00 0.00
3 TOTAL INCOME (a+b) 23.43 25.31 27.08 28.98 31.01
4 OPERATING PROFIT 11.98 12.75 13.69 14.67 15.72
5 NET PROFIT 9.10 9.78 10.74 12.13 13.03
6 CASH PROFIT 10.20 10.73 11.55 12.82 13.63
7 OPEARATING PROFIT MARGIN(%) 51.13% 50.36% 50.56% 50.63% 50.70%
8 NET PROFIT MARGIN (%) 38.81% 38.66% 39.65% 41.85% 42.02%
9 CASH PROFIT TO SALES 43.51% 42.39% 42.65% 44.26% 43.95%
10 QUASSI CAPITAL (UNSECURED LOANS) 0.00 0.00 0.00 0.00 0.00
11 CAPITAL 77.93 84.62 92.05 100.63 109.87
12 NET WORTH 77.93 84.62 92.05 100.63 109.87
13 TOTAL OUTSIDE LIABILITIES 3.00 3.00 3.00 3.00 3.00
14 CURRENT RATIO 6.53 7.88 8.35 10.19 12.07
15 QUICK RATIO 6.53 7.88 8.35 10.19 12.07
16 DEBTORS TURNOVER RATIO 17.38 14.60 14.60 14.60 14.60
17 CREDITORS TURNOVER RATIO N.A. N.A. N.A. N.A. N.A.
18 FIXED ASSET TURNOVER RATIO 0.31 0.34 0.37 0.40 0.43
19 SALES TO CAPITAL EMPLOYED 1.41 1.23 1.23 1.05 0.93
20 FIXED ASSETS TO NET WORTH 0.97 0.88 0.80 0.73 0.66
21 CREDITORS NO. OF DAYS PURCHASES - - - - -
22 RECEIVABLES NO. OF DAYS SALES 21.00 25.00 25.00 25.00 25.00
23 STOCK NO. OF DAYS SALES - - - - -
24 TOL/TNW 0.04 0.04 0.03 0.03 0.03
25 DEBT MANAGEMENT RATIO 19.23% 15.19% 11.51% 8.71% 6.93%
26 INTEREST COVERAGE 14.26 14.37 18.24 24.14 34.57
27 PROPRIETARY RATIO 0.78 0.82 0.86 0.89 0.91
28 CASH FLOW YIELD 97.29% 116.66% 116.07% 107.33% 103.86%
29 CASH FLOW TO ASSETS 8.83% 11.05% 11.60% 11.47% 11.16%

Page 35 of 50
 DPR of Khushi Mandap Decorators

CURRENT RATIO
Projections
PARTICULARS
FY 2022 FY 2023 FY 2024 FY 2025 FY 2026

CURRENT ASSETS
Cash & Bank 2.43 3.80 4.36 8.93 13.54
Stock in hand - - - - -
Sundry Debtors 1.35 1.73 1.85 1.98 2.12
Advances - - - - -
Deposits - 2.00 2.40 2.88 3.46
Security Deposit & TDS, Taxes (Advance, etc.) - - - - -
Other Current Assets (Mandap Stock) 15.80 16.12 16.44 16.77 17.10

TOTAL CURRENT ASSETS 19.58 23.65 25.05 30.56 36.22

CURRENT LIABILITIES
Cash Credit 3.00 3.00 3.00 3.00 3.00
Sundry Creditors - - - - -
Provisions - - - - -
Other Current Liabilities - - - - -

TOTAL CURRENT LIABILITIES 3.00 3.00 3.00 3.00 3.00

CURRENT RATIO 6.53 7.88 8.35 10.19 12.07

Page 36 of 50
 DPR of Khushi Mandap Decorators

SENSITIVITY ANALYSIS
rupees in lakhs
I. REVENUE GROWTH OF 5%

PARTICULARS FY 2022 FY 2023 FY 2024 FY 2025 FY 2026

Projected revenue 23.43 25.31 27.08 28.98 31.01
% Change 5% 5% 5% 5% 5%
Growth 1.17 1.27 1.35 1.45 1.55
Change

Cost of Goods sold 9.84 10.83 11.59 12.40 13.27

Indirect Costs 1.61 1.73 1.80 1.90 2.02
Interest, Depreciation 1.86 1.77 1.52 1.28 1.04

EBT 10.12 10.98 12.17 13.39 14.68

Updated EBT 11.29 11.03 12.22 13.44 14.73
Impact on EBT 1.17 0.05 0.05 0.05 0.05

II. REVENUE REDUCTION OF (-)5%

PARTICULARS FY 2022 FY 2023 FY 2024 FY 2025 FY 2026

Projected revenue 23.43 25.31 27.08 28.98 31.01
% Change 5% 5% 5% 5% 5%
Updated Revenue 22.26 24.04 25.73 27.53 29.46
Change

Cost of Goods sold 9.84 10.83 11.59 12.40 13.27

Indirect Costs 1.61 1.73 1.80 1.90 2.02
Interest, Depreciation 1.86 1.77 1.52 1.28 1.04

EBT 10.12 10.98 12.17 13.39 14.68

Updated EBT 8.95 9.71 10.82 11.95 13.13
Impact on EBT (1.17) (1.27) (1.35) (1.45) (1.55)

Page 37 of 50
 DPR of Khushi Mandap Decorators

III. INCREASE IN COGS BY 5% rupees in lakhs

PARTICULARS FY 2022 FY 2023 FY 2024 FY 2025 FY 2026

Projected revenue 23.43 25.31 27.08 28.98 31.01

Cost of Goods sold 9.84 10.83 11.59 12.40 13.27

% Change 5% 5% 5% 5% 5%
Increase 0.49 0.54 0.58 0.62 0.66
Updated COGS 10.33 11.37 12.17 13.02 13.93

Indirect Costs 1.61 1.73 1.80 1.90 2.02

Interest, Depreciation 1.86 1.77 1.52 1.28 1.04

EBT 10.12 10.98 12.17 13.39 14.68

Updated EBT 9.63 10.44 11.59 12.77 14.02
Impact on EBT (0.49) (0.54) (0.58) (0.62) (0.66)

Page 38 of 50
 DPR of Khushi Mandap Decorators

BREAK EVEN ANALYSIS

rupees in lakhs

Sr.
Particulars Weightage FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 FY 2026
No.

(A) Gross Revenue 19.86 23.43 25.31 27.08 28.98 31.01

(B) Variable Expenses

Purchases 100% 7.92 9.19 10.07 10.78 11.53 12.34

Direct Labour (Wages) 75% 0.38 0.49 0.57 0.61 0.65 0.70
Power & Fuel 65% 0.00 0.00 0.00 0.00 0.00 0.00
Other prime costs 60% 0.00 0.00 0.00 0.00 0.00 0.00
Difference in Stock 100% 0.00 0.00 0.00 0.00 0.00 0.00

Total Variable expenses 8.30 9.68 10.64 11.39 12.18 13.04

8.42
(C) Contribution (A - B) 11.57 13.76 14.67 15.69 16.79 17.97
Contribution (%) 58.23% 58.70% 57.95% 57.95% 57.95% 57.95%

(D) Fixed & Semi-fixed Expenses

Administration Costs 70% 0.00 0.08 0.09 0.09 0.10 0.10
Rent 100% 0.00 0.54 0.59 0.59 0.62 0.65
Insurance 100% 0.00 0.21 0.22 0.24 0.25 0.27
Property Taxes 100% 0.00 0.00 0.00 0.00 0.00 0.00
Other Fixed Costs 0.00 0.00 0.00 0.00 0.00 0.00

Total Fixed & Semi-fixed Expenses 0.00 0.83 0.90 0.92 0.97 1.02

(E) Operating profit (C - D) 11.57 12.92 13.76 14.78 15.83 16.95

(F) Break-even point 0.00% 6.06% 6.17% 5.85% 5.76% 5.66%

Page 39 of 50
 DPR of Khushi Mandap Decorators

SECURITY MARGIN

Sr.
PARTICULARS FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 FY 2026
No.

A WDV OF FIXED ASSETS 68.71 75.61 74.67 73.85 73.15 72.55

B AGGREGATE TL OUTSTANDINGS 18.93 3.17 2.02 0.73 0.00 0.00
C SECURITY MARGIN 49.78 72.44 72.65 73.12 73.15 72.55

PERCENTAGE OF MARGIN 72.45% 95.80% 97.30% 99.01% 100.00% 100.00%

Page 40 of 50
 DPR of Khushi Mandap Decorators

SUMMARY OF LOAN REPAYMENT SCHDULE

Interest Rate 10.50% p.a

Particulars FY 2022 FY 2023 FY 2024 FY 2025 FY 2026

Principal at the begining of the year 0.00 5.29 4.25 3.09 1.81
Add :- Disbursement 6.00 0.00 0.00 0.00 0.00
Add :- Interest 0.45 0.51 0.39 0.26 0.12
Less :- Repayment During the year 1.16 1.55 1.55 1.55 1.93

Principal at the end of the year 5.29 4.25 3.09 1.81 0.00

Page 41 of 50
 DPR of Khushi Mandap Decorators

Detailed working of Term Loan from Bank

rupees in lakhs

Month Opening Disburse- Monthly Monthly Closing

Balance ment Interest Installement Balance
REPAYMENT

Year I - Month 1
Month 2
Month 3
Month 4 - 6.00 0.05 0.13 5.92
Month 5 5.92 - 0.05 0.13 5.85
Month 6 5.85 - 0.05 0.13 5.77
Month 7 5.77 - 0.05 0.13 5.69
Month 8 5.69 - 0.05 0.13 5.61
Month 9 5.61 - 0.05 0.13 5.53
Month 10 5.53 - 0.05 0.13 5.45
Month 11 5.45 - 0.05 0.13 5.37
Month 12 5.37 - 0.05 0.13 5.29
6.00 0.45 1.16
Year II - Month 1 5.29 - 0.05 0.13 5.20
Month 2 5.20 - 0.05 0.13 5.12
Month 3 5.12 - 0.04 0.13 5.04
Month 4 5.04 - 0.04 0.13 4.95
Month 5 4.95 - 0.04 0.13 4.87
Month 6 4.87 - 0.04 0.13 4.78
Month 7 4.78 - 0.04 0.13 4.69
Month 8 4.69 - 0.04 0.13 4.61
Month 9 4.61 - 0.04 0.13 4.52
Month 10 4.52 - 0.04 0.13 4.43
Month 11 4.43 - 0.04 0.13 4.34
Month 12 4.34 - 0.04 0.13 4.25
0.51 1.55
Year III - Month 1 4.25 - 0.04 0.13 4.15
Month 2 4.15 - 0.04 0.13 4.06
Month 3 4.06 - 0.04 0.13 3.97
Month 4 3.97 - 0.03 0.13 3.87
Month 5 3.87 - 0.03 0.13 3.78
Month 6 3.78 - 0.03 0.13 3.68
Month 7 3.68 - 0.03 0.13 3.59
Month 8 3.59 - 0.03 0.13 3.49
Month 9 3.49 - 0.03 0.13 3.39
Month 10 3.39 - 0.03 0.13 3.29
Month 11 3.29 - 0.03 0.13 3.19
Month 12 3.19 - 0.03 0.13 3.09
0.39 1.55

Page 42 of 50
 DPR of Khushi Mandap Decorators

Year IV - Month 1 3.09 - 0.03 0.13 2.99

Month 2 2.99 - 0.03 0.13 2.88
Month 3 2.88 - 0.03 0.13 2.78
Month 4 2.78 - 0.02 0.13 2.68
Month 5 2.68 - 0.02 0.13 2.57
Month 6 2.57 - 0.02 0.13 2.46
Month 7 2.46 - 0.02 0.13 2.36
Month 8 2.36 - 0.02 0.13 2.25
Month 9 2.25 - 0.02 0.13 2.14
Month 10 2.14 - 0.02 0.13 2.03
Month 11 2.03 - 0.02 0.13 1.92
Month 12 1.92 - 0.02 0.13 1.81
0.26 1.55
Year V - Month 1 1.81 - 0.02 0.13 1.69
Month 2 1.69 - 0.01 0.13 1.58
Month 3 1.58 - 0.01 0.13 1.46
Month 4 1.46 - 0.01 0.13 1.35
Month 5 1.35 - 0.01 0.13 1.23
Month 6 1.23 - 0.01 0.13 1.11
Month 7 1.11 - 0.01 0.13 0.99
Month 8 0.99 - 0.01 0.13 0.87
Month 9 0.87 - 0.01 0.13 0.75
Month 10 0.75 - 0.01 0.13 0.63
Month 11 0.63 - 0.01 0.13 0.50
Month 12 0.50 - 0.00 0.51 (0.00)
0.12 1.93

Page 43 of 50
 DPR of Khushi Mandap Decorators

Credit Monitoring Arrangement (CMA)

rupees in lakhs

LIABILITIES FY 2022 FY 2023 FY 2024 FY 2025 FY 2026

Projected Projected Projected Projected Projected
Capital 77.93 84.62 92.05 100.63 109.87
Net Worth 77.93 84.62 92.05 100.63 109.87

Term Loans 3.17 2.02 0.73 0.00 0.00

Unsecured Loans 0.00 0.00 0.00 0.00 0.00
Other Term Liabilities 0.00 0.00 0.00 0.00 0.00
Total Term Liabilities 3.17 2.02 0.73 0.00 0.00

Sundry Creditors 0.00 0.00 0.00 0.00 0.00

Bank Borrowings-CC 3.00 3.00 3.00 3.00 3.00
Provision 0.00 0.00 0.00 0.00 0.00
Other Current Liabilities 0.00 0.00 0.00 0.00 0.00
other advances 16.09 13.68 11.63 9.88 8.40
Total Current Liabilities 19.09 16.68 14.63 12.88 11.40
Total Outside Liabilities 22.26 18.69 15.36 12.88 11.40

Total Liabilities 100.19 103.31 107.41 113.51 121.27

Page 44 of 50
 DPR of Khushi Mandap Decorators

ASSETS FY 2022 FY 2023 FY 2024 FY 2025 FY 2026

Projected Projected Projected Projected Projected
Fixed Assets 76.71 75.61 74.67 73.85 73.15
Depreciation 1.10 0.95 0.81 0.70 0.60
Net Block 75.61 74.67 73.85 73.15 72.55

Cash & Bank Balance 2.43 3.80 4.36 8.93 13.54

advances to suppliers 0.00 0.00 0.00 0.00 0.00
Othr current assets 15.80 18.12 18.84 19.65 20.56
stock 0.00 0.00 0.00 0.00 0.00
investments 0.00 0.00 0.00 0.00 0.00
Receivables 1.35 1.73 1.85 1.98 2.12

Total Current Assets 19.58 23.65 25.05 30.56 36.22

Investments 5.00 5.00 8.50 9.80 12.50

Other Non Current Assets 0.00 0.00 0.00 0.00 0.00
Total Non Current Assets 5.00 5.00 8.50 9.80 12.50

Accumulated Losses 0.00 0.00 0.00 0.00 0.00

Other Intangible Assets 0.00 0.00 0.00 0.00 0.00
Total Intangible Assets 0.00 0.00 0.00 0.00 0.00

Total Assets 100.19 103.31 107.41 113.51 121.27

control total 0.00 0.00 0.00 0.00 0.00

Page 45 of 50
 DPR of Khushi Mandap Decorators

WORKING CAPITAL CALCULATIONS

PARTICULARS FY 2022 FY 2023 FY 2024 FY 2025 FY 2026

Projected Projected Projected Projected Projected

Capital 77.93 84.62 92.05 100.63 109.87

Other Reserves
P/L Account
unsecured loans 0.00 0.00 0.00 0.00 0.00
Term Loans 3.17 2.02 0.73 0.00 0.00
Term Deposits 0.00 0.00 0.00 0.00 0.00
Other Term Liabilities 0.00 0.00 0.00 0.00 0.00
Long Term Sources 81.10 86.63 92.78 100.63 109.87

Net Fixed Assets 75.61 74.67 73.85 73.15 72.55

Investments 5.00 5.00 8.50 9.80 12.50
Other Non Current Assets 0.00 0.00 0.00 0.00 0.00
Adv to Suppliers of Cap Goods
Intangible Assets 0.00 0.00 0.00 0.00 0.00
Long Term Uses 80.61 79.67 82.35 82.95 85.05
Net Working Capital 0.49 6.97 10.43 17.68 24.82
CA-CL 0.49 6.97 10.43 17.68 24.82
control total 0.00 0.00 0.00 0.00 0.00
NWC as % to TCA 2.49 29.47 41.62 57.85 68.53

Page 46 of 50
 DPR of Khushi Mandap Decorators

KEY FINANCIAL INDICATORS

PARTICULARS FY 2022 FY 2023 FY 2024 FY 2025 FY 2026

Projected Projected Projected Projected Projected
Net Sales 23.43 25.31 27.08 28.98 31.01
% increase 18.00 8.00 7.00 7.00 7.00
Net Profit after Tax 9.10 9.78 10.74 12.13 13.03
% to Sales 38.81 38.66 39.65 41.85 42.02
Cash Accruals 10.20 10.73 11.55 12.82 13.63
TNW 77.93 84.62 92.05 100.63 109.87
TOL/TNW 0.29 0.22 0.17 0.13 0.10
NWC 0.49 6.97 10.43 17.68 24.82
Current Ratio 1.03 1.42 1.71 2.37 3.18
Net Sales 23.43 25.31 27.08 28.98 31.01
Net Profit 9.10 9.78 10.74 12.13 13.03
Depreciation 1.10 0.95 0.81 0.70 0.60

PARTICULARS FY 2022 FY 2023 FY 2024 FY 2025 FY 2026

Projected Projected Projected Projected Projected
Net Sales 23.43 25.31 27.08 28.98 31.01
Purchases 9.19 10.07 10.78 11.53 12.34
Sundry Creditors 0.00 0.00 0.00 0.00 0.00
CREDITORS NO. OF DAYS PURCHASES 0.00 0.00 0.00 0.00 0.00
Receivables 1.35 1.73 1.85 1.98 2.12
RECEIVABLES NO. OF DAYS SALES 21.00 25.00 25.00 25.00 25.00
Stock 0.00 0.00 0.00 0.00 0.00
STOCK NO. OF DAYS SALES 0.00 0.00 0.00 0.00 0.00

Page 47 of 50
 DPR of Khushi Mandap Decorators

Working Capital - Assessment

BASED ON TONDAN COMMITTEE - I

Method I (WCG) FY 2022 FY 2023 FY 2024 FY 2025 FY 2026
Projected Projected Projected Projected Projected
1. Total Current Assets 19.58 23.65 25.05 30.56 36.22
2. Other Current Liabilities 16.09 13.68 11.63 9.88 8.40
3. WCG 3.49 9.97 13.43 20.68 27.82
4. 25 % Margin 0.87 2.49 3.36 5.17 6.95
5. MPBF as per method I 2.62 7.48 10.07 15.51 20.86

BASED ON TONDAN COMMITTEE - II

Method II (TCA) FY 2022 FY 2023 FY 2024 FY 2025 FY 2026
Projected Projected Projected Projected Projected
1. Total Current Assets 19.58 23.65 25.05 30.56 36.22
2. Other Current Liabilities 16.09 13.68 11.63 9.88 8.40
3. WCG 3.49 9.97 13.43 20.68 27.82
4. 25 % Margin (TCA*25%) 4.89 5.91 6.26 7.64 9.05
5. MPBF as per method II -1.41 4.06 7.16 13.04 18.76

NAYAK COMMITTEE NORMS - TURNOVER METHOD

Turnover Method FY 2022 FY 2023 FY 2024 FY 2025 FY 2026

Projected Projected Projected Projected Projected
1. Actual / Projected Sales 23.43 25.31 27.08 28.98 31.01
2. WCG - 25 % of sales 5.86 6.33 6.77 7.24 7.75
3. 5 % of sales as margin 1.17 1.27 1.35 1.45 1.55
4. Minimum permissible finance 4.69 5.06 5.42 5.80 6.20
(20% of turnover)
5. Margin Money by Borrower 1.17 1.27 1.35 1.45 1.55
6. Actual/Projected NWC 0.49 6.97 10.43 17.68 24.82

Page 48 of 50
 DPR of Khushi Mandap Decorators

Particulars FY 2022 FY 2023 FY 2024 FY 2025 FY 2026

Projected Projected Projected Projected Projected
Stock 0.00 0.00 0.00 0.00 0.00
(Days cost of production) 0 0 0 0 0
Receivables 1.35 1.73 1.85 1.98 2.12
(Days sales) 21 25 25 25 25
Other Current assets 15.80 18.12 18.84 19.65 20.56
% to Total Current Assets 80.70 76.61 75.19 64.29 56.76
Loans and advances 0.00 0.00 0.00 0.00 0.00
holding period 0 0 0 0 0
Cash & bank balances 2.43 3.80 4.36 8.93 13.54
% to total Current Assets 12.41 16.05 17.40 29.22 37.37
Total Current Assets 19.58 23.65 25.05 30.56 36.22
Sundry Creditors 0.00 0.00 0.00 0.00 0.00
Days purchases 0 0 0 0 0
OCL – Provisions 0.00 0.00 0.00 0.00 0.00
% to TCL N.A. N.A. N.A. N.A. N.A.
Total Current Liabilities 0.00 0.00 0.00 0.00 0.00

Page 49 of 50
 DPR of Khushi Mandap Decorators

Notes to the Project Report

a. Depreciation is calculated as per the rate priscribed in the Income Tax Act and Seperate Depreciation schedule
has been attatched for calculation purpose.

b. Data such as Sensativity Analysis & Balance Sheet synopsis has been prepared based on the standard financial
assumptions and calculations.

c. It has been presumed that there will be no change in the Government policies & rules with respect to the
business of the loan applicant. Also, no abnormal events will take place during the life of the project / business,

d. Provision for Income Tax has been made on the Rules and Regulations which are applicable for current scenario.

e. Standard assumption of Year end at March has been presumed

f. Indirect Expenses, Break Even Analysis and Security margin calculation have been shown in the separate Annexures.

g. All the data related to revenue from business, asset addition, existing obligations, etc. have been provided
based on the information given by the client.

h. This Projected data is a future-oriented financial information prepared using assumptions to the best judgment
of applicants as to the most probable set of economic conditions and should not be treated as a forecast.

i. All the information related to business entity, owner's profile, employment along with the feasibility studies,
Industry analysis, market potential, current scenario and challenges-solutions is based on the discussions and
inputs from the loan applicant.

Page 50 of 50