Soft Bound Version for Advanced Accounting 13th Edition
Soft Bound Version for Advanced Accounting 13th Edition
13th Edition
ISBN: 9781260110579
Author: Hoyle
Publisher: McGraw Hill Education
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 1, Problem 1DYS

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. 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. 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.
  3. 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.

Expert Solution
Check Mark
To determine

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 income10%    
Dividends30000    
Cost700000    
Annual amortization $   15,000    
1st year PHC income $ 185,000    
Percentage owned40%    
      
 20182019202020212022
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
      
ROI8.43%8.89%9.30%9.66%9.98%
Average9.25%    

2.

Expert Solution
Check Mark
To determine

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 income10%    
Dividends30000    
Cost700000    
Annual amortization $   15,000    
1st year PHC income $ 185,000    
Percentage owned40%    
      
 20182019202020212022
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
      
ROI8.43%8.89%9.30%9.66%9.98%
Average9.25%    

3.

Expert Solution
Check Mark
To determine

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 income10%    
Dividends30000    
Cost639794    
Annual amortization $   15,000    
1st year PHC income $ 185,000    
Percentage owned40%    
      
 20182019202020212022
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
      
ROI9.22%9.67%10.06%10.39%10.67%
Average10.00%    

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
1st Jan-31 Dec reporting period Year 2022: At the beginning of the reporting period, it has $5 million of share capital and 1.5 million ordinary shares outstanding. On 1 April 2022, the company announces a bonus issue of 2 shares for every share held on that date. By the end of the year Himalaya Ltd.’s profit attributable to ordinary shareholders amounts to $5,250,000. Year 2023: Himalaya Ltd. needs to raise funds for expansion of its business. Ms. Natasha Romanoff, CEO and Mr. Clint Barton, CFO have decided to make a non-renounceable rights issue to existing shareholders of 250,000 new shares at an issue price of $20 per share. Goldman Sachs has agreed to fully underwrite the rights issue. Himalaya Ltd issued a prospectus on 1 February 2023 and applications closed on 3 April 2023. Costs associated with the rights issue and the eventual issue of the shares were $45,000. RequiredFor year ending December 2023: Prepare the journal entries for the rights issue and the subsequent share…
Question 6 On June 1, 2020, Ping Corp. purchased 10,000 of Pong’s 50,000 outstanding shares at a price of P6.00 per share. Pong had earnings of P3,000 per month during 2020 and paid dividends of P10,000 on March 1, 2020 and P12,500 on December 1, 2020.  The fair value of Pong’s shares was P6.50 per share on December 31, 2020.   Which statement is correct? Group of answer choices Assuming that the investment is FVTOCI, the total effect on Ping’s profit or loss for the year ended December 31, 2020 is P7,500. Assuming that the investment is an associate, the total effect on Ping’s profit or loss for the year ended December 31, 2020 is P3,600. After all closing entries for 2020 are completed, the effect of the increase in fair value on total shareholders' equity would be the same amount under the FVTOCI and FVTPL approaches. Assuming that the investment is FVTPL, the total effect on Ping’s profit or loss for the year ended December 31, 2020 is P2,500.
capital structure 1. Enya Company is planning to repurchase part of its common stock by issuing corporate debt. As a result, the firm’s debt–equity ratio is expected to rise from 40 percent to 50 percent. The firm currently has RM4.3 million worth of debt outstanding. The cost of this debt is 10 percent per year. Enya expects to have an EBIT of RM1.68 million per year in perpetuity. Enya pays no taxes. I. What is the market value of Locomotive Corporation before and after the repurchase announcement? II. What is the expected return on the firm’s equity before the announcement of the stock repurchase plan? III. What is the expected return on the equity of an otherwise identical all-equity firm? IV. What is the expected return on the firm’s equity after the announcement of the stock repurchase plan?

Chapter 1 Solutions

Soft Bound Version for Advanced Accounting 13th Edition

Knowledge Booster
Background pattern image
Accounting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Text book image
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Text book image
EBK CFIN
Finance
ISBN:9781337671743
Author:BESLEY
Publisher:CENGAGE LEARNING - CONSIGNMENT
Text book image
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Text book image
Entrepreneurial Finance
Finance
ISBN:9781337635653
Author:Leach
Publisher:Cengage
What is WACC-Weighted average cost of capital; Author: Learn to invest;https://www.youtube.com/watch?v=0inqw9cCJnM;License: Standard YouTube License, CC-BY