Finance Question - Calculating Operating Net Working Capital

problem-6-11.xlsx

Sheet1

					Solution Legend
						= Value given in problem
Given:						= Formula/Calculation/Analysis required
In Millions of $	2010	2009	2008	2007		= Qualitative analysis or Short answer required
Cash & Equivalents	$ 807,926	$ 560,960	$ 617,866	$ 658,255		= Goal Seek or Solver cell
Short Term Investments	178,994	197,408	182,442	614,513		= Crystal Ball Input
Cash and Short Term Investments	986,920	758,368	800,308	1,272,768		= Crystal Ball Output
Accounts Receivable	2,028,060	2,365,823	2,341,609	2,302,447
Inventories	1,456,271	1,441,024	1,450,258	1,262,308
Total Current Assets	4,471,251	4,565,215	4,592,175	4,837,523
Accounts Payable	1,138,770	1,601,413	1,584,959	1,416,367
Accrued Expenses	878,454	901,546	902,164	863,683
Notes Payable/Short Term Debt	1,038,633	789,285	979,675	821,126
Current Port. of LT Debt	531,635	386,879	303,214	248,028
Total Current Liabilities	$ 3,587,492	$ 3,679,123	$ 3,770,012	$ 3,349,204
Solution a:
Operating Current Assets
Operating Current Liabilities
Operating Net Working Capital
Solution b:
Change in Operating Net Working Capital
Solution c: