CHAPTER 4

Project Appraisal

After going through this chapter, you should be able to

Identify various techniques of project appraisal

Appreciate the difference between traditional and modern techniques

Understand the importance of discounting of cash flows under modern techniques

Appreciate the differences and commonalities in the modern techniques

Oversee the computation of IRR

Appreciate the limitations of IRR/BCR/NPV

Understand the modified PBP and modified IRR

Appreciate examples of some projects and project management practice

Key Terms: Appraisal techniques, Cash flows, Discounting, Payback Period, NPV, Benefit Cost Ratio, IRR, Modified Payback period, Modified IRR, Cost of Capital

Having formulated the project proposal giving all details of the project as discussed in the previous chapter, let us examine the viability of the project, that is, its financial viability. This is a two-step exercise:

 i. Estimation of cash flows—inflows and outflows (refer Illustrations 3.1 & 3.2 in the previous chapter)

Cash outflows are project cost, while cash inflows are PAT + depreciation + interest.

ii. Evaluation of cash flows for various projects: This is with an objective to select a project that is economically viable and yields maximum return on investment. For the purpose, various techniques are used for analysis of the cash flows.

A word of caution while using various techniques:

There is no one best technique.

Every technique has some strong point.

In that respect, management judgment is supreme, and there is no substitute for decision making to select a project.

Man is the principal syllable in management

C.T. McKenzie

Various techniques1 for project appraisal techniques include

Ranking by inspection

Accounting rate of return (ARR)

Payback period (PBP)

Net present value (NPV)

Benefit–cost ratio (BCR) or Profitability Index (PI)

Adjusted payback period (PBP Adj.)

Internal rate of return (IRR)

Modified internal rate of return (MIRR)

Economic rate of return (ERR)

First three techniques are termed as traditional techniques, while the others are called modern techniques. The last one is a technique for economic appraisal for macro-level projects.

The above techniques are illustrated in the following pages.

Exhibit 4.1

Ranking by Inspection

Ranking by Inspection

Projects are ranked by looking at the inflows and outflows for various projects. Such ranking is merely by personal judgment and is not a systematic one. To illustrate, of the four projects in Exhibit 4.1, ranking is by comparing the inflows and outflows and as such between the two projects A and B, rankings are 2,1 and between projects C and D rankings are 2, 1.

Such ranking is crude one, is on personal judgment, and is not systematic and not followed by banks and financial institutions.

Accounting Rate of Return (ARR)

Accounting profits are used as the basis of appraisal. Profits of a project are related with the investment of the project and a project with higher profit rate is selected. It is calculated as

ARR = Profit for the year/investment × 100

where profit = PAT;

investment is average (Avg.) investment, that is, investment adjusted for annual depreciation.

So,

ARR = Avg. PAT/Avg. investment × 100

where Avg. profit is the average of profits at the beginning and end of the yearly profit for the project and Avg. investment is investment adjusted for depreciation for the year.

ARR for a project is compared with the cost of capital or the borrowing rate to ascertain whether the project is acceptable. If the ARR is more than cost of capital, the project is considered feasible.

Cost of capital is the cost of funds deployed in the project; it is the minimum return expected from the project. In case of different sources of financing such as equity and debt, it is the average cost for the various sources. As discussed latter, it is also known as the discount rate or hurdle rate.

Decision Rules:

ARR = Avg. PAT/Avg. investment × 100

Accept a project when ARR >cost of capital

Among number of projects having ARR greater than cost of capital, accept a project with the highest ARR.

ARR has the following positive points:

+ Easy to understand

+ Considers profits for the entire life of project

ARR has the following negative points:

Based on accounting information and not on cash flows

Does not consider time value of money

The value of data is directly related to their timeliness

Not conceptually sound as PAT is after interest, depreciation, and tax, while investment comprises of equity as well as debt, so there is inconsistency in its computation

ARR is a good accounting measure but not a technique for project appraisal.

For illustrations in the previous chapter, ARR will be as under:

