Concept explainers
EXCEL CASE 1
On January 1, 2018, Acme Co. is considering purchasing a 40 percent ownership interest in PHC Co., a privately held enterprise, for $700,000. PHC predicts its profit will be $185,000 in 2018, projects a 10 percent annual increase in profits in each of the next four years, and expects to pay a steady annual dividend of $30,000 for the foreseeable future. Because PHC has on its books a patent that is undervalued by $375,000, Acme realizes that it will have an additional amortization expense of $15,000 per year over the next 10 years—the patent’s estimated remaining useful life. All of PHC’s other assets and liabilities have book values that approximate market values. Acme uses the equity method for its investment in PHC.
Required
- 1. Using an Excel spreadsheet, set the following values in cells:
- Acme’s cost of investment in PHC.
- Percentage acquired.
- First-year PHC reported income.
- Projected growth rate in income.
- PHC annual dividends.
- Annual excess patent amortization.
- 2. Referring to the values in (1), prepare the following schedules using columns for the years 2018 through 2022.
- Acme’s equity in PHC earnings with rows showing these:
- Acme’s share of PHC reported income.
- Amortization expense.
- Acme’s equity in PHC earnings.
- Acme’s Investment in PHC balance with rows showing the following:
- Beginning balance.
- Equity earnings.
- Dividends.
- Ending balance.
- Return on beginning investment balance = Equity earnings/Beginning investment balance in each year.
- Acme’s equity in PHC earnings with rows showing these:
- 3. Given the preceding values, compute the average of the projected returns on beginning investment balances for the first five years of Acme’s investment in PHC. What is the maximum Acme can pay for PHC if it wishes to earn at least a 10 percent average return on beginning investment balance? (Hint: Under Excel’s Data tab, select What-If Analysis, and the Goal Seek capability to produce a 10 percent average return on beginning investment balance by changing the cell that contains Acme’s cost of investment in PHC. Excel’s Solver should produce an exact answer while Goal Seek should produce a close approximation. You may need to first add in the Solver capability under Excel’s Tools menu.)
1.
Using an Excel spreadsheet, set the following values in cells:
- Acme’s cost of investment in PHC.
- Percentage acquired.
- First-year PHC reported income.
- Projected growth rate in income.
- PHC annual dividends.
- Annual excess patent amortization.
Explanation of Solution
The required values are presented in excel sheet as follows:
Growth rate in income | 10% | ||||
Dividends | 30000 | ||||
Cost | 700000 | ||||
Annual amortization | $ 15,000 | ||||
1st year PHC income | $ 185,000 | ||||
Percentage owned | 40% | ||||
2018 | 2019 | 2020 | 2021 | 2022 | |
PHC reported income | $ 74,000 | $ 81,400 | $ 89,540 | $ 98,494 | $ 108,343 |
Amortization | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 |
Equity earnings | $ 59,000 | $ 66,400 | $ 74,540 | $ 83,494 | $ 93,343 |
Beginning balance | $ 700,000 | $ 747,000 | $ 801,400 | $ 863,940 | $ 935,434 |
Equity earnings | $ 59,000 | $ 66,400 | $ 74,540 | $ 83,494 | $ 93,343 |
Dividends | $ (12,000) | $ (12,000) | $ (12,000) | $ (12,000) | $ (12,000) |
Ending balance | $ 747,000 | $ 801,400 | $ 863,940 | $ 935,434 | $ 1,016,777 |
ROI | 8.43% | 8.89% | 9.30% | 9.66% | 9.98% |
Average | 9.25% |
2.
Referring to the values in (1), prepare the following schedules using columns for the years 2018 through 2022.
Acme’s equity in PHC earnings with rows showing these:
- Acme’s share of PHC reported income.
- Amortization expense.
- Acme’s equity in PHC earnings.
Acme’s Investment in PHC balance with rows showing the following:
- Beginning balance.
- Equity earnings.
- Dividends.
- Ending balance.
Explanation of Solution
Growth rate in income | 10% | ||||
Dividends | 30000 | ||||
Cost | 700000 | ||||
Annual amortization | $ 15,000 | ||||
1st year PHC income | $ 185,000 | ||||
Percentage owned | 40% | ||||
2018 | 2019 | 2020 | 2021 | 2022 | |
PHC reported income | $ 74,000 | $ 81,400 | $ 89,540 | $ 98,494 | $ 108,343 |
Amortization | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 |
Equity earnings | $ 59,000 | $ 66,400 | $ 74,540 | $ 83,494 | $ 93,343 |
Beginning balance | $ 700,000 | $ 747,000 | $ 801,400 | $ 863,940 | $ 935,434 |
Equity earnings | $ 59,000 | $ 66,400 | $ 74,540 | $ 83,494 | $ 93,343 |
Dividends | $ (12,000) | $ (12,000) | $ (12,000) | $ (12,000) | $ (12,000) |
Ending balance | $ 747,000 | $ 801,400 | $ 863,940 | $ 935,434 | $ 1,016,777 |
ROI | 8.43% | 8.89% | 9.30% | 9.66% | 9.98% |
Average | 9.25% |
3.
Compute the average of the projected returns on beginning investment balances for the first five years of Acme’s investment in PHC. Find the maximum amount which Acme can pay for PHC if it wishes to earn at least a 10 percent average return on beginning investment balance.
Explanation of Solution
The average of the projected returns on beginning investment balances for the first five years of Acme’s investment in PHC is as follows:
Growth rate in income | 10% | ||||
Dividends | 30000 | ||||
Cost | 639794 | ||||
Annual amortization | $ 15,000 | ||||
1st year PHC income | $ 185,000 | ||||
Percentage owned | 40% | ||||
2018 | 2019 | 2020 | 2021 | 2022 | |
PHC reported income | $ 74,000 | $ 81,400 | $ 89,540 | $ 98,494 | $ 108,343 |
Amortization | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 | $ 15,000 |
Equity earnings | $ 59,000 | $ 66,400 | $ 74,540 | $ 83,494 | $ 93,343 |
Beginning balance | $ 639,794 | $ 686,794 | $ 741,194 | $ 803,734 | $ 875,228 |
Equity earnings | $ 59,000 | $ 66,400 | $ 74,540 | $ 83,494 | $ 93,343 |
Dividends | $ (12,000) | $ (12,000) | $ (12,000) | $ (12,000) | $ (12,000) |
Ending balance | $ 686,794 | $ 741,194 | $ 803,734 | $ 875,228 | $ 956,571 |
ROI | 9.22% | 9.67% | 10.06% | 10.39% | 10.67% |
Average | 10.00% |
Want to see more full solutions like this?
Chapter 1 Solutions
Soft Bound Version for Advanced Accounting 13th Edition
- DIVIDENDS Brooks Sporting Inc. is prepared to report the following 2019 income statement (shown in thousands of dollars). Prior to reporting this income statement, the company wants to determine its annual dividend. The company has 320,000 shares of common stock outstanding, and its stock trades at 37 per share. a. The company had a 25% dividend payout ratio in 2018. If Brooks wants to maintain this payout ratio in 2019, what will be its per-share dividend in 2019? b. If the company maintains this 25% payout ratio, what will be the current dividend yield on the companys stock? c. The company reported net income of 1.35 million in 2018. Assume that the number of shares outstanding has remained constant. What was the companys per-share dividend in 2018? d. As an alternative to maintaining the same dividend payout ratio. Brooks is considering maintaining the same per-share dividend in 2019 that it paid in 2018. If it chooses this policy, what will be the companys dividend payout ratio in 2019? e. Assume that the company is interested in dramatically expanding its operations and that this expansion will require significant amounts of capital. The company would like to avoid transactions costs involved in issuing new equity. Given this scenario, would it make more sense for the company to maintain a constant dividend payout ratio or to maintain the same per-share dividend? Explain.arrow_forwardPayout-B Early in the year, EasyCo repurchased $25 mill. worth of its common shares to use for employee incentive plan awards. Easy also late in the year issued $75 mill. of new common shares into the market. EasyCo reported Dividends paid to shareholders of $100 million for 2020. What was Easy’s Net Payout to Shareholders for 2020?arrow_forwardProblem 3-12 On January 1, 2019, an entity granted to a senior executive 20,000 share options, conditional upon the executive’s remaining in the entity’s employ until December 31, 2021. The par value per share is P50. The exercise price is P100. However, the exercise drops to P80 if the entity’s earnings increase by at least an average of 10% per year over the three-year period. On grant date, the entity estimates that the fair value of the share option is P30 if the exercise price is P80. If the exercise price is P100, the fair value of the share option is P25. During 2019 and 2020, the earnings increased by 12% and 11% respectively. However, during 2021, the earnings increased only by 4%. Required: A. Prepare journal entries from 2019 to 2021arrow_forward
- Firm Valuation Through Excess Returns ApproachThe incorporation of XYZ Inc. was completed through the raising of funds. These funds include net proceeds from debt and from equity at P5,000,000 and P20,000,000 respectively. The after-tax costs of debt and of equity are 9% and 15% in order. If the actual return of XYZ is forecasted to be 17% annually over the firm’s 10-year life, compute the firm value.arrow_forwardKnowledge Check 01 On January 1, Year 1, Sterling Corporation issued stock options for 260,000 shares to its CEO. The options have an estimated fair value of $6 each. To provide additional incentive, the options are not exercisable unless revenue increases by 4% in three years. Sterling initially estimates that it is probable the goal will be achieved. What is compensation expense for Year 1?arrow_forwardQuestion 1 DMC currently has 100,000 shares of common stock outstanding with a market price of $50 per share. It also has $2 million in 7% bonds currently selling at par. The company is considering a $4 million expansion program that it can finance either (I) all common stock at $50 per share, or (II) all bonds at 9%. The company estimates that if the expansion is undertaken, it can attain, in the near future, $1 million EBIT. The company’s tax rate is 40%. Calculate EPS for each plan. Draw the EBIT-EPS graph. What is the break-even or indifference point between the two alternatives? Due to expansionary credit conditions / monetary policy, you expect that sales and EBIT next year would be greater than the break-even calculated in © above, what form of financing would you recommend? Which plan is riskier, I or II? Why?arrow_forward
- Problem 4. Mr. X is an investor in ABC Corporation. In 2020, he has 1,000 share holdings acquired at P120 per share classified as capital asset. Mr. X uses FIFO in costing his investment holdings. Required: a.) What would be the net capital gain in March? b.) How much is the nondeductible loss in May? c.) Supposing that all the remaining shares were liquidated in December 2021 at 130 per share, what would be the capital gain(loss) to be recognized.arrow_forwardTed McKay has just bought the common stock of Sunland Corp. Management of Sunland expects the company expects to grow at the following rates for the next three years: 40 percent, 35 percent, and 25 percent. Last year the company paid a dividend of $2.20. Assume a required rate of return of 12 percent. Compute the expected dividend for the first year. D1 $enter a dollar amount of the dividend for the first year rounded to 2 decimal placesarrow_forwardInstrument Corporation has the following investment which was held throughout 2021–2022. Assume the organization has invested in stock and holds 40%. Fair Value Cost 12/31/21 Equity investment $900,000 $1,200,000 A. Record the initial investment. B. Total dividends paid equal $400,000. Record the dividends. C. Total Net Income for the year equals $600,000. Record the income. D. If Instrument increased its investment to 55%, what would occur? Explain your answer.arrow_forward
- 25) ABC Corporation purchased 30,000 shares of common stock of the XYZ, Inc. for $50 per share on January 2, 2020. XYZ Inc. had 100,000 shares of common stock outstanding during 2021, paid cash dividends of $180,000 during 2021, and reported net income of $550,000 for 2021. ABC Corporation should report revenue from investment for 2021 in the amount of?arrow_forwardHalliford Corporation expects to have earnings this coming year of $3.000 per share. Halliford plans to retain all of its earnings for the next two years. Then, for the subsequent two years, the firm will retain 50% of its earnings. It will retain 20% of its earnings from that point onward. Each year, retained earnings will be invested in new projects with an expected return of 25.0% per year. Any earnings that are not retained will be paid out as dividends. Assume Halliford's share count remains constant and all earnings growth comes from the investment of retained earnings. If Halliford's equity cost of capital is 10.0%, what price would you estimate for Halliford stock?arrow_forwardPermian Partners (PP) produces from aging oil fields in west Texas. Production is 1.92 million barrels per year in 2018, but production is declining at 9% per year for the foreseeable future. Costs of production, transportation, and administration add up to $26.20 per barrel. The average oil price was $66.20 per barrel in 2018.PP has 8.2 million shares outstanding. The cost of capital is 11%. All of PP’s net income is distributed as dividends. For simplicity, assume that the company will stay in business forever and that costs per barrel are constant at $26.20. Also, ignore taxes.a. Assume that oil prices are expected to fall to $61.20 per barrel in 2019, $56.20 per barrel in 2020, and $51.20 per barrel in 2021. After 2021, assume a long-term trend of oil-price increases at 7% per year. What is the ending 2018 value of one PP share? (Do not round intermediate calculations. Round your answer to 2 decimal places.) b-1. What is PP’s EPS/P ratio? (Do not round intermediate calculations.…arrow_forward
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningFundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning