PROJECT REPORT

DIVYESHKUMAR MISTRY
OVERVIEW

1 Name of the proprietor MR. DIVYESHKUMAAR MISTRY

(DIVYESH FURNITURE)
2 Address VADODARA
3 Project cost(Rs.) 471,000.00
4 Bank loan (Rs.) 200,000.00
5 Margin money (Rs.) 271,000.00
6 Repayment period(years) 5
7 Loan rate of interest(%) 10.20%

SCHEDULE OF REPAYMENT OF LOAN & INTEREST CALCULATION

(RS. LAKHS)
[TERM LOAN] 10.20%

YEAR OP. BALANCE REPAYMENT CL. BALANCE INTEREST TOTAL REPAYMENT

I 2.00 0.40 1.60 0.16 0.56

II 1.60 0.40 1.20 0.12 0.52
III 1.20 0.40 0.80 0.08 0.48
IV 0.80 0.40 0.40 0.04 0.44
V 0.40 0.40 0.00 0.00 0.40
Total 2.00 0.41 2.41
 DIVYESHKUMAR MISTRY
PROJECTED PROFITABILITY STATEMENT
([Link] LAKH)
YEAR
PARTICULERS I II III IV V
PROJECTED
A] INCOME
1) SALES 3.00 3.60 4.32 5.18 6.22
2) OTHER INCOME 0.00 0.00 0.00 0.00 0.00
TOTAL - A 3.00 3.60 4.32 5.18 6.22

B] COST EXPENSES
1) SALARY- WAGES 0.00 0.00 0.00 0.00 0.00
2) OTHER DIRECT EXPENSES 0.05 0.05 0.05 0.06 0.06
3) DEPRICIATION 0.52 0.10 0.09 0.08 0.07
TOTAL - B 0.57 0.15 0.14 0.14 0.13

GROSS PROFIT ( A-B ) 2.43 3.45 4.18 5.05 6.09

4) ADMINISTRATIVE EXPENSES 0.00 0.00 0.00 0.00 0.00

5) INTEREST ON UNSECURED LOAN 0.00 0.00 0.00 0.00 0.00
6) FINANCE CHARGES 0.01 0.01 0.01 0.01 0.01
TOTAL 0.01 0.01 0.01 0.01 0.01

NET PROFIT 2.42 3.44 4.17 5.04 6.08

7) PROVISION FOR TAX (20% OF N.P.) 0.48 0.69 0.83 1.01 1.22
PROFIT AFTER TAX 1.94 2.75 3.33 4.03 4.86
ADD:- DEPRICIATION 0.52 0.10 0.09 0.08 0.07
TOTAL 2.46 2.85 3.42 4.11 4.94

LESS:- REPAYMENT OF LOAN 0.56 0.52 0.48 0.44 0.40

2) WITHDRAWAL 1.35 1.40 1.46 1.52 1.58
TOTAL 1.91 1.93 1.94 1.96 1.98

Debt Service Coverage ratio (%) 1.28 1.48 1.76 2.10 2.49

AVERAGE D.S.C.R. 1.82

 DIVYESHKUMAR MISTRY
PROJECTED BALANCE SHEET
([Link] LAKH)
YEAR
LIABILITIES I II III IV V
PROJECTED
A] PROPRITOR'S CAPITAL 3.50 2.22 2.33 2.44 2.56
B] PROFIT TR. TO CAPITAL 2.42 3.44 4.17 5.04 6.08
C] RESERVE & SURPLUS 0.00 0.00 0.00 0.00 0.00
TOTAL 5.92 5.66 6.50 7.48 8.64

C] SECURED LOAN
i) From Bank 0.00 2.00 1.44 1.08 0.72
ii) From Govt. Securities 0.00 0.00 0.00 0.00 0.00
TOTAL 0.00 2.00 1.44 1.08 0.72

D] UNSECURED LOAN 0.00 0.00 0.00 0.00 0.00

TOTAL (Rs.) 5.92 7.66 7.93 8.56 9.36

ASSETS
A] FIXED ASSETS
i) GROSS BLOCK 1.50 0.98 0.88 0.79 0.71
ii) DEPRICIATION 0.52 0.10 0.09 0.08 0.07
NET BLOCK 0.98 0.88 0.79 0.71 0.64

B] INVESTMENT 4.24 6.04 6.37 7.03 7.87

C] WORKING CAPITAL
a. CURRENT ASSETS
i) CASH & Bank Balance 0.55 0.58 0.61 0.64 0.67
ii) INVENTORIES 0.15 0.16 0.17 0.17 0.18
iii) SUNDRY DEBTORS 0.00 0.00 0.00 0.00 0.00
iv) LOAN & ADVANCES 0.00 0.00 0.00 0.00 0.00
TOTAL 0.70 0.74 0.77 0.81 0.85