Illustration I (for Illustration 3.1)

Avg. profit/Avg. investment

1/5 (3,000 + 3,000 + 3,000 + 3,000 + 3,000)/

1/6 (30,000 + 25,000, + 20,000 + 15,000 + 10,000 + 5,000) = 17.14%

Illustration II (for illustration 3.2)

ARR = Avg. PAT/Avg. investment = 32%

Payback Period (PBP)

Payback period represents period within which annual inflows from the project are sufficient to recover investment.

So,

PBP = Investment/annual inflows

where annual inflows are uniform over the years.

Where inflows are not uniform over the years, cumulative cash flows are calculated to see the years within which cumulative inflows are adequate to recover investment.

Decision Rule:

Accept a project with lowest payback period

For Illustrations in the previous chapter, PBP will be as under:

Illustration I = 3 years

Illustration II = 2.5 years

PBP has the following strong points:

+ Simple and commonly used

+ Considers projects of shorter recovery period and so risk is taken care of

+ Emphasizes on liquidity

+ A useful, quick, preliminary screening device if sophisticated analysis is worth

PBP suffers from the following shortcomings:

Considers only a part of inflows

Ignores time value of money

Not a profitability measure

As mentioned earlier, ARR and PBP are also known as traditional methods of appraisal

(refer illustrations in Chapter 5).

Discounted Cash Flows Methods

These are methods which discount inflows and outflows for time as they occur at different time intervals. These methods are

Net present value (NPV)

Benefit–cost ratio (BCR) or Profitability Index (PI)

Adjusted payback period (PBP Adj.)

Internal rate of return (IRR)

Modified IRR (MIRR)

The above methods are also known as modern methods of project appraisal.

Before we discuss the modern methods of appraisal, let us discuss, in brief, the concept of discounting and time value of money.

Discounted Cash Flows: Principles

Discounting of cash flows is also known as ascertainment of present value of the cash flows expected over the years; it is reciprocal of compounding.

To illustrate:

Consider compounding of cash inflows for time @10%, as under:

0 yr. . .. . .. . ..-.. -- → yr 1 . . .. . .. . .. . .. . .---- yr 2

Rs. 100 = ---becomes ... Rs. 110 = ---becomes--- Rs. 121 at the end of year 2.

As Rs. 100 deposited in a bank in year “0” becomes Rs. 110 at the end of year “1,” it also becomes Rs. 121 at the end of year “2.”

Looking the other way, discounted cash flows for time at 10% are as under:

Rs. 121 at the end of year 2 = Rs.110 at the end of year 1, or Rs. 100 at year 0

Rs. 100 = ←--. . .. . -Rs. 110 = ←. . .. . ..---- Rs. 121

where 10% is assumed as discount rate

As mentioned earlier, discount rate is the cost of raising funds for the project. It is the average cost of raising funds from different sources, and is also known as “Cost of Capital” or “cutoff rate”

Time Value of Money: Principles

Compounding” is a process of ascertaining value in future (FV) from the present value (PV) at a certain rate,

that is, ascertainment of value in second year from the value in year“0” at a certain rate

Whereas “Discounting” is a process of ascertaining PV from future value (FV) at a certain rate,

that is, ascertain value at present from the value in future years

So discounting is the reciprocal of compounding

Time Value of Money

Time is a great teacher but unfortunately it kills all its pupils

Time” is important in time value analysis

Time Line:

*-. . .*-. . . . .*--. . . .*--. . . . .*----. . . . . . . . . .

01yr2yr3 yr4yr5yr

Rs. 100 today at time “0” becomes 110 at time yr 1 end,

i.e., {100 + 10% (100)} = 110; or

{100 × (1 + 0.10)}, or

becomes 121 at time yr2 end, i.e., {110 + 10% (110)} = 121;

or {110 × (1 + 0.10)}, or

becomes 133.1 at time yr 3 end, i.e., {121 + 10% (121)} = 133.1;

or {121 × (1 + 0.10)}

