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

1. A 10 ft chain weighs 25 lb and hangs from a ceiling with a...

Basic Math
Q

3. Describe the two major routes by which the amino groups are removed from amino acids:...

Biology
Q

The whey obtained from centrifugation to extract some proteins is stored in a preliminary tank and...

Mechanical Engineering
Q

5 Homer is getting scared of something horrific happening to him and dying so he...

Geometry
Q

A scientist claims that more than 4 percent of mammals are monogamous For which confidence...

Statistics
Q

When a car is randomly selected it is found to have an engine with 4...

Statistics
Q

Find all the zeros of the polynomial f(x)=x-x+2x - 4x-8 given that -2i is a...

Algebra
Q

1 3 12 6 3 6 6 2 5 10 4 5 4 20

Algebra
Q

Last year, our company's net operating income (NOi) was $3,700,000. Our Degree of Operating Leverage...

Accounting
Q

a Martinez Corporation owns equipment that cost $92,800 and has a useful life of 8...

Accounting
Q

Blending of financial information is done when component units and the primary government are so...

Accounting
Q

7. TI Calculator Graded Problem Set You are evaluating a proposed project for your company....

Finance