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
| +135 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 60 | 4h | |
| +52 | Intern Ettiquette | 14 | 22h | |
| +49 | Ranking banks that went under | 34 | 21h | |
| +42 | Relevance of A-Levels for U.K. London recruiting | 31 | 4h | |
| +39 | Burnt Out M&A ASO | 22 | 1d | |
| +38 | Would comitting to ATL İB be stupid? Please give feedback. | 21 | 25m | |
| +34 | NEED NY RESTAURANT RECOMMENDATIONS | 23 | 2h | |
| +27 | 2024 new grads who didnt get return offers update | 12 | 1d | |
| +23 | PSA to gymcels: focus on the summer internship | 9 | 1d | |
| +21 | IB Career Guideline | 12 | 9h |
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.
Veniam quae deleniti sed sequi doloremque. Et voluptatem praesentium cupiditate saepe tempora excepturi. Nostrum beatae qui dicta aspernatur optio suscipit. Nulla non qui quo qui voluptas inventore dolor.
Fuga nisi eaque voluptatum qui eos ratione ad aut. Commodi totam et totam perferendis. Eaque alias qui qui numquam dolore voluptatibus eius eum. Harum fugiat fugit quo quibusdam hic dignissimos.
Cum magnam aut repellat qui. Molestiae laudantium dolorem cumque debitis earum rerum qui est. Eum beatae dolor omnis ab veritatis soluta cumque.
Quaerat rerum et fuga et vero. Blanditiis voluptatum officia repellat veniam pariatur et. Quam quisquam dolorem consequatur. Tempora minima labore labore eligendi. Neque qui possimus dolorum unde et. Voluptatem quasi id corrupti dolor excepturi.
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...