Having discussed the concept of discounting because of time, let us discuss the discounting methods of project appraisal.

Net Present Value (NPV)

NPV == PV of inflows less PV of outflows, in rupee terms, that is,

NPV == PV (I) – PV (O)

where

NPV is net present value,

PV (I) is present value of inflows, and

PV (O) is present value of outflows, at a certain rate.

Decision RuleGo--No-Go

Go, when NPV is (“positive” or +)

No-Go, when NPV is (“negative” or)

Prefer a project with highest NPV

(See Illustrations IV and V in the next chapter.)

Benefit–Cost Ratio (BCR) or Profitability Index (PI)

In computation,

BCR = PV (I)/PV (O), a ratio

where PV(I) = present value of inflows at a discount rate and

PV(O) = present value of outflows at a discount rate

BCR is similar to NPV and uses the same information, where NPV is in rupees, while BCR is a ratio.

Decision Rule:

Reject a project with BC ratio < 1

Accept a project with BC ratio > 1

Prefer a project with higher BC ratio >1

Computation of NPV and BCR is illustrated for two projects A and B in Exhibit 4.2.

Exhibit 4.2

  Project A Project B
Project cost Rs. 25,000 Rs. 25,000
Inflows Uniform Rs. 10,000 pa Rs. 5,000 pa for first 4 years and Rs. 25,000 in the fifth year
Project life 5 years 5 years
Discount rate 10% 10%

Outflows reflected by () – Inflows reflected by +

Of the two projects A and B, at discount rate of 10% Project A has positive NPV greater than that of Project B so accept Project A.

Similarly Project A has greater BCR so accept Project A.

NPV and BCR—Comparison—illustrated below

 

NPV

BC Ratio

Information needed:

Inflows

Inflows

Outflows

Outflows

Life

Life

Discount rate

Discount rate

Information obtained

NPV (Rs.)

Ratio

Decision rule

Go–No-Go

No-Go when NPV (—)
Reject

Go When NPV (+)
Accept

Prefer a project with highest (+) NPV

Go–No-Go

No-Go when, BCR < 1
Reject

Go when, BCR > 1
Accept

Prefer a project with highest BCR

where discount rate is the cost of raising funds.

From the comparison of NPV and BCR for the four projects in Exhibit 4.3, one finds that

NPV and BCR both give the same result when projects are of equal size.

Exhibit 4.3

NPV and BCR Computation—Illustration where Projects are of equal size of Rs. 25,000 each

  Project A Project B Project C Project D
PV (I)  37,900  31,370  25,000     23,000
PV (O)  25,000  25,000  25,000     25,000
NPV  12,900    6,370           0 (–) 2,000
BCR      1.51      1.25      1.00         0.92
Project ranking NPV   First rank Second rank Indifferent      Reject
Project ranking BCR   First rank Second rank Indifferent      Reject

Comparison of NPV and BCR when projects are of different sizes, that is, projects A, B, C, and D have size of Rs. 25,000 each while project E has a size of Rs. 75,000, is illustrated in Exhibit 4.4.

Decision Rule:

Use BCR

Select a project with highest BCR

Exhibit 4.4

NPV and BCR Computation—Illustration where Projects are of Unequal size

Internal Rate of Return (IRR)

Internal rate of return (IRR) is the rate of return from the project after discounting of cash flows, where present value of cash inflows equals the present value of cash outflows.

To calculate IRR:

Ascertain discount rate by discounting of cash flows, such that PV (I) = PV (O) or BCR = 1 or NPV = 0, i.e.,

PV (I) – PV (O) == 0; or

BCR = PV (I)/PV (O) = 1

The discount rate ascertained is the IRR.

IRR Computation: IRR can be calculated by

use of computer: ascertain a rate where discounted inflows = discounted outflows, or

iteration process: calculate PV inflows and PV outflows at various discount rates by using PV Table,

where ∑PV(I) = ∑ PV(O), a cumbersome process

interpolation formula, discussed below

IRR—Thumb Rule:

