Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. complex finance problem using excel valuing copper

Complex finance problem using Excel Valuing Copperhead Corporation: Use the FCF valuation method with multiple growth rates...

Free

60.1K

Verified Solution

Question

Finance

Complex finance problem using Excel

Valuing Copperhead Corporation: Use the FCF valuation methodwith multiple growth rates for Copperhead Corporation, arapidly-growing service firm. Here are the relevant data necessaryto calculate the share price value of Copperhead, utilizing theValuation Method 2: The Price of a Share Is the Discounted Value ofthe Future Anticipated FCFs.

Valuing Copperhead Corporation

2014 FCF (base year)

$2,500,000

High growth rate, ghigh

30%

Normal growth rate, gnormal

11%

Number of high-growth years

5

WACC

18%

End-2014 debt

$3,500,000

End-2014 cash

$1,750,000

Number of shares (end-2014)

2,400,000

Answer & Explanation Solved by verified expert
3.7 Ratings (343 Votes)

WACC= 18.00%
Year Previous year FCF FCF growth rate FCF current year Horizon value Total Value Discount factor Discounted value
1 2500000 30.00% 3250000 3250000 1.18 2754237.288
2 3250000 30.00% 4225000 4225000 1.3924 3034329.216
3 4225000 30.00% 5492500 5492500 1.643032 3342905.068
4 5492500 30.00% 7140250 7140250 1.93877776 3682861.516
5 7140250 30.00% 9282325 147191153.6 156473478.6 2.287757757 68395999.58
Long term growth rate (given)= 11.00% Value of Enterprise = Sum of discounted value = 81210332.67
Where
Current FCF =Previous year FCF*(1+growth rate)^corresponding year
Total value = FCF + horizon value (only for last year)
Horizon value = FCF current year 5 *(1+long term growth rate)/( WACC-long term growth rate)
Discount factor=(1+ WACC)^corresponding period
Discounted value=total value/discount factor
Enterprise value = Equity value+ MV of debt
- Cash & Cash Equivalents
81210332.67 = Equity value+3500000-1750000
Equity value = 79460332.67
share price = equity value/number of shares
share price = 79460332.67/2400000
share price = 33.11

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

Complex finance problem using ExcelValuing Copperhead Corporation: Use the FCF valuation methodwith multiple growth rates for Copperhead Corporation, arapidly-growing service firm. Here are the relevant data necessaryto calculate the share price value of Copperhead, utilizing theValuation Method 2: The Price of a Share Is the Discounted Value ofthe Future Anticipated FCFs.Valuing Copperhead Corporation2014 FCF (base year)$2,500,000High growth rate, ghigh30%Normal growth rate, gnormal11%Number of high-growth years5WACC18%End-2014 debt$3,500,000End-2014 cash$1,750,000Number of shares (end-2014)2,400,000

Other questions asked by students

Q

PLEASE USING THIS INFORMATION FILL OUT ALL COLUMNS COMPLETELY IN THE TABLE MARKED AS (*******) 1) Life Period...

Finance
Q

Simply Chocolate Company is considering two possible expansion plans.Proposal X involves opening five stores in North...

Finance
Q

A manufacturer of banana chips would like to know whether its bag filling machine works correctly...

Basic Math
Q

What appropriate and necessary actions do you need to take to advise relevant people where there...

General Management
Q

rd My courses SC BIOL1001 P Biology II Evolutio 5 ed out of question When...

Biology
Q

1 Two types of electron carrier molecules NADH and FADH2 are produced during glycolysis and...

Biology
Q

There are 630 dishes that need to be rinsed. Omar can rinse them in 105...

Basic Math
Q

The formula A = 21.2 e 0.0417t models the population of a US state, A,...

Basic Math
Q

Clement Manufacturing Company uses two departments to make its products. Department I is a cutting...

Accounting
Q

The Responsibilities Standards stress the importance of: a. evidence accumulation. ...

Accounting
Q

Explain the impact if a not-for-profit confers excess economic benefits on disqualified persons.

Accounting
Q

A not-for-profit organization is required to report expenses incurred for programs separately from management and...

Accounting