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...
-
A specialty foods company sells "gourmet hams" by mail order. The hams vary in size from 4.15 to 7.45 pounds, with a mean weight of 6 pounds and standard deviation of 0.65 pounds. The quartiles and...
-
A gas refrigeration system using air as the working fluid has a pressure ratio of 5. Air enters the compressor at 0°C. The high-pressure air is cooled to 35°C by rejecting heat to the...
-
A 22 in. by 34 in. speed limit sign is supported on a 3 -in.-wide, 5 -ft-long pole. Estimate the bending moment in the pole at ground level when a 30 -mph wind blows against the sign. List any...
-
Luxury Furniture designs and builds factory-made, premium, wood armoires for homes. All are of white oak. Its budgeted manufacturing overhead costs for the year 2012 are as follows. Overhead Cost...
-
Distinguish between financial and managerial accounting for (a) primary users of reports, (b) types and frequency of reports, and (c) purpose of reports. (b) types and frequency of reports, and (c)...
-
You have estimated spot rates as follows: r1 = 5.00%, r2 = 5.40%, r3 = 5.70%, r4 = 5.90%, r5 = 6.00%. a. What are the discount factors for each date (that is, the present value of $1 paid in year t)?...
-
Write an assembly language program for 8085 microprocessors to read consecutive memory locations from 2000 to 2FFF & transfer to 4000 to 4FFF, if interrupted display the current count at port5...
-
Brannan Manufacturing has a target debt-equity ratio of .90. Its cost of equity is 12 percent, and its cost of debt is 7 percent. If the tax rate is 25 percent, what is the company's WACC? (Do not...
-
In the table below, the production quantities and total production costs at various production quantities are shown. For example, fixed costs are IDR 10 thousand. Production Quantity (Units) Price...
-
(a) The equity share of VCC Ltd. is quoted at Rs. 210. A 3-month call option is available at a premium of Rs. 6 per share and a 3-month put option is available at a premium of Rs. 5 per share....
-
a) What do you understand by the term autocorrelation? What are the consequences of autocorrelation in estimation? (5 marks) b) What are the assumptions underlying the Durbin Watson statistics in...
-
61. The solubility product of CuS, AgS and HgS are 10 37, 104 and 1054 respectively. The solubility of these sulphides will be in the order (1) HgS> AgS > Cus (2) AgS>HgS > CuS (3) CuS AgS > HgS (4)...
-
What is the earnings per share of a company that has $1,000 in revenue, $400 of expenses, and 20 outstanding shares of stock?
-
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...
-
The overall process of creating a capital budget proposal has a lot of similarities to writing a business plan for a start-up company. Describe three aspects of the similarities between a budget...
-
There are three general categories of capital budget scenarios: replacement, expansion, and investment in a NewCo. Describe the overall decision-making context for each. How do they draw on similar...
-
In analysis, some focus seems to be on the need for NPV equations to be applied to projects that are mutually exclusive. But in practice we find that the lines are blurred in capital budgeting....
Study smarter with the SolutionInn App