BUMN044H7 Valuation Analysis and Risk Management Assignment Help

BUMN044H7 Valuation Analysis and Risk Management

PART I: NextEra Energy Inc. STOCK VALUATION (75 marks)

As a new analyst for a large brokerage firm, you are anxious to demonstrate the skills you learned in your MSc programme and prove that you are worth your attractive salary. Your first assignment is to analyse the NextEra stock. Your boss recommends determining prices based on both the dividend-discount model and discounted free cash flow valuation methods. NextEra uses a cost of equity of 7.5% and an after-tax weighted cost of capital of 6.5%. It expects 3% return on new investments. However, you are a little concerned because your finance professor has told you that these two valuation approaches can result in widely differing estimates when applied to real data. You are really hoping that these alternative valuation methods will reach similar prices.

  1. Go to Yahoo! Finance (http://finance.yahoo.com) and enter the symbol for NextEra (NEE). From the main page for NEE, gather the following information and enter it into an Excel spreadsheet:
    1. The current stock price (last trade).
    1. The current dividend amount.
  • From the “Key Statistics” page, gather the following information and enter it on the same spreadsheet:
    • The number of shares of stock outstanding.
    • The payout ratio.
  • From the “Analyst Estimates” page, find the expected growth rate for the next five years and enter it onto to spreadsheet.
  • Start Excel, create a new blank spreadsheet and select Data / From Web. In the New Web Query box, paste the URL for NextEra’s “Income Statement” of the web page and press return. Use the little yellow and black arrow boxes to select the table containing the entire three years of income statements and import them. Repeat this process for both the balance sheet and cash flow statements for NextEra. Keep all the different statements in the same Excel worksheet.
  • To determine the stock value based on the dividend-discount model:
    • Create a timeline in Excel for five years.
    • Use the dividend obtained from Yahoo! Finance as the current dividend to forecast the next five annual dividends based on the five-year growth ratio.
    • Determine the long-term growth rate based on NextEra’s payout ratio (Eq. 9.12).
    • Use the long-term growth rate to determine the stock price for year five (Eq. 9.13).
    • Determine the current stock price based on the dividend-discount model (Eq. 9.14).
  • To determine the stock value based on the discounted free cash flow method:
    • Forecast the free cash flows using the historical data from the financial statements downloaded from Yahoo!Finance, Bloomberg or Capital IQ to compute the three-year average of the following ratios:
      • EBIT/Sales and NI/Sales
      • Tax Rate
      • Property Plant and Equipment/Sales and Depreciation/Property Plant and Equipment
      • Net Operating Working Capital/Sales
      • Net Borrowing/Sales
    • Create a timeline for the next seven years.
    • Forecast future sales based on the first five years and the long-term growth rate for years 6-7.
    • Use the average ratios computed in part (a) to forecast EBIT, property, plant and equipment, depreciation, and net working capital for the next seven years.
    • Forecast the free cash flow for the next seven years (Eq. 9.18).
    • Determine the horizon enterprise value for year 5 (Eq. 9.24).
    • Determine the enterprise value of the firm as the present value of the free cash flows.
    • Determine the stock price based on discounted free cash flow methods (FCFF and FCFE).
  • Compare the stock prices from these methods to the actual stock price. What recommendations can you make as to whether clients should buy or sell the stock based on your price estimates?
  • Explain why the estimates from these valuation methods differ 1) from the market price and 2) between themselves. Specifically, address the assumptions implicit in the models themselves as well as those you made in preparing your analysis. Why do these estimates differ from the actual stock price of NextEra?


Using the CBOE option table for NextEra, compare the market price at market close on April 4, 2023 for the (a) April, (b) June, and (c) September 2023 monthly call and put options with a strike price of $77.5 (≈ at- the money) to the price predicted by the Black-Scholes formula. Recent Treasury bill rates and historical dividend data are provided below. Discuss your results and limitations of the Black-Scholes option valuation model. Historical volatility for NextEra’s stock can be derived from historical daily prices (adj. close) for the last twelve months. Calculate 50-day rolling standard deviations of daily price changes and adjust the average by √𝑛 (where n is the number of trading days per year) for an estimate of annual volatility. Compute and compare the implied volatilities of options (output) with historical stock price volatility estimates (input). Determine what volatility estimate to use in the B-S option valuation model.

Use the Standard Normal Distribution Table in Appendix to determine N(d). Alternatively, you may use the Excel function NORMDIST (d,0,1,true).

Daily Treasury Yield Curve Rates (4 April 2023)

Date1 Mo3 Mo6 Mo1 Yr

For further detail see following link: https://www.treasury.gov/resource-center/data-chart-center/interest- rates/Pages/TextView.aspx?data=yield

During the past 13 years, the highest Dividend Yield of NextEra Energy was 3.57%. The lowest was 1.65%. During the past 13 years, the highest 3-Year average Dividends Per Share Growth Rate of NextEra Energy was 13.00% per year. he forward annual dividend yield on April 4, is 2.44%. Quarterly dividends for the last four years are tabulated below.

NEE Dividend History

(Payouts are split-adjusted)

  Cash AmountDeclare DateEx-Dividend Date  Record Date  Payment DatePayout Frequency
$0.385 11/24/202111/26/202112/15/2021Quarter
$0.385 08/26/202108/27/202109/15/2021Quarter

