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

Calculate the confidence interval of returns, Following are return expectat...

Following are return expectations on the S&P 500 index for the upcoming year with the corresponding probabilities: Expectation                                   Return

Market-based versus bank-based financial systems, What do you meant by mark...

What do you meant by market-based and bank-based financial systems? Market-based versus bank-based financial systems implications. The presence of market-based and bank-base

Create a financial institution’s balance sheet, Question. 1 Using D to...

Question. 1 Using D to assess the interest rate risk of a financial institution's balance sheet Background: Point 1. A business is 'insolvent' when it has negative eq

Assignment, Discuss the applicability ofan operating cycle in a poultry bus...

Discuss the applicability ofan operating cycle in a poultry business(consider broilers)

Dividend policies, explain for factors influencing design for dividend poli...

explain for factors influencing design for dividend policies

What is indirect method, What is Indirect method Indirect method is wha...

What is Indirect method Indirect method is what you would probably be familiar with. It requires a lot less information to produce it and hence can be argued to be easier metho

Role depreciation play in calculating incremental cash flows, What role doe...

What role does depreciation play in calculating incremental cash flows? Depreciation expense is a tax deductible expense and hence influences cash flow by its effect on taxes.Dep

Claim for refund, Claim for Refund - A refund isn't automatically mailed if...

Claim for Refund - A refund isn't automatically mailed if one is due. A taxpayer whether individual orbusiness, should file a request on a form. It should also be filed within the

Case study.., This case has been framed in order to test the skills in eval...

This case has been framed in order to test the skills in evaluating a credit request and reaching a correct decision. Perluence International is large manufacturer of petroleum and

When they analyze pro forma financial statements, What do financial manager...

What do financial managers look for when they analyze pro forma financial statements? After the pro forma financial statements are finished, financial managers examine the

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