4.99 See Answer

Question: The Coca-Cola Company is a global

The Coca-Cola Company is a global soft-drink beverage company that is a primary and direct competitor with PepsiCo. The data in Chapter 12 Exhibits 12.14–12.16 include the actual amounts for 2012 and projected amounts for Year +1 to Year +6 for the income statements, balance sheets, and statements of cash flows for Coca-Cola. The market equity beta for Coca-Cola at the end of 2012 is 0.75. Assume that the risk-free interest rate is 3.0% and the market risk premium is 6.0%. Coca-Cola has 4,469 million shares outstanding at the end of 2012, when Coca-Cola’s share price was $35.48. Data from chapter 12:
The Coca-Cola Company is a global soft-drink beverage company that is a primary and direct competitor with PepsiCo. The data in Chapter 12 Exhibits 12.14–12.16 include the actual amounts for 2012 and projected amounts for Year +1 to Year +6 for the income statements, balance sheets, and statements of cash flows for Coca-Cola.
The market equity beta for Coca-Cola at the end of 2012 is 0.75. Assume that the risk-free interest rate is 3.0% and the market risk premium is 6.0%. Coca-Cola has 4,469 million shares outstanding at the end of 2012, when Coca-Cola’s share price was $35.48.
Data from chapter 12:



REQUIRED
Part I—Computing Coca-Cola’s Value-to-Book Ratio Using the Value-to-Book Valuation Approach
a. Use the CAPM to compute the required rate of return on common equity capital for Coca-Cola.
b. Using the projected financial statements in Exhibits 12.14–12.16, derive the projected residual ROCE (return on common shareholders’ equity) for Coca-Cola for Years +1 through +5.
c. The projected income statements and balance sheets for Year +6 assume Coca-Cola will grow at a steady state growth rate of 3.0%. Derive the projected residual ROCE for Year +6 for Coca-Cola.
d. Using the required rate of return on common equity from Requirement a as a discount rate, compute the sum of the present value of residual ROCE for Coca-Cola for Years +1 through þ5.
e. Using the required rate of return on common equity from Requirement a as a discount rate and the long-run growth rate from Requirement c, compute the continuing value of Coca- Cola as of the start of Year +6 based on Coca-Cola’s continuing residual ROCE in Year +6 and beyond. After computing continuing value as of the start of Year +6, discount it to present value at the start of Year +1.
f. Compute Coca-Cola’s value-to-book ratio as of the end of 2012 with the following three steps:
(1) Compute the total sum of the present value of all future residual ROCE (from Requirements d and e).
(2) To the total from Requirement f (1), add 1 (representing the book value of equity as of the beginning of the valuation as of the end of 2012).
(3) Adjust the total sum from Requirement f (2) using the midyear discounting adjustment factor.
g. Compute Coca-Cola’s market-to-book ratio as of the end of 2012. Compare the value to book ratio to the market-to-book ratio. What investment decision does the comparison suggest? What does the comparison suggest regarding the pricing of Coca-Cola shares in the market: underpriced, overpriced, or fairly priced?
h. Use the value-to-book ratio to project the value of a share of common equity in Coca-Cola.
i. If you computed Coca-Cola’s common equity share value using the free cash flows to common equity valuation approach in Problem 12.16 in Chapter 12 and/or the residual income valuation approach in Problem 13.19 in Chapter 13, compare the value estimate you obtained in those problems with the estimate you obtained in this case. You should obtain the same value estimates under all three approaches. If you have not yet worked those problems, you would benefit from doing so now.
Data from Problem 12.16 in Chapter 12:


Part II—Analyzing Coca-Cola’s Share Price Using the Value-Earnings Ratio, Price-Earnings Ratio, Price Differentials, and Reverse Engineering
j. Use the forecast data for Year +1 to project Year +1 earnings per share. To do so, divide the projection of Coca-Cola’s comprehensive income available for common shareholders in Year +1 by the number of common shares outstanding at the end of 2012. Using this Year +1 earnings-per-share forecast and the share value computed in Requirement h, compute Coca-Cola’s value-earnings ratio.
k. Using the Year +1 earnings-per-share forecast from Requirement j and using the share price at the end of 2012, compute Coca-Cola’s price-earnings ratio. Compare Coca-Cola’s value-earnings ratio with its price-earnings ratio. What investment decision does the comparison suggest? What does the comparison suggest regarding the pricing of Coca-Cola shares in the market: underpriced, overpriced, or fairly priced? Does this comparison lead to the same conclusions you reached when comparing value-to-book ratios with market-to-book ratios in Requirement g?
l. Note: For this part only, assume Coca-Cola’s long-run growth beginning in Year +6 will be 1% rather than 3%. With a 1% growth rate, Year +6 comprehensive income will be $10,615 million. Compute Coca-Cola’s price differential at the end of 2012. Compute Coca-Cola’s price differential as a percentage of Coca-Cola’s risk-neutral value. What dollar amount and what percentage amount has the market discounted Coca-Cola shares for risk?
m. Reverse engineer Coca-Cola’s share price at the end of 2012 to solve for the implied expected rate of return. First, assume that value equals price and that the earnings and 3% long-run growth forecasts through Year þ6 and beyond are reliable proxies for the market’s expectations for Coca-Cola. Then solve for the implied expected rate of return (the discount rate) the market has impounded in Coca-Cola’s share price. (Hint: Begin with the forecast and valuation spreadsheet you developed to value Coca-Cola shares. Vary the discount rate until you solve for the discount rate that makes your value estimate exactly equal the end of 2012 market price of $35.48 per share.)
n. Reverse engineer Coca-Cola’s share price at the end of 2012 to solve for the implied expected long-run growth. First, assume that value equals price and that the earnings forecasts through Year +5 are reliable proxies for the market’s expectations for Coca-Cola. Also assume that the discount rate implied by the CAPM (computed in Requirement a) is a reliable proxy for the market’s expected rate of return. Then solve for the implied expected long-run growth rate the market has impounded in Coca-Cola’s share price.
(Hint: Begin with the forecast and valuation spreadsheet you developed to value Coca- Cola shares and use the CAPM discount rate. Set the long-run growth parameter initially to zero. Increase the long-run growth rate until you solve for the growth rate that makes your value estimate exactly equal the end of 2012 market price of $35.48 per share.)

The Coca-Cola Company is a global soft-drink beverage company that is a primary and direct competitor with PepsiCo. The data in Chapter 12 Exhibits 12.14–12.16 include the actual amounts for 2012 and projected amounts for Year +1 to Year +6 for the income statements, balance sheets, and statements of cash flows for Coca-Cola.
The market equity beta for Coca-Cola at the end of 2012 is 0.75. Assume that the risk-free interest rate is 3.0% and the market risk premium is 6.0%. Coca-Cola has 4,469 million shares outstanding at the end of 2012, when Coca-Cola’s share price was $35.48.
Data from chapter 12:



REQUIRED
Part I—Computing Coca-Cola’s Value-to-Book Ratio Using the Value-to-Book Valuation Approach
a. Use the CAPM to compute the required rate of return on common equity capital for Coca-Cola.
b. Using the projected financial statements in Exhibits 12.14–12.16, derive the projected residual ROCE (return on common shareholders’ equity) for Coca-Cola for Years +1 through +5.
c. The projected income statements and balance sheets for Year +6 assume Coca-Cola will grow at a steady state growth rate of 3.0%. Derive the projected residual ROCE for Year +6 for Coca-Cola.
d. Using the required rate of return on common equity from Requirement a as a discount rate, compute the sum of the present value of residual ROCE for Coca-Cola for Years +1 through þ5.
e. Using the required rate of return on common equity from Requirement a as a discount rate and the long-run growth rate from Requirement c, compute the continuing value of Coca- Cola as of the start of Year +6 based on Coca-Cola’s continuing residual ROCE in Year +6 and beyond. After computing continuing value as of the start of Year +6, discount it to present value at the start of Year +1.
f. Compute Coca-Cola’s value-to-book ratio as of the end of 2012 with the following three steps:
(1) Compute the total sum of the present value of all future residual ROCE (from Requirements d and e).
(2) To the total from Requirement f (1), add 1 (representing the book value of equity as of the beginning of the valuation as of the end of 2012).
(3) Adjust the total sum from Requirement f (2) using the midyear discounting adjustment factor.
g. Compute Coca-Cola’s market-to-book ratio as of the end of 2012. Compare the value to book ratio to the market-to-book ratio. What investment decision does the comparison suggest? What does the comparison suggest regarding the pricing of Coca-Cola shares in the market: underpriced, overpriced, or fairly priced?
h. Use the value-to-book ratio to project the value of a share of common equity in Coca-Cola.
i. If you computed Coca-Cola’s common equity share value using the free cash flows to common equity valuation approach in Problem 12.16 in Chapter 12 and/or the residual income valuation approach in Problem 13.19 in Chapter 13, compare the value estimate you obtained in those problems with the estimate you obtained in this case. You should obtain the same value estimates under all three approaches. If you have not yet worked those problems, you would benefit from doing so now.
Data from Problem 12.16 in Chapter 12:


