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

Relevant and irrelevant cost, The first involved the creation of spreadshee...

The first involved the creation of spreadsheets to resolve some problems for an organization. You will need to model the problem roughly before you start to spreadsheet and you wil

Determine the earnings per share, Goodshape Company has currently, an ordin...

Goodshape Company has currently, an ordinary share capital of Rs. 2.5 million, consisting of 25,000 shares of Rs. 100 each. The management is planning to raise another Rs. 2 milli

Explain the random walk model for exchange rate forecasting, Explain the ra...

Explain the random walk model for exchange rate forecasting. Can it be consistent along with the technical analysis? Answer:  The random walk model assumes that the current excha

What is risk adjusted discount rate, Q. What is risk adjusted discount rate...

Q. What is risk adjusted discount rate? The risk adjusted discount rate includes two rates viz (i) Risk-free rate: - Risk free rate is the usual rate or the usual discount r

Define can a corporation have too much working capital, Can a corporation h...

Can a corporation have too much working capital?  Explain. A firm can have very much working capital if it is losing the opportunity to invest in high returning fixed assets and

Future value of a series of equal cash flows, Q. Future Value of a Series o...

Q. Future Value of a Series of Equal Cash Flows? Quite often a decision may result in the occurrence of cash flows of the same amount every year for a number of years consecuti

Explain the term- authorised and paid-up share capital, Explain the term- A...

Explain the term- Authorised and Paid-up Share Capital Number of shares of stock provided for in Articles of Association of a company is the authorized share capital. This figu

Explain the financial accounting techniques, Question 1: (a) Explain f...

Question 1: (a) Explain fully the following financial accounting techniques: i. Cash accounting ii. Accrual accounting iii. Fund accounting iv. B

Development of the market - t-bills, Development of the Market Until 19...

Development of the Market Until 1950s, T-Bills were issued by both the Central and State Governments and from 1950s, it is only the Central Government that is issuing Treasury

Illustrate dividend valuation model, Q. Illustrate dividend valuation model...

Q. Illustrate dividend valuation model? The business is being acquired as a going concern and earnings valuations rather than asset valuations are recommended. Even these are b

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