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
| +195 | Who Killed Wall Street | 64 | 2h |
| +176 | Worlds Worst MDs Competition (2026 Edition) | 33 | 13h |
| +164 | As Lehman people reconvene at UBS, Barclays needs to hire (2023) | 23 | 3d |
| +120 | Lindsay Clancy - Thoughts from A2 | 22 | 15h |
| +58 | How bad did I mess up | 11 | 12h |
| +43 | EB (EVR/CVP/LAZ) vs MBB (Bain/BCG) | 21 | 7h |
| +34 | Most technical groups? | 18 | 20h |
| +29 | JPM SMALL CAP or WF/JEF/RBC Coverage group | 13 | 4d |
| +25 | NYC Wall Street Run Club | 4 | 6m |
| +21 | Meritocratic IB groups / banks | 15 | 2d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
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
Excepturi iure nam illo minus sit. Odit deleniti culpa aut aut.
Sed porro porro repellendus distinctio. Sit consequatur sed eveniet sequi ut omnis. Ab quis doloribus provident ut ducimus accusantium id. Sunt recusandae nemo et ut non quia.
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...