b. CURRENT LIABILITIES
i) SUNDRY CREDITORS 0.00 0.00 0.00 0.00 0.00
ii) PROVISION 0.00 0.00 0.00 0.00 0.00
TOTAL 0.00 0.00 0.00 0.00 0.00

c. NET CURRENT ASSETS 0.70 0.74 0.77 0.81 0.85

TOTAL (Rs.) 5.92 7.66 7.94 8.55 9.36

 DIVYESHKUMAR MISTRY
FUND FLOW STATEMENT
([Link] LAKH)
YEAR
SOURCES OF FUNDS I II III IV
PROJECTED

1) NET PROFIT 3.44 4.17 5.04 6.08

2) DEPRICIATION 0.10 0.09 0.08 0.07
3) CAPITAL INTRODUCE -1.28 0.11 0.11 0.12
4) UNSECURED LOAN 0.00 0.00 0.00 0.00
5) LOAN FROM BANKS 2.00 0.00 0.00 0.00
6) INCREASE IN CURRENT LIABILITIES 0.00 0.00 0.00 0.00
7) OTHER

TOTAL - A 4.26 4.37 5.23 6.27

APPLICATION OF FUNDS I II III IV

1) INCREASE IN FIXED ASSETS -0.52 -0.10 -0.09 -0.08

2) INCREASE IN CURRENT ASSETS
i) INVENTORIES 0.01 0.01 0.01 0.01
ii) SUNDRY DEBTORS 0.00 0.00 0.00 0.00
iii) LOANS & ADVANCES 0.00 0.00 0.00 0.00
3) REPAYEMNT OF LOAN 0.52 0.48 0.44 0.40
4) WITHDRAWAL OF PROPRITORS 1.40 1.46 1.52 1.58
5) INVESTMENT 1.80 0.33 0.66 0.84
6) OTHER

TOTAL - B 3.21 2.18 2.54 2.75

1) CASH
2) OPENING BALANCE 0.55 1.59 3.78 6.47
ADD :-SURPLUS 1.04 2.18 2.69 3.52

CLOSING BALANCE 1.59 3.78 6.47 9.99

 DIVYESHKUMAR MISTRY
([Link] LAKH)
A. PROFILE ANALYSIS

I II III IV V
Total Assets(Tangible) 1.68 1.62 1.57 1.52 1.49
Total Outside Liabilities 0.00 0.00 0.00 0.00 0.00
Tangible Net Worth 5.92 7.66 7.93 8.56 9.36
Net Sales 3.00 3.60 4.32 5.18 6.22
PBDIT 2.94 3.54 4.26 5.12 6.15
Operating Profit(OPBT) 2.42 3.44 4.17 5.04 6.08
Net Profit 2.42 3.44 4.17 5.04 6.08
Net Working Capital 0.70 0.74 0.77 0.81 0.85
% of NWC to Current Assests (%) 100.00 100.00 100.00 100.00 100.00
Current Assests to Net Sales (%) 23.33 20.42 17.86 15.63 13.68

B PROFITABILITY ANALYSIS

PBDIT to Net Sales (%) 98.00 98.28 98.52 98.72 98.90

OPBT to Net Sales (%) 80.67 95.56 96.48 97.19 97.75
Net Profit to Net Sales (%) 80.67 95.56 96.48 97.19 97.75
Return on Assests (%) 144.05 212.74 266.21 330.44 407.06
Return on Net Worth (%) 40.88 44.91 52.53 58.89 64.97

C LEVERAGE AND OTHER RATIOS

TOL / TNW - - - - -
DSCR 1.28 1.48 1.76 2.10 2.49
 ([Link] LAKH)
COST OF PROJECT
PARTICULERS EXISTING PROPOSED TOTAL

1 LAND 0.00 12.80 12.80

2 [Link] 0.00 0.00 0.00
3 BUILDING 0.00 17.50 17.50
4 PLANT & MACHINERY 6.21 11.50 17.71
5 COMPUTER 1.44 0.00 1.44
6 FURNITURE & FIXTURE 1.44 1.20 2.64
7 OTHER FIXED ASSETS (VEHICLES) 5.19 2.00 7.19
8 OTHER ASSETS (INVESTMENT) 3.44 0.00 3.44
9 NET CURRENT ASSETS -0.46 0.00 -0.46
10 MARGIN MONEY FOR W.C. 0.00 0.00 0.00

TOTAL 17.26 45.00 62.26

MEANS OF FINANCE
PARTICULERS EXISTING PROPOSED TOTAL

1 OWNERS CONTRIBUTION 0.00 0.00 0.00

2 LOAN FROM FRIENDS & RELATIVES 0.00 0.00 0.00
3 LOAN FROM BANKS 30.00 0.00 30.00
0.00 0.00 0.00
TOTAL 30.00 0.00 30.00