Nothing Special   »   [go: up one dir, main page]

Cash Credit Proposal For Bank Finance

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 15

PROJECT REPORT

OF

M/S GOPAL HANDLOOM


PROP: MR. RAJESH KUMAR MOHANTY

DIST: SAMBALPUR,ODISHA
PROJECT AT A GLANCE

1 Name of the project : Cash Credit facility for Retailor of Textiles

2 Location of the Project : Kansaripara


P.O. Sambalpur
Dist : Sambalpur,768001

3 Provisional Registration No. : Not Required

4 Name of the Proprietor : Mr. Rajesh Kumar Mohanty


Kansaripara
Dist : Sambalpur,768001

5 Legal Constitution of the unit : Individual

6 Type of Industry : Retailor of Textile

7 Capacity Utilisation ( Yearwise ): Not Applicable

Rs.in 000'
8 COST OF THE PROJECT : Fixed Capital : -
Working Capital Requirment : 200
Total : 200

9 MEANS OF FINANCE
9.1 Margin Money : Promoter's Contribution / Margin money -

9.2 Bank Loan : Term Loan : -

Total : -

10 Type of Entrepreneur : General Entrepreneur

11 Working Hours : 8 Hours

25 working days per month


: 300 working days per year
Rs.in 000'
12 BANK EXPOSURE Term Loan -
Cash Credit 200
200.0
M/S GOPAL HANDLOOM
PROP: MR. RAJESH KUMAR MOHANTY
KANSARIPARA SAMBALPUR
ACTUAL PROFIT AND LOSS ACCOUNT FOR THE YEAR ENDED 31ST MARCH 2019

PARTICULARS AMOUNT IN RS. PARTICULARS AMOUNT IN RS.

To Opening Stock 132,000.00 By Sales 1,825,000.00

To Purchases 1,381,978.00 By Closing Stock 158,700.00


(Including Carriage & Freight)
To Gross Profit 469,722.00
TOTAL 1,983,700.00 TOTAL 1,983,700.00

To Staff salary 72,000.00 By Gross Profit 469,722.00


To Electricity 5,122.00
To postage & Courier 1,500.00
To Telephone 3,250.00
To Rent 60,000.00
To Travelling expenses 4,250.00
To Depreciation 10,000.00
To Legal expenses 2,000.00
To Insurance Charges 2,000.00
To General expenses 4,000.00
To Bank Charges
To Bank Interest -
To Net profit transferred to B/S 305,600.00
TOTAL 469,722.00 TOTAL 469,722.00

M/S GOPAL HANDLOOM


PROP: MR. RAJESH KUMAR MOHANTY
KANSARIPARA SAMBALPUR
ACTUAL BALANCE SHEET AS AT 31ST MARCH 2019

PARTICULARS AMOUNT IN RS. PARTICULARS AMOUNT IN RS.

CAPITAL A/C FIXED ASSETS


Mr. Rajesh Kumar MOHANTY Furniture 44,000.00
Op.capital 225,100.00 Less: Depreciation 4,400.00 39,600.00
Add: Net Profit 305,600.00
Office Equipments
530,700.00 Less: Depreciation - -
Less: Drawings 150,000.00 380,700.00
Two Wheeler 56,000.00
SECURED & UNSECURED LOAN Less: Depreciation 5,600.00 50,400.00

INVESTMENTS

Other Investment -

CURRENT LIABILITIES & CURRENT ASSETS


PROVISIONS Sundry debtors 42,000.00
Sundry Creditors 85,000.00 Closing Stock 158,700.00
( At cost, as valued &
certified by the Proprietor )
Loans & Advances 50,000.00
Cash in Hand & at bank 125,000.00
TOTAL 465,700.00 TOTAL 465,700.00
M/S GOPAL HANDLOOM
PROP: MR. RAJESH KUMAR MOHANTY
KANSARIPARA SAMBALPUR
ESTIMATED PROFIT AND LOSS ACCOUNT FOR THE YEAR ENDED 31ST MARCH 2020

PARTICULARS AMOUNT IN RS. PARTICULARS AMOUNT IN RS.

To Opening Stock 158,700.00 By Sales 2,220,480.00

To Purchases 1,848,387.00 By Closing Stock 332,500.00


