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)/ (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)
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,
ReplyDeleteOkay what about this formula
ReplyDeleteLowerrate + higher rate-lower rate/factor at higher rate-factor at lower rate *factor at higher rate-factor needed
Fantastic blog! Do you have any tips and hints for aspiring writers? I’m planning to start my own website soon but I’m a little lost on everything. Would you propose starting with a free platform like WordPress or go for a paid option? There are so many options out there that I’m completely overwhelmed .. Any suggestions? Many thanks! click here
ReplyDeleteGreat and that i have a dandy proposal: How Much Are House Renovations Stardew Valley remodeling companies near me
ReplyDeleteStudents should appreciate the difference between NPV and Present value of Net Cash Flows.
ReplyDeleteWhile 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.Thanks for sharing useful Information for the reasearch and it's very helpful. Being best ca coaching in hyderabad . One of the Leading Coaching Centres in Hyderabad for Chartered Accountancy.
Double Entry System is the only scientific system of accounting. According to it, every transaction has two-fold aspects–debit and credit. Both of these aspects are to be recorded in the books of accounts.
ReplyDeleteFor example, if a business purchase of furniture either the cash balance will be reduced or a liability to the supplier will arise. This system has proved to be systematic and has been found of great use for recording the financial affairs for all institutions requiring use of money.Thanks for sharing Valuable Information and it's very helpful. Being Best Top ca Final institute in bangalore One of the Leading Coaching Centres in bangalore for Chartered Accountancy.