Forum

 
guestdefault Forum
Current User: Guest user permissions Forum login Forum Login register Forum Register
Please consider registering


Register? | Lost Your Password?

Search Forums:


searchicon Forum 






Wildcard Usage:
*    matches any number of characters
%    matches exactly one character

topic Forum

Valuation Problem

addtopic Forum Add a New Topic addpost Forum Reply to Post
small tag Forumrelated Forum
UserPost

8:30 pm
March 1, 2010


TheAnswer

guestdefault Forum
Guest

I got this valuation exersice where I have to calculate both Enterprise Value and Equity Value.

The  company in question is looking to raise $100 million in equity to fund a factory, which will be built in 2010 for $200 million (the other $100 million will be funded through debt at 6% interest). The firm's sales forecast include variable and fixed cost. I also have enough info to calculate the WACC. However, I don't know D&A, CapEx or change in operating assets. Should I just assume them and calculate the DCF?

I also have EV/EBITDA, P/E multiples from a table of comparables, but based on my calculation, the company's 2010 EBITDA and net earnings are both negative. So how would I then use multiples to value the company?

Thanks.

9:17 pm
March 1, 2010


Holario

guestdefault Forum
Guest

Start depreciating the new asset (the factory) using the straight line method over a period of time, making some reasonable assumptions about scrap value and useful life.

For changes in net working capital, you have the sales, so you can back into the accounts receivable via an assumption for DSO. You also have the COGS (variable costs) so you can back into inventory and AP with assumptions for DPO and inventory turns.

For CapEx, check what the return on the factory asset is at the moment, and looking at the sales forecast, back into the necessary capital expenditures to keep ROA flat – it doesn't change that much in stable industries.

For the comapny's EBITDA, there is not much to calculate. In your case sales – variable expenses – fixed expenses = EBITDA. Does this really turn out to be negative? Remember not to include $200mm in capital expense in your 2010 EBITDA calculations.

This should be everything you need to do a decent DCF with reasonable assumptions. That's the Enterprise value. Subtract the $100mm debt and you have the Equity value.

Multiples can now be used to test if your numbers are reasonable or if you need to re-evaluate your assumptions.

8:56 pm
September 26, 2011


innovative_investments88

userdefault Forum
New Member

posts 2

Hi, advice on specific books or websites that can assist with equity valuation models!? Any help would be greatly appreciated, thanks.

small tag Forumrelated Forum
addpost Forum Reply to Post

Reply to Topic:
Valuation Problem

Guest Name (Required):

Smileys
sf confused Forum sf cool Forum sf cry Forum sf embarassed Forum sf frown Forum sf kiss Forum sf laugh Forum sf smile Forum sf surprised Forum sf wink Forum sf yell Forum
Post New Reply

Guest URL (required)

Math Required!
What is the sum of:
4 + 8
   


About the Equity-Research.com Forum

Most Users Ever Online: 24

Currently Online:
6 Guests

Currently Browsing this Topic:
1 Guest

Forum Stats:

Groups: 1
Forums: 5
Topics: 19
Posts: 108

Membership:

There are 264 Members
There have been 58 Guests

There is 1 Admin

Top Posters:

Risi – 10
Equity Researcher – 9
jiangtaoxgp – 5
lestin – 5
meme20 – 5
borselvs – 4

Recent New Members: abeckley, Josaw, Risi, meme20, edufinance, shiromanimakkar

Administrators: admin (2 Posts)



 

Popularity: 100% [?]

About the Author