DETAILED PROJECT REPORT FOR

kishan khad beej bhandar

(retailer of khad and beej or fertilisers)

Office:
Address: wair
district: bulandshar
tashil: sikandrabad
posi office: wair
PIN code: 203205
 DETAILED PROJECT REPORT FOR
kishan khad beej bhandar

I N D E X
SL. CONTENTS PAGES

CHAPTER :
1 PROJECT AT GLANCE 1
2 COST OF THE PROJECT AND MEANS OF FINANCE 2
3 PROJECTIONS AND PROFITABILITY STATEMENT 3
4 CASH - FLOW STATEMENT 4
5 BALANCE SHEET 5

ANNEXURES
1 DEPRECIATION SCHEDULE 6
2 BREAK EVEN ANALYSIS 7
3 INTEREST SCHEDULE 8
4 DEBT COVERAGE RATIO 9
5 ANALYSIS ON RETURN ON INVESTMENT 10
6 ASSUMPTION AND WORKING NOTES 11
kishan khad beej bhandar
CHAPTER NO. 1
PROJECT AT GLANCE :
1 BussinessName : kishan khad beej bhandar
2 Bussiness address : Reg.Office:
Address: wair
district: bulandshar
tashil: sikandrabad
Proprietar name Gajendra singh

3 Nature of Business : service

4 Constitution : Proprietorship
Proprietor :

5 Cost of the project : 2730000 (Rs. In Lakhs)

Particulars Total
Operational Cost ##########
Furniture & Fittings 200,000.00
Generator & Office Equipemnts 300,000.00
Deposits 600,000.00
Interest during the impl. Period 200,000.00
Total ##########

Means of Finance :
Particulars Total
Proprietor Contribution 200,000.00
Term Loan from Bank / Institution ##########

Total ##########

Page 3 of 11
kishan khad beej bhandar
BULANDSHAR

(RETAILER OF KHAD BEEJ)

STATEMENT NO. 1

COST OF THE PROJECT AND MEANS OF FINANCE:

The project cost has been estimated at Rs. 2,730,000.00

Brief details of the project cost is given below

Cost of the project : (Rs. In Lakhs)

Particulars Total
Operational Cost 1,430,000.00
Furniture & Fittings 200,000.00
Generator & Office Equipemnts 300,000.00
Deposits 600,000.00
Interest during the impl. Period 200,000.00
Total 2,730,000.00

Means of Finance :
Particulars Total
Promoters Contribution 730,000.00
Term Loan from Bank / Institution 200,000.00
Total 2,730,000.00
 kishan khad beej bhandar
STATEMENT NO.2
PROJECTIONS AND PROFITABILITY STATEMENT
Operating years
PARTICULARS
0 1 2 3 4
A.INCOME:
Income from Trading Activities 1,000,000.00 ######## 1,400,000.00 1,500,000.00 1,600,000.00

(The Quanities Sold are expected to increase by

20% every year)

B. EXPENSES:
Material Purchase Cost and Related cost
(After Adjusting closing stock) 400,000.00 ######## 600,000.00 700,000.00 820,000.00
Salary 60,000.00 65,000.00 70,000.00 70,000.00 72,000.00
Power Charges 20,000.00 25,000.00 22,000.00 24,000.00 20,000.00
Depreciation 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00
TOTAL 490,000.00 ######## 702,000.00 804,000.00 922,000.00

C. Gross Profit [ A - B ] 510,000.00 ######## 698,000.00 696,000.00 678,000.00

D. Interest: on term loan 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00

E. Selling & Admin. Exp. 10,000.00 20,000.00 50,000.00 40,000.00 60,000.00

F. Profit before Tax[ C - (D+E) ] 495,000.00 ######## 643,000.00 651,000.00 613,000.00

G. Income Tax - - - - -

H. Profit after Tax ( F-G ) 495,000.00 ######## 643,000.00 651,000.00 613,000.00

I. Depreciation added back - - - - -

J. Cash Accruals ( H + I ) 495,000.00 ######## 643,000.00 651,000.00 613,000.00

L. Repayment of Term Loan - - - - -

M. Net Cash A'ble (J - K)) 495,000.00 ######## 643,000.00 651,000.00 613,000.00

kishan khad beej bhandar
STATEMENT No.3

CASH - FLOW STATEMENT :

(khad beej sales)
Operating Years
PARTICULARS
0 1 2 3 4
A. Source of Funds :
Profit after Tax 495,000.00 ######## 643,000.00 651,000.00 613,000.00
Depreciation 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00
Term Loan from Bank - - - - -
Promoters Contribution - - - - -

TOTAL OF ' A ' 505,000.00 ######## 653,000.00 661,000.00 623,000.00

B. Application of Funds :
Furniture & Fittings 100,000.00 ######## 100,000.00 100,000.00 100,000.00
Gen & Office Equipts, 100,000.00 ######## 100,000.00 100,000.00 100,000.00
Deposits 300,000.00 ######## 350,000.00 300,000.00 400,000.00
Repayment of loan 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00

TOTAL OF ' B ' 505,000.00 ######## 555,000.00 505,000.00 605,000.00

