1 PROJECT REPORT

OF
M/S HEAVEN GAME RESTRO
Prop. Tanaykumar Rushikesh Shelke.

H. No. 1-2-563, Canol Road, Behind Natyagruh Beed, Beed 431122.

PREPARED BY
S. P. AMTE & CO.

CHARTERED ACCOUNTANTS
2nd Floor Narayangad Sankul ,
Opposite Siddhivinayak Complex ,
D.P. Road Near Vaidyanath Urban
Co Op Bank Ltd . Beed - 431122

A Name of the Activity : Serving of Food / HOTEL & Gaming Activity.

B Project Cost :

(a) Capital Expenditure

Units Rs.

Hotel Building Construction (As Per Estimation ) 6778340

Interior Work (As Per Estimation ) 2006000
Gaming Machinery (As Per Estimation ) 2240820
Furniture & Fixture (As Per Quatation ) 608000
(including Glass work, Table, Chair , counter)
Hotel Utencils (As Per Quatation ) 462000
Electricity Fittings 252040
Water Tank 48285
Air Conditioner 228000
Kitchen Chimani 128500
Invetor Battary / Generatar 198000
Gardening Lown's Exp. 152300

Equipments : 208000
Gas Table, Kitchen Utensils, Pans, Chopping table,
Knifes, Chimney, Tables, Chairs, Crockery
Cots, Matters etc.

Total Capital Expenditure 13310285

(b) Working Capital (Recurring Cost - RM+Labour+ Maintance) 904000

TOTAL PROJECT COST : 14214285
OWN Funds - 30% 4264286
Bank Loan Required 9950000
Bank Loan 9950000 70% 14214285
( Annasaheb Patil Mahamandal )

Employment 12 1137142.8
 C Estimated Annual Revenue : (Projected Revenue )
Rs.
[Link]. Particulars Years
1 2 3 4 5
1 Serving of Food/Hospitality 9856000 11827200 14192640 17031168 20437402
2 Gaming Charges 1925000 2310000 2772000 3326400 3991680
0 0 0 0 0

TOTALTotal Projected Sales 11781000 14137200 16964640 20357568 24429082

D Estimated Annual Expenses

Rs.
[Link]. Particulars Years
1 2 3 4 5
1 Purchases of RM - Groserry /Vegitables + GST 3275200 3930240 4716288 5659546 6791455
2 Water Charges 285000 342000 410400 492480 590976
3 Wages (Skilled & Unskilled) : 1222500 1467000 1760400 2112480 2534976
4 Repairs & Maintance - . 138450 166140 199368 239242 287090
5 Administrative Expenses : 258350 310020 372024 446429 535715
6 Gas / Wood Charges 125500 150600 180720 216864 260237
7 Electricity Charges 235500 282600 339120 406944 488333
8 Hotel Rent 300000 315000 330750 347288 364652
9 Depreciation : 1331029 1197926 1078133 970320 873288
10 Insurance : - Workers 52000 62400 74880 89856 107827
11 Interest (As per Amortisation sch)
(a) Capital Expenditure Loan : 9,59,934 7,85,312 5,91,637 3,76,831 1,38,590
(b) Working Capital Loan : CC 0 0 0 0 0
Total Interest : 959934 785312 591637 376831 138590
Working Capital Requirement
Fixed Cost : 1993734 1980872 1979059 1992125 2024850
Variable Cost : 4858700 5830440 6996528 8395834 10075000
E Estimated Cost/ Benifit Analysis
Rs.
Sr. No Particulars Years
1 2 3 4 5
1 Fixed Cost 1993734 1980872 1979059 1992125 2024850
2 Variable Cost 4858700 5830440 6996528 8395834 10075000
3 Cost of Production (1+2) 6852434 7811312 8975587 10387959 12099850
4 Projected Sales 11781000 14137200 16964640 20357568 24429082
5 Gross Surplus (4-3) 4928566 6325888 7989053 9969609 12329232
6 Depreciation 1331029 1197926 1078133 970320 873288
7 Expected Net Surplus 3597537 5127963 6910920 8999289 11455944
8 Taxes 810431 1416715 2028627 2745354 3751592
9 Net Surplus After Tax 2787106 3711248 4882293 6253935 7704352
10 Contribution (Sales - Variable Cost) 6922300 8306760 9968112 11961734 14354081
11 BEP - Break Even Point Fixed Exp/ P.V. Ratio 3393119 3371227 3368142 3390380 3446073
12 Gross Operating Surplus ( PBIT) 5888500 7111200 8580690 10346441 12467822
 F Projected Balance Sheet
[Link]. Particulars Years
1 2 3 4 5
1 Capital 4320181 19409929 26110650 34852439 45999683
Capital Introduced / Drawings 10146286 -184500 -210200 -257500 -308700

