fin622 solution required

[em-ad]

Please upload solution ASAP

[Vuhelper]

SEMESTER SPRING 2012
Corporate Finance (Fin 622)
Assignment No. 02
Due Date: 19-06-2012 Marks: 25
Learning objectives:
To develop an understanding of working capital management and economic importance for
financial planning & forecasting on short term basis
Outcomes:
After completing this assignment students will be able to understand:
 how working capital requirements of any business organization are determined; &
 how “cash and inventory” are two important components of working capital management.
Case
Super Manufacturing Company (SMC) is a medium scale but highly profitable unit engaged in the
processing of food items contributing well in the country’s Rs. 1,000 million food industry. The
company’s after tax profit has been reached to the tune of 63% over the past 7 years. Much of this is
due to the efforts put in by its Financial Planner – Mr. FP, whose success can be traced to financial
planning and forecasting of short term assets and liabilities. But, still he is much concerned about
working capital management to maintain a balance between liquidity and profitability of the company.
For this, he along with his team has chalked out an estimate about the company’s overall working
capital needs. He has also done detailed analysis of cash and inventory to determine optimal level for
the working capital for the Financial Year 2013.
The following are the estimates in this regard:
Particulars Rs.
Sales 1,500,000
Material Alfa 450,000
Direct Labor 375,000
Factory Overhead (fixed and variable) 225,000
NOTE: All above figures are annual estimates.
Credit terms Month(s) (period)
Material Alfa 1½
Direct Labor 2
Factory Overhead Expenses - fixed and variable (Cash) 2½
SMC takes 1½ month to materialize its account receivables in cash. Material Alfa is held in the stock
for a quarter. Work in process remains in the production for 30 days to complete. It takes 2 months to
sell the finished goods held in the stock.
Required:
1. Figure out the working capital requirement (net) for the year 2013;
(12 Marks)
2. Mr. FP can arrange cash from a local bank in multiple of RS. 50,000 at a fixed cost of Rs.
2,500 for each multiple, whereas interest rate is 15% and deposit rate is 8%. What would be
the optimal cash holding level for SMC at this point of time to meet annual requirements of Rs.
150,000? Also determine the number of years, this finance (optimal cash level) will be enough
for SMC?
(5 marks)
3. To meet the above estimated annual sales, monthly requirements have been determined at 500
kg of material Alfa. Present ordering cost is Rs. 70 per order, whereas material Alfa is priced at
Rs. 75 per kg. Holding cost is estimated at 3% of the purchase price. At present, its monthly
requirement is 500 kg. EOQ has been determined at 611kg. Recently, the supplier has offered
SMC a trade discount of 3% subject to the order size of 300 kg. Determine whether the new
discount policy is acceptable to SMC or not. Support your answer with complete working.
(8 marks)
(Formulas and complete working is mandatory, as it carries marks)
Note:
Only in the case of Assignment, 24 hours extra / grace period after the due date is
usually available to overcome uploading difficulties which may be faced by the students
on last date. This extra time should only be used to meet the emergencies and above
mentioned due dates should always be treated as final to avoid any inconvenience.