Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
the photos looked clear to me so not sure which one was blurry. i posted all the information i had. thank you! image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

No Nonsense Project Auditing A Practical Guide For The PMO

Authors: Lisa Nash

1st Edition

0993403522, 978-0993403521

More Books

Students also viewed these Accounting questions