Estimate the required return to equity and WACC

Assignment Help Financial Management

Reference no: EM133095140

Question: Use a single-stage dividend discount model to estimate the required return to equity and WACC for Alliant Energy Corporation. The historical dividends for this company are in the next worksheet.

Based on your understanding of the dividends, tread the forward-looking growth rate as stochastic. In addition, treat the tax rate as stochastic. Using the method we used in class, create a covariance matrix for these two inputs. Create a button that, when clicked, will simulate 100 WACC values and put them in column R. Compute the mean and standard deviation of the WACC.

You will need to do the whole simulation process, Cholesky and all. I have added the Cholesky code to a module in this file, so you do not need to copy it from the website.

Comment in a text box on how you came up with the covariance matrix of your stochastic inputs.

Use a THREE-stage total cash flow to equity model to compute the required return to equity and WACC for Dollar Tree (DLTR). Let the first growth rate apply to the first three years, the second to the following 4. Then have a long-term growth rate.

I have not given you the growth rates. Figure out a reasonable way to guess/estimate these and report the method you used in a text box. There is no single right answer for this, so use some creativity.

Continue your investigation into Dollar Tree by computing the (single stage) Free Cash Flow to Equity version of Re and the WACC.

In a text box, compare the FCFE estimates with the multistage TCFE you did in the previous tab.

Coment on any assumptions you made or difficulties you had with either approach.

Attachment:- Alliant Energy Corporation.rar

Reference no: EM133095140

Questions Cloud

Why is worker health and safety important : 1. Why is worker's health and safety important and how is it related to compensation and benefits?

What have you learned about yourself : What have you learned about yourself (in general and as a leader?

Terms of customers data breached and exposed : What was the impact in terms of customers' data breached and exposed?

What is probability that that patient was administered drug : What is the probability that that the patient was administered the drug and had their symptoms show signs of improvement

Estimate the required return to equity and WACC : Estimate the required return to equity and WACC for Alliant Energy Corporation. The historical dividends for this company are in the next worksheet

Important elements of the affordable care act : The Affordable Care Act was signed into law by President Barack Obama in March 2010. Many of the provisions of the law directly affect health care providers.

Understand different cultural backgrounds : 1. Why is it important for us to understand our own leadership styles prior to leading?

What would be your initial interventions : Your new patient mr. Smith is assigned to your unit after getting into a fight outside a local mall. He got into a group of strangers outside the store. Mr. Smi

Kinds of protections might customer expect : What kinds of protections might a customer expect from other customers when accessing reputations?

User Account

All Pages