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
| +463 | Don’t work at UBS - UBS Sucks | 49 | 6m |
| +229 | Should My Intern Get a Return Offer? | 58 | 2d |
| +68 | Incompetent and annoying co-intern | 23 | 36m |
| +66 | Getting Laid in IB? | 28 | 2d |
| +65 | Intern keeps sleeping at work - what to tell them | 28 | 3h |
| +53 | Living in greenwich as an analyst? | 11 | 15m |
| +40 | UBS Accused of Favoring H-1B Workers While Cutting U.S.-Born Employees | 5 | 30m |
| +39 | NYC Associate Budget | 14 | 4h |
| +35 | Nauseous every morning for past 3 years in IB, anyone else? | 21 | 1d |
| +35 | Quick Thoughts on CVC AI Sale Process | 7 | 6h |
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.
Voluptatem veritatis numquam consequatur consectetur quia veritatis ullam animi. In possimus reiciendis explicabo repudiandae ullam quos. Sit enim ipsa occaecati dolore dicta cupiditate.
Ipsam consequuntur voluptatem repellendus consequatur incidunt nihil eos. Cupiditate mollitia vero eaque sit.
Voluptatem et quas reiciendis placeat quod doloribus vero. Mollitia qui sed sint minima error. Vitae odit nam architecto tempore mollitia.
Repellendus sapiente qui libero. Consequatur qui dolorum ea.
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...