Study Note - 7: Capital Budgeting
Study Note - 7: Capital Budgeting
Study Note - 7: Capital Budgeting
CAPITAL BUDGETING
One of the important aspects of Financial Management is proper decision making in respect of investment
of funds. Successful operation of any business depends upon the investment of resources in such a way
as to bring in benefits or best possible returns from any investment. An investment can be simply defined
as an expenditure in cash or its equivalent during one or more time periods in anticipation of enjoying
a net inflow of cash or its equivalent in some future time period or periods. An appraisal of investment
proposals is necessary to ensure that the investment of resources will bring in desired benefits in future. If
the financial resources were in abundance, it would be possible to accept several investment proposals
which satisfy the norms of approval or acceptability. Since resources are limited a choice has to be
made among the various investment proposals by evaluating their comparative merit. It is apparent that
some techniques should be followed for making appraisal of investment proposals. Capital Budgeting
is one of the appraising techniques of investment decisions. Capital Budgeting is defined as the firm’s
decision to invest its current funds most efficiently in long term activities in anticipation of an expected
flow of future benefits over a series of years. It should be remembered that the investment proposal is
common both for fixed assets and current assets.
Capital budgeting decision may be defined as “Firms decisions to invest its current funds most efficiently
in long term activities in anticipation of an expected flow of future benefits over a series of year. The
firm’s capital budgeting decisions will include addition, disposition, modification and replacement of
fixed assets”.
Definitions: Charles. T.Horngreen defined capital budgeting as “Long term planning for making and
financing proposed capital out lay”.
According to Keller and Ferrara, “Capital Budgeting represents the plans for the appropriation and
expenditure for fixed asset during the budget period”.
Robert N. Anthony defined as “Capital Budget is essentially a list of what management believes to be
worthwhile projects for the acquisition of new capital assets together with the estimated cost of each
product”.
The selection of the most profitable project of capital investment is the key function of Financial Manager.
The decisions taken by the management in this area affect the operations of the firm for many years.
Capital budgeting decisions may be generally needed for the following purposes:
Capital Budgeting decisions are considered important for a variety of reasons. Some of them are the
following:
1) Crucial decisions: Capital budgeting decisions are crucial, affecting all the departments of the
firm. So the capital budgeting decisions should be taken very carefully.
2) Long-run decisions: The implications of capital budgeting decisions extend to a longer period in
the future. The consequences of a wrong decision will be disastrous for the survival of the firm.
3) Large amount of funds: Capital budgeting decisions involve spending large amount of funds. As such
proper care should be exercised to see that these funds are invested in productive purchases.
4) Rigid: Capital budgeting decision can not be altered easily to suit the purpose. Because of this
reason, when once funds are committed in a project, they are to be coutinued till the end, loss or
profit no matter.
The major steps in the capital budgeting process are given below. They are a) Generation of project;
b) Evaluation of the project; c) Selection of the project and d) Execution of the project. The capital
budgeting process may include a few more steps. As each step is significant they are usually taken by
top management.
Risk Return
Trade off
a) Generation of Project: Depending upon the nature of the firm, investment proposals can emanate
from a variety of sources. Projects may be classified into five categories.
(i) New products or expansion of existing products.
(ii) Replacement of equipment or buildings.
(iii) Research and development.
(iv) Exploration.
(v) Others like acquisition of a pollution control device etc.
Investment proposals should be generated for the productive employment of firm’s funds. However,
a systematic procedure must be evolved for generating profitable proposals to keep the firm
healthy.
b) Evaluation of the project: The evaluation of the project may be done in two steps. First the costs
and benefits of the project are estimated in terms of cash flows and secondly the desirability of
the project is judged by an appropriate criterion. It is important that the project must be evaluated
without any prejudice on the part of the individual. While selecting a criterion to judge the desirability
of the project, due consideration must be given to the market value of the firm.
c) Selection of the project: After evaluation of the project, the project with highest return should
be selected. There is no hard and fast rule set for the purpose of selecting a project from many
alternative projects. Normally the projects are screened at various levels. However, the final selection
of the project vests with the top level management.
d) Execution of project: After selection of a project, the next step in capital budgeting process is to
implement the project. Thus the funds are appropriated for capital expenditures. The funds are spent
in accordance with appropriations made in the capital budget funds for the purpose of project
execution should be spent only after seeking format permission for the controller. The follow – up
comparison of actual performance with original estimates ensure better control.
Thus the top management should follow the above procedure before taking acaital expenditure
decision.
The capital budgeting appraisal methods or techniques for evaluation of investment proposals will help
the company to decide the desirability of an investment proposal, depending upon their relative income
generating capacity and rank them in order if their desirability. These methods provide the company a
set of normal method should enable to measure the real worth of the investment proposal. The appraisal
methods should posses several good characteristics, which are mentioned as under.
Characteristics of a Sound Appraisal Method
(i) It should help the company to rank the investment proposals in order of their desirability.
(ii) It should provide a technique for distinguishing between an acceptable and non-acceptable
project.
(iii) It should provide a criteria to solve the problem of choosing among alternative projects.
(iv) It should recognize the importance of time value of money i.e. bigger benefits are preferable to
smaller ones and early benefits are preferable to later benefits.
(v) It should provide the criteria for the selection of investment proposals.
(vi) It should take into account the pattern of cash flows.
APPRAISAL METHODS
Traditional
Traditional TimeAdjusted
Time Adjustedoror
methods
Method Discounted Cash
Discounted cash
flow Techniques
flow Techniques
1.
1. Net
Net Present Value Method
Present Value Method
1. Pay
1. Pay back
Back period
Period 2.
2. Profitability IndexMethod
Profitability Index method
2. Accounting
2. Accounting or Average
of Average 3.
3. Internal Rate
rate of ofreturn
Return
Rate of Return
rate of return 4.
4. Modified InternalRate
Modified Internal rate of
of return
Return
5.
5. Discounted pay
Discounted Pay back
Backperiod
Period
(v) Failure in taking magnitude and timing of cash inflows: It fails to consider the pattern of cash inflows
i.e. the magnitude and timing of cash inflows.
2. Accounting or Average Rate of Return (ARR)
This technique uses the accounting information revealed by the financial statements to measure the
profitability of an investment proposal. It can be determined by dividing the average income after taxes
by the average investment. According to Soloman, Accounting Rate of Return can be calculated as
the ratio, of average net income to the initial investment.
On the basis of this method, the company can select all those projects whose ARR is higher than the
minimum rate established by the company. It can reject the projects with an ARR lower than the expected
rate of return. This method also helps the management to rank the proposal on the basis of ARR.
Average Net Income
Accounting Rate of Return (ARR) =
Original Investment
OR
Average Net Income
Accounting Rate of Return (ARR) =
Average Investment
Acceptance Rule:
The project which gives the highest rate of return over the minimum required rate of return is
acceptable
Merits: The following are the merits of ARR method:
(i) It is very simple to understand and calculate;
(ii) It can be readily computed with the help of the available accounting data;
(iii) It uses the entire stream of earnings to calculate the ARR.
Demerits: This method has the following demerits:
(i) It is not based on cash flows generated by a project;
(ii) This method does not consider the objective of wealth maximization;
(iii) It ignore the length of the projects useful life;
(iv) If does not take into account the fact that the profile can be re-invested; and
(v) It ignores the time value of money.
7.5.2 Discounted Cash Flow Techniques:
The discounted cash flow methods provide a more objective basis for evaluating and selecting an
investment project. These methods consider the magnitude and timing of cash flows in each period
of a project’s life. Discounted Cash Flows methods enable us to isolate the differences in the timing of
cash flows of the project by discounting them to know the present value. The present value can be
analyses to determine the desirability of the project. These techniques adjust the cash flows over the
life of a project for the time value of money.
The popular discounted cash flows techniques are:
(a) Net Present Value
(b) Internal Rate of Return, and
(c) Profitability Index
Time Value of Money:
The value of money received today is more than the value of money received after some time in the
future due to the following reasons:
7.6 I COST ACCOUNTING AND FINANCIAL MANAGEMENT
(i) Inflation: Under inflationary conditions the value of money expressed in terms of its purchasing
power over goods and services declines.
(ii) Risk: Having one rupee now is certain where as one rupee receivable tomorrow is less certain. That
is a bird-in-the-hand principle is most important in the investment decisions.
(iii) Personal Consumption Preference: Many individuals have a strong preference for immediate rather
than delayed consumption. The promise of a bowl of rice next week counts for little to the starving
man.
(iv) Investment Opportunities: Money like any other commodity has a price. Given the choice of `
1000/- now or the same account in one year time, it is always preferable to take ` 1000/- now,
because it could be invested over the next year @ 12% interest, to produce ` 1,120/- at the end of
year. If the risk-free rate of return in 12%, then you would be indifferent in receiving ` 1000/- now or
`1120/- in ones year’s time. In other words, the present value of `1120/- receivable one year hence
is `1000/-.
Present Value:
The value of a firm depends upon the net cash inflows generated by the firm assets and also on future
returns. The amount of cash inflows and risk associated with the uncertainty of future returns forms the
basis of valuation. To get the present value, cash inflows are to be discounted at the required rate of
return i.e., minimum rate expected by the investor to account for their timing and risk. The cash inflows
and outflows of an investment decision are to be compared at zero time period or at the same value
by discounting them at required rate of return. The following formula can be used to discount the future
inflows of a project to compare with its cash outflows.
C1 C2 C3 Cn
I= + + + fff
^1 + Kh1 ^1 + Kh2 ^1 + Kh3 ^1 + Khn
Where V0= Present value of cash inflows of the project during its life time.
C1, C2, ----Cn =Expected cash inflows of the project during its life time.
K =Discount rate.
n =Expected life of the project.
1. Net Present Value (NPV):
The net present value method is a classic method of evaluating the investment proposals. It is one of
the methods of discounted cash flow techniques, which recognizes the importance of time value of
money. It correctly postulates that cash flows arising at time periods differ in value and are comparable
only with their equivalents i.e. present values.
It is a method of calculating the present value of cash flows (inflows and outflows) of an investment
proposal using the cost of capital as an appropriate discounting rate. The net present value will be
arrived at by subtracting the present value of cash outflows from the present value of cash inflows.
According to Ezra Soloman, “it is a present value of the cast of the investment.”
Steps to compute net present value:
(i) Estimation of future cash inflows
(ii) An appropriate rate of interest should be selected to discount the cash flows. Generally, this will
be the “cost of capital” of the company, or required rate of return.
(iii) The present value of inflows and outflows of an investment proposal has to be computed by
discounting them with an appropriate cost of capital.
(iv) The net value is the difference between the present value of cash inflows and the present value
of cash outflows.
The formula for the net present value can be written as:
C1 C2 C3 Cn
NPV = + + + ff −I
^1 + Kh1 ^1 + Kh2 ^1 + Kh3 ^1 + Khn
Where
C = Annual Cash inflows,
Cn = Cash inflow in the year n
K = Cost of Capital
I = Initial Investment
Acceptance Rule:
If the NPV is positive or atleast equal to zero, the project can be accepted. If it is negative, the proposal
can be rejected. Among the various alternatives, the project which gives the highest positive NPV
should be selected.
NPV is positive = Cash inflows are generated at a rate higher than the minimum required by the firm.
NPV is zero = Cash inflows are generated at a rate equal to the minimum required.
NPV is negative = Cash inflows are generated at a rate lower than the minimum required by the firm.
The market value per share will increase if the project with positive NPV is selected.
The accept/reject criterion under the NPV method can also be put as:
NPV>Zero Accept
NPV<Zero Reject
NPV=0 May accept or reject
Merits: The following are the merits of the net present value (NPV) methods:
(i) Consideration to total Cash Inflows: The NPV methods considers the total cash inflows of investment
opportunities over the entire life-time of the projects unlike the payback period methods.
(ii) Recognition to the Time Value of Money: This methods explicitly recognizes the time value of money,
which is investable for making meaningful financial decisions.
(iii) Changing Discount Rate: Due to change in the risk pattern of the investor different discount rates
can be used.
(iv) Best decision criteria for Mutually Exclusive Projects: This Method is particularly useful for the selection
of mutually exclusive projects. It serves as the best decision criteria for mutually exclusive choice
proposals.
(v) Maximisation of the Shareholders Wealth: Finally, the NPV method is instrumental in achieving the
objective of the maximization of the shareholders’ wealth. This method is logically consistent with
the company’s objective of maximizing shareholders’ wealth in terms of maximizing market value
of shares, and theoretically correct for the selections of investment proposals.
Demerits: The following are the demerits of the net present value method:
(i) It is difficult to understand and use.
(ii) The NPV is calculated by using the cost of capital as a discount rate. But the concept of cost of
capital itself is difficult to understand and determine.
(iii) It does not give solutions when the comparable projects are involved in different amounts of
investment.
Decision criteria: If the Profitability Index is greater than or equal to one, the project should be accepted
otherwise reject.
Merits: The merits of this method are:
(i) It takes into account the time value of money
(ii) It helps to accept / reject investment proposal on the basis of value of the index.
(iii) It is useful to rank the proposals on the basis of the highest /lowest value of the index.
(iv) It takes into consideration the entire stream of cash flows generated during the life of the asset.
Demerits: However, this technique suffers from the following limitations:
(v) It is some what difficult to compute.
(vi) It is difficult to understand the analytical of the decision on the basis of profitability index.
3. Internal Rate of Return (IRR):
IRR method follows discounted cash flow technique which takes into account the time value of money.
The internal rate of return is the interest rate which equates the present value of expected future cash
inflows with the initial capital outlay. In other words, it is the rate at which NPV is equal zero.
Whenever a project report is prepared, IRR is to be worked out in order to ascertain the viability of the
project. This is also an important guiding factor to financial institutions and investors.
Formula:
A1 A2 A3 An
C= + + + ff
^1 + r h ^1 + r h2 ^1 + Kh3 ^1 + Rhn
Where
C = Initial Capital outlay.
A1, A2, A3 etc. = Expected future cash inflows at the end of year 1, 2, 3 and so on.
r = Rate of interest
n = Number of years of project
In the above equation ‘r’ is to be solved in order to find out IRR.
Computation of IRR
The Internal rate of return is to be determined by trial and error method. The following steps can be
used for its computation.
(i) Compute the present value of the cash flows from an investment, by using arbitrari by selected
interest rate.
(ii) Then compare the present value so obtained with capital outlay.
(iii) If the present value is higher than the cost, then the present value of inflows is to be determined
by using higher rate.
(iv) This procedure is to be continued until the present value of the inflows from the investment are
approximately equal to its outflow.
(v) The interest rate that bring about equality is the internal rate if return.
In order to find out the exact IRR between two near rates, the following formula is to be used.
P1 − C0
IRR = L+ ×D
P1 − P2
Where,
L = Lower rate of interest
P1 = Present value at lower rate of interest
P2 = Present value at higher rate of interest
Co = Cash outlay
D = Difference in rate of interest
Acceptance Rule
If the internal rate of return exceeds the required rate of return, then the project will be accepted. If the
project’s IRR is less than the required rate of return, it should be rejected. In case of ranking the proposals
the technique of IRR is significantly used. The projects with highest rate of return will be ranked as first
compared to the lowest rate of return projects.
Thus, the IRR acceptance rules are
Accept if IRR > k
Reject if IRR < k
May accept or reject if IRR = k
Where
K is the cost of capital.
MERITS
The following are the merits of the IRR method:
(i) Consideration of Time of Money: It considers the time value of money.
(ii) Consideration of total Cash Flows: It taken into account the cash flows over the entire useful life of
the asset.
(iii) Maximising of shareholders’ wealth: It is in conformity with the firm’s objective of maximizing owner
welfare.
(iv) Provision for risk and uncertainty: This method automatically gives weight to money values which
are nearer to the present period than those which are distant from it. Conversely, in case of other
methods like ‘Payback Period’ and ‘Accounting Rate of Return’, all money units are given the same
weight which is unrealistic. Thus the IRR is more realistic method of project valuation. This method
improves the quality of estimates reducing the uncertainty to minimum.
(v) Elimination of pre-determined discount rate: Unlike the NPV method, the IRR method eliminates
the use of the required rate of return which is usually a pre-determined rate of cost of capital for
discounting the cash flow consistent with the cost of capital. Therefore, the IRR is more reliable
measure of the profitability of the investment proposals.
(iii) NPV assumes that intermediate cash flows are reinvested at firm’s cost of capital. The reinvestment
assumption of NPV is more realistic than IRR method.
But IRR method is favoured by some scholars because:
(i) It is easier to visualize and to interpret as compared to NPV.
(ii) Even in the absence of cost of capital, IRR gives an idea of project’s profitability.
Note:
Unless the cost of capital is known, NPV cannot be used.
(iii) IRR method is preferable to NPV in the evaluation of risky projects.
6. Modified Internal Rate of Returns (MIRR)
IRR assumes that interim positives cash flows are reinvested at the rate of returns as that of the project
that generated them. This is usually an unrealistic scenario.. To overcome this draw back a new
technique emerges. Under MIRR the earlier cash flows are reinvested at firm’s rate of return and finding
out the terminal value. MIRR is the rate at which present value of terminal values equal to outflow
(Investment).
The procedure for calculating MIRR is as follows:
Step I: Calculate the present value of the costs (PVC) associated with the project, using cost of capital
(r) as the discount rate.
Cash outflowt
PVC = / n
^1 + r ht
t=0
Step 2: Calculate the future value (FV) of the cash inflows expected from the project:
FV = / t = 0 Cash outflowt ^1 + r h
n n-t
Illustration 2
A limited company is considering investing a project requiring a capital outlay of ` 2,00,000. Forecast
for annual income after depreciation but before tax is as follows:
Year `
1 1,00,000
2 1,00,000
3 80,000
4 80,000
5 40,000
Depreciation may be taken as 20% on original cost and taxation at 50% of net income.
You are required to evaluate the project according to each of the following methods:
(a) Pay-back method
(b) Rate of return on original investment method
(c) Rate of return on average investment method
(d) Discounted cash flow method taking cost of capital as 10%
(e) Net present value index method
(f) Internal rate of return method.
(g) Modified internal rate of return method.
Solution:
Working Notes:
Year Profit Profit Cash inflows Cumulative Discounting Present Discounting Present Discounting Present Discounting Present
before after tax after tax [PAT cash factor @ Value factor @ value factor @ Value factor @ 32% value
tax @ 50% + Dep] inflows 10% 20% @20% 30% @30% @32%
1 1,00,000 50,000 90,000 90,000 0.9091 81,819 0.8333 74,997 0.7692 69,228 0.7576 68,184
2 1,00,000 50,000 90,000 1,80,000 0.8264 74,376 0.6944 62,496 0.5917 53,253 0.5739 51,651
3 80,000 40,000 80,000 2,60,000 0.7513 60,104 0.5787 46,296 0.4552 36,416 0.4348 34,784
4 80,000 40,000 80,000 3,40,000 0.6830 54,640 0.4823 38,584 0.3501 28,008 0.3294 26,352
5 40,000 20,000 60,000 4,00,000 0.6209 37,254 0.4019 24,114 0.2693 16,158 0.2495 14,970
3,08,193 2,46,487 2,03,063 1,95,941
(a) Pay Back Method:
Pay back period = 2 + 20,000/80,000
= 2.25 years (or) 2 years 3 months
(b) Rate of Return on Original Investment Method.
ARR = Average Profit after Tax / Investment x 100
= 40,000 / 2,00,000 x 100
= 20%
(c) Rate of Return on Average Investment Method
ARR = Average Profit after tax / Average investment x 100
= 40,000 / [2,00,000 + 0/2] x 100
= 40%
1 2 3 4 5 Total
Cash inflow after tax 90,000 90,000 80,000 80,000 60,000 --
Re-investment period 4 3 2 1 0
Re-investment at 10% 10% 10% 10% 10%
Future value factor (1.1)4 (1.1)3 (1.1)2 (1.1) 1
Future value 1,31,769 1,19,790 96,800 88,000 60,000 4,96,359
At MIRR = 2,00,000 [1 + MIRR] = 4,96,359
5
The cost of capital is 14% and the P.V. Factors for each of the five years respectively are 0.877, 0.769,
0.675, 0.592 and 0.519.
State whether the company should replace Model A machine by installing the Super Model machine.
Will there be any change in your decision if the Model A machine has not been installed and the
company is in the process of consideration of selection of either of the two models of the machine?
Present suitable statement to illustrate your answer.
Solution:
A) Appraisal of replacement decision under NPV method
Step 1:
Calculation of Present value of net cash outflow or net investment required.
Cost of super model 1,50,000
Less: Sale proceeds of Model A 50,000
(-) Cost of removal 10,000 40,000
Net investment required 1,10,000
Step 2:
Calculation of present value of incremental operating cash flows:
Step 3:
Calculation of PV of terminal cash inflow – NIL
Step 4:
Calculation of NPV `
PV of total cash inflow = 2,40,310
[2,40,310 + 0]
Less: Outflow = 1,50,000
Net Present Value (under alternative II) = 90,310
Comment:
As NPV of Super Model is more [`. 90,310] than that of Model A [`. 71,650], it is advised to Select
Super Model.
Illustration 4
Techtronics Ltd., an existing company, is considering a new project for manufacture of pocket video
games involving a capital expenditure of `.600 lakhs and working capital of `.150 lakhs. The capacity of
the plant is for an annual production of 12 lakh units and capacity utilisation during the 6-year working
life of the project is expected to be as indicated below.
Illustration 5
A chemical company is considering replacing an existing machine with one costing `65,000. The
existing machine was originally purchased two years ago for `28,000 and is being depreciated by the
straight line method over its seven-year life period. It can currently be sold for `30,000 with no removal
costs. The new machine would cost `10,000 to install and would be depreciate over five years. The
management believes that the new machine would have a salvage value of `5,000 at the end of year
5. The management also estimates an increase in net working capital requirement of `10,000 as a result
of expanded operations with the new machine. The firm is taxed at a rate of 55% on normal income and
30% on capital gains. The company’s expected after-tax profits for next 5 years with existing machine
and with new machine are given as follows:
`
Expected after-tax profits
Year With existing machine With new machine
1 2,00,000 2,16,000
2 1,50,000 1,50,000
3 1,80,000 2,00,000
4 2,10,000 2,40,000
5 2,20,000 2,30,000
a) Calculate the net investment required by the new machine.
b) If the company’s cost of capital is 15%, determine whether the new machine should be
purchased.
Solution:
Appraisal of replacement decision under NPV method
Step 1:
Calculation of present value of net investment required: `
Cost of new asset 65,000
Add: Installation cost 10,000
75,000
Add: Additional WC 10,000
85,000
Less: Sale proceeds of old machine 30,000
Less: Tax 5,000
[8,000 x 55/100 + 2000 x 30/100] 25,000
Net Investment required 60,000
Step 2:
Calculation of Present Value of Incremental Operating cash inflows for 5 years.
Year CIAT New Incremental PV factor at Present Value
(PAT + Dep) 15%
1 2,04,000 2,30,000 26,000 0.8696 22,609
2 1,54,000 1,64,000 10,000 0.7561 7,561
3 1,84,000 2,14,000 30,000 0.6575 19,725
4 2,14,000 2,54,000 40,000 0.5718 22,872
5 2,24,000 2,44,000 20,000 0.4972 9,944
PV of cash inflows for 5 years 82,711
Depreciation for new Machine 65, 000 + 10, 000 - 5, 000 = ` 14,000
5
Illustration 6
A Company is considering two mutually exclusive projects. Project K will require an initial cash investment
in machinery of ` 2,68,000. It is anticipated that the machinery will have a useful life of ten years at the
end of which its salvage will realise `20,500. The project will also require an additional investment in cash,
Sundry debtors and stock of `40,000. At the end of five years from the commencement of the project
balancing equipment for `45,000 has to be installed to make the unit workable. The cost of additional
machinery will be written off to depreciation over the balance life of the project. The project is expected
to yield a net cash flow (before depreciation) of `1,00,000 annually.
Project R, which is the alternative one under consideration, requires an investment of `3,00,000 in
machinery and as in Project K investment in current assets of `40,000. The residual salvage value of the
machinery at the end of its useful life of ten years is expected to be `25,000. The annual cash inflow
(before depreciation) from the project is worked at `80,000 p.a. for the first five years and `1,80,000 per
annum for the next five years.
Depreciation is written off by the Company on sum-of-the years’ digits method, (i.e., if the life of the
asset is 10 years, then in the ratio of 10,9,8 and so on). Income tax rate is 50%. A minimum rate of return
has been calculated at 16%. The present value of Re. 1 at interest of 16% p.a. is 0.86, 0.74, 0.64, 0.55,
0.48, 0.41, 0.35, 0.30, 0.26 and 0.23 for years 1 to 10 respectively.
Which Project is better? Assuming no capital gains taxes, calculate the Net Present Value of each
Project.
Solution:
Appraisal of mutually exclusive decision under NPV method
Alternative 1: Project K
Calculation of NPV under alternative I
Step 1:
Calculation of present value of cash outflow `
Cost of machine at (t0) (2,68,000 x 1) = 2,68,000
Additional working capital at (t0) [40,000 x 1] = 40,000
PV of additional asset at (t5) [45,000 x 0.48] = 21,600
PV of total cash outflow = 3,29,600
Step 2:
Calculation of PV of operating cash inflows for 10 years `
Year Cash profit before tax Dep PBT PAT at 50% CIAT PV factor at 16% PV
1 80,000 50,000 30,000 15,000 65,000 0.86 55,900
2 80,000 45,000 35,000 17,500 62,500 0.74 46,250
3 80,000 40,000 40,000 20,000 60,000 0.64 38,400
4 80,000 35,000 45,000 22,500 57,500 0.55 31,625
5 80,000 30,000 50,000 25,000 55,000 0.48 26,400
6 1,80,000 25,000 1,55,000 77,500 1,02,500 0.41 42,025
7 1,80,000 20,000 1,60,000 80,000 1,00,000 0.35 35,000
8 1,80,000 15,000 1,65,000 82,500 97,500 0.30 29,250
9 1,80,000 10,000 1,70,000 85,000 95,000 0.26 24,700
10 1,80,000 5,000 1,75,000 87,500 92,500 0.23 21,275
3,50,825
Step 3:
Calculation of PV of terminal cash inflows
`
Scrap value = 25,000
WC = 40,000
= 65,000
Its PV = 65,000 x 0.23 = 14,950
Step 4:
`
PV of total cash inflows = 3,65,775
[3,50,825 + 14,950]
Less: Outflow = 3,40,000
NPV = 25,775
Comment:
Project R is better compared to project K because it has higher NPV.
Illustration 7
A product is currently manufactured on a machine that is not fully depreciated for tax purposes and
has a book value of `70,000. It was purchased for `2,10,000 twenty years ago. The cost of the product
are as follows:
Unit Cost
Direct Labour `28.00
Indirect labour 14.00
Other variable overhead 10.50
Fixed overhead 17.50
70.00
In the past year 10,000 units were produced. It is expected that with suitable repairs the old machine
can be used indefinitely in future. The repairs are expected to average ` 75,000 per year.
An equipment manufacturer has offered to accept the old machine as a trade in for a new equipment.
The new machine would cost `4,20,000 before allowing for `1,05,000 for the old equipment. The Project
costs associated with the new machine are as follows:
Unit Cost
Direct Labour `14.00
Indirect labour 21.00
Other variable overhead 7.00
Fixed overhead 22.75
64.75
The fixed overhead costs are allocations for other departments plus the depreciation of the equipment.
The old machine can be sold now for `50,000 in the open market. The new machine has an expected life
of 10 years and salvage value of `20,000 at that time. The current corporate income tax rate is assumed
to be 50%. For tax purposes cost of the new machine and the book value of the old machine may be
depreciated in 10 years. The minimum required rate is 10%. It is expected that the future demand of the
Comment:
Since NPV is positive, it is advised to replace the machine.
Note:
Since the exchange value is greater than open market value, the open market value is irrelevant.
Illustration 8
Electromatic Excellers Ltd. specialise in the manufacture of novel transistors. They have recently
developed technology to design a new radio transistor capable of being used as an emergency lamp
also. They are quite confident of selling all the 8,000 units that they would be making in a year. The
capital equipment that would be required will cost `.25 lakhs. It will have an economic life of 4 years
and no significant terminal salvage value.
During each of the first four years promotional expenses are planned as under:
`
1st Year 1 2 3 4
Advertisement 1,00,000 75,000 60,000 30,000
Others 50,000 75,000 90,000 1,20,000
Variable cost of production and selling expenses: `250 per unit
Additional fixed operating costs incurred because of this new product are budgeted at `.75,000 per
year.
The company’s profit goals call for a discounted rate of return of 15% after taxes on investments on new
products. The income tax rate on an average works out to 40%. You can assume that the straight line
method of depreciation will be used for tax and reporting.
Work out an initial selling price per unit of the product that may be fixed for obtaining the desired rate
of return on investment.
Present value of annuity of Re. 1 received or paid in a steady stream throughout 4 years in the future
at 15% is 3.0079.
Solution:
Calculation of Selling Price
Let x be the selling price.
Evaluation under NPV method
Step 1:
Initial Investment = 25,00,000
Step 2:
PV of operating cash inflows per annum
A. Sales p.a. = 8,000 X
B. Expenses
Depreciation [(25,00,000 – 0) / 4] = 6,25,000
Promotion Expenses = 1, 50,000
Variable costs = 20, 00,000
Fixed costs = 75,000
`28,50,000
Comment:
It is advised to select alternative II as it involves lower cash outflows.
Illustration 10
Following are the data on a capital project being evaluated by the management of X Ltd.:
Project M
Annual cost saving ` 40,000
Useful life 4 years
I.R.R 15%
Profitability Index (PI) 1.064
NPV ?
Cost of capital ?
Cost of project ?
Pay back ?
Salvage value 0
Find the missing values considering the following table of discount factor only:
X Y
NPV at 12% II I
NPV at 18% Same Same
IRR I II
ARR II I
Pay back I II
PI I II
Decision:
1. As the outlays in the projects are different, NPV is not suitable for evaluation.
2. As there is different life periods, ARR is not appropriate method for evaluation.
On the basis of remaining evaluation methods [IRR, PBP, PI] Project X is occupied first priority. Hence, it
is advised to choose project X.
Year 1 2 3 4 5
Estimated Cash flow before depreciation and tax (` Lakhs) 4 6 8 8 10
You are required to determined the:
i) Pay back period for the investment
ii) Average rate of return on the investment
iii) NPV at 10% cost of capital
iv) Benefit – Cost Ratio
Ans:
i) Pay back period = 3 years 10 months
ii) ARR = 16%
iii) NPV = ` 0.717 lakhs
iv) Benefit Cost Ratio = 1.036
5. Indo Plastics Ltd. is a manufacturer of high quality plastic products, Rasik, President, is considering
computerizing the company’s ordering, inventory and billing procedures. He estimates that the
annual savings from computerization include a reduction of 4 clerical employees with annual salaries
of ` 50,000 each, ` 30,000 from reduced production delays caused by raw materials inventory
problems ` 25,000 from lost sales due to inventory stock outs and ` 18,000 associated with timely
billing procedures.
The purchase price of the system is ` 2,50,000 and installation costs are ` 50,000. These outlays will
be capitalized (depreciated) on a straight line basis to a zero books salvage value which is also
its market annual salaries of ` 80,000 per person. Also annual maintenance and operating (cash)
expenses of ` 22,000 are estimated to be required. The company’s tax rate is 40% and its required
rate of return (cost of capital) for this project is 12%.
You are required to:
i) Evaluate the project using NPV method.
ii) Evaluate the project using PI method
iii) Calculate the Project’s payback period.
(` Lakhs)
Particulars A B
Investment required 100 90
Average annual cash inflow before depreciation and tax (estimate) 28 24
Salvage value: Nil for both projects. Estimate life – 19 years for both projects.
The company follows straight line method of charging depreciation. Its tax rate is 50%.
You are required to calculate i) Payback period and ii) IRR for the 2 projects.
Note: P.V of an annuity of Re. 1 for ten years at different discount rate is given below:
Rate % 10 11 12 13 14
Annuity Value of return 6.1446 5.8992 5.6502 5.462 5.2161 5.01
Ans:
Project A Project B
i) Payback period 5.26 years 5.45 years
ii) IRR 13.78% 12.89%
7. Precision Instruments is considering two mutually exclusive Projects X and Y. The following details
are made available to you:
(` Lakhs)
Particulars Project X Project Y
Project Cost 700 700
Cash inflows: Year 1 100 400
Year 2 200 400
Year 3 300 200
Year 4 450 100
Year 5 600 100
Total 1,650 1,300
Assume no residual values at the end of the fifth year. The firm’s cost of capital is 10%. Required, in
respect of each of the two projects: i) Net present value, using 10% discounting, ii) Internal rate of return
iii) profitability Index.
Ans:
Project X Project Y
i) NPV 461.35 lakhs 365.5 lakhs
ii) IRR 27.21% 37.63%
iii) PI 1.659 1.522
8. XYZ Ltd. has decided to diversity its production and wants to invest its surplus funds on the most
profitable project. It has under consideration only two projects. ‘A’ and ‘B’. The cost of project ‘A’
is ` 100 lakhs and that of ‘B’ is ` 150 lakhs. Both projects are expected to have a life of 8 years only
and at the end of this period ‘A’ will have a salvage value of ` 4 lakhs and ‘B’ ` 14 lakhs. The running
expenses of ‘A’ will be ` 35 lakhs per year and that of ‘B’ ` 20 lakhs per year. In either case the
company expects a rate of return of 10%. The company’s tax rate is 50%. Depreciation is charged
on straight line basis. Which project should the company take up?
Note: Present value of annuity of Re. 1 for eight years at 10% is 5.335 and present value of Re.1
received at the end of the eighth year is 0.467.
Ans: NPV of Project A = ` 19.238 lakhs; Project B = ` 27.258 lakhs