2 Loans
CC
Term Loan 83,49,473 65,74,324 46,05,500 24,21,870 0.00
Increase in Liability 0.00 7,000 25,000 1,35,000 3,30,000
Total 22815940 25806753 30530949 37151809 46020983

1 Fixed Assets 11979257 10781331 9703198 8732878 7859590

2 Cash & Bank Balance 25550 30660 36792 44150 52980

3 FD with Bank 252000 252000 252000 252000 252000

4 Current Assets 10559133 14742762 20538960 28122781 37856412

Total 22815940 25806753 30530950 37151809 46020983
0 0 0 0 0
G Calculation of Ratios

Sr. No Particulars Combined Ratio -

Years
Entire Project
1 2 3 4 5

1 N. P Ratio 39.73 30.54 36.27 40.74 44.21 46.89

2 N. P Ratio After Tax 28.19 23.66 26.25 28.78 30.72 31.54
3 DSCR 3.24 1.92 2.47 3.12 3.89 4.82
4 Current Ratio 26.97 1.30 2.28 4.50 11.11 115.64
5 I.R.R. (%) 21.17 13.23 16.85 21.05 25.42 29.28
6 P. V. Ratio Contribution/Sales 58.76 58.76 58.76 58.76 58.76 58.76

H Repayment schedule
Rs.
Total
Loan Surplus after
Year Outstanding
Surplus after Tax Interest Principal Repayment
Interest & Tax
Incl. CC Int.

1 8349473 2787106 959934 1600526 2560461 226645

2 6574324 3711248 785312 1775149 2560461 1150787
3 4605500 4882293 591637 1968824 2560461 2321832
4 2421870 6253935 376831 2183629 2560461 3693475
5 0 7704352 138590 2421870 2560460 5143891

Assumptions
1 Interest on Term Loan is Assumed @ 10.40 % p.a.
2 Estimated Revenue /Expenses will increase 20% every year
3 Income Tax Rate is assumed to be A/P I Tax Slabs
4 No Opening / Closing Stock of Raw Material in process as it is Assumed that All Material in process is Consumed .
5 Administrative Overheads include administrative and office expenses such as staff traveling, office
Stationery and postage, telephone bills, audit fee, legal fee, bank charges and other sundry expenses
 [Link]
1
Loan Amortization Schedule

Inputs

Loan Amount Rs 99,50,000 Rate (per period) 0.867%

Annual Interest Rate 10.40% Payment (per period) Rs2,13,371.73
Term of Loan in Years 5
First Payment Date 01-07-2024 Total Payments Rs1,28,02,303.53
Frequency of Payment Monthly Total Interest Rs28,52,304.03
Interest Savings Rs0.07
Summary