For further detail on NEE dividend data go to the following link: www.nasdaq.com


Black-Scholes Option Pricing Formula

The basic Black–Scholes formula calculates the price of European call and put options on an underlying stock but it can also be used to approximate the price of American stock options. The value of a call or put option for a non-dividend paying underlying stock in terms of the Black–Scholes parameters is:


Berk, J.B., and van Binsbergen, J.H., 2017, How do investors compute the discount rate? They use the CAPM,

Financial Analysts Journal 73, 25-32.

Black, F., and M. Scholes, 1972, Valuation of option contracts and a test of market efficiency, Journal of Finance

27, 399-417.

Black, F., and M. Scholes, 1973, Pricing of options and corporate liabilities, Journal of Political Economy 81, 637- 654.

Brealey, R.A., S.C. Myers, and F. Allen, 2010. Principles of Corporate Finance (McGraw-Hill, New York). Brennan, M. J., and E. S. Schwartz, 1977, Valuation of American put options, Journal of Finance 32, 449-462. Broadie, M., and J. DeTemple, 1996, American option valuation: New bounds, approximations, and a comparison of existing methods, Review of Financial Studies 9, 1211-1250.

Broadie, M., and J. B. DeTemple, 2004, Option pricing: Valuation models and applications, Management Science 50, 1145-1177.

Damodaran, Aswath, 2012. Investment Valuation: Tools and Techniques for Determining the Value of any Asset (John Wiley and Sons, New York).

Fama, E. F., 1998, Market efficiency, long-term returns, and behavioral finance, Journal of Financial Economics 49, 283-306.

Geske, R., and R. Roll, 1984, On valuing American call options with the Black-Scholes European formula,

Journal of Finance 39, 443-455.

Geske, R., and K. Shastri, 1985, Valuation by approximation – a comparison of alternative option valuation techniques, Journal of Financial and Quantitative Analysis 20, 45-71.

Hand, J. R. M., and W. R. Landsman, 2005, The pricing of dividends in equity valuation, Journal of Business Finance & Accounting 32, 435-469.

Harris, R. S., and J. J. Pringle, 1985, Risk-adjusted discount rates – extensions from the average-risk case, Journal of Financial Research 8, 237-244.

Kaplan, S. N., and R. S. Ruback, 1995, The valuation of cash flow forecasts – an empirical-analysis, Journal of Finance 50, 1059-1093.

Kim, I. J., 1990, The analytic valuation of American options, Review of Financial Studies 3, 547-572. Kim, M., and J. R. Ritter, 1999, Valuing IPOs, Journal of Financial Economics 53, 409-437.

Koller, T., M. Goedhart, and D. Wessels, 2010. Valuation: Measuring and Managing the Value of Companies (John Wiley & Sons, New York).

Krueger, Philipp, Augustin Landier, and David Thesmar, 2015, The WACC fallacy: The real effects of using a unique discount rate, Journal of Finance 70, 1253-1285.

Liu, J., D. Nissim, and J. Thomas, 2002, Equity valuation using multiples, Journal of Accounting Research 40, 135- 172.

Liu, Jing, Doron Nissim, and Jacob Thomas, 2007, Is cash flow king in valuations? Financial Analysts Journal 63, 56-68.

Luehrman, T. A., 1997, What’s it worth? A general manager’s guide to valuation, Harvard Business Review 75, 132- 142.

Merton, R. C., 1973, Theory of rational option pricing, Bell Journal of Economics 4, 141-183.

Merton, R. C., 1976, Option pricing when underlying stock returns are discontinuous, Journal of Financial Economics 3, 125-144.

Miller, M. H., 1986, Behavioral rationality in finance – the case of dividends, Journal of Business 59, 451-468. Modigliani, F, and M. Miller, 1963, Corporate income taxes and the cost of capital: A correction American Economic Review June, 11.

Modigliani, F., and M. Miller, 1958, The cost of capital, corporation finance and the theory of investment,

American Economic Review 48, 37.

Myers, S. C., 1974, Interactions of corporate financing and investment decisions – implications for capital budgeting, Journal of Finance 29, 1-25.

Ohlson, J. A., and B. E. Juettner-Nauroth, 2005, Expected EPS and EPS growth as determinants of value, Review of Accounting Studies 10, 349-365.

Pastor, L., and P. Veronesi, 2003, Stocks valuation and learning about profitability, Journal of Finance 58, 1749- 1789.

Penman, S.H. and T. Sougiannis, 1998, A comparison of dividend, cash flow, and earnings approaches to equity valuation, Contemporary Accounting Research 15(3), 343–83.

Roll, R., 1977, Analytic valuation formula for unprotected American call options on stocks with known dividends,

Journal of Financial Economics 5, 251-258.

Ruback, R. S., 2002, Capital cash flows: A simple approach to valuing risky cash flows, Financial Management

31, 85-103.

Sorensen, E. H., and D.A. Williamson, 1985, Some evidence on the value of the dividend discount model,

Financial Analysts Journal 41, 10.

Sterk, W. E., 1983, Option pricing – dividends and the in-the-money and out-of-the-money bias, Financial Management 12, 47-53.

Whaley, R. E., 1982, Valuation of American call options on dividend-paying stocks – empirical tests, Journal of Financial Economics 10, 29-58.