Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I got this DCF model template online and filled it in with a public company's information. Some things are just assumed values, but if you

image text in transcribed

I got this DCF model template online and filled it in with a public company's information. Some things are just assumed values, but if you had to explain what was going on here, what would you say about this? Literally any kind of analysis on this would help me. For example, if you were thinking about acquiring this company, would you or would you not? Why?

DCF Model Cash Flow $69,146 Perpetural Growth Rate EVIEBITDA Multiple $61,615 $54,303 47,204 520,156 Shares Outstanding 009 2011 2012 Terminal Value Perpetural Growth EVIEBITDA Average 791,332 2,910,019 1,850,676 6/30/12 6/30/12 axes Less: Changes in NWC (2,382,423) (2,382,423) 1,850,676 1,850,676 Market Value Market Cap Plus: Debt Less: Cash Enterprise Value ue Enterprise Value 1,369,151 105,335 135,518 1,338,968 2,352,240 135,518 105,335 2,382,423 Target Price Upside Internal Rate of Return (IRR) Market Value vs Intrinsic Value Market Value Equity Value/Share Equity Value/Share 30.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions