Cash flow how to calculated irr internal rate return in Excel

For example, I am considering making a $50'000 investment that would increase my profits over the next 5 years as shown in Table below.

excel cash flow how to calculated irr internal rate return

To do it in Excel, here is the answer:

a) Enter the formula =IRR(M4:M9) as shown below. The formula returns the rate of Return for investment being considered.

excel cash flow how to calculated irr internal rate return

 

You can find similar Excel Questions and Answer hereunder

1) Vlookup to return max value from multiple hits in Excel

2) The scenario manager in Excel VBA allows to explore various scenarios in a very easy way

3) Our financial Year is divided into 13 periods of 4 weeks each. I enter weekly YTD data. In Excel, how can I set up Worksheet to get Period data automatically?

4) Vlookup to return multiple values in same cell in Excel

5) How can I set Page orientation, Zoom % , Title Rows and footer using VBA?

6) How can I fill a series of data automatically?

7) how do you enter multiple line in a cell in Excel

8) How to change desktop background in Excel

9) What are events in excel VBA. Here an explanation about VBA events.

10) Vba to return week numbers in Excel

 

Here the previous and next chapter