Question: Question ...about valuation useing excel Getting Information for valuation Most of the information that you need for valuation come from your current or past financial

Question ...about valuation useing excel

Getting Information for valuation

Most of the information that you need for valuation come from your current or past financial statements (available at Palestine stock exchange website). You will also need a beta (stock price and market index are available on Palestine stock exchange website).

https://web.pex.ps

Key Questions:

What type of cash flow (dividends, FCFE or FCFF) would you choose to discount for this firm?

What growth pattern would you pick for this firm? How long will high growth last?

What is your estimate of value of equity in this firm? How does this compare to the market value?

Do Framework for Analysis:

1. Cash Flow Estimation

What is this firm's accounting operating income? Would you adjust it for your valuation?

What is your firm's effective tax rate? What is its marginal tax rate? Which would you use in your valuation?

How much did your firm reinvest last year in internal investments, acquisitions, R&D and working capital?

2. Growth Pattern Choice

How fast have this company's earnings grown historically?

How fast do analysts expect this company's earnings to grow in the future?

What do the fundamentals suggest about earnings growth at this company?

(How much is being reinvested and at what rate of return?)

If there is anticipated high growth, what are the barriers to entry that will allow this high growth to continue? For how long?

3. Valuation

What is the value of the operating assets of the firm, based upon a discounted cash flow model?

Does the firm have cash and non-operating assets and what is their value?

Are there equity options outstanding (management options, convertible bonds) and how much are they worth?

What is the value of equity per share?

https://web.pex.ps

Note: only excel files are allowed

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

5.5 - Discussion: Current Assets 1 Financial Statements AnalysisDirections Using the Annual Report of your selected company (WALMART) answer the following questions in the Discussion: What is the...

2.What price should Aquarius sell for? The suggested process for solving this problem is: a. Develop common size income statements and balance sheets for Aquarius. b. Use the percentages (when...

N21 Xfx B D E 1 MGT2303.Fnal Project 2 3 Part 5: (a) Valuation for Purchase 4 5. The following information was pulled from a companies current annual financial statements 6 7 Account Values 8 9...

each item in common-sized income statement or balance sheet, we calculated the average of past three-year percentage as a projected percentage in 2007. Then use predicted sales and predicted total...

Valuation for purchase Calculate the value of Bjorn's business using the asset based method, as well as the earings based method based on the following information. Calibri (Body) ' ' 11 = Paste B IU...

Help please. Oto 3 Not yet Maked out of Many companies invest in the stock or debt securities of other firms. They may do so for several reasons Identity which activities, term, definition rates to...

Using Excel, prepare corrected balance sheet for Hydromaint Inc. Please put all the disclosures note for the financial statements. Please use attachments to prepare balance sheet with disclosures....

Can you please help me with this assignment? Thanks! "You work for a prestigious investment bank, Lazard Ltd, which has been recently commissioned by the US-based e-commence giant, Amazon.com, Inc....

2. [This question is optional. If you decide not to work on it, please assume that the optimal capital structure is ND* /(ND+E)=23.4%.] A careful analysis of Buckeye's strategy, its markets, and its...

The company started when it acquired $18,000 cash by issuing common stock. Purchased a new cooktop that cost $16,400 cash. Earned $20,700 in cash revenue. Paid $10,300 cash for salaries expense....

What is a Join operation? What is meant when it is said that two relations are join compatible? What is the difference between an Inner Join operation and an Outer Join operation?

4.38 Height and Head Circumference for Students and Teachers The scatterplot shows a solid blue line for predicting head circumference from height of teachers; the dotted red line is for predicting...

A hula hoop and solid disc of equal radii are rolled, from rest and without slipping, down an incline plane. Which one will reach the bottom of the inclined plane first? Explain.

A A company purchased equipment on 1 January 2013 for $ 40,000$, at which date the relevant price index for equipment was 100 . Depreciation is charged on a straight line basis at $25 \%$ per annum....

A You are presented with the following information relating to Messiter plc: \begin{tabular}{|c|c|c|} \hline Year to 31 December & \begin{tabular}{c} 2007 \\ $\mathrm{fm}$ \end{tabular} &...

A Categorise each of the following costs into one of these six categories: (i) Direct materials (ii) Direct labour (iii) Indirect manufacturing costs (iv) Administration expenses (v) Selling and...