Payment Additional
No. Due Date Due Payment Interest Principal Balance interest repayment
Rs99,49,999.50
1 01-07-2024 2,13,371.73 0.00 86,233.33 1,27,138.40 98,22,861.10
2 01-08-2024 2,13,371.73 0.00 85,131.46 1,28,240.27 96,94,620.83
3 01-09-2024 2,13,371.73 0.00 84,020.05 1,29,351.68 95,65,269.15
4 01-10-2024 2,13,371.73 0.00 82,899.00 1,30,472.73 94,34,796.42
5 01-11-2024 2,13,371.73 0.00 81,768.24 1,31,603.49 93,03,192.93
6 01-12-2024 2,13,371.73 0.00 80,627.67 1,32,744.06 91,70,448.87
7 01-01-2025 2,13,371.73 0.00 79,477.22 1,33,894.51 90,36,554.36
8 01-02-2025 2,13,371.73 0.00 78,316.80 1,35,054.93 89,01,499.43
9 01-03-2025 2,13,371.73 0.00 77,146.33 1,36,225.40 87,65,274.03
10 01-04-2025 2,13,371.73 0.00 75,965.71 1,37,406.02 86,27,868.01 interest repayment total cl bal
11 01-05-2025 2,13,371.73 0.00 74,774.86 1,38,596.87 84,89,271.14
12 01-06-2025 2,13,371.73 0.00 73,573.68 1,39,798.05 83,49,473.09 9,59,934.35 16,00,526.41 25,60,460.76 83,49,473.09
13 01-07-2025 2,13,371.73 0.00 72,362.10 1,41,009.63 82,08,463.46 9.60 16.01 25.60 83.49
14 01-08-2025 2,13,371.73 0.00 71,140.02 1,42,231.71 80,66,231.75
15 01-09-2025 2,13,371.73 0.00 69,907.34 1,43,464.39 79,22,767.36
16 01-10-2025 2,13,371.73 0.00 68,663.98 1,44,707.75 77,78,059.61
17 01-11-2025 2,13,371.73 0.00 67,409.85 1,45,961.88 76,32,097.73
18 01-12-2025 2,13,371.73 0.00 66,144.85 1,47,226.88 74,84,870.85
19 01-01-2026 2,13,371.73 0.00 64,868.88 1,48,502.85 73,36,368.00
20 01-02-2026 2,13,371.73 0.00 63,581.86 1,49,789.87 71,86,578.13
21 01-03-2026 2,13,371.73 0.00 62,283.68 1,51,088.05 70,35,490.08
22 01-04-2026 2,13,371.73 0.00 60,974.25 1,52,397.48 68,83,092.60
23 01-05-2026 2,13,371.73 0.00 59,653.47 1,53,718.26 67,29,374.34
24 01-06-2026 2,13,371.73 0.00 58,321.24 1,55,050.49 65,74,323.85 7,85,311.52 17,75,149.24 25,60,460.76 65,74,323.85
25 01-07-2026 2,13,371.73 0.00 56,977.47 1,56,394.26 64,17,929.59 7.85 17.75 25.60 65.74
26 01-08-2026 2,13,371.73 0.00 55,622.06 1,57,749.67 62,60,179.92
27 01-09-2026 2,13,371.73 0.00 54,254.89 1,59,116.84 61,01,063.08
28 01-10-2026 2,13,371.73 0.00 52,875.88 1,60,495.85 59,40,567.23
29 01-11-2026 2,13,371.73 0.00 51,484.92 1,61,886.81 57,78,680.42
30 01-12-2026 2,13,371.73 0.00 50,081.90 1,63,289.83 56,15,390.59
31 01-01-2027 2,13,371.73 0.00 48,666.72 1,64,705.01 54,50,685.58
32 01-02-2027 2,13,371.73 0.00 47,239.28 1,66,132.45 52,84,553.13
33 01-03-2027 2,13,371.73 0.00 45,799.46 1,67,572.27 51,16,980.86
34 01-04-2027 2,13,371.73 0.00 44,347.17 1,69,024.56 49,47,956.30
35 01-05-2027 2,13,371.73 0.00 42,882.29 1,70,489.44 47,77,466.86
36 01-06-2027 2,13,371.73 0.00 41,404.71 1,71,967.02 46,05,499.84 5,91,636.75 19,68,824.01 25,60,460.76 46,05,499.84
37 01-07-2027 2,13,371.73 0.00 39,914.33 1,73,457.40 44,32,042.44 5.92 19.69 25.60 46.05
38 01-08-2027 2,13,371.73 0.00 38,411.03 1,74,960.70 42,57,081.74
39 01-09-2027 2,13,371.73 0.00 36,894.71 1,76,477.02 40,80,604.72
40 01-10-2027 2,13,371.73 0.00 35,365.24 1,78,006.49 39,02,598.23
41 01-11-2027 2,13,371.73 0.00 33,822.52 1,79,549.21 37,23,049.02
42 01-12-2027 2,13,371.73 0.00 32,266.42 1,81,105.31 35,41,943.71
43 01-01-2028 2,13,371.73 0.00 30,696.85 1,82,674.88 33,59,268.83
44 01-02-2028 2,13,371.73 0.00 29,113.66 1,84,258.07 31,75,010.76
45 01-03-2028 2,13,371.73 0.00 27,516.76 1,85,854.97 29,89,155.79
46 01-04-2028 2,13,371.73 0.00 25,906.02 1,87,465.71 28,01,690.08
47 01-05-2028 2,13,371.73 0.00 24,281.31 1,89,090.42 26,12,599.66
48 01-06-2028 2,13,371.73 0.00 22,642.53 1,90,729.20 24,21,870.46 3,76,831.38 21,83,629.38 25,60,460.76 24,21,870.46
49 01-07-2028 2,13,371.73 0.00 20,989.54 1,92,382.19 22,29,488.27 3.77 21.84 25.60 24.22
50 01-08-2028 2,13,371.73 0.00 19,322.23 1,94,049.50 20,35,438.77
51 01-09-2028 2,13,371.73 0.00 17,640.47 1,95,731.26 18,39,707.51
52 01-10-2028 2,13,371.73 0.00 15,944.13 1,97,427.60 16,42,279.91
53 01-11-2028 2,13,371.73 0.00 14,233.09 1,99,138.64 14,43,141.27
54 01-12-2028 2,13,371.73 0.00 12,507.22 2,00,864.51 12,42,276.76
55 01-01-2029 2,13,371.73 0.00 10,766.40 2,02,605.33 10,39,671.43
56 01-02-2029 2,13,371.73 0.00 9,010.49 2,04,361.24 8,35,310.19
57 01-03-2029 2,13,371.73 0.00 7,239.35 2,06,132.38 6,29,177.81
58 01-04-2029 2,13,371.73 0.00 5,452.87 2,07,918.86 4,21,258.95
59 01-05-2029 2,13,371.73 0.00 3,650.91 2,09,720.82 2,11,538.13
60 01-06-2029 2,13,371.46 0.00 1,833.33 2,11,538.13 0.00 1,38,590.03 24,21,870.46 25,60,460.49 0.00
1.39 24.22 25.60 0.00

0.00