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

Chemistry
1.2K views

Sally chemist is attempting to determine the mass % of acetic acid in vinegar. Below is...

Biology
1.2K views

“Organization of Lipids in the Tear Film: A Molecular- Level View” Article. Identify a specific type of...

Basic Math
1.2K views

This week we study complex numbers which include an "imaginary" part. This is an unfortunate name,  because...

Physics
1.2K views

A 4 kg box is pulled along a horizontal surface uk 0 23 by a...

Geometry
1.2K views

5 Find the surface area of the sphere exactly and approximately Q Exact 11 mi...

Basic Math
1.2K views

Find the Fourier series of f on the given interval 8 x 0 f x...

Algebra
1.2K views

A car averages 22 mpg with a standard deviation of 3 What is the standard...

Algebra
1.2K views

The window is 20 inches tall at its highest point and 80 inches wide at...

Accounting
1.2K views

Please answer ASAP! Thanks Which of the following cannot be...

Accounting
1.2K views

The bookkeeper for Baird's Country Music Bar left this incomplete balance sheet. Baird's working capital...

Accounting
1.2K views

The Modern Pen Company Jane Hayvice, controller of the Modern Pen Company, was concerned about...

Accounting
1.2K views

Panamint Systems Corporation is estimating activity costs associated with producing disk drives, tapes drives, and...