It seems to me that we need a valuation method.
Below is a simple Excel spreadsheet tool that does that.
If the variables and Future Value are stored in row 10, columns A to G,
and the No of shares held is in row 13, then the Future Value of shares in in E 13.
Please don't argue that the numbers are or are not true or realistic, I just chose
some numbers to show the calculations that produce the required results.
Just choose your own numbers and produce your own results. I hope this helps.
To Calculate the Future Value From the CAGR. Present Value CAGR % No of Years Future Value 1.4 100 5 =Round((A10*(C10/100+1)^E10,2) No of shares held Future Value of shares 148,236 =A13*G10
It seems to me that we need a valuation method.Below is a simple...
-
- There are more pages in this discussion • 2,296 more messages in this thread...
You’re viewing a single post only. To view the entire thread just sign in or Join Now (FREE)
Add PNV (ASX) to my watchlist
 (20min delay)
|
|||||
|
Last
$2.45 |
Change
0.010(0.41%) |
Mkt cap ! $1.691B | |||
| Open | High | Low | Value | Volume |
| $2.45 | $2.51 | $2.43 | $5.243M | 2.122M |
Buyers (Bids)
| No. | Vol. | Price($) |
|---|---|---|
| 5 | 35541 | $2.45 |
Sellers (Offers)
| Price($) | Vol. | No. |
|---|---|---|
| $2.46 | 2681 | 1 |
View Market Depth
| Last trade - 16.10pm 28/06/2024 (20 minute delay) ? |
| PNV (ASX) Chart |