The real Return on investment (ROI) of Agro PLC for the last two years was 18.5%...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The real Return on investment (ROI) of Agro PLC for the last two years was 18.5% and 21.75% respectively while the inflation rate was 4.5% and 5.7% respectively. It is expected that the inflation rate will be 6% forever. Over the last two years the firm's dividends per share was respectively Rs. 15.5 and Rs. 16.85. Agro PLC expects that the real ROI would gradually slowdown up to 8.2% by the end of year 5 and thereafter it would be equals to the firm's real discount rate of 8% per year. The dividend policy of the firm is to pay 40% of earnings as dividends and the firm expects to maintain the same policy in future as well. Determine the Intrinsic value per share today. Based on the above observations show a Excel model to calculate the intrinsic value of a share of Agro PLC. The structure of the model should clearly include the Input, Output areas and the equations necessary for calculation. Note: Please use the Exhibit A to write-down the model or a similar structure that is to an Excel work sheet. (18 Marks) The real Return on investment (ROI) of Agro PLC for the last two years was 18.5% and 21.75% respectively while the inflation rate was 4.5% and 5.7% respectively. It is expected that the inflation rate will be 6% forever. Over the last two years the firm's dividends per share was respectively Rs. 15.5 and Rs. 16.85. Agro PLC expects that the real ROI would gradually slowdown up to 8.2% by the end of year 5 and thereafter it would be equals to the firm's real discount rate of 8% per year. The dividend policy of the firm is to pay 40% of earnings as dividends and the firm expects to maintain the same policy in future as well. Determine the Intrinsic value per share today. Based on the above observations show a Excel model to calculate the intrinsic value of a share of Agro PLC. The structure of the model should clearly include the Input, Output areas and the equations necessary for calculation. Note: Please use the Exhibit A to write-down the model or a similar structure that is to an Excel work sheet. (18 Marks)
Expert Answer:
Answer rating: 100% (QA)
Exhibit A Input Real ROI 185 2175 Inflation rate 45 57 Dividends per share Rs ... View the full answer
Related Book For
Applied Statistics in Business and Economics
ISBN: 978-0073521480
4th edition
Authors: David Doane, Lori Seward
Posted Date:
Students also viewed these accounting questions
-
In some countries, it is expected that businesses will pay off officials. Suppose it makes the difference between getting the contract and not getting the contract? If a payoff is not made because of...
-
It is expected that a parallel RLC resonant circuit has a midband admittance of 25 1103 S, quality factor of 80, and a resonant frequency of 200 krad/s. Calculate the values of R, L, and C. Find the...
-
A firms balance sheets for the last two years are as follows: Sales in 20X1 were $250,000. Sales in 20X2 were $250,000. a. Based solely on the current ratio and the quick ratio, has the firms...
-
Select the reasons why most professional telescopes are reflectors rather than refractors. A mirror can collect light more efficiently than a lens. Reflecting telescopes have shorter focal lengths...
-
What are various ways that a ribo-switch shuts off translation when it binds to its target molecule?
-
Using the number of hospitals per state listed in the table in Problem 3, make a stem-and-leaf display for the number of community hospitals per state. Which states have an unusually high number of...
-
Analyze the wine quality of young red wines data in Table B. 19 for multicollinearity. y X2 X3 X4 x6 X7 Xg Xg x10 19.2 0 3.85 66 9.35 5.65 2.40 3.25 0.33 19 0.065 18.3 0 3.73 79 11.15 6.95 3.15 3.80...
-
On June 30, 2018, a county (government) hospital bought 3,000 shares of stock for $94,000 intending to hold the investment for its proposed expansion of its trauma center. The market value of the...
-
Carvings LTd. is expected to pay dividends of $2.10 per share in Year 1 and $2.35 per share in Year 2 and $2.60 in Year 3. Then, the dividend is expected to increase by 3% annually in perpetuity....
-
Jackson et al. (1987) compared the precision of systematic and stratified sampling for estimating the average concentration of lead and copper in the soil. The 1-km2 area was divided into 100-m...
-
Instructions Job Cost, Source Documents Spade Millhone Detective Agency performs investigative work for a variety of clients. Recently, Alban Insurance Company asked Spade Millhone to investigate a...
-
1. Evaluate the integral S L cos (2) dx dy 2y by reversing the order of integration.
-
Given the Volumetric Analysis of a Natural Gas: CH4 = 67.3% Nitrogen = 9.6% 0 = 2.7% CO = 0.8% CH6 = 15.4% CO = 1.8% H = 2.4% Calculate the A/F ratio by mass considering CO = 10.8% CO2. Note: Use...
-
Figure Q4a illustrates a two-dimensional boundary-layer velocity profile over a flat wall. The sketch identifies flow velocities U, i = 1...5 at five successive heights spaced Ay apart and the...
-
PROBLEM 1 Class Workshop Exercise: Consider a person strengthening the shoulder muscles by means of dumbbell exercises. The figure bellow illustrates the position of the left arm when the arm is...
-
1. The input variable of mechanism in the Figure is 012. BD is perpendicular to DC. a) Write vector loop closure equation of mechanism. Write vector loop of closure equation in complex numbers. b) In...
-
K The trial balance for LMO, Inc., at September 15, 2018, follows: (Click the icon to view the trial balance.) Cash Sep Paid salanes. Date Requirement 2. The four-column ledger accounts, together...
-
Calculate the number of neutrons of 239Pu.
-
Semester GPAs are compared for seven randomly chosen students in each class level at Oxnard University. Do the data show a significant difference in mean GPAs? GPA for Randomly Selected Students in...
-
(a) Plot the data on gas bills. (b) Can you see seasonal patterns? Explain. (c) Use MegaStat or MINITAB to calculate estimated seasonal indexes and trend. (d) Which months are the most expensive? The...
-
Given a sample correlation coefficient r = .373 with n = 30, can you reject the hypothesis = 0 for the population at = .01? Explain, stating the critical value you are using in the test.
-
To test \(H_{0}: \sigma=50\) versus \(H_{1}: \sigma <50\), a random sample of size \(n=24\) is obtained from a population that is known to be normally distributed. (a) If the sample standard...
-
(a) Determine the critical values for a right-tailed test of a standard population deviation with 18 degrees of freedom at \(\alpha=0.1\) level of significance. (b) Determine the critical values for...
-
In Example 2 from Section 10.3, the quality-control engineer for M\&MMars tested whether the mean weight of fun-size Snickers was 20.1 grams. Suppose that the standard deviation of the weight of the...
Study smarter with the SolutionInn App