By table, I'm guessing you're referring to the discount rates?

As you know, NPV = (Sum of (cashflows year t) * (discount rate year t) from year t = 1 to N ) + Initial investment

The discount rates are 1 / (1 + discount rate )^t

The table is just a look-up table for those discount rates. On one axis you have years/time periods, on the other discount rate.

Let's say you have the following data:

Initial investment = -20

CF(t=1) = 10

CF(t=2) = 20

CF(t=3) = 30

And with different discount rates

r(t=1,2,3) = 5%

Your NPV is then

NPV = CF(t=1) x r(t=1)+CF(t=2) x r(t=2)+CF(t=3) x r(t=3)-Investment

From the lookup table (for example this link) you find the following:

Period 1, Discount Rate 5% : 0.9524

Period 2, DR 5% : 0.9070

Period 3, DR 5%: 0.8638

Ok, now you can insert all the data into your NPV equation

NPV = CF(t=1) x r(t=1)+CF(t=2) x r(t=2)+CF(t=3) x r(t=3)-Investment NPV = (10)x(0.9524)+(20)x(0.9070)+(30)x(0.8638)-20 = 33.575

If the yearly rates are different (year 1, i = 5%, year 2, i =3%, etc.), you simply multiply the discount rates, instead of using the table.

i.e

CF(1) * 1/(1+r1) + CF(2) * 1/((1+r1)(1+r2)) + ... + CF(N) * 1/((1+r1)(1+r2)...(1+rN))

 
Most Helpful

Could you provide visual examples of your problem? Having a real hard time figuring out what you're trying to say.

NPV is a sum of PV future cash flows, so that NPV = PV(CF1) + PV(CF2) + PV(CF3), nothing more to it than that.

To find PV of any future CF, you simply divide/multiply by the appropriate discount rates. If the rate is fixed, you the formula is PV = FV/(1+r)^n, if the rate is not fixed, you need to divide by every previous rate (1+r_1)(1+r_2)...(1+r_n), up to your future year / period n.

 

Similique ducimus inventore est velit. Occaecati voluptatem dolorem quis aspernatur dolor. Nemo praesentium nobis fugit ducimus quae aut.

Array

Career Advancement Opportunities

April 2024 Investment Banking

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

Overall Employee Satisfaction

April 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

April 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

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (145) $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
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
CompBanker's picture
CompBanker
98.9
6
dosk17's picture
dosk17
98.9
7
kanon's picture
kanon
98.9
8
GameTheory's picture
GameTheory
98.9
9
bolo up's picture
bolo up
98.8
10
Linda Abraham's picture
Linda Abraham
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...”