can you tell me step per step to calculate the forecasted measurement on each row in this dividend discount model? Step not analysis. I need to know how people calculating the amount on the forecasted column based on the actual data from each measurement such as revenue, cost, dividend, etc

I dont need interpretation just show me how to get the number with actual data for the forecast.

please show the calculation and the number in forecasted column. So i know how to get each number for doing the excel calculation.

Cost of equity is $6\mathrm{.}59\%.$We estimated that the margin profile will improve from $15\%$ in FY$2021$ to $18\%$ in FY$2026.$

We have estimated Earnings to grow at a CAGR FY$2022-2026$ of $7\mathrm{.}2\%$

We have estimated the Dividend Payout ratio at $84\%,$ which is conservative when compared to the average of the

last five years.