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

Yield spread measures for floating-rate securities, In a floating rat...

In a floating rate security, the coupon rate changes periodically as per the reference rate. The yield to maturity of floating rate securities cannot be calculated as

Why total assets equal the sum of total liabilities & equity, Why do total ...

Why do total assets equal the sum of total liabilities and equity?Explain. Assets = Liabilities + Equity Assets are the entities of value a business owns. Liabilities ar

Case let 2, how would you judge the potential profit of Bajaj Electronics o...

how would you judge the potential profit of Bajaj Electronics on the first year of sales to booth plastice and give your views to to increase the profit

State the significance of the cost of capital, State the Significance of th...

State the Significance of the Cost of Capital It must be recognized at the outset that cost of capital is one of the most difficult and disputed topics in the finance theory.

What are the benefits as well as costs of holding inventory, Q. What are th...

Q. What are the benefits as well as costs of holding inventory? What is Inventory? What are the benefits as well as costs of holding inventory? Ans. Inventory: - Every enter

Strategic investment and decision-making, Carr, C., Kolehmainen, K. and Mit...

Carr, C., Kolehmainen, K. and Mitchell, F. (2010) ‘Strategic investment decision-making practices: a contextual approach', Management Accounting Research, 21, 167-84. (a) What a

Return on common equity finance basics, At the end of the fiscal year endin...

At the end of the fiscal year ending June 30, 2003, Microsoft reported common equity of $64.9 billion on its balance sheet, with $49.0 billion invested in financial assets (in the

Explain the three kind’s non-financial incentives, Q. Explain the three kin...

Q. Explain the three kind’s non-financial incentives? Non-Financial incentives: Incentives which cannot be offered in terms of money are known as non-¬financial incentives. Ind

Case study - japanese loans and forwards, Japanese banks borrow in yen and ...

Japanese banks borrow in yen and purchase spot dollars from their Western counterparties. Therefore the Western banks are left holding the yen for the time of the loan (three month

No title, discuss the steps in the controlling process

discuss the steps in the controlling process

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