Mamta Jha

Korba

BRIEF REPORT ON PROJECT COST OF VEHICLE

 Mamta Jha

UTILIZATION OF FUND

FIXED CAPITAL COST 59,00,000.00

59,00,000.00

WORKING CAPITAL COST -

59,00,000.00

MEANS OF FINANCE

BANK LOAN
TERM LOAN FINANCE 50,00,000.00 50,00,000.00
CASH CREDIT -

PROMOTER'S CONTRIBUTION 9,00,000.00

59,00,000.00
EMPLOYMENT DETAILS
Wages :
No. of Wages Amount in Rs.
Particulars
Worker Per Month (Per Annum)
Skilled labour 1 5000 60,000.00
Unskilled Labour 1 3000 36,000.00
0 0 0 -
0 0 0 -
0 0 0 -
0 0 0 -
0 0 0 -
Total 2 96,000.00

Repairs and Maintenance : Rs. -

Power and Fuel : Rs. -

Other Overhead Expenses : Rs. -

Administrative Expenses :
Salary
Manager 0 0 -
0 0 0 -
0 0 0 -
0 0 -
0 0 -
Total 0 -

Telephone Expenses -

Stationery & Postage -

Advertisement & Publicity -

Workshed Rent -

Other Miscellaneous Expenses 25,000.00

Total 25,000.00
 Mamta Jha
Korba

Projected Performance

Particulars YEAR - 1 YEAR - 2 YEAR - 3 YEAR - 4 YEAR - 5 YEAR - 6 YEAR - 7

Turnover( ESTIMATED) 25,35,220.00 45,65,250.00 49,30,470.00 53,24,907.60 57,50,900.21 62,10,972.22 67,07,850.00

Material 13,43,666.60 29,21,760.00 31,55,500.80 34,07,940.86 36,80,576.13 39,75,022.22 42,93,024.00
Electricity/ water exp 15,250.00 16,775.00 18,452.50 20,297.75 22,327.53 24,560.28 27,016.31
Depreciation 8,85,000.00 7,52,250.00 6,39,412.50 5,43,500.63 4,61,975.53 3,92,679.20 3,33,777.32
Sales tax/service tax( avg 5%) 6,980.00 82,174.50 88,748.46 95,848.34 1,03,516.20 1,11,797.50 1,20,741.30
Transport & conveyance 5,563.00 6,119.30 6,731.23 7,404.35 8,144.79 8,959.27 9,855.19
Total Cost of Production 22,56,459.60 37,79,078.80 39,08,845.49 40,74,991.93 42,76,540.18 45,13,018.47 47,84,414.12
Interest on CC Loan - - - - - - -
Interest on Term Loan 1,71,635.00 4,58,648.00 3,67,071.00 2,65,401.00 1,52,527.00 32,888.00 -
Office Expenses 14,250.00 15,675.00 17,242.50 18,966.75 20,863.43 22,949.77 25,244.74
Salary Exp. 47,560.00 52,316.00 57,547.60 63,302.36 69,632.60 76,595.86 84,255.44
Misc Exp 2,456.00 2,701.60 2,971.76 3,268.94 3,595.83 3,955.41 4,350.95
Less :- Closing Stock - - - - - - -
Total Costof Sale 24,92,360.60 43,08,419.40 43,53,678.35 44,25,930.97 45,23,159.03 46,49,407.51 48,98,265.26

NET CREDIT [A-B] 42,859.40 2,56,830.60 5,76,791.65 8,98,976.63 12,27,741.18 15,61,564.72 18,09,584.74
Profit before Taxation 42,859.40 2,56,830.60 5,76,791.65 8,98,976.63 12,27,741.18 15,61,564.72 18,09,584.74
Profit after Taxation 42,859.40 2,56,830.60 5,76,791.65 8,98,976.63 12,27,741.18 15,61,564.72 18,09,584.74
Bal carried over to Balance Sheet 42,859.40 2,56,830.60 5,76,791.65 8,98,976.63 12,27,741.18 15,61,564.72 18,09,584.74
 Mamta Jha
Korba

PROJECTED PROFITABILITY STATEMENT

YEARS YEAR - 1 YEAR - 2 YEAR - 3 YEAR - 4 YEAR - 5 YEAR - 6 YEAR - 7

INCOME

1 Turnover( ESTIMATED) 25,35,220.00 45,65,250.00 49,30,470.00 53,24,907.60 57,50,900.21 62,10,972.22 67,07,850.00

