I was given a set of cash flows and need to calculate the NPV as of 01/01/2020. Do I need to consider the cash flows before 1/1/2020? Any advice will be appreciated!
Cash flows follow:
FY 2017 90
FY 2018 -50
FY 2019 30
FY 2020 40
FY 2021 60
FY 2022 65
FY 2023 70
FY 2024 -45
| +178 | Americas M&A League Table Q2 Updated | 73 | 10h |
| +132 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 26 | 1h |
| +109 | Restructuring: Anti-climactic Experience | 27 | 9s |
| +75 | IB Net Worth / Savings Check | 30 | 6m |
| +74 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 12 | 1d |
| +51 | Boutique firm wants access to my LinkedIn? | 40 | 1d |
| +39 | Investment Banking is Hard | 17 | 21h |
| +31 | PWP vs BofA | 23 | 3h |
| +25 | Who pays the highest right now? | 14 | 3h |
| +21 | Big 4 Transaction diligence (FDD) vs Valuations and modeling for goal to get in IB | 5 | 4d |
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.
bump
What was the discount rate you were given? The NPV of all cash flows before 01/01/2020 would just be the net total, so it would be (90 - 50 + 30) = 70. That's because as of 01/01/2020, you would have 70 in cash, and since it's cash you have now, it's face value. You would then just find the NPV of all of the future cash flows normally then add them to 70 as that's what you have now.
NPV is used to calculate the present value of future cash flows, but since you were given past cash flows, I suppose you would just add the face value of the past cash flows? Idk for sure; I'm just an intern.
Thank you for answering. The most confusing part is the cash flows before 1/1/2020, and I was thinking about using CF*(1+R)^t to find the value as of 1/1/2020. Your explanation also makes sense; maybe I am overthinking about the cash flows before 1/1/2020.
BTW, the discount rate is 6%. I know how to figure out the PV of future cash flows.
No, any cash flow prior to 2020 is completely irrelevant and is meant to throw you off. Including FY 2020 and everything past that.
Repudiandae aut maxime nostrum eaque aut culpa sit. Ut sapiente quae facere dolore adipisci rerum libero voluptatum. Maxime fuga est est omnis reiciendis. Non nam ut tenetur perferendis et aperiam vel architecto. Eos nihil vero rerum earum eveniet placeat.
Possimus et quia est nobis. Error sint cum asperiores odit sed est sed sit. Veniam quam itaque ad est non temporibus. Illum perferendis aspernatur aliquid eveniet vero.
A molestiae quia ipsam a natus dolor. Voluptatem libero quod et et. Nihil eveniet libero dolores vel voluptas dolorem. Quam illo vel at ut non quisquam. Aperiam necessitatibus optio adipisci autem quaerat quo officiis perspiciatis.
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...