MBA FINANCE MANAGEMENT CASE STUDY ANSWER PROVIDED WHATSAPP 91 9924764558
DR. PRASANTH MBA PH.D. DME MOBILE / WHATSAPP: +91 9924764558 OR +91 9447965521 EMAIL: email@example.com WEBSITE: www.casestudyandprojectreports.com
Case 1: Zip Zap Zoom Car Company
Zip Zap Zoom Company Ltd is into manufacturing cars in the small car (800 cc) segment. It was set up 15 years back and since its establishment it has seen a phenomenal growth in both its market and profitability. Its financial statements are shown in Exhibits 1 and 2 respectively.
The company enjoys the confidence of its shareholders who have been rewarded with growing dividends year after year. Last year, the company had announced 20 per cent dividend, which was the highest in the automobile sector. The company has never defaulted on its loan payments and enjoys a favorable face with its lenders, which include financial institutions, commercial banks and debenture holders.
The competition in the car industry has increased in the past few years and the company foresees further intensification of competition with the entry of several foreign car manufactures many of them being market leaders in their respective countries. The small car segment especially, will witness entry of foreign majors in the near future, with latest technology being offered to the Indian customer. The Zip Zap Zoom’s senior management realizes the need for large scale investment in up gradation of technology and improvement of manufacturing facilities to pre-empt competition.
Whereas on the one hand, the competition in the car industry has been intensifying, on the other hand, there has been a slowdown in the Indian economy, which has not only reduced the demand for cars, but has also led to adoption of price cutting strategies by various car manufactures. The industry indicators predict that the economy is gradually slipping into recession.
Exhibit 1 Balance sheet as at March 31,200 x
(Amount in Rs. Crore)
Source of Funds
Share capital 350
Reserves and surplus 250 600
Debentures (@ 14%) 50
Institutional borrowing (@ 10%) 100
Commercial loans (@ 12%) 250
Total debt 400
Current liabilities 200
Application of Funds
Gross block 1,000
Less : Depreciation 250
Net block 750
Capital WIP 190
Total Fixed Assets 940
Current assets :
Sundry debtors 40
Cash and bank balance 10
Other current assets 10
Total current assets 260
Exhibit 2 Profit and Loss Account for the year ended March 31, 200x
(Amount in Rs. Crore)
Sales revenue (80,000 units x Rs. 2,50,000) 2,000.0
Operating expenditure :
Variable cost :
Raw material and manufacturing expenses 1,300.0
Variable overheads 100.0
Fixed cost :
R & D 20.0
Marketing and advertising 25.0
Total operating expenditure 1,765.0
Operating profits (EBIT) 235.0
Financial expense :
Interest on debentures 7.7
Interest on institutional borrowings 11.0
Interest on commercial loan 33.0 51.7
Earnings before tax (EBT) 183.3
Tax (@ 35%) 64.2
Earnings after tax (EAT) 119.1
Debt redemption (sinking fund obligation)** 40.0
Contribution to reserves and surplus 9.1
* Includes the cost of inventory and work in process (W.P) which is dependent on demand (sales).
** The loans have to be retired in the next ten years and the firm redeems Rs. 40 crore every year.
The company is faced with the problem of deciding how much to invest in up
gradation of its plans and technology. Capital investment up to a maximum of Rs. 100
crore is required. The problem areas are three-fold.
• The company cannot forgo the capital investment as that could lead to reduction in its market share as technological competence in this industry is a must and customers would shift to manufactures providing latest in car technology.
• The company does not want to issue new equity shares and its retained earning are not enough for such a large investment. Thus, the only option is raising debt.
• The company wants to limit its additional debt to a level that it can service without taking undue risks. With the looming recession and uncertain market conditions, the company perceives that additional fixed obligations could become a cause of financial distress, and thus, wants to determine its additional debt capacity to meet the investment requirements.
Mr. Shortsighted, the company’s Finance Manager, is given the task of determining the additional debt that the firm can raise. He thinks that the firm can raise Rs. 100 crore worth debt and service it even in years of recession. The company can raise debt at 15 per cent from a financial institution. While working out the debt capacity. Mr. Shortsighted takes the following assumptions for the recession years.
a) A maximum of 10 percent reduction in sales volume will take place.
b) A maximum of 6 percent reduction in sales price of cars will take place.
Mr. Shorsighted prepares a projected income statement which is representative of the recession years. While doing so, he determines what he thinks are the “irreducible minimum” expenditures under
recessionary conditions. For him, risk of insolvency is the main concern while designing the capital structure. To support his view, he presents the income statement as shown in Exhibit 3.
Exhibit 3 projected Profit and Loss account
(Amount in Rs. Crore)
Sales revenue (72,000 units x Rs. 2,35,000) 1,692.0
Variable cost :
Raw material and manufacturing expenses 1,170.0
Variable overheads 90.0
Fixed cost :
R & D —
Marketing and advertising 15.0
Total operating expenditure 1,532.5
Financial expenses :
Interest on existing Debentures 7.0
Interest on existing institutional borrowings 10.0
Interest on commercial loan 30.0
Interest on additional debt 15.0 62.0
Tax (@ 35%) 34.1
Debt redemption (sinking fund obligation) 50.0*
Contribution to reserves and surplus 13.4
* Rs. 40 crore (existing debt) + Rs. 10 crore (additional debt)
Assumptions of Mr. Shorsighted
• R & D expenditure can be done away with till the economy picks up.
• Marketing and advertising expenditure can be reduced by 40 per cent.
• Keeping in mind the investor confidence that the company enjoys, he feels that the company can forgo paying dividends in the recession period.
He goes with his worked out statement to the Director Finance, Mr. Arthashatra, and advocates raising Rs. 100 crore of debt to finance the intended capital investment. Mr. Arthashatra does not feel comfortable with the statements and calls for the company’s financial analyst, Mr. Longsighted.
Mr. Longsighted carefully analyses Mr. Shortsighted’s assumptions and points out that insolvency should not be the sole criterion while determining the debt capacity of the firm. He points out the following :
• Apart from debt servicing, there are certain expenditures like those on R & D and marketing that need to be continued to ensure the long-term health of the firm.
• Certain management policies like those relating to dividend payout, send out important signals to the investors. The Zip Zap Zoom’s management has been paying regular dividends and discontinuing this practice (even though just for the recession phase) could raise serious doubts in the investor’s mind about the health of the firm. The firm should pay at least 10 per cent dividend in the recession years.
• Mr. Shortsighted has used the accounting profits to determine the amount available each year for servicing the debt obligations. This does not give the true picture. Net cash inflows should be used to determine the amount available for servicing the debt.
• Net Cash inflows are determined by an interplay of many variables and such a simplistic view should not be taken while determining the cash flows in recession. It is not possible to accurately predict the fall in any of the factors such as sales volume, sales price, marketing expenditure and so on. Probability distribution of variation of each of the factors that affect net cash inflow should be analyzed. From this analysis, the probability distribution of variation in net cash inflow should be analysed (the net cash inflows follow a normal probability distribution). This will give a true picture of how the company’s cash flows will behave in recession conditions.
The management recognizes that the alternative suggested by Mr. Longsighted rests on data, which are complex and require expenditure of time and effort to obtain and interpret. Considering the importance of capital structure design, the Finance Director asks Mr. Longsighted to carry out his analysis. Information on the behaviour of cash flows during the recession periods is taken into account.
The methodology undertaken is as follows :
(a) Important factors that affect cash flows (especially contraction of cash flows), like sales volume, sales price, raw materials expenditure, and so on, are identified and the analysis is carried out in terms of cash receipts and cash expenditures.
(b) Each factor’s behaviour (variation behaviour) in adverse conditions in the past is studied and future expectations are combined with past data, to describe limits (maximum favourable), most probable and maximum adverse) for all the factors.
(c) Once this information is generated for all the factors affecting the cash flows, Mr. Longsighted comes up with a range of estimates of the cash flow in future recession periods based on all possible combinations of the several factors. He also estimates the probability of occurrence of each estimate of cash flow.
Assuming a normal distribution of the expected behaviour, the mean expected
value of net cash inflow in adverse conditions came out to be Rs. 220.27 crore with standard deviation of Rs. 110 crore.
Keeping in mind the looming recession and the uncertainty of the recession behaviour, Mr. Arthashastra feels that the firm should factor a risk of cash inadequacy of around 5 per cent even in the most adverse industry conditions. Thus, the firm should take up only that amount of additional debt that it can service 95 per cent of the times, while maintaining cash adequacy.
To maintain an annual dividend of 10 per cent, an additional Rs. 35 crore has to be kept aside. Hence, the expected available net cash inflow is Rs. 185.27 crore (i.e. Rs. 220.27 – Rs. 35 crore)
Analyse the debt capacity of the company.
CASE – 2 GREAVES LIMITED
Started as trading firm in 1922, Greaves Limited has diversified into manufacturing and marketing of high technology engineering products and systems. The company’s mission is “manufacture and market a wide range of high quality products, services and systems of world class technology to the total satisfaction of customers in domestic and overseas market.”
Over the years Greaves has brought to India state of the art technologies in various engineering fields by setting up manufacturing units and subsidiary and associate companies. The sales of Greaves Limited has increased from Rs 214 crore in 1990 to Rs 801 crore in 1997. The sales of Greaves Limited has increased from Rs 214 crore in 1990 to Rs 801 crore in 1997. Profits before interest and tax (PBIT) of the company increased from Rs 15 crore to Rs 83 crore in 1997. The market price of the company’s share has shown ups and downs during 1990 to 1997. How has the company performed? The following question need answer to fully understand the performance of the company:
Profit and Loss Account ending on 31 March (Rupees in crore)
1990 1991 1992 1993 1994 1995 1996 1997
Raw Material and Stores
Wages and Salaries
Power and fuel
Other Mfg. Expenses
Marketing and Distribution
Change in stock 214.38
– 1.13 521.56
Total Op Expenses 202.72 239.40 268.91 291.85 338.77 493.41 672.20 731.75
PBIT 15.10 19.67 23.97 34.51 39.64 42.98 65.67 82.64
Interest 5.56 6.77 11.92 19.62 17.17 21.48 28.25 27.54
PBT 9.54 12.90 12.05 14.89 22.47 21.50 37.42 55.10
Retained Earnings 3.00
Balance Sheet (Rupees in crore)
1990 1991 1992 1993 1994 1995 1996 1997
Land and Building
Plant and Machinery
Other Fixed Assets
Gross Fixed Assets
Less: Accu. Depreciation
Net Tangible Fixed Assets
Intangible Fixed Assets
Net Fixed Assets 6.89 6.93 7.83 56.20 119.68 126.50 135.10 139.97
Cash and Bank Balance
LIABILITIES AND CAPITAL
Reserves and Surplus
Net Worth 37.66 42.63 47.48 119.39 200.60 206.52 219.81 243.19
Current Portion of LT Debt 14.81
Borrowings 38.35 57.12 73.72 84.61 130.82 158.73 183.94 203.66
Provision for tax, etc.
Current Portion of LT Dept 37.52
Current Liabilities 48.20 65.38 77.56 85.35 141.85 166.42 181.86 220.01
Share premium reserve
Bonus equity capital 124.21
Share Price Data
1990 1991 1992 1993 1994 1995 1996 1997
Closing share price (Rs)
Yearly high share price (Rs)
Yearly low share price (Rs)
Market capitalization (Rs crore
Book value (Rs) 27.19
1. How profitable are its operations? What are the trends in it? How has growth affected the profitability of the company?
2. What factors have contributed to the operating performance of Greaves Limited? What is the role of profitability margin, asset utilisation, and non-operating income?
3. How has Greaves performed in terms of return on equity? What is the contribution of return on investment, the way of the business has been financed over the period?
CASE – 3 CHOOSING BETWEEN PROJECTS IN ABC COMPANY
ABC Company, has three projects to choose from. The Finance Manager, the operations manager are discussing and they are not able to come to a proper decision. Then they are meeting a consultant to get proper advice. As a consultant, what advice you will give?
The cash flows are as follows. All amounts are in lakhs of Rupees.
Duration 5 Years
Beginning cash outflow = Rs. 100
Cash inflows (at the end of the year)
Yr. 1 – Rs 30; Yr. 2 – Rs 30; Yr. 3 – Rs 30; Yr.4 – 10; Yr.5 – 10
Duration 5 Years
Beginning Cash outflow Rs. 3763
Cash inflows (at the end of the year)
Yr. 1 – 200; Yr. 2 – 600; Yr. 3 – 1000; Yr. 4 – 1000; Yr. 5 – 2000.
Duration 15 Years
Beginning Cash Outflow – Rs. 100
Cash Inflows (at the end of the year)
Yrs. 1 to 10 – Rs. 20 (for 10 continuous years)
Yrs. 11 to 15 – Rs. 10 (For the next 5 years)
If the cost of capital is 8%, which of the 3 projects should the ABC Company accept?
CASE – 4 STAR ENGINEERING COMPANY
Star Engineering Company (SEC) produces electrical accessories like meters, transformers, switchgears, and automobile accessories like taximeters and speedometers.
SEC buys the electrical components, but manufactures all mechanical parts within its factory which is divided into four production departments Machining, Fabrication, Assembly, and Painting—and three service departments—Stores, Maintenance, and Works Office.
Though the company prepared annual budgets and monthly financial statements, it had no formal cost accounting system. Prices were fixed on the basis of what the market can bear. Inventory of finished stocks was valued at 90 per cent of the market price assuming a profit margin of 10 per cent.
In March, the company received a trial order from a government department for a sample transformer on a cost-plus-fixed-fee basis. They took up the job (numbered by the company as Job No 879) in early April and completed all manufacturing operations before the end of the month.
Since Job No 879 was very different from the type of transformers they had manufactured in the past, the company did not have a comparable market price for the product. The purchasing officer of the government department asked SEC to submit a detailed cost sheet for the job giving as much details as possible regarding material, labour and overhead costs.
SEC, as part of its routine financial accounting system, had collected the actual expenses for the month of April, by 5th of May. Some of the relevant data are given in Exhibit A.
The company tried to assign directly, as many expenses as possible to the production departments. However, It was not possible in all cases. In many cases, an overhead cost, which was common to all departments had to be allocated to the various departments using some rational basis. Some of the possible bases were collected by SEC’s accountant. These are presented in Exhibit B.
He also designed a format to allocate the overhead to all the production and service departments. It was realized that the expenses of the service departments on some rational basis. The accountant thought of distributing the service departments’ costs on the following basis:
a. Works office costs on the basis of direct labour hours.
b. Maintenance costs on the basis of book value of plant and machinery.
c. Stores department costs on the basis of direct and indirect materials used.
The accountant who had to visit the company’s banker, passed on the papers to you for the required analysis and cost computations.
Based on the data given in Exhibits A and B, you are required to:
1. Complete the attached “overhead cost distribution sheet” (Exhibit C).
Note: Wherever possible, identify the overhead costs chared directly to the production and service departments. If such direct identification is not possible, distribute the costs on some “rational basis.
2. Calculate the overhead cost (per direct labour hour) for each of the four producing departments. This should include share of the service departments’ costs.
3. Do you agree with:
a. The procedure adopted by the company for the distribution of overhead costs?
b. The choice of the base for overhead absorption, i.e. labour-hour rate?
STAR ENGINEERING COMPANY
Actual Expenses(Manufacturing Overheads) for April
Indirect Labour and Supervisions:
Indirect Materials and Supplies
Depreciation of Plant and Machinery
Building Rates and Taxes
(At 2 per cent of direct labour wages and Indirect labour and supervision)
(Maintenance—Rs 366; Works Office Rs 2,200, Balance to Producing Departments)
Works Office Salaries and Expenses
Miscellaneous Stores Department Expenses
STAR ENGINEERING COMPANY
Projected Operation Data for the Year
(sq.m) Original Book of Plant & Machinery
Rs Direct Materials
The estimates given in this exhibit are for the budgeted year January to December where as the actuals in Exhibit A are just one month—April of the budgeted year.
STAR ENGINEERING COMPANY
Actual Overhead Distribution Sheet for April
Overhead Costs Production Departments Service Departments Total Amount Actuals for April (Rs) Basis for Distribution
A. Allocation of Overhead to all departments
A.1 Indirect Labour and Supervision
A.2 Indirect materials and supplies
A.3 Factory Rent 1,68,000
A.4 Depreciation of Plant and Machinery
A.5 Building Rates and Taxes
A.6 Welfare Expenses
A.7 Power 68,586
A.8 Works Office Salaries and Expenses
A.9 Miscellaneous Stores Expenses
A. Total (A.1 to A.9) 5,96,430
B. Reallocation of Service Departments Costs to Production Departments
B.1 Distribution of Works Office Costs
B.2 Distribution of Maintenance Department’s Costs
B.3 Distribution of Stores Department’s Costs
Total Charged to Producing
C. Departments (A+B)
D. Labour Hours Actuals for April
E. Overhead Rate/Per Hour (D)
Case 5: EASTERN MACHINES COMPANY
Raj, who was in charge production felt that there are many problems to be attended to. But Quality Control was the main problem, he thought, as he found there were more complaints and litigations as compared to last year. With the demand increasing, he does not want to take any chances.
So he went down to assembly line, but was greeted by an unfamiliar face. He introduced himself.
Raj: I am in charge of checking the components, which we use, when we assemble the machines for customers. For most of the components, suppliers are very reliable and we assume that there will not be any problem. When we generally test the end product, we don’t have failures.
Namdeo: I am Namdeo. I was in another dept. and has been transferred recently to this dept.
Raj: Recently we have been having problems, and there has been some complaint or other about the machines we have supplied. I am worried and would like to check the components used. I would like to avoid lot of expensive rework.
Namdeo: But it would be very expensive to test every one of them. It will take at least half an hour for each machine. I neither have the staff nor the time. It will be rather pointless as majority of them will pass the test.
Raj: There has been more demand than supply for these machines in last 2 years. We have been buying many components from many suppliers. We have been producing more with extra shifts. We are trying to capture the market and increase our market share.
Namdeo: We order for components from different places, and sometimes we do not have time to check all. There is a time lag between order and supply of components, and we cannot wait as production will stop. We use whatever comes soon as we want to complete our orders.
Raj: Oh! Obviously we need some kind of checking. Some sampling technique to check the quality of the components. We need to get a sample from each shipment from our component suppliers. But I do not know how many we should test.
Namdeo: We should ask somebody from our statistics dept. to attend to this problem.
As a Statistician, advice what kind of Sampling schemes can we consider, and what factors will influence choice of scheme. What are the questions we should ask Mr. Namdeo, who works in the assembly line?
CASE : 01
COOKING LPG LTD
DETERMINATION OF WORKING CAPTIAL
Cooking LPG Ltd, Gurgaon, is a private sector firm dealing in the bottling and supply of domestic LPG for household consumption since 1995. The firm has a network of distributors in the districts of Gurgaon and Faridabad. The bottling plant of the firm is located on National Highway – 8 (New Delhi – Jaipur), approx. 12 kms from Gurgaon. The firm has been consistently performing we.” and plans to expand its market to include the whole National Capital Region.
The production process of the plant consists of receipt of the bulk LPG through tank trucks, storage in tanks, bottling operations and distribution to dealers. During the bottling process, the cylinders are subjected to pressurized filling of LPG followed by quality control and safety checks such as weight, leakage and other defects. The cylinders passing through this process are sealed and dispatched to dealers through trucks. The supply and distribution section of the plant prepares the invoice which goes along with the truck to the distributor.
Statement of the Problem :
Mr. I. M. Smart, DGM(Finance) of the company, was analyzing the financial performance of the company during the current year. The various profitability ratios and parameters of the company indicated a very satisfactory performance. Still, Mr. Smart was not fully content-specially with the management of the working capital by the company. He could recall that during the past year, in spite of stable demand pattern, they had to, time and again, resort to bank overdrafts due to non-availability of cash for making various payments. He is aware that such aberrations in the finances have a cost and adversely affects the performance of the company. However, he was unable to pinpoint the cause of the problem.
He discussed the problem with Mr. U.R. Keenkumar, the new manager (Finance). After critically examining the details, Mr. Keenkumar realized that the working capital was hitherto estimated only as approximation by some rule of thumb without any proper computation based on sound financial policies and, therefore, suggested a reworking of the working capital (WC) requirement. Mr. Smart assigned the task of determination of WC to him.
Profile of Cooking LPG Ltd.
1) Purchases : The company purchases LPG in bulk from various importers ex-Mumbai and Kandla, @ Rs. 11,000 per MT. This is transported to its Bottling Plant at Gurgaon through 15 MT capacity tank trucks (called bullets), hired on annual contract basis. The average transportation cost per bullet ex-either location is Rs. 30,000. Normally, 2 bullets per day are received at the plant. The company make payments for bulk supplies once in a month, resulting in average time-lag of 15 days.
2) Storage and Bottling : The bulk storage capacity at the plant is 150 MT (2 x 75 MT storage tanks) and the plant is capable of filling 30 MT LPG in cylinders per day. The plant operates for 25 days per month on an average. The desired level of inventory at various stages is as under.
• LPG in bulk (tanks and pipeline quantity in the plant) – three days average production / sales.
• Filled Cylinders – 2 days average sales.
• Work-in Process inventory – zero.
3) Marketing : The LPG is supplied by the company in 12 kg cylinders, invoiced @ Rs. 250 per cylinder. The rate of applicable sales tax on the invoice is 4 per cent. A commission of Rs. 15 per cylinder is paid to the distributor on the invoice itself. The filled cylinders are delivered on company’s expense at the distributor’s godown, in exchange of equal number of empty cylinders. The deliveries are made in truck-loads only, the capacity of each truck being 250 cylinders. The distributors are required to pay for deliveries through bank draft. On receipt of the draft, the cylinders are normally dispatched on the same day. However, for every truck purchased on pre-paid basis, the company extends a credit of 7 days to the distributors on one truck-load.
4) Salaries and Wages : The following payments are made :
• Direct labour – Re. 0.75 per cylinder (Bottling expenses) – paid on last day of the month.
• Security agency – Rs. 30,000 per month paid on 10th of subsequent month.
• Administrative staff and managers – Rs. 3.75 lakh per annum, paid on monthly basis on the last working day.
5) Overheads :
• Administrative (staff, car, communication etc) – Rs. 25,000 per month – paid on the 10th of subsequent month.
• Power (including on DG set) – Rs. 1,00,000 per month paid on the 7th Subsequent month.
• Renewal of various licenses (pollution, factory, labour CCE etc.) – Rs. 15,000 per annum paid at the beginning of the year.
• Insurance – Rs. 5,00,000 per annum to be paid at the beginning of the year.
• Housekeeping etc – Rs. 10,000 per month paid on the 10th of the subsequent month.
• Regular maintenance of plant – Rs. 50,000 per month paid on the 10th of every month to the vendors. This includes expenditure on account of lubricants, spares and other stores.
• Regular maintenance of cylinders (statutory testing) – Rs. 5 lakh per annum – paid on monthly basis on the 15th of the subsequent month.
• All transportation charges as per contracts – paid on the 10th subsequent month.
• Sales tax as per applicable rates is deposited on the 7th of the subsequent month.
6) Sales : Average sales are 2,500 cylinders per day during the year. However, during the winter months (December to February), there is an incremental demand of 20 per cent.
7) Average Inventories : The average stocks maintained by the company as per its policy guidelines :
• Consumables (caps, ceiling material, valves etc) – Rs. 2 lakh. This amounts to 15 days consumption.
• Maintenance spares – Rs. 1 lakh
• Lubricants – Rs. 20,000
• Diesel (for DG sets and fire engines) – Rs. 15,000
• Other stores (stationary, safety items) – Rs. 20,000
8) Minimum cash balance including bank balance required is Rs. 5 lakh.
9) Additional Information for Calculating Incremental Working Capital During Winter.
• No increase in any inventories take place except in the inventory of bulk LPG, which increases in the same proportion as the increase of the demand. The actual requirements of LPG for additional supplies are procured under the same terms and conditions from the suppliers.
• The labour cost for additional production is paid at double the rate during wintes.
• No changes in other administrative overheads.
• The expenditure on power consumption during winter increased by 10 per cent. However, during other months the power consumption remains the same as the decrease owing to reduced production is offset by increased consumption on account of compressors /Acs.
• Additional amount of Rs. 3 lakh is kept as cash balance to meet exigencies during winter.
• No change in time schedules for any payables / receivables.
• The storage of finished goods inventory is restricted to a maximum 5,000 cylinders due to statutory requirements.
Suppose you are Mr.Keen Kumar, the new manager. What steps will you take for the growth of Cooking LPG Ltd.?
CASE : 2
M/S HI-TECH ELECTRONICS
M/s. Hi – tech Electronics, a consumer electronics outlet, was opened two years ago in Dwarka, New Delhi. Hard work and personal attention shown by the proprietor, Mr. Sony, has brought success. However, because of insufficient funds to finance credit sales, the outlet accepted only cash and bank credit cards. Mr. Sony is now considering a new policy of offering installment sales on terms of 25 per cent down payment and 25 per cent per month for three months as well as continuing to accept cash and bank credit cards.
Mr. Sony feels this policy will boost sales by 50 percent. All the increases in sales will be credit sales. But to follow through a new policy, he will need a bank loan at the rate of 12 percent. The sales projections for this year without the new policy are given in Exhibit 1.
Exhibit 1 Sales Projections and Fixed costs
Month Projected sales without instalment option Projected sales with instalment option
January Rs. 6,00,000 Rs. 9,00,000
February 4,00,000 6,00,000
March 3,00,000 4,50,000
April 2,00,000 3,00,000
May 2,00,000 3,00,000
June 1,50,000 2,25,000
July 1,50,000 2,25,000
August 2,00,000 3,00,000
September 3,00,000 4,50,000
October 5,00,000 7,50,000
November 5,00,000 15,00,000
December 8,00,000 12,00,000
Total Sales 48,00,000 72,00,000
Fixed cost 2,40,000 2,40,000
He further expects 26.67 per cent of the sales to be cash, 40 per cent bank credit card sales on which a 2 per cent fee is paid, and 33.33 per cent on instalment sales. Also, for short term seasonal requirements, the film takes loan from chit fund to which Mr. Sony subscribes @ 1.8 per cent per month.
Their success has been due to their policy of selling at discount price. The purchase per unit is 90 per cent of selling price. The fixed costs are Rs. 20,000 per month. The proprietor believes that the new policy will increase miscellaneous cost by Rs. 25,000.
The business being cyclical in nature, the working capital finance is done on trade – off basis. The proprietor feels that the new policy will lead to bad debts of 1 per cent.
(a) As a financial consultant, advise the proprietor whether he should go for the extension of credit facilities.
(b) Also prepare cash budget for one year of operation of the firm, ignoring interest. The minimum desired cash balance & Rs. 30,000, which is also the amount the firm has on January 1. Borrowings are possible which are made at the beginning of a month and repaid at the end when cash is available.
CASE : 3
SMOOTHDRIVE TYRE LTD
Smoothdrive Tyre Ltd manufacturers tyres under the brand name “Super Tread’ for the domestic car market. It is presently using 7 machines acquired 3 years ago at a cost of Rs. 15 lakh each having a useful life of 7 years, with no salvage value.
After extensive research and development, Smoothdrive Tyre Ltd has recently developed a new tyre, the ‘Hyper Tread’ and must decide whether to make the investments necessary to produce and market the Hyper Tread. The Hyper Tread would be ideal for drivers doing a large amount of wet weather and off road driving in addition to normal highway usage. The research and development costs so far total Rs. 1,00,00,000. The Hyper Tread would be put on the market beginning this year and Smoothdrive Tyrs expects it to stay on the market for a total of three years. Test marketing costing Rs. 50,00,000, shows that there is significant market for a Hyper Tread type tyre.
As a financial analyst at Smoothdrive Tyre, Mr. Mani asked by the Chief Financial Officer (CFO), Mr. Tyrewala to evaluate the Hyper-Tread project and to provide a recommendation or whether or not to proceed with the investment. He has been informed that all previous investments in the Hyper Tread project are sunk costs are only future cash flows should be considered. Except for the initial investments, which occur immediately, assume all cash flows occur at the year-end.
Smoothedrive Tyre must initially invest Rs. 72,00,00,000 in production equipments to make the Hyper Tread. They would be depreciated at a rate of 25 per cent as per the written down value (WDV) method for tax purposes. The new production equipments will allow the company to follow flexible manufacturing technique, that is both the brands of tyres can be produced using the same equipments. The equipments is expected to have a 7-year useful life and can be sold for Rs. 10,00,000 during the fourth year. The company does not have any other machines in the block of 25 per cent depreciation. The existing machines can be sold off at Rs. 8 lakh per machine with an estimated removal cost of one machine for Rs. 50,000.
The operating requirements of the existing machines and the new equipment are detailed in Exhibits 11.1 and 11.2 respectively.
Exhibit 11.1 Existing Machines
• Labour costs (expected to increase 10 per cent annually to account for inflation) :
(a) 20 unskilled labour @ Rs. 4,000 per month
(b) 20 skilled personnel @ Rs. 6,000 per month.
(c) 2 supervising executives @ Rs. 7,000 per month.
(d) 2 maintenance personnel @ Rs. 5,000 per month.
• Maintenance cost :
Years 1-5 : Rs. 25 lakh
Years 6-7 : Rs. 65 lakh
• Operating expenses : Rs. 50 lakh expected to increase at 5 per cent annually.
• Insurance cost / premium :
Year 1 : 2 per cent of the original cost of machine
After year 1 : Discounted by 10 per cent.
Exhibit 11.2 New production Equipment
• Savings in cost of utilities : Rs. 2.5 lakh
• Maintenance costs :
Year 1 – 2 : Rs. 8 lakh
Year 3 – 4 : Rs. 30 lakh
• Labour costs :
9 skilled personnel @ Rs. 7,000 per month
1 maintenance personnel @ Rs. 7,000 per month.
• Cost of retrenchment of 34 personnel : (20 unskilled, 11 skilled, 2 supervisors and 1 maintenance personnel) : Rs. 9,90,000, that is equivalent to six months salary.
• Insurance premium
Year 1 : 2 per cent of the purchase cost of machine
After year 1 : Discounted by 10 per cent.
The opening expenses do not change to any considerable extent for the new equipment and the difference is negligible compared to the scale of operations.
Smoothdrive Tyre intends to sell Hyper Tread of two distinct markets :
1. The original equipment manufacturer (OEM) market : The OEM market consists primarily of the large automobile companies who buy tyres for new cars. In the OEM market, the Hyper Tread is expected to sell for Rs. 1,200 per tyre. The variable cost to produce each Hyper Tread is Rs. 600.
2. The replacement market : The replacement market consists of all tyres purchased after the automobile has left the factory. This markets allows higher margins and Smoothdrive Tyre expects to sell the Hyper Tread for Rs. 1.500 per tyre. The variable costs are the same as in the OEM market.
Smoothdrive Tyre expects to raise prices by 1 percent above the inflation rate.
The variable costs will also increase by 1 per cent above the inflation rate. In addition, the Hyper Tread project will incur Rs. 2,50,000 in marketing and general administration cost in the first year which are expected to increase at the inflation rate in subsequent years.
Smoothdrive Tyre’s corporate tax rate is 35 per cent. Annual inflation is expected to remain constant at 3.25 per cent. Smoothdrive Tyre uses a 15 per cent discount rate to evaluate new product decisions.
The Tyre Market
Automotive industry analysts expect automobile manufacturers to have a production of 4,00,000 new cars this year and growth in production at 2.5 per year onwards. Each new car needs four new tyres (the spare tyres are undersized and fall in a different category) Smoothdrive Tyre expects the Hyper Tread to capture an 11 per cent share of the OEM market.
The industry analysts estimate that the replacement tyre market size will be one crore this year and that it would grow at 2 per cent annually. Smoothdrive Tyre expects the Hyper Tread to capture an 8 per cent market share.
You also decide to consider net working capital (NWC) requirements in this scenario. The net working capital requirement will be 15 per cent of sales. Assume that the level of working capital is adjusted at the beginning of the year in relation to the expected sales for the year. The working capital is to be liquidated at par, barring an estimated loss of Rs. 1.5 crore on account of bad debt. The bad debt will be a tax-deductible expenses.
As a finance analyst, prepare a report for submission to the CFO and the Board of Directors, explaining to them the feasibility of the new investment.
CASE : 4
COMPUTATION OF COST OF CAPITAL OF PALCO LTD
In October 2003, Neha Kapoor, a recent MBA graduate and newly appointed assistant to the Financial Controller of Palco Ltd, was given a list of six new investment projects proposed for the following year. It was her job to analyse these projects and to present her findings before the Board of Directors at its annual meeting to be held in 10 days. The new project would require an investment of Rs. 2.4 crore.
Palco Ltd was founded in 1965 by Late Shri A. V. Sinha. It gained recognition as a leading producer of high quality aluminum, with the majority of its sales being made to Japan. During the rapid economic expansion of Japan in the 1970s, demand for aluminum boomed, and palco’s sales grew rapidly. As a result of this rapid growth and recognition of new opportunities in the energy market, Palco began to diversify its products line. While retaining its emphasis on aluminum production, it expanded operations to include uranium mining and the production of electric generators, and finally, it went into all phases of energy production. By 2003, Palco’s sales had reached Rs. 14 crore level, with net profit after taxes attaining a record of Rs. 67 lakh.
As Palco expanded its products line in the early 1990s, it also formalized its caital budgeting procedure. Until 1992, capital investment projects were selected primarily on the basis of the average return on investment calculations, with individual departments submitting these calculations for projects falling within their division. In 1996, this procedure was replaced by one using present value as the decision making criterion. This change was made to incorporate cash flows rather than accounting profits into the decision making analysis, in addition to adjusting these flows for the time value of money. At the time, the cost of capital for Palco was determined to be 12 per cent, which has been used as the discount rate for the past 5 years. This rate was determined by taking a weighted average cost Palco had incurred in raising funds from the capital market over the previous 10 years.
It had originally been Neha’s assignment to update this rate over the most recent 10-year period and determine the net present value of all the proposed investment opportunities using this newly calculated figure. However, she objected to this procedure, stating that while this calculation gave a good estimate of “the past cost” of capital, changing interest rates and stock prices made this calculation of little value in the present. Neha suggested that current cost of raising funds in the capital market be weighted by their percentage mark-up of the capital structure. This proposal was received enthusiastically by the Financial Controller of the Palco, and Neha was given the assignment of recalculating Palco’s cost of capital and providing a written report for the Board of Directors explaining and justifying this calculation.
To determine a weighted average cost of capital for Palco, it was necessary for Neha to examine the cost associated with each source of funding used. In the past, the largest sources of funding had been the issuance of new equity shares and internally generated funds. Through conversations with Financial Controller and other members of the Board of Directors, Neha learnt that the firm, in fact, wished to maintain its current financial structure as shown in Exhibit 1.
Exhibit 1 Palco Ltd Balance Sheet for Year Ending March 31, 2003
Assets Liabilities and Equity
Total current assets
Net fixed assets
Total assets Rs. 90,00,000
Total current liabilities
Total liabilities and equity shareholders fund
She further determined that the strong growth patterns that Palco had exhibited over the last ten years were expected to continue indefinitely because of the dwindling supply of US and Japanese domestic oil and the growing importance of other alternative energy resources. Through further investigations, Neha learnt that Palco could issue additional equity share, which had a par value of Rs. 25 pre share and were selling at a current market price of Rs. 45. The expected dividend for the next period would be Rs. 4.4 per share, with expected growth at a rate of 8 percent per year for the foreseeable future. The flotation cost is expected to be on an average Rs. 2 per share.
Preference shares at 11 per cent with 10 years maturity could also be issued with the help of an investment banker with an investment banker with a per value of Rs. 100 per share to be redeemed at par. This issue would involve flotation cost of 5 per cent.
Finally, Neha learnt that it would be possible for Palco to raise an additional Rs. 20 lakh through a 7 – year loan from Punjab National Bank at 12 per cent. Any amount raised over Rs. 20 lakh would cost 14 per cent. Short-term debt has always been usesd by Palco to meet working capital requirements and as Palco grows, it is expected to maintain its proportion in the capital structure to support capital expansion. Also, Rs. 60 lakh could be raised through a bond issue with 10 years maturity with a 11 percent coupon at the face value. If it becomes necessary to raise more funds via long-term debt, Rs. 30 lakh more could be accumulated through the issuance of additional 10-year bonds sold at the face value, with the coupon rate raised to 12 per cent, while any additional funds raised via long-term debt would necessarily have a 10 – year maturity with a 14 per cent coupon yield. The flotation cost of issue is expected to be 5 per cent. The issue price of bond would be Rs. 100 to be redeemed at par.
In the past, Palco had calculated a weighted average of these sources of funds to determine its cost of capital. In discussion with the current Financial Controller, the point was raised that while this served as an appropriate calculation for external funds, it did not take into account the cost of internally generated funds. The Financial Controller agreed that there should be some cost associated with retained earnings and need to be incorporated in the calculations but didn’t have any clue as to what should be the cost.
Palco Ltd is subjected to the corporate tax rate of 40 per cent.
From the facts outlined above, what report would Neha submit to the Board of Directors of palco Ltd ?
CASE : 5
ARQ Ltd is an Indian company based in Greater Noida, which manufactures packaging materials for food items. The company maintains a present fleet of five fiat cars and two Contessa Classic cars for its chairman, general manager and five senior managers. The book value of the seven cars is Rs. 20,00,000 and their market value is estimated at Rs. 15,00,000. All the cars fall under the same block of depreciation @ 25 per cent.
A German multinational company (MNC) BYR Ltd, has acquired ARQ Ltd in all cash deal. The merged company called BYR India Ltd is proposing to expand the manufacturing capacity by four folds and the organization structure is reorganized from top to bottom. The German MNC has the policy of providing transport facility to all senior executives (22) of the company because the manufacturing plant at Greater Noida was more than 10 kms outside Delhi where most of the executives were staying.
Prices of the cars to be provided to the Executives have been as follows :
Manager (10) Santro King Rs. 3,75,000
DGM and GM (5) Honda City 6,75,000
Director (5) Toyota Corolla 9,25,000
Managing Director (1) Sonata Gold 13,50,000
Chairman (1) Mercedes benz 23,50,000
The company is evaluating two options for providing these cars to executives
Option 1 : The company will buy the cars and pay the executives fuel expenses, maintenance expenses, driver allowance and insurance (at the year – end). In such case, the ownership of the car will lie with the company. The details of the proposed allowances and expenditures to be paid are as follows :
a) Fuel expense and maintenance Allowances per month
Particulars Fuel expenses Maintenance allowance
DGM and GM
Chairman Rs. 2,500
18,000 Rs. 1,000
b) Driver Allowance : Rs. 4,000 per month (Only Chairman, Managing Director and Directors are eligible for driver allowance.)
c) Insurance cost : 1 per cent of the cost of the car.
The useful life for the cars is assumed to be five years after which they can be sold at 20 per cent salvage value. All the cars fall under the same block of depreciation @ 25 per cent using written down method of depreciation. The company will have to borrow to finance the purchase from a bank with interest at 14 per cent repayable in five annual equal instalments payable at the end of the year.
Option 2 : ORIX, The fleet management company has offered the 22 cars of the same make at lease for the period of five years. The monthly lease rentals for the cars are as follows (assuming that the total of monthly lease rentals for the whole year are paid at the end of each year.
Santro Xing Rs. 9,125
Honda City 16,325
Toyota Corolla 27,175
Sonata Gold 39,250
Mercedes Benz 61,250
Under this lease agreement the leasing company, ORIX will pay for the fuel, maintenance and driver expenses for all the cars. The lessor will claim the depreciation on the cars and the lessee will claim the lease rentals against the taxable income. BYR India Ltd will have to hire fulltime supervisor (at monthly salary of Rs. 15,000 per month) to manage the fleet of cars hired on lease. The company will have to bear additional miscellaneous expense of Rs. 5,000 per month for providing him the PC, mobioe phone and so on.
The company’s effective tax rate is 40 per cent and its cost of capital is 15 per cent.
Analyse the financial viability of the two options. Which option would you recommend ? Why ?