TOTAL (A) 25,35,220.00 45,65,250.00 49,30,470.00 53,24,907.60 57,50,900.21 62,10,972.22 67,07,850.00

2 Material & Direct labour 13,43,666.60 29,21,760.00 31,55,500.80 34,07,940.86 36,80,576.13 39,75,022.22 42,93,024.00
3 Electricity/ water exp 15,250.00 16,775.00 18,452.50 20,297.75 22,327.53 24,560.28 27,016.31
4 Interest on CC Loan - - - - - - -
5 Interest on Term Loan 1,71,635.00 4,58,648.00 3,67,071.00 2,65,401.00 1,52,527.00 32,888.00 -
6 Office Expenses 14,250.00 15,675.00 17,242.50 18,966.75 20,863.43 22,949.77 25,244.74
7 Salary Exp. 47,560.00 52,316.00 57,547.60 63,302.36 69,632.60 76,595.86 84,255.44
8 Depreciation 8,85,000.00 7,52,250.00 6,39,412.50 5,43,500.63 4,61,975.53 3,92,679.20 3,33,777.32
9 Misc expenses 2,456.00 2,701.60 2,971.76 3,268.94 3,595.83 3,955.41 4,350.95
10 Sales tax/service tax( avg 5%) 6,980.00 82,174.50 88,748.46 95,848.34 1,03,516.20 1,11,797.50 1,20,741.30
11 Transport & conveyance 5,563.00 6,119.30 6,731.23 7,404.35 8,144.79 8,959.27 9,855.19
12 Stores - - - - - - -

TOTAL (B) 24,92,360.60 43,08,419.40 43,53,678.35 44,25,930.97 45,23,159.03 46,49,407.51 48,98,265.26

NET CREDIT [A-B] 42,859.40 2,56,830.60 5,76,791.65 8,98,976.63 12,27,741.18 15,61,564.72 18,09,584.74
Opening stock - - - - - - -
Closing stock - - - - - - -
Stock adjustment - - - - - - -
Profit before Taxation 42,859.40 2,56,830.60 5,76,791.65 8,98,976.63 12,27,741.18 15,61,564.72 18,09,584.74
Withdrawal during the year - - - 2,00,000.00 2,00,000.00 2,00,000.00 2,00,000.00
Profit after Taxation 42,859.40 2,56,830.60 5,76,791.65 6,98,976.63 10,27,741.18 13,61,564.72 16,09,584.74
Bal carried over to Balance Sheet 42,859.40 2,99,690.00 8,76,481.65 15,75,458.28 26,03,199.45 39,64,764.17 55,74,348.91
 Mamta Jha
Korba

BALANCE SHEET
YEARS YEAR - 1 YEAR - 2 YEAR - 3 YEAR - 4 YEAR - 5 YEAR - 6 YEAR - 7

LIABILITIES

Capital 9,00,000.00 9,00,000.00 9,00,000.00 9,00,000.00 9,00,000.00 9,00,000.00 9,00,000.00

Reseve & Surplus 42,859.40 2,99,690.00 8,76,481.65 15,75,458.28 26,03,199.45 39,64,764.17 55,74,348.91
CC Loan - - - - - - -
Term Loan 47,41,757.00 39,10,771.00 29,88,208.00 19,63,975.00 8,26,868.00 - -
Sundry Creditors 2,65,350.00 2,89,231.50 3,15,262.34 3,43,635.95 3,74,563.18 4,08,273.87 4,45,018.51

TOTAL 59,49,966.40 53,99,692.50 50,79,951.99 47,83,069.22 47,04,630.63 52,73,038.04 69,19,367.43

ASSETS

Net Fixed Assets (W.D.V.) 50,15,000.00 42,62,750.00 36,23,337.50 30,79,836.88 26,17,861.34 22,25,182.14 18,91,404.82
Advance & Deposits 3,52,500.00 3,87,750.00 4,26,525.00 4,69,177.50 5,65,250.00 8,58,500.00 9,44,350.00
Net Current Assets (Debt &Others) 4,25,025.00 6,25,250.00 6,81,522.50 7,42,859.53 8,09,716.88 8,09,716.88 8,82,591.40
Cash & Bank Bal. 1,57,441.40 1,23,942.50 3,48,566.99 4,91,195.32 7,11,802.41 13,79,639.01 32,01,021.20

