[go: up one dir, main page]

0% found this document useful (0 votes)
5 views5 pages

Prema Project Report

pROJECT REPORT

Uploaded by

Dinesh Venkat
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
5 views5 pages

Prema Project Report

pROJECT REPORT

Uploaded by

Dinesh Venkat
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

PROJECT REPORT FOR BUSINESS INVESTMENT

DETAILS M/s. MARIAMMAN AGENCIES, Prop: [Link], D/o Mr. Sitharthan


No.14, Santhi Nagar, RTO Office Opposite,
Pillaiyarpatti Post,
Thanjavur - 613001
COST OF PROJECT (Rs. in Lakhs)

New Business Investments 6.83


Total 6.83

MEANS OF FINANCE

Term Loan repayable in Six years (Rate of Interest 11.10%) 6.50


Owners Contribution 0.33

Total 6.83

BANK LOAN REPAYMENT SCHEDULE

Opening Interest Closing


Year Balance Repaid Principal @ 11.10% Balance
I 6.50 0.59 0.35 0.24 6.15
II 6.15 1.76 1.08 0.68 5.07
III 5.07 1.76 1.20 0.56 3.87
IV 3.87 1.76 1.33 0.43 2.54
V 2.54 1.76 1.48 0.28 1.06
VI 1.06 1.17 1.06 0.11 0.00
PROJECTED PROFITABILITY STATEMENT FOR SIX YEARS
M/s. MARIAMMAN AGENCIES, Prop: [Link], D/o Mr. Sitharthan (Rs. in Lakhs)
--------------------------------------------------------------------------------------------
Year I II III IV V VI
--------------------------------------------------------------------------------------------

Sales 55.47 60.00 66.00 72.60 79.90 87.90 96.70


Closing Stock 6.58 12.00 12.50 13.00 13.50 14.00 14.50

---------------------------------------------------------------
Total GP 62.04 72.00 78.50 85.60 93.40 101.90 111.20
---------------------------------------------------------------

Opening Stock 3.23 6.58 12.00 12.50 13.00 13.50 14.00


Purchases 48.35 54.1 54.04 59.39 65.31 71.8 78.94
Salary & Bonus 0.86 0.95 1.00 1.10 1.20 1.30 1.40
Other Admin Expenses 2.70 2.58 2.37 2.69 3.04 3.42 3.84
Interest Expenses 0.00 0.24 0.68 0.56 0.43 0.28 0.11

---------------------------------------------------------------
Total Expenses 55.14 64.45 70.09 76.24 82.98 90.30 98.29
---------------------------------------------------------------

Net income 6.90 7.55 8.41 9.36 10.42 11.60 12.91

Taxes (assumed) 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Profit after tax 6.90 7.55 8.41 9.36 10.42 11.60 12.91
---------------------------------------------------------------
PROJECTED BALANCE SHEET FOR SIX YEARS (Rs. in Lakhs)
M/s. MARIAMMAN AGENCIES, Prop: [Link], D/o Mr. Sitharthan
--------------------------------------------------------------------------------------------
Year I II III IV V VI
--------------------------------------------------------------------------------------------
Capital Balance 11.47 14.35 17.26 20.62 24.54 29.14 34.55
Bank loan principal
Repayable within
Balance 5.07 3.87 2.54 1.06 0.00 0.00
One year 1.08 1.20 1.33 1.48 1.06 0.00
Sundry Creditors 2.57 2.00 1.50 1.00 0.50 0.00 0.00
---------------------------------------------------------------
14.04 22.50 23.83 25.49 27.58 30.20 34.55
---------------------------------------------------------------

Cash & Bank 0.89 0.94 0.99 1.04 1.09 1.14 1.19
Debtors/Investment 2.83 5.82 6.60 7.71 9.25 11.32 15.12
Advances & Deposits 0.30 0.30 0.30 0.30 0.30 0.30 0.30
Furniture & Fittings 0.62 0.62 0.62 0.62 0.62 0.62 0.62
Thalavadam 1.95 1.95 1.95 1.95 1.95 1.95 1.95
Two Wheeler 0.86 0.86 0.86 0.86 0.86 0.86 0.86
Closing Stock 6.58 12.00 12.50 13.00 13.50 14.00 14.50

---------------------------------------------------------------
14.04 22.50 23.83 25.49 27.58 30.20 34.55
---------------------------------------------------------------
PROJECTED CASH FLOW STATEMENT FOR SIX YEARS (Rs. in Lakhs)
M/s. MARIAMMAN AGENCIES, Prop: [Link], D/o Mr. Sitharthan
--------------------------------------------------------------------------------------------
Year I II III IV V VI
--------------------------------------------------------------------------------------------
CASH IN FLOWS AS PER INDIRECT METHOD (AS 3)

Profit after tax 7.55 8.41 9.36 10.42 11.60 12.91


Bank Interest 0.24 0.68 0.56 0.43 0.28 0.11
Decrease in Creditors -0.57 -0.50 -0.50 -0.50 -0.50 0.00
Bank loan 6.50
Owner Contribution 0.33
---------------------------------------------------------------
14.06 8.59 9.42 10.35 11.38 13.02
---------------------------------------------------------------

CASH OUT FLOWS AS PER INDIRECT METHOD (AS 3)

Loan Repaid 0.59 1.76 1.76 1.76 1.76 1.17


Increase-Drs/Investment 2.99 0.78 1.11 1.54 2.07 3.80
Increase in Stock 5.42 0.50 0.50 0.50 0.50 0.50
Drawings 5.00 5.50 6.00 6.50 7.00 7.50
---------------------------------------------------------------
14.00 8.54 9.37 10.30 11.33 12.97
---------------------------------------------------------------

Opening balance 0.89 0.94 0.99 1.04 1.09 1.14

Surplus/Deficit 0.05 0.05 0.05 0.05 0.05 0.05

Closing Balance 0.94 0.99 1.04 1.09 1.14 1.19

Note: We assume that all generating cash flow are reinvested into the
business by way of increasing Debtors/Investments
DEBT SERVICE COVERAGE RATIO (OVERALL) (Rs. in Lakhs)
--------------------------------------------------------------------------------------------
Year I II III IV V VI
--------------------------------------------------------------------------------------------

Profit after tax 7.55 8.41 9.36 10.42 11.60 12.91


Add: Bank Interest 0.24 0.68 0.56 0.43 0.28 0.11

Less: Drawings -5.00 -5.50 -6.00 -6.50 -7.00 -7.50

Cash accrual 2.79 3.59 3.92 4.35 4.88 5.52

Total repayment 0.59 1.76 1.76 1.76 1.76 1.17

DSC ratio 1.58 2.04 2.23 2.47 2.77 3.15

Average DSCR 2.37

You might also like