Scribd
Upload
281 views2 pages

Stock Dividend Projection Guide

This document contains instructions and inputs for analyzing a stock investment over different time frames. It includes the stock's average return on equity, price-to-earnings ratio, book value per share, dividends per share, dividend payout ratio, and other financial metrics. The user is instructed to input data into blue sections and select the time frame gains in cell B19 by choosing the sum between cells E17 and E26 depending on the selected time period of the investment.

Uploaded by

Rational Investing
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
281 views2 pages

Stock Dividend Projection Guide

This document contains instructions and inputs for analyzing a stock investment over different time frames. It includes the stock's average return on equity, price-to-earnings ratio, book value per share, dividends per share, dividend payout ratio, and other financial metrics. The user is instructed to input data into blue sections and select the time frame gains in cell B19 by choosing the sum between cells E17 and E26 depending on the selected time period of the investment.

Uploaded by

Rational Investing
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

Instructions 1) Input data into blue sections 2) Select tGains (B19) and choose sum between E17 and

E26, depending on the selected time frame Stock Timeframe Avg ROE Avg P/E BPS DPS DPR RIR Franking Price EPS MR RR Projected Dividends* Year DPS 0 $1.86 1 $1.98 2 $2.12 3 $2.26 4 $2.41 5 $2.57 6 $2.74 7 $2.93 8 $3.12 9 $3.33 10 $3.56 Total DPS $1.98 (1 yr) fBPS $33.97 $4.10 (2 yr) fEPS $3.40 $6.36 (3 yr) fPrice $40.76 $8.77 (4 yr) tGains $42.74 $11.34 (5 yr) $14.09 (6 yr) IV $39.95 $17.02 (7 yr) MBP $33.29 $20.14 (8 yr) BIN 37% $23.48 (9 yr) $27.03 (10 yr) Glosssary *Note: All dividends (except DPS) are gross figures, in other words, Timeframe Number of years investment held Avg Average ROE Return on Equity P/E P/E ratio BPS Book value per share DPS Dividends per share DPR Dividend Payout Ratio Franking Franking (imputation) rate EPS Earnings per share MR Market's Required Return (Long-term bond yield or 0.7, whichever is larger) RR Required Return f Future Value t Total IV Intrinsic Value MBP Maximum Buy Price BIN "Buy it Now" Return MQG 1 10% 12 $32.88 $1.86 67% 33% 0% $29.10 2.76 7% 20%

elected time frame

gross figures, in other words, they do not carry any tax on them

You might also like