Calculating PV in excel
Hi -
Is there a way to calculate the present value of a stream of payments that start at a future point in time in excel? For example, I want to calculate the PV at 8/31/23 of $137 that is paid annually (starting 8/31/23) for 13 years, discounted at 13%.
Many thanks
yeah use the pv function
But I can't specify payment dates with that. I don't want to calculate the PV today, but rather the PV as if I am doing the calculation on 8/31/23
then do a fraction of a year to meet that need.
for 8/31/23 it could be something like yrs= 1.0907
Quo quo soluta porro earum. Laboriosam et est accusantium aut unde ut.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...