Compute the required return to equity and WACC

Reference no: EM133095227

Simulation

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.

Multistage

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.

Free CashFlow
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:- Simulation.rar

Reference no: EM133095227

Questions Cloud

How much of your income is subject to taxation : You open up a traditional IRA to save for retirement and you make a $4,000 contribution. How much of your income is subject to taxation

Types of business managers : There are a lot of different, but related job titles (e.g., Medical and Health Services Managers, Healthcare Manager, etc.) that describe what healthcare admini

Four views of risk : There are risks and costs to a program of action. But they are far less than the long-range risks and costs of comfortable inaction.

Prepare the journal entry to adjust carry-forward balances : Deferred Tax Liability 29,000. Prepare the journal entry to adjust the carry-forward balances of the deferred tax asset and deferred tax liability

Compute the required return to equity and WACC : Use a THREE-stage total cash flow to equity model to compute the required return to equity and WACC for Dollar Tree

Developing an effective recruitment process : Scenario: You are a human resource director working in an integrated urban hospital. As a result of ongoing changes in the hiring process at your facility, your

Leverage self-analysis work : Create a LinkedIn account and create a profile that will leverage the self-analysis work and some of the deliverables completed for this course.

Long-range risks and costs of comfortable inaction : There are risks and costs to a program of action. But they are far less than the long-range risks and costs of comfortable inaction.

What is the weight that you should allocate to asset a : You will have a portfolio that is only comprised of two assets. Asset A has an expected return of 5.79%, What is the weight that you should allocate to Asset A

User Account

All Pages