Calculate the projected values of the following from the table below for 1990 to 1994

Cash
Working Capital
Net Fixed Assets
Other Assets
Total Assets

 

Transcribed Image Text:

Historical and Pro Formas Divisions LPD Sales R&D EBITDA EBIT Depreciation Capital Expenditures Working Capital Capital Needs Free Cash Flow (CX) Free Cash Flow (Capital Needs & Taxes) Revised EBIT Revised EBITDA Revised Free Cash Flow Sales % Revised EBIT% EBITDA% Capital Needs % FCF% WC% of Total Depreciation % of Total CX % of Total 1986 1987 104.9 123 5.775 5.775 25.72 28.22 19.5 21.2 6.2 7.0 15.4 19.1 17.3 20.0 22.0 32.7 39.1 47.8 10.29 9.07 6.70 -14.81 -19.40 -25.06 13.725 15.425 18.25 19.95 22.44 26.41 1988 136.4 6.05 32.46 24.3 8.2 25.8 82% 82% 19.8% 19.8% 30.6% 30.6% 13.9% 14.1% 14.2% 15.3% 15.5% 14.8% 16.0% 17.3% 16.6% 16.0% 17.0% 18.0% 43.1% 30.8% 45.8% 45.0% 1989 1990 150.6 179.5 6.7 6.99 36.94 47.20 26.9 32.3 10.0 14.9 36.2 79.2 0.2 10 36.5 89.2 0.71 -32.00 -10.30 -54.92 20.2 25.31 30.24 40.21 82% 19.8% 30.6% 1991 214.8 7.41 59.70 38.7 21 29.8 31.4 61.2 29.90 -16.98 31.29 52.29 17.3% 19.4% 19.6% 32.9% 20.4% 1992 1993 262.1 319.7 8.11 9.24 71.00 83.90 47.2 57.5 23.8 26.4 30.8 31 27.8 29.1 58.6 60.1 40.20 52.90 -6.48 0.80 39.09 48.26 62.89 1994 390 10.57 99.90 70.2 29.7 31.1 33.2 64.3 68.80 7.52 59.63 74.66 89.33 19.6% 21.8% 23.4% 22.9% 23.1% 21.6% 21.3% 22.6% 23.2% 35.3% 35.1% 82% 82% 71% 61% 20.8% 22.2% 19.8% 19.8% 30.6% 30.6% 11.6% 25.6% 25.2% 60% 23.3% 24.9% 23.4% 23.8% 35.9% 65% 24.5% 24.3% Historical and Pro Formas Divisions LPD Sales R&D EBITDA EBIT Depreciation Capital Expenditures Working Capital Capital Needs Free Cash Flow (CX) Free Cash Flow (Capital Needs & Taxes) Revised EBIT Revised EBITDA Revised Free Cash Flow Sales % Revised EBIT% EBITDA% Capital Needs % FCF% WC% of Total Depreciation % of Total CX % of Total 1986 1987 104.9 123 5.775 5.775 25.72 28.22 19.5 21.2 6.2 7.0 15.4 19.1 17.3 20.0 22.0 32.7 39.1 47.8 10.29 9.07 6.70 -14.81 -19.40 -25.06 13.725 15.425 18.25 19.95 22.44 26.41 1988 136.4 6.05 32.46 24.3 8.2 25.8 82% 82% 19.8% 19.8% 30.6% 30.6% 13.9% 14.1% 14.2% 15.3% 15.5% 14.8% 16.0% 17.3% 16.6% 16.0% 17.0% 18.0% 43.1% 30.8% 45.8% 45.0% 1989 1990 150.6 179.5 6.7 6.99 36.94 47.20 26.9 32.3 10.0 14.9 36.2 79.2 0.2 10 36.5 89.2 0.71 -32.00 -10.30 -54.92 20.2 25.31 30.24 40.21 82% 19.8% 30.6% 1991 214.8 7.41 59.70 38.7 21 29.8 31.4 61.2 29.90 -16.98 31.29 52.29 17.3% 19.4% 19.6% 32.9% 20.4% 1992 1993 262.1 319.7 8.11 9.24 71.00 83.90 47.2 57.5 23.8 26.4 30.8 31 27.8 29.1 58.6 60.1 40.20 52.90 -6.48 0.80 39.09 48.26 62.89 1994 390 10.57 99.90 70.2 29.7 31.1 33.2 64.3 68.80 7.52 59.63 74.66 89.33 19.6% 21.8% 23.4% 22.9% 23.1% 21.6% 21.3% 22.6% 23.2% 35.3% 35.1% 82% 82% 71% 61% 20.8% 22.2% 19.8% 19.8% 30.6% 30.6% 11.6% 25.6% 25.2% 60% 23.3% 24.9% 23.4% 23.8% 35.9% 65% 24.5% 24.3%

Answer rating: 100% (QA)

To calculate the projected values for the given ratios from 1990 to 1994 we will use the provided hi... View the full answer