0% found this document useful (0 votes)
19 views20 pages

2022 Project Report for Staffing Buzz

The project report for Staffing Buzz Pvt Ltd outlines a logistics venture with a total project cost of ₹95 crores, employing 1000 individuals. The financial breakdown includes fixed capital of ₹51.4 crores and working capital of ₹43.6 crores, with a total bank loan of ₹90 crores. Key financial ratios indicate a healthy debt service coverage ratio of 2.47 and projected profitability growth over the next five years.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
19 views20 pages

2022 Project Report for Staffing Buzz

The project report for Staffing Buzz Pvt Ltd outlines a logistics venture with a total project cost of ₹95 crores, employing 1000 individuals. The financial breakdown includes fixed capital of ₹51.4 crores and working capital of ₹43.6 crores, with a total bank loan of ₹90 crores. Key financial ratios indicate a healthy debt service coverage ratio of 2.47 and projected profitability growth over the next five years.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

2022

PROJECT
REPORT

Staffing Buzz Pvt Ltd


0, South Station Road, Agarpara, Kolkata North 24
Parganas, West Bengal ,743177
Project at a glance
Name & Address of Unit

Staffing Buzz Pvt Ltd


0, South Station Road, Agarpara, Kolkata North 24 Parganas,743177

Activity : Logistics

Email : Santosh@[Link]

Phone : 9123313202

Constitution : Private LTD

Scheme : sme

Number of employment : 1000

Total project cost : 95,00,00,000.00

Fixed Capital : 51,40,00,000.00

Working Capital : 43,60,00,000.00

Total Bank loan : 90,00,00,000.00

Promoter(s) contribution : 5,00,00,000.00

Term loan : 51,00,00,000.00 Interest : 10.00 %

Working capital loan : 39,00,00,000.00 Interest : 10.00 %


Name & address of promoter(s)

Name : Santosh Singh

Address: 0, South Station Road Agarpara Kolkata North 24 Parganas

Phone: 9123313202

Date of birth: 01-06-1990

Designation: Founder

Category: General

E-mail: santosh@[Link]
Project Feasibility Ratio
Debt Service Coverage Ratio (Average) :2.47

Current ratio (Average) :1.53

Year 1 Year 2 Year 3 Year 4 Year 5


Current ratio 1.15 1.22 1.39 1.70 2.17

Quick ratio 1.04 1.10 1.27 1.57 2.04

Interest coverage ratio 3.63 3.34 5.39 9.06 15.86

Debt equity ratio 6.65 3.25 1.54 0.73 0.35

TOL/TNW 8.94 4.62 2.36 1.25 0.68

DSCR 1.71 1.44 2.03 2.93 4.21

Gross profit Sales Percentage % 28.93 % 27.35 % 28.32 % 29.60 % 31.17 %

Net profit Sales Percentage % 2.48 % 1.78 % 2.97 % 4.39 % 6.05 %

Return On Capital Employed 0.19 0.25 0.40 0.50 0.55

Net profit Sales % Quick ratio


Project Feasibility graph
Revenue v/s Expense

Expense Splitup
Project Cost
Sl. no Item Amount Rs.
1 Construction of the Building 20,00,00,000.00

2 Land 10,00,00,000.00

3 Machinery 15,00,00,000.00

4 Printer 10,00,000.00

5 Computer 2,00,00,000.00

6 Interior 1,00,00,000.00

7 Cooler 2,00,00,000.00

8 Electrification 90,00,000.00

9 Generator 40,00,000.00

10 Working Capital 43,60,00,000.00

Total 95,00,00,000.00
Working Capital Computation
Sl. no Item Amount Rs.
1 Consumables / stock in hand 7,50,00,000.00

2 Working expense. 21,01,00,000.00

3 Receivables/Sundry debtors 44,38,75,000.00

4 Payables 29,29,75,000.00

5 Total working capital 43,60,00,000.00

6 Own Contribution 4,60,00,000.00

7 Working capital loan 39,00,00,000.00


Annual Sales / Revenue
Sales is calculated from September 2022

Sl. no Item Sales Details Total Rs.


