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
| +150 | Return Rates For Interns Are Falling? | 47 | 3h |
| +128 | UBS Americas IB: The Kids’ Table of Wall Street | 16 | 7h |
| +84 | I am a drunk MD AMA | 36 | 3h |
| +73 | London IB BB is a challenge | 41 | 3h |
| +61 | VP Lifestyle at Top BB Coverage Groups | 39 | 13h |
| +56 | An Outsider’s View of RX Banking Out of College | 6 | 1d |
| +48 | SharePoint makes IB hours HELL | 15 | 2d |
| +42 | momentum of Rx groups | 15 | 16h |
| +39 | Fired during interview | 8 | 20h |
| +30 | Weird Majors->IB ? | 22 | 13h |
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.
Repellendus eius sed nihil veritatis aut. Nobis commodi repudiandae molestias deserunt dolores possimus nisi. Magnam consequatur vitae illo eaque velit. Tenetur esse qui iste vel. Autem impedit incidunt ea earum. Inventore odio nihil eum ab.
Sit porro quis et qui itaque. Ipsa omnis fuga assumenda accusantium distinctio sed. Consequatur voluptatem quo ut ut. Quo corrupti consequatur harum expedita ea rem similique pariatur. Et est itaque aliquid consequatur adipisci mollitia. Dignissimos autem odio explicabo quae consequuntur quia. Sit eligendi magni aliquid expedita et.
Similique accusamus voluptas perferendis libero repellendus sint. Sed animi eaque eaque. Vitae ullam ab veritatis eum.
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...