(Including Carriage & Freight)
To Gross Profit 545,893.00
TOTAL 2,552,980.00 TOTAL 2,552,980.00

To Staff salary 78,000.00 By Gross Profit 545,893.00


To Electricity 5,300.00
To postage & Courier 1,700.00
To Telephone 3,300.00
To Rent 60,000.00
To Travelling expenses 4,500.00
To Depreciation 9,000.00
To Legal expenses 2,500.00
To Insurance Charges 2,500.00
To General expenses 4,500.00
To Bank Charges 5,000.00
To Bank Interest 5,000.00
To Net profit transferred to B/S 364,593.00
TOTAL 545,893.00 TOTAL 545,893.00

M/S GOPAL HANDLOOM


PROP: MR. RAJESH KUMAR MOHANTY
KANSARIPARA SAMBALPUR
ESTIMATED BALANCE SHEET AS AT 31ST MARCH 2020

PARTICULARS AMOUNT IN RS. PARTICULARS AMOUNT IN RS.

CAPITAL A/C FIXED ASSETS


Mr. Rajesh Kumar MOHANTY Furniture 39,600.00
Op.capital 380,700.00 Less: Depreciation 3,960.00 35,640.00
Add: Net Profit 364,593.00
Office Equipments -
745,293.00 Less: Depreciation - -
Less: Drawings 170,000.00 575,293.00
Two Wheeler 50,400.00
SECURED & UNSECURED LOAN Less: Depreciation 5,040.00 45,360.00

INVESTMENTS

Other Investment 145,000.00

CURRENT LIABILITIES & CURRENT ASSETS


PROVISIONS Sundry debtors 169,000.00
Cash credit 200,000.00 Closing Stock 332,500.00
Sundry Creditors 45,000.00 ( At cost, as valued &
certified by the Proprietor )
Loans & Advances 55,000.00
Cash in Hand & at bank 37,793.00
TOTAL 820,293.00 TOTAL 820,293.00
M/S GOPAL HANDLOOM
PROP: MR. RAJESH KUMAR MOHANTY
KANSARIPARA SAMBALPUR
PROJECTED PROFIT AND LOSS ACCOUNT FOR THE YEAR ENDED 31ST MARCH 2021

PARTICULARS AMOUNT IN RS. PARTICULARS AMOUNT IN RS.

To Opening Stock 332,500.00 By Sales 2,384,035.00

To Purchases 1,745,000.00 By Closing Stock 338,000.00


(Including Carriage & Freight)
To Gross Profit 644,535.00
TOTAL 2,722,035.00 TOTAL 2,722,035.00

To Staff salary 84,000.00 By Gross Profit 644,535.00


To Electricity 5,400.00
To postage & Courier 2,000.00
To Telephone 3,500.00
To Rent 66,000.00
To Travelling expenses 4,700.00
To Depreciation 8,100.00
To Legal expenses 2,500.00
To Insurance Charges 2,600.00
To General expenses 5,000.00
To Bank Charges 1,100.00
To Bank Interest 20,000.00
To Net profit transferred to B/S 439,635.00
TOTAL 644,535.00 TOTAL 644,535.00

M/S GOPAL HANDLOOM


PROP: MR. RAJESH KUMAR MOHANTY
KANSARIPARA SAMBALPUR
PROJECTED BALANCE SHEET AS AT 31ST MARCH 2021

PARTICULARS AMOUNT IN RS. PARTICULARS AMOUNT IN RS.

CAPITAL A/C FIXED ASSETS


Mr. Rajesh Kumar MOHANTY Furniture 35,640.00
Op.capital 575,293.00 Less: Depreciation 3,564.00 32,076.00
Add: Net Profit 439,635.00
Office Equipments -
1,014,928.00 Less: Depreciation - -
Less: Drawings 200,000.00 814,928.00
Two Wheeler 45,360.00
SECURED & UNSECURED LOAN Less: Depreciation 4,536.00 40,824.00

INVESTMENTS

Other Investment 360,000.00

CURRENT LIABILITIES & CURRENT ASSETS


PROVISIONS Sundry debtors 140,000.00
Cash credit 200,000.00 Closing Stock 338,000.00
Sundry Creditors 35,000.00 ( At cost, as valued &
certified by the Proprietor )
Loans & Advances 65,000.00
Cash in Hand & at bank 74,028.00
TOTAL 1,049,928.00 TOTAL 1,049,928.00
M/S GOPAL HANDLOOM
PROP: MR. RAJESH KUMAR MOHANTY
KANSARIPARA SAMBALPUR
PROJECTED PROFIT AND LOSS ACCOUNT FOR THE YEAR ENDED 31ST MARCH 2022

PARTICULARS AMOUNT IN RS. PARTICULARS AMOUNT IN RS.

To Opening Stock 338,000.00 By Sales 2,500,200.00

To Purchases 1,791,200.00 By Closing Stock 342,000.00


(Including Carriage & Freight)
To Gross Profit 713,000.00
TOTAL 2,842,200.00 TOTAL 2,842,200.00

To Staff salary 90,000.00 By Gross Profit 713,000.00


To Electricity 5,600.00
To postage & Courier 2,200.00
To Telephone 3,700.00
To Rent 66,000.00
To Travelling expenses 5,000.00
To Depreciation 7,290.00
To Legal expenses 3,000.00
To Insurance Charges 2,750.00
To General expenses 5,500.00
To Bank Charges 1,300.00
To Bank Interest 20,000.00
To Net profit transferred to B/S 500,660.00
TOTAL 713,000.00 TOTAL 713,000.00

M/S GOPAL HANDLOOM


PROP: MR. RAJESH KUMAR MOHANTY
KANSARIPARA SAMBALPUR
PROJECTED BALANCE SHEET AS AT 31ST MARCH 2022

PARTICULARS AMOUNT IN RS. PARTICULARS AMOUNT IN RS.

CAPITAL A/C FIXED ASSETS


Mr. Rajesh Kumar MOHANTY Furniture 32,076.00
Op.capital 814,928.00 Less: Depreciation 3,207.60 28,868.40
Add: Net Profit 500,660.00
Office Equipments -
1,315,588.00 Less: Depreciation - -
Less: Drawings 215,000.00 1,100,588.00
Two Wheeler 40,824.00
SECURED & UNSECURED LOAN Less: Depreciation 4,082.40 36,741.60

INVESTMENTS

Other Investment 640,000.00

CURRENT LIABILITIES & CURRENT ASSETS


PROVISIONS Sundry debtors 130,000.00
Closing Stock 342,000.00
Cash credit 200,000.00 ( At cost, as valued &
Sundry Creditors 65,000.00 certified by the Proprietor )
Loans & Advances 75,000.00
Cash in Hand & at bank 112,978.00
TOTAL 1,365,588.00 TOTAL 1,365,588.00
M/S GOPAL HANDLOOM
PROP: MR. RAJESH KUMAR MOHANTY
KANSARIPARA SAMBALPUR

COMPARATIVE BALANCE SHEET

PARTICULARS ACTUAL ESTIMATED PROJECTED PROJECTED


2018-2019 2019-2020 2020-2021 2021-2022
A. LIABILITIES

CAPITAL : 380,700.00 575,293.00 814,928.00 1,100,588.00

SECURED & UNSECURED LOAN

CURRENT LIABILITIES
Cash Credit Loan 200,000.00 200,000.00 200,000.00
Sundry Creditors 85,000.00 45,000.00 35,000.00 65,000.00

TOTAL ( A ) 465,700.00 820,293.00 1,049,928.00 1,365,588.00

B. ASSETS -

FIXED ASSETS 90,000.00 81,000.00 72,900.00 65,610.00

INVESTMENTS
Other Investment 145,000.00 360,000.00 640,000.00

CURRENT ASSETS
1. Closing Stock 158,700.00 332,500.00 338,000.00 342,000.00

2. Sundry Debtors 42,000.00 169,000.00 140,000.00 130,000.00

3. Loans & Advances 50,000.00 55,000.00 65,000.00 75,000.00

3. Cash & Bank Bal. 125,000.00 37,793.00 74,028.00 112,978.00

Total ( B ) 465,700.00 820,293.00 1,049,928.00 1,365,588.00

- - - -
M/S GOPAL HANDLOOM
PROP: MR. RAJESH KUMAR MOHANTY
KANSARIPARA SAMBALPUR

COMPARATIVE PROFIT & LOSS ACCOUNT

PARTICULARS ACTUAL ESTIMATED PROJECTED PROJECTED