Part II—Analyzing Coca-Cola’s Share Price Using the Value-Earnings Ratio, Price-Earnings Ratio, Price Differentials, and Reverse Engineering
j. Use the forecast data for Year +1 to project Year +1 earnings per share. To do so, divide the projection of Coca-Cola’s comprehensive income available for common shareholders in Year +1 by the number of common shares outstanding at the end of 2012. Using this Year +1 earnings-per-share forecast and the share value computed in Requirement h, compute Coca-Cola’s value-earnings ratio.
k. Using the Year +1 earnings-per-share forecast from Requirement j and using the share price at the end of 2012, compute Coca-Cola’s price-earnings ratio. Compare Coca-Cola’s value-earnings ratio with its price-earnings ratio. What investment decision does the comparison suggest? What does the comparison suggest regarding the pricing of Coca-Cola shares in the market: underpriced, overpriced, or fairly priced? Does this comparison lead to the same conclusions you reached when comparing value-to-book ratios with market-to-book ratios in Requirement g?
l. Note: For this part only, assume Coca-Cola’s long-run growth beginning in Year +6 will be 1% rather than 3%. With a 1% growth rate, Year +6 comprehensive income will be $10,615 million. Compute Coca-Cola’s price differential at the end of 2012. Compute Coca-Cola’s price differential as a percentage of Coca-Cola’s risk-neutral value. What dollar amount and what percentage amount has the market discounted Coca-Cola shares for risk?
m. Reverse engineer Coca-Cola’s share price at the end of 2012 to solve for the implied expected rate of return. First, assume that value equals price and that the earnings and 3% long-run growth forecasts through Year þ6 and beyond are reliable proxies for the market’s expectations for Coca-Cola. Then solve for the implied expected rate of return (the discount rate) the market has impounded in Coca-Cola’s share price. (Hint: Begin with the forecast and valuation spreadsheet you developed to value Coca-Cola shares. Vary the discount rate until you solve for the discount rate that makes your value estimate exactly equal the end of 2012 market price of $35.48 per share.)
n. Reverse engineer Coca-Cola’s share price at the end of 2012 to solve for the implied expected long-run growth. First, assume that value equals price and that the earnings forecasts through Year +5 are reliable proxies for the market’s expectations for Coca-Cola. Also assume that the discount rate implied by the CAPM (computed in Requirement a) is a reliable proxy for the market’s expected rate of return. Then solve for the implied expected long-run growth rate the market has impounded in Coca-Cola’s share price.
(Hint: Begin with the forecast and valuation spreadsheet you developed to value Coca- Cola shares and use the CAPM discount rate. Set the long-run growth parameter initially to zero. Increase the long-run growth rate until you solve for the growth rate that makes your value estimate exactly equal the end of 2012 market price of $35.48 per share.)

The Coca-Cola Company is a global soft-drink beverage company that is a primary and direct competitor with PepsiCo. The data in Chapter 12 Exhibits 12.14–12.16 include the actual amounts for 2012 and projected amounts for Year +1 to Year +6 for the income statements, balance sheets, and statements of cash flows for Coca-Cola.
The market equity beta for Coca-Cola at the end of 2012 is 0.75. Assume that the risk-free interest rate is 3.0% and the market risk premium is 6.0%. Coca-Cola has 4,469 million shares outstanding at the end of 2012, when Coca-Cola’s share price was $35.48.
Data from chapter 12:



REQUIRED
Part I—Computing Coca-Cola’s Value-to-Book Ratio Using the Value-to-Book Valuation Approach
a. Use the CAPM to compute the required rate of return on common equity capital for Coca-Cola.
b. Using the projected financial statements in Exhibits 12.14–12.16, derive the projected residual ROCE (return on common shareholders’ equity) for Coca-Cola for Years +1 through +5.
c. The projected income statements and balance sheets for Year +6 assume Coca-Cola will grow at a steady state growth rate of 3.0%. Derive the projected residual ROCE for Year +6 for Coca-Cola.
d. Using the required rate of return on common equity from Requirement a as a discount rate, compute the sum of the present value of residual ROCE for Coca-Cola for Years +1 through þ5.
e. Using the required rate of return on common equity from Requirement a as a discount rate and the long-run growth rate from Requirement c, compute the continuing value of Coca- Cola as of the start of Year +6 based on Coca-Cola’s continuing residual ROCE in Year +6 and beyond. After computing continuing value as of the start of Year +6, discount it to present value at the start of Year +1.
f. Compute Coca-Cola’s value-to-book ratio as of the end of 2012 with the following three steps:
(1) Compute the total sum of the present value of all future residual ROCE (from Requirements d and e).
(2) To the total from Requirement f (1), add 1 (representing the book value of equity as of the beginning of the valuation as of the end of 2012).
(3) Adjust the total sum from Requirement f (2) using the midyear discounting adjustment factor.
g. Compute Coca-Cola’s market-to-book ratio as of the end of 2012. Compare the value to book ratio to the market-to-book ratio. What investment decision does the comparison suggest? What does the comparison suggest regarding the pricing of Coca-Cola shares in the market: underpriced, overpriced, or fairly priced?
h. Use the value-to-book ratio to project the value of a share of common equity in Coca-Cola.
i. If you computed Coca-Cola’s common equity share value using the free cash flows to common equity valuation approach in Problem 12.16 in Chapter 12 and/or the residual income valuation approach in Problem 13.19 in Chapter 13, compare the value estimate you obtained in those problems with the estimate you obtained in this case. You should obtain the same value estimates under all three approaches. If you have not yet worked those problems, you would benefit from doing so now.
Data from Problem 12.16 in Chapter 12:


Part II—Analyzing Coca-Cola’s Share Price Using the Value-Earnings Ratio, Price-Earnings Ratio, Price Differentials, and Reverse Engineering
j. Use the forecast data for Year +1 to project Year +1 earnings per share. To do so, divide the projection of Coca-Cola’s comprehensive income available for common shareholders in Year +1 by the number of common shares outstanding at the end of 2012. Using this Year +1 earnings-per-share forecast and the share value computed in Requirement h, compute Coca-Cola’s value-earnings ratio.
k. Using the Year +1 earnings-per-share forecast from Requirement j and using the share price at the end of 2012, compute Coca-Cola’s price-earnings ratio. Compare Coca-Cola’s value-earnings ratio with its price-earnings ratio. What investment decision does the comparison suggest? What does the comparison suggest regarding the pricing of Coca-Cola shares in the market: underpriced, overpriced, or fairly priced? Does this comparison lead to the same conclusions you reached when comparing value-to-book ratios with market-to-book ratios in Requirement g?
l. Note: For this part only, assume Coca-Cola’s long-run growth beginning in Year +6 will be 1% rather than 3%. With a 1% growth rate, Year +6 comprehensive income will be $10,615 million. Compute Coca-Cola’s price differential at the end of 2012. Compute Coca-Cola’s price differential as a percentage of Coca-Cola’s risk-neutral value. What dollar amount and what percentage amount has the market discounted Coca-Cola shares for risk?
m. Reverse engineer Coca-Cola’s share price at the end of 2012 to solve for the implied expected rate of return. First, assume that value equals price and that the earnings and 3% long-run growth forecasts through Year þ6 and beyond are reliable proxies for the market’s expectations for Coca-Cola. Then solve for the implied expected rate of return (the discount rate) the market has impounded in Coca-Cola’s share price. (Hint: Begin with the forecast and valuation spreadsheet you developed to value Coca-Cola shares. Vary the discount rate until you solve for the discount rate that makes your value estimate exactly equal the end of 2012 market price of $35.48 per share.)
n. Reverse engineer Coca-Cola’s share price at the end of 2012 to solve for the implied expected long-run growth. First, assume that value equals price and that the earnings forecasts through Year +5 are reliable proxies for the market’s expectations for Coca-Cola. Also assume that the discount rate implied by the CAPM (computed in Requirement a) is a reliable proxy for the market’s expected rate of return. Then solve for the implied expected long-run growth rate the market has impounded in Coca-Cola’s share price.
(Hint: Begin with the forecast and valuation spreadsheet you developed to value Coca- Cola shares and use the CAPM discount rate. Set the long-run growth parameter initially to zero. Increase the long-run growth rate until you solve for the growth rate that makes your value estimate exactly equal the end of 2012 market price of $35.48 per share.)

