VUDESK

¤Virtual University Of Pakistan Network¤



Welcome Visitors to VUDESK Family .Join VUDESK For Free to Get more Access to study material and lot of infotainment stuff. Stay Connected!!

VUDESk ALL Subject CODES
Find Your Subject Code , Join Group And You Will Get ALL related Data
ACC - Fundamentals of auditing and business
ACC311ACC501
ACF - (Accounting And Finance Related)
ACF619ACFI619
COM - (Commerce Related)
COM619COMI619
ECO - (Economics Related)
ECO401 ECO402 ECO403 ECO404
ENG - (English Related)
ENG001 ENG101 ENG201 ENG301 ENG401
ETH201 - Ethics (for Non-Muslims)
ETH201
ISL201 - Islamic Studies
ISL201
IT - (Info Tech Related
IT000IT0001IT430IT619ITI619
MIS - (Project And Internship Report)
MIS619 MISI619MIS620 MISI620
PAD - (Public Administration Related)
PAD619 PADI619
PAK301 - Pakistan Studies
PAK301PAK302
PHY - (Physics Related)
PHY101 PHY301
PSC201 - International Relations
PSC201PSC401
SOC - (Socialogy Related)
SOC101 SOC401
STA - (Statistics and Research)
STA301 STA630
URDU - (Urdu Related)
URD101

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)

Tags: 19-06-2012, 2, Corporate, Date:, Due, FIN622, Finance-ASSIGNMENT

Views: 112

Replies to This Discussion

Advertise Here

plz koe send kr dy

Sol for 1

Net working Capital: -

Net working Capital= Average receivable + Average inventory – Average payables

=184932+39945205-129452

= 40000685/-

 

Sol for 2

Ch= 52500 *15% = 7875 & 52500 * 8%

= 4200

7875-4200= 3675/- for each multiple

 

EOQ= 2*2500*150000/3675

 = 452 for 1 multiple

Assignment no:     02

Fin 622            : corporate finance

 

Solution:

Question no 1: Calculation of working capital

 

       Answer                              Working capital requirement

Sales 1500000

Annual cost of cost item

Material                        45000

Direct labor                 375000 

Factory over head       225000

Fixed variable

Average value of current assets        period               

Raw Material                                              quarter              450000/12*4            150000

Work in process                                                                                                87500

Material                                          1 month (30 days)          450000/30        37500

Direct labor                                1 month (30 days)              375000/30        31250

 Factory Overhead                      1 month (30 days)             225000/30        18750

Fixed variable                                    

Finished goods                                                                                                   175000

Direct material                           2 month                        450000/12*2                75000

Labor                                          2 month                         375000/12*2               62500

Factory overhead                       2 month                         225000/12*2                 37500

Account receive able                1 ½ month                    1500000/12*11/2            187500

Gross working capital

Raw material+w.i.p+finished goods a/c r/a        150000 +87500+175000+ 187500

Gross working capital                                                                                            600000

Average value of current liabilities 

 Material                                  1 ½ month                     450000/12*1 ½              56250

Direct Labor                            2 month                            375000/12*2                 62500

Factory overhead                     2 ½ month                   225000/12*2 ½                   46875

Total liabilities                                                                                                      165625

Net working capital for 2013

Formula: current assets –current liabilities           600000-165625               434375

Question no 2 optimal cash holding level and time period in which this finance will be enough

Answer:

EOQ: √ (2 x 2500x 150000 / 7%)

           =√750, 000, 000, /0.07

           = 103510 or 103509.8339

Time period:      103509.8339/150000

                             0.69

Question no 3 determine new discount policy is acceptable or not

Solution with complete work

 

Answer: 

 EOQ = √ (2*70*500)/3 %( 75)

         = √ (140*500)/0.03(75)

          =13228.75or 13229 unit

With out discount

Purchase cost               500*75            37500

Holding cost             500*(3%*75)     1125

Order cost                 0.037*70            2.59

Total cost                                         38627.59

Per order cost                     38627.59/500=77.25

 

 With discount 3%on Qty order 300

Total order         500/300                 2 order

Purchase cost      500*(75-3%)       360

Holding cost        500*(3%*72)           1080

Ordering cost         2*70                       140

Total cost                                             37220

Cost per kg        37220/500                   74.44

Decision

This policy is acceptable for the company because per unit price before discount is 77.25 which is more then the discounted price 74 .44

RSS

*Member OF Week*

=======================

Popular Social Events

=======================

+ Member of the Day

+ Member of the Week

+ Member of the Month

+ Member of the Year

+ Miss VU

+ Mr VU

+ Gold Members

+ Vote for Miss VU

+ Vote for Mr VU

+ Members Points Table

+ Profile Points Allocation

+ Competition Corner

+ Our Fans Club

+ Certificate Winners

---------------------------------------

௵ Scholars Of Desk

 Gold Members

 MR VU,S

௵ MISS VU,S

 Members Of Month

 Team Members

 Moderators 

  ADMINS

ʭAdministrationʭ

Senior Admin : Yasmeen

VUDESK Owner : Ismail Shah

DMCA.com

VUDESK GROUPS

© 2013   Created by ʭIsmail Shahʭ.

Badges  |  Report an Issue  |  Terms of Service

-->