Under the assumptions that Ideko's market share will increase by 0.60 percent per year (implying that the investment. financing, and depreciation will be adjusted accordingly) and the following forecasts , calculate Ideko's working capital requirements through 2010 (that is, reproduce Table 19.9 under the new assumptions). Ideko's pro-forma income statements for 2005-2010 are shown here., while its balance sheet for 2005 is shown here table \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline ect Labor Costs & (18,715) & (21,674) & (25,019) & (28,798) & (33,062) & (37,868) & \\ \hline ss Profit & 43,981 & 49,838 & 56,285 & 63,371 & 71,148 & 79,677 & \\ \hline s and Marketing & (11,798) & (14,677) & (18,066) & (22,035) & (25,366) & (28,537) & \\ \hline hinistrative & (14,229) & (13,492) & (15,297) & (16,144) & (16,907) & (19,020) & \\ \hline TDA & 17,954 & 21,669 & 22,922 & 25,192 & 28,875 & 32,120 & \\ \hline reciation & (5,580) & (5,517) & (5,460) & (5,409) & (5,363) & (6,752) & \\ \hline & 12,374 & 16,152 & 17,462 & 19,783 & 23,512 & 25,368 & \\ \hline est Expense (net) & (70) & (6,816) & (6,816) & (6,816) & (6,816) & (6,816) & \\ \hline ax Income & 12,304 & 9,336 & 10,646 & 12,967 & 16,696 & 18,552 & \\ \hline me Tax & (4,306) & (3,268) & (3,726) & (4,538) & (5,844) & (6,493) & \\ \hline come & 7,998 & 6,068 & 6,920 & 8,429 & 10,852 & 12,059 & \\ \hline \end{tabular} Print Done (Click on the following icon in order to copy its contents into a spreadsheet.) \begin{tabular}{|c|c|c|c|c|c|c|} \hline Income Statement ($000) & 2005 & 2006 & 2007 & 2008 & 2009 & 2010 \\ \hline Sales & 78,919 & 89,766 & 101,778 & 115,066 & 129.751 & 145,969 \\ \hline \multicolumn{7}{|l|}{ Cost of Goods Sold } \\ \hline Raw Materials & (16,223) & (18,254) & (20,474) & (22,897) & (25,541) & (28,424) \\ \hline Direct Labor Costs & (18,715) & (21,674) & (25,019) & (28,798) & (33,062) & (37,868) \\ \hline Gross Profit & 43,981 & 49,838 & 56,285 & 63,371 & 71,148 & 79.677 \\ \hline Sales and Marketing & (11,798) & (14,677) & (18,066) & (22,035) & (25,366) & (28,537) \\ \hline Administrative & (14.229) & (13,492) & (15,297) & (16,144) & (16,907) & (19,020) \\ \hline EBITDA & 17,954 & 21,669 & 22,922 & 25,192 & 28,875 & 32,120 \\ \hline Depreciation & (5,580) & (5,517) & (5,460) & (5,409) & (5,363) & (6,752) \\ \hline EBIT & 12,374 & 16,152 & 17.462 & 19,783 & 23,512 & 25,368 \\ \hline \end{tabular} Working Capital ($000) 2005 Assets Accounts Receivable Raw Materials Finished Goods Minimum Cash Balance Total Current Assets Liabilities Wages Payable Other Accounts Payable Total Current Liabilities Net Working Capital Increase in Net Working Capital Figure Ideko's Net Working Capital Forecast
