PROJECT REPORT
Dabba
Address
Introduction
Project report for Restaurant is as follows
The food industry in India has been booming in the recent times, owing to the rising disposable income of the middle class. The Indian restaurant market was valued at Rs 20,400 crore in 2016 and is expected to grow to Rs 51,000 crore by 2021, according to industry body National Restaurant Association of India (NRAI). Quick service restaurants (QSR) like Pizza Hut, Burger King, Goli Wada Pav, Burger Singh, etc have been growing exponentially in the recent times.More Indians are slowly warming up to the idea of eating in restaurants, and not just for special occasions. Thanks to growing wages, urbanization and technology’s influence on consumption habits, foodservice sales in this country of USD 1.3 billion are growing at about 10% annually (making it one of the fastest-growing in the world). This growth is double the rate expected for the much more mature U.S. restaurant industry, and with a population quadruple the size. All told, between 2013 and 2021, the Indian restaurant market is projected to double. Many separate forces are at work in creating huge potential for restaurants in India. Its economy is among the fastest growing in the developing world; the International Monetary Fund projects the country’s annual GDP will increase by 7.4% through 2017 and 2018 — more than double the world average.
Product / Services & process
We offer all type of North Indian, South Indian cusines, Veg - No veg items ,Tea, snacks , coffee, juices and icecreams.
Market potential & Strategy
India is also one of the largest consumer markets globally, and one of the youngest with more than 45% of the population under 25 years old. For teens and young adults, eating out is a popular form of socializing, contributing to the growth of multiple segments within the expanding market. Disposable income is on the rise; the educated middle class is growing; and as the country grows more industrialized and cements its reputation as an IT hub, per capita income stands to grow as well. According to data from the Economist Intelligence Unit, personal disposable income should grow about 10.5% annually through 2020. India’s traditional close-knit extended families are less common; as younger family members move away for education and jobs, they are setting up smaller households, making dining out more attractive. More women are joining the workforce as well, especially in urban areas, leaving less time for home cooking and creating more demand for dining out/takeout options. We’ve seen similar spending trends in the U.S. though it’s worth noting that this will occur on an accelerated time frame in India (as Western systems have already been developed, they now only need to be implemented in other parts of the world, like India).
Project at a glance
Name & Address of Unit
Restaurant
Address
Details of unit
Email
|
: |
[email protected]
|
Phone
|
: |
000000
|
Constitution
|
: |
Proprietership
|
Total project cost
|
: |
*******
|
Fixed Capital
|
: |
*******
|
Working Capital
|
: |
*******
|
Total Bank loan
|
: |
*******
|
Promoter(s) contribution
|
: |
*******
|
Term loan
|
: |
*******
|
Working capital loan
|
: |
*******
|
Name & address of promoter(s)
Name |
| : Your name |
|
Address |
| : Address |
|
Phone |
| : 000000 |
|
Designation |
| : Proprietor |
|
E-mail |
| : [email protected] |
|
|
Project Feasibility Ratio
Debt Service Coverage Ratio (Average) |
:1.87 |
Current ratio (Average) |
:2.63 |
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
Current ratio |
1.53 |
2.06 |
2.62 |
3.19 |
3.76 |
Quick ratio |
1.13 |
1.56 |
2.10 |
2.64 |
3.18 |
Interest coverage ratio |
3.87 |
5.55 |
7.00 |
9.48 |
14.71 |
Debt equity ratio |
2.863 |
2.080 |
1.528 |
1.020 |
0.542 |
TOL/TNW |
3.02 |
1.45 |
0.79 |
0.43 |
0.21 |
DSCR |
1.65 |
1.86 |
1.90 |
1.94 |
1.97 |
Gross profit Sales Percentage % |
29.23 % |
28.54 % |
28.18 % |
27.86 % |
27.50 % |
Net profit Sales Percentage % |
10.84 % |
10.56 % |
11.10 % |
11.57 % |
11.90 % |
BEP in % of installed capacity % |
49.90 % |
27.12 % |
27.12 % |
27.12 % |
27.12 % |
BEP in sales of Rs |
2,620,800.00 |
1,840,695.65 |
1,972,173.91 |
2,103,652.17 |
2,235,130.43 |
Return On Capital Employed |
0.26 |
0.34 |
0.34 |
0.33 |
0.33 |
Project Feasibility graph
Revenue v/s Expense
|
Expense Splitup
|
|
|
  |
Revenue |
  |