C. Opening Balance 200,000.00 ######## 600,000.00 700,000.00 700,000.00

D. Net surplus ( A - B ) - ######## 98,000.00 156,000.00 18,000.00

kishan khad beej bhandar
STATEMENT No.4

BALANCE SHEET
(khad beej sales)
Operating Years
PARTICULARS
0 1 2 3 4

A. LIABILITIES :
Reserves & Surplus - ######## 98,000.00 156,000.00 18,000.00
Secured Loan - - - - -

TOTAL - ######## 98,000.00 156,000.00 18,000.00

B. ASSETS :
Cash & Bank ######## ######## ######## 400,000.00 300,000.00
Deposits ######## ######## ######## 500,000.00 500,000.00

TOTAL ######## ######## ######## 900,000.00 800,000.00

kishan khad beej bhandar
bulandshar

(khad beej sales)

ANNEXURE NO.1

DEPRECIATION SCHEDULE: (khad beej sales)

WDV at the year end
PARTICULARS
0 1 2 3
1. Furniture & Fittings 100,000.00 100,000.00 100,000.00 100,000.00
Depreciation @ 15% 15,000.00 15,000.00 15,000.00 15,000.00
WDV 85,000.00 85,000.00 85,000.00 85,000.00

4. Genr & Office Equipts 100,000.00 100,000.00 100,000.00 100,000.00

Depreciation @ 15% 15,000.00 15,000.00 15,000.00 15,000.00
WDV 85,000.00 85,000.00 85,000.00 85,000.00

Total Assets 200,000.00 200,000.00 200,000.00 200,000.00

[1+2+3+4]

Total Depreciation 30,000.00 30,000.00 30,000.00 30,000.00

[1+2+3+4]
WDV at the year end
4
100,000.00
15,000.00
85,000.00

100,000.00
15,000.00
85,000.00

200,000.00

30,000.00
kishan khad beej bhandar
ANNEXURE NO.2

BREAK-EVEN ANALYSIS
Years
(khad beej sales)
0 1 2 3 4
A. Receipts 1,000,000.00 ######## 1,300,000.00 1,400,000.00 1,600,000.00

B. Variable cost: 1000000.00 1200000.00 1300000.00 1400000.00 1600000.00

D. Fixed costs:
Depreciation 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00
Interest on Term Loan 5000.00 5000.00 5000.00 5000.00 5000.00
Administration Expenses 0.00 0.00 0.00 0.00 0.00
15000.00 15000.00 15000.00 15000.00 15000.00

E. Contribution [ B - C ] 850000.00 850000.00 850000.00 850000.00 850000.00

F. P.V.Ratio [ E/B x 100 ] 117.64 117.64 117.64 117.64 117.64

G. Break - even [ Value ] 12750 12750 12750 12750 12750

[ D / F x 100 ]

H. Cash Break Even 0.00 0.00 0.00 0.00 0.00

[ Without Depreciation]
 #REF!
ANNEXURE NO.4

DEBT SERVICE COVERAGE RATIO :

Operating Years
(khad beej sales)
0 1 2 3 4
A. SOURCES :
Profit after tax ######## ######## ####### ######## 613,000.00
Depreciation 10,000.00 10,000.00 ####### 10,000.00 10,000.00
Interest on term loan 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00
TOTAL OF ' A ' ######## ######## ####### ######## 628,000.00

B DEBT :
Term loan installment - - - - -
Interest on Term Loan 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00

TOTAL OF ' B ' 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00

C Debt Service Coverage Ratio 102.00 136.00 131.60 133.20 125.60

DSCR [A/B]

D Average DSCR 125.68

 #REF!
ANNEXURE NO.5

ANALYSIS OF RETURN ON INVESTMENT :

(khad beej sales)
1. Return on Investment = Average Return x 100
Capital Employed

2. Return = Profit before tax + Depreciation + Interest on term loan

3. Capital Employed = Cost of the Project

RETURN ON INVESTMENT :

OPERTING YEARS
PARTICULARS
0 1 2 3 4
Profit before tax ######## ####### ######## ######## 613,000.00

Depreciation 10,000.00 ####### 10,000.00 10,000.00 10,000.00

Interest on Term Loan 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00

######## ####### ######## ######## 628,000.00

# Average Return ########

# Capital Employed ########

# Return on Investment 42.50

#REF!
ANNEXURE NO.6
Assumption and workings notes to the Financial Statements of the Project Report:
1 Revenue
Sale of (urea and seeds) in lakh
sr. product quantity( per bag ) price total
1 urea 400 240 100,000
2 DAP 500 1320 #######
3 sagariya 500 400 #######
4 simodis 200 1800 #######
5 incipio 300 2200 #######
6 virjaco 500 1300 #######

#######

2 Material Purchase Costs

2500000

3 Salary
S.No. Category of Employee No.of Salary per Salary per
Employees Month Annuam
1 worker 1 8,000.00 96,000.00

Total 1 8,000.00 96,000.00

Note: Increament in salary is taken at 5% per annum

Page 11 of 11