PROJECT REPORT

Of

M/S SHIVNERI DAL MILL

Proprietorship:

Mrs. VANDANA NAVNATH GODBOLE

PROJECT REPORT
For

Term Loan Finance of Rs.3.00 Lakhs

[Link], [Link], DIST BEED – 431127.

M/S SHIVNERI DAL MILL

Amount
(Rs in
Project Cost Incurred Balance Lakhs)

Plant & Machinery 3.06 3.06

Material Purchase 0.50 0.50

3.56

Total Project Cost 3.56 3.56 3.56

Means of Finance

Bank Finance
Term Loan 3.00 3.00 3.00
-
Pramoters Margin ( Capital & unsecured Loan) 0.56 0.56 0.56

Total 3.56 3.56 3.56

 Term Loan 3.00
12.0% Rate 0.01
Term 60
EMI -0.07
Int Repay Bal
1 3.00 0.03 3.03 -0.07 2.96
2 2.96 0.03 2.99 -0.07 2.93
3 2.93 0.03 2.96 -0.07 2.89
4 2.89 0.03 2.92 -0.07 2.85
5 2.85 0.03 2.88 -0.07 2.81
6 2.81 0.03 2.84 -0.07 2.77
7 2.77 0.03 2.80 -0.07 2.74
8 2.74 0.03 2.76 -0.07 2.70
9 2.70 0.03 2.72 -0.07 2.66
10 2.66 0.03 2.68 -0.07 2.62
11 2.62 0.03 2.64 -0.07 2.58
12 2.58 0.03 2.60 -0.07 2.53 0.33 -0.80 2.53
13 2.53 0.03 2.56 -0.07 2.49
14 2.49 0.02 2.52 -0.07 2.45
15 2.45 0.02 2.48 -0.07 2.41
16 2.41 0.02 2.43 -0.07 2.37
17 2.37 0.02 2.39 -0.07 2.32
18 2.32 0.02 2.35 -0.07 2.28
19 2.28 0.02 2.30 -0.07 2.24
20 2.24 0.02 2.26 -0.07 2.19
21 2.19 0.02 2.21 -0.07 2.15
22 2.15 0.02 2.17 -0.07 2.10
23 2.10 0.02 2.12 -0.07 2.06
24 2.06 0.02 2.08 -0.07 2.01 0.28 -0.80 2.01
25 2.01 0.02 2.03 -0.07 1.96
26 1.96 0.02 1.98 -0.07 1.92
27 1.92 0.02 1.93 -0.07 1.87
28 1.87 0.02 1.89 -0.07 1.82
29 1.82 0.02 1.84 -0.07 1.77
30 1.77 0.02 1.79 -0.07 1.72
31 1.72 0.02 1.74 -0.07 1.67
32 1.67 0.02 1.69 -0.07 1.62
33 1.62 0.02 1.64 -0.07 1.57
34 1.57 0.02 1.59 -0.07 1.52
35 1.52 0.02 1.54 -0.07 1.47
36 1.47 0.01 1.48 -0.07 1.42 0.21 -0.80 1.42
37 1.42 0.01 1.43 -0.07 1.37
38 1.37 0.01 1.38 -0.07 1.31
39 1.31 0.01 1.33 -0.07 1.26
40 1.26 0.01 1.27 -0.07 1.20
41 1.20 0.01 1.22 -0.07 1.15
42 1.15 0.01 1.16 -0.07 1.09
43 1.09 0.01 1.11 -0.07 1.04
44 1.04 0.01 1.05 -0.07 0.98
45 0.98 0.01 0.99 -0.07 0.93
46 0.93 0.01 0.93 -0.07 0.87
47 0.87 0.01 0.88 -0.07 0.81
48 0.81 0.01 0.82 -0.07 0.75 0.13 -0.80 0.75
49 0.75 0.01 0.76 -0.07 0.69
50 0.69 0.01 0.70 -0.07 0.63
51 0.63 0.01 0.64 -0.07 0.57
52 0.57 0.01 0.58 -0.07 0.51
53 0.51 0.01 0.52 -0.07 0.45
54 0.45 0.00 0.45 -0.07 0.39
55 0.39 0.00 0.39 -0.07 0.32
56 0.32 0.00 0.33 -0.07 0.26
57 0.26 0.00 0.26 -0.07 0.20
58 0.20 0.00 0.20 -0.07 0.13
59 0.13 0.00 0.13 -0.07 0.07
60 0.07 0.00 0.07 -0.07 0.00 0.05 -0.80 0.00

