Mangalore Paints Trading Project Plan
Mangalore Paints Trading Project Plan
CONSTITUITION : Proprietor
DERAILS OF THE PROMOTER : Promotor is an Individual who is associated with the persons in
this field of Marketting and Works of Interior Designs and
Painting for the past 10 years.
The Promotor is in the need of financial assistance to expand her business, So she has approached the
bank.
CONCLUSION
The above project is technically feasible and econmically viable as evidenced by the working provided.
INDEX Page No.
Details of Investments 1
Balance Sheet 4
DSCR Ratio 6
Other Ratios 7
MEANS OF FINANCE:
01. LOAN FROM THE BANK 15,00,000.00
02. PROMOTORS CONTRIBUTION 10,00,000.00
25,00,000.00
Herick Saldanha
Merlapadav House, Farangipete Post, , Mangalore – 574143
PROPOSED REPAYMENT SCHEDULE
Notes:
Interest on loan in considered at 12% (Highest Rate as per Bank)
Total repayment schedule is assumend at 24months with 0 months of repayment holiday
For the convinience and understanding, and also for the depicting the true and fare
picture of the project , we have now considering the repayments to be presented quarterly.
Herick Saldanha
Merlapadav House, Farangipete Post, , Mangalore – 574143
PROJECTED QUARTERLY PROFIT & LOSS ACCOUNT CONSOLIDATED STATEMENT
PARTICULARS Y1Q1 Y1Q2 Y1Q3 Y1Q4 TOTAL
INCOME
Sale of Material and Services (Note 1) 10,75,000.00 21,50,000.00 32,25,000.00 43,00,000.00 1,07,50,000.00
Closing Stock 13,71,000.00 12,63,000.00 9,75,000.00 5,08,000.00 5,08,000.00
A 24,46,000.00 34,13,000.00 42,00,000.00 48,08,000.00 1,12,58,000.00
Trading Expenses:
Opening Stock - 13,71,000.00 12,63,000.00 9,75,000.00 -
Purchase of Materials (Note 2) 15,00,000.00 5,00,000.00 5,00,000.00 5,00,000.00 30,00,000.00
Direct Expenses (Note 3) 75,000.00 25,000.00 25,000.00 25,000.00 1,50,000.00
Wages and Salaries (Note 4) 4,08,500.00 8,17,000.00 12,25,500.00 16,34,000.00 40,85,000.00
B 19,83,500.00 27,13,000.00 30,13,500.00 31,34,000.00 72,35,000.00
TRADE PROFIT (A-B) C 4,62,500.00 7,00,000.00 11,86,500.00 16,74,000.00 40,23,000.00
Operative/Direct Expenses:
Marketting Expenses (Note 5) 64,500.00 1,12,875.00 1,61,250.00 2,09,625.00 5,48,250.00
Travelling and Conveyance (Note 6) 1,93,500.00 2,41,875.00 2,90,250.00 3,38,625.00 10,64,250.00
D 2,58,000.00 3,54,750.00 4,51,500.00 5,48,250.00 16,12,500.00
GROSS PROFIT (C-D) E 2,04,500.00 3,45,250.00 7,35,000.00 11,25,750.00 24,10,500.00
Administrative Expenses:
Salary and Employee Cost (Note 7) 75,000.00 75,000.00 75,000.00 2,25,000.00 4,50,000.00
ESI and PF Contribution (Note 8) 11,800.00 11,800.00 11,800.00 35,400.00 70,800.00
Office Expenses (Note 9) 5,000.00 5,500.00 6,100.00 6,700.00 23,300.00
Other Expenses (Note 10) 8,250.00 9,100.00 10,000.00 11,000.00 38,350.00
F 1,00,050.00 1,01,400.00 1,02,900.00 2,78,100.00 5,82,450.00
PROFIT BEFORE INTEREST AND
DEPRECIATION G 1,04,450.00 2,43,850.00 6,32,100.00 8,47,650.00 18,28,050.00
Interest on Term Loan H 43,326.00 38,220.00 32,959.00 27,539.00 1,42,044.00
PROFIT BEFORE DEPRECIATION I 61,124.00 2,05,630.00 5,99,141.00 8,20,111.00 16,86,006.00
Depreciation J 25,000.00 33,750.00 28,688.00 24,384.00 1,11,822.00
NET PROFIT K 36,124.00 1,71,880.00 5,70,453.00 7,95,727.00 15,74,184.00
Income Tax (Note 11) L 9,031.00 42,970.00 1,42,613.25 1,98,931.75 3,93,546.00
PROFIT AFTER TAX M 27,093.00 1,28,910.00 4,27,839.75 5,96,795.25 11,80,638.00
PARTICULARS Y2Q1 Y2Q2 Y2Q3 Y2Q4 TOTAL
INCOME
Sale of Material and Services (Note 1) 53,75,000.00 64,50,000.00 75,25,000.00 86,00,000.00 2,79,50,000.00
Closing Stock 4,12,000.00 1,37,000.00 3,83,000.00 2,00,000.00 2,00,000.00
A 57,87,000.00 65,87,000.00 79,08,000.00 88,00,000.00 2,81,50,000.00
Trading Expenses:
Opening Stock 5,08,000.00 4,12,000.00 1,37,000.00 3,83,000.00 5,08,000.00
Purchase of Materials (Note 2) 8,00,000.00 8,00,000.00 15,00,000.00 15,00,000.00 46,00,000.00
Direct Expenses (Note 3) 40,000.00 40,000.00 75,000.00 75,000.00 2,30,000.00
Wages and Salaries (Note 4) 20,42,500.00 24,51,000.00 28,59,500.00 32,68,000.00 1,06,21,000.00
B 33,90,500.00 37,03,000.00 45,71,500.00 52,26,000.00 1,59,59,000.00
TRADE PROFIT (A-B) C 23,96,500.00 28,84,000.00 33,36,500.00 35,74,000.00 1,21,91,000.00
Operative/Direct Expenses:
Marketting Expenses (Note 5) 2,58,000.00 3,06,375.00 3,54,750.00 4,03,125.00 13,22,250.00
Travelling and Conveyance (Note 6) 3,87,000.00 4,35,375.00 4,83,750.00 5,32,125.00 18,38,250.00
D 6,45,000.00 7,41,750.00 8,38,500.00 9,35,250.00 31,60,500.00
GROSS PROFIT (C-D) E 17,51,500.00 21,42,250.00 24,98,000.00 26,38,750.00 90,30,500.00
Administrative Expenses:
Salary and Employee Cost (Note 7) 82,500.00 82,500.00 82,500.00 82,500.00 3,30,000.00
ESI and PF Contribution (Note 8) 13,000.00 13,000.00 13,000.00 13,000.00 52,000.00
Office Expenses (Note 9) 7,400.00 8,100.00 8,900.00 9,800.00 34,200.00
Other Expenses (Note 10) 12,100.00 13,300.00 14,600.00 16,100.00 56,100.00
F 1,15,000.00 1,16,900.00 1,19,000.00 1,21,400.00 4,72,300.00
PROFIT BEFORE INTEREST AND
DEPRECIATION G 16,36,500.00 20,25,350.00 23,79,000.00 25,17,350.00 85,58,200.00
Interest on Term Loan H 21,954.00 16,202.00 10,274.00 4,166.00 52,596.00
PROFIT BEFORE DEPRECIATION I 16,14,546.00 20,09,148.00 23,68,726.00 25,13,184.00 85,05,604.00
Depreciation J 20,727.00 17,618.00 14,975.00 12,729.00 66,049.00
NET PROFIT K 15,93,819.00 19,91,530.00 23,53,751.00 25,00,455.00 84,39,555.00
Income Tax (Note 11) L 3,98,454.75 4,97,882.50 5,88,437.75 6,25,113.75 21,09,888.75
PROFIT AFTER TAX M 11,95,364.25 14,93,647.50 17,65,313.25 18,75,341.25 63,29,666.25
The above financials are prepared for the stand alone business generated by the amount from the bank finances, and its reutilization in to business
Herick Saldanha
Merlapadav House, Farangipete Post, , Mangalore – 574143
CONSOLIDATED QUARTERLY BALANCE SHEET
PARTICULARS Y1Q1 Y1Q2 Y1Q3 Y1Q4
ASSETS
Fixed Assets 2,50,000.00 2,25,000.00 1,91,250.00 1,62,562.00
Less: Depreciation (Note 12) 25,000.00 33,750.00 28,688.00 24,384.00
Net Fixed Asset 1 2,25,000.00 1,91,250.00 1,62,562.00 1,38,178.00
Current Assets
Receivables 2 1,61,250.00 3,22,500.00 4,83,750.00 6,45,000.00
Stocks in Hand 13,71,000.00 12,63,000.00 9,75,000.00 5,08,000.00
Cash in hand and Bank 3 7,83,357.00 5,36,793.00 8,47,553.75 15,23,064.00
TOTAL ASSETS(1+2+3) 25,40,607.00 23,13,543.00 24,68,865.75 28,14,242.00
LIABILITIES
Capital Account
Opening Balance - 9,95,711.00 10,61,857.00 13,95,550.75
Add: Introduced 10,00,000.00 -
Net Profit 27,093.00 1,28,910.00 4,27,839.75 5,96,795.25
10,27,093.00 11,24,621.00 14,89,696.75 19,92,346.00
Less: Drawings (Note 13) 31,382.00 62,764.00 94,146.00 1,25,528.00
4 9,95,711.00 10,61,857.00 13,95,550.75 18,66,818.00
LIABILITIES
Capital Account
Opening Balance 18,66,818.00 29,05,272.25 42,10,627.75 57,56,267.00
Add: Introduced - -
Net Profit 11,95,364.25 14,93,647.50 17,65,313.25 18,75,341.25
30,62,182.25 43,98,919.75 59,75,941.00 76,31,608.25
Less: Drawings (Note 13) 1,56,910.00 1,88,292.00 2,19,674.00 2,51,056.00
4 29,05,272.25 42,10,627.75 57,56,267.00 73,80,552.25
The above financials are prepared for the stand alone business generated by the amount from the bank finances, and its reutilization in to business
Herick Saldanha
Merlapadav House, Farangipete Post, , Mangalore – 574143
CONSOLIDATED QUARTERLY CASH FLOW STATEMENT
PARTICULARS Y1Q1 Y1Q2 Y1Q3 Y1Q4 TOTAL
INFLOW
Bank finance 15,00,000.00 - - - 15,00,000.00
Promotor's Margine 10,00,000.00 - - - 10,00,000.00
Sale of Material and Services (Note 1) 9,13,750.00 19,88,750.00 30,63,750.00 41,38,750.00 1,01,05,000.00
TOTAL INFLOW 1 34,13,750.00 19,88,750.00 30,63,750.00 41,38,750.00 1,26,05,000.00
OUTFLOW -
Investment in Fixed Assets 2,50,000.00 - - - 2,50,000.00
Purchase of Medicine 13,20,000.00 6,20,000.00 5,00,000.00 5,00,000.00 29,40,000.00
Other Trading Expenses 4,83,500.00 8,42,000.00 12,50,500.00 16,59,000.00 42,35,000.00
Operative Expenses 2,58,000.00 3,54,750.00 4,51,500.00 5,48,250.00 16,12,500.00
Administrative expenses 66,650.00 1,01,000.00 1,02,400.00 2,19,700.00 4,89,750.00
Repayment of Loan (As per Sche.) 2,11,830.00 2,11,830.00 2,11,830.00 2,11,830.00 8,47,320.00
Drawings (Note 13) 31,382.00 62,764.00 94,146.00 1,25,528.00 3,13,820.00
Income Tax (Note 11) 9,031.00 42,970.00 1,42,613.25 1,98,931.75 3,93,546.00
TOTAL OUTFLOW 2 26,30,393.00 22,35,314.00 27,52,989.25 34,63,239.75 -
Surplus 3 7,83,357.00 -2,46,564.00 3,10,760.75 6,75,510.25 15,23,064.00
Opening Cash/Bank 4 - 7,83,357.00 5,36,793.00 8,47,553.75 -
Closing Cash/Bank 5 7,83,357.00 5,36,793.00 8,47,553.75 15,23,064.00 15,23,064.00
PARTICULARS Y2Q1 Y2Q2 Y2Q3 Y2Q4 TOTAL
INFLOW
Bank finance - - - - -
Promotor's Margine - - - - -
Interest on Term Loan 52,13,750.00 62,88,750.00 73,63,750.00 84,38,750.00 2,73,05,000.00
TOTAL INFLOW 1 52,13,750.00 62,88,750.00 73,63,750.00 84,38,750.00 2,73,05,000.00
OUTFLOW
Investment in Fixed Assets - - - - -
Purchase of Medicine 7,64,000.00 8,00,000.00 14,16,000.00 15,00,000.00 44,80,000.00
Other Trading Expenses 20,82,500.00 24,91,000.00 29,34,500.00 33,43,000.00 1,08,51,000.00
Operative Expenses 6,45,000.00 7,41,750.00 8,38,500.00 9,35,250.00 31,60,500.00
Administrative expenses 1,69,400.00 1,16,200.00 1,18,300.00 1,20,600.00 5,24,500.00
Repayment of Loan (As per Sche.) 2,11,830.00 2,11,830.00 2,11,830.00 2,11,830.00 8,47,320.00
Drawings (Note 13) 1,56,910.00 1,88,292.00 2,19,674.00 2,51,056.00 8,15,932.00
Income Tax (Note 11) 3,98,454.75 4,97,882.50 5,88,437.75 6,25,113.75 21,09,888.75
TOTAL OUTFLOW 2 44,28,094.75 50,46,954.50 63,27,241.75 69,86,849.75 2,27,89,140.75
Surplus 3 7,85,655.25 12,41,795.50 10,36,508.25 14,51,900.25 45,15,859.25
Opening Cash/Bank 4 15,23,064.00 23,08,719.25 35,50,514.75 45,87,023.00 15,23,064.00
Closing Cash/Bank 5 23,08,719.25 35,50,514.75 45,87,023.00 60,38,923.25 60,38,923.25
The above financials are prepared for the stand alone business generated by the amount from the bank finances, and its reutilization in to business
Herick Saldanha
Merlapadav House, Farangipete Post, , Mangalore – 574143
CONSOLIDATED STATEMENT SHOWING CALCULATION OF QUARTERLY DSCR
PARTICULARS Y1Q1 Y1Q2 Y1Q3 Y1Q4 TOTAL
INCOME
Net Profit After Tax 27,093.00 1,28,910.00 4,27,839.75 5,96,795.25 11,80,638.00
Depreciation (Note 12) 25,000.00 33,750.00 28,688.00 24,384.00 1,11,822.00
Interest on Term Loan (As per Schedule) 43,326.00 38,220.00 32,959.00 27,539.00 1,42,044.00
TOTAL A 95,419.00 2,00,880.00 4,89,486.75 6,48,718.25 14,34,504.00
-
Promotors' Drawing 31,382.00 62,764.00 94,146.00 1,25,528.00 3,13,820.00
Repayment of loans 2,11,830.00 2,11,830.00 2,11,830.00 2,11,830.00 8,47,320.00
TOTAL B 2,43,212.00 2,74,594.00 3,05,976.00 3,37,358.00 11,61,140.00
Net Profit to Sales Ratio 1.11% 3.78% 10.19% 12.41% 6.87% 20.66% 22.68% 22.32% 21.31% 21.74%
- -
Profit before Int. Dep and Tax to Sales Ratio 4.27% 7.14% 15.05% 17.63% 11.02% 28.28% 30.75% 30.08% 28.61% 29.43%
- -
Debt to Equity Ratio 1.34 1.09 0.70 0.43 0.89 0.21 0.10 0.04 - 0.09
- -
EBIDT to Sales Ratio 4.27% 7.14% 15.05% 17.63% 11.02% 28.28% 30.75% 30.08% 28.61% 29.43%
- -
DCER 0.39 0.73 1.60 1.92 1.24 3.36 3.82 4.15 4.09 3.88
The above financials are prepared for the stand alone business generated by the amount from the bank finances, and its reutilization in to business
Our Net Profir margine we have kept very reasonable as 25%, whereas the actual Net profit in the market is around 50%.
Note 2:
Purchase of Materials is the core product of this trade, for initial sale consumption, we are
estimating a need of 15,00,000 worth of cost. And 5,00,000 each in each quarter to fuel up the
sales. Also, we intend and presume that our sales go so up that we will have to buy for about
15,00,000 worth products every quarter by 2nd year end.
Note 3:
Direct Expenses are the labour and waorkers benefit cost. We would by buying the product as
mentioned supra in Note 2, and it would cost us about 5% on the cost of goods.
Note 4:
Labour Charges is the cost of salary we would have to assign for the labours and workers.
Note 5:
Selling and Marketing Expenses are a kind of incentive we pay for our staff and marketing
team for aproaching our Co-managers and customers. It is by our staff who gets our major
customers that we get the sales generated. This is a kind of Key person commission. Initial
Commission we have fixed at 6% but from Q2, we are planning to tripple it considering the
performence of the employees.
Note 6:
Travelling Expense is the re-imbursement of cost of our marketting team. We have assumed
and assertained this to be at around 18% to the sales.
Note 7:
Salary and Employee cost is the salary we pay for the office staff. And on 4th Quarter we are
planning to hoist a development program to our staff for quality improvements as well.
Note 8:
ESI is 3.75% of Wages as per Govt Regulations. And EPF at 12% we are planning to extend
for full salary.
Note 9:
Office expense related to the office maintenance.
Note 10:
Miscellaneous Office expenses for day to day expenses.
Note 11:
Income tax is estimated at 25% of net profit.
Note 12:
We believe that we would need bout 2,50,000 to set up our office. Depreciation is calculated at
Written Down Value at 10% for Q1, as our Q1 would be Q4 of FY 2025-26, hence lesser
depreciation. The Depreciation rate allowed by the Income Tax Department is different for a
Private Ltd Company. However, looking at the life and usability of the assets, we believe, 15%
of depreciation every yer is ideal.
Note 13:
Drawings are ideally kept as a repayable amount if in case the Promotor's Margine was part of
this loan. Interest at 12%
Note 14:
Sale Amount Received = Sales in the Quarter - Recievable for the Quarter in which it was sold
+ Recievable in the previous Quarter in which it was sold. Our Standard credit period is about
1month, which is effectively 15% ot Turnover.