Search by ticker code:
Generic filters

Search by ticker code:
Generic filters

Search by ticker code:
Generic filters

How To Use Excel’s IRR To Value Stocks

How do you value shares or stocks using the Internal Rate of Return (IRR)?

In this video, Owen Rask from The Rask Group explains how to use IRR to value stocks and businesses, what to look for, and he uses an example for IRR on a hypothetical company.

This video answers:

  • What is IRR?
  • Is high or low IRR better?
  • How to calculate IRR using Excel & Google Sheets
  • The difference between NPV and IRR
  • Using IRR to value a stock/business
  • The relationship between IRR and the cost of capital

Who Cares?

IRR is a very simple and easy-to-understand valuation methodology. In fact, it’s probably too quick and easy!

While our video is short (~20min in total), Owen provides a working template (click here to go RaskFinance.com) that viewers and readers can use to understand the risk-reward for almost any stock on the exchange.

IRR can be used to value:

  • Bank stocks
  • Tech stocks
  • Industrial stocks
  • Individual projects (e.g. infrastructure)
  • In corporate finance and Private Equity

This video is a bonus part of Rask Finance’s full investment valuation series, The Value of Everything. Take the full course today!

Finally, don’t forget, dogs can’t look up.

 

Disclaimer: This video is provided for educational purposes only. It forms part of the free valuation course provided by Rask Finance (part of The Rask Group). Rask Finance’s mission is to empower Australians with the information, education and advice they deserve. This video contains factual information only and should not be considered financial advice. Further, it shouldn’t be used for trading or investing. For more information, head to the Rask Finance website. Finally, if you made it this far through the disclaimer you’re a dang legend. 

$50,000 per year in passive income from shares? Yes, please!

With interest rates UP, now could be one of the best times to start earning passive income from a portfolio. Imagine earning 4%, 5% — or more — in dividend passive income from the best shares, LICs, or ETFs… it’s like magic.

So how do the best investors do it?

Chief Investment Officer Owen Rask has just released his brand new passive income report. Owen has outlined 10 of his favourite ETFs and shares to watch, his rules for passive income investing, why he would buy ETFs before LICs and more.

You can INSTANTLY access Owen’s report for FREE by CLICKING HERE NOW and creating a 100% FREE Rask Account.

(Psst. By creating a free Rask account, you’ll also get access to 15+ online courses, 1,000+ podcasts, invites to events, a weekly value investing newsletter and more!)

Unsubscribe anytime. Read our TermsFinancial Services GuidePrivacy Policy. We’ll never sell your email address. Our company is Australian owned.

Information warning: The information on this website is published by The Rask Group Pty Ltd (ABN: 36 622 810 995) is limited to factual information or (at most) general financial advice only. That means, the information and advice does not take into account your objectives, financial situation or needs. It is not specific to you, your needs, goals or objectives. Because of that, you should consider if the advice is appropriate to you and your needs, before acting on the information. If you don’t know what your needs are, you should consult a trusted and licensed financial adviser who can provide you with personal financial product advice. In addition, you should obtain and read the product disclosure statement (PDS) before making a decision to acquire a financial product. Please read our Terms and Conditions and Financial Services Guide before using this website. The Rask Group Pty Ltd is a Corporate Authorised Representative (#1280930) of AFSL #383169.

Skip to content