Complete Cash Flow Data Forecast Year Sales growth rate NOPAT margin Beginning net operating working/sales Beginning net
Fantastic news! We've Found the answer you've been seeking!
Question:
Complete Cash Flow Data
Transcribed Image Text:
Forecast Year Sales growth rate NOPAT margin Beginning net operating working/sales Beginning net operating long-term assets/sales Beginning net debt to captial ratio After-tax cost of debt Cash Flow Data Net income -Change in net working capital -Change in net long-term assets + Change in net debt =Free cash flow to equity Net operating profit after tax -Change in net working capital -change in net long term assets = Free cash flow to capital 2018 9.39% 9.89% 10.60% 58.10% 57.20% 1.50% 20356.31 -23191.95 -127118.15 -85977.38 84689.03 21645.97 -23191.95 -127118.15 171956.07 2022 2023 2024 2019 2020 2021 2025 8.31% 8.42% 7.60% 6.80% 6.00% 5.30% 4.50% 10.49% 11.09% 10.50% 9.90% 9.30% 8.70% 8.10% 9.60% 57.00% 55.70% 55.70% 55.70% 55.70% 55.70% 57.20% 57.20% 57.20% 57.20% 57.20% 57.20% 1.70% 1.90% 2.10% 2.30% 2.50% 2.50% 2.50% 2026 2027 3.80% 3.00% 7.60% 7.00% 8.60% 8.60% 8.60% 8.60% 8.60% 8.60% 8.60% 8.60% 55.70% 55.70% 55.70% 57.20% 57.20% 57.20% 2.50% 2.50% Forecast Year Sales growth rate NOPAT margin Beginning net operating working/sales Beginning net operating long-term assets/sales Beginning net debt to captial ratio After-tax cost of debt Cash Flow Data Net income -Change in net working capital -Change in net long-term assets + Change in net debt =Free cash flow to equity Net operating profit after tax -Change in net working capital -change in net long term assets = Free cash flow to capital 2018 9.39% 9.89% 10.60% 58.10% 57.20% 1.50% 20356.31 -23191.95 -127118.15 -85977.38 84689.03 21645.97 -23191.95 -127118.15 171956.07 2022 2023 2024 2019 2020 2021 2025 8.31% 8.42% 7.60% 6.80% 6.00% 5.30% 4.50% 10.49% 11.09% 10.50% 9.90% 9.30% 8.70% 8.10% 9.60% 57.00% 55.70% 55.70% 55.70% 55.70% 55.70% 57.20% 57.20% 57.20% 57.20% 57.20% 57.20% 1.70% 1.90% 2.10% 2.30% 2.50% 2.50% 2.50% 2026 2027 3.80% 3.00% 7.60% 7.00% 8.60% 8.60% 8.60% 8.60% 8.60% 8.60% 8.60% 8.60% 55.70% 55.70% 55.70% 57.20% 57.20% 57.20% 2.50% 2.50%
Expert Answer:
Answer rating: 100% (QA)
To complete the cash flow data we will calculate the values for each year based on the provided information Heres the completed cash flow data 2018 Ne... View the full answer
Related Book For
Engineering Economy
ISBN: 978-0133439274
16th edition
Authors: William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Posted Date:
Students also viewed these accounting questions
-
A geothermal heat pump can save up to 80% of the annual heating and cooling bills of a certain home in the northeastern U.S. In this region, the yearly cost of conventionally heating and cooling a...
-
The initial cost of a bridge that is expected to be in place forever is $70 million. Maintenance can be done at 1-, 2-, 3-, or 4-year intervals, but the longer the interval between servicing, the...
-
The initial cost of a packed-bed degassing reactor for removing trihalomethanes from potable water is $84,000. The annual operating cost for power, site maintenance, etc. is $13,000. If the salvage...
-
Using and citing Bevan, define active empathic listening. Report on both the meaning and significance of the definition Explain how you can use active empathic listening to help you improve your...
-
Suppose we have a stochastic model Y i = x i + i Where the is are independent with mean 0 and variance 2 x i . Show that the weighted least squares estimator of is = y /x. Is the standard error...
-
What do you think are three common mistakes that novice analysts make in output design?
-
Refer to Exercise 10. The quality engineer suspects that the setting with a P-value of 0.03 may actually reduce the proportion of defective parts. What P-value would be needed to make this conclusion...
-
An economics student wishes to see if there is a relationship between the amount of state debt per capita and the amount of tax per capita at the state level. Based on the following data, can she or...
-
John is an employee at a publishing company in Toronto. He has access to copyrighted materials that the company has invested time and resources into creating, including digital books and other...
-
Bill and Ellen are husband and wife with five married children and eight grandchildren. Commencing in December 2014, they would like to transfer a tract of land (worth $1,008,000) equally to their...
-
What's the price of a $50 par value 7% preferred share if the required rate of return is 8%?
-
(b) The assumed coupling and three leptons have constant. (ii) If are the mulon and branching ratios the (is Given that the -6 2.2x10's, make time lifetime of the Me + v + v I e + v + v (mass 105...
-
Recast the reported cash flow statement to a 'standardised' cash flow statement for Rossi Ltd to perform cash flow analysis. The following is the cash flow statement of Rossi Ltd for the year ended...
-
Suppose the current in a 1.50 mm diameter copper wire is 2.5 A is used to light a bulb, and the number density of the free electrons in the metal of the wire is 3.001025 m a) Find the drift velocity...
-
1. A silver wire 1 mm in diameter transfer a charge of 90 C in 1 hr and 15 min. Silver contains 5.8x1028 free electrons per m. a) What is the current in the wire? b) What is the drift velocity of the...
-
A world-class runner can run long distances at a pace of 10 km/hour. That runner expends 700 kilocalories of energy per hour. a. What is the power (in Watts [W] the runner is exerting while running?...
-
2. (a). (b) An angle-modulated signal is given by x(t) = 4 sin (2106t + 60 sin 210+) (i) Find the instantaneous frequency of the signal in Hertz. (ii) Find the frequency deviation Af in Hertz. (iii)...
-
Consider the setup in Problem 16. Show that the relative speed of the ball and the point of contact on the stick is the same before and immediately after the collision. (This result is analogous to...
-
A wood products company has decided to purchase new logging equipment for $100,000 with a trade-in of its old equipment. The old equipment has a BV of $10,000 at the time of the trade-in. The new...
-
Three mutually exclusive earth-moving pieces of equipment are being considered for several large building projects in India over the next five years. The estimated cash flows for each alternative are...
-
A 250 square foot shell and tube heat exchanger was purchased for $15,250 in 2004 when the index value was 830. Estimate the cost of 150 square foot shell and tube heat exchanger in 2014 when the...
-
Calculate the residual enthalpy and entropy for carbon dioxide at \(393 \mathrm{~K}\) and \(12 \mathrm{MPa}\) using any equation of state.
-
Prove that \(d S=\frac{C_{P}}{T} d T-\beta V d P\).
-
What assumptions are involved in the Clausius-Clapeyron equation?
Study smarter with the SolutionInn App