IRR is the reciprocal of payback period under certain conditions as

Inflows are uniform over the years and

Project is of long life

IRR—Interpolation Formula

IRR lies between two rates, that is, between a low rate (L) and a high rate (H), such that

at “L” discount rate, NPV is Positive (+) and

at “H” discount rate, NPV is Negative (–)

So, IRR = L + [NPV (L)/Abs. (PV (I)L – PV (I) H] ×(H – L)

For illustration in Exhibit 4.2 above, at “L” 10% and “H”

30%, interpolation formula

= 10% + [12,900/37,900 – 24,360] × (30 – 10)

= 10 + 19.05 = 29.05

Comparison of NPV, BCR, and IRR is illustrated in Exhibit 4.5.

Exhibit 4.5

Comparison of NPV, BCR, and IRR

 

NPV

BC Ratio

IRR

Information needed

Inflows

Outflows

Life

Discount rate

Inflows

Outflows

Life

Discount rate

Inflows

Outflows

Life

?

Information obtained=>

NPV (Rs.)

BC ratio

Discount rate

where

PV(I) = PV (O)

Decision rule

NPV (–) →Reject

NPV (+) →Accept

Prefer a project with highest (+) NPV

BCR < 1 → Reject

BCR > 1 → Accept

Prefer a project with highest BCR

IRR < COC →Reject

IRR > COC →Accept

Prefer a project with highest IRR being greater than COC

NPV/BCR/IRR—Limitations:

The discounting methods discussed above although commonly used have some limitations as these are based on certain assumptions. These include:

Discount rate is assumed to be constant throughout the project.

Cash flows are assumed to occur at equally spread interval at the end of the year.

These are static methods at the time of analysis.

Cash inflows during the intermittent years are Reinvested.

Reinvestment rate is assumed to be the discount rate followed.

In addition, for IRR, there is a situation of

Multiple IRR (see Exhibit 5.3 . . . . . in the next chapter)

Adjusted Payback Period (PBP Adj.)

PBP discussed above does not discount cash flows for time; to overcome this weak point, PBP is calculated for cash flows adjusted for time and this is known as adjusted payback period (PBP Adj.).

So PBP Adj. is the period within which discounted inflows are sufficient to cover discounted outflows.

PBP Adjusted Computation:

For illustration in Exhibit 4.2 (discounting at 10%)

Project: A = 3.02 years

Project B = 4.59 years

Modified Internal Rate of Return (MIRR)

Discounted cash flow methods (discussed above) namely, NPV, BCR, and IRR have several limitations, one such limitation being the reinvestment rate, that is, inflows during the intermittent period are reinvested at the rate of discount. MIRR is a discounted cash flow method which takes care of this limitation. It calculates rate of discount at the terminal date equating discounted inflows and outflows and is called MIRR.

One today is worth two tomorrows and if you have something to do tomorrow do it today

MIRR Calculation: Steps

1. Calculate present value (PV) of outflows involved, i.e., present value of project cost using the discount rate.

2. Calculate the terminal value (TV) of the cash inflows expected from the project using the discount rate. This results in a single stream of cash inflows in the terminal year.

3. Calculate the rate of discount which equates the present value (PV) of outflows (Step 1 above) with the terminal value of inflows (Step 2 above).

The rate so calculated equates the PV of outflows in the zeroth year with the terminal value of cash inflows and is the MIRR.

Illustrations

Illustration 4.1: Computation of IRR

Johnson Watch Co. is considering an investment proposal as under:

Year

Cash flows Rs.

0

(136,000)

1

  30,000

2

  40,000

3

  60,000

4

  30,000

5

  20,000

NPV 10% = PV (I)10% 2 PV (O)10% == 138,280 – 136,000 = Rs. 2,280

NPV 12% = PV (I)12% 2 PV (O)12% == 131,810 – 136,000 = Rs. 26,410

So IRR lies between 10% and 12%

By interpolation

IRR == 10% + {2,280/(138,280 – 131,810)} × (12 –10) =10.711%

MIRR calculation for Illustration 4.1:

MIRR Calculation Steps :

Step 1. PV of outflows Rs. 136,000
Step 2. Compounded value of inflows at the terminal year 5th at 8%
1. 30,000 1.3605 40,815
2. 40,000 1.2597 50,388
3. 60,000 1.1664 69,984
4. 30,000 1.0800 32,400
5. 20,000 1.0000 20,000
Total 213,587
Step 3. MIRR is obtained as:

136,000 == 213,587 / (1 + MIRR)

136,000 / 213,587 == 0.6367428 which lies between 9 % and 10% in

Table PV interest factor at five years

So MIRR is 9.5%

Illustration 4.2

For Anderson Sons, given outflows in the first 2 years and inflows in the subsequent years are given as:

So IRR lies between 10% and 20%

By interpolation IRR = 10 + 53.28/{(246 2 163.58)} ×(20 – 10)
= 16.64 %

 

 

MIRR calculations:

Step 1. PV of outflows at 15% = 120 + 80 (0.870) = 189.6
Step 2. Compounded value of inflows at terminal year 6 at 15%

Year

Inflows

Compound value of inflows factor

Compound value

2

20

1.749

  34.98

3

60

1.521

  91.26

4

80

1.322

105.76

5

100  

1.150

115.00

6

120  

1.000

120.00

Total

467.00

Step 3 MIRR is obtained as

189.6 == 467/(1 + MIRR)

189/467 == 0.4059957 which lies between 19% and 20% in PV

Table for interest factor at 5 years

So MIRR is 19.5%

Case Studies

Water Supply Project of a City Municipality—Part I

Municipal Corporation of a Western State in India is planning to set up fully automatic water works for its newly developed colonies. Order for the plant and equipment costing Rs. 170 crores plus sales tax 5% was placed on June 20, 2000. Freight and insurance in transit was likely to cost Rs. 2 crores. The land was provided by the local government at a concessional price and construction together with land costed Rs. 25 crores. The plant was received on December 12, 2000, and was operational after installation on April 1, 2001, the installation charges being Rs. 18 crores.

Funds for the project were arranged through government grant of Rs. 200 crores and 12% Rs. 100 crores bank borrowings.

The commissioner of the Municipal Corporation is in charge of the project and is responsible for its planning, commissioning, and operations, with monthly expenses of Rs. 8 lakhs. In addition, a group of employees were provided training in project operations and the training cost was Rs. 25 lakhs.

A consultant, expert in water treatment plant, was hired with a consultation fee of 5 percent of the equipment cost.

Ascertain project cost from the above information.

Water Supply Project of a City Municipality—Part II

The project was expected to provide water services to households with a monthly billing of Rs. 20 crores. As per normal practice, 1 month billing was estimated to remain outstanding. In addition, to ensure regular supplies, stock of raw materials and supplies was to be maintained for 4-week requirements. Raw materials and supplies accounted for 30 percent of the billing.

Will the above information affect the project cost estimated in Part I above?

Water Supply Project of a City Municipality—Part III

Operational details of the project for the first 20 years were as under:

Annual billing Rs. 240 crores

Material and supplies cost: 30 percent of billing

Manpower cost including Commissioner: Rs. 5 crores per annum for first 2 years and Rs. 7 crores for the subsequent 18 years

Depreciation and interest: Rs. 30 crores per annum for the first 5 years and Rs. 25 for the subsequent 15 years

Other expenses: Rs 2. crores per annum

Realizable value of equipment, building, and working capital at the end of 20 years is estimated to be Rs. 30 crores

Requirements:

Ascertain: annual revenue cost, annual profit, project cost, annual cash flows

Analyze the viability of the project and give your recommendations

In case financing of the project has to be redrawn, what alternative sources would you suggest indicating their cost implications?

 

1 Refer to Chapter 4, pp. 44–46 of Information Systems Project Management by David Olson, Business Expert Press, LLC (2015).

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.141.201.26