TOTAL 59,49,966.40 53,99,692.50 50,79,951.99 47,83,069.22 47,04,630.63 52,73,038.04 69,19,367.43

 Mamta Jha
Korba

CALCULATION OF ESTIMATED DEPRECIATION

Fixed Assets & Depreciation Chart

Particulars Rate WDV as on Balance as on Dep. WDV as on

Year Opening Year Ending Claimed Year Ending

Plant & Machinery 15% 59,00,000.00 59,00,000.00 8,85,000.00 50,15,000.00

Furniture & Fixtures 10% - - - -
Shop Equipments 10% - - - -
Land & Building 5% - - - -

Total 59,00,000.00 59,00,000.00 8,85,000.00 50,15,000.00

Particulars Rate WDV as on Balance as on Dep. WDV as on

Year Opening Year Ending Claimed Year Ending

Plant & Machinery 15% 50,15,000.00 50,15,000.00 7,52,250.00 42,62,750.00

Furniture & Fixtures 10% - - - -
Office Equipments 10% - - - -
Land & Building 5% - - - -

Total 50,15,000.00 50,15,000.00 7,52,250.00 42,62,750.00

Particulars Rate WDV as on Balance as on Dep. WDV as on

Year Opening Year Ending Claimed Year Ending

Plant & Machinery 15% 42,62,750.00 42,62,750.00 6,39,412.50 36,23,337.50

Furniture & Fixtures 10% - - - -
Office Equipments 10% - - - -
Land & Building 5% - - - -

Total 42,62,750.00 42,62,750.00 6,39,412.50 36,23,337.50

Particulars Rate WDV as on Balance as on Dep. WDV as on

Year Opening Year Ending Claimed Year Ending

Plant & Machinery 15% 36,23,337.50 36,23,337.50 5,43,500.63 30,79,836.88

Furniture & Fixtures 10% - - - -
Office Equipments 10% - - - -
Land & Building 5% - - - -

Total 36,23,337.50 36,23,337.50 5,43,500.63 30,79,836.88

Particulars Rate WDV as on Balance as on Dep. WDV as on

Year Opening Year Ending Claimed Year Ending

Plant & Machinery 15% 30,79,836.88 30,79,836.88 4,61,975.53 26,17,861.34

Furniture & Fixtures 10% - - - -
Office Equipments 10% - - - -
Land & Building 5% - - - -

Total 30,79,836.88 30,79,836.88 4,61,975.53 26,17,861.34

Particulars Rate WDV as on Balance as on Dep. WDV as on

Year Opening Year Ending Claimed Year Ending

Plant & Machinery 15% 26,17,861.34 26,17,861.34 3,92,679.20 22,25,182.14

Furniture & Fixtures 10% - - - -
Office Equipments 5% - - - -
Land & Building 5% - - - -

Total 26,17,861.34 26,17,861.34 3,92,679.20 22,25,182.14

Particulars Rate WDV as on Balance as on Dep. WDV as on

Year Opening Year Ending Claimed Year Ending

Plant & Machinery 15% 22,25,182.14 22,25,182.14 3,33,777.32 18,91,404.82

Furniture & Fixtures 10% - - - -
Office Equipments 10% - - - -
Land & Building 5% - - - -

Total 22,25,182.14 22,25,182.14 3,33,777.32 18,91,404.82

 Mamta Jha
Korba

PROJECTED CASH FLOW STATEMENT

YEARS YEAR - 1 YEAR - 2 YEAR - 3 YEAR - 4 YEAR - 5 YEAR - 6 YEAR - 7

SOURCES
PBIT 2,14,494.40 7,15,478.60 9,43,862.65 9,64,377.63 11,80,268.18 13,94,452.72 16,09,584.74
Depreciation 8,85,000.00 7,52,250.00 6,39,412.50 5,43,500.63 4,61,975.53 3,92,679.20 3,33,777.32
Increase in Capital 9,00,000.00 - - - - - -
Increase in Cash Credit - - - - - - -
Increase in term loan 47,41,757.00 (8,30,986.00) (9,22,563.00) (10,24,233.00) (11,37,107.00) (8,26,868.00) -
Decrease in Current Assets (4,25,025.00) (2,00,225.00) (56,272.50) (61,337.03) (66,857.36) - (72,874.52)
Decrease in Advance & Deposits (3,52,500.00) (35,250.00) (38,775.00) (42,652.50) (96,072.50) (2,93,250.00) (85,850.00)

TOTAL [A] 59,63,726.40 4,01,267.60 5,65,664.65 3,79,655.73 3,42,206.85 6,67,013.92 17,84,637.54

APPLICATION
Increase in Fixed Assets 59,00,000.00 - - - - -
Interest on Bank Loan 1,71,635.00 4,58,648.00 3,67,071.00 2,65,401.00 1,52,527.00 32,888.00 -
decrease in Current Laiblity (2,65,350.00) (23,881.50) (26,030.84) (28,373.61) (30,927.24) (33,710.69) (36,744.65)

TOTAL [B] 58,06,285.00 4,34,766.50 3,41,040.17 2,37,027.39 1,21,599.76 (822.69) (36,744.65)

Opening Cash Balance - 1,57,441.40 1,23,942.50 3,48,566.99 4,91,195.32 7,11,802.41 13,79,639.01
Net Surplus / Deficit [A-B] 1,57,441.40 (33,498.90) 2,24,624.48 1,42,628.34 2,20,607.09 6,67,836.61 18,21,382.19
Closing Cash Balance 1,57,441.40 1,23,942.50 3,48,566.99 4,91,195.32 7,11,802.41 13,79,639.01 32,01,021.20

- (0.00) - (0.00) - - -
 Mamta Jha
Korba

CALCULATION OF INTEREST ON TERM LOAN

YEAR YEAR - 1 YEAR - 2 YEAR - 3 YEAR - 4 YEAR - 5 YEAR - 6 YEAR - 7

CC LOAN INTEREST - - - - - - -
TERM LOAN INTEREST 1,71,635.00 4,58,648.00 3,67,071.00 2,65,401.00 1,52,527.00 32,888.00 -

TOTAL INTEREST 1,71,635.00 4,58,648.00 3,67,071.00 2,65,401.00 1,52,527.00 32,888.00 -

WORKING CAPITAL LOAN

OPENING INSTALLMENT CLOSING
YEAR PRINCIPAL INTEREST
BALANCE PAID BALANCE
1 - 0 0 - -
2 - 0 0 - -
3 - 0 0 - -
4 - 0 0 - -
5 - 0 0 - -
6 - 0 0 - -
7 - 0 0 - -

TERM LOAN
OPENING INSTALLMENT CLOSING
YEAR PRINCIPAL INTEREST
BALANCE PAID BALANCE
1 50,00,000.00 4,29,878.00 2,58,243.00 1,71,635.00 47,41,757.00
2 47,41,757.00 12,89,634.00 8,30,986.00 4,58,648.00 39,10,771.00
3 39,10,771.00 12,89,634.00 9,22,563.00 3,67,071.00 29,88,208.00
4 29,88,208.00 12,89,634.00 10,24,233.00 2,65,401.00 19,63,975.00
5 19,63,975.00 12,89,634.00 11,37,107.00 1,52,527.00 8,26,868.00
6 8,26,868.00 8,59,756.00 8,26,868.00 32,888.00 -
7 - - - - -
 Mamta Jha
Korba
CALCULATION OF SOME IMPORTANT RATIOS
PARTICULARS YEAR - 1 YEAR - 2 YEAR - 3 YEAR - 4 YEAR - 5 YEAR - 6 YEAR - 7

NET PROFIT (PAT) 42,859.40 2,56,830.60 5,76,791.65 6,98,976.63 10,27,741.18 13,61,564.72 16,09,584.74
INTEREST ON CC LOAN - - - - - - -
INTEREST ON Term Loan 1,71,635.00 4,58,648.00 3,67,071.00 2,65,401.00 1,52,527.00 32,888.00 -
INCOME TAX - - - - -

TOTAL (X) (PBIT) 2,14,494.40 7,15,478.60 9,43,862.65 9,64,377.63 11,80,268.18 13,94,452.72 16,09,584.74

INTEREST ON CC LOAN - - - - - - -
INTEREST ON Term Loan 1,71,635.00 4,58,648.00 3,67,071.00 2,65,401.00 1,52,527.00 32,888.00 -

TOTAL (Y) 1,71,635.00 4,58,648.00 3,67,071.00 2,65,401.00 1,52,527.00 32,888.00 -

INTREST SERIVCE COVERAGE 1.25 1.56 2.57 3.63 7.74 42.40 #DIV/0!
RATIO ( X/Y)

NET PROFIT 42,859.40 2,56,830.60 5,76,791.65 6,98,976.63 10,27,741.18 13,61,564.72 16,09,584.74

SALES 25,35,220.00 45,65,250.00 49,30,470.00 53,24,907.60 57,50,900.21 62,10,972.22 67,07,850.00

NET PROFIT/ SALES 0.02 0.06 0.12 0.13 0.18 0.22 0.24

PBIT 2,14,494.40 7,15,478.60 9,43,862.65 9,64,377.63 11,80,268.18 13,94,452.72 16,09,584.74

DEPRECIATION 8,85,000.00 7,52,250.00 6,39,412.50 5,43,500.63 4,61,975.53 3,92,679.20 3,33,777.32
PBDIT 10,99,494.40 14,67,728.60 15,83,275.15 15,07,878.25 16,42,243.71 17,87,131.92 19,43,362.06

TOTAL ASSETS 59,49,966.40 53,99,692.50 50,79,951.99 47,83,069.22 47,04,630.63 52,73,038.04 69,19,367.43

I.S.C.R. 0.18 0.27 0.31 0.32 0.35 0.34 0.28

NET SALES (O) 25,35,220.00 45,65,250.00 49,30,470.00 53,24,907.60 57,50,900.21 62,10,972.22 67,07,850.00

CC LOAN - - - - - - -
Term laon 47,41,757.00 39,10,771.00 29,88,208.00 19,63,975.00 8,26,868.00 - -

TOTAL BANK BORROWING ( P) 47,41,757.00 39,10,771.00 29,88,208.00 19,63,975.00 8,26,868.00 - -

NET SALES/ BANK BORROWING 0.53 1.17 1.65 2.71 6.96 #DIV/0! #DIV/0!

CURRENT ASSETS 5,82,466.40 7,49,192.50 10,30,089.49 12,34,054.85 15,21,519.29 21,89,355.89 40,83,612.60

CURRENT LAIBLITIES 2,65,350.00 2,89,231.50 3,15,262.34 3,43,635.95 3,74,563.18 4,08,273.87 4,45,018.51
CA/CL - CURRENT RATIO 2.20 2.59 3.27 3.59 4.06 5.36 9.18

DEBT 47,41,757.00 39,10,771.00 29,88,208.00 19,63,975.00 8,26,868.00 - -

EQUITY 9,42,859.40 11,99,690.00 17,76,481.65 24,75,458.28 35,03,199.45 48,64,764.17 64,74,348.91
DEBT/EQUITY - D/E RATIO 5.03 3.26 1.68 0.79 0.24 - -

TOTAL OUTSIDE LAIBLITY 50,07,107.00 42,00,002.50 33,03,470.34 23,07,610.95 12,01,431.18 4,08,273.87 4,45,018.51
TOTAL NETWORTH 9,42,859.40 11,99,690.00 17,76,481.65 24,75,458.28 35,03,199.45 48,64,764.17 64,74,348.91
TOL/TNW RATIO 5.31 3.50 1.86 0.93 0.34 0.08 0.07
 Mamta Jha
Korba

CALCULATION OF DSCR

YEARS YEAR - 1 YEAR - 2 YEAR - 3 YEAR - 4 YEAR - 5 YEAR - 6

A. Net Profit after Tax 42,859.40 2,56,830.60 5,76,791.65 6,98,976.63 10,27,741.18 13,61,564.72
B. Depreciation 8,85,000.00 7,52,250.00 6,39,412.50 5,43,500.63 4,61,975.53 3,92,679.20
C. Interest on Working loan - - - - - -
D. Interest on Term Loan 1,71,635.00 4,58,648.00 3,67,071.00 2,65,401.00 1,52,527.00 32,888.00

TOTAL [X] 10,99,494.40 14,67,728.60 15,83,275.15 15,07,878.25 16,42,243.71 17,87,131.92

E. Instalment of Term Loan 2,58,243.00 8,30,986.00 9,22,563.00 10,24,233.00 11,37,107.00 8,26,868.00

F Instalment of Working Capital - - - - - -
G Interest on Working loan - - - - - -
H Interest on Term Loan 1,71,635.00 4,58,648.00 3,67,071.00 2,65,401.00 1,52,527.00 32,888.00

TOTAL [Y] 4,29,878.00 12,89,634.00 12,89,634.00 12,89,634.00 12,89,634.00 8,59,756.00

DSCR = [X] / [Y] 2.56 1.14 1.23 1.17 1.27 2.08

AVERAGE DSCR 1.57