1 Revenue from Sales Rs. 451000000 x 7 month 3,15,70,00,000.00

Total 3,15,70,00,000.00
Total Yearly Expense
Expense is calculated from September 2022 .

Sl. no Item Amount Rs.


1 Rent 19,60,000.00

2 Salary 21,00,00,000.00

3 Water Bill 1,40,000.00

4 Electricity Bill 84,00,000.00

5 Transportation 35,00,00,000.00

6 Advertisement 7,00,000.00

7 Insurance 2,45,00,000.00

8 Purchase of Raw Materials 2,10,00,00,000.00

9 Other Expenses 35,00,00,000.00

Total 3,04,57,00,000.00
Application of Fund
Sl. no Item Subsidy % No. Rate Amount Rs.
1 Construction of the Building 1 20,00,00,000.00 20,00,00,000.00

2 Land 1 10,00,00,000.00 10,00,00,000.00

3 Machinery 1 15,00,00,000.00 15,00,00,000.00

4 Printer 1 10,00,000.00 10,00,000.00

5 Computer 1 2,00,00,000.00 2,00,00,000.00

6 Interior 1 1,00,00,000.00 1,00,00,000.00

7 Cooler 1 2,00,00,000.00 2,00,00,000.00

8 Electrification 1 90,00,000.00 90,00,000.00

9 Generator 1 40,00,000.00 40,00,000.00

Total Investment 51,40,00,000.00

Total Subsidy 0.00

Net Investment 51,40,00,000.00


Means of Finance
Sl. no Item Amount
1 Term Loan 51,00,00,000.00

2 Working capital Loan 39,00,00,000.00

3 Total loan 90,00,00,000.00

4 Promoters contribution on term loan 40,00,000.00

5 Promoters contribution on working capital loan 4,60,00,000.00


Profitability Statement
All figures are in lakhs
31/03/23 31/03/24 31/03/25 31/03/26 31/03/27
Revenue from operation

Revenue from Sales 31,570.00 60,073.20 66,981.62 75,019.41 84,396.84

Add :

Closing stock 750.00 825.00 907.50 998.25 1,098.08

Total 32,320.00 60,898.20 67,889.12 76,017.66 85,494.91

Less :

Opening stock 0 750.00 825.00 907.50 998.25

Purchase of Raw Materials 21,000.00 39,600.00 43,560.00 47,916.00 52,707.60

Salary 2,100.00 3,960.00 4,356.00 4,791.60 5,270.76

Water Bill 1.40 2.64 2.90 3.19 3.51

Electricity Bill 84.00 158.40 174.24 191.66 210.83

Total 23,185.40 44,471.04 48,918.14 53,809.96 59,190.95

Gross profit 9,134.60 16,427.16 18,970.97 22,207.70 26,303.96

Less :

Rent 19.60 36.96 40.66 44.72 49.19

Transportation 3,500.00 6,600.00 7,260.00 7,986.00 8,784.60

Advertisement 7.00 13.20 14.52 15.97 17.57

Insurance 245.00 462.00 508.20 559.02 614.92

Other Expenses 3,500.00 6,600.00 7,260.00 7,986.00 8,784.60

Total 7,271.60 13,712.16 15,083.38 16,591.71 18,250.88

Profit before interest, tax and depreciation1,863.00 2,715.00 3,887.60 5,615.99 8,053.07

Depreciation 233.04 371.63 327.62 289.52 256.50

Interest on TL 285.81 423.25 331.41 229.96 117.87

Interest on WC 227.50 390.00 390.00 390.00 390.00

Profit before tax 1,116.65 1,530.12 2,838.57 4,706.51 7,288.70

Income Tax 334.99 459.03 851.57 1,411.95 2,186.61

Profit after tax 781.65 1,071.08 1,987.00 3,294.56 5,102.09


