Reproduce Ideko's balance sheet and statement of cash flows, assuming Ideko's market share will increase by 0.55 percent per year; investment, financing, and depreciation will be adjusted accordingly; and the projected improvements in working capital occur (that is, Ideko's working capital requirements through 2010 will be as shown here). Ideko's income statements through 2010 and balance sheet for 2005 are shown here and here respectively. Ideko capital expenditure assumptions are shown here Assume an income tax rate of 35 % The projected dividend payments for 2006 thru 2010 are shown below:

Data Table (Click on the Icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet) Ideko's Working Capital Requirements Working Capital Days Assets > 2005 Days 60 30 45 30 2005 Accounts Receivable Raw Materials Finished Goods Minimum Cash Balance Based on: Sales Revenue Raw Materials Costs Raw Materials Labor Costs Sales Revenue 90 45 45 30 Liabilities Wages Payable Other Accounts Payable Raw Materials Sales and Marketing Direct LaborAdmin Costs 15 45 45 Data Table Working Capital ($ 000) 2005 2006 2007 2008 2009 2010 Assets Accounts Receivable Raw Materials Finished Goods Minimum Cash Balance 19,11714,433 16,299 18,360 20,635 23,143 2,229 7,780 6,372 7,217 8,150 9,180 10,317 11,571 31,591 27,840 31,452 35,44439,855 44,723 1,934 4,168 1,803 2,007 6,896 1,446 1,617 4,744 5,386 6,101 Total Current Assets Labilities 2,228 6,844 9,072 26,891 22,469 25,210 28,259 31,761 35,651 3,890 Wages Payable 1,316 1,398 3,384 4,7005,371 1,596 1,772 1,963 4,646 6,242 7,185 8,094 3,973 5,413 6,131 Other Accounts Payable Total Current Liabilities Net Working Capital Increase in Net Working Capital 4,422) 2,7413,049 3,502 Data Table Income Statement ($ 000) Sales Cost of Goods Sold 2005 2006 2007 2008 2009 2010 77,532 87,802 99,155 111,693 125,529 140,785 Raw Materials Direct Labor Costs Gross Profit Sales and Marketing Administrative EBITDA Depreciation EBIT Interest Expense (net) Pretax Income (15,685) 17,589 19,669) (21,939) 24,414) (27,115) (18,120 (20,892) (24,021) (27,548) (31,520) (35,993) 43,72749,321 55,465 62,206 69,595 77,677 (11,762) (14,637) 18,016) (21,970) (25,319) 28,396) 13,909) (13,118) (14,814) 15,570) (16,243) (18,218) 18,056 21,566 22,635 24,666 28,033 31,063 5,440 5,411) (5,385) (5,361) (5,340) 6,841) 12,6166,155 7250 19,305 22,693 24,222 (76) (6,969) (6,969) (6,969) 6,969) 6,969) 2,5409,186 10,281 2,336 15,7247,253 4,389 3,215) 3,598 (4,318) 5,503) 6,039) 11,214 Income Tax Net Income 8,151 5,971 6,683 8,018 10,221 Data Table (Click on the Icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet) Estimated 2005 Balance Sheet Data for Ideko Corporation Balance Sheet ($ 000) Assets Cash and Equivalents Accounts Receivable Inventories Total Current Assets Property, Plant, and Equipment Goodwill Total Assets 6,140 19,117 6,066 31,323 48,960 72,276 152,559 Liabilities and Stockholders' Equity Accounts Payable Debt Total Liabilities Stockholders Equity Total Liabilities and Equity 4,624 101,000 105,624 46,935 152,559 Data Table (Click on the Icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet) Ideko Capital Expenditure Assumptions (S 000) 2010 Opening Book Value 54,400 48,960 48,69948,464 48,25348,063 20,350 5,440 (5,411) (5,385) 5,361) 5,340 (6,841) 61,572 2006 2008 5,150 48,253 2009 5,150 48,063 5,150 New Investment Depreciation Closing Book Value 48,960 48,699 48,464 Banc Shot00 Cash and q Propery. Pnt nd Eipnt Liobdites and SockhoEquhy AccouParti. Total Libls ockholders Equit otsl Stockholiders Lqu Show transcribed image text Reproduce ldeko's balance sheet and statement of cash flows, assuming ldeko's market share will increase by 0.55 percent per year, investment, financing, and depreciation will be adjusted accordingly; and the projected improvements in working capital EEB occur (that is, Ideko's working capital requirements through 2010 will be as shown here) ldeko's income statements through 2010 and balance sheet for 2005 are shown here and here respectively. Ideko capital expenditure assumptions are shown here. Assume an income tax rate of 35%. The projected dividend payments for 2006 thru 2010 are shown below: 2010 2006 (10,462) 2007 (4,177) 2008 (5,180) 2009 (6,909) Dividends ($ 000) (9,015) Construct Ideko's balance sheets through 2010 below: (Round to the nearest $ 000.) Balance Sheet (S 000) 2006 Assets Cash and Equivalents Accounts Receivable Inventories Total Current Assets Property, Plant and Equipment Goodwil Total Assets Liabilities and Stockholders' Equity Accounts Pavable Enter any number in the edit fields and then click Check Answer. Data Table (Click on the Icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet) Ideko's Working Capital Requirements Working Capital Days Assets > 2005 Days 60 30 45 30 2005 Accounts Receivable Raw Materials Finished Goods Minimum Cash Balance Based on: Sales Revenue Raw Materials Costs Raw Materials Labor Costs Sales Revenue 90 45 45 30 Liabilities Wages Payable Other Accounts Payable Raw Materials Sales and Marketing Direct LaborAdmin Costs 15 45 45 Data Table Working Capital ($ 000) 2005 2006 2007 2008 2009 2010 Assets Accounts Receivable Raw Materials Finished Goods Minimum Cash Balance 19,11714,433 16,299 18,360 20,635 23,143 2,229 7,780 6,372 7,217 8,150 9,180 10,317 11,571 31,591 27,840 31,452 35,44439,855 44,723 1,934 4,168 1,803 2,007 6,896 1,446 1,617 4,744 5,386 6,101 Total Current Assets Labilities 2,228 6,844 9,072 26,891 22,469 25,210 28,259 31,761 35,651 3,890 Wages Payable 1,316 1,398 3,384 4,7005,371 1,596 1,772 1,963 4,646 6,242 7,185 8,094 3,973 5,413 6,131 Other Accounts Payable Total Current Liabilities Net Working Capital Increase in Net Working Capital 4,422) 2,7413,049 3,502 Data Table Income Statement ($ 000) Sales Cost of Goods Sold 2005 2006 2007 2008 2009 2010 77,532 87,802 99,155 111,693 125,529 140,785 Raw Materials Direct Labor Costs Gross Profit Sales and Marketing Administrative EBITDA Depreciation EBIT Interest Expense (net) Pretax Income (15,685) 17,589 19,669) (21,939) 24,414) (27,115) (18,120 (20,892) (24,021) (27,548) (31,520) (35,993) 43,72749,321 55,465 62,206 69,595 77,677 (11,762) (14,637) 18,016) (21,970) (25,319) 28,396) 13,909) (13,118) (14,814) 15,570) (16,243) (18,218) 18,056 21,566 22,635 24,666 28,033 31,063 5,440 5,411) (5,385) (5,361) (5,340) 6,841) 12,6166,155 7250 19,305 22,693 24,222 (76) (6,969) (6,969) (6,969) 6,969) 6,969) 2,5409,186 10,281 2,336 15,7247,253 4,389 3,215) 3,598 (4,318) 5,503) 6,039) 11,214 Income Tax Net Income 8,151 5,971 6,683 8,018 10,221 Data Table (Click on the Icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet) Estimated 2005 Balance Sheet Data for Ideko Corporation Balance Sheet ($ 000) Assets Cash and Equivalents Accounts Receivable Inventories Total Current Assets Property, Plant, and Equipment Goodwill Total Assets 6,140 19,117 6,066 31,323 48,960 72,276 152,559 Liabilities and Stockholders' Equity Accounts Payable Debt Total Liabilities Stockholders Equity Total Liabilities and Equity 4,624 101,000 105,624 46,935 152,559 Data Table (Click on the Icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet) Ideko Capital Expenditure Assumptions (S 000) 2010 Opening Book Value 54,400 48,960 48,69948,464 48,25348,063 20,350 5,440 (5,411) (5,385) 5,361) 5,340 (6,841) 61,572 2006 2008 5,150 48,253 2009 5,150 48,063 5,150 New Investment Depreciation Closing Book Value 48,960 48,699 48,464 Banc Shot00 Cash and q Propery. Pnt nd Eipnt Liobdites and SockhoEquhy AccouParti. Total Libls ockholders Equit otsl Stockholiders Lqu Show transcribed image text Reproduce ldeko's balance sheet and statement of cash flows, assuming ldeko's market share will increase by 0.55 percent per year, investment, financing, and depreciation will be adjusted accordingly; and the projected improvements in working capital EEB occur (that is, Ideko's working capital requirements through 2010 will be as shown here) ldeko's income statements through 2010 and balance sheet for 2005 are shown here and here respectively. Ideko capital expenditure assumptions are shown here. Assume an income tax rate of 35%. The projected dividend payments for 2006 thru 2010 are shown below: 2010 2006 (10,462) 2007 (4,177) 2008 (5,180) 2009 (6,909) Dividends ($ 000) (9,015) Construct Ideko's balance sheets through 2010 below: (Round to the nearest $ 000.) Balance Sheet (S 000) 2006 Assets Cash and Equivalents Accounts Receivable Inventories Total Current Assets Property, Plant and Equipment Goodwil Total Assets Liabilities and Stockholders' Equity Accounts Pavable Enter any number in the edit fields and then click Check