Hi , Can I please have this done.

' ---- "__" _"'_'l__""'" I Information: Your senior analyst has called in your assistance. She must present a lecture to young investors. To ensure that she can assess each individual trainee investor's abilities she wants you to help design individual question with solutions for each participant. She is expecting over 100 candidates at her seminar. She provided you with the following proforma information on which to base your question. Y2012 Y2013 Y2014 Y2015 Y2016 $3.75 Values Required Section 1: (Use Word for this section) Prepare a question for the senior analyst to use at the seminar she will present. (Please note that a solution to the Question will be required for Section 2} In preparing your question take both the information provided by the senior analyst already and the following information into account. a) Choose a name for your company. - Protein Co b) 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 c) 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% - 12% d) Choose a required equity rate from one of the following 6% or 7% or 8% -7% e} From Year 4 onwards the company's earnings will grow at 1% below your chosen required equity rate. f} Choose your company's dividend payout ratio by selecting either 20% or 30% or 40% of earnings - 20% g} 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 last name (surname) starts with the letters A up to and including M you need to design Jur question using an abnormal earnings growth valuation equired Section 2: |(Preferably in Excel) 'epare a complete solution showing all the calculations for your