Question: 3) Using the information below, calculate ValueCo's 2011 working capital ratios ValueCo Corporation Working Capital Projections ($ in millions, fiscal year ending Dooomber 31) Historical


3) Using the information below, calculate ValueCo's 2011 working capital ratios ValueCo Corporation Working Capital Projections ($ in millions, fiscal year ending Dooomber 31) Historical Period 2009 2010 Sales $2,600.0 $2,900,0 Cost of Goods Sold 1,612.0 1,769.0 Current Assets Accounts Receivable 317.0 365.5 Inventories 441.6 496.8 Prepaid Expenses and Other 117.0 142.1 Total Current Assets $875.6 $1,004.4 2011 $3,200.0 1,920.0 2012 $3,450.0 2,070.0 450.0 417.4 556.5 162.3 $1,136.2 600.0 175.0 $1,225.0 Current Liabilities Accounts Payable Accrued Liabilities Other Current Liabilities Total Current Liabilities Net Working Capital % sales 189.9 221.0 75.4 $486.3 189.0 237.8 84.1 $510.9 $493.5 17.0% 199.4 255.1 92.8 $547.2 215.0 275.0 100.0 $590.0 $635.0 18.4% - $389.4 15.0% $589.0 18.4% ($95.5) ($104.1) (Increaso)Decrease in NWC ($46.0) Assumptions Current Assets Days Sales Outstanding Days Inventory Held Propaids and Other CA (% of sales) 44.5 100.0 4.5% 46.0 A 102.5 B) 4.9% C) 39.0 Current Liabilities Days Payable Outstanding Accrued abilities (% of sales) Other Current Liabilities (% of sales) 43.0 8.5% 2.9% 8.2% E) 2.9% F) a. Calculate ValueCo's 2011 days sales outstanding (DSO) b. Calculate 2011 days inventory held (DIH) c. Calculate 2011 prepaid and other current assets as a percentage of sales d. Calculate 2011 days payable outstanding (DPO) e. Calculate 2011 accrued liabilities as a percentage of sales f. Calculate 2011 other current liabilities as a percentage of sales
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
