Fundamentals of Corp. Fin. (Looseleaf)(Custom)
15th Edition
ISBN: 9781269945646
Author: Berk
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 20, Problem 2CQ
Use the following spreadsheet to project Idexo’s working capital needs over the next five years. Why is the increase in net working capital negative in 2017? Why does the increase in net working capital decline from 2017 to 2018?
1 | Year | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 |
2 | Working Capital ($000s) | ||||||
3 | Assets | ||||||
4 | Accounts Receivable | 20,000 | |||||
5 | Inventories | 8,219 | |||||
6 | Minimum Cash Balance | 8,219 | |||||
7 | Total Current Assets | 36,438 | |||||
8 | Liabilities | ||||||
9 | Accounts Payable | 6,205 | |||||
10 | Net Working Capital | 30,233 | |||||
11 | Increase in Net Working Capital |
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The following table tracks the main components of working capital over the life of a four-year project.
2021
2022
2023
2024
2025
Accounts receivable
0
174,000
249,000
214,000
0
Inventory
87,000
142,000
142,000
107,000
0
Accounts payable
31,000
56,000
62,000
41,000
0
Calculate net working capital and the cash inflows and outflows due to investment in working capital.
Based on the investor expectations of earning at least 12%, should this projected below be completed?
Year 0 1 2 3 4 5 6
Cash Flow (133,000) 37,000 42,750 44,000 46,500 82,500 77,000
Please explain why or why not the company should move forward with this endeavor.
ssume that today is December 31, 2018, and that the following information applies to Abner Airlines:
After-tax operating income [EBIT(1 - T)] for 2019 is expected to be $500 million. The depreciation expense for 2019 is expected to be $180 million. The capital expenditures for 2019 are expected to be $400 million. No change is expected in net operating working capital. The free cash flow is expected to grow at a constant rate of 6% per year. The required return on equity is 15%. The WACC is 10%. The firm has $200 million of non-operating assets. The market value of the company's debt is $3.096 billion. 340 million shares of stock are outstanding.
Using the corporate valuation model approach, what should be the company's stock price today? Do not round intermediate calculations. Round your answer to the nearest cent.
$
Chapter 20 Solutions
Fundamentals of Corp. Fin. (Looseleaf)(Custom)
Ch. 20 - Prob. 1CCCh. 20 - 2. What is the effect of seasonalities on...Ch. 20 - Prob. 3CCCh. 20 - Prob. 4CCCh. 20 - Prob. 5CCCh. 20 - Prob. 6CCCh. 20 - Prob. 7CCCh. 20 - Prob. 8CCCh. 20 - Prob. 9CCCh. 20 - Prob. 10CC
Ch. 20 - Based on the forecasts in this case, use the...Ch. 20 - Use the following spreadsheet to project Idexo’s...Ch. 20 - Based on the forecasts you have already developed,...Ch. 20 - Prob. 4CQCh. 20 - Prob. 5CQCh. 20 - Prob. 1CTCh. 20 - Prob. 2CTCh. 20 - Which of the following companies are likely to...Ch. 20 - Prob. 4CTCh. 20 - Prob. 5CTCh. 20 - Prob. 6CTCh. 20 - Prob. 7CTCh. 20 - What is the difference between evergreen credit...Ch. 20 - Prob. 9CTCh. 20 - Prob. 10CTCh. 20 - Prob. 11CTCh. 20 - Prob. 1PCh. 20 - Prob. 2PCh. 20 - Prob. 3PCh. 20 - The following table includes quarterly working...Ch. 20 - Prob. 5PCh. 20 - Prob. 6PCh. 20 - Prob. 7PCh. 20 - Hand-to-Mouth (H2M) is currently cash-constrained,...Ch. 20 - Prob. 9PCh. 20 - Prob. 10PCh. 20 - Prob. 11PCh. 20 - Prob. 12PCh. 20 - Prob. 13PCh. 20 - Prob. 14PCh. 20 - Prob. 15PCh. 20 - Prob. 16PCh. 20 - The Rasputin Brewery is considering using a public...Ch. 20 - Prob. 18P
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- AFN EQUATION Refer to Problem 16-1. What additional funds would be needed if the companys year-end 2019 assets had been 4 million? Assume that all other numbers are the same. Why is this AFN different from the one you found in Problem 16-1? Is the companys capital intensity the same or different? Explain.arrow_forwardAFN Equation Refer to Problem 9-1. Return to the assumption that the company had 5 million in assets at the end of 2018, but now assume that the company pays no dividends. Under these assumptions, what would be the additional funds needed for the coming year? Why is this AFN different from the one you found in Problem 9-1?arrow_forwardBroussard Skateboard’s sales are expected to increase by 15% from $8 million in 2018 to $9.2 million in 2019. Its assets totaled $5 million at the end of 2018. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2018, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is forecasted to be 6%, and the forecasted payout ratio is 40%. Use the AFN equation to forecast Broussard’s additional funds needed for the coming year.arrow_forward
- Fenton, Inc., has established a new strategic plan that calls for new capital investment. The company has a 9.8% required rate of return and an 8.3% cost of capital. Fenton currently has a return of 10% on its other investments. The proposed new investments have equal annual cash inflows expected. Management used a screening procedure of calculating a payback period for potential investments and annual cash flows, and the IRR for the 7 possible investments are displayed in image. Each investment has a 6-year expected useful life and no salvage value. A. Identify which project(s) is/are unacceptable and briefly state the conceptual justification as to why each of your choices is unacceptable. B. Assume Fenton has $330,000 available to spend. Which remaining projects should Fenton invest in and in what order? C. If Fenton was not limited to a spending amount, should they invest in all of the projects given the company is evaluated using return on investment?arrow_forwardAs a financial analyst, you have been tasked with evaluating Randy Watson Music's free cash flow. Based on the 2022 income statement, BIT was $41 million, the tax rate was 21 percent, and its depreciation expense was $6 million. NOPAT gross fixed assets increased by $28 million from 2021 and 2022. The company's current assets increased by $18 million and current liabilities increased by $14 million. Calculate the Investment in operating capital (IOC) for 2022.arrow_forwardCompany is planning its operations for next year, and as its CFO, you will need to forecast the company’s additional funds needed (AFN) based on the following data. Dollars are in millions. Last year’s sales = $364 Last year’s accounts payable = $58Sales growth rate = 30% Last year’s notes payable = $50Last year’s total assets = $548 Last year’s accruals = $30Last year’s profit margin = 5.32% Target payout ratio = 60% Your company is operating at full capacity. Based on the AFN formula and the Percentage of Sales method, what is the AFN for the coming year? Round your answer to two decimal places of dollar, but ignore dollar and millions, e.g., xxx.xx. (Hint: Use the AFN General Formula in Financial Forecasting.) Answer:arrow_forward
- WorldTrans Industries is planning its operations for next year. The CEO, wants you to forecast the firm's additional funds needed (AFN). Data for use in your forecast are shown below. Based on the AFN equation, what is the AFN for the coming year? Dollars are in millions. Last year's sales = S0 $350 Last yr's accounts payable $40 Sales growth rate = g 30% Last yr's notes payable $50 Last year's total assets = A0* $460 Last yr's accruals $30 Last year's prof margin = PM 5% Target payout ratio 60% Group of answer choices $87.4 $120.8 $90.6 $124.1 $107.9arrow_forwardChachagogo, Inc. is planning its operations for next year, and the CEO wants you to forecast the firm's additional funds needed (AFN). Data for use in your forecast are shown below. Based on the AFN equation, what is the AFN for the coming year? Last year's sales P200,000 Sales growth rate 40% Last year's current assets 65,000 Last year's noncurrent assets 70,000 Last year's profit margin 20.0% L last year's accounts payable P50,000 Last year's notes payable P25,000 Last year's accruals P20,000 Target plowback ratio 75.0% choices: -44,000 -50,000 -54,000 -16,000 -40,000 Jonson, Inc. is planning its operations for the coming year, and the CEO wants you to forecast the firm's additional funds needed (AFN). Data for use in the forecast are shown below. However, the CEO is concerned about the impact of a change in the retention ratio from 90% that was used in the past to 50%, which the firm's investment bankers have recommended. Seventy-five percent of the total assets are considered…arrow_forwardLogano Driving School's 2021 balance sheet showed net fixed assets of $2.4 million, and the 2022 balance sheet showed net fixed assets of $3.4 million. The company's 2022 income statement showed a depreciation expense of $309,000. What was net capital spending for 2022? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, e.g., 1,234,567.)arrow_forward
- Calculate Comfy Home’s Free Cash Flow in 2018. Please note that the company’s tax rate is 25% and anticipated capital expenditures for 2018 are $25,000. Round your answer to the nearest whole dollar.arrow_forwardASAP!! Assume that today is December 31, 2015, and the following information applies to Vermeil Airlines: • After-tax operating income [EBIT(1 T), also called NOPAT] for 2016 is expected to be $500 million.• The depreciation expense for 2016 is expected to be $100 million.• The capital expenditures for 2016 are expected to be $200 million.• No change is expected in net operating working capital.• The free cash flow is expected to grow at a constant rate of 6 percent per year.• The required return on equity is 15 percent.• The WACC is 12 percent.• The market value of the company’s debt is $3.2 billion.• 200 million shares of stock are outstanding.Using the free cash flow approach, what should the company’s stock price be today?arrow_forwardAssume that today is December 31, 2021, and that the following information applies to Abner Airlines: After-tax operating income [EBIT(1 - T)] for 2022 is expected to be $600 million. The depreciation expense for 2022 is expected to be $90 million. The capital expenditures for 2022 are expected to be $250 million. No change is expected in net operating working capital. The free cash flow is expected to grow at a constant rate of 5% per year. The required return on equity is 15%. The WACC is 9%. The firm has $193 million of nonoperating assets. The market value of the company's debt is $2.918 billion. 230 million shares of stock are outstanding. Using the corporate valuation model approach, what should be the company's stock price today? Do not round intermediate calculations. Round your answer to the nearest cent.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Fundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Financial Projections for Startups Basic Walkthrough; Author: Mike Lingle;https://www.youtube.com/watch?v=7avegQF4dxI;License: Standard youtube license