Answered step by step
Verified Expert Solution
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 &
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started