Cash flow statement
All figures are in lakhs
Cash Inflow Pre operative period 31/03/23 31/03/24 31/03/25 31/03/26 31/03/27
Capital 40.00 460.00 0 0 0 0
Subsidy 0 0 0 0 0 0
Termloan 5,100.00 0 0 0 0 0
Profit before tax with interest 0 1,629.96 2,343.37 3,559.98 5,326.47 7,796.58
Increase in WC loan 0 3,900.00 0 0 0 0
Depreciation 0 233.04 371.63 327.62 289.52 256.50
Increase in Current liability 0 2,929.75 292.98 322.27 354.50 389.95
Total Cash Inflow 5,140.00 9,152.75 3,007.97 4,209.87 5,970.49 8,443.02

Cash Outflow
Fixed Assets 5,140.00 0 0 0 0 0
Increase in Current asset 5,188.75 518.88 570.76 627.84 690.62
Interest on TL 0 285.81 423.25 331.41 229.96 117.87
Interest on WC 0 227.50 390.00 390.00 390.00 390.00
Income Tax 0 334.99 459.03 851.57 1,411.95 2,186.61
Decrease in Term loan 472.71 877.07 968.91 1,070.36 1,182.44
Divident on equity 0 0 0 0 0 0
Total Cash Outflow 5,140.00 6,509.76 2,668.23 3,112.65 3,730.11 4,567.55
Opening balance 0 0 2,642.99 2,982.73 4,079.95 6,320.33
Net Cashflow 0 2,642.99 339.75 1,097.22 2,240.38 3,875.47
Closing balance 0 2,642.99 2,982.73 4,079.95 6,320.33 10,195.80
Balance sheet
All figures are in lakhs
Liability Pre operative period As of 31/03/23 31/03/24 31/03/25 31/03/26 31/03/27
A. Share holders funds

Capital 40.00 500.00 500.00 500.00 500.00 500.00

Reserve & Surplus 0 781.65 1,852.73 3,839.73 7,134.29 12,236.38

[Link] current Liabilities

Termloan 5,100.00 4,627.29 3,750.23 2,781.32 1,710.96 528.51

[Link] Liabilities

Working capital loan 0 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00

Account payable 2,929.75 3,222.72 3,545.00 3,899.50 4,289.45

Total Liability 5,140.00 12,738.70 13,225.69 14,566.05 17,144.74 21,454.34


Asset

A. Non current Assets

Fixed Assets 5,140.00 4,906.96 4,535.33 4,207.71 3,918.19 3,661.69

B. Current Assets

Inventory 0 750.00 825.00 907.50 998.25 1,098.08

Trade receivables 0 4,438.75 4,882.62 5,370.89 5,907.98 6,498.77

Cash and cash equivalence 0 2,642.99 2,982.73 4,079.95 6,320.33 10,195.80

Total Asset 5,140.00 12,738.70 13,225.69 14,566.05 17,144.74 21,454.34


Repayment of Term loan
All figures are in lakhs
Year Month Installment Outstanding at the beginning Principal repayment Interest Amount paid Outstanding at the end
1 Sep 2022 1 5,100.00 65.86 42.50 108.36 5,034.14

1 Oct 2022 2 5,034.14 66.41 41.95 108.36 4,967.73

1 Nov 2022 3 4,967.73 66.96 41.40 108.36 4,900.77

1 Dec 2022 4 4,900.77 67.52 40.84 108.36 4,833.25

1 Jan 2023 5 4,833.25 68.08 40.28 108.36 4,765.17

1 Feb 2023 6 4,765.17 68.65 39.71 108.36 4,696.52

1 Mar 2023 7 4,696.52 69.22 39.14 108.36 4,627.29

2 Apr 2023 8 4,627.29 69.80 38.56 108.36 4,557.49

2 May 2023 9 4,557.49 70.38 37.98 108.36 4,487.11

2 Jun 2023 10 4,487.11 70.97 37.39 108.36 4,416.15

2 Jul 2023 11 4,416.15 71.56 36.80 108.36 4,344.59

2 Aug 2023 12 4,344.59 72.16 36.20 108.36 4,272.43

2 Sep 2023 13 4,272.43 72.76 35.60 108.36 4,199.68

2 Oct 2023 14 4,199.68 73.36 35.00 108.36 4,126.31

2 Nov 2023 15 4,126.31 73.97 34.39 108.36 4,052.34

2 Dec 2023 16 4,052.34 74.59 33.77 108.36 3,977.75