2018-2019 2019-2020 2020-2021 2021-2022

SALES ( 1 ) 1,825,000.00 2,220,480.00 2,384,035.00 2,500,200.00

COST OF GOODS SOLD ( 2 )

Opening Stock 132,000.00 158,700.00 332,500.00 338,000.00

Add : Purchases 1,381,978.00 1,848,387.00 1,745,000.00 1,791,200.00

Total 1,513,978.00 2,007,087.00 2,077,500.00 2,129,200.00

Less : Closing Stock 158,700.00 332,500.00 338,000.00 342,000.00

Cost of Goods Sold ( 2 ) 1,355,278.00 1,674,587.00 1,739,500.00 1,787,200.00

GROSS PROFIT ( 1 - 2 ) 469,722.00 545,893.00 644,535.00 713,000.00

Add : Other Income ( 3 ) -

TOTAL INCOME ( 4 ) 469,722.00 545,893.00 644,535.00 713,000.00

Sales & Admn. Expenses ( 5 ) 164,122.00 181,300.00 204,900.00 212,340.00

P B T ( 4 - 5)+INTEREST 305,600.00 369,593.00 459,635.00 520,660.00

Less :Bank Interest ( 7 ) - 5,000.00 20,000.00 20,000.00

NET PROFIT ( 8 ) 305,600.00 364,593.00 439,635.00 500,660.00

Less: Drawings (9) 150,000.00 170,000.00 200,000.00 215,000.00

RETAINED PROFIT (10) 155,600.00 194,593.00 239,635.00 285,660.00

-
- - - -
M/S GOPAL HANDLOOM
PROP: MR. RAJESH KUMAR MOHANTY
KANSARIPARA SAMBALPUR

RATIO ANALAYSIS

PARTICULARS ACTUAL ESTIMATED PROJECTED PROJECTED


2018-2019 2019-2020 2020-2021 2021-2022

SALES 1,825,000.00 2,220,480.00 2,384,035.00 2,500,200.00

COST OF GOODS SOLD 1,355,278.00 1,674,587.00 1,739,500.00 1,787,200.00

GROSS PROFIT 469,722.00 545,893.00 644,535.00 713,000.00

NET PROFIT 305,600.00 364,593.00 439,635.00 500,660.00

TANGIBLE NET WORTH ( TNW ) 380,700.00 575,293.00 814,928.00 1,100,588.00

AVERAGE INVENTORY 145,350.00 245,600.00 335,250.00 340,000.00

SUNDRY DEBTORS 42,000.00 169,000.00 140,000.00 130,000.00

SUNDRY CREDITORS 85,000.00 45,000.00 35,000.00 65,000.00

TOTAL CURRENT ASSETS 375,700.00 594,293.00 617,028.00 659,978.00

TOTAL CURRENT LIABILITIES 85,000.00 245,000.00 235,000.00 265,000.00

NET WORKING CAPITAL ( NWC ) 290,700.00 349,293.00 382,028.00 394,978.00

GROSS PROFIT RATIO 26 25 27 29

NET PROFIT RATIO 17 16 18 20

STOCK TURNOVER RATIO 8.54 5.04 5.15 5.23

CURRENT RATIO 4.42 2.43 2.63 2.49

INTEREST SERVICE COVERAGE RATIO - 75.72 23.39 26.40

TOL/TNW 0.22 0.43 0.29 0.24


M/S GOPAL HANDLOOM
PROP: MR. RAJESH KUMAR MOHANTY
KANSARIPARA SAMBALPUR

WORKING CAPITAL ASSESSMENT

ESTIMATED PROJECTED PROJECTED


2019-2020 2020-2021 2021-2022

a. Sales turnover Estimated/ Projected 2,220,480.00 2,384,035.00 2,500,200.00


b. 25% of sales turnover 555,120.00 596,008.75 625,050.00
c. 5% of sales turnover projected as margin 111,024.00 119,201.75 125,010.00
d. Actual NWC existing( CA-CL) 349,293.00 382,028.00 394,978.00
e. b-c 444,096.00 476,807.00 500,040.00
f. b-d 205,827.00 213,980.75 230,072.00
g. MPBF (e or f) which ever is less 205,827.00 213,980.75 230,072.00

You might also like