P ROJECT

REPORT
NAME : [Link]

PLACE OF BUSINESS PerumalKovil Street,

7th Ward, Kadambur Post,
Gangavallli Taluk,
Salem.

NATURE OF BUSINESS : Service Oriented

PRODUCT : Centering

PROJECT COST : 10,00,000

BANK LOAN : 9,50,000

OWN FUND : 50,000

DEPRECIATION : Nil

RATE OF INTEREST : 12.00%

EMI PERIOD : 60
MONTH
 AUTOMOBILES SPARES SHOP

PROJECT REPORT

Application Amount Sources Amount

Purchase of Materials 10,00,000 Term loan 9,50,000

Own fund 50,000

Total 10,00,000 Total 10,00,000

 CENTERING WORK

PROFITABILITY STATEMENT FOR THE YEAR ENDED (RS. IN '000'S)

YEAR I II III IV V

Gross Sales 5,082.00 5,473.31 5,801.71 6,091.80 6,396.39

Closing Stock 201.00 211.05 221.60 232.68 244.32

5,283.00 5,684.36 6,023.32 6,324.48 6,640.71

Opening Stock - 201.00 211.05 221.60 232.68

Purchase 4,308.00 4,437.24 4,703.47 4,938.65 5,185.58

Salary & Bonus 256.00 276.48 290.30 304.82 320.06

Power & Fuel Exps 96.00 110.40 115.92 121.72 127.80

Repairs &
Maintenance 26.25 28.88 30.32 31.83 33.43

Printing & Stationery 12.65 13.92 14.61 15.34 16.11

Telephone Expns. 18.57 20.43 21.45 22.52 23.65

General Exps 16.23 17.85 19.63 21.60 23.76

Interest on Term loan 112.18 87.48 62.78 35.15 13.38

Depreciation - - - - -

4,845.88 5,193.66 5,469.54 5,713.23 5,976.44

Profit before Tax 437.12 490.70 553.78 611.25 664.26

Less Income Tax - - - - -

Profit after Tax 437.12 490.70 553.78 611.25 664.26

Add Depreciation - - - - -

Cash Accruals 437.12 490.70 553.78 611.25 664.26

DSCR

I) Net Surplus 437.12 490.70 553.78 611.25 664.26

II) Depreciation - - - - -

III) Interest on TL 112.18 87.48 62.78 35.15 13.38

V) Repayment 190.00 190.00 190.00 190.00 190.00

of Loan

(I + II + III) 549.30 578.18 616.56 646.40 677.64

------------------- = 302.18 277.48 252.78 225.15 203.38

1.82 2.08 2.44 2.87 3.33

12.54
5.00

DSCR: 2.51
 C ASH FLOW STATEMENT (Rs. In '000's)

Years I II III IV V

Sources
Opg. Capital 50.00 - - - -

Term Loan 950.00 - - - -

Add Capital - - - - -

Cash Accruals 437.12 490.70 553.78 611.25 664.26

Total 1,437.12 490.70 553.78 611.25 664.26

Applications

Purchase of Materials 1,000.00 - - - -

Repayment of T.L 190.00 190.00 190.00 190.00 190.00

Increase of Stock 201.00 10.05 10.55 11.08 11.63

Drawings 10.00 70.00 75.00 80.00 90.00

Total 1,401.00 270.05 275.55 281.08 291.63

Opening Balance - 36.12 256.77 535.00 865.17

Net surplus 36.12 220.65 278.22 330.17 372.63

Closing Total 36.12 256.77 535.00 865.17 1,237.80

 B ALANCE SHEET (RS. '000'S)

Year I II III IV V

LIABILITIES

Opening Balance - 477.12 897.82 1,376.60 1,907.85

Own Fund 50.00 - - - -

Add Net surplus 437.12 490.70 553.78 611.25 664.26

487.12 967.82 1,451.60 1,987.85 2,572.12

Less Drawings 10.00 70.00 75.00 80.00 90.00

Closing Balance 477.12 897.82 1,376.60 1,907.85 2,482.12

Add Term Loan 760.00 570.00 380.00 190.00 -

Total 1,237.12 1,467.82 1,756.60 2,097.85 2,482.12

ASSETS

Purchase of Materials 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00

Closing Stock 201.00 211.05 221.60 232.68 244.32

