YW Stefan.
That is actually a common mistake IMO.
Excel PV formula assumes that PV of an investment is a series of future payments, assuming periodic, constant payments and a constant interest rate. With just 1 payment years into the future the "skipping" of payments makes a difference when using PV(rate,nper,fcf) for 1 future payment "n" periods" into the future.
They are all estimates anyway.
YW Stefan.That is actually a common mistake IMO.Excel PV formula...
Add COE (ASX) to my watchlist
 (20min delay)
|
|||||
|
Last
23.5¢ |
Change
0.010(4.44%) |
Mkt cap ! $620.4M | |||
| Open | High | Low | Value | Volume |
| 22.5¢ | 23.5¢ | 22.5¢ | $901.6K | 3.903M |
Buyers (Bids)
| No. | Vol. | Price($) |
|---|---|---|
| 4 | 95398 | 23.0¢ |
Sellers (Offers)
| Price($) | Vol. | No. |
|---|---|---|
| 23.5¢ | 735751 | 15 |
View Market Depth
| Last trade - 16.10pm 10/05/2024 (20 minute delay) ? |
|
|||||
|
Last
23.5¢ |
Change
0.010 ( 6.82 %) |
||||
| Open | High | Low | Volume | ||
| 22.5¢ | 23.5¢ | 22.5¢ | 1893836 | ||
| Last updated 15.59pm 10/05/2024 ? | |||||
| COE (ASX) Chart |