Calculate the projected values of the following from the table below for 1990 to 1994 Cash Working
Fantastic news! We've Found the answer you've been seeking!
Question:
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%
Expert Answer:
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
Related Book For
Fundamentals of corporate finance
ISBN: 978-0470876442
2nd Edition
Authors: Robert Parrino, David S. Kidwell, Thomas W. Bates
Posted Date:
Students also viewed these finance questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
A researcher wanted to find out if there was difference between older movie goers and younger movie goers with respect to their estimates of a successful actors income. The researcher first...
-
Predict your results. Write "yes" or "no," depending on whether you think the plate will show growth. Give the reason (s) for your predictions. Observe the colonies through the petri plate lids. Do...
-
For each of the following situations, identify the measure of central tendency (mean, median, or mode) that would provide the best description of the average score: a. A news reporter interviewed...
-
Weak base B has a pK b of 6.78 and weak acid HA has a pK a of 5.12. a. Which is the stronger base, B or A ? b. Which is the stronger acid, HA or BH + ? c. Consider the following reaction: B(aq) +...
-
Ethos Day School is a private elementary school. In addition to regular classes, after-school care is provided between 3:00 p.m. and 6:00 p.m. at SF12 per child per hour. Financial results for the...
-
The percent of college students marijuana use for a sample of 95,761 students is shown in the pie chart. Find the probability of each event. (a) Randomly selecting a student who never used marijuana....
-
Name the type of sampling/study: Joey could not find out how to break the student into groups, so he just surveyed every single student in the school. QUESTION 2 Name the type of sampling: Alyssa...
-
Bright Sparks Electrical - Bank Register Report: Now that you have completed the journals for the month, you need to prepare the Bank Register Report in the template below. Not all general journals...
-
An owner's title insurance policy will protect a homeowner against the loss of value resulting from a physical hazard for the duration of ownership of the property. True False
-
For each of the following situations, determine whether the criteria for revenue recognition have been met by December 31, 2018. a. A manufacturing company received \(\$ 60,000\) cash on December...
-
Sarbanes-Oxley Act The Sarbanes-Oxley Act of 2002 was enacted to help restore confidence in financial reporting. Which of the following was not part of the legislation? a. Severe penalties for...
-
There are strong echoes in this chapter of Porters seminal 5 Forces analysis of two decades ago. What has changed and what remains the same 20 or so years on (both about Information & Communication...
-
Many have argued that the Internet renders strategy obsolete. In reality, the opposite is true. In what ways do you think that this statement from Michael Porter is appropriate? And how would you...
-
For organizations considering electronic commerce, what are some of the implications from these cases?
-
In the AD partnership, A's capital is P140,000 and D's is P40,000 and they share income in a 75% and 25% ratio, respectively. They decide to admit B to the partnership. Each of the following...
-
Annual dividends of ATTA Corp grew from $0.96 in 2005 to $1.76 in 2017. What was the annual growth rate?
-
The CFO of a certain company always wears his green suit on a day that the firm is about to release positive information about his company. You believe that you can profit from this information by...
-
What difficulties do firms face in estimating cash flows from an overseas project?
-
What are the strengths and weaknesses of the accounting rate of return approach?
-
What is a semi-variable cost?
-
What does the term operational gearing refer to and why is this important?
-
From the data and your answers from question 5, sketch two graphs showing the following against level of activity: (i) variable cost; and (ii) fixed cost. Clearly label each line on your graphs.
Study smarter with the SolutionInn App