2 Jan 2024 17 3,977.75 75.21 33.15 108.36 3,902.54

2 Feb 2024 18 3,902.54 75.84 32.52 108.36 3,826.70

2 Mar 2024 19 3,826.70 76.47 31.89 108.36 3,750.23

3 Apr 2024 20 3,750.23 77.11 31.25 108.36 3,673.12

3 May 2024 21 3,673.12 77.75 30.61 108.36 3,595.37

3 Jun 2024 22 3,595.37 78.40 29.96 108.36 3,516.97

3 Jul 2024 23 3,516.97 79.05 29.31 108.36 3,437.92

3 Aug 2024 24 3,437.92 79.71 28.65 108.36 3,358.21

3 Sep 2024 25 3,358.21 80.37 27.99 108.36 3,277.83

3 Oct 2024 26 3,277.83 81.04 27.32 108.36 3,196.79

3 Nov 2024 27 3,196.79 81.72 26.64 108.36 3,115.07

3 Dec 2024 28 3,115.07 82.40 25.96 108.36 3,032.67

3 Jan 2025 29 3,032.67 83.09 25.27 108.36 2,949.58

3 Feb 2025 30 2,949.58 83.78 24.58 108.36 2,865.80

3 Mar 2025 31 2,865.80 84.48 23.88 108.36 2,781.32

4 Apr 2025 32 2,781.32 85.18 23.18 108.36 2,696.14

4 May 2025 33 2,696.14 85.89 22.47 108.36 2,610.25

4 Jun 2025 34 2,610.25 86.61 21.75 108.36 2,523.64

4 Jul 2025 35 2,523.64 87.33 21.03 108.36 2,436.31

4 Aug 2025 36 2,436.31 88.06 20.30 108.36 2,348.25


Year Month Installment Outstanding at the beginning Principal repayment Interest Amount paid Outstanding at the end
4 Sep 2025 37 2,348.25 88.79 19.57 108.36 2,259.46

4 Oct 2025 38 2,259.46 89.53 18.83 108.36 2,169.93

4 Nov 2025 39 2,169.93 90.28 18.08 108.36 2,079.65

4 Dec 2025 40 2,079.65 91.03 17.33 108.36 1,988.62

4 Jan 2026 41 1,988.62 91.79 16.57 108.36 1,896.84

4 Feb 2026 42 1,896.84 92.55 15.81 108.36 1,804.28

4 Mar 2026 43 1,804.28 93.32 15.04 108.36 1,710.96

5 Apr 2026 44 1,710.96 94.10 14.26 108.36 1,616.86

5 May 2026 45 1,616.86 94.89 13.47 108.36 1,521.97

5 Jun 2026 46 1,521.97 95.68 12.68 108.36 1,426.29

5 Jul 2026 47 1,426.29 96.47 11.89 108.36 1,329.82

5 Aug 2026 48 1,329.82 97.28 11.08 108.36 1,232.54

5 Sep 2026 49 1,232.54 98.09 10.27 108.36 1,134.45

5 Oct 2026 50 1,134.45 98.91 9.45 108.36 1,035.55

5 Nov 2026 51 1,035.55 99.73 8.63 108.36 935.82

5 Dec 2026 52 935.82 100.56 7.80 108.36 835.25

5 Jan 2027 53 835.25 101.40 6.96 108.36 733.85

5 Feb 2027 54 733.85 102.24 6.12 108.36 631.61

5 Mar 2027 55 631.61 103.10 5.26 108.36 528.51

6 Apr 2027 56 528.51 103.96 4.40 108.36 424.56

6 May 2027 57 424.56 104.82 3.54 108.36 319.74

6 Jun 2027 58 319.74 105.70 2.66 108.36 214.04

6 Jul 2027 59 214.04 106.58 1.78 108.36 107.46

6 Aug 2027 60 107.46 107.46 0.90 108.36 0


Debt Service Coverage Ratio
All figures are in lakhs
Particulars 31/03/23 31/03/24 31/03/25 31/03/26 31/03/27

Receipts
a).Net Profit 781.65 1,071.08 1,987.00 3,294.56 5,102.09

