Project report for Computer sales & service

Introduction

Computer sales & service is one of the smartest ideas for computer-savvy people. If you have the knowledge and skill of software and hardware of a computer and know how to assemble computers, then computer assembling business is a great opportunity to start your entity and use your skill to grow your business and earn a luxurious livelihood instead of dedicating yourself for someone else’s benefit. The Indian computer industry has registered significant growth in recent years. The hardware business or computer assembly business is growing at a rate of 12-18 % a year in India. Just as mobile phones, the computer is also an integral part of daily life. Branded computers are costly and unable to get in a customized configuration. If it is getting assembled, it can be availed with the required configuration and cheap rate. Price for brand value and promotion can be reduced in the future.

Computers are nowadays used for various applications in day-to-day life. A Micro Enterprise unit proposed activity Computer assembling & Sales. For this computer, parts will be Purchased from the dealer and assembling in the unit. Assembled Computers will be marketed through the distributors appointed by the entrepreneur. The distributor will also inform the needs of the computer through the market survey. As the usage of computers increases day by day, the need for sales and maintenance of that system is also needed. So the demand is on the higher side for the service. 

Product / Services & process

The products of this unit are assembled computers and its maintenance services. As per the orders of customers, we procure components from branded suppliers and assemble them at the unit and install all required software and fix it at the premises of the customer. We also supply all accessories of the computers such as Printers, UPS, Scanners, Camera, Modem, earphones, etc. We offer all post-sale services and undertake all sorts of maintenance and repair works also.

Market potential & Strategy

The population of educated youth is growing in India. Quality and methods of education also improve. Computer education is a part of it. Moreover, the IT and ITE Industry is much developed in India and the extent of internet connectivity is highly improved. 4G has already launched. 5G is expected to launch soon. Hence the requirement for computers is increasing rapidly.

The Indian Desktop market which is estimated to be worth Rs.10,452 crore, is divided into the Commercial market and Consumer market and the Commercial market accounts for 67% of the total sales. All these branded PC manufacturers along with HCL Infosystems were in the past selling to corporates, government, business professionals, and to some extent the eminent educational institutions. But, recently these companies have started targeting individual consumers to improve their market shares. Not so long ago, assembled PCs were considered to be the best, value-for-money PCs as against the branded PCs as the branded ones were high priced. But, in the recent past, the demand for assembled PCs has come down drastically in comparison with the branded ones. Though more than half (53%) of the Indian PC market is occupied by the unorganized sector (assembled and non-branded PCs), there has not been a considerable improvement in their sales. The major reason for this change in customer preference is that the present-day customer is no more looking for low-priced products.

The Indian computer industry has registered significant growth in recent years. The hardware business or computer assembly business is growing at a rate of 12-18 % a year in India. Just as mobile phones, the computer is also an integral part of daily life. Branded computers are costly and unable to get in a customized configuration. If it is getting assembled, it can be availed with the required configuration and cheap rate. Price for brand value and promotion can be reduced in the future.

Name & Address of Unit

Computer sales & service

Address

Details of unit
Email : [email protected]
Phone : 00000
Constitution : Proprietership
Total project cost : *******
Fixed Capital : *******
Working Capital : *******
Total Bank loan : *******
Promoter(s) contribution : *******
Term loan : *******
Working capital loan : *******
Name & address of promoter(s)
Name : Your name
Address : Address
Designation : Proprietor
Debt Service Coverage Ratio (Average) :1.87
Current ratio (Average) :2.63
Year 1Year 2Year 3Year 4Year 5
Current ratio 1.53 2.06 2.62 3.19 3.76
Quick ratio 1.13 1.56 2.10 2.64 3.18
Interest coverage ratio 3.87 5.55 7.00 9.48 14.71
Debt equity ratio 2.863 2.080 1.528 1.020 0.542
TOL/TNW 3.02 1.45 0.79 0.43 0.21
DSCR 1.65 1.86 1.90 1.94 1.97
Gross profit Sales Percentage % 29.23 % 28.54 % 28.18 % 27.86 % 27.50 %
Net profit Sales Percentage % 10.84 % 10.56 % 11.10 % 11.57 % 11.90 %
BEP in % of installed capacity % 49.90 % 27.12 % 27.12 % 27.12 % 27.12 %
BEP in sales of Rs 2,620,800.00 1,840,695.65 1,972,173.91 2,103,652.17 2,235,130.43
Return On Capital Employed 0.26 0.34 0.34 0.33 0.33
Net profit Sales %
Quick ratio
Revenue v/s Expense
Expense Splitup
Sl. no Item Amount Rs
1 Building advance *******
2 CRO *******
3 Other fitting items *******
4 Soldering station *******
5 soldering Iron *******
6 Multimeter *******
7 Screw Driver *******
8 Electrification *******
9 Racks and storage *******
10 Working Capital *******
Total *******

 