The Coca-Cola Company is a global soft-drink beverage company that is a primary and direct competitor with PepsiCo. The data in Chapter 12 Exhibits 12.14–12.16 include the actual amounts for 2012 and projected amounts for Year +1 to Year +6 for the income statements, balance sheets, and statements of cash flows for Coca-Cola.
The market equity beta for Coca-Cola at the end of 2012 is 0.75. Assume that the risk-free interest rate is 3.0% and the market risk premium is 6.0%. Coca-Cola has 4,469 million shares outstanding at the end of 2012, when Coca-Cola’s share price was $35.48.
Data from chapter 12:



REQUIRED
Part I—Computing Coca-Cola’s Value-to-Book Ratio Using the Value-to-Book Valuation Approach
a. Use the CAPM to compute the required rate of return on common equity capital for Coca-Cola.
b. Using the projected financial statements in Exhibits 12.14–12.16, derive the projected residual ROCE (return on common shareholders’ equity) for Coca-Cola for Years +1 through +5.
c. The projected income statements and balance sheets for Year +6 assume Coca-Cola will grow at a steady state growth rate of 3.0%. Derive the projected residual ROCE for Year +6 for Coca-Cola.
d. Using the required rate of return on common equity from Requirement a as a discount rate, compute the sum of the present value of residual ROCE for Coca-Cola for Years +1 through þ5.
e. Using the required rate of return on common equity from Requirement a as a discount rate and the long-run growth rate from Requirement c, compute the continuing value of Coca- Cola as of the start of Year +6 based on Coca-Cola’s continuing residual ROCE in Year +6 and beyond. After computing continuing value as of the start of Year +6, discount it to present value at the start of Year +1.
f. Compute Coca-Cola’s value-to-book ratio as of the end of 2012 with the following three steps:
(1) Compute the total sum of the present value of all future residual ROCE (from Requirements d and e).
(2) To the total from Requirement f (1), add 1 (representing the book value of equity as of the beginning of the valuation as of the end of 2012).
(3) Adjust the total sum from Requirement f (2) using the midyear discounting adjustment factor.
g. Compute Coca-Cola’s market-to-book ratio as of the end of 2012. Compare the value to book ratio to the market-to-book ratio. What investment decision does the comparison suggest? What does the comparison suggest regarding the pricing of Coca-Cola shares in the market: underpriced, overpriced, or fairly priced?
h. Use the value-to-book ratio to project the value of a share of common equity in Coca-Cola.
i. If you computed Coca-Cola’s common equity share value using the free cash flows to common equity valuation approach in Problem 12.16 in Chapter 12 and/or the residual income valuation approach in Problem 13.19 in Chapter 13, compare the value estimate you obtained in those problems with the estimate you obtained in this case. You should obtain the same value estimates under all three approaches. If you have not yet worked those problems, you would benefit from doing so now.
Data from Problem 12.16 in Chapter 12:


Part II—Analyzing Coca-Cola’s Share Price Using the Value-Earnings Ratio, Price-Earnings Ratio, Price Differentials, and Reverse Engineering
j. Use the forecast data for Year +1 to project Year +1 earnings per share. To do so, divide the projection of Coca-Cola’s comprehensive income available for common shareholders in Year +1 by the number of common shares outstanding at the end of 2012. Using this Year +1 earnings-per-share forecast and the share value computed in Requirement h, compute Coca-Cola’s value-earnings ratio.
k. Using the Year +1 earnings-per-share forecast from Requirement j and using the share price at the end of 2012, compute Coca-Cola’s price-earnings ratio. Compare Coca-Cola’s value-earnings ratio with its price-earnings ratio. What investment decision does the comparison suggest? What does the comparison suggest regarding the pricing of Coca-Cola shares in the market: underpriced, overpriced, or fairly priced? Does this comparison lead to the same conclusions you reached when comparing value-to-book ratios with market-to-book ratios in Requirement g?
l. Note: For this part only, assume Coca-Cola’s long-run growth beginning in Year +6 will be 1% rather than 3%. With a 1% growth rate, Year +6 comprehensive income will be $10,615 million. Compute Coca-Cola’s price differential at the end of 2012. Compute Coca-Cola’s price differential as a percentage of Coca-Cola’s risk-neutral value. What dollar amount and what percentage amount has the market discounted Coca-Cola shares for risk?
m. Reverse engineer Coca-Cola’s share price at the end of 2012 to solve for the implied expected rate of return. First, assume that value equals price and that the earnings and 3% long-run growth forecasts through Year þ6 and beyond are reliable proxies for the market’s expectations for Coca-Cola. Then solve for the implied expected rate of return (the discount rate) the market has impounded in Coca-Cola’s share price. (Hint: Begin with the forecast and valuation spreadsheet you developed to value Coca-Cola shares. Vary the discount rate until you solve for the discount rate that makes your value estimate exactly equal the end of 2012 market price of $35.48 per share.)
n. Reverse engineer Coca-Cola’s share price at the end of 2012 to solve for the implied expected long-run growth. First, assume that value equals price and that the earnings forecasts through Year +5 are reliable proxies for the market’s expectations for Coca-Cola. Also assume that the discount rate implied by the CAPM (computed in Requirement a) is a reliable proxy for the market’s expected rate of return. Then solve for the implied expected long-run growth rate the market has impounded in Coca-Cola’s share price.
(Hint: Begin with the forecast and valuation spreadsheet you developed to value Coca- Cola shares and use the CAPM discount rate. Set the long-run growth parameter initially to zero. Increase the long-run growth rate until you solve for the growth rate that makes your value estimate exactly equal the end of 2012 market price of $35.48 per share.)
REQUIRED Part I—Computing Coca-Cola’s Value-to-Book Ratio Using the Value-to-Book Valuation Approach a. Use the CAPM to compute the required rate of return on common equity capital for Coca-Cola. b. Using the projected financial statements in Exhibits 12.14–12.16, derive the projected residual ROCE (return on common shareholders’ equity) for Coca-Cola for Years +1 through +5. c. The projected income statements and balance sheets for Year +6 assume Coca-Cola will grow at a steady state growth rate of 3.0%. Derive the projected residual ROCE for Year +6 for Coca-Cola. d. Using the required rate of return on common equity from Requirement a as a discount rate, compute the sum of the present value of residual ROCE for Coca-Cola for Years +1 through þ5. e. Using the required rate of return on common equity from Requirement a as a discount rate and the long-run growth rate from Requirement c, compute the continuing value of Coca- Cola as of the start of Year +6 based on Coca-Cola’s continuing residual ROCE in Year +6 and beyond. After computing continuing value as of the start of Year +6, discount it to present value at the start of Year +1. f. Compute Coca-Cola’s value-to-book ratio as of the end of 2012 with the following three steps: (1) Compute the total sum of the present value of all future residual ROCE (from Requirements d and e). (2) To the total from Requirement f (1), add 1 (representing the book value of equity as of the beginning of the valuation as of the end of 2012). (3) Adjust the total sum from Requirement f (2) using the midyear discounting adjustment factor. g. Compute Coca-Cola’s market-to-book ratio as of the end of 2012. Compare the value to book ratio to the market-to-book ratio. What investment decision does the comparison suggest? What does the comparison suggest regarding the pricing of Coca-Cola shares in the market: underpriced, overpriced, or fairly priced? h. Use the value-to-book ratio to project the value of a share of common equity in Coca-Cola. i. If you computed Coca-Cola’s common equity share value using the free cash flows to common equity valuation approach in Problem 12.16 in Chapter 12 and/or the residual income valuation approach in Problem 13.19 in Chapter 13, compare the value estimate you obtained in those problems with the estimate you obtained in this case. You should obtain the same value estimates under all three approaches. If you have not yet worked those problems, you would benefit from doing so now. Data from Problem 12.16 in Chapter 12:
The Coca-Cola Company is a global soft-drink beverage company that is a primary and direct competitor with PepsiCo. The data in Chapter 12 Exhibits 12.14–12.16 include the actual amounts for 2012 and projected amounts for Year +1 to Year +6 for the income statements, balance sheets, and statements of cash flows for Coca-Cola.
The market equity beta for Coca-Cola at the end of 2012 is 0.75. Assume that the risk-free interest rate is 3.0% and the market risk premium is 6.0%. Coca-Cola has 4,469 million shares outstanding at the end of 2012, when Coca-Cola’s share price was $35.48.
Data from chapter 12:



