Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / Select real years to replace the proforma years indicated as Y0, Y 1

Select real years to replace the proforma years indicated as Y0, Y 1

Finance

  1. Select real years to replace the proforma years indicated as Y0, Y 1. You can select your years starting from the period 2012 up and including to the year 2020

2013-2018

  1. While the company’s earnings have grown by 15% in Y1 this growth is not expected to last. For Year 2 and 3 choose a rate from one of the following rates: 11% or 12% or13% or 14%

11%

  1. Choose a required equity rate from one of the following 6% or 7% or 8%

6%

  1. From Year 4 onwards the company’s earnings will grow at 1% below your chosen required equity rate.

5% after 4 years

  1. Choose your company’s dividend pay-out ratio by selecting either 20% or 30% or 40% of earnings

20%

  1. In your question you need to provide the discount values – do not ask your participant to determine these values using the PV formula is Excel.

your question using an abnormal earnings growth valuation

Prepare a complete solution showing all the calculations for your question

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

Particulars 2012 2013 2014 2015 2016 2017 2018
Time Y0 Y1 Y2 Y3 Y4 Y5 Y6
Earnings (Net Income) E 1.15E 1.2765E 1.416915E 1.487761E 1.562149E 1.640256E
Dividends (Dividends payout ratio*earnings) 0.2E 0.23E 0.2553E 0.283383E 0.2975522E 0.3124298E 0.3280512E
Free cash flow remaining after paying out dividends 0.8E 0.92E 1.0212E 1.133532E 1.1902088E 1.2497192E 1.3122048E
Cost of equity (r) 0.06 0.06 0.06 0.06 0.06 0.06 0.06
Discount factor= 1/(1+r)^n 0.943396226 0.88999644 0.839619283 0.792093663 0.747258173 0.70496054 0.665057114
Present value 0.754716981132075E 0.818796724813101E 0.857419211832587E 0.89786351427752E 0.889393253217102E 0.88100272262984E 0.872691136769375E
Sum of present value 5.9718835446716E