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
22.5¢ |
Change
-0.005(2.17%) |
Mkt cap ! $594.0M | |||
| Open | High | Low | Value | Volume |
| 23.0¢ | 23.0¢ | 22.5¢ | $28.64K | 125.4K |
Buyers (Bids)
| No. | Vol. | Price($) |
|---|---|---|
| 25 | 642705 | 22.5¢ |
Sellers (Offers)
| Price($) | Vol. | No. |
|---|---|---|
| 23.0¢ | 700686 | 35 |
View Market Depth
| Last trade - 14.17pm 27/05/2024 (20 minute delay) ? |
|
|||||
|
Last
22.8¢ |
Change
-0.005 ( 0.71 %) |
||||
| Open | High | Low | Volume | ||
| 23.0¢ | 23.0¢ | 22.5¢ | 23169 | ||
| Last updated 13.37pm 27/05/2024 ? | |||||
| COE (ASX) Chart |