REQUIRED
Part I—Computing Coca-Cola’s Value-to-Book Ratio Using the Value-to-Book Valuation Approach
a. Use the CAPM to compute the required rate of return on common equity capital for Coca-Cola.
b. Using the projected financial statements in Exhibits 12.14–12.16, derive the projected residual ROCE (return on common shareholders’ equity) for Coca-Cola for Years +1 through +5.
c. The projected income statements and balance sheets for Year +6 assume Coca-Cola will grow at a steady state growth rate of 3.0%. Derive the projected residual ROCE for Year +6 for Coca-Cola.
d. Using the required rate of return on common equity from Requirement a as a discount rate, compute the sum of the present value of residual ROCE for Coca-Cola for Years +1 through þ5.
e. Using the required rate of return on common equity from Requirement a as a discount rate and the long-run growth rate from Requirement c, compute the continuing value of Coca- Cola as of the start of Year +6 based on Coca-Cola’s continuing residual ROCE in Year +6 and beyond. After computing continuing value as of the start of Year +6, discount it to present value at the start of Year +1.
f. Compute Coca-Cola’s value-to-book ratio as of the end of 2012 with the following three steps:
(1) Compute the total sum of the present value of all future residual ROCE (from Requirements d and e).
(2) To the total from Requirement f (1), add 1 (representing the book value of equity as of the beginning of the valuation as of the end of 2012).
(3) Adjust the total sum from Requirement f (2) using the midyear discounting adjustment factor.
g. Compute Coca-Cola’s market-to-book ratio as of the end of 2012. Compare the value to book ratio to the market-to-book ratio. What investment decision does the comparison suggest? What does the comparison suggest regarding the pricing of Coca-Cola shares in the market: underpriced, overpriced, or fairly priced?
h. Use the value-to-book ratio to project the value of a share of common equity in Coca-Cola.
i. If you computed Coca-Cola’s common equity share value using the free cash flows to common equity valuation approach in Problem 12.16 in Chapter 12 and/or the residual income valuation approach in Problem 13.19 in Chapter 13, compare the value estimate you obtained in those problems with the estimate you obtained in this case. You should obtain the same value estimates under all three approaches. If you have not yet worked those problems, you would benefit from doing so now.
Data from Problem 12.16 in Chapter 12:


Part II—Analyzing Coca-Cola’s Share Price Using the Value-Earnings Ratio, Price-Earnings Ratio, Price Differentials, and Reverse Engineering
j. Use the forecast data for Year +1 to project Year +1 earnings per share. To do so, divide the projection of Coca-Cola’s comprehensive income available for common shareholders in Year +1 by the number of common shares outstanding at the end of 2012. Using this Year +1 earnings-per-share forecast and the share value computed in Requirement h, compute Coca-Cola’s value-earnings ratio.
k. Using the Year +1 earnings-per-share forecast from Requirement j and using the share price at the end of 2012, compute Coca-Cola’s price-earnings ratio. Compare Coca-Cola’s value-earnings ratio with its price-earnings ratio. What investment decision does the comparison suggest? What does the comparison suggest regarding the pricing of Coca-Cola shares in the market: underpriced, overpriced, or fairly priced? Does this comparison lead to the same conclusions you reached when comparing value-to-book ratios with market-to-book ratios in Requirement g?
l. Note: For this part only, assume Coca-Cola’s long-run growth beginning in Year +6 will be 1% rather than 3%. With a 1% growth rate, Year +6 comprehensive income will be $10,615 million. Compute Coca-Cola’s price differential at the end of 2012. Compute Coca-Cola’s price differential as a percentage of Coca-Cola’s risk-neutral value. What dollar amount and what percentage amount has the market discounted Coca-Cola shares for risk?
m. Reverse engineer Coca-Cola’s share price at the end of 2012 to solve for the implied expected rate of return. First, assume that value equals price and that the earnings and 3% long-run growth forecasts through Year þ6 and beyond are reliable proxies for the market’s expectations for Coca-Cola. Then solve for the implied expected rate of return (the discount rate) the market has impounded in Coca-Cola’s share price. (Hint: Begin with the forecast and valuation spreadsheet you developed to value Coca-Cola shares. Vary the discount rate until you solve for the discount rate that makes your value estimate exactly equal the end of 2012 market price of $35.48 per share.)
n. Reverse engineer Coca-Cola’s share price at the end of 2012 to solve for the implied expected long-run growth. First, assume that value equals price and that the earnings forecasts through Year +5 are reliable proxies for the market’s expectations for Coca-Cola. Also assume that the discount rate implied by the CAPM (computed in Requirement a) is a reliable proxy for the market’s expected rate of return. Then solve for the implied expected long-run growth rate the market has impounded in Coca-Cola’s share price.
(Hint: Begin with the forecast and valuation spreadsheet you developed to value Coca- Cola shares and use the CAPM discount rate. Set the long-run growth parameter initially to zero. Increase the long-run growth rate until you solve for the growth rate that makes your value estimate exactly equal the end of 2012 market price of $35.48 per share.)
Part II—Analyzing Coca-Cola’s Share Price Using the Value-Earnings Ratio, Price-Earnings Ratio, Price Differentials, and Reverse Engineering j. Use the forecast data for Year +1 to project Year +1 earnings per share. To do so, divide the projection of Coca-Cola’s comprehensive income available for common shareholders in Year +1 by the number of common shares outstanding at the end of 2012. Using this Year +1 earnings-per-share forecast and the share value computed in Requirement h, compute Coca-Cola’s value-earnings ratio. k. Using the Year +1 earnings-per-share forecast from Requirement j and using the share price at the end of 2012, compute Coca-Cola’s price-earnings ratio. Compare Coca-Cola’s value-earnings ratio with its price-earnings ratio. What investment decision does the comparison suggest? What does the comparison suggest regarding the pricing of Coca-Cola shares in the market: underpriced, overpriced, or fairly priced? Does this comparison lead to the same conclusions you reached when comparing value-to-book ratios with market-to-book ratios in Requirement g? l. Note: For this part only, assume Coca-Cola’s long-run growth beginning in Year +6 will be 1% rather than 3%. With a 1% growth rate, Year +6 comprehensive income will be $10,615 million. Compute Coca-Cola’s price differential at the end of 2012. Compute Coca-Cola’s price differential as a percentage of Coca-Cola’s risk-neutral value. What dollar amount and what percentage amount has the market discounted Coca-Cola shares for risk? m. Reverse engineer Coca-Cola’s share price at the end of 2012 to solve for the implied expected rate of return. First, assume that value equals price and that the earnings and 3% long-run growth forecasts through Year þ6 and beyond are reliable proxies for the market’s expectations for Coca-Cola. Then solve for the implied expected rate of return (the discount rate) the market has impounded in Coca-Cola’s share price. (Hint: Begin with the forecast and valuation spreadsheet you developed to value Coca-Cola shares. Vary the discount rate until you solve for the discount rate that makes your value estimate exactly equal the end of 2012 market price of $35.48 per share.) n. Reverse engineer Coca-Cola’s share price at the end of 2012 to solve for the implied expected long-run growth. First, assume that value equals price and that the earnings forecasts through Year +5 are reliable proxies for the market’s expectations for Coca-Cola. Also assume that the discount rate implied by the CAPM (computed in Requirement a) is a reliable proxy for the market’s expected rate of return. Then solve for the implied expected long-run growth rate the market has impounded in Coca-Cola’s share price. (Hint: Begin with the forecast and valuation spreadsheet you developed to value Coca- Cola shares and use the CAPM discount rate. Set the long-run growth parameter initially to zero. Increase the long-run growth rate until you solve for the growth rate that makes your value estimate exactly equal the end of 2012 market price of $35.48 per share.)





