Answered step by step
Verified Expert Solution
Question
1 Approved Answer
the photos looked clear to me so not sure which one was blurry. i posted all the information i had. thank you! this is all
the photos looked clear to me so not sure which one was blurry. i posted all the information i had. thank you!
this is all the information i have. thank you!
Cubulate lhekok tre cash fow trovgh 2010 telew: chownd to the nearest $600 ) TABLE 19.10 SPREADSHEET Ideko's Free Cash Flow Forecast \begin{tabular}{lrrrrrrrr} \hline & Growth/Year & 2005 & 2006 & 2007 & 2008 & 2009 & 2010 \\ \hline Sales Data & & & & & & & & \\ Market Size (000 units) & 4.95% & 9,900.0 & 10,390.1 & 10,904.4 & 11,444.2 & 12,010.7 & 12,605.2 \\ Market Share & 0.60% & 10.10% & 10.70% & 11.30% & 11.90% & 12.50% & 13.10% \\ Average Sales Price (\$/unit) & 1.95% & 75.03 & 76.49 & 77.98 & 79.51 & 81.06 & 82.64 \\ Cost of Goods Data & & & & & & & \\ Raw Materials (\$/unit) & 0.90% & 15.48 & 15.62 & 15.76 & 15.90 & 16.04 & 16.19 \\ Direct Labor Costs (\$/unit) & 3.85% & 18.01 & 18.70 & 19.42 & 20.17 & 20.95 & 21.75 \\ Operating Expense Data & & & & & & & & \\ Sales and Marketing (\% sales) & & 15.17 & 16.77 & 18.37 & 19.97 & 20.57 & 20.57 \\ Administrative (\% sales) & & 18.12 & 15.12 & 15.12 & 14.12 & 13.12 & 13.12 \\ Interest on Term Loan (\$ 000) & & (74) & (6,797) & (6.797) & (6.797) & (6.797) & (6.797) \\ \hline \end{tabular} (Click on the following icon p in order to copy its contents into a spreadsheet.) \begin{tabular}{lrrrrrrr} Working Capital ($000) & 2005 & 2006 & 2007 & 2008 & 2009 & 2010 \\ \hline Assets & & & & & & \\ Accounts Recelvable & 18,499 & 20,969 & 23,694 & 26,698 & 30,006 & 33,647 \\ Raw Materials & 1,908 & 2,141 & 2,394 & 2,670 & 2,970 & 3,296 \\ Finished Goods & 4,128 & 4,704 & 5,345 & 6,057 & 6,847 & 7,725 \\ Minimum Cash Balance & 6,166 & 6,990 & 7,898 & 8,899 & 10,002 & 11,216 \\ Total Cument Assots & 30,701 & 34,804 & 39,331 & 44,324 & 49,825 & 55,884 \end{tabular} Labilities \begin{tabular}{lrrrrrrr} Wages Payable & 1,299 & 1,383 & 1,581 & 1,757 & 1,949 & 2,212 \\ \multicolumn{1}{c}{ Other Accounts Payable } & 3,311 & 3,899 & 4,570 & 5,336 & 6,056 & 6,756 \\ \cline { 2 - 7 } Total Current Liabilities & 4,610 & 5,282 & 6,151 & 7,093 & 8,005 & 8,968 \\ Net Working Capital & 26,091 & 29,522 & 33,180 & 37,231 & 41,820 & 46,916 \\ Increase in Net Working Capital & & 3,431 & 3,658 & 4,051 & 4,589 & 5,096 \\ \hline \hline \end{tabular} \begin{tabular}{lcccccc} \multicolumn{7}{c}{ Fixed Assets and Capital Investment (\$000) } \\ \hline & 2005 & 2006 & 2007 & 2008 & 2009 & 2010 \\ \hline New Investment & 5,100 & 5,100 & 5,100 & 5,100 & 5,100 & 21,000 \\ Depreciation & (5,590) & (5,541) & (5,497) & (5,457) & (5,422) & (6,979) \\ \hline \end{tabular} (Click on the following icon D in order to copy its contents into a spreadsheet.) Forecast Ideko's free cash flow (reproduce Table 19.10 I, assuming Ideko's market share will increase by 0.45 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 J. Ideko's pro-forma income statements for 2005-2010 are shown here , while its balance sheet for 2005 is shown here Ideko's production plant will require an expansion in 2010 (when production volume will exceed the current level by 50% ), and the cost of this expansion will be $15.3 million. This amount will be borrowed from a financial institution at an interest rate of 6.6%. The new projected capital investments are shown here (Assume an income tax rate of 35%.) Calculate Ideko's free cash flow through 2010 below. (Round to the nearest $000.) 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