FREE-CASH-FLOW VALUATION OF EQUITY enter data In blue-colored cells Assumptions: PERIOD 10 0 1 2 3 YEAR 1 3 4 2 4 Profit from operations (EBIT) 0.0...
View the step-by-step solution to:

Question

How is each individual item highlighted in blue calculated? Screen Shot</h1><p class='abPRemoveTitle'> 2019-12-11 at 10.25.09 AM.png

Screen Shot 2019-12-11 at 10.25.09 AM.png

FREE-CASH-FLOW VALUATION OF EQUITY
enter data In blue-colored cells
Assumptions:
PERIOD
10 0
1
2
3
YEAR
1
3
4
2
4
Profit from operations (EBIT)
0.0
0.0
0.0
0.0
0.0
Income tax rate
0.0
0.0
0.0
0.0
0.0
Depreciation &amp; amortization expense
0.0
0.0
0.0
0.0
0.0
Net working capital from balance sheet forecast
0.0
0.0
0.0
D.0
0.0
0.0
Capital expenditures
0.0
0.0
0.0
0.0
0.0
Long-term growth rate
0.0%
Wt-Avg. C of C (K-wacc)
0.0%
Market Value of Debt
0.0
Number of Shares
0.0
Redundant Assets
0.0
PERIOD
1
2
3
5
YEAR
1
2
3
4
4
5
EBIT after tax (EBIAT)
0.0
0.0
D.0
0.0
0.0
+ Depreciation
0.0
0.0
0.0
0.0
0.0
-Cash Flow from Operations (CFFO)
0.0
0.0
0.0
0.0
0.0
+/- Change in Net Working Capital
0.0
0.0
0.0
0.0
0.0
+/- Capital Expenditures
0.0
0.0
0.0
0.0
0.0
=Free Cash Flow (FCF)
0.0
0.0
0.0
0.0
0.0
+Terminal Value (TV)
#DIV/O!
=Sum of FCF + TV
0.0
0.0
0.0
0.0 #DIV/O!
Present Value
#DIV/O!
- Market Value of Debt
0.0
Valuation of Equity
#DIV/O!
Redundant assets
0.0
=Adjusted Value of Equity
#DIV/O!
/ Number of Shares
0.0
Value of Equity per Share
#DIV/OI
MARKET MULTIPLES (COMPARABLES) VALUATION OF EQUITY
Average
Market Multiples of Peers
Peer A
Peer B
Peer C
Peer D
Poor E
Mkt Mult
Price /revenue market multiple of peer company
D.C
D.O
0.0
U.L
0.0 REFER TO PEER DATA TAB
Price/EBITDA market multiple of peer company
0.0
0.0
0.0
0.0
0.0
0.0
Price /Earnings market multiple of peer company
0.0
0.0
0.0
0.0
0.0
0.0
Mkt Val of Eq/Book Val mkt mult of Equity of peer co
0.0
0.0
0.0
0.0
0.0
0.0
Target company data
Target company revenue
0.0
adjust function
Target company EBITDA
D.0
If less than 5
Target company earnings (net income)
0.0
peers
Target company book value of equity
0.0
Target company number of shares
0.0

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Let our 24/7 Finance tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors