Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. calculate the per share equity value of company xy

Calculate the per share equity value of Company XYZ (Using Excel) based on the following...

50.1K

Verified Solution

Question

Finance

Calculate the per share equity value of Company XYZ (Using Excel) based on the following information:
Sales for the most recent ended fiscal year 10 million
EBIT margin for the most recent ended fiscal year 17 percent
Sales growth projections: 10% for each of the next 2 years; 6% for years 3 & 4; 4% for year 5
EBIT margin projections: Y1 17%; Y2 16%; Y3 15.5%; Y4 15%; Y5 14.5%
CapEx for the most recent fiscal year 400K
Depreciation for the most recent fiscal year 100K
NWC for the most recent fiscal year 50K
CapEx is projected to be 4 percent of sales for the next 5 years
Depreciation is projected to be 25 percent of capex for the next 5 years
NWC is projected to be 0.50 percent of sales for the next 5 years
Sales, EBIT, CapEx, Depreciation and NWC will grow at 3 percent per year beyond year 5
Tax rate 25 percent
WACC is 14 percent and cost of equity is 16 percent
The company has 3 million in debt outstanding with a coupon rate of 4 percent

The company has 250K shares of common stock outstanding

(Show all work in Excel)

Answer & Explanation Solved by verified expert
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: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Heartland Foods will release a new range of candies which contain anti-oxidants. New equipment to manufacture...

Finance
Q

1. Distinguish between “genome-wide” selective sweeps, versus “gene-specific” selective sweeps. Which of these would you expect to...

Biology
Q

The battery shown in figure is ideal The values are 10 V R 502L 2H...

Physics
Q

3 14 0 x 10 N 4 1 75 x 10 N Two particles of...

Physics
Q

240 Find the area of the highlighted sector 623 1 O 536 2 16 ft...

Basic Math
Q

The function s(t) describes the motion of a particle along a line.s(t)= t 14t+ 22(a)...

Basic Math
Q

A company determined that the marginal cost C x of producing the xth unit of...

Calculus
Q

Assume that the domain of f is the set A 2 1 0 1 23...

Calculus
Q

Question 25) Your audit client shipped some merchandise to a customer on December 28 of...

Accounting
Q

Astro Corporation was started with the issue of 4,700 shares of $10 par stock for...

Accounting
Q

8. ! rt 1 of 4 Required Information [The following information applies to the questions...

Accounting
Q

Che 3 Selected data from Campbell Company follow: Balance Sheets As of December 31 8...

Accounting