I II III IV V
Int. 0.33 0.28 0.21 0.13 0.05
Repay EMI -0.80 -0.80 -0.80 -0.80 -0.80
Repay Principal -0.47 -0.52 -0.59 -0.67 -0.75

Balance 2.53 2.01 1.42 0.75 0.00

M/S SHIVNERI DAL MILL
Depreciation Schedule ( Rates as per Income Tax Act)
(Rs. In Lakhs)
PROJECTED
FIXED ASSETS I II III IV V
Plant & Machinery
Opening Balance - 2.60 2.21 1.88 1.60
Addition 3.06 - - - -
Total 3.06 2.60 2.21 1.88 1.60
Depreciation 0.46 0.39 0.33 0.28 0.24
Closing Balance 2.60 2.21 1.88 1.60 1.36
Furniture & Fixture
Opening Balance - - - - -
Addition - - - - -
Total - - - - -
Depreciation - - - - -
Closing Balance - - - - -

M/S SHIVNERI DAL MILL

Summary of Depreciated items (Rs. In Lakhs)
PROJECTED
I II III IV V
Opening Balance - 2.60 2.21 1.88 1.60
Addition 3.06 - - - -
Total 3.06 2.60 2.21 1.88 1.60
Depreciation 0.46 0.39 0.33 0.28 0.24
Closing Balance 2.60 2.21 1.88 1.60 1.36
M/S SHIVNERI DAL MILL
Working Capital Requirement (Rs. In Lakhs)
PROJECTED
PARTICULARS I II III IV V
Debtors 0.59 3.31 3.77 4.37 5.07

Closing Stock 3.47 3.64 3.86 4.13 4.50

Current Assests Loans & Advances - - 0.35 0.40 0.48

Creditors 1.83 2.01 2.21 2.44 2.68

Outstanding Expenses 0.05 0.06 0.08 0.12 0.12

Working Capital 2.18 4.88 5.69 6.35 7.26

Bank Finance - - - - -
Own Margin 2.18 4.88 5.69 6.35 7.26

Changes in own margin 2.18 2.70 0.81 0.66 0.91

Changes in w.c. 2.18 2.70 0.81 0.66 0.91

M/S SHIVNERI DAL MILL
Profitability Satement (Rs. In Lakhs)
PROJECTED
PARTICULARS I II III IV V

Sales 14.28 18.56 21.16 24.55 28.48

Total Receipts 14.28 18.56 21.16 24.55 28.48

Less :- Opening Stock - 3.47 3.64 3.86 4.13
Add :- Closing Stock 3.47 3.64 3.86 4.13 4.50
Material Purchases 7.23 5.86 6.44 7.41 8.07

Gross Profit 10.52 12.88 14.94 17.41 20.77

% 73.67% 69.39% 70.59% 70.92% 72.95%
Total (A) 10.52 12.88 14.94 17.41 20.77

Conveyance Expenses 0.92 1.07 1.24 1.44 1.67

Labour Expenses 0.84 1.13 1.53 1.99 3.08
Salary & Wages 1.40 1.54 1.77 2.07 2.49
Electricity Expenses 0.12 0.13 0.15 0.16 0.18
Professional Charges 0.07 0.08 0.08 0.09 0.10
General & [Link] 0.19 0.22 0.25 0.30 0.35
Printing & Stationery 0.08 0.09 0.11 0.12 0.15
Postage & Telephone Exp. 0.18 0.20 0.23 0.26 0.30
Repairs & Maint 0.67 0.74 0.87 1.00 1.15
Travelling Expenses 0.28 0.31 0.34 0.37 0.41

Total (C) 4.75 5.51 6.56 7.81 9.87

EBIDTA 5.77 7.37 8.38 9.60 10.91

Depreciation 0.46 0.39 0.33 0.28 0.24
Interest on Term Loan 0.33 0.28 0.21 0.13 0.05

Net Profit Before Tax 4.98 6.71 7.83 9.18 10.62

% to sales 0.35 0.36 0.37 0.37 0.37

Net Profit Before Tax (A-B) 4.98 6.71 7.83 9.18 10.62
Income Tax
Profit after Tax 4.98 6.71 7.83 9.18 10.62
PAT 0.35 0.36 0.37 0.37 0.37

(Rs. In Lakhs)
DSCR
Net Profit Before Tax 4.98 6.71 7.83 9.18 10.62
Depreciation 0.46 0.39 0.33 0.28 0.24
Interest On TL 0.33 0.28 0.21 0.13 0.05
Total Cash Accruals 5.77 7.37 8.38 9.60 10.91

Interest On TL 0.33 0.28 0.21 0.13 0.05

Instalment for the year 0.47 0.52 0.59 0.67 0.75
Total payables 0.80 0.80 0.80 0.80 0.80
DSCR 7.21 9.21 10.46 11.99 13.62
Avg DSCR 10.50
M/S SHIVNERI DAL MILL
Cash Flow Statement (Rs. In Lakhs)
PROJECTED
Particulars I II III IV V

Opening Balance - 1.97 2.57 3.70 4.89

Unsecured Loan

Net Profit 4.98 6.71 7.83 9.18 10.62

Bank Loans 3.00

Addition in Capital 0.56 - - - -

- -

Depreciation 0.46 0.39 0.33 0.28 0.24

Cash Inflow 9.00 9.07 10.73 13.17 15.75

Project outflow

Drawings 1.32 3.28 5.13 7.45 9.85

Repayment of Loan 0.47 0.52 0.59 0.67 0.75

Fixed Assets Purchase 3.06 - - -

Repayment of Unsecurred Loan - - - - -

Deposits - - - - -

Investements - - 0.50 (0.50) -

Changes in W.C. 2.18 2.70 0.81 0.66 0.91

Total outflow 7.02 6.50 7.03 8.28 11.51

Closing Balance 1.97 2.57 3.70 4.89 4.24

M/S SHIVNERI DAL MILL
Projected Balance Sheet (Rs. In Lakhs)
PROJECTED
I II III IV V

CAPITAL ACCOUNT
Opening Capital - 4.22 7.64 10.35 12.08
Add:- Additional Capital 0.56 - - -
Add: Profit 4.98 6.71 7.83 9.18 10.62
Less: Drawings 1.32 3.28 5.13 7.45 9.85
Balance 4.22 7.64 10.35 12.08 12.85
Secured Loans
Term Loan 2.53 2.01 1.42 0.75 0.00

Unsecured Loans - - - - -

Sundry Creditors 1.83 2.01 2.21 2.44 2.68

Current Liabilities & provisions 0.05 0.06 0.08 0.12 0.12

Total 8.63 11.73 14.06 15.39 15.65
Fixed Assets 2.60 2.21 1.88 1.60 1.36

Investements - - 0.50 - -

Diposit - - - - -

Current Assests Loans & Advances - - 0.35 0.40 0.48

Closing Stock 3.47 3.64 3.86 4.13 4.50

Sundry Debtors 0.59 3.31 3.77 4.37 5.07

Cash/Bank Balance 1.97 2.57 3.70 4.89 4.24

Total 8.63 11.73 14.06 15.39 15.66
M/S SHIVNERI DAL MILL
Current Ratio
(Rs. In Lakhs)
Particulars PROJECTED
Years I II III IV V

Closing Stock 3.47 3.64 3.86 4.13 4.50

Sundry Debtors 0.59 3.31 3.77 4.37 5.07
Deposit - - - - -
Current Assests Loans & Advances - - 0.35 0.40 0.48
Cash/Bank Balance 1.97 2.57 3.70 4.89 4.24
TOTAL CURRENT ASSETS 6.03 9.52 11.68 13.80 14.30

Sundry Creditors 1.83 2.01 2.21 2.44 2.68

Current Liabilities & provisions 0.05 0.06 0.08 0.12 0.12

TOTAL CURRENT LIABILITIES 1.88 2.07 2.30 2.56 2.80

Current Ratio 3.21 4.59 5.09 5.40 5.11

TOL/TNW
Particulars PROJECTED
Years I II III IV V
TNW
Capital Account 4.22 7.64 10.35 12.08 12.85
Unsecured Loans - - - - -

Total 4.22 7.64 10.35 12.08 12.85

TOL
Sundry Creditors 1.83 2.01 2.21 2.44 2.68
Outstanding Expenses 0.05 0.06 0.08 0.12 0.12
Term Loan 2.53 2.01 1.42 0.75 0.00

Total 4.41 4.08 3.71 3.31 2.80

Ratio 1.05 0.53 0.36 0.27 0.22

Debt / Equity
Particulars PROJECTED
Years I II III IV V

Capital Account / Equity 4.22 7.64 10.35 12.08 12.85

Unsecured Loans - - - - -

Total 4.22 7.64 10.35 12.08 12.85

Debt / Loans 2.53 2.01 1.42 0.75 0.00

Ratio 0.60 0.26 0.14 0.06 0.00