Under the assumptions that Ideko's market share will increase by 0.45 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 Ideko's Working Capital Requirements \begin{tabular}{llcc} \hline Working Capital Days & & 2005 & >2005 \\ \hline Assets & Based on: & Days & Days \\ Accounts Receivable & Sales Revenue & 90 & 60 \\ Raw Materials & Raw Materials Costs & 45 & 30 \\ Finished Goods & Raw Materials + Labor Costs & 45 & 45 \\ Minimum Cash Balance & Sales Revenue & 30 & 30 \\ Liabilities & & & \\ Wages Payable & Direct Labor + Admin Costs & 15 & 15 \\ Other Accounts Payable & Raw Materials + Sales and Marketing & 45 & 45 \\ \hline \end{tabular} \begin{tabular}{lrrrrrrrr|} \cline { 2 - 8 } & Year & 2005 & 2006 & 2007 & 2008 & 2009 & 2010 \\ \hline Working Capital (\$ 000) & & & & & & & \\ Assets & & & & & & \\ 1 Accounts Receivable & 18,493 & 14,525 & 16,970 & 19,689 & 22,709 & 26,059 \\ 2 & Raw Materials & 1,973 & 1,534 & 1,775 & 2,039 & 2,329 & 2,646 \\ 3 Finished Goods & 4,192 & 4,967 & 5,838 & 6,815 & 7,911 & 9,138 \\ 4 Minimum Cash Balance & 6,164 & 7,262 & 8,485 & 9,845 & 11,355 & 13,030 \\ 5 & Total Current Assets & 30,822 & 28,288 & 33,067 & 38,388 & 44,304 & 50,872 \\ Liabilities & & & & & & \\ 6 & Wages Payable & 1,294 & 1,433 & 1,695 & 1,941 & 2,211 & 2,570 \\ 7 & Other Accounts Payable & 3,360 & 4,099 & 4,953 & 5,938 & 6,900 & 7,878 \\ 8 Total Current Liabilities & 4,654 & 5,532 & 6,648 & 7,879 & 9,110 & 10,448 \\ Net Working Capital & & & & & & \\ 9 Net Working Capital (5 - 8) & 26,168 & 22,756 & 26,419 & 30,509 & 35,194 & 40,425 \\ 10 Increase in Net Working Capital & & 13,412) & 3,663 & 4,089 & 4,685 & 5,231 \\ \hline \end{tabular} \begin{tabular}{lrrrrrrr} \hline Income Statement ($000) & 2005 & 2006 & 2007 & 2008 & 2009 & 2010 \\ \hline Sales & 76,391 & 85,259 & 94,985 & 105,648 & 117,328 & 130,117 \end{tabular} Cost of Goods Sold \begin{tabular}{lrrrrrr} Raw Materials & (16,672) & (18,460) & (20,406) & (22,518) & (24,811) & (27,298) \\ Direct Labor Costs & (18,156) & (20,721) & (23,607) & (26,849) & (30,492) & (34,577) \\ \cline { 2 - 7 } Gross Profit & 41,563 & 46,078 & 50,972 & 56,281 & 62,025 & 68,242 \\ Sales and Marketing & (11,504) & (13,991) & (16,869) & (20,189) & (22,832) & (25,321) \\ Administrative & (13,865) & (12,917) & (14,390) & (14,949) & (15,429) & (17,110) \\ EBITDA & 16,194 & 19,170 & 19,713 & 21,143 & 23,764 & 25,811 \\ Depreciation & (5,470) & (5,408) & (5,352) & (5,302) & (5,257) & (6,646) \\ EBIT & 10,724 & 13,762 & 14,361 & 15,841 & 18,507 & 19,165 \\ Interest Expense (net) & (78) & (6,885) & (6,885) & (6,885) & (6,885) & (6,885) \\ Pretax Income & 10,646 & 6,877 & 7,476 & 8,956 & 11,622 & 12,280 \\ Income Tax & (3,726) & (2,407) & (2,617) & (3,135) & (4,068) & (4,298) \\ \hline Net Income & 6,920 & 4,470 & 4,859 & 5,821 & 7,554 & 7,982 \\ \hline \hline \end{tabular} Estimated 2005 Balance Sheet Data for Ideko Corporation Balance Sheet (\$ 000) Assets Cash and Equivalents Accounts Receivable \begin{tabular}{lr} Accounts Receivable & 18,836 \\ Inventories & 6,165 \\ \hline Total Current Assets & 31,165 \\ Property, Plant, and Equipment & 49,230 \\ Goodwill & 72,332 \\ \hline Total Assets & 152,727 \\ \hline \end{tabular} \begin{tabular}{lr} \hline Liabilities and Stockholders' Equity & \\ Accounts Payable & 4,654 \\ Debt & 99,500 \\ \hline Total Liabilities & 104,154 \\ Stockholders' Equity & 48,573 \\ \hline Total Liabilities and Equity & 152,727 \\ \hline \end{tabular} Calculate Ideko's working capital requirements through 2010 below: (Round to the nearest $000.) Under the assumptions that Ideko's market share will increase by 0.45 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 Ideko's Working Capital Requirements \begin{tabular}{llcc} \hline Working Capital Days & & 2005 & >2005 \\ \hline Assets & Based on: & Days & Days \\ Accounts Receivable & Sales Revenue & 90 & 60 \\ Raw Materials & Raw Materials Costs & 45 & 30 \\ Finished Goods & Raw Materials + Labor Costs & 45 & 45 \\ Minimum Cash Balance & Sales Revenue & 30 & 30 \\ Liabilities & & & \\ Wages Payable & Direct Labor + Admin Costs & 15 & 15 \\ Other Accounts Payable & Raw Materials + Sales and Marketing & 45 & 45 \\ \hline \end{tabular} \begin{tabular}{lrrrrrrrr|} \cline { 2 - 8 } & Year & 2005 & 2006 & 2007 & 2008 & 2009 & 2010 \\ \hline Working Capital (\$ 000) & & & & & & & \\ Assets & & & & & & \\ 1 Accounts Receivable & 18,493 & 14,525 & 16,970 & 19,689 & 22,709 & 26,059 \\ 2 & Raw Materials & 1,973 & 1,534 & 1,775 & 2,039 & 2,329 & 2,646 \\ 3 Finished Goods & 4,192 & 4,967 & 5,838 & 6,815 & 7,911 & 9,138 \\ 4 Minimum Cash Balance & 6,164 & 7,262 & 8,485 & 9,845 & 11,355 & 13,030 \\ 5 & Total Current Assets & 30,822 & 28,288 & 33,067 & 38,388 & 44,304 & 50,872 \\ Liabilities & & & & & & \\ 6 & Wages Payable & 1,294 & 1,433 & 1,695 & 1,941 & 2,211 & 2,570 \\ 7 & Other Accounts Payable & 3,360 & 4,099 & 4,953 & 5,938 & 6,900 & 7,878 \\ 8 Total Current Liabilities & 4,654 & 5,532 & 6,648 & 7,879 & 9,110 & 10,448 \\ Net Working Capital & & & & & & \\ 9 Net Working Capital (5 - 8) & 26,168 & 22,756 & 26,419 & 30,509 & 35,194 & 40,425 \\ 10 Increase in Net Working Capital & & 13,412) & 3,663 & 4,089 & 4,685 & 5,231 \\ \hline \end{tabular} \begin{tabular}{lrrrrrrr} \hline Income Statement ($000) & 2005 & 2006 & 2007 & 2008 & 2009 & 2010 \\ \hline Sales & 76,391 & 85,259 & 94,985 & 105,648 & 117,328 & 130,117 \end{tabular} Cost of Goods Sold \begin{tabular}{lrrrrrr} Raw Materials & (16,672) & (18,460) & (20,406) & (22,518) & (24,811) & (27,298) \\ Direct Labor Costs & (18,156) & (20,721) & (23,607) & (26,849) & (30,492) & (34,577) \\ \cline { 2 - 7 } Gross Profit & 41,563 & 46,078 & 50,972 & 56,281 & 62,025 & 68,242 \\ Sales and Marketing & (11,504) & (13,991) & (16,869) & (20,189) & (22,832) & (25,321) \\ Administrative & (13,865) & (12,917) & (14,390) & (14,949) & (15,429) & (17,110) \\ EBITDA & 16,194 & 19,170 & 19,713 & 21,143 & 23,764 & 25,811 \\ Depreciation & (5,470) & (5,408) & (5,352) & (5,302) & (5,257) & (6,646) \\ EBIT & 10,724 & 13,762 & 14,361 & 15,841 & 18,507 & 19,165 \\ Interest Expense (net) & (78) & (6,885) & (6,885) & (6,885) & (6,885) & (6,885) \\ Pretax Income & 10,646 & 6,877 & 7,476 & 8,956 & 11,622 & 12,280 \\ Income Tax & (3,726) & (2,407) & (2,617) & (3,135) & (4,068) & (4,298) \\ \hline Net Income & 6,920 & 4,470 & 4,859 & 5,821 & 7,554 & 7,982 \\ \hline \hline \end{tabular} Estimated 2005 Balance Sheet Data for Ideko Corporation Balance Sheet (\$ 000) Assets Cash and Equivalents Accounts Receivable \begin{tabular}{lr} Accounts Receivable & 18,836 \\ Inventories & 6,165 \\ \hline Total Current Assets & 31,165 \\ Property, Plant, and Equipment & 49,230 \\ Goodwill & 72,332 \\ \hline Total Assets & 152,727 \\ \hline \end{tabular} \begin{tabular}{lr} \hline Liabilities and Stockholders' Equity & \\ Accounts Payable & 4,654 \\ Debt & 99,500 \\ \hline Total Liabilities & 104,154 \\ Stockholders' Equity & 48,573 \\ \hline Total Liabilities and Equity & 152,727 \\ \hline \end{tabular} Calculate Ideko's working capital requirements through 2010 below: (Round to the nearest $000.)