Transcribed Image Text:

Exhibit 12.14 The Coca-Cola Company Income Statements for 2010 through 2012 (Actual) and Year +1 through Year +6 (Projected) (amounts in millions allow for rounding) (Problem 12.16) Actuals Forecasts 2010 2011 2012 Year +1 Year +2 Year +3 Year +4 Year +5 Year +6 $ 35,119 $46,542 $ 63, 122 $ 48,017 (19,053) $ 28,964 $50,418 $ 52,939 21,175) $ 31,763 $ 55,586 $58,365 (22,234) (23,346) $ 35,019 $ 33,351 Revenues $61,283 (12,693) $ 22,426 (18,215) 28,327 Cost of goods sold (20,167) $ 30,251 (24,513) (25,249) Gross Profit $ 36,770 $ 37,873 Selling, general, and admin. expenses Other operating expenses Operating Profit (13,194) (17,422) (17,738) (18,655) (19,587) (20,567) (21,595) (22,675) (23,355) 819) $ 8413 (732) $ 10,173 (447) $ 10,779 (504) (529) (556) (584) $ 12,840 (613) $ 13,482 (631) $ 13,887 $ 11,092 $ 11,647 $ 12,229 Interest income 317 483 471 360 396 412 430 448 461 Interest expense 733) (417) (397) (978) (1,006) (1,065) (1,125) (1,188) (1,223) Income from equity affiliates Other income 1,025 5,185 $ 14,207 690 1,073 819 137 857 900 945 992 1,041 529 $ 11,330 $ 11,936 (2,745) $ 9,191 $ 13,137 (3,021) $ 10,115 Income before Tax $ 11,458 $ 11,809 $ 12,521 $ 13,784 $ 14,197 Income tax expense (2,370) (2,812) (2,723) (2,606) (2,880) 3,170) (3,265) Net Income $11,837 $ 8,646 $ 9,086 $ 8,724 $ 9,641 $ 10,613 $ 10,932 Net income attributable to noncontrolling interests (50) (62) (67) (57) (57) (57) (57) (57) (58) Net Income Attributable to Common Shareholders $11,787 $ 8,584 $ 9,019 $ 8,668 $ 9,134 $ 9,585 $ 10,058 $ 10,557 $ 10,873 Other comprehensive 771) $11,116 income items (1,265) (611) Comprehensive Income $ 7,319 $ 8408 $ 8,668 $ 9,134 $ 9,585 $10,058 $ 10,557 $ 10,873 Source for Actuals The Coca-Cola Company Form 10-Kfor the Fiscal Year Ended December 31, 2012 Exhibit 12.15 The Coca-Cola Company Balance Sheets for 2010 through 2012 (Actual) and Year +1 through Year +6 (Projected) (amounts in millions; allow for rounding) (Problem 12.16) Actuals Foreca sts 2010 2011 2012 Year +1 Year+2 Year +3 Year +4 Year +5 Year +6 ASSETS $ 8,517 $ 12,803 $ 8,442 $ 11,050 $ 11,603 $ 12,183 $ 12,792 $ 13,432 $ 13,835 8,603 Cash and cash equivalents Marketable securities 2,820 1,232 8,109 8,352 8,861 5,635 9,127 9,401 9,683 4,920 3,092 Accounts receivable (net) 4,430 4,759 5,111 5,366 5,916 6,212 6,399 Inventories 2,650 3,264 3,370 3,539 3,716 3,902 4,097 4,220 Prepaid expenses and other current assets 3,162 3,450 2,781 2,920 3,066 3,219 3,380 3,549 3,656 Assets held for sale 2,973 $ 21,579 $ 25,497 $ 30,328 $ 30,804 $ 32,177 $ 33,614 $ 35,118 $ 36,691 11,519 current assets $ 37,792 Long-term investments in affiliates Property, plant & equipment 7,585 8,374 10,448 10,970 12,095 12,700 13,335 13,735 21,706 23,151 23,486 26,486 29,636 32,944 36,416 40,063 41,265 (at cost) Accumulated deprediation (6,979) (8,212) (9,010) (10,945) (13,111) (15,518) (18,180) (21,107) (21,740) 1,250 12,219 14,200 Amortizable intangible assets (net) 1,377 1,150 1,050 950 850 750 650 670 Goodwill 11,665 12,255 12,868 13,511 14,187 16,128 4,150 14,896 15,641 16,110 14,629 3,764 $ 72,921 $79,974 $86,174 $ 89,626 $93,995 $98449 $102,992 $107,629 Other nonamortizable intangibles 13,867 13,932 3,585 15,360 16,934 17,781 18,315 Other noncurrent assets 2,121 З495 3,952 4,358 4,575 4,713 Total Assets $110,857 (Continued) Actuals Forecasts 2010 2011 2012 Year +1 Year +2 Year +3 Year +4 Year +5 Year +6 LIABILITIES $ 1,887 $ 2,172 $ 1,969 $ 2,222 $ 2,339 $ 2,456 $ 2,579 $ 2,708 $ 6,972 8,100 Accounts payable -trade 2,789 6,711 16,297 1,577 Current accrued liabilities 6,837 7,047 7,399 7,769 19,158 1,854 8,157 8,565 8,822 18,118 Notes payable and short-term debt Current maturities of long-term debt Income taxes payable Liabilities of segments held for sale Current Liabilities 12,871 17,113 1,656 20,233 1,958 21,347 21,987 1,276 2,041 362 1,753 2,066 2,128 554 273 471 448 470 492 515 538 796 $ 18,508 $ 24,283 $ 27,821 $ 28,485 $ 30,079 $ 31,729 $ 33,442 $ 35,223 14,041 4,261 36,280 Long-term debt Deferred tax liabilities-noncurrent 13,656 14,736 4,981 5 468 15,474 16,383 17,323 18,295 5,953 19,302 19,881 4,694 5,181 5,433 5,690 6,221 6,408 Other noncurrent liabilities 6,028 $41,604 $48,053 $ 53,006 $54,881 $57,923 $61,072 $ 64,337 $ 67,725 $ 69,757 4,794 5,420 5,741 6,330 6,646 6,979 7,188 Total Liabilities SHAREHOLDERS' EQUITY Common stock + paid-in capital Retained earnings Accum. other comprehensive income (loss) $ 10,937 $ 12,092 $ 13,139 $ 13,665 $ 14,331 $ 15,011 $ 15,703 $ 16,410 $ 16,902 66,917 49,278 53,621 58,045 62,369 71,688 76,695 81,950 84,409 (1,450) (2,774) (3,385) (3,385) (3,385) (3,385) 3,385) (3,385) (3,385) Treasury stock Common Shareholders' equity $ 31,003 $ 31,635 $ 32,790 $ 34,367 $ 35,693 $ 36,999 $ 38,277 $ 39,525 $ 40,711 (27,762) 31,304) (35,009) (38,283) (42,170) (46,315) (50,737) (55,450) (57,215) Noncontrolling interests Total equity 314 286 378 378 378 378 378 378 389 $31,317 $31,921 $33,168 $34,745 $36,071 $37,377 $ 38,655 $72,921 $79,974 $ 86,174 $ 89,626 $ 93,995 $ 98,449 $102,992 $107,629 $ 39,903 $ 41,100 $110,857 Total Liabilities and Equities Souce for Actuais: The Coca-Cola Company, Fom 10-K for the Fkal Year Ended December 31, 2012. Exhibit 12.16 The Coca-Cola Company Projected Implied Statements of Cash Flows for Year +1 through Year +6 (amounts in millions; allow for rounding) (Problem 12.16) Forecasts Year +1 Year +2 Year +3 Year +4 Year +5 Year +6 IMPLIED STATEMENT OF CASH FLOWS $ 9,600 $ 9,151 2,166 (256) (169) (146) $10,567 $ 8,705 1,935 (352) (106) (139) 253 336 (23) $10,071 $10,884 633 (186) (123) (106) Net Income Add back depredation expense (net) (Increase) Dearease in receivables (net) (Increase) Decrease in inventories (Increase) Decrease in prepaid expenses Increase (Decrease) in accounts payable-trade Increase (Decrease) in current accrued liabilities Increase (Decrease) in income taxes payable Net change in deferred tax assets and liabilities Increase (Decrease) in other noncurrent liabilities Cash flows from assets/liabilities of segment sold Net Cash Flows from Operations 2,407 (268) (177) (153) 2,661 (282) (1 86) (161) 123 388 23 2,928 (296) (195) (169) 129 408 117 117 81 352 370 257 16 187 209 22 22 23 200 253 257 263 268 273 287 301 316 332 2,177 $13,259 $12,476 $13,217 $11,778 $13,995 $11,852 (Increase) Decrease in prop, plant, & equip, at cost (Increase) Decrease in marketable securities (Increase) Decrease in investment securities (Increase) Decrease in amortizable intangible assets (net) (Increase) Decrease in goodwill and nonamort. intang. (Increase) Decrease in other non-current assets Net Cash Flows from Investing (3,000) (243) (522) 100 (1,309) (179) (3,150) (251) (549) 100 (1,375) (1,202) (282) (400) (20) (1,003) (137) 3 (3,043) (3,308) (258) (576) (3,473) (266) (605) 3,647) (274) (635) 100 (1,592) (218) $(6,265) 100 100 (188) 3 (5412) (1,444) (198) 3 (5,683) (1,516) (208) $ (5,967) 3(5,154) 1,103 909 666 1,140 940 679 Increase (Decrease) in short-term debt 895 738 526 1,180 1,221 1,007 702 Increase (Decrease) in long-term debt Increase (Decrease) in common stock + paid-in capital Increase (Decrease) in accum. OCl and other equity adjs. Increase (Decrease) in treasury stock 973 579 693 707 492 (3,274) (3,887) (4,547) (57) (4,145) (4,77 1) (57) (4,422) (5,007) (57) (4,713) (5,255) (57) (1,765) (8,367) (47) Dividends (4,324) (57) $(5,496) $ 2,608 Dividends to noncontrolling interests Net Cash Flows from Financing $ (5,813) $ 553 $ (6,214) $ 580 $ (6,641) 609 $ (7,091) $ 640 $ (8405) 403 Net Change in Cash Exhibit 12.16 The Coca-Cola Company Projected Implied Statements of Cash Flows for Year +1 through Year +6 (amounts in millions; allow for rounding) (Problem 12.16) Forecasts Year +1 Year +2 Year +3 Year +4 Year +5 Year +6 IMPLIED STATEMENT OF CASH FLOWS $ 9,600 $ 9,151 2,166 (256) (169) (146) $10,567 $ 8,705 1,935 (352) (106) (139) 253 336 (23) $10,071 $10,884 633 (186) (123) (106) Net Income Add back depredation expense (net) (Increase) Dearease in receivables (net) (Increase) Decrease in inventories (Increase) Decrease in prepaid expenses Increase (Decrease) in accounts payable-trade Increase (Decrease) in current accrued liabilities Increase (Decrease) in income taxes payable Net change in deferred tax assets and liabilities Increase (Decrease) in other noncurrent liabilities Cash flows from assets/liabilities of segment sold Net Cash Flows from Operations 2,407 (268) (177) (153) 2,661 (282) (1 86) (161) 123 388 23 2,928 (296) (195) (169) 129 408 117 117 81 352 370 257 16 187 209 22 22 23 200 253 257 263 268 273 287 301 316 332 2,177 $13,259 $12,476 $13,217 $11,778 $13,995 $11,852 (Increase) Decrease in prop, plant, & equip, at cost (Increase) Decrease in marketable securities (Increase) Decrease in investment securities (Increase) Decrease in amortizable intangible assets (net) (Increase) Decrease in goodwill and nonamort. intang. (Increase) Decrease in other non-current assets Net Cash Flows from Investing (3,000) (243) (522) 100 (1,309) (179) (3,150) (251) (549) 100 (1,375) (1,202) (282) (400) (20) (1,003) (137) 3 (3,043) (3,308) (258) (576) (3,473) (266) (605) 3,647) (274) (635) 100 (1,592) (218) $(6,265) 100 100 (188) 3 (5412) (1,444) (198) 3 (5,683) (1,516) (208) $ (5,967) 3(5,154) 1,103 909 666 1,140 940 679 Increase (Decrease) in short-term debt 895 738 526 1,180 1,221 1,007 702 Increase (Decrease) in long-term debt Increase (Decrease) in common stock + paid-in capital Increase (Decrease) in accum. OCl and other equity adjs. Increase (Decrease) in treasury stock 973 579 693 707 492 (3,274) (3,887) (4,547) (57) (4,145) (4,77 1) (57) (4,422) (5,007) (57) (4,713) (5,255) (57) (1,765) (8,367) (47) Dividends (4,324) (57) $(5,496) $ 2,608 Dividends to noncontrolling interests Net Cash Flows from Financing $ (5,813) $ 553 $ (6,214) $ 580 $ (6,641) 609 $ (7,091) $ 640 $ (8405) 403 Net Change in Cash


