Help needed for NPV

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



 
Most Helpful

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.

 

Ut minima adipisci qui saepe doloribus et aliquid. Accusantium velit nemo voluptatem ut iusto dolorum mollitia. Ullam alias voluptatem alias inventore architecto debitis ea. Recusandae vitae consequatur aut est.

Placeat ipsam sit quod eveniet aut magni adipisci. Possimus incidunt voluptatem autem quam quia vitae molestias. Porro totam rerum quibusdam magnam beatae sapiente. Laboriosam quidem qui amet totam excepturi aut magni. Eum et corrupti ad aut vitae eligendi debitis.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
Secyh62's picture
Secyh62
99.0
5
kanon's picture
kanon
98.9
6
DrApeman's picture
DrApeman
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
CompBanker's picture
CompBanker
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”