Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based on the assumptions provided, please create the model. Kindly provide the formula as well. begin{tabular}{|l|l|l|l|l|l|l|} hline Particulars & FY24E & FY25E & FY26E &

image text in transcribed Based on the assumptions provided, please create the model. Kindly provide the formula as well. \begin{tabular}{|l|l|l|l|l|l|l|} \hline Particulars & FY24E & FY25E & FY26E & FY28E & FY29E & Perpetuity \\ \hline EPS & ? & ? & ? & ? & ? & ? \\ \hline DPS & ? & ? & ? & ? & ? & ? \\ \hline PV of DPS & ? & ? & ? & ? & ? & ? \\ \hline Terminal Value & ? & ? & ? & ? & ? & ? \\ \hline PV of Terminal Value & ? & ? & ? & ? & ? & ? \\ \hline \end{tabular} Implied Share price of XYZ Itd Increase Decimal \begin{tabular}{|l|r|} \hline Assumptions & \\ \hline Growth Rate for high growth phase & 13.21% \\ \hline Length of high growth phase & \multicolumn{1}{|c|}{5} \\ \hline Growth rate for stable growth phase & 5% \\ \hline Payout ratio & 51.43% \\ \hline Risk free Rate & 6.50% \\ \hline Beta & 1.31 \\ \hline Market Risk Premium & 5.50% \\ \hline Cost of Equity & 13.71% \\ \hline Share outstanding (in Millions) & 4136.39 \\ \hline \end{tabular} \begin{tabular}{|l|c|} \hline Inputs from current financials & \\ \hline Net Income & 241080 \\ \hline total shareholders funds & 754070 \\ \hline current year dividend & 136345 \\ \hline shares outstanding (in millions) & 4136.4 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Economics Of Money Banking And Financial Markets

Authors: Frederic S. Mishkin

12th Global Edition

1292268859, 978-1292268859

More Books

Students also viewed these Finance questions