Method to calculate IRR

Can anyone provide me formula to calculate exact IRR, i.e. after applying trail and error method, we come to know that rate is between 10% & 11%. But, what is the formula to find rate in decimal points after this.

 

Thanks in advance

Replies (5)

let present value @ 10%-present value @ 11%=x

and present value @ 10%-initial investment =y

then formula for calculating IRR is IRR=10+(11-10)*y/x

if you provide me the question i will solve it for you.

 

IRR:- It is the rate of return or discounting factor at which discounted cash in flow is equal to discounted cash out flow i.e NPV=0, PI=1.

EXAMPLE

Let cost of project is Rs 500000.

you are required to find IRR if cash in flow of different future years are as below :-

year

cash in flow

pv factor @ 24%

pv (Rs)

pv factor @ 23%

pv (Rs)

1

200000

0.8065

161300

0.813

162600

2

80000

0.6504

52032

0.6609

52872

3

300000

0.5245

157350

0.5374

161220

4

195000

0.4229

82465.5

0.4369

85195.5

5

75000

0.3411

25582.5

0.3552

26640

6

46000

0.2751

12654.6

0.2887

13280.2

TOTAL

491384.6

501807.7

Here we find that at 24%, discounted cash in flow is less than Rs 500000

And

At 23%, discounted cash in flow is more than Rs 500000

Therefore, the rate at which discounted cash in flow becomes Rs 500000 i.e equal to out flow of cash at zero time,

lies between

24% and 23%, which is called IRR.

Therefore,

IRR = 23% + (501807.7 - 500000)/(501807.7-491384.6)*(24%-23%) = 23.1734321

=24% - (500000 - 491384.6)/(501807.7-491384.6)*(24%-23%) = 23.1734321

Therefore, IRR= 23.1734%

10+( Pv @ 10% - Pv of outflow / Pv @ 10% - Pv  @ 11%)* 11-10

Hi friend,

 

A sample video of Online Coaching - Shortcut method to compute IRR is placed by Sreeram Coaching Point. Visit www.sreeramcoachingpoint.com and make use of it.

Thanks for Sharing Sreeram.

 The effort taken by LM Sir for our students' community is something marvelous.. :-)

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
20 November 2026
Article

S & N CO

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details
Company
20 November 2026
Senior Accountant

Compass Tex India Pvt Ltd

Coimbatore

CA Inter

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details