Excel valuation of stock in practice. PV( ) function

Hello,

so there is this little guide on how to value a stock in excel using the =pv( ) function, See this link please on investopedia

1) Would this procedure actually be used in practice? Or is it just a theoretical approach?
2) Where would you get the figures from for expected profits of a company for the coming 10 yrs?
3) *edit

any help would be appreciated.

2 Comments
 
Best Response

1) I mean the basic idea is the same as a DCF analysis, except here it looks like they are using earnings to keep things simple, and instead of doing their own "terminal value" calculation, they are using an analyst estimate for the stock price 10 yrs out. In reality, nobody would do a valuation that relies on an analyst's estimate of future value, and analysts don't project prices out that far anyway. The basic concept, however - projecting cash flows over a period of 5-10 years, valuing the business at the end of that period, and then discounting everything to the present to get the fair stock price today - is widely used.

2) Presumably if you are considering an investment, you have done a thorough analysis of the business and you have your own idea of what the growth / profitability of the business will be going forward. That said, if you were in banking or otherwise needed a quick estimate, you could look at sell-side equity research reports, which usually have at least a few years of projections of the big line items.

 

Tempore iure officia quis voluptatem aut consequatur perferendis. Eos maiores eveniet quibusdam odit soluta ex quidem. Odit voluptatem maiores rerum odio qui.

Vel est inventore nesciunt. Cumque ratione fugit hic commodi. Sed nihil vitae voluptate ut sunt libero officiis. Aliquid et vero iste. Sequi libero et rerum quam commodi aut quam veritatis. Ex aut deleniti quis asperiores veniam accusantium cum. Soluta incidunt porro labore quo corporis tempora fugit.

Et rerum est aliquid mollitia sed totam. Voluptas non error voluptatem sed illum sed nulla.

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 04 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (17) $409
  • Associates (58) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $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
kanon's picture
kanon
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
GameTheory's picture
GameTheory
98.9
7
DrApeman's picture
DrApeman
98.9
8
dosk17's picture
dosk17
98.9
9
CompBanker's picture
CompBanker
98.9
10
Mimbs's picture
Mimbs
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...”