Sl. no Item Amount Rs
1 Consumables / stock in hand *******
2 Work in progress *******
3 Finished goods *******
4 Working expense. *******
5 Receivables/Sundry debtors *******
6 Payables *******
7 Total working capital *******
8 Own Contribution *******
9 Working capital loan *******

working capital is calculated taking one month as working cycle. Stock is purchasing on monthly basis.

Sl. no Item Rate Quantity Unit Total Rs
1 Sales of Assembled Computers ******* X 180 Number *******
2 Sale of Accessories ******* X 8400 Metre *******
3 Service of computers ******* X 6600 Metre *******
Total *******

Sl. no Item Amount Rs
1 Building Rent *******
2 Skilled Workers *******
3 Electricity charges *******
4 Office expenses *******
5 Computer Parts and accessories *******
6 Wages *******
Total *******
Sl. no Item Subsidy % No. Rate Amount Rs
1 Building advance ******* 1 ******* *******
2 CRO ******* 2 ******* *******
3 Other fitting items ******* 1 ******* *******
4 Soldering station ******* 4 ******* *******
5 soldering Iron ******* 4 ******* *******
6 Multimeter ******* 4 ******* *******
7 Screw Driver ******* 4 ******* *******
8 Electrification ******* 1 ******* *******
9 Racks and storage ******* 1 ******* *******
Total Investment *******
Total Subsidy *******
Net Investment *******
Sl. no Item Amount
1 Term Loan *******
2 Working capital Loan *******
3 Total loan *******
4 Term Loan contribution *******
5 Working capital contribution *******

Own contribution will be deposited in the loan account

Year 1(!*) Year 2 Year 3 Year 4 Year 5
Revenue from operation
Sales ***** ***** ***** ***** *****
Add :
Closing stock ***** ***** ***** ***** *****
Total ***** ***** ***** ***** *****
Less :
Opening stock ***** ***** ***** ***** *****
Stock purchase ***** ***** ***** ***** *****
Salary ***** ***** ***** ***** *****
Repairs and maintenance charges ***** ***** ***** ***** *****
gas ***** ***** ***** ***** *****
ELECTRICITY bill ***** ***** ***** ***** *****
Total ***** ***** ***** ***** *****
Gross profit ***** ***** ***** ***** *****
Less :
Rent ***** ***** ***** ***** *****
Telephone/Postal &internet charge ***** ***** ***** ***** *****
Total ***** 0***** ***** ***** *****
Depreciation ***** ***** ***** ***** *****
Interest on TL ***** ***** ***** ***** *****
Interest on WC ***** ***** ***** ***** *****
Total ***** ***** ***** ***** *****
Profit before tax ***** ***** ***** ***** *****
Income Tax ***** ***** ***** ***** *****
Profit after tax ***** ***** ***** ***** *****
Cash Inflow Pre operative period Year 1 Year 2 Year 3 Year 4 Year 5
Capital 0.63 ***** ***** ***** ***** *****
Subsidy ***** ***** ***** ***** ***** *****
Termloan ***** ***** ***** ***** ***** *****
Profit before tax with interest ***** ***** ***** ***** ***** *****
Increase in WC loan ***** ***** ***** ***** ***** *****
Depreciation ***** ***** ***** ***** ***** *****
Increase in Current liability ***** ***** ***** ***** ***** *****
Total Cash Inflow ***** ***** ***** ***** ***** *****
Cash Outflow
Fixed Assets ***** ***** ***** ***** ***** *****
Increase in Current asset ***** ***** ***** ***** *****
Interest on TL ***** ***** ***** ***** ***** *****
Interest on WC ***** ***** ***** ***** ***** *****
Income Tax ***** ***** ***** ***** ***** *****
Decrease in Term loan ***** ***** ***** ***** *****
Drawing ***** ***** ***** ***** ***** *****
Total Cash Outflow ***** ***** ***** ***** ***** *****
Opening balance ***** ***** ***** ***** ***** *****
Net Cashflow ***** ***** ***** ***** ***** *****
Closing balance ***** ***** ***** ***** ***** *****
Liability Pre operative period Year 1 Year 2 Year 3 Year 4 Year 5
A. Share holders funds
Capital ***** ***** ***** ***** ***** *****
Reserve & Surplus ***** ***** ***** ***** ***** *****
B.Non current Liabilities
Termloan ***** ***** ***** ***** ***** *****
C.Current Liabilities
Working capital loan ***** ***** ***** ***** ***** *****
Account payable ***** ***** ***** ***** *****
Total Liability ***** ***** ***** ***** ***** *****
Asset
A. Non current Assets
Fixed Assets ***** ***** ***** ***** ***** *****
B. Current Assets
Inventory ***** ***** ***** ***** ***** *****
Trade receivables ***** ***** ***** ***** ***** *****
Cash and cash equivalence ***** ***** ***** ***** ***** *****
Total Asset ***** ***** ***** ***** ***** *****
Year Installment Outstanding at the beginning Principal repayment Interest Amount paid Outstanding at the end
1 1 ***** ***** ***** ***** *****
1 2 ***** ***** ***** ***** *****
1 3 ***** ***** ***** ***** *****
1 4 ***** ***** ***** ***** *****
1 5 ***** ***** ***** ***** *****
| | | | | | |
| | | | | | |
5 56 ***** ***** ***** ***** *****
5 57 ***** ***** ***** ***** *****
5 58 ***** ***** ***** ***** *****
5 59 ***** ***** ***** ***** *****
5 60 ***** ***** ***** ***** *****
Particulars Year 1 Year 2 Year 3 Year 4 Year 5
Receipts
a).Net Profit ***** ***** ***** ***** *****
b).Depreciation ***** ***** ***** ***** 0.30
c).Interest on termloan ***** ***** ***** ***** *****
Total ***** ***** ***** ***** *****
Repayments
a).Loan Principal ***** ***** ***** ***** *****
b).Interest on termloan ***** ***** ***** ***** *****
Total ***** ***** ***** ***** *****
DSCR ***** ***** ***** ***** *****
Particulars Rate Year 1 Year 2 Year 3 Year 4 Year 5
Building ***** ***** ***** ***** ***** *****
Less Depreciation ***** ***** ***** ***** *****
Written down value ***** ***** ***** ***** *****
Computers/ Printers /Photocopier/Electronic gadget 00 ***** ***** ***** ***** *****
Less Depreciation ***** ***** ***** ***** *****
Written down value ***** ***** ***** ***** *****
Furniture & fixtures 00 ***** ***** ***** ***** *****
Less Depreciation ***** ***** ***** ***** *****
Written down value ***** ***** ***** ***** *****
Racks & storage/Interior works 00 ***** ***** ***** ***** *****
Less Depreciation ***** ***** ***** ***** *****
Written down value ***** ***** ***** ***** *****
new item 00 ***** ***** ***** ***** *****
Less Depreciation ***** ***** ***** ***** *****
Written down value ***** ***** ***** ***** *****
new 00 ***** ***** ***** ***** *****
Less Depreciation ***** ***** ***** ***** *****
Written down value ***** ***** ***** ***** *****
Air-conditioning 00 ***** ***** ***** ***** *****
Less Depreciation ***** ***** ***** ***** *****
Written down value ***** ***** ***** ***** *****
Other investments 00 ***** ***** ***** ***** *****
Less Depreciation ***** ***** ***** ***** *****
Written down value ***** ***** ***** ***** *****
Total less depreciation ***** ***** ***** ***** *****
Total written down value ***** ***** ***** ***** *****

The project as a whole describes the scope and viability of the Trading industry and mainly of the financial, technical and its market potential.The project guarantee sufficient fund to repay the loan and also give a good return on capital investment. When analyzing the social- economic impact, this project is able to generate an employment of 5 and above. It will cater the demand of Trading and thus helps the other business entities to increase the production and service which provide service and support to this industry. Thus more cyclic employment and livelihood generation. So in all ways, we can conclude the project is technically and socially viable and commercially sound too.

Read in the language you are comfortable with - image
Read in the language you are comfortable with - image
Click buttons to create report

Project report format for bank loan

A good project report may contain the specific segments and in detailed format to gain confidence from the loan issuing authority

Check format >

Need assistance?

Get help from our experts. Drop us a Whatsapp message now! View video help >

WhatsApp Icon WhatsApp us  Chat Icon Chat with expert

Have some questions?

Share your details, we will call you