The interpolation formula which I am going to share with you today is considered

as cumbersome formula by majority of the students because most of the times the student fails to understand it. As personally happened with me also, but being consistent and determined with your target, you can surely achieve it, so here I will provide some information about Interpolation Formula used in financial management's Capital Budgeting (Investment Decisions).

We know that using interpolation formula we have to calculate Discount (interest) rate/Internal rate of return which is between two individual rates in the present value interest factor table. When you reach the two discount rates, where one gives a positive Net Present value and another gives a negative one you can apply the following formula to get the accurate IRR.

Example:- If during our trail and error process we reach two rates i.e., 10% as a Positive NPV rate and 11% as Negative NPV rate then we can calculate IRR as:

10 + {(NPV by 10% x 1)

Note: Students should appreciate the difference between NPV and Present value of Net Cash Flows.

While Present value of Net Cash Flows is the sum of Present value of cash flows during the life of project. NPV is Present value of Net Cash Flows (-minus) Initial Investment/Discount total outflow.

Note: In the above formula NPV by Lower rate is multiplied by 1, which solely depends upon the rates used to locate IRR. For Instance if in place of 11% there was 15% then NPV by Lower rate will be multiplied by 5 (i.e., the difference between the two rates)

as cumbersome formula by majority of the students because most of the times the student fails to understand it. As personally happened with me also, but being consistent and determined with your target, you can surely achieve it, so here I will provide some information about Interpolation Formula used in financial management's Capital Budgeting (Investment Decisions).

We know that using interpolation formula we have to calculate Discount (interest) rate/Internal rate of return which is between two individual rates in the present value interest factor table. When you reach the two discount rates, where one gives a positive Net Present value and another gives a negative one you can apply the following formula to get the accurate IRR.

IRR = Lower rate + {(NPV1 x Differece between the rates used)

**/**(Present value of Net Cash Flows by lower rate - Present value of Net Cash Flows by higher rate)}

Interpolation Formula (Lmeasy.blogspot.com) |

10 + {(NPV by 10% x 1)

**/**(Present value of Net Cash Flows by 10% (-minus) Present value of Net Cash Flows by 11%)}Note: Students should appreciate the difference between NPV and Present value of Net Cash Flows.

While Present value of Net Cash Flows is the sum of Present value of cash flows during the life of project. NPV is Present value of Net Cash Flows (-minus) Initial Investment/Discount total outflow.

Note: In the above formula NPV by Lower rate is multiplied by 1, which solely depends upon the rates used to locate IRR. For Instance if in place of 11% there was 15% then NPV by Lower rate will be multiplied by 5 (i.e., the difference between the two rates)

thanks for the info sir,

ReplyDeleteSometimes in life there are genuine

ReplyDeleteshortcuts.

Shortcuts which can be life-changing

and in this case transform your wealth.

But even shortcuts require a level of

discipline and focus.

This opportunity is one such shortcut:

http://five-minute-profit-sites.net?SLLO541

It requires setting aside a minimum of

23 minutes a day.

That might sound like nothing but

in my experience most people struggle

to go 23 minutes without checking their

phone.

I want you to promise me something.

Go to this private page right now and

decide if this is the kind of shortcut

that fits with your lifestyle and mindset:

http://five-minute-profit-sites.net?SLLO541

The financial reward from this small

time investment could literally change

your life.

Please let me know how you get on.