Reproduce Ideko's balance sheet and statement of cash flows, assuming Ideko's market share will increase by percent per year; investment, financing, and depreciation will be adjusted accordingly; and the projected improvements in working capital LOADING... do not occur, i.e., the numbers in the table remain at their 2005 levels through 2010 (that is, Ideko's working capital requirements though 2010 will be as shown here LOADING...). Ideko's income statements through 2010 and balance sheet for 2004 are shown here LOADING... and here LOADING..., respectively. Ideko capital expenditure assumptions are shown here LOADING.... Assume an income tax rate of . The projected dividend payments for 2006 thru 2010 are shown below: 2006 2007 2008 2009 2010 Dividends ($ 000)

if I can post a pic it would be more clear.

corprate finance 4th ed, chap -19 ques 8p. the question is already in chegg. however I can't understand it because it did not giving the answer step by step. please try give me the answer step by step. if you can show me how to do it with excel that will be great thank you.

Save Homework: Chapter 19 Homework HW Score: 51.82%, 9.84 of 19 p 10 of 19 (11 complete) Score: 0 of 1 pt P19-10 (similar to) Question Help 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 do not occur, i.e., the numbers in the table remain at their 2005 levels through 2010 (that is, Ideko's working capital requirements through 2010 will be as shown here !). Ideko's income statements though 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: 2006 2007 2008 2009 2010 Dividends (3 000) (2.184) (2,917) (3,592) (4,943) (6,613) Construct Ideko's balance sheets through 2010 below: (Round to the nearest $ 000.) Balance Sheet (8 000) 2006 Assets Cash and Equivalents Accounts Receivable Enter any number in the edit fields and then click Check Answer. 9 parts remaining Clear All Check Answer Save Homework: Chapter 19 Homework HW Score: 51.82%, 9.84 of 19 p 10 of 19 (11 complete) Score: 0 of 1 pt P19-10 (similar to) Question Help 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 do not occur, i.e., the numbers in the table remain at their 2005 levels through 2010 (that is, Ideko's working capital requirements through 2010 will be as shown here !). Ideko's income statements though 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: 2006 2007 2008 2009 2010 Dividends (3 000) (2.184) (2,917) (3,592) (4,943) (6,613) Construct Ideko's balance sheets through 2010 below: (Round to the nearest $ 000.) Balance Sheet (8 000) 2006 Assets Cash and Equivalents Accounts Receivable Enter any number in the edit fields and then click Check Answer. 9 parts remaining Clear All Check