> During the year, Ricardo made the following contributions to a qualified public charity: Cash……………………………………………………………………………………$220,000 Stock in Seagull, Inc. (a publicly traded corporation)………………280,000 Ricardo acquired the stock in Seagull, Inc., as an

> Joan is a self-employed consultant. What is her exposure to the Federal selfemployment tax? Discuss the tax rates that apply to Joan’s profits and the income base amounts for the year.

> A friend tells you that she does not worry about the AMT because she does not itemize deductions and, as a result, she does not generate many AMT adjustments. Evaluate your friend’s assertion.

> Wesley, who is single, listed his personal residence with a real estate agent on March 3, 2017, at a price of $390,000. He rejected several offers in the $350,000 range during the summer. Finally, on August 16, 2017, he and the purchaser signed a contrac

> Matt, who is single, always has elected to itemize deductions rather than take the standard deduction. In prior years, his itemized deductions always exceeded the standard deduction by a substantial amount. As a result of paying off the mortgage on his r

> Celine will be subject to the AMT in 2017. She owns an investment building and is considering disposing of it and investing in other realty. Based on an appraisal of the building’s value, the realized gain would be $85,000. Ed has offered to purchase the

> In 1998, Douglas purchased an office building for $500,000 to be used in a business. Douglas sells the building in the current tax year. Explain why the recognized gain or loss for regular income tax purposes is different from any recognized gain or loss

> Howard’s roadside vegetable stand (adjusted basis of $275,000) is destroyed by a tractor-trailer accident. He receives insurance proceeds of $240,000 ($300,000 fair market value $60,000 coinsurance). Howard immediately uses the proceeds plus additional c

> Evaluate the validity of the following statements: If the stock received under an incentive stock option (ISO) is sold in the year of exercise, there is no AMT adjustment. If the stock is sold in a later year, there will be an AMT adjustment then.

> Evaluate the validity of the following statement: In a year in which depreciable personal property is sold, the amount of the AMT gain adjustment equals the amount of the current year’s AMT depreciation adjustment.

> Alfred is single, and his AMTI of $350,000 consists of the following. What tax rates are applicable in calculating Alfred’s TMT? Ordinary income………………..$250,000 Long-term capital gains…………70,000 Qualified dividends……………….30,000

> Andrew and Monica, unrelated individuals, use the same Federal income tax filing status (head of household). However, Monica’s AMT exemption amount is $52,800, while Andrew’s is $0. Explain.

> An AMT liability results if the tentative minimum tax (TMT) exceeds the regular income tax liability. But what happens if the regular income tax liability exceeds the TMT? Does this create a negative AMT that can be carried to other years? Explain.

> How might a taxpayer who cannot avoid engaging in activities that generate AMT adjustments minimize or eliminate such adjustments?

> Mark and Lisa are approaching an exciting time in their lives as their oldest son, Austin, graduates from high school and moves on to college. What are some of the tax issues that Mark and Lisa should consider as they think about paying for Austin’s coll

> Karl purchased his residence on January 2, 2016, for $260,000, after having lived in it during 2015 as a tenant under a lease with an option to buy clause. On August 1, 2017, Karl sells the residence for $315,000. On June 13, 2017, Karl purchases a new r

> Auralia owns stock in Orange Corporation and Blue Corporation. She receives a $10,000 distribution from both corporations. The instructions from Orange state that the $10,000 is a dividend. The instructions from Blue state that the $10,000 is not a divid

> Liz had AGI of $130,000 in 2017. She donated Bluebird Corporation stock with a basis of $10,000 to a qualified charitable organization on July 5, 2017. a. What is the amount of Liz’s deduction assuming that she purchased the stock on December 3, 2016, an

> A depreciable business dump truck has been owned for four years and is no longer useful to the taxpayer. What would have to be true for the disposition of the dump truck to generate at least some § 1231 loss?

> Jacob, age 42, and Jane Brewster, age 37, are married and file a joint return in 2017. The Brewsters have two dependent children, Ellen and Sean, 10-year-old twins. Jacob is a factory supervisor; he earned $95,000 in 2017. Jane is a computer systems anal

> Robert A. Kliesh, age 41, is single and has no dependents. Robert’s Social Security number is 111-11-1112. His address is 201 Front Street, Missoula, MT 59812. He does not contribute to the Presidential Election Campaign fund through the Form 1040. Rober

> This year, Brennen sold a machine used in his business for $180,000. The machine was put into service eight years ago for $340,000. Depreciation up to the date of the sale for regular income tax purposes was $210,000; it was $190,000 for AMT purposes. Wh

> In March 2017, Serengeti exercised an ISO that had been granted by his employer, Thunder Corporation, in December 2014. Serengeti acquired 5,000 shares of Thunder stock with a strike price of $65 per share. The fair market value of the stock at the date

> Compute the 2017 AMT exemption for the following taxpayers. a. Bristol, who is single, reports AMTI of $149,500. b. Marley and Naila are married and file a joint tax return. Their AMTI is $498,000.

> Elijah, who is single, holds a $12,000 AMT credit available from year 1. For year 2, Elijah’s regular tax liability is $28,000, and his TMT is $24,000. Does Elijah owe any AMT for year 2? If so, how much (if any) of the AMT credit can he use for that yea

> Yanni, a single individual, reports the following information for the tax year. Salary……………………………………….$80,000 State income taxes…………………...…..6,800 Mortgage interest expense…………….6,200 Charitable contributions…………………1,500 Interest income……………………………..1,30

> Dimitri owns a gold mine that qualifies for a 15% percentage depletion rate. The basis of the property at the beginning of the year, prior to any current year depletion deduction, is $21,000. Gross income from the property for the year is $200,000; taxab

> Kiki, who incurred intangible drilling costs (IDC) of $94,000 during the year, deducted that amount for regular tax purposes. Her net oil and gas income for the year was $110,000. Kiki has calculated her current-year IDC preference to be $9,400. Is this

> Wanda, a calendar year taxpayer, owned a building (adjusted basis of $250,000) in which she operated a bakery that was destroyed by fire in December 2017. She receives insurance proceeds of $290,000 for the building the following March. Wanda is consider

> An individual taxpayer had a net § 1231 loss in 2017. Could any of this loss be treated as a long-term capital loss? Why or why not?

> Shontelle owns an apartment house that has an adjusted basis of $760,000 but is subject to a mortgage of $192,000. She transfers the apartment house to Dave and receives from him $120,000 in cash and an office building with a fair market value of $780,00

> Jorge owns two passive investments, Activity A and Activity B. He plans to sell Activity A in the current year or next year. Juanita has offered to buy Activity A this year for an amount that would produce a taxable passive activity gain to Jorge of $115

> In the current year, Bill Parker (54 Oak Drive, St. Paul, MN 55164) is considering making an investment of $60,000 in Best Choice Partnership. The prospectus provided by Bill’s broker indicates that the partnership investment is not a passive activity an

> In 2016, Fred invested $50,000 in a general partnership. Fred’s interest is not considered to be a passive activity. If his share of the partnership losses is $35,000 in 2016 and $25,000 in 2017, how much can he deduct in each year?

> Helen Derby borrowed $150,000 to acquire a parcel of land to be held for investment purposes. During the current year, she reported AGI of $90,000 and paid interest of $12,000 on the loan. Other items related to Helen’s investments include the following:

> In 2017, Kathleen Tweardy incurs $30,000 of interest expense related to her investments. Her investment income includes $7,500 of interest, $6,000 of qualified dividends, and a $12,000 net capital gain on the sale of securities. Kathleen asks you to comp

> Tonya sells a passive activity in the current year for $150,000. Her adjusted basis in the activity is $50,000, and she uses the installment method of reporting the gain. The activity has suspended losses of $12,000. Tonya receives $60,000 in the year of

> Commercial Bank has initiated an advertising campaign that encourages customers to take out home equity loans to pay for purchases of automobiles. Are there any tax advantages related to this type of borrowing? Explain.

> Dan, a self-employed individual taxpayer, prepared his own income tax return for the past year and has asked you to check it for accuracy. Your review indicates that Dan failed to claim certain business entertainment expenses. a. Will the correction of t

> Explain why market-to-book valuation multiples demonstrate less variance over time and across firms than do price-earnings valuation multiples.

> Identify three economic factors that will drive a firm’s price-earnings ratio to decrease over time. Identify three accounting factors that will drive a firm’s price-earnings ratio down in a given period.

> Identify three economic factors that will drive a firm’s price-earnings ratio to be higher than that of other firms in the same industry. Identify three accounting factors that will drive a firm’s price-earnings ratio in a given period to be higher than

> In practice, it is common to observe price-earnings ratios measured as current period price divided by trailing-twelve-months (or most recent annual) earnings per share. Identify and explain three potential flaws inherent in this measurement of the price

> In conceptual terms, explain the value-earnings ratio. Explain the difference between the value-earnings ratio and the price-earnings ratio. What is the critical assumption about future earnings in both the value-earnings and price-earnings ratio?

> Identify three economic factors that will drive a firm’s value-to-book ratio to decrease over time. Identify three accounting factors that will drive a firm’s value-to-book ratio to decrease over time.

> Identify three economic factors that will drive a firm’s value-to-book ratio to be higher than that of other firms in the same industry. Identify three accounting factors that will drive a firm’s value-to-book ratio to be higher than that of other firms

> We projected financial statements for Walmart Stores for Years þ1 through +5. The data in Chapter 12 Exhibits 12.17–12.19 include the actual amounts for 2012 and the projected amounts for Year +1 to Year +5 for the income

> In this chapter, we evaluated shares of common equity in PepsiCo using the value-to-book approach, market multiples, price differentials, and reverse engineering. The Coca-Cola Company competes directly with PepsiCo. The data in Chapter 12 Exhibits 12.14

> Explain the implications of a value to-book ratio that is greater than the market-to-book ratio. Explain the implications of a value to-book ratio that is less than the market-to-book ratio.

> In 2000, Enron enjoyed remarkable success in the capital markets. During that year, Enron’s shares increased in value by 89%, while the S&P 500 index fell by 9%. At the end of 2000, Enron’s shares were trading at roughly $83 per share and all of the sell

> This problem explores the sensitivity of the value-earnings and value-to-book models to changes in underlying assumptions. We recommend that you design a computer spreadsheet to perform the calculations, particularly for the value-to-book ratio. REQUIRE

> Exhibit 14.12 presents data on market-to-book ratios, ROCE, the cost of equity capital, and price-earnings ratios for seven pharmaceutical companies. (Note that price-earnings ratios for these firms typically fall in the 30–35 range.) E

> Problem 13.18 and Exhibit 13.7 in Chapter 13 present selected hypothetical data from projected financial statements for Steak ‘n Shake for Year +1 to Year +11. The amounts for Year +11 reflect a long-term growth assumption of 3%. The co

> Using the evidence presented in Exhibit 14.10, describe the extent to which the market is efficient with respect to quarterly earnings surprises during the 60 trading days prior to quarterly earnings announcements. Using the evidence presented in Exhibit

> Explain the role of analysts in increasing capital market efficiency.

> What does market efficiency mean? What does market efficiency not mean? Explain how market efficiency relates to the amount of information that affects share prices and the speed with which information affects share prices.

> Explain reverse engineering of share prices in conceptual terms. How does reverse engineering of share prices enable an analyst to infer (or deduce) the assumptions that the capital markets appear to impound in share price?

> What does a price differential measure? How does a price differential relate to risk?

> In Integrative Case 10.1, we projected financial statements for Starbucks for Years +1 through +5. In this portion of the Starbucks Integrative Case, we use the projected financial statements from Integrative Case 10.1 and apply the techniques in Chapter

> Each column presents financial information taken from one of four different companies, with one or more items of data missing. Required: Use your understanding of the relationships among financial statements and financial statement items to find the mi

> Parker Renovation Inc. renovates historical buildings for commercial use. During 2019, Parker had $763,400 of revenue from renovation services and $5,475 of interest income from miscellaneous investments. Parker incurred $222,900 of wages expense, $135,0

> Information for TTL Inc. is given below. Required: Use the relationships in the balance sheet, income statement, and retained earnings statement to determine the missing values. Total assets at the beginning of the year S (a) Total assets at the en

> At the beginning of 2019, Huffer Corporation had total assets of $232,400, total liabilities of $94,200, common stock of $50,000, and retained earnings of $88,200. During 2019, Huffer had net income of $51,750, paid dividends of $10,000, and issued addit

> Carson Corporation reported the following amounts for assets and liabilities at the beginning and end of a recent year. Required: Calculate Carson’s net income or net loss for the year in each of the following independent situations: 1.

> Data from the financial statements of four different companies are presented in separate columns in the table below. Each column has one or more data items missing. Required: Use your understanding of the relationships among the financial statement item

> The following information relates to Ashton Appliances for 2019. Accounts payable $ 16,800 Income taxes expense $ 16,650 Accounts receivable 69,900 Income taxes payable 12,000 Accumulated depreciation (building) 104,800 Insurance expense 36,

> The table below presents the retained earnings statements for Bass Corporation for 3 successive years. Certain numbers are missing. Required: Use your understanding of the relationship between successive retained earnings statements to calculate the miss

> Dittman Expositions has the following data available: Dividends, 2019 $ 10,250 Retained earnings, 12/31/2018 $ 20,900 Dividends, 2020 12,920 Revenues, 2019 407,500 Expenses, 2019 382,100 Revenues, 2020 451,600 Expenses, 2020 418,600 Required

> The following information for Rogers Enterprises is available at December 31, 2019, and includes all of Rogers’ financial statement amounts except retained earnings: Accounts receivable $72,920 Property, plant, and equipment $ 90,000 Cash 13,240

> What types of questions are answered by the financial statements?

> Each column presents financial information taken from one of four different companies, with one or more items of data missing. Required: Use your understanding of the relationships among financial statements and financial statement items to determine t

> Powers Wrecking Service demolishes old buildings and other structures and sells the salvaged materials. During 2019, Powers had $425,000 of revenue from demolition services and $137,000 of revenue from salvage sales. Powers also had $1,575 of interest in

> Information for Beethoven Music Company is given below. Total assets at the beginning of Equity at the beginning of the year $ (b) the year $145,200 Equity at the end of the year 104,100 Total assets at the end of the year (a) Divid

> Which of the following statements is true? a. The auditor’s opinion is typically included in the notes to the financial statements. b. The notes to the financial statements are an integral part of the financial statements that clarify and expand on the i

> Which of the following sentences regarding the statement of cash flows is false? a. The statement of cash flows describes the company’s cash receipts and cash payments for a period of time. b. The statement of cash flows reconciles the beginning and endi

> Which of the following statements concerning retained earnings is true? a. Retained earnings is the difference between revenues and expenses. b. Retained earnings is increased by dividends and decreased by net income. c. Retained earnings represents accu

> For the most recent year, Grant Company reported revenues of $182,300, cost of goods sold of $108,800, inventory of $8,500, salaries expense of $48,600, rent expense of $12,000, and cash of $12,300. What was Grant’s net income? a. $9,400 b. $12,900 c. $2

> Which of the following statements regarding the income statement is true? a. The income statement provides information about the profitability and growth of a company. b. The income statement shows the results of a company’s operations at a specific poin

> Refer to the information for Marker above. What is Marker’s stockholders’ equity? a. $7,500 b. $17,500 c. $19,100 d. $25,000

> Refer to the information for Marker above. What is the total of Marker’s current assets? a. $12,100 b. $13,700 c. $14,500 d. $25,000

> Name and briefly describe the purpose of the four financial statements.

> Which of the following is not shown in the heading of a financial statement? a. The title of the financial statement b. The name of the company c. The time period covered by the financial statement d. The name of the auditor

> What type of questions do the financial statements help to answer? a. Is the company better off at the end of the year than at the beginning of the year? b. What resources does the company have? c. For what did a company use its cash during the year? d.

> Which of the following is not one of the four basic financial statements? a. Balance sheet b. Income statement c. Statement of cash d. Auditor’s report

> At December 31, Pitt Inc. has assets of $12,900 and liabilities of $6,300. What is the stockholders’ equity for Pitt at December 31? a. $6,600 b. $6,300 c. $18,100 d. $19,200

> Cam and Anna met during their freshman year of college as they were standing in line to buy tickets to a concert. While waiting in line, the two shared various aspects of their lives. Cam, whose father was an executive at a major record label, was raised

> Refer to the 10-K reports of Under Armour, Inc., and Columbia Sportswear that are available for download from the companion website at CengageBrain.com. Required: Answer the following questions: 1. Describe each company’s business and list some of the m

> Obtain Apple Inc.’s 2016 annual report either through the ‘‘Investor Relations’’ portion of their website (do a web search for Apple investor relations) or go to www.sec.gov and click ‘‘Company Filings Search’’ under ‘‘Filings.’’ Required: Answer the fo

> Lola, the CEO of JB Inc., and Frank, the accountant for JB Inc., were recently having a meeting to discuss the upcoming release of the company’s financial statements. Following is an excerpt of their conversation: Lola: These financial statements don’t s

> Professional ethics guide public accountants in their work with financial statements. Required: Why is ethical behavior by public accountants important to society? Be sure to describe the incentives that public accountants have to behave ethically and u

> Reproduced below are portions of the president’s letter to stockholders and selected income statement and balance sheet data for the Wright Brothers Aviation Company. Wright Brothers is a national airline that provides both passenger se

> Define the terms revenue and expense. How are these terms related?

> Agency Rent-A-Car Inc. rents cars to customers whose vehicles are unavailable due to accident, theft, or repair (‘‘Wheels while your car heals’’). The company has a fleet of more tha

> Which of the following statements regarding business activities is true? a. Operating activities involve buying the long-term assets that enable a company to generate revenue. b. Financing activities include obtaining the funds necessary to begin and ope

> The accounting profession is organized into three major groups: (a) Accountants who work in nonbusiness entities, (b) Accountants who work in business entities, and (c) Accountants in public practice. The periodical literature of accounting includes

> Jim Hadden is a freshman at Major State University. His earnings from a summer job, combined with a small scholarship and a fixed amount per term from his parents, are his only sources of income. He has a new MasterCard that was issued to him the week he

> Which of the following statements is false concerning forms of business organization? a. A corporation has tax advantages over the other forms of business organization. b. It is easier for a corporation to raise large sums of money than it is for a sole

> Decision-makers use accounting information in a wide variety of decisions including the following: 1. Deciding whether or not to lend money to a business 2. Deciding whether or not an individual has paid enough in taxes 3. Deciding whether or not to plac

> Bill and Steve recently formed a company that manufactures and sells high-end kitchen appliances. The following is a list of activities that occurred during the year. a. Bill and Steve each contributed cash in exchange for common stock in the company. b.

> Listed below are various activities that companies engage in during a period. a. Purchase of equipment b. Payment of a dividend c. Purchase of supplies d. Sale of equipment e. Sale of goods or services f. Borrow money from a bank g. Contribution of cash

4.99

See Answer