Expense |
|
|
|
Net profit Sales %
|
Quick ratio
|
|
|
|
|
|
Project Cost
Sl. no |
Item |
Amount Rs |
1 |
Building Advance |
******* |
2 |
Computer & printer |
******* |
3 |
Serving dishes |
******* |
4 |
Utensils |
******* |
5 |
Electrification |
******* |
6 |
Preliminary expenses |
******* |
7 |
Display board |
******* |
8 |
Working Capital |
******* |
|
Total |
******* |
Working Capital Computation
Sl. no |
Item |
Amount Rs |
1 |
Consumables / stock in hand |
******* |
2 |
Work in progress |
******* |
3 |
Finished goods |
******* |
4 |
Working expense. |
******* |
5 |
Receivables/Sundry debtors |
******* |
6 |
Payables |
******* |
7 |
Total working capital |
******* |
8 |
Own Contribution |
******* |
9 |
Working capital loan |
******* |
Annual Sales / Revenue
Sl. no |
Item |
Rate |
|
Quantity |
Unit |
Total Rs |
1 |
Revenue from Sales |
******* |
X |
360 |
Day |
******* |
|
Total |
******* |
Total Yearly Expense
Sl. no |
Item |
Amount Rs |
1 |
Rent |
******* |
2 |
Salary |
******* |
3 |
Repairs & Maintanance |
******* |
4 |
Electricity |
******* |
5 |
Raw material purchase |
******* |
6 |
Wages |
******* |
7 |
Marketing/Advertisement |
******* |
|
Total |
******* |
Application of Fund
Sl. no |
Item
| Subsidy % |
No.
| Rate
| Amount Rs |
1 |
Building Advance |
******* |
1 |
******* |
******* |
2 |
Computer & printer |
******* |
1 |
******* |
******* |
3 |
Serving dishes |
******* |
1 |
******* |
******* |
4 |
Utensils |
******* |
1 |
******* |
******* |
5 |
Electrification |
******* |
1 |
******* |
******* |
6 |
Preliminary expenses |
******* |
1 |
******* |
******* |
7 |
Display board |
******* |
1 |
******* |
******* |
|
Total Investment |
******* |
|
Total Subsidy |
******* |
|
Net Investment |
******* |
Means of Finance
Sl. no |
Item
| Amount |
1 |
Term Loan |
******* |
2 |
Working capital Loan |
******* |
3 |
Total loan |
******* |
4 |
Term Loan contribution |
******* |
5 |
Working capital contribution |
******* |
Profitability Statement
|
|
Year 1(!*) |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
Revenue from operation |
|
|
|
|
|
|
Sales |
15.93 |
***** |
***** |
***** |
***** |
***** |
Add : |
|
|
|
|
|
|
Closing stock |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Total |
|
***** |
***** |
***** |
***** |
***** |
Less : |
|
|
|
|
|
|
Opening stock |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Stock purchase |
7.20 |
***** |
***** |
***** |
***** |
***** |
Salary |
3.60 |
***** |
***** |
***** |
***** |
***** |
Repairs and maintenance charges |
0.24 |
***** |
***** |
***** |
***** |
***** |
gas |
0.12 |
***** |
***** |
***** |
***** |
***** |
ELECTRICITY bill |
0.12 |
***** |
***** |
***** |
***** |
***** |
Total |
|
***** |
***** |
***** |
***** |
***** |
Gross profit |
|
***** |
***** |
***** |
***** |
***** |
Less : |
|
|
|
|
|
|
Rent |
0.12 |
***** |
***** |
***** |
***** |
***** |
Telephone/Postal &internet charge |
0.12 |
***** |
***** |
***** |
***** |
***** |
Total |
|
***** |
0***** |
***** |
***** |
***** |
Depreciation |
|
***** |
***** |
***** |
***** |
***** |
Interest on TL |
|
***** |
***** |
***** |
***** |
***** |
Interest on WC |
|
***** |
***** |
***** |
***** |
***** |
Total |
|
***** |
***** |
***** |
***** |
***** |
Profit before tax |
|
***** |
***** |
***** |
***** |
***** |
Income Tax |
|
***** |
***** |
***** |
***** |
***** |
Profit after tax |
|
***** |
***** |
***** |
***** |
***** |
Cash flow statement
Cash Inflow |
Pre operative period |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
Capital |
0.63 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Subsidy |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Termloan |
***** |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Profit before tax with interest |
0.00 |
***** |
***** |
***** |
***** |
***** |
Increase in WC loan |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Depreciation |
0.00 |
***** |
***** |
***** |
***** |
***** |
Increase in Current liability |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Total Cash Inflow |
***** |
***** |
***** |
***** |
***** |
***** |
Cash Outflow |
|
|
|
|
|
|
Fixed Assets |
***** |
***** |
***** |
***** |
***** |
***** |
Increase in Current asset |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Interest on TL |
0.00 |
***** |
***** |
***** |
***** |
***** |
Interest on WC |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Income Tax |
0.00 |
***** |
***** |
***** |
***** |
***** |
Decrease in Term loan |
|
***** |
***** |
***** |
***** |
***** |
Drawing |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Total Cash Outflow |
***** |
***** |
***** |
***** |
***** |
***** |
Opening balance |
***** |
***** |
***** |
***** |
***** |
***** |
Net Cashflow |
0.00 |
***** |
***** |
***** |
***** |
***** |
Closing balance |
0.00 |
***** |
***** |
***** |
***** |
***** |
Balance sheet
Liability |
Pre operative period |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
A. Share holders funds |
|
|
|
|
|
|
Capital |
***** |
***** |
***** |
***** |
***** |
***** |
Reserve & Surplus |
0.00 |
***** |
***** |
***** |
***** |
***** |
B.Non current Liabilities |
|
|
|
|
|
|
Termloan |
***** |
***** |
***** |
***** |
***** |
***** |
C.Current Liabilities |
|
|
|
|
|
|
Working capital loan |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Account payable |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Total Liability |
***** |
***** |
***** |
***** |
***** |
***** |
Asset |
|
|
|
|
|
|
A. Non current Assets |
|
|
|
|
|
|
Fixed Assets |
***** |
***** |
***** |
***** |
***** |
***** |
B. Current Assets |
|
|
|
|
|
|
Inventory |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Trade receivables |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Cash and cash equivalence |
***** |
***** |
***** |
***** |
***** |
***** |
Total Asset |
***** |
***** |
***** |
***** |
***** |
***** |
Repayment of Term loan
Year |
Installment |
Outstanding at the beginning |
Principal repayment |
Interest |
Amount paid |
Outstanding at the end |
1 |
1 |
***** |
***** |
***** |
***** |
***** |
1 |
2 |
***** |
***** |
***** |
***** |
***** |
1 |
3 |
***** |
***** |
***** |
***** |
***** |
1 |
4 |
***** |
***** |
***** |
***** |
***** |
1 |
5 |
***** |
***** |
***** |
***** |
***** |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
5 |
56 |
***** |
***** |
***** |
***** |
***** |
5 |
57 |
***** |
***** |
***** |
***** |
***** |
5 |
58 |
***** |
***** |
***** |
***** |
***** |
5 |
59 |
***** |
***** |
***** |
***** |
***** |
5 |
60 |
***** |
***** |
***** |
***** |
***** |
Debt Service Coverage Ratio
Particulars |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
Receipts |
|
|
|
|
|
a).Net Profit |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
b).Depreciation |
0.00 |
0.00 |
0.00 |
0.00 |
0.30 |
c).Interest on termloan |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Total |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Repayments |
|
|
|
|
|
a).Loan Principal |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
b).Interest on termloan |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Total |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
DSCR |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Depreciation
Particulars |
Rate |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
Building |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Less Depreciation |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Written down value |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Computers/ Printers /Photocopier/Electronic gadget |
00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Less Depreciation |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Written down value |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Furniture & fixtures |
00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Less Depreciation |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Written down value |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Racks & storage/Interior works |
00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Less Depreciation |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Written down value |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
new item |
00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Less Depreciation |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Written down value |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
new |
00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Less Depreciation |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Written down value |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Air-conditioning |
00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Less Depreciation |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Written down value |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Other investments |
00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Less Depreciation |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Written down value |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Total less depreciation |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Total written down value |
|
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Conclusion
The project as a whole describes the scope and viability of the Trading industry and mainly of the financial, technical and its market potential.The project guarantee sufficient fund to repay the loan and also give a good return on capital investment. When analyzing the social- economic impact, this project is able to generate an employment of 5 and above. It will cater the demand of Trading and thus helps the other business entities to increase the production and service which provide service and support to this industry. Thus more cyclic employment and livelihood generation. So in all ways, we can conclude the project is technically and socially viable and commercially sound too.