Long-term plans Table 29.18 shows the 2019 financial statements for the Executive Cheese Company. Annual
- a. Construct a model for Executive Cheese like the one in Table 29.9.
- b. Use your model to produce a set of financial statements for 2020.
TABLE 29.18 Financial statements for Executive Cheese Company, 2019 (figures in thousands)
![Check Mark](/static/check-mark.png)
Want to see the full answer?
Check out a sample textbook solution![Blurred answer](/static/blurred-answer.jpg)
Chapter 29 Solutions
PRIN.OF CORP.FINANCE-CONNECT ACCESS
- Assume today is December 31, 2019. Barrington Industries expects that its 2020 after-tax operating income [EBIT(1 – T)] will be $420 million and its 2020 depreciation expense will be $70 million. Barrington's 2020 gross capital expenditures are expected to be $100 million and the change in its net operating working capital for 2020 will be $30 million. The firm's free cash flow is expected to grow at a constant rate of 5% annually. Assume that its free cash flow occurs at the end of each year. The firm's weighted average cost of capital is 8.8%; the market value of the company's debt is $2.15 billion; and the company has 190 million shares of common stock outstanding. The firm has no preferred stock on its balance sheet and has no plans to use it for future capital budgeting projects. Also, the firm has zero non-operating assets. Using the corporate valuation model, what should be the company's stock price today (December 31, 2019)? Do not round intermediate calculations. Round your…arrow_forwardThe firm`s manager targets to increase the current ratio in the year (2022) by 20% out of the previous year (2021), this requiring to increase the amount of the total current asset. To what level can the manager increase the total current asset to achieve this target (20%) at (2022)?arrow_forwardCarlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in 2020, or by 20%. Its assets totaled $4 million at the end of 2019. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 7%, and the forecasted retention ratio is 35%. Use the AFN equation to forecast the additional funds Carlsbad will need for the coming year. Write out your answer completely. For example, 5 million should be entered as 5,000,000. Round your answer to the nearest dollar. i keeo getting it wrong, i got: can you help me walk though it with excel formulas please :) ASSETS $ 4,000,000.00 SALES IN 2019 $ 5,000,000.00 TOTAL LIBS $ 1,000,000.00 SALES IN 2020 $ 6,000,000.00 AP $ 250,000.00 VALUE OF SALES INCEASE $…arrow_forward
- Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in 2020, or by 20%. Its assets totaled $3 million at the end of 2019. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 6%. a. Assume that the company pays no dividends. Use the AFN equation to forecast the additional funds Carlsbad will need for the coming year. Write out your answer completely. For example, 5 million should be entered as 5,000,000. Round your answer to the nearest dollar. b. Why is this AFN different from the one when the company pays dividends? I. Under this scenario the company would have a lower level of retained earnings, which would decrease the amount of additional funds needed. II. Under this scenario the company would have a higher…arrow_forwardThe following is a four-year forecast for Torino Marine. Year Free cash flow ($ millions) a. Fair market value b. Fair market value per share 2022 -61 $ a. Estimate the fair market value of Torino Marine at the end of 2021. Assume that after 2025, earnings before interest and tax will remain constant at $200 million, depreciation will equal capital expenditures in each year, and working capital will not change. Torino Marine's weighted-average cost of capital is 15 percent and its tax rate is 30 percent. Note: Do not round intermediate calculations. Enter your answer in millions rounded to 1 decimal place. 6.89 2023 82 b. Estimate the fair market value per share of Torino Marine's equity at the end of 2021 if the company has 46 million shares outstanding and the market value of its interest-bearing liabilities on the valuation date equals $360 million. Note: Do not round intermediate calculations. Round your answer to 2 decimal places. 2024 99 million 2025 121arrow_forwardFor the year ending December 31, 2017, sales for Company Y were $78.51 billion. Beginning January 1, 2018 Company Y plans to invest 7.5% of their sales amount each year and they expect their sales to increase by 4% each year over the next three years. Company Y invests into an account earning an APR of 2.0% compounded continuously. Assume a continuous income stream. How much money will be in the investment account on December 31, 2020? Round your answer to three decimal places. 84.762 X billion dollars How much money did Company Y invest in the account between January 1, 2018 and December 31, 2020? Round your answer to three decimal places. billion dollars How much interest did Company Y earn on this investment between January 1, 2018 and December 31, 2020? Round your answer to three decimal places. If intermediate values are used, be sure to use the unrounded values to determine the answer. billion dollars Submit Answerarrow_forward
- For the year ending December 31, 2017, sales for Company Y were $72.11 billion. Beginning January 1, 2018 Company Y plans to invest 8.5% of their sales amount each year and they expect their sales to increase by 7% each year over the next three years. Company Y invests into an account earning an APR of 2.0% compounded continuously. Assume a continuous income stream. How much money will be in the investment account on December 31, 2020? Round your answer to three decimal places. X billion dollars How much money did Company Y invest in the account between January 1, 2018 and December 31, 2020? Round your answer to three decimal places. billion dollars How much interest did Company Y earn on this investment between January 1, 2018 and December 31, 2020? Round your answer to three decimal places. If intermediate values are used, be sure to use the unrounded values to determine the answer. billion dollars TEACHER Submit Answerarrow_forwardRentz Corporation is investigating the optimal level of current assets for the coming year. Management expects sales to increase to approximately $4 million as a result of an asset expansion presently being undertaken. Fixed assets total $1 million, and the firm plans to maintain a 60% debt-to-assets ratio. Rentz's interest rate is currently 10% on both short- term and long-term debt (which the firm uses in its permanent structure). Three alternatives regarding the projected current assets level are under consideration: (1) a restricted policy where current assets would be only 45% of projected sales, (2) a moderate policy where current assets would be 50% of sales, and (3) a relaxed policy where current assets would be 60% of sales. Earnings before interest and taxes should be 13% of total sales, and the federal-plus-state tax rate is 40%. a. What is the expected return on equity under each current assets level? Round your answers to two decimal places. Restricted policy Moderate…arrow_forwardFor the year ending December 31, 2017, sales for Corporation Y were $63.21 billion. Beginning January 1, 2018 Corporation Y plans to invest 8.5% of their sales amount each year and they expect their sales to increase by 5% each year over the next three years. Corporation Y invests into an account earning an APR of 1.4% compounded continuously. Assume a continuous income stream. How much money will be in the investment account on December 31, 2020? Round your answer to three decimal places. billion dollars How much money did Company Y invest in the account between January 1, 2018 and December 31, 2020? Round your answer to three decimal places. billion dollars How much interest did Company Y earn between January 1, 2018 and December 31, 2020? Round your answer to three decimal places. If intermediate values are used, be sure to use the unrounded values to determine the answer. billion dollarsarrow_forward
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTIntermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage LearningFundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337514835/9781337514835_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337395083/9781337395083_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337902571/9781337902571_smallCoverImage.jpg)