Answered You can hire a professional tutor to get the answer.

QUESTION

I was looking for some help with a couple of Finance problems that I wasn't able to complete for my homework a few weeks ago and I am looking to

I was looking for some help with a couple of Finance problems that I wasn't able to complete for my homework a few weeks ago and I am looking to relearn and perfect the concepts for my exam. The first question is in regards to the Fundamentals of Capital Budgeting chapter and the others are in regards to Stock Valuation. I have included a brief overview of concepts that I struggled with specifically in each problem below in an effort to make it easier for you to understand which steps I was caught up on.

1st: 

- Calculating PV of Future Cash flows after N years have passed

- Determining whether a machine should be sold in order to purchase a newer machine (weighing the two alternatives)

2nd: 

- Calculating exit value

- Calculating stock price after N years have already passed

3rd:

- Determining range of stock prices given EBIT rate range

- Determining range of stock prices given growth rate range 

- Determining range of stock prices given WACC range 

4th:

- Calculating high P/E & EV/EBITDA range

- Calculating low P/E & EV/EBITDA range

5th:

- Using enterprise value to sales multiple to determine range of share price

- Determining range of prices using max/min enterprise value to EBITDA

I prefer to learn the formulas and calculations by hand; however, if it's a particularly lengthy calculation that has a lot of room for error either in calculation or rounding and there is an easier alternative via Excel, then that method would be preferred.

  • Attachment 1
  • Attachment 2
  • Attachment 3
  • Attachment 4
  • Attachment 5
a. Estimated enterprise value for Nike = Average EV/Sales × KCP Sales= 1.12 × $25,292 million= $28,327.04 millionEquity Value = EV – Debt + Cash= $28,327.04 – 1,391+ 3,332= $30,268.04...
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question