Cash at Bank & Hand 36.12 256.77 535.00 865.17 1,237.80

Total 1,237.12 1,467.82 1,756.60 2,097.85 2,482.12

 L OAN REPAYMENT SCHEDULE
Term Loan Repayment

Installment [Link] Principal Interest Paid [Link]

13.00% Loan

1st Month 9,50,000 15,833 10,292 9,34,167

2nd Month 9,34,167 15,833 10,120 9,18,333
3rd Month 9,18,333 15,833 9,949 9,02,500
4th Month 9,02,500 15,833 9,777 8,86,667
5th Month 8,86,667 15,833 9,606 8,70,833
6th Month 8,70,833 15,833 9,434 8,55,000
7th Month 8,55,000 15,833 9,263 8,39,167
8th Month 8,39,167 15,833 9,091 8,23,333
9th Month 8,23,333 15,833 8,919 8,07,500
10th Month 8,07,500 15,833 8,748 7,91,667
11th Month 7,91,667 15,833 8,576 7,75,833
12th Month 7,75,833 15,833 8,405 7,60,000
1,90,000 1,12,179

13th Month 7,60,000 15,833 8,233 7,44,167

14th Month 7,44,167 15,833 8,062 7,28,333
15th Month 7,28,333 15,833 7,890 7,12,500
16th Month 7,12,500 15,833 7,719 6,96,667
17th Month 6,96,667 15,833 7,547 6,80,833
18th Month 6,80,833 15,833 7,376 6,65,000
19th Month 6,65,000 15,833 7,204 6,49,167
20th Month 6,49,167 15,833 7,033 6,33,333
21st Month 6,33,333 15,833 6,861 6,17,500
22nd Month 6,17,500 15,833 6,690 6,01,667
23rd Month 6,01,667 15,833 6,518 5,85,833
24th Month 5,85,833 15,833 6,347 5,70,000

1,90,000 87,479
 Term Loan Repayment

Installment [Link] Principal Interest Paid [Link]

13.00% Loan

25th Month 5,70,000 15,833 6,175 5,54,167

26th Month 5,54,167 15,833 6,003 5,38,333
27th Month 5,38,333 15,833 5,832 5,22,500
28th Month 5,22,500 15,833 5,660 5,06,667
29th Month 5,06,667 15,833 5,489 4,90,833
30th Month 4,90,833 15,833 5,317 4,75,000
31st Month 4,75,000 15,833 5,146 4,59,167
32nd Month 4,59,167 15,833 4,974 4,43,333
33rd Month 4,43,333 15,833 4,803 4,27,500
34th Month 4,27,500 15,833 4,631 4,11,667
35th Month 4,11,667 15,833 4,460 3,95,833
36th Month 3,95,833 15,833 4,288 3,80,000
1,90,000 62,779
37th Month 3,80,000 15,833 3,800 3,64,167
38th Month 3,64,167 15,833 3,642 3,48,333
39th Month 3,48,333 15,833 3,483 3,32,500
40th Month 3,32,500 15,833 3,325 3,16,667
41st Month 3,16,667 15,833 3,167 3,00,833
42nd Month 3,00,833 15,833 3,008 2,85,000
43rd Month 2,85,000 15,833 2,850 2,69,167
44th Month 2,69,167 15,833 2,692 2,53,333
45th Month 2,53,333 15,833 2,533 2,37,500
46th Month 2,37,500 15,833 2,375 2,21,667
47th Month 2,21,667 15,833 2,217 2,05,833
48th Month 2,05,833 15,833 2,058 1,90,000
1,90,000 35,150
49th Month 1,90,000 15,833 2,058 1,74,167
50th Month 1,74,167 15,833 1,887 1,58,333
51st Month 1,58,333 15,833 1,715 1,42,500
52nd Month 1,42,500 15,833 1,544 1,26,667
53rd Month 1,26,667 15,833 1,372 1,10,833
54th Month 1,10,833 15,833 1,201 95,000
55th Month 95,000 15,833 1,029 79,167
56th Month 79,167 15,833 858 63,333
57th Month 63,333 15,833 686 47,500
58th Month 47,500 15,833 515 31,667
59th Month 31,667 15,833 343 15,833
60th Month 15,833 15,833 172 -
1,90,000 13,379