Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please fill out the Balance Sheet AND Statement of Cash Flows for 2006 - 2010. Data Tables are provided. Please note, the answers provided in
Please fill out the Balance Sheet AND Statement of Cash Flows for 2006 - 2010. Data Tables are provided. Please note, the answers provided in the Statement of Cash Flows are wrong.
2010 are shown below: Construct Ideko's balance sheets through 2010 below: (Round to the nearest $000 ) Construct Ideko's statements of cash flows throuah 2010 below: (Round to the nearest $000.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Data table \begin{tabular}{|lrrrrrr} \hline Income Statement ($000) & 2005 & 2006 & 2007 & 2008 & 2009 & 2010 \\ \hline Sales & 75,184 & 83,631 & 92,891 & 103,037 & 114,148 & 126,310 \\ Cost of Goods Sold & & & & & & \\ Raw Materials & (16,110) & (17,735) & (19,496) & (21,401) & (23,466) & (25,698) \\ Direct Labor Costs & (18,089) & (20,526) & (23,257) & (26,315) & (29,740) & (33,570) \\ \cline { 2 - 7 } Gross Profit & 40,985 & 45,370 & 50,138 & 55,321 & 60,942 & 67,042 \\ Sales and Marketing & (11,142) & (13,732) & (16,739) & (20,216) & (23,081) & (25,540) \\ Administrative & (13,465) & (12,469) & (13,850) & (14,332) & (14,737) & (16,307) \\ \cline { 2 - 7 } EBITDA & 16,378 & 19,169 & 19,549 & 20,773 & 23,124 & 25,195 \\ Depreciation & (5,580) & (5,522) & (5,470) & (5,423) & (5,381) & (6,922) \\ \cline { 2 - 7 } EBIT & 10,798 & 13,647 & 14,079 & 15,350 & 17,743 & 18,273 \\ Interest Expense ( net ) & (78) & (6,831) & (6,831) & (6,831) & (6,831) & (6,831) \\ Pretax Income & 10,720 & 6,816 & 7,248 & 8,519 & 10,912 & 11,442 \\ Income Tax & (3,752) & (2,386) & (2,537) & (2,982) & (3,819) & (4,005) \\ \cline { 2 - 7 } Net Income & 6,968 & 4,430 & 4,711 & 5,537 & 7,093 & 7,437 \\ \hline \end{tabular} Data table (Click on the following icon in order to copy its contents into a spreadsheet.) (Click on the following icon in order to copy its contents into a spreadsheet.) 2010 are shown below: Construct Ideko's balance sheets through 2010 below: (Round to the nearest $000 ) Construct Ideko's statements of cash flows throuah 2010 below: (Round to the nearest $000.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Data table \begin{tabular}{|lrrrrrr} \hline Income Statement ($000) & 2005 & 2006 & 2007 & 2008 & 2009 & 2010 \\ \hline Sales & 75,184 & 83,631 & 92,891 & 103,037 & 114,148 & 126,310 \\ Cost of Goods Sold & & & & & & \\ Raw Materials & (16,110) & (17,735) & (19,496) & (21,401) & (23,466) & (25,698) \\ Direct Labor Costs & (18,089) & (20,526) & (23,257) & (26,315) & (29,740) & (33,570) \\ \cline { 2 - 7 } Gross Profit & 40,985 & 45,370 & 50,138 & 55,321 & 60,942 & 67,042 \\ Sales and Marketing & (11,142) & (13,732) & (16,739) & (20,216) & (23,081) & (25,540) \\ Administrative & (13,465) & (12,469) & (13,850) & (14,332) & (14,737) & (16,307) \\ \cline { 2 - 7 } EBITDA & 16,378 & 19,169 & 19,549 & 20,773 & 23,124 & 25,195 \\ Depreciation & (5,580) & (5,522) & (5,470) & (5,423) & (5,381) & (6,922) \\ \cline { 2 - 7 } EBIT & 10,798 & 13,647 & 14,079 & 15,350 & 17,743 & 18,273 \\ Interest Expense ( net ) & (78) & (6,831) & (6,831) & (6,831) & (6,831) & (6,831) \\ Pretax Income & 10,720 & 6,816 & 7,248 & 8,519 & 10,912 & 11,442 \\ Income Tax & (3,752) & (2,386) & (2,537) & (2,982) & (3,819) & (4,005) \\ \cline { 2 - 7 } Net Income & 6,968 & 4,430 & 4,711 & 5,537 & 7,093 & 7,437 \\ \hline \end{tabular} Data table (Click on the following icon in order to copy its contents into a spreadsheet.) (Click on the following icon in order to copy its contents into a spreadsheet.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started