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

Capital budegting, SCL Limited a highly profitable company is engaged in th...

SCL Limited a highly profitable company is engaged in the manufacture of power intensive products.

State about the pest analysis, PEST analysis Political for instance...

PEST analysis Political for instance political culture, bureaucracy of regulating competition Economic for instance exchange rates, interest rates, taxation or busines

Describe the balance of payments identity, Describe the balance of payments...

Describe the balance of payments identity and discuss its implications under the fixed and flexible exchange rate regimes. Answer:  The balance of payments recognize holds that t

Pass-through vs. pay-through structures, In a pass-through structure,...

In a pass-through structure, each certificate holder will be allotted a proportion of the cash flow from the underlying pool of loans or receivables on a pro rat

Trading Options, TRADING IN OPTIONS We have already seen that options a...

TRADING IN OPTIONS We have already seen that options are traded on exchanges and have already discussed how to understand published quotations. Let us now learn the trading mec

Treasury bills, T-Bills are issued to enable the government to tide o...

T-Bills are issued to enable the government to tide over short-term liquidity requirements with maturities varying from a fortnight to a year. These instruments a

Cost-volume-profit models, Bennis Shafts produces three types of golf club ...

Bennis Shafts produces three types of golf club shafts which it sells to golf club manufacturers.  Prepare ONE worksheet to answer the following questions and to determine the outc

Function of the investment decision, Q. Function of the Investment decision...

Q. Function of the Investment decision? Investment decision related of the selection of the fixed assets. the assets can be acquired fall into two board groups i) long terms

Types of equity securities , Types of equaty Securities Equity securiti...

Types of equaty Securities Equity securities, traditionally, are classified into two types when they are issued. They are: Common Stock, and Preferred Stock.     Common Stoc

Discuss how a firm can maintain adequate working capital, Question1 Analys...

Question1 Analyse the financial requirements of a FMCG company Question2 If you are an investor and are interested in finding out the value of an amount of Rs 10,000 to be re

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