Larsen & Toubro
Larsen & Toubro
Larsen & Toubro
AT
KANSBAHAL WORKS
For the Partial fulfilment of the degree of Master of Business Administration ( M.B.A ) (2009-11)
FACULTY GUIDE:
Natraj Agrawal.
PROJECT GUIDE:
Sec.: A
1
ACKNOWLEDGEMENT
To undertake such an important project and to accomplish it, one needs quite a lot of guidance and support. The time, which I spent in L&T, Kansbahal, during training, was a wonderful experience in itself and it is a great pleasure and honour for me to take this opportunity to thank all those who have helped and provided able guidance all along the project. I would like to thank MR.V.N. Shrivastava (GM, Finance) for providing me with an opportunity of carrying out my summer training at this esteemed organization. I would like to express my deep sense of gratitude to Mr. P. Roy (Manager, Finance) whose support and guidance helped me in converting my conception into visualization and also for the continuous guidance throughout the project. I would also like to thank Mr. S.S. Sahoo and Mr. Prashant Patra, who helped me in making me understand about all the concepts of taxation and their application in the organisation. And also my deepest sense of gratitude goes to Mr. R. K. Mishra, Mr. Amit Parashar and Mr. T. N. Biswal. Without their co-operation it would have been difficult for me to complete the project. I would like to thank my Faculty guide Prof. Amiya Sahu for his guidance and co-operation. I would also like to express my deep gratitude to my parents for providing me with necessary facilities and guidance. Lastly, I would like to express my gratitude towards our prestigious institute KIIT School Of Management ( KSOM ), KIIT University, Bhubaneswar for providing me with this lifetime opportunity.
Natraj Agrawal.
2
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
DECLARATION
I Swarup Samal, Student of MBA (2009-11) of KIIT School of Management, KIIT University, Bhubaneswar do hereby declare that the Summer Internship project report entitled STUDY OF THE PRINCIPLES AND PROCEDURES FOLLOWED IN FINANCIAL ACCOUNTS DEPARTMENT, at Larsen & Toubro Ltd., Kansbahal is a true and original work done by me. It is not duplicated from anywhere else. This Project Report is my own and is not submitted to any other institution or is not being published anywhere. This is going to be used for academic purpose only. This is being submitted in partial fulfilment of the requirement for the award of Master of Business Administration (MBA).
Place: Date:
3
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
PROJECT OBJECTIVES
To make a thorough study of the accounting principles, procedures involved and the process of documentation by the various sections in financial accounts dept. of Larsen and Toubro Limited., Kansbahal works. The following are the main objectives of the study: a) To check the feasibility of the project i.e., Calculation of Net present value and Payback period. b) Analyse the capital budgeting process. c) Taxation and their application. d) Analysis of Working Capital Management e) Analysis of Operating and Cash cycle f) Ratio analysis of the different components of working capital
4
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
METHODOLOGY
This Project Report is prepared at L&T, Kansbahal Works with the help of Data collected from various sources: I. Collection of data from the people of Finance department and Store department by discussion. II. Collection of data from the system maintained by L&T, Kansbahal Works. i.e. (ERP, People Soft) III. Collection of data from the Annual Accounts and Annual Report from 2006 to 2010. IV. Collection of data from the PMS. V. Collection of data from magazines, Journals of L&T, Kansbahal. VI. Collection of data through Internet Service. The collected data are analyzed and prepared, with the help of the people of Finance Department.
5
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
6
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
7
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
THE BEGINNING:
Henning Holck Larsen and Soren Kristen Toubro, both Danish nationals, came to India in 1934, as employees of FL Smidth, Denmark, to provide engineering services to cement plants in India. During their stay they became fond of India and its culture. They realized the growing business potential in this country and laid the foundation of their partnership firm in the year 1938, christened as Larsen & Toubro. In the early years, they represented Danish manufacturers of diary equipment for a modest retainer. But with the start of the Second World War in 1939, imports were restricted, compelling them to start a small work-shop to undertake jobs and provide service facilities. Germanys invasion of Denmark in 1940 stopped supplies of Danish products. This crisis forced the partners to stand on their own feet and innovate. They started manufacturing dairy equipment indigenously. These products proved to be a success, and L&T came to be recognized as a reliable fabricator with high standards. Again the sudden interment of German engineers (because of the war) who were to put up a soda ash plant for the TATA, gave L&T a chance to enter the field of installation an area where their capability became well respected. The company had its humble beginning in a tiny room in South Mumbai near to the corporate headquarters. With time the company took huge achievement strides and the marshy land in South Mumbai was transformed to a sprawling enterprise spread over 99 acres, employing more than 24,000 people and catering to the engineering needs of the world with a diverse product line. Today, the enterprise of the company lies in Engineering and Construction but it is constantly leveraging its knowledge in other areas like Information Technology. In India, it has a visible and vibrant presence. Some of Indias most sophisticated projects and most complex industrial equipment carry the L&T
8
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
insignia of excellence. The adventure that began so humbly surpassed even the well established companies, the evidence of which is contained in the following milestones: 1940's: Engineering Construction Corporation (ECC) was incorporated. The partners signed a dealership agreement with the Tractor Company, Caterpillar Inc., USA - one of the largest manufacturers of earthmoving equipment. L&T Pvt. Ltd. came into being on February 07, 1946. L&T acquires 55 acres of land at Powai in 1948.
1950's: L&T became public limited company on December 1950, with a paid-up share capital of Rs. 20 lakhs. Sales turnover being Rs. 109lakhs. Tractor Engineers Limited (TENGL) & Caterpillar Inc., USA were incorporated as a joint venture of L&T on September 18, 1952. On 1956, the company moved to IC office at Ballard Estate which is today known as L&T House, Corporate headquarters. L&T receives a substantial order from Rourkela Steel Plant for the erection of 3 blast furnaces and a pig casting machine. 1960's: L&T emerges as the largest and most outstanding erection contractor in India. Switch gear workshop was set up. Prestigious contracts include turnkey construction of the Radiological Laboratories for the Atomic Energy Establishment, Trombay - which was one of the largest in Asia. Receives a contract for the erection of an Iron ore plant for Hindustan Steel Ltd. at Barsua, Orissa.
9
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
1970's: Manufactures India's first indigenous Nuclear Reactor Vessel for Rajasthan Atomic Power Plant. Manufactures hydraulic excavators in collaboration with Poclain, S.A., France. Manufactures a high speed bottling plant (Capacity: 24,000 bottles per year) for the Delhi Milk Scheme. Supplies and Commissions India's largest indigenous cement plant. Fabricates and delivers motor casings for Indian Space Research Organization (ISRO). 1980's: Manufactures the first multi-wall vessel for ammonia separation for Hindustan Fertiliser Corporation Limited, Namrup. Manufactures India's 1st indigenous adjustable throat armour, at Kansbahal, for the blast furnace at TISCO. Receives national recognition for its path breaking achievement in developing the tri-junction welding technique for critical parts of nuclear reactors. L&T secures an order from ISRO for the manufacture of rocket motor casing made from maraging steel for the Polar Satellite Launch Vehicle (PSLV). Establishes itself as India's largest manufacturer of low tension switchgear, with the widest range. Sets up cement plants at Awarpur. Heavy Engineering facilities are set up in 1987 at Hazira near Surat for the manufacture of heavy and large equipment. 1990's: Emerges as India's largest integrated engineering and Construction Company. Ventures into Software development.
10
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
Fabricated giant oil platforms, including India's biggest marine structure. Emerges as the largest producer of cement and sets up plants at Gujarat, Madhya Pradesh and Andhra Pradesh. Fabricates India's 1st indigenous hydrocracker reactor. Fabricates India's largest slab caster for Bokaro Steel Plant. Builds India's first open-sea jetty.
Today L&T is one of the Indias biggest and best known industrial organizations with a reputation for technological excellence, high quality of products and services, and strong customer orientation. It is also taking steps to grow its international presence. There cannot and must not be an end. And thus L&T saga continues.
11
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
DIVISIONS
L&T businesses have been broadly grouped into six business divisions viz: Engineering & Construction Projects (E&C) Engineering & Construction Corporation (ECC) Heavy Engineering Division (HED) Electrical & Electronics Business Group (EBG) Information Technology (IT) Machinery & Industrial Products Division (MIPD)
I)
II)
ECC as its Construction Division was conceived as Indias leading construction organization.
Engineering
Construction Corporation Limited in April 1944. It has today emerged as Prized landmarks: Its exquisite buildings, tallest structures, largest industrial projects, longest flyovers, and highest viaducts have been built by ECC. The famous Lotus Temple is built by ECC.
III)
IV)
ELECTRICAL & ELECTRONICS BUSINESS GROUP (EBG):Its engaged in the business of low voltage Switchgear products, Electrical Systems, Energy meters, Medical equipments, Petroleum dispensing pumps, Automation solutions and Enterprise networking. Largest manufacturer of low voltage switchgear and control gear in India. EBG products cater to the needs of diverse customers comprising farmers, urban households and commercial buildings. Its products are required in health-care equipments as advanced protection, control and automation in a number of industries.
V)
INFORMATION TECHNOLOGY:
L&T InfoTech Limited provides comprehensive, end-to-end software solutions to clients all over the world.
13
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
It focuses on: Manufacturing, Banking, Securities & Insurance, Utilities and Communications, Embedded systems. The services provided are package implementation and support,
Application development and Maintenance, Application testing, Enterprise application engineering, Data Warehousing and Business Intelligence, Infrastructure Management services, Strategy Consulting, Value Added services.
VI)
ACHIEVEMENTS
In 2009 14
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
Mr. A. M. Naik receives Padma Bhushan from the President of India. CII honours L&T with Corporate Wellness Award. L&T wins D&B-Rolta Top Indian Company Award. L&T-Chiyoda Management. L&T Wins Golden Peacock Award for Corporate Social Responsibility. Chemtech Business Leader of the Year. L&T bags FICCI Award for Outstanding Corporate Vision. L&T bags FICCI Award for Outstanding Corporate Vision. Technology Block at Hazira wins LEED Platinum Rating. L&T is Best for Investor Relations: Asiamoney. ET Business Leader of the Year for Mr. A. M. Naik. Mr. A.M. Naik Conferred Gujarats Highest State Honour - Gujarat Garima Award. bags ICWAI Award for Excellence in Cost
In 2008
Krishnamurthy Award for Excellence. Industrial Excellence Award. E&Y Entrepreneur of the Year Award. Transformational Leader Award. All India Engineering Export Award. Most Admired Infrastructure Company in India. The International Trade Awards.
15
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
1. Tractor Engineers Limited (TENGL) 2. L&T Komatsu Limited (LTK) 3. L&T-Case Equipment Private Limited 4. L&T Infrastructure Development Projects Limited 5. Larsen & Toubro Electromech LLC 6. HPL Cogeneration Limited 7. L&T-Sargent & Lundy Limited 8. L&T-Chiyoda Limited 9. L&T-Valdel Engineering Pvt. Limited 10. Audco India Limited (AIL) 11. L&T-Demag Plastics Machinery Limited 12. EWAC Alloys Limited 13. L&T Finance Limited 14. L&T International FZE 15. L&T Urban Infrastructure Limited 16. L&T Infrastructure Finance Limited 17. L&T Capital Company ltd. (LTCCL) 18. L&T Infrastructure Development Projects Ltd. (L&TIDPL)
16
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
: US$ 8.50 billion (2009) : US$ 900 million (2009) : US$ 0.58 billion (2009) : US$ 9.92 billion (2009) : 35,000 : www.larsentoubro.com
BOARD OF DIRECTORS
17
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
L&T have two types of Directors i.e. Executive Directors and NonExecutive Directors.
EXECUTIVE DIRECTORS:
1. A.M. Naik (Chairman & Managing Director) 2. J.P. Nayak (Whole-time Director & President Machinery & Industrial Products) 3. Y.M. Deosthalee (Whole-time Director & Chief Financial Officer)
NON-EXECUTIVE DIRECTORS:
1. S. Rajgopal 2. S. N. Talwar 3. M. M. Chitale 4. Lt. Gen. Surinder Nath (Retd.) 5. U. Sundararajan 6. Thomas Mathew 7. N. Mohan Raj 8. Subodh Bhargava
18
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
( PROFILE )
Kansbahal works is located near Rourkela (Orissa), is states largest heavy engineering unit. Kansbahal Works, a unit under the Machinery & Industrial Products Division of L&T, is a world class Integrated Machine Building Centre with facilities for Casting, Fabrication, Machining and Assembly, complimented by excellent design, engineering, quality control and logistics support. Set up in 1962 as an Indo-German Venture, under the name of Utkal Machinery Limited (UTMAL) to serve the steel and paper industries to substitute imports. On inception it had four partners viz., GHH, VOITH, KOOPERS and L&T. In the year 1982, it finally came under the umbrella of L&T group after full acquisition of shares. It however remained a cost centre for L&T serving several business divisions of the company and in October 1999, it was structured as a Strategic Business Unit (SBU). L&T, Kansbahal works is situated in sylvan surroundings of Kansbahal, Orissa. It is 25 km away from Rourkela and 15 km from Rajgangpur in the district of Sundergarh, Orissa. It is well connected by roads and railways. Kansbahal works is one of the oldest factories in the arsenal of L&Ts manufacturing bases. It has licensed annual capacity of 12000 tones. It is an ISO 9001 certified works. It has evolved into a world class integrated manufacturing centre with facilities for Fabrication, Machining, Assembly and Casting. This is complemented by excellent design, engineering, quality control and logistic expertise. Kansbahal works manufactures and supplies Heavy machinery, Crushing equipments, Paper machinery and Foundry equipments for Power plants and Windmill. The commitments to quality and customer satisfaction are the driving forces for all its activities. The concern for environment is an integral part of the company's vision. It manufactures a range of steel, Iron and Alloy Iron including spheroidised graphite iron castings as well as paper drying cylinders in vertical
20
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
pits up to 2000-mm dia and 7500 mm length. Approved by Lloyds register of hipping, London, for manufacture of various grades of ferrous castings, the foundry can manufacture a single piece casting of maximum 14 tons in steel, 22 tons in cast iron and 18 tons in spherodized graphite iron. The fabrication shop has a built-up area of 9525 sq.m and can handle a single unit of maximum 100tons. The L&T Kansbahal Works has four main shops and they are: 1. Foundry Shop 2. Machine Shop 3. Fabrication Shop 4. Assembly Shop Products: 1. Paper and pulp machineries 2. Crushing equipments for mining, limestone and minerals 3. Various Foundry Castings 4. Steel plant equipment 5. Surface Minor 6. Hub Casting and Fabrication items for Windmill power sector
21
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
VISION
L&T shall be A professionally-managed Indian Multinational, committed to total customer Satisfaction and enhancing shareholders value. L&Tites shall be An innovative, entrepreneurial and Empowered team, constantly creating value And attaining global benchmarks. L&T shall Foster a culture of caring, trust and Continuous learning while meeting Exceptions of employees, Stakeholders and society.
ORGANIZATION STRUCTURE
22
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
S.C. MOHANTY ( E3 )
[ Suppliers Payment ]
N. AGRAWAL ( MANAGER )
[ Excise, Service tax, VAT, CST, General ledger, Final A/c's, Capital budget ]
P.K. PANI ( E2 )
[ Employee related Payment Provident Fund ]
B.C.RANA ( EXECUTIVE )
P. ROY ( OFFICER )
K. PARIJA ( OFFICER )
P. PODDAR ( OFFICER )
S. BEURA ( C.L )
24
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
CAPITAL BUDGETING
CAPITAL BUDGETING
Capital budgeting is the planning process used to determine whether a firm's long term investments such as new machinery, replacement machinery, new plants, new products, and research development projects are worth pursuing. It is the budget for major capital, or investment, expenditures.
25
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
Capital Budgeting is the process in which a business determines whether projects such as building a new plant or investing in a long-term venture are worth pursuing. Oftentimes, a prospective project's lifetime cash inflows and outflows are assessed in order to determine whether the returns generated meet a sufficient target benchmark. Capital Budgeting of an organisation includes the budgeting of all the capital expenditures incurred in it. A capital expenditure is an expenditure that is shown as an asset on the balance sheet. This asset, except in the case of a nondepreciable asset like land, is depreciated over its life. Capital expenditures have long term consequences.
Capital Expenditures include purchase of fixed assets.
Fixed Assets have 2 characteristics: They are acquired for use over relatively long periods for carrying on the operations of the firm and They are not ordinarily meant for sale.
These fixed assets that are used at L&T are: a) Factory Building b) Non Factory Building c) Plant and Machinery d) Computer items e) Furniture and Fixtures f) Office Equipment
g) Air Conditioning and Refrigeration
GUIDELINES
FOR
PREPARATION
CAPITAL
EXPENDITURES
AND
26
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
Real Estate i.e., Land (Free hold or Lease hold ) Real Estate i.e., Buildings ( Factory or Office / Commercial or Residential Flats ) Plant and Machinery - General or specific Information Technology (IT) related items - PC's, Laptops, Servers, Photo copiers / Printers, Softwares, etc. Special items - Transit houses and holiday homes, Vehicles, Equipment for Medical/Welfare centres, Cars under employee car scheme, Personal computers for employees under the company's scheme, Aircraft, Others Other office equipment Furniture and Fixtures
The proposals should be entered in the appropriate subcategories under respective categories. The proposals for Real Estate and Plant & Machinery should contain detailed item wise justification. All proposals should be substantiated and collaborated with the complete plan. Specific plant and machinery items refer to: a) New investments, b) Expansion and c) Items bought for targeted jobs The specific and general P/M are budgeted under the aforesaid three subcategories with a detailed rationale covering all norms, such as Net Present Value (NPV), Payback period, Project Internal Rate of Return (IRR). The above norms should be justified with respect to probability of award of job and its expected use and residual value post completion of the job.
B) BUDGET PROPOSALS:
27
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
A detailed justification for the purchase of the new asset should be submitted. The increase in revenues, contribution and cost savings that will be achieved should also be given, wherever applicable. The proposals should be comprehensive and must include cost of consequential proposals such as stamp duty, registration charges, material handling equipment, stores, land / site clearing, etc. In case of proposal for general P&M costing Rs.150 lakhs or more & specific P&M budgeted under new investments or expansion, Payback Period, Net Present Value ( NPV ), and Project Internal Rate of Return (IRR ) calculations should be furnished. NPV should be arrived at using Weighted Average Cost of Capital (WACC). Proposals for acquiring Plant & Machinery in anticipation of customer orders should indicate the customer orders, the probability of getting these orders and the redeployment plan for these assets after execution of the orders. For real estate proposals covering construction", breakup of cost into civil, electrical and air conditioning along with area and rate per sq. meter should be provided. Cost of land, if applicable, should also be separately disclosed along with likely stamp duty, registration charges, land development expenses, etc.
28
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
Proposed replacement:
a) Improvements expected including additional production anticipated, cost saving, efficiency improvements, etc.
b) Cost of replacement
E) COSTS:
The amount to be indicated against each proposal should include all taxes, duties, cost of accessories, spares, installation charges, etc. The cost of office space should include cost of modification, transfer expenses, stamp duty, registration charges, etc.
29
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
F) PROPOSAL EVALUATION:
The CAPEX budget would be approved based on the Company's cash flow position for the budget year. All capital expenditure proposals are evaluated and sanctioned on the basis of information given along with the Budget proposals. It is therefore necessary that complete description and justification of the proposals are given to facilitate sanction. Further, it may be noted that a proposal sanctioned towards a particular asset cannot be utilized for any other asset . In case for requirement for substitution prior approval of the H.O Finance dept. will be necessary.
30
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
The capital budgeting process begins with the identification of potential investment opportunities. Typically, the planning body develops estimates of future sales which serve as the basis for setting production targets. This information, in turn, is helpful in identifying required investments in plant & machinery and equipment.
Project Classification:
Normally projects are classified into different categories to have a detailed analysis. Project analysis entails time and effort. The costs incurred in this exercise must be justified by the benefits from it. a) Mandatory Investments: These are expenditures required to comply with statutory requirements such as pollution control equipment, medical dispensary, fire fitting equipment and so on. These are often non revenue producing investments. In analysing such investments the focus is mainly on finding the most cost-effective way of fulfilling a given statutory need. b) Replacement Projects: The Company routinely invest in equipments meant to replace obsolete and inefficient equipments, even though they may be in a serviceable condition. The objective of such investments is to reduce costs of labour, raw material, and power. And also to increase yield and improve quality.
explicit forecast of growth. Since this can be risky and complex, expansion projects normally warrant more careful analysis. Decisions relating to such projects are taken by the top management.
Investment Criteria:
Investments in most of the projects should fulfil some criteria's so that the project is accepted or else the project will be rejected. The investment criteria that are followed at L&T, Kansbahal works are Net Present Value (NPV) and Payback Period.
WORKS
Machine shop is a vital link that concretizes and fructifies the parts which are to be assembled in the assembly shop.
32
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
The machine shop can be divided into : 1) Lathe shop a) Centre lathe b) Vertical lathe c) Facing lathe 2) Boring group a) Table borer b) Floor borer c) CNC borer 3) Central group a) Marking b) Miscellaneous machines The operations that can be performed in Lathe shop are: OD and ID Turning Taper Turning External threading Internal Threading Parting Grooving Chamfering, etc.
There were 4 vertical lathe machines available in the machine shop: a) M/C No. - 021 b) M/C No. - 037 c) M/C No. - 032 d) M/C No. - 033 M/C No. - 033 was windmill component machinery.
33
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
But due to a major order from Bokaro Steel Plant, the Chuck Dial required for the specified job was 5300 mm. Hence the new Vertical Lathe was proposed to be bought, so as for the completion of the order and to work out more no. of such orders. The estimated total expenditure of the Vertical Lathe M/C was calculated to be 600 lakhs. Availing of the new machinery will result in: 1. Improving productivity 2. Increasing existing capacity 3. Creating new capacity and 4. Getting more no. of specific sales order This particular investment was categorised as an Expansion project and the Net present value (NPV) and Payback period were calculated to check the feasibility of the project. a) Net Present Value (NPV): The Net present value of a project is the sum of the present values of all the cash flows that are expected to occur over the life of the project. Net present value of an investment/project is the difference between present value of cash inflows and cash outflows. The present values of cash flows are obtained at a discount rate equivalent to the cost of capital. The decision rule associated with the net present value criterion is: Accept the project if NPV is positive and reject the project if NPV is negative. If NPV is zero, it is a matter of indifference. The vertical lathe's present value of cash inflows is equal to Rs. 2191.19 lakhs which is much greater than Rs. 600 lakhs. Thus it generates a positive net present value of Rs.1591.18 lakhs. Hence, this project adds to the wealth of owners; therefore, it should be accepted.
34
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
b) Payback Period: Payback period is the time duration required to recoup the investment committed to a project. It is the length of time required to recover the initial cash outlay on the project. According to the payback criterion, the shorter the payback period, the more desirable is the project. Firms using this criterion generally specify the maximum acceptable payback period. If this is 'n' years, projects with a payback period of 'n' years or less are deemed worthwhile and projects with a payback period exceeding 'n' years are considered unworthy. Preparation of Capital Expenditure Budget Proposals: According to the requirement of materials by the different departments of the unit, the Head of the Dept. writes a letter to the Accounts Dept. mentioning the description, quantity and justification for the purchase of those. Then the A/c's dept. prepares a budget proposal in the mentioned format:
Cash Outflow Sl. No. Description Qty. Amount ( in lakhs ) Dept. 1st qtr. 2nd qtr. 3rd qtr. 4th qtr. Justification For a specific & repetitive order Increase in capacity
600
Machine shop
600
Submission of Budget:
Then the Budget proposals that are prepared in the unit are submitted to the Head Office, Mumbai on the CAPEX System operating on the intranet (http://172.25.11.2/capex/Login.aspx). This system will be the platform for the submission of the CAPEX requests, release of sanctions, monitoring of actual commitment and cash outflow. All the requests are submitted through this
35
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
proposal only. After the acceptance from the head office the H.O. sends a letter of Capital sanction.
Capital Sanction:
The Head office then analyzes the proposal sent by its units and sanctions capital accordingly. This is then sent to the individual units A/c's dept... The A/c's department of the units then informs the individual units whether their budgets are sanctioned or not.
Initiated by
Date
Asset Group Description Vertical Lathe Machine Quantity 1 Supplier When Reqd. Expected Delivery 36
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
Execution Departmental Estimated Cost } Landed Cost } Installation }Total(GrossValue) Month Justification 1 2 3 4 Improving Productivity Increasingexistingcapacity Creating new capacity No. of Shifts Single Grade : Area Sq m. Double No: Location YES if NO ; Reason for this proposal Departmental Head (ACCOUNTS) 1. Cash flow Certified 2 3 (Date) 1. Approved. 2. Rejected. 3. Postponed ( Vice President) (Accounts Department) (MANAGEMENT) 1. Appropriation noted 2. Project No. : 3. Head of account 4. Accounts advised on (Date) (Date) (Budget Section) 5 6 7 8 StatutoryObligation Welfare of Workmen/Community Replacement(state disposal of old assets) Others(specify) Horse Any Incidental Power capital outlay required (Specify) Month Contract
Indigenous
Treble
Is the estimated cost within the NO approved budget ? if No reason for Excess Divisional Head (BUDGET) 1. Is this item approved in the Capital budget ? 2. Is the Estimate within budget allocation? 3. Is budget over-run for any other item for Dept./CC? 4. Other Comments (Date) Yes (Budget Section) (BUDGET) YES NO
Purchase Requisition:
After the approval of the Capital Job Requisition ( CJR ) by the Department heads, a Purchase Requisition ( PR ) is prepared and is sent to the Purchase dept. for the purchase of the required materials mentioning the quantity of those, the suppliers and the date of requirement.
37
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
Requisition Date: Estimated Value: Larsen and Toubro Ltd., Kansbahal works Project: EO Number: Item Line no. No. Cost Centre: 401 A/C No.: 7402 Description Quantity Unit Cost Required Date Group: Total Cost
Delivery Instructions:
Purchase Order:
Now Purchase order is placed by the Purchase dept. to the Suppliers for those items. Purchase Order No.: Date: AMD No.: Vendor's Reference
Larsen &Toubro Ltd., Machinery & Industrial Products Division, Kansbahal Works, Kansbahal-770034, Dist.: Sundergarh
Terms of payment:
Deletion during Original Project No. Description Category Capital Dept. Sanctioned Amount as on Jan 1st Jan 1st to Mar 31st Addition during Jan 1st to Mar 31st CWIP as on Feb 16th
Capitalization:
It is a process in which a product or a sanctioned budget is capitalized or converted into a fixed asset from the amount available in Capital Work In Progress ( CWIP ).
39
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
i.
Asset No.
Original cost
ii.
Asset No.
Thus the Asset is converted from CWIP to a fixed asset of the company and the process is termed as Capitalization where a fixed amount is depreciated each year.
Install Dept. code Description ation date Asset category Quantity Original value Dep. Rate WDV OPN DEP SLMD WDV CLO REP VALUE
Depreciation:
L&T, Kansbahal follows two types of depreciation methods: Straight Line Method ( SLM ) - used for Book depreciation. Written Down Value ( WDV ) - used for IT depreciation.
Depreciation on revalued assets is calculated on Straight Line basis on the values and at the rates given by the valuers. The difference between depreciation on the assets based on revaluation and that on original cost is transferred from Revaluation A/c to Profit-Loss A/c. a) Tangible Assets: I) Building: Residential Purpose Non Residential Purpose Temporary Erections 2.5% 5% 50% Rate of Depreciation
II)
Furniture & Fixtures : General ( including electrical fittings ) Colleges & other educational Institutions, Library,
41
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
5%
Welfare centres, City malls III) Plant & Machinery: General installed in the factory Premises Motor cars & other vehicles Air pollution control equipment Water pollution control equipment Computers Energy saving devices Renewable energy devices Furnace Railway sidings Ships Laboratory equipments Canteen equipment Air conditioning & Refrigeration Office equipment -
5%
7.5% 7.5% 50% 50% 30% 40% 40% 40% 7.5% 10% 12.5% 12.5% 8.33% 6.67%
42
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
WDV Additions during the year Sale during the year Normal before dep. rate of dep. Dep. allowable
WDV as on 31-03-2009
Asset description
Opening WDV
Grinder
1,78,63,776
27,670
17,891,446
5%
894,572
16,996,874
43
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
TAXATION
Tax
A Tax is a payment made by the person who has earned income during a year to the government. Tax is nothing but it is a charge made by the government on the goods, travelling, medicine, etc. that is a sort of income to the government and this money is used for developing purpose. Tax is a major source of revenue
44
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
to the government. Tax is the price which we pay for a civilised society. Broadly, Tax is divided into 2 categories:
A) Direct Tax:
Direct taxes are those which the taxpayer pays directly from his income/ wealth/ estate, etc... Direct taxes are those which are paid after the income reaches the hands of the tax-payer. Income Tax: An income tax is a tax levied on the financial income of persons, corporations, or other legal entities. As per section-14, income of a person is computed under the following heads: 1) Salaries: The term salary includes: a) b) c) d) Wages Any annuity or pension Gratuity Any fees, commissions, perquisites or profits in lieu of or in addition to any salary or wages e) Any advance of salary f) Leave encashment g) Annual accretion to the credit balance in a recognised provident fund 2) Income from house property: Rent received from building or land appurtenant (i.e., land attached to the building) 3) Profits and gains of business or profession: a) Income derived by a trade or profession b) Compensation or other payment received c) Profit on sale of a licence granted under the imports order d) Cash assistance received against exports
45
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
e) Value of any benefits or perquisites arising from a business or the exercise of a profession f) Interest, salary, bonus, commission or remuneration due to or received by a partner of a firm 4) Capital gains: Any profit or gain arising from the sale or transfer of a capital asset. Capital asset is defined to include property of any kind, whether fixed or circulating, movable or immovable, tangible or intangible. Short term capital assets are: a) Equity or preference shares b) Securities like debentures or government securities c) Units of UTI d) Units of Mutual fund e) Zero coupon bonds An asset other than a short term capital asset is regarded as long term capital asset. 5) Income from other sources: Incomes from other sources include: a) Dividends b) Income from subletting c) Interests on bank deposits and loans d) Income from royalty e) Director's fees f) Director's commission g) Ground rent h) Agricultural income i) Examination fees received by a teacher j) Insurance commission k) Winning from lotteries, etc. Tax Rates that are currently applicable are:
46
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
Net income range ( Rs.) <= 1,90,000 1,90,000 - 5,00,000 5,00,000 - 8,00,000 >= 8,00,000
Net income range ( Rs.) <= 2,40,000 2,40,000 - 5,00,000 5,00,000 - 8,00,000 >= 8,00,000
Net income range ( Rs.) <= 1,60,000 1,60,000 - 5,00,000 5,00,000 - 8,00,000 >= 8,00,000
B) Indirect Tax:
Indirect taxes are those which the tax-payer pays indirectly i.e., while purchasing goods and commodities, paying for services, etc... Indirect taxes are paid before the goods or a service reaches the tax payer. a) Central Excise Duty or Central Value Added Tax ( CENVAT ):
47
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
Central Excise is a tax on act of manufacture or production. Central Excise Duty is imposed and collected on excisable goods ( that are movable and marketable ) which are manufactured or produced in India. Excisable goods are those that are included in Central Excise Tariff Act, 1985. It is collected by Central Govt. of India. Basic Excise Duty Education Cess Secondary & Higher Education Cess For example: Line Filter is a product that is manufactured and supplied by L&T, Kansbahal. Total cost of the machine is Rs. 33,040/-and after addition of excise duty amount the total value went up to Rs.36, 443.12. The excise duty is charged as the product is been manufactured here.
Item 880339 Excise Duty (%) 10% CSH No. 84314990 Excise Duty Amount 3,304.00 Description Line Filter Quantity 4 Rate(Rs.) 8,260.00 Amount(Rs.) 33,040.00 Assessable Value 33,040.00 E-Cess Rate (%) 2% E-Cess Amount 66.1 SHE-Cess Rate (%) 1% SHE-Cess Amount 33.04 Total Excise 3,403.12 Duty Net Amount 36,443.12
- 10% - 2% on Basic excise duty (w.e.f. 9-7-2004) - 1% on Basic excise duty (w.e.f. 1-3-2007)
b) Value Added Tax ( VAT ): It is an act to provide for the imposition and collection of tax on the sale or purchase of goods in the state. It extends to the whole of the state of Orissa. It is collected by State Government. VAT is applicable on a product after excise duty is imposed on it. It is a consumption tax as it is paid by the final customer. All business transactions carried on within a state by individuals, partnerships,
48
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
companies, etc. will be covered under VAT. Annual turnover of Rs. 2, 00,000/- or more will be covered under VAT. Under the VAT system, 550 goods are covered. Tax rates under VAT: Zero Rate: Exempted goods such as flood relief goods. 1%: Part I of the schedule. 4%: Part II of the schedule covering 210 items such as medicines and drugs, all agricultural and industrial inputs, capital goods and declared goods.
Item 880339
Assessable Value 33,040.00 SHESHE-Cess Cess Rate (%) Amount Total 1% 33.04 3,403.12 Excise Duty Amount on which VAT is payable 36,443.12 VAT @ 12.5% 4,555.39 Net Value 40,998.51
VAT is a multipoint tax system with provision for input tax credit / setoff tax paid on purchase at each point of sale.VAT liability of the dealer is calculated by deducting input tax credit from tax collected on sales during the payment period (say, a month). c) Entry Tax:
49
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
An act to provide for the levy and collection of tax on the entry of goods into the local areas of the state of Orissa for consumption, use or sale therein and matters incidental thereto and connected therewith. It is a tax collected for local development. A local area means the areas within the limits of any: i) Municipal corporation ii) Municipality iii) Notified area council iv) Gram panchayat v) Industrial township vi) Other local authority by whatever name called, constituted or continued in any law for the time being in force. Rate of tax: The tax payable by a dealer or any other person under the act shall be at the following rates: i) Subject to the provisions, the goods specified in Part I of the schedule (116 items) to the act shall be charged at the rate of 1% of the purchase value. L&T Products: Coal & coke Cotton yarn Iron and steel Furnace oil Kerosene Sheets & rods Bricks & roofing tiles Paper LPG & Natural gases items ) to the act shall be charged at the rate of 2% of the purchase value.
50
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
Telephone & accessories Petrol, Diesel and lubricants Cement & asbestos Doors and shutters Plywood Sheet glass Computer & Softwares Office stationary
ii) Subject to the provisions, the goods specified in Part II of the schedule ( 43
L&T Products: Electrical goods including motors, conductors & cables Electrical appliances Voltage stabiliser Machinery and equipments and spare parts Furniture including steel, plastic and aluminium Elevator and lift Generator and transformer Copier, Xerox machine, Fax TV, VCD, DVD, Camera All motor vehicles Marbles and Tiles Air conditioners, Refrigerators Air coolers Ferro alloys
Assessable Value 33,040.00 SHE-Cess Amount Total 33.04 Excise 3,403.12 Duty VAT @ 12.5% Entry Tax @ 2% 4,555.39 819.97
Amount on which VAT is payable 36,443.12 Net Value 40,998.51 Net Payable 41,818.00
Source: L&T Tax Invoice (Reference: Annexure)
Entry tax in case of intra state transactions (i.e., within a state), the tax is given by the buyer to the seller of the goods and it is mentioned in the invoice. After the buyer collects the tax he deposits it to the Govt. But in case of interstate transactions (i.e., one state to another), the tax is given by the buyer to the Govt. directly and it is not mentioned in the invoice. d) Central Sales Tax ( CST ):
51
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
It is an act to formulate principles for determining when a sale or purchase of goods takes place in the course of inter-state trade or commerce or outside a state or in the course of import into or export from India, to provide for the levy, collection and distribution of taxes on sale of goods in the course of interstate trade or commerce and to declare certain goods to be of special importance in interstate trade or commerce and specify the restrictions and conditions to which state laws imposing taxes on the sale or purchase of such goods of special importance shall be subject. Rate of Central Sales Tax (CST) is 2%. It extends to the whole of India.
Item
CSH No.
Description
Quantity
Rate(Rs.)
Amount(Rs.)
880339
84314990
Line Filter
8,260.00
33,040.00
Assessable Value 33,040.00 Excise Duty(%) 10% Excise Duty Amount 3,304.00 E-Cess Rate(%) 2% E-Cess Amount 66.1 SHE-Cess Rate(%) 1% SHE-Cess Amount 33.04 Total Excise Duty 3,403.12
In case of Central Sales Tax (CST), ), the Entry tax is given by the buyer to the Govt. directly and it is not mentioned in the invoice. e) Service Tax:
52
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
Service tax is a form of indirect tax imposed on specified services called "taxable services". Service tax cannot be levied on any service which is not included in the list of taxable services. Service tax is levied on the value of such taxable service that shall be equivalent to the gross amount charged by the service provider to provide similar service to any other person in the ordinary course of trade and the gross amount charged is the sole consideration. Over the last few years, service tax has been expanded to cover new services. The intention of the government is to gradually increase the list of taxable services until most services fall within the scope of service tax. Till now 100 services have been made taxable. The common services that are included are: Advertisement services Asset management services Auction services ATM operation & management services Banking services Broadcasting services & other financial Business support services Cargo and port handling services Cleaning services Construction services Courier services Insurance services Internet telephony services Stock broking services
Presently the rate of service tax that is levied is: Basic Service Tax Education Cess Secondary & Higher Education Cess
Item 880339 CSH No. 84314990 Service Tax Amount 3,304.00 Description Commissioning of Line Filter E-Cess Rate (%) 2%
- 10% - 2% on Basic excise duty (w.e.f. 9-7-2004) - 1% on Basic excise duty (w.e.f. 1-3-2007)
Rate(Rs.) 8,260.00 Amount(Rs.) 33,040.00 Assessable Value 33,040.00
Quantity 4
SHE-Cess Amount 33.04 Total Service 3,403.12 tax Net Amount Payable 36,443.12
53
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
INTRODUCTION Proper management of working capital is very important for the success of an enterprise. It aims at protecting the purchasing power of assets and maximizing the return on investment. Constant management is required to maintain appropriate levels in the various working capital components. Sales expansion, dividend declaration, plant expansion, new product line, increased salaries and wages, rising price levels etc. put added strain on working capital maintenance. Business concerns need funds for carrying on the business. These funds are acquired either from equity or on borrowed basis. Concern utilizes a part of the funds for acquiring fixed assets and other for long term purposes. Apart from financing for investing in fixed asset, every business concern also require funds on a continual basis for carrying on its day-to-day operations. These include amount incurred for purchase of raw materials, for processing them, constructions work, etc.. Working capital refers to the sources of financing required to by business on continual basis for meeting these needs.
MEANING OF WORKING CAPITAL: Working capital typically means the firms holding of current or short-term assets such as cash, cash receivables, inventory, and marketable securities. Working capital focuses on the efficient management of the individual current assets in the day-to-day operation of the business. Working capital is that part of firms current assets which are financed by long term funds when we take working capital as excess of current assets over current liabilities. The net working capital provides an accurate assessment of the liquidity position of the firm. With the liquidity and profitability dilemma solidly authenticated in the financial scheme of management, concerned efforts are made to ensure the ability of the firm to meet the obligations, which mature within twelve month period. Management must always ensure the solvency and viability of the firm.
55
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
The definition of working capital is fairly simple; it is the difference between an organization's current assets and its current liabilities. Of more importance, is it's function which is primarily to support the day-to-day financial operations of an organization, including the purchase of stock, the payment of salaries, wages and other business expenses, and the financing of credit sales. Working capital comprises a number of different items and its management is difficult since these are often linked. Hence altering one item may impact adversely upon other areas of the business. For example, a reduction in the level of stock will see a fall in storage costs and reduce the danger of goods becoming obsolete. It will also reduce the level of resources that an organization has tied up in stock. However, such an action may damage an organization's relationship with its customers as they are forced to wait for new stock to be delivered, or worse still may result in lost sales as customers go elsewhere.
NEED OF WORKING CAPITAL MANAGEMENT: The working capital management refers to Management of working capital ", or, to be more precise The management of current assets". A firms working capital consists of its investment in current assets which include short term assets such as cash and bank balance, inventories, receivable and marketable securities, etc. So the working capital refers to the management of the level of all these individual current assets. The need for working capital management arises from two considerations: i. Firstly, existence of working capital is imperative in any firm. The fixed assets, which usually require a large chunk of total funds, can be used as an optimal level of only if supported by sufficient working capital, and ii. Secondly, the working involves investment of funds of the firm. If the working capital level is not properly maintained and managed, then it may result in unnecessary blocking of scarce resources of the firm. The insufficient working capital, on the other hand, put different hindrances in
56
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
smooth working of the firm. Therefore, the working capital management needs attention of all financial managers. Proper management of Working Capital is very important for the success of an enterprise. It aims at protecting the purchasing power of assets and maximizing the return on investment. Constant management is required to maintain appropriate levels in the various working capital components. It has been found that the major portion of a financial managers time is utilized in the management of working capital. Current assets are a large portion of the total investment of a firm. In some of the industries, current assets account for a very large portion of the total investment of a firm. In some of the industrial current assets on an average represent over three-fifth of the total assets. In the case of trading concerns they account for about 80 percent.
CONCEPTS OF WORKING CAPITAL: There are two concepts regarding the meaning of Working Capital: Gross Working Capital Net Working Capital.
i. Gross Working Capital includes investment of a firm only in current assets. Current assets are those which can be converted into cash within an accounting year. They are cash, Sundry debtors, Inventories and Short term securities, etc.. Current assets are of circulating nature so it should be considered as working capital. There would be an automatic increase in the Working Capital with every increase in the funds of the company.
57
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
OF
As On 31-032009 90,37,34,909
As On 31-032008 77,24,35,692
As On 31-032007 62,66,18,535
As On 31-032006 67,10,58,974
24,39,09,257
27,34,76,341
27,74,11,232
19,64,69,859
21,24,39,125
26,41,31,520
49,80,05,436
33,76,71,000
32,71,20,950
34,96,27,890
Components
5,71,13,408
9,98,69,097
10,97,03,495
5,01,78,739
8,12,46,579
3,51,89,225
2,15,96,355
1,24,03,765
79,30,291
85,08,020
Finished Goods SUNDRY DEBTORS CASH AND BANK BALANCE LOANS AND ADVANCES WIP SUSPENSE TOTAL CURRENT ASSETS
90,53,182
1,07,87,680
3,52,46,200
4,49,18,696
1,92,37,360
79,19,16,010
75,18,68,597
90,56,40,467
76,32,29,126
43,99,44,793
37,325
46,629
31,82,292
-10,89,505
-34,790
19,46,36,758
13,34,51,167
14,20,21,170
14,67,04,521
11,03,89,478
20,53,89,590
1,22,13,58,455
58
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
From the above table it is clear that the Gross Working Capital is increasing in a very smooth way. It means the companys liquidity position is well. ii. Net Working Capital refers to the excess of current assets over current liabilities. Current liabilities are claims of outsiders expected to mature within an accounting year. It includes Bills payable, Sundry Creditors, Bank overdraft, Outstanding Expenses.etc. This concept of Working Capital enables the shareholders to judge the financial soundness of the concern and the extent of protection affordable to them. It is particularly because with an increase in short term-borrowings the, Working Capital does not increase. It is increase only by following the policy by ploughing back of profits or conversion of fixed assets into liquid assets or by procuring fresh capital from Shareholders.
NET WORKING CAPITAL OF L&T, KANSBAHAL WORKS FOR LAST FIVE YEARS (2005-2009)
CURRENT ASSETS: INVENTORY: As On 3103-2010 60,93,96,591 As On 3103-2009 90,37,34,909 As On 31-032008 77,24,35,692 As On 3103-2007 62,66,18,535 As On 3103-2006 67,10,58,974
24,39,09,257
27,34,76,341
27,74,11,232
19,64,69,859
21,24,39,125
26,41,31,520
49,80,05,436
33,76,71,000
32,71,20,950
34,96,27,890
5,71,13,408
9,98,69,097
10,97,03,495
5,01,78,739
8,12,46,579
3,51,89,225
2,15,96,355
1,24,03,765
79,30,291
85,08,020
90,53,182
1,07,87,680
3,52,46,200
4,49,18,696
1,92,37,360
59
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
SUNDRY DEBTORS CASH AND BANK BALANCE LOANS AND ADVANCES WIP SUSPENSE TOTAL CURRENT ASSETS CURRENT LIABILITIES: ACCEPTANCE SUNDRY CREDITORS ADVANCE FROM CUSTOMER PROVISIONS TOTAL CURRENT LIABILITIES NET WORKING CAPITAL
79,19,16,010
75,18,68,597
90,56,40,467
76,32,29,126
43,99,44,793
37,325
46,629
31,82,292
-10,89,505
-34,790
19,46,36,758 -
13,34,51,167 20,53,89,590
14,20,21,170 -
14,67,04,521 -
11,03,89,478 -
1,59,59,86,68 3
1,99,44,90,89 2
1,82,32,79,62 1
1,53,54,62,67 7
1,22,13,58,45 5
70,43,62,533
95,56,60,369
91,43,72,348
85,85,97,867
69,30,23,272
From the above table it can be seen that the amount of net working capital for the company for the previous five years is fluctuating. The net working capital is high in the year 2008-09. The net working capital is always positive in nature i.e. current assets are always more than current liabilities. The greater the amount of net working capital, the greater the liquidity of the company.
60
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
management must be considered in relation to other aspects of the department's financial and non-financial performance.
will not earn enough return. The two important aim of the working capital management are: Profitability and Solvency. Solvency refers to the firms continuous ability to meet maturing obligations. To ensure solvency, the firm should be very liquid, which means larger current assets holdings.
implies greater liquidity and lower risk; while "an aggressive policy indicates higher risk and poor liquidity". Moderate current assets policy fall in the middle of conservative and aggressive policies. Current Assets to Fixed Assets of L&T, Kansbahal Works. Year 2009-10 2008-09 2007-08 2006-07 2005-06 Current Assets 1,595,986,683 1,994,490,892 1,823,279,621 1,535,462,677 1,221,358,455 Net Fixed Assets 1,725,796,584 655,784,255 439,803,577 310,744,935 294,351,357 Ratio 0.92 3.04 4.15 4.94 4.15
As per the above data, it can be clearly seen that L&T, Kansbahal Works follows a Aggressive Current Assets policy in the financial year 2009-10 than in the other years. The management believes on the Liquidity and lower risk rather than Profitability with higher risk.
63
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
OPERATING CYCLE
64
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
OPERATING CYCLE
The Working Capital Cycle or Operating Cycle is the length of time between a company paying for materials entering into stock and receiving the inflow of cash from sales. Investment in working capital is influenced by 4 key events in the production and sales cycle of the firm: i) Purchase of raw materials ii) Payment for raw materials iii) Sale of finished goods iv) Collection of cash from sales
RMCP
WIPCP
RCP
FGCP
The firm begins with the purchase of raw materials which are paid for after a delay which represents the accounts payable period. The firm converts the raw materials into finished goods and then sells the same. The time lag between the purchase of raw materials and the sale of finished goods is the inventory period. Customers pay their bills sometime after the sales. The period that elapses between the date of sales and the date of collection of receivables is the accounts payable period (debt period).
65
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
Order placed
Stock arrives Inventory period Accounts payable period Firm receives Cash paid for invoice materials Operating cycle Cash cycle
The time that elapses between the purchase of raw materials and the collection of cash for sales is referred to as the operating cycle, whereas the time length between the payment for raw material purchases and the collection of cash for sales is referred to as the cash cycle. The operating cycle is the sum of the inventory period and the accounts receivable period, whereas the cash cycle is equal to the operating cycle less the accounts payable period. Longer the working capital cycle period, larger the requirement of working capital. The determination of operating cycle is helpful for control purposes with a view to improve previous working capital ratios.
Operating Cycle = Inventory Conversion Period + Receivables conversion Period = RMCP + WIPCP + FGCP + RCP
66
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
I) Inventory Conversion Period: It is the total time needed for producing and selling the product. Typically, it includes: a) Raw material Conversion Period( RMCP ): It is the average time period taken to convert material into work in process. RMCP depends on: Raw material consumption per day and Raw material inventory.
Raw material consumption per day is given by the total raw material consumption divided by the number of days in a year ( 365 days). Hence, RMCP = Raw Material Conversion Period. = Average Stock of Raw Material Material Consumption Per day b) Work-in-Process Conversion Period( WIPCP ): It is the average time taken to complete the semi-finished or work in process. Hence, WIPCP = Work-In-Progress Conversion Period. = Average Stock of Work In - Progress Total Cost of Production per Day c) Finished goods Conversion Period (FGCP): It is the average time taken to sell the finished goods. Hence, FGCP = Finished Goods Conversion Period. = Average Stock of Finished Goods Total Cost of Goods Sold Per Day
67
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
II) Receivables or Debtors Conversion Period (RCP): It is the average time taken to convert debtors into cash. RCP represents the average collection period. It is the time required to collect the outstanding amount from the customers. Hence, RCP = Receivable Conversion Period. = Average Accounts Receivables Net Credit Sales Per day
CASH CYCLE:
It is the difference between operating cycle and payables deferral period.
Payables or Creditors Deferral Period (PDP): It is the average time taken by the firm in paying its suppliers or creditors. Hence, PDP = Payable Defferal Period = Average Accounts Payable Net Credit purchase Per Day
68
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
2006-07 2546 13589 / 365 = 68.39 3271 21009 / 365 = 56.83 449 19345 / 365 = 8.47
2007-08 3995 15428 / 365 = 94.53 3376 24141 / 365 = 51.04 352 21414 / 365 = 5.99 151.57 9056 28543 / 365 = 115.81
2008-09 3949 16641 / 365 = 86.62 4980 27872 / 365 = 65.22 108 24229 / 365 = 1.63 153.47 7518 31880 / 365 = 86.08
2009-10 3,191 14,739 / 365 = 79.02 2592 26887 / 365 = 35.19 91 27854 / 365 = 1.19 115.4 8089 34929 / 365 = 84.52
133.69 (days) Debtors conversion period (days) 7632 25294 / 365 = 110.22
Operating Cycle
(days)
243.91
3213 13115 / 365 = 89.42
267.38
3794 16878 / 365 = 82.05
239.55
4015 16597 / 365 = 88.30
199.92
3850 13981 / 365 = 100.52
Cash Cycle
(days)
154.49
185.33
151.25
99.4
69
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
RATIO ANALYSIS
70
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
RATIO ANALYSIS
Accounting ratios is used to describe significant relationships which exist between figures shown on a balance sheet, in a profit & loss account, in a budgetary control system or in any other part of the accounting organisation. Ratios are simply a means of highlighting in arithmetical terms the relationship between figures drawn from financial statements. Ratio Analysis is the technique of analysis and interpretation of the financial statements. Ratio Analysis facilitates the presentation of information of financial statements in simplified and concise and summarized form. It is the process of establishing and interpreting various ratios for making certain decisions.
71
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
LIQUIDITY RATIOS
Liquidity ratios measure the ability of the firm to meet its current obligations as they fall due. Liquidity is the case with which assets may be converted into cash without loss. The failure of a company to meets its obligation due to lack of sufficient liquidity, will result in a poor credit worthiness, loss of creditor's confidence. Liquidity ratios usually consist of Current ratio, Quick ratio, Cash ratio etc.
A) Current Ratio:
This ratio expresses the relationship between current assets and current liabilities. This ratio is an indication of the companys ability to meet its short term liabilities. It is the ratio of current assets and current liabilities. The most ideal current ratio of a company is 2:1. This means every current liability should be covered by at least twice the amount of current assets. Here the current liabilities also consider the bank borrowings i.e., secured loans mentioned in the balance sheet. Current Ratio = Current Asset Current Liabilities Current Ratio Year 2009-10 2008-09 2007-08 2006-07 2005-06 Current Assets 1,595,986,683 1,994,490,892 1,823,279,621 1,535,462,677 1,221,358,455 Current Liabilities 860,675,005 1,022,286,575 863,491,435 681,312,393 539,325,732 Ratio 1.85 1.95 2.11 2.25 2.26
L&T has a current ratio of 1.85:1 and 1.95:1 for the financial year 2009-10 and 2008-09 respectively. This is interpreted to be insufficiently liquid but the previous years have maintained high liquidity. The current ratio of L&T, Kansbahal reveals that the obligations of the company can be met on time.
72
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
borrowings i.e., secured loans mentioned in the balance sheet. A ratio of 1:1 is
considered as ideal.
Quick Ratio = Liquid Asset Current Liabilities Current Ratio Year 2009-10 2008-09 2007-08 2006-07 2005-06 Liquid Assets 986,590,092 1,090,755,983 1,050,843,929 908,844,142 550,299,481 Current Liabilities 860,675,005 1,022,286,575 863,491,435 681,312,393 539,325,732 Ratio 1.15 1.07 1.22 1.33 1.02
The company has been maintaining a little more than necessary quick ratio of 1:1. Thus, if the L&Ts inventories do not sell and it has to pay all current liabilities it can easily meet its obligations because its quick assets are 1.15 times of current liabilities. High Quick ratio indicates the liquidity position of the firm. The quick ratio of the company reveals satisfactory liquidity position since it also has considerably fast moving debtors.
business activity. The ratios of this kind, attempt to find out the efficient utilization of asset by relating the same to sales/cost of goods sold.
Inventory Turnover Ratio Year 2009-10 2008-09 2007-08 2006-07 2005-06 Net Sales 3,38,49,58,254 2,97,83,53,765 2,58,72,04,708 2,31,50,28,433 1,70,92,98,528 Inventory 60,93,96,591 90,37,34,909 77,24,35,692 62,66,18,535 67,10,58,974 Ratio 5.55 3.30 3.35 3.69 2.55
This shows that L&T is turning its inventory into sales 5.5 times in the year 2009-10 which is more as compared to the previous years which indicates there is an efficient management of Inventory. In 2005-06 the ratio is very low i.e. 2.55 times. It indicates there is an inefficient management of Inventory. A low
implies efficient inventory control, sound sales policies, trading in quality goods, better competitive capacity & less money required to finance the inventory. Days of Inventory Holdings (DIH):
Days of Inventory Holdings (DIH) = Days in a year Inventory turnover ratio Days of Inventory Holdings (DIH) Year 2009-10 2008-09 2007-08 2006-07 2005-06 Days in a year 365 365 365 365 365 Inventory Turnover Ratio 5.55 3.3 3.35 3.69 2.55 DIH ( in days ) 65.77 110.61 108.96 98.92 143.14
L&T holds average inventory of 66 days in the year 2009-10 which is the minimum than in comparison to the previous years which is good for the company.
75
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
Debtors Turnover Ratio Year 2009-10 2008-09 2007-08 2006-07 2005-06 Net Sales 3,38,49,58,254 2,97,83,53,765 2,58,72,04,708 2,31,50,28,433 1,70,92,98,528 Debtors 79,19,16,010 75,18,68,597 90,56,40,467 76,32,29,126 43,99,44,793 Ratio(times) 4.27 3.96 2.86 3.03 3.89
Debtor turnover is high in the year 2009-10. i.e. 4.27 times in a year than in the other years which implies that Efficiency of management of debtors is good in the year than other. There is consistency maintained by L&T, Kansbahal and has an average of 3.60 times. The lowest ratio indicates the poor management of debtors. Average Collection Period: The ACP measures the quality of debtors since it indicates the speed of their collection. The shorter the ACP, the better the quality of debtors, since a short collection period implies the prompt payments by debtors. Average Collection Period (ACP) Year 2009-10 2008-09 2007-08 2006-07 2005-06 Days in a year 365 365 365 365 365 Debtors Turnover Ratio 4.27 3.96 2.86 3.03 3.89 ACP (in days) 85.48 92.17 127.62 120.46 93.83
76
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
L&T is able to turnover its debtors 4.27 times in a year. In other words, its debtor remains outstanding for 86 days. But in the previous years, its debtor remains outstanding for more number of days. This shows the efficient utilization of debtors.
Creditors Turnover Ratio Year 2009-10 2008-09 2007-08 2006-07 2005-06 Purchases 1,66,05,50,137 1,78,99,98,563 1,70,28,31,690 1,32,97,00,660 94,70,09,225 Creditors 88,67,01,395 98,65,49,929 83,50,87,133 62,82,81,770 47,79,47,196 Ratio(times) 1.87 1.81 2.04 2.12 1.98
Higher payable turnover ratio indicate less period of credit enjoyed by the business; it may be due to the fact that either business has better liquidity position; believes in availing cash discount and consequently enjoys better credit standing in the market or business credit rating among suppliers is not good and therefore they do not allow reasonable period of credit.
effectively used. It expresses the number of times the unit invested in working capital produces sale. It is calculated by simply dividing the net sales by net current assets. It helps in measuring the efficiency of the employment of
working capital. Generally speaking the higher the turnover, the greater the efficiency and larger the profits. However a very high ratio may signify a
potentially dangerous situation of the shortage of working capital. Working capital turnover ratio gives us a better and whole picture of efficiency and inefficiency than stock or inventory turnover ratio.
Working Capital Ratio Year 2009-10 2008-09 2007-08 2006-07 2005-06 Sales 3,38,49,58,254 2,97,83,53,765 2,58,72,04,708 2,31,50,28,433 1,70,92,98,528 Net Current Assets 70,43,62,533 95,56,60,369 91,43,72,348 85,85,97,867 69,30,23,272 Ratio(times) 4.81 3.12 2.83 2.7 2.47 Reciprocal of the ratios 0.21 0.32 0.35 0.37 0.40
The highest turnover is achieved in 2009-10. i.e. 4.81 and the lowest is in 2005-06. i.e. 2.47. A higher ratio indicates efficiency utilization of working capital in L&T, Kansbahal. The ratio can be used by making of comparative and trend analysis for different companies in the same industry and for various periods. The reciprocal of the ratios indicates that for one rupee of sales, the company needs Rs. 0.21 of net current assets. This gap will be met from bank borrowings and long term sources of funds.
78
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
Net Assets Turnover Ratio Year 2009-10 2008-09 2007-08 2006-07 2005-06 Net Sales 3,384,958,254 2,978,353,765 2,587,204,708 2,315,028,433 1,709,298,528 Net Assets 2,430,159,116 1,611,444,624 1,354,175,925 1,169,342,802 987,374,629 Ratio(times) 1.39 1.85 1.91 1.98 1.73
A firms ability to produce a large volume of sales for a given amount of net assets is the most important aspect of its operating performance. The net assets turnover in the year 2009-10 is 1.39 times which implies that L&T is producing Rs. 1.39 of sales for one rupee of capital employed in net assets. Net assets turnover in the year 2006-07 was good and hence forth it is declining. b) Total assets turnover: This ratio shows the firms ability in generating sales from all financing resources committed to total assets. Thus,
79
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
Total Assets Turnover Ratio Year 2009-10 2008-09 2007-08 2006-07 2005-06 Net Sales 3,384,958,254 2,978,353,765 2,587,204,708 2,315,028,433 1,709,298,528 Total Assets 3,321,783,267 2,650,275,147 2,263,083,198 1,846,207,612 1,515,709,812 Ratio(times) 1.02 1.12 1.14 1.25 1.13
The total assets turnover of 1.02 times in the year 2009-10 implies that L&T generates a sale of Rs. 1.02 for one rupee investment in fixed and current assets together. c) Fixed and Current Assets Turnover Ratio
This ratio measures sales per rupee of investment in fixed and current assets. This ratio establishes the relationship between sales and fixed &
current assets. The purpose is to judge whether the firm is generating adequate sales for the investment in fixed & current assets of the firm. The term fixed assets include land and buildings, plant and machinery, furniture, etc., after the depreciation. Net fixed assets includes net block of both tangible as well as intangible assets. This ratio is supposed to measure the efficiency with which fixed assets are employed. A high ratio indicates a high degree of efficiency in asset utilization and a low ratio reflects inefficient use of assets.
80
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
Fixed Assets Turnover Ratio Net Fixed Reciprocal of the Net Sales Assets Ratio(times) ratios 3,384,958,254 2,978,353,765 2,587,204,708 2,315,028,433 1,709,298,528 1,725,796,584 655,784,255 439,803,577 310,744,935 294,351,357 1.96 4.54 5.88 7.45 5.81 0.510204 0.220264 0.170068 0.134228 0.172117
Interpreting the reciprocals of the ratios, it can be said that in the year 200910, for generating a sale of one rupee, the company needs respectively Rs. 0.51 investment in the fixed assets. The term current assets include inventories, sundry debtors, cash and bank balances and loans and advances.
Current Assets Turnover Ratio Year Net Sales Current Assets 1,595,986,683 1,994,490,892 1,823,279,621 1,535,462,677 1,221,358,455 Ratio(times) 2.12 1.49 1.42 1.51 1.4 Reciprocal of the ratios 0.471698 0.671141 0.704225 0.662252 0.714286
2009-10 3,384,958,254 2008-09 2,978,353,765 2007-08 2,587,204,708 2006-07 2,315,028,433 2005-06 1,709,298,528
Interpreting the reciprocals of the ratios, it can be said that in the year 200910, for generating a sale of one rupee, the company needs respectively Rs. 0.47 investment in the fixed assets. In the year 2009-10, L&T turned over its current assets faster than fixed assets but in the previous years 2005-06 to 2008-09 L&T turned over its fixed assets faster than current assets.
81
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
INVENTORY MANAGEMENT
82
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
INVENTORY MANAGEMENT
Inventories are stock of the product of a company is manufacturing for sale and components that make up the product. The various forms in which inventories exist in a manufacturing company are: a) Raw materials - are materials and components that are inputs in making the final product. b) Stock-in-process - refers to goods in the intermediate stages of production and, c) Finished goods - consists of the final products that are ready for sale. Inventories constitute the most significant part of current assets of a company. On an average, Inventories are approximately 60 percent of the current assets in public limited companies in India. Inventories represent the second largest asset category for manufacturing companies, next only to plant and equipment. There are three general motives for holding inventories: Transactions motive, Precautionary motive & Speculative motive. The investment in inventory is very high in most of the undertakings engaged in manufacturing. The amount of investment is sometimes more in inventory than in other assets. About 90 percent part of working capital is invested in inventories. It is necessary for every management to give proper attention to inventory management. An efficient system of inventory management will determine: What to purchase? How much to purchase? Where to purchase? Where to store?
83
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
Cost associated with Inventory: There are two types of cost associated with inventory at L&T, Kansbahal. They are: i. Ordering cost are cost incurred for acquiring of raw materials. It includes Requisitioning, Order Placing, Transportation, Receiving, storing, inspecting and clerical and staff. ii. Cost incurred for maintaining a given level of inventory is called Carrying
INVENTORY MANAGEMENT AT L&T, KANSBAHAL There are two types of inventory considered in L&T, Kansbahal. They are: General Inventories Projected Inventories. L&T, Kansbahal Works is not a process industry where only general inventories are required. They purchase the Raw Materials and stored as per their order. Those raw materials can be used only against certain order. So they purchase raw materials as per their order and against a specific job. These Inventories are projected inventories. The maximum investment by L&T, Kansbahal in inventories are of projected Inventories type. Some of the common materials which can be used in other job also are general Inventories. These Inventories required proper stock and the methods to
84
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
control and manage these inventories. They are: EOQ, maximum level, minimum level and re-ordering level. L&T, Kansbahal uses ERP (People Soft), which help them to find out the EOQ, maximum level, minimum level and re-ordering level. The data regarding the Stock can be found out with the help of ERP system. This system makes the control system very easy, because, at any point of time we can get the inventory status. It helps for planning and controlling of inventory. The percentage of inventory over current assets for last five years: Year 2009-10 2008-09 2007-08 2006-07 2005-06 Inventory 60,93,96,591 90,37,34,909 77,24,35,692 62,66,18,535 67,10,58,974 Current Assets 1,59,59,86,683 1,99,44,90,892 1,82,32,79,621 1,53,54,62,677 1,22,13,58,455 Ratio (%) 38.18 45.31 42.37 40.81 54.94
The average portion of inventory in current asset is about 45% in the last 5 years. So in L&T inventory plays a vital role in current assets.
85
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
Inventory Turnover Ratio Year 2009-10 2008-09 2007-08 2006-07 2005-06 Net Sales 3,38,49,58,254 2,97,83,53,765 2,58,72,04,708 2,31,50,28,433 1,70,92,98,528 Inventory 60,93,96,591 90,37,34,909 77,24,35,692 62,66,18,535 67,10,58,974 Ratio(times) 5.55 3.30 3.35 3.69 2.55
A low ratio implies over-investment in inventories whereas a high ratio implies less money required to finance the inventory. From the above table, it is found that, there is an improvement in ratio which indicates the improvement in the management of inventory. The table shows that L&T is turning its inventory into sales 5.5 times in the year 2009-10 which is more as compared to the previous years which indicates there is an efficient management of Inventory. In 2005-06 the ratio is very low i.e. 2.55 times. It indicates there is an inefficient management of Inventory. A low ratio implies over-investment in inventories, possibility of stock comprising of obsolete items, slow moving products & poor selling policy; whereas a high ratio implies efficient inventory control, sound sales policies, trading in quality goods, better competitive capacity & less money required to finance the inventory.
86
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
Days of Inventory Holdings (DIH) Year 2009-10 2008-09 2007-08 2006-07 2005-06 Days in a year 365 365 365 365 365 Inventory Turnover Ratio 5.55 3.3 3.35 3.69 2.55 DIH ( in days ) 65.77 110.61 108.96 98.92 143.14
L&T holds average inventory of 66 days in the year 2009-10 which is the minimum than in comparison to the previous years which is good for the company.
\\\
87
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
RESEARCH FINDINGS
During my entire tenure of two months, I came to know the various theoretical concepts are used in practise. The kind of practical exposure that I have got here and the guidance given by my project guide has made me aware of theories, concepts and their applications in real industry environment which cannot be learnt in regular classroom teachings. Concepts like Capital Budgeting, Working Capital Management, Ratio Analysis, NPV, Payback period IRR and several other concepts has now become very easy to understand. L&T is a manufacturing concern where I got ample opportunity to know about the working conditions and procedures applied, which helped me a lot in achieving my objective viz., to begin my career as a financial analyst. Apart from above
88
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
CONCLUSION
89
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
BIBLIOGRAPHY
Annual Accounts (2005-06 to 2009-10) Annual Reports (2005-06 to 2009-10) Magazines (published by L&T,Kansbahal) Financial Management (I M Pandey) Financial Management ( P Chandra) Financial Management ( Shashi K.Gupta) www.lntkbl.com www.larsentoubro.com www.lntenc.com
90
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
91
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
496,538,010 496,538,010
92
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
447770549 447770549
93
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
360757850 360757850
94
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
300222171 300222171
95
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
144951310 144951310
96
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
PROFIT AND LOSS A/C FOR THE PERIOD ENDED MARCH 31, 2010
PARTICULARS A) INCOME: Sales & Service(Gross) Less: Excise Duty Sales & Service(Net) Other Income Interest Income B) EXPENDITURE Mfg Construction & Operating expenses Staff Expenses Sales Administration & Other Expenses Interest & Brokerage Depreciation, obsolescence & Impairment Amortization of intangible assets Less: Overheads charged to Fixed Assets Profit before transfer from revaluation reserve Add: Transfer from revaluation reserve Profit before tax before extra ordinary items Provision for Fringe Benefit Tax Profit after tax before extra ordinary items Profit after tax after extra ordinary items Profit after tax after Minority Interest Profit available for appropriation Profit available for distribution Balance carried to Balance Sheet 488571913 488571913 488571913 488571913 488571913 488571913 M N O P 2386604263 376954805 119966357 3635983 84554446 2652401 2974368255 84423639 2889944616 486342570 2229343 488571913 L(ii) L(iii) K 3534651997 149693743 3384958254 2898475 -11569542 3376287186 01.04.2009 to 31.03.2010 Schedules Rupees Rupees
97
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
PROFIT AND LOSS A/C FOR THE PERIOD ENDED MARCH 31, 2009
PARTICULARS A) INCOME: Sales & Service(Gross) Less: Excise Duty Sales & Service(Net) Other Income Interest Income B) EXPENDITURE Mfg Construction & Operating expenses Staff Expenses Sales Administration & Other Expenses Interest & Brokerage
Depreciation, obsolescence & Impairment
01.04.2008 to 31.03.2009 Schedules K Rupees 3190229157 211875392 2978353765 L(ii) L(iii) 5196993 1151516 2983702274 M N O P 2013471320 352877527 168814257 658562 49825894 1943257 2587590817 Rupees
Amortization of intangible assets Less: Overheads charged to Fixed Assets Profit before transfer from revaluation reserve Add: Transfer from revaluation reserve Profit before tax before extra ordinary items Provision for Fringe Benefit Tax Profit after tax before extra ordinary items Profit after tax after extra ordinary items Profit after tax after Minority Interest Profit available for appropriation Profit available for distribution Balance carried to Balance Sheet
42020019 2545570798 439131476 2021268 441152744 3577635 3577635 437575109 437575109 437575109 437575109 437575109 437575109
98
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
PROFIT AND LOSS A/C FOR THE PERIOD ENDED MARCH 31, 2008
PARTICULARS A) INCOME: Sales & Service(Gross) Less: Excise Duty Sales & Service(Net) Other Income Interest Income B) EXPENDITURE Mfg Construction & Operating expenses Staff Expenses Sales Administration & Other Expenses Interest & Brokerage Depreciation, obsolescence & Impairment Amortization of intangible assets Less: Overheads charged to Fixed Assets Profit before transfer from revaluation reserve Add: Transfer from revaluation reserve Profit before tax before extra ordinary items Provision for Fringe Benefit Tax Profit after tax before extra ordinary items Profit after tax after extra ordinary items Profit after tax after Minority Interest Profit available for appropriation Profit available for distribution Balance carried to Balance Sheet 3609716 3609716 348541143 348541143 348541143 348541143 348541143 348541143 M N O P 1822365888 328025833 102137136 164119 44229714 2316022 2299238713 7225595 2292013118 350142442 2008417 352150859 L(ii) L(iii) K 2854005574 266800866 2587204708 53258160 1692693 2642155561 01.04.2007 to 31.03.2008 Schedules Rupees Rupees
99
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
PROFIT AND LOSS A/C FOR THE PERIOD ENDED MARCH 31, 2007
PARTICULARS A) INCOME: Sales & Service(Gross) Less: Excise Duty Sales & Service(Net) Other Income Interest Income B) EXPENDITURE Mfg Construction & Operating expenses Staff Expenses Sales Administration & Other Expenses Interest & Brokerage Depreciation, obsolescence & Impairment Amortization of intangible assets Less: Overheads charged to Fixed Assets Profit before transfer from revaluation reserve Add: Transfer from revaluation reserve Profit before tax before extra ordinary items Provision for Fringe Benefit Tax Profit after tax before extra ordinary items Profit after tax after extra ordinary items Profit after tax after Minority Interest Profit available for appropriation Profit available for distribution Balance carried to Balance Sheet 2956526 2956526 285997047 285997047 285997047 285997047 285997047 285997047 M N O P 1613630126 267879316 105029401 1632041 46384185 2980421 20375355490 2776011 2034759479 286982603 1970970 288953573 L(ii) L(iii) K 2529356302 214327869 2315028433 5770183 943466 2321742082 01.04.2006 to 31.03.2007 Schedules Rupees Rupees
100
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
PROFIT AND LOSS A/C FOR THE PERIOD ENDED MARCH 31, 2006
PARTICULARS 01.04.2005 to 31.03.2006 Schedules A) INCOME: Sales & Service(Gross) Less: Excise Duty Sales & Service(Net) Other Income Interest Income L(ii) L(iii) K 1869960759 160662231 1709298528 16999842 0 1726298370 B) EXPENDITURE Mfg Construction & Operating expenses Staff Expenses Sales Administration & Other Expenses Interest & Brokerage Depreciation, obsolescence & Impairment Amortization of intangible assets M N O P 1203835844 232615117 111819499 -425743 47997793 2646410 1598488920 Less: Overheads charged to Fixed Assets Profit before transfer from revaluation reserve Add: Transfer from revaluation reserve Profit before tax before extra ordinary items Provision for Fringe Benefit Tax Profit after tax (PAT) Profit available for appropriation Profit available for distribution Balance carried to Balance Sheet 3152464 1595336456 130961914 1943962 132905876 4150660 128755216 128755216 128755216 128755216 Rupees Rupees
101
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
ANNEXURE
102
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
RETURN ON INVESTMENT
SIGNATURE: DATE:
103
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR
PAYBACK PERIOD
QUANTITY OR HOURS
600
BASIS TOTAL EXISTING CAPACITY OF SIMILAR FACILITIES TOTAL LOAD x 100% HOURS TWO SHIFT THREE SHIFT YEAR 4600 5400 4600 9200 TOTAL CAPACITY CAPACITY INCREASE REQD. TO REMOVE BOTTLENECK QTY. OR HOURS CAPACITY OF PROPOSED FACILITY QTY. OR HOURS INCREASED CAPACITY AFTER THE PROPOSED ADDITION QTY. OR HOURS
FACILITIES AFTER PROPOSED ADDITION LOAD FORECAST QTY OR HOURS (MT) CAPACITY UTILISATION (MT) TWO THREE SHIFT SHIFT BASIS BASIS
OTHER BALANCING FACILITIES REQUIRED FACILITY VALUE RS. Lacs WHEN REQD.
BUDGET YR 2007-08 BUDGET YR+1 2008-09 BUDGET YR+2 2009-10 BUDGET YR+3 2010-11 BUDGET YR+4 2011-12 BUDGET YR+4 2012-13 10000 12000 14000 16000 18000 7800 9360 10920 12480 14040
RAW MATERIAL,SPARES
YES
NO
2. IF NOT, HOW ELSE? 2. IF NOT, HOW ELSE? YES NO Some imported spares would be required. CONSTRAINTS / LIMITATIONS (KNOWN /LIKELY)
104
105
KIIT SCHOOL OF MANAGEMENT, BHUBANESWAR