Interpolation applications in financial analysis, Financial Management

Assignment Help:

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%

Related Discussions:- Interpolation applications in financial analysis

What is institutional finance, What is Institutional Finance A natio...

What is Institutional Finance A nation's economic structure comprise a number offinancial institutions, like banks, pension funds, insurance companies, creditunions. These i

Miller approach of irrelevance of dividends, Q. Miller Approach of irreleva...

Q. Miller Approach of irrelevance of dividends? Discuss the Modigliani as well as Miller Approach of irrelevance of dividends. What are its drawbacks? Ans. Modigliani with M

What is suspension of payments, Is it possible for a company with a positiv...

Is it possible for a company with a positive net income and which does not distribute dividends to find itself in suspension of payments?  Yes. A lot of companies which entered

Tests in investments, Tests in Investments There are many rules that sp...

Tests in Investments There are many rules that specify how the past data of share prices can be used to obtain a clue regarding the future prices of shares. Such rules would be

Operating cycle, #questionoperating cycle in vegetable growing business in ...

#questionoperating cycle in vegetable growing business in uganda..

Steps in process of securitization, Process The process of Secu...

Process The process of Securitization involves the following steps: Transfer of assets by the originator (person holding the assets) to an entity (comp

Principle of opportunity cost, Suppose you have recently been contracted as...

Suppose you have recently been contracted as a financial consultant to a London-based engineering company, Alpha Products Plc. The company uses three components as part of their pr

Financial asseta and time value of money, assume that risk free rate is 8% ...

assume that risk free rate is 8% and expected rate of return in market is 12%. what is the required rate of return on stock with a beta of 0.8%

On-the-run treasury issues and selected off-the-run treasury, The wid...

The wide gap between maturities poses problems in using the on-the-run issues, especially after five years. Some dealers and vendors use selected off-the-run Trea

How does it help financial managers make business decisions, What is the in...

What is the investment opportunity schedule (IOS)?  How does it help financial managers make business decisions? The investment opportunity schedule illustrates graphically pro

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd