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

How is finance related to accounting and economics, How is finance related ...

How is finance related to the disciplines of accounting and economics? Financial management is fundamentally a combination of economics and accounting. First financial managers

Define a sunk cost, What is a sunk cost?  Is it relevant while evaluating a...

What is a sunk cost?  Is it relevant while evaluating a proposed capital budgeting project?  Explain. A sunk cost is a cash flow which has previously occurred, or that will take

Corporate debt, which critically examines the benefits and risks to a compa...

which critically examines the benefits and risks to a company, of incorporating corporate debt into a portfolio of equity and debt.

What are the main flaws of the profit maximisation criterion, What are the ...

What are the main flaws of the profit maximisation criterion The main technical flaws of this criterion are i) ambiguity, ii) quality of benefits and iii) timing of be

State the terms- stock and share, Explain the terms- Stock and  Share ...

Explain the terms- Stock and  Share Stock Ownership of a company represented by shares that are a claim on the company's earnings and assets. Share Unit of equity

Exchange requirements-, Exchange Requirements To ensure money supply, s...

Exchange Requirements To ensure money supply, some central banks require some or all of its foreign exchange receipts (generally from exports) be exchanged for the local curren

Is it possible to make money in the stock market, Is it possible to make mo...

Is it possible to make money in the stock market when the quotations are going down? What is credit sale? There are three simple moves to make money when prices are going down:

Explain adjustments necessary to translate enterprise value, Explain the ad...

Explain the adjustments necessary to translate enterprise value to the total present value of common equity. To gain the value of the company's common stock add the value of th

Foreign exchange market equilibrium, Foreign Exchange Market Equilibrium: ...

Foreign Exchange Market Equilibrium: We say that the foreign exchange market is in equilibrium when deposits of all currencies o er the same expected rate of return (when retu

Equity method of accounting, Q. Equity Method of Accounting? Equity Met...

Q. Equity Method of Accounting? Equity Method of Accounting - Investors cost basis is adjusted up or down (according to the % of stock ownership) as investee's retained earning

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