Interpolation Formula

Can anyone provide me the formula for interpolation used in Capital Budgeting?


Thanks in advance.

Replies (4)
Quick Summary
Provides interpolation formula used in capital budgeting to calculate IRR using two discount rates and their NPVs. Includes method for equal and unequal cash flows and steps using payback factor and present value tables.

 

 

IRR  =Start rate+(NPV at start rate / NPV at start rate - NPV at end rate) X Difference between rate.

Hello









Here is the formula to calculate IRR

IRR = Lowest Discount Rate + [NPV at Lower rate * (Higher Rate - Lower Rate) / (NPV at Lower Rate - NPV at Higher Rate)]









For eg:- Say there are two discount rates for instance 10% & 20% and also let us say  NPV at 10% is +29,150 and at 20% is -19,350. Then IRR would be as follows :









IRR = 10% + [ 29,150*(20%-10%)/(29,150+19,350)]

IRR = 16.01%

NOTE : - This formula is useful when there is unequal Cash Inflows.

Regards,









CA PCC Student - FA

When there is equal Cash Inflows :

(a) Long Life Project : -

When life is at least twice that of payback period.

Steps :

1. Calculate Payback Factor

2. Look into PV Tables

 

(b) Short Life Project: - 

When life is less than the twice of payback period.

Steps:

1. Find two discount rates within which this value lies in the table.

 

IRR = Lower Discount Rate + [ (PV annuity Factor at Lower Rate - Payback Factor) / (PV annuity factor at Lower Rate - PV annuity Factor at Higher Rate)]

 

Payback Factor = Cash Outflow / Annual Cash Flow after tax

 Regards,

 

CA PCC Student - FA

 

Thanks Mangesh and CA PCC.. for replying and clarifying.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
14 November 2026
Manager - Indirect Tax (GST)

Westbridge Consulting LLP

New Delhi

CA

View Details
Company
19 October 2026
Accountant

Jari Saree Center

New Delhi

Others

View Details
Company
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details