b).Depreciation 233.04 371.63 327.62 289.52 256.50

c).Interest on termloan 285.81 423.25 331.41 229.96 117.87

Total 1,300.51 1,865.97 2,646.03 3,814.04 5,476.46

Repayments
a).Loan Principal 472.71 877.07 968.91 1,070.36 1,182.44

b).Interest on termloan 285.81 423.25 331.41 229.96 117.87

Total 758.52 1,300.32 1,300.32 1,300.32 1,300.32

DSCR 1.71 1.44 2.03 2.93 4.21

Average DSCR : 2.47


Depreciation
All figures are in lakhs
Particulars Rate 31/03/23 31/03/24 31/03/25 31/03/26 31/03/27
Construction of the Building 5 2,000.00 1,941.67 1,844.58 1,752.35 1,664.74

Less Depreciation 58.33 97.08 92.23 87.62 83.24

Written down value 1,941.67 1,844.58 1,752.35 1,664.74 1,581.50

Machinery 15 1,500.00 1,368.75 1,163.44 988.92 840.58

Less Depreciation 131.25 205.31 174.52 148.34 126.09

Written down value 1,368.75 1,163.44 988.92 840.58 714.50

Printer 15 10.00 9.12 7.76 6.59 5.60

Less Depreciation 0.88 1.37 1.16 0.99 0.84

Written down value 9.12 7.76 6.59 5.60 4.76

Computer 15 200.00 182.50 155.12 131.86 112.08

Less Depreciation 17.50 27.38 23.27 19.78 16.81

Written down value 182.50 155.12 131.86 112.08 95.27

Interior 10 100.00 94.17 84.75 76.28 68.65

Less Depreciation 5.83 9.42 8.47 7.63 6.86

Written down value 94.17 84.75 76.28 68.65 61.78

Cooler 10 200.00 188.33 169.50 152.55 137.29

Less Depreciation 11.67 18.83 16.95 15.26 13.73

Written down value 188.33 169.50 152.55 137.29 123.57

Electrification 10 90.00 84.75 76.28 68.65 61.78

Less Depreciation 5.25 8.47 7.63 6.86 6.18

Written down value 84.75 76.28 68.65 61.78 55.60

Generator 10 40.00 37.67 33.90 30.51 27.46

Less Depreciation 2.33 3.77 3.39 3.05 2.75

Written down value 37.67 33.90 30.51 27.46 24.71

Total less depreciation 233.04 371.63 327.62 289.52 256.50

Total written down value 4,906.96 4,535.33 4,207.71 3,918.19 3,661.69


Assumption
The entire projection is based on the assumption that the sales for 5 years will be

All figures are in lakhs

31/03/23 31/03/24 31/03/25 31/03/26 31/03/27


32,320.00 60,898.20 67,889.12 76,017.66 85,494.91

Revenue from Sales : 5412000000

Also the total expense for the firm during the projection years will be as follows

31/03/23 31/03/24 31/03/25 31/03/26 31/03/27


30,457.00 57,433.20 63,176.52 69,494.17 76,443.59

• The depreciation is as follows

Particulars Value
Construction of the Building 5%

Machinery 15%

Printer 15%

Computer 15%

Interior 10%

• Cost of the land or building is based on the basis of current rate


• Cost of machinery is based on the quotation submitted by the supplier
• Value of raw materials & utility charges as per the current market conditions
• All other assumptions are calculated based on the basis of experience of the promoter and deep study on
the working of similar model

This report is created using www.fi[Link] . Finline have bears no financial responsibility on or behalf of any of
the authorized signatories
Conclusion
The project as a whole describes the scope and viability of the Service industry and mainly of the financial,
technical and its market [Link] 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 1000 and above. It will cater the demand of Service 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.

When we take a close look at the Debt Service Coverage Ratio (DSCR), the avg: DSCR is 2.47 : 1, which is at a
healthy proposition & proposes a profitable venture

The Profit and Loss shows a steady growth in profit throughout the year and the firm has a satisfactory Current
Ratio (average) of 1.53, this shows the current assets and current liabilities are managed & balanced well.

You might also like