Under the assumptions that Ideko's market share will increase by 0.5% per year (implying that the investment, financing, and depreciation will be adjusted as described in previous problems) but that the projected improvements in net working capital do not transpire (so the numbers in Table: Ideko’s Working Capital Requirements remain at their 2005 levels through 2010), calculate Ideko's working capital requirements though 2010 (that is, reproduce Table: Ideko’s Net Working Capital Forecast under these assumptions).
Ideko’s Working Capital Requirements
Year2005>2005
Working Capital DaysAssets1234Liabilities56Accounts ReceivableRaw MaterialsFinished GoodsMinimum Cash BalanceWages PayableOther Accounts PayableBased on:Sales RevenueRaw Materials CostsRaw Materials + Labor CostsSales RevenueDirect Labor + Admin CostsRaw Materials + Sales and MarketingDays904545301545Days603045301545
Ideko’s Net Working Capital Forecast
Year200520062007200820092010
Working Capital ($000)Assets12345Liabilities678Net Working Capital910Accounts ReceivableRaw MaterialsFinished GoodsMinimum Cash BalanceTotal Current AssetsWages PayableOther Accounts PayableTotal Current LiabilitiesNet Working Capital (5 - 8)Increase in Net Working Capital18,4931,9734,1926,16430,8221,2943,3604,65426,16814,5251,5344,9677,26228,2881,4334,0995,53222,756(3,412)16,9701,7755,8388,48533,0671,6954,9536,64826,4193,66319,6892,0396,8159,84538,3881,9415,9387,87930,5094,08922,7092,3297,91111,35544,3042,2116,9009,11035,1944,68526,0592,6469,13813,03050,8722,5707,87810,44840,4255,231