Doing An IRR function in Excel manually Using The Goal Seek Function

Excel function tutorials

If you want to learn Excel, keep reading or Get 10 days of free unlimited access to Lynda.com. for professional help and Excel Tutorials
***************

The other day I got an interesting question from a reader. He was trying to do an IRR (internal rate of return) but had one specification. An IRR function assumes that all cash flows are at the same period of the year. He wanted something more precise that would account for the fact that some cash flows might be at the start, beginning or middle of the year. I suggested that he try to do an IRR manually and decided to give it a try myself.

First, take a look at a traditional IRR function result:

Then, I decided to get the same result but with a function instead. How?

An IRR function is the rate of return for break-even. So I created a formula manually that would calculate the “NAV”. When that NAV would become $0, I would have the correct IRR. Look at this screen:

Then, I used the goal seek function to set the nav to $0.

As you can see, I get the same result:

Then, I did the same exercise but changed the years to reflect the period. So Q1 of the 3rd year would become 2.25, etc. See the result here:

***************************************************

Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss


***************************************************

4 Feedbacks on "Doing An IRR function in Excel manually Using The Goal Seek Function"

web design inspiration

web design inspiration…

Experiments in Finance…



Christian Louboutin Outlet

Woah! I’m really enjoying the template/theme
of this site. It’s simple, yet effective. A lot of times it’s challenging to get that
“perfect balance” between user friendliness
and visual appeal. I must say you have done a
fantastic job with this. Additionally, the blog
loads super quick for me on Internet explorer. Superb Blog!



enquiry

enquiry

Doing An IRR function in Excel manually Using The Goal Seek Function | Experiments in Finance



solicitor definition ireland

solicitor definition ireland

Doing An IRR function in Excel manually Using The Goal Seek Function | Experiments in Finance



Comments

Please Leave a Comment!





Please note: Comments may be moderated. It may take a while for them to show on the page.