Interpolation applications in financial analysis, Financial Management

In financial analysis, interpolation is used widely in:

  1. Determination of internal rate of return of a project.

  2. Finding out the yield to maturity (ytm) of a bond or debenture.

  3. Other situations where the time value of money is considered and interpolations have to be made while using the present and future value tables.

In financial analysis extrapolation is widely used for:

  1. Forecasting future sales, cost and profit.

  2. Long-term capital requirements.

  3. Production of financial statements for financial institutions, banks, etc.Example 4

The cash inflows of a project involving an initial outlay of Rs.22 lakh is as follows:

Year

Rs. in lakh

1

2

3

4

10

10

6

3                              

The internal rate of return is the rate at which the total value of discounted cash outflows is exactly equal to the total value of discounted cash inflows. The internal rate of return of a project can be determined only through a process of trial and error.

To begin with, let us try the discount rate of 14%.

Using present value interest factor (PVIF) tables, the total of discounted cash inflows will be,

(10 x 0.877) + (10 x 0.769) + (6 x 0.675) + (3 x 0.592) = Rs.22.29 lakh.

Since this figure is higher than the initial outflow of Rs.22 lakh, we must discount at a higher rate.

At r = 15%, the total of discounted cash inflows will be,

(10 x 0.870) + (10 x 0.756) + (6 x 0.658) + (3 x 0.572) = Rs.21.93 lakh.

At the discount rate of 15%, the discounted cash inflows are slightly lower than Rs.22 lakh. It can be concluded that the internal rate of return must lie somewhere between 14% and 15%. The technique of interpolation can be used to determine the exact rate of return.

We now have a series of the following nature:

Rate%

Discounted Cash Flows (DCF)

(Rs. in lakh)


14

22.29

15

21.93

For an intermediary figure of Rs.22 lakh of discounted cash flow we need to interpolate the rate.

The linear approximation method may be used to interpolate. We know that when the rate increases by 1%, the DCF falls from 22.29 to 21.93 or the descent in DCF for 1% ascent in rate is (22.29 - 21.93). We also know that the interest rate must be higher than 14%, but less than 15%.

At the exact rate, the descent must be (22.29 - 22.00). When descent is

(22.29 - 21.93), the increase in rate is 1. For a descent of (22.29 - 22)

the increase in rate must be   882_applications in financial analysis.png
The internal rate of return = 14% + 1189_applications in financial analysis1.png
  = 14 + 0.806 ~ 14.81%
Posted Date: 9/13/2012 8:13:45 AM | Location : United States







Related Discussions:- Interpolation applications in financial analysis, Assignment Help, Ask Question on Interpolation applications in financial analysis, Get Answer, Expert's Help, Interpolation applications in financial analysis Discussions

Write discussion on Interpolation applications in financial analysis
Your posts are moderated
Related Questions
Third Inc. wishes to issue a perpetual callable bond. The current interest rate is 6%. Next year, there is a 30% chance that the interest rate will be 4.5% and a 70% chance that th

Why do businesses spend time, effort, and money to produce forecasts?  Explain. Businesses succeed or fail relies on how well organized they are to deal with the situations they

Q. Is Conservatism an investment strategy? Conservatism - An investment strategy aimed at long-term capital appreciation with low risk; moderate; cautious; opposite of aggressi

Q. Calculation of WMCC? The calculation of WMCC requires several steps to be taken and is subject to the following assumptions: 1) The WMCC is calculated on the basis of market

1. Describe the types of financial ratios and other financial performance measures that are used during a venture's successful life cycle. Who are the users of financial performan

Expected volatility is a major factor that affects the value of an option. Expected volatility of an option on bond is referred to as 'expected yield volatility'. The

limitations of historical cost

Citilink will start a new business line on 1st July, 2011 to make and sell bus souvenirs. The target sales and production volume are 525,000 in next year. The following projected

Jack needs to borrow $1,000 for the next year. Bank South will give him the loan at 9 percent. Suncoast bank will give him the loan at 7 percent with a $50 loan origination fee. Fi

The Rise of Derivative Market: In the 1980s, the process of liberalization and deregulation of the financial markets gained momentum when the British and American leadership l