Projects Solutions
Projects Solutions
Projects Solutions
∑TY–nTY
b=
∑T2–nT2
a = Y – bT
The parameters are calculated below:
Calculation in the Least Squares Method
T Y TY T2
1 2,000 2,000 1
2 2,200 4,400 4
3 2,100 6,300 9
4 2,300 9,200 16
5 2,500 12,500 25
6 3,200 19,200 36
7 3,600 25,200 49
8 4,000 32,000 64
9 3,900 35,100 81
10 4,000 40,000 100
11 4,200 46,200 121
12 4,300 51,600 144
13 4,900 63,700 169
14 5,300 74,200 196
∑ T = 105 ∑ Y = 48,500 ∑ TY = 421,600 ∑ T 2 = 1,015
T = 7.5 Y = 3,464
57,880
= = 254
227.5
a = Y – bT
= 3,464 – 254 (7.5)
= 1,559
Thus linear regression is
Y = 1,559 + 254 T
2. In general, in exponential smoothing the forecast for t + 1 is
Ft + 1 = Ft + α et
1 2,000
2 2,200
3 2,100 F4 = (2000 + 2200 + 2100)/3 = 2100
4 2,300 2100 F5 =(2200 + 2100 + 2300)/3= 2200
5 2,500 2200 F6 = (2100 + 2300 + 2500)/3 = 2300
6 3,200 2300 F7 = (2300 + 2500 + 3200)/3= 2667
7 3,600 2667 F8 = (2500 + 3200 + 3600)/3 = 3100
8 4,000 3100 F9 = (3200 + 3600 + 4000)/3 = 3600
9 3,900 3600 F10 = (3600 + 4000 + 3900)/3 = 3833
10 4,000 3833 F11 = (4000 + 3900 + 4000)/3 =3967
11 4,200 3967 F12 =(3900 + 4000 + 4200)/3 = 4033
12 4,300 4033 F13 = (4000 + 4200 + 4300)/3 = 4167
13 4,900 4167 F14 = (4200 + 4300 + 4900) = 4467
14 5,300 4467
4.
Q1 = 60
Q2 = 70
I1 = 1000
I2 = 1200
Q1 – Q2 I1 + I2
Income Elasticity of Demand E1 = x
I2 - I1 Q2 – Q1
E1 = Income Elasticity of Demand
Q1 = Quantity demanded in the base year
Q2 = Quantity demanded in the following year
I1 = Income level in base year
I2 = Income level in the following year
70 – 60 1000 + 1200
E1 = x
1200 – 1000 70 + 60
22000
E1 = = 0.846
26000
5.
P1 = Rs.40
P2 = Rs.50
Q1 = 1,00,000
Q2 = 95,000
Q2 – Q1 P1 + P2
Price Elasticity of Demand = Ep = x
P2 –P1 Q2 + Q1
P1 , Q1 = Price per unit and quantity demanded in the base year
P2, Q2 = Price per unit and quantity demanded in the following year
Ep = Price Elasticity of Demand
95000 - 100000 40 + 50
Ep = x
50 - 40 95000 + 100000
- 45
Ep = = - 0.0231
1950
Chapter 6
1.
Projected Cash Flow Statement (Rs. in million)
Sources of Funds
Profit before interest and tax 4.5
Depreciation provision for the year 1.5
Secured term loan 1.0
Total (A) 7.0
Disposition of Funds
Capital expenditure 1.50
Increase in working capital 0.35
Repayment of term loan 0.50
Interest 1.20
Tax 1.80
Dividends 1.00
Total (B) 6.35
(Rs. in million)
Liabilities Assets
Share capital 5.00 Fixed assets 11.00
Reserves & surplus 4.50 Investments .50
Secured loans 4.50 Current assets 12.85
Unsecured loans 3.00 * Cash 1.65
Current liabilities 6.30 * Receivables 4.20
& provisions 1.05 * Inventories 7.00
24.35 24.35
4. Saving Rs.2000 a year for 5 years and Rs.3000 a year for 10 years thereafter is
equivalent to saving Rs.2000 a year for 15 years and Rs.1000 a year for the
years 6 through 15.
(5.000 – 4.411) x 2%
r = 16% + = 17.4%
(5.234 – 4.411)
8. The present value of Rs.10,000 receivable after 8 years for various discount
rates (r ) are:
r = 10% PV = 10,000 x PVIF(r = 10%, 8 years)
= 10,000 x 0.467 = Rs.4,670
10. The present value of an annual pension of Rs.10,000 for 15 years when r = 15%
is:
Obviously, Mr. Jingo will be better off with the annual pension amount of
Rs.10,000.
14. To earn an annual income of Rs.5,000 beginning from the end of 15 years from
now, if the deposit earns 10% per year a sum of
Rs.5,000 / 0.10 = Rs.50,000
is required at the end of 14 years. The amount that must be deposited to get this
sum is:
Rs.50,000 / PVIF (10%, 14 years) = Rs.50,000 / 3.797 = Rs.13,165
5.019 – 5.00
r = 15% + ---------------- x 3%
5.019 – 4.494
= 15.1%
= Rs.2590.9
Similarly,
PV (Stream B) = Rs.3,625.2
PV (Stream C) = Rs.2,851.1
20. Investment required at the end of 8 th year to yield an income of Rs.12,000 per
year from the end of 9th year (beginning of 10th year) for ever:
Rs.12,000 x PVIFA(12%, ∞ )
= Rs.12,000 / 0.12 = Rs.100,000
Rs.100,000 Rs.100,000
= = Rs.40,388
PVIF(12%, 8 years) 2.476
21. The interest rate implicit in the offer of Rs.20,000 after 10 years in lieu of
Rs.5,000 now is:
Rs.20,000
FVIF (r,10 years) = = 4.000
Rs.5,000
23. A constant deposit at the beginning of each year represents an annuity due.
To provide a sum of Rs.50,000 at the end of 10 years the annual deposit should
be
Rs.50,000
A = FVIFA(12%, 10 years) x (1.12)
Rs.50,000
= = Rs.2544
17.549 x 1.12
24. The discounted value of Rs.20,000 receivable at the beginning of each year from
2005 to 2009, evaluated as at the beginning of 2004 (or end of 2003) is:
If A is the amount deposited at the end of each year from 1995 to 2000 then
A x FVIFA (12%, 6 years) = Rs.51,335
A x 8.115 = Rs.51,335
A = Rs.51,335 / 8.115 = Rs.6326
25. The discounted value of the annuity of Rs.2000 receivable for 30 years,
evaluated as at the end of 9th year is:
Rs.2,000 x PVIFA (10%, 30 years) = Rs.2,000 x 9.427 = Rs.18,854
The present value of Rs.18,854 is:
Rs.18,854 x PVIF (10%, 9 years)
= Rs.18,854 x 0.424
= Rs.7,994
26. 30 percent of the pension amount is
0.30 x Rs.600 = Rs.180
Assuming that the monthly interest rate corresponding to an annual interest rate
of 12% is 1%, the discounted value of an annuity of Rs.180 receivable at the end of
each month for 180 months (15 years) is:
Rs.180 x PVIFA (1%, 180)
(1.01)180 - 1
Rs.180 x ---------------- = Rs.14,998
.01 (1.01)180
If Mr. Ramesh borrows Rs.P today on which the monthly interest rate is 1%
P x (1.01)60 = Rs.14,998
P x 1.817 = Rs.14,998
Rs.14,998
P = ------------ = Rs.8254
1.817
21.244 – 20.000
r = 1% + ---------------------- x 1%
21.244 – 18,914
= 1.53%
Thus, the bank charges an interest rate of 1.53% per month.
The corresponding effective rate of interest per annum is
[ (1.0153)12 – 1 ] x 100 = 20%
29. Let `n’ be the number of years for which a sum of Rs.20,000 can be withdrawn
annually.
Rs.20,000 x PVIFA (10%, n) = Rs.100,000
PVIFA (15%, n) = Rs.100,000 / Rs.20,000 = 5.000
From the tables we find that
PVIFA (10%, 7 years) = 4.868
PVIFA (10%, 8 years) = 5.335
Thus n is between 7 and 8. Using a linear interpolation we get
5.000 – 4.868
n=7+ ----------------- x 1 = 7.3 years
5.335 – 4.868
31. Define n as the maturity period of the loan. The value of n can be obtained
from the equation.
200,000 x PVIFA(13%, n) = 1,500,000
PVIFA (13%, n) = 7.500
From the tables or otherwise it can be verified that PVIFA(13,30) = 7.500
Hence the maturity period of the loan is 30 years.
32. Expected value of iron ore mined during year 1 = Rs.300 million
Expected present value of the iron ore that can be mined over the next 15 years
assuming a price escalation of 6% per annum in the price per tonne of iron
1 – (1 + g)n / (1 + i)n
= Rs.300 million x ------------------------
i-g
Chapter 8
INVESTMENT CRITERIA
1.(a) NPV of the project at a discount rate of 14%.
100,000 200,000
= - 1,000,000 + ---------- + ------------
(1.14) (1.14)2
= - 44837
= - 1,000,000
100,000
+
(1.12)
200,000
+
(1.12) (1.13)
300,000
+
(1.12) (1.13) (1.14)
600,000
+
(1.12) (1.13) (1.14) (1.15)
300,000
+
(1.12) (1.13) (1.14)(1.15)(1.16)
2. Investment A
r = 15 + 1 x (0.019 / 0.136)
= 15.14%
Investment B
d) BCR = PVB / I
= 194,661 / 300,000 = 0.65
Investment C
a) Payback period lies between 2 years and 3 years. Linear interpolation in
this range provides an approximate payback period of 2.88 years.
Investment D
Investment A B C D
a) Payback period
(in years) 5 9 2.88 8.5
3. IRR (r) can be calculated by solving the following equations for the value of r.
60000 x PVIFA (r,7) = 300,000
i.e., PVIFA (r,7) = 5.000
Through a process of trial and error it can be verified that r = 9.20% p.a.
4. The IRR (r) for the given cashflow stream can be obtained by solving the
following equation for the value of r.
-3000 + 9000 / (1+r) – 3000 / (1+r) = 0
Simplifying the above equation we get
r = 1.61, -0.61; (or) 161%, (-)61%
Note : Given two changes in the signs of cashflow, we get two values for the
IRR of the cashflow stream. In such cases, the IRR rule breaks down.
5. Define NCF as the minimum constant annual net cashflow that justifies the
purchase of the given equipment. The value of NCF can be obtained from the
equation
NCF x PVIFA (10%,8) = 500000
NCF = 500000 / 5.335
= 93271
6. Define I as the initial investment that is justified in relation to a net annual cash
inflow of 25000 for 10 years at a discount rate of 12% per annum. The value
of I can be obtained from the following equation
25000 x PVIFA (12%,10) = I
i.e., I = 141256
Project
P Q R
Discount rate
0% 400 500 600
5% 223 251 312
10% 69 40 70
15% - 66 - 142 - 135
25% - 291 - 435 - 461
30% - 386 - 555 - 591
9. NPV profiles for Projects P and Q for selected discount rates are as follows:
(a)
Project
P Q
Discount rate (%)
0 2950 500
5 1876 208
10 1075 - 28
15 471 - 222
20 11 - 382
-1000 -1200 x PVIF (r,1) – 600 x PVIF (r,2) – 250 x PVIF (r,3)
+ 2000 x PVIF (r,4) + 4000 x PVIF (r,5) = 0
(ii) The IRR (r') of project Q can be obtained by solving the following
equation for r'
-1600 + 200 x PVIF (r',1) + 400 x PVIF (r',2) + 600 x PVIF (r',3)
+ 800 x PVIF (r',4) + 100 x PVIF (r',5) = 0
Through a process of trial and error we find that r' = 9.34%.
d) Project P
PV of investment-related costs
= 1000 x PVIF (12%,0)
+ 1200 x PVIF (12%,1) + 600 x PVIF (12%,2)
+ 250 x PVIF (12%,3)
= 2728
TV of cash inflows = 2000 x (1.12) + 4000 = 6240
The MIRR of the project P is given by the equation:
2728 = 6240 x PVIF (MIRR,5)
(1 + MIRR)5 = 2.2874
MIRR = 18%
(c) Project Q
PV of investment-related costs = 1600
TV of cash inflows @ 15% p.a. = 2772
The MIRR of project Q is given by the equation:
16000 (1 + MIRR)5 = 2772
MIRR = 11.62%
10.
(a) Project A
NPV at a cost of capital of 12%
= - 100 + 25 x PVIFA (12%,6)
= Rs.2.79 million
Project B
NPV at a cost of capital of 12%
= - 50 + 13 x PVIFA (12%,6)
= Rs.3.45 million
IRR (r') can be obtained by solving the equation
13 x PVIFA (r',6) = 50
i.e., r' = 14.40% [determined through a process of trial and error]
IRR (r'') of the differential project can be obtained from the equation
12 x PVIFA (r'', 6) = 50
i.e., r'' = 11.53%
11.
(a) Project M
The pay back period of the project lies between 2 and 3 years. Interpolating in
this range we get an approximate pay back period of 2.63 years.
Project N
The pay back period lies between 1 and 2 years. Interpolating in this range we
get an approximate pay back period of 1.55 years.
(b) Project M
Cost of capital = 12% p.a
PV of cash flows up to the end of year 2 = 24.97
PV of cash flows up to the end of year 3 = 47.75
PV of cash flows up to the end of year 4 = 71.26
Discounted pay back period (DPB) lies between 3 and 4 years. Interpolating in
this range we get an approximate DPB of 3.1 years.
Project N
Cost of capital = 12% per annum
PV of cash flows up to the end of year 1 = 33.93
PV of cash flows up to the end of year 2 = 51.47
Since the two projects are independent and the NPV of each project is (+) ve,
both the projects can be accepted. This assumes that there is no capital
constraint.
(d) Project M
Cost of capital = 10% per annum
NPV = Rs.25.02 million
Project N
Cost of capital = 10% per annum
NPV = Rs.23.08 million
Since the two projects are mutually exclusive, we need to choose the project
with the higher NPV i.e., choose project M.
Note : The MIRR can also be used as a criterion of merit for choosing between
the two projects because their initial outlays are equal.
(e) Project M
Cost of capital = 15% per annum
NPV = 16.13 million
Project N
Cost of capital: 15% per annum
NPV = Rs.17.23 million
Again the two projects are mutually exclusive. So we choose the project with the
higher NPV, i.e., choose project N.
(f) Project M
Terminal value of the cash inflows: 114.47
MIRR of the project is given by the equation
50 (1 + MIRR)4 = 114.47
i.e., MIRR = 23.01%
Project N
Terminal value of the cash inflows: 115.41
MIRR of the project is given by the equation
50 ( 1+ MIRR)4 = 115.41
i.e., MIRR = 23.26%
12. The internal rate of return is the value of r in the equation
Chapter 9
1.
(a) Project Cash Flows (Rs. in million)
Year 0 1 2 3 4 5 6 7
6. Profit before tax 112.5 121.87 128.91 134.18 138.13 141.1 143.33
8. Profit after tax 78.75 85.31 90.24 93.93 96.69 98.77 100.33
14. NCF (200) 116.25 113.44 111.33 109.75 108.56 107.67 205
(c) IRR (r) of the project can be obtained by solving the following equation for r
Year 0 1 2 3 4 5 6 7
21. Net cash flow (140) 10.20 20.55 31.46 62.80 49.25 35.94 55.00
(17+18-19+20)
(b) NPV of the net cash flow stream @ 15% per discount rate
3.
(a) A. Initial outlay (Time 0)
Year 1 2 3 4 5
i. Post-tax savings in
manufacturing costs 455,000 455,000 455,000 455,000 455,000
ii. Incremental
depreciation 550,000 412,500 309,375 232,031 174,023
D. Net cash flows associated with the replacement project (in Rs)
Year 0 1 2 3 4 5
Year 1 2 3 4 5
i. Depreciation
of old machine 18000 14400 11520 9216 7373
ii. Depreciation
of new machine 100000 75000 56250 42188 31641
Year 0 1 2 3 4 5
Chapter 10
14 + (100 – 108)/10
rD = ------------------------ x 100 = 12.60%
0.4 x 100 + 0.6x108
2. Define rp as the cost of preference capital. Using the approximate yield formula
rp can be calculated as follows:
9 + (100 – 92)/6
rp = --------------------
0.4 x100 + 0.6x92
5. Given
0.5 x 14% x (1 – 0.35) + 0.5 x rE = 12%
6 (a) The cost of debt of 12% represents the historical interest rate at the time the debt
was originally issued. But we need to calculate the marginal cost of debt (cost
of raising new debt); and for this purpose we need to calculate the yield to
maturity of the debt as on the balance sheet date. The yield to maturity will not
be equal to 12% unless the book value of debt is equal to the market value of
debt on the balance sheet date.
(b) The cost of equity has been taken as D1/P0 ( = 6/100) whereas the cost of equity
is (D1/P0) + g where g represents the expected constant growth rate in dividend
per share.
7. The book value and market values of the different sources of finance are
provided in the following table. The book value weights and the market value
weights are provided within parenthesis in the table.
(Rs. in million)
Source Book value Market value
Equity 800 (0.54) 2400 (0.78)
Debentures – first series 300 (0.20) 270 (0.09)
Debentures – second series 200 (0.13) 204 (0.06)
Bank loan 200 (0.13) 200 (0.07)
Total 1500 (1.00) 3074 (1.00)
8.
(a) Given
rD x (1 – 0.3) x 4/9 + 20% x 5/9 = 15%
rD = 12.5%,where rD represents the pre-tax cost of debt.
(b) Given
13% x (1 – 0.3) x 4/9 + rE x 5/9 = 15%
rE = 19.72%, where rE represents the cost of equity.
The average cost of capital using book value proportions is calculated below:
The average cost of capital using market value proportions is calculated below :
11.
(a) WACC = 1/3 x 13% x (1 – 0.3)
+ 2/3 x 20%
= 16.37%
(c) NPV of the proposal after taking into account the floatation costs
= 130 x PVIFA (16.37%, 8) – 500 / (1 - 0.09)
= Rs.8.51 million
Chapter 11
Assumptions: (1) The useful life is assumed to be 10 years under all three
scenarios. It is also assumed that the salvage value of the
investment after ten years is zero.
(3) The tax rate has been calculated from the given table i.e.
10 / 35 x 100 = 28.57%.
2.
(a) Sensitivity of NPV with respect to quantity manufactured and sold:
(in Rs)
Pessimistic Expected Optimistic
22 = 0.56
32 = 0.49
= 1.00
(NPV) = Rs.1.00 million
3. Expected NPV
4 At
= - 25,000
t=1 (1.08)t
4. Expected NPV
4 At
= - 25,000 …. (1)
t=1 (1.06)t
A1 = 2,000 x 0.2 + 3,000 x 0.5 + 4,000 x 0.3
= 3,100
A2 = 3,000 x 0.4 + 4,000 x 0.3 + 5,000 x 0.3
= 3,900
0 – 3044
= Prob Z<
1296
The required probability is given by the shaded area in the following normal
curve.
The required probability is given by the shaded area of the following normal
curve:
P(Z > - 0.81) = 0.5 + P(-0.81 < Z < 0)
= 0.5 + P(0 < Z < 0.81)
= 0.5 + 0.2910
= 0.7910
5. Given values of variables other than Q, P and V, the net present value model of
Bidhan Corporation can be expressed as:
5
[Q(P – V) – 3,000 – 2,000] (0.5)+ 2,000 0
t=1
NPV = ---------------------------------------------------------- + ------- - 30,000
(1.1)t (1.1)5
5
0.5 Q (P – V) – 500
t=1
= ------------------------------------ - 30,000
(1.1)t
Exhibit 1
Correspondence between values of exogenous variables and
two digit random numbers
Exhibit 2
Simulation Results
50
Variance of NPV = 1/50 NPVi – NPV)2
i=1
6. To carry out a sensitivity analysis, we have to define the range and the most
likely values of the variables in the NPV Model. These values are defined
below
The relationship between Q and NPV given the most likely values of other
variables is given by
5 [Q (30-20) – 3,000 – 2,000] x 0.5 + 2,000 0
NPV = + - 30,000
t=1 (1.1)t (1.1)5
5 5Q - 500
= - 30,000
t=1 (1.1)t
The net present values for various values of Q are given in the following table:
The relationship between P and NPV, given the most likely values of other
variables is defined as follows:
5 700 P – 14,500
= - 30,000
t=1 (1.1)t
The net present values for various values of P are given below :
P (Rs) 20 30 40 50
NPV(Rs) -31,896 -5,359 21,179 47,716
8. NPV -5 0 5 10 15 20
(Rs.in lakhs)
PI 0.9 1.00 1.10 1.20 1.30 1.40
6
Expected PI = PI = (PI)j P j
j=1
= 1.24
6
Standard deviation = (PIj - PI) 2 P j
o f P1 j=1
= .01156
= .1075
The standard deviation of P1 is .1075 for the given investment with an expected
PI of 1.24. The maximum standard deviation of PI acceptable to the company
for an investment with an expected PI of 1.25 is 0.30.
Since the risk associated with the investment is much less than the maximum
risk acceptable to the company for the given level of expected PI, the company
should accept the investment.
9. Investment A
Outlay : Rs.10,000
Net cash flow : Rs.3,000 for 6 years
Required rate of return : 12%
Investment B
Outlay : Rs.30,000
Net cash flow : Rs.11,000 for 5 years
Required rate of return : 14%
NPV(B) = 11,000 x PVIFA (14%, 5 years) – 30,000
= Rs.7763
10. The NPVs of the two projects calculated at their risk adjusted discount rates are
as follows:
6 3,000
Project A: NPV = - 10,000 = Rs.2,333
t=1 (1.12)t
5 11,000
Project B: NPV = - 30,000 = Rs.7,763
t=1 (1.14)t
Project A B
PI 1.23 1.26
IRR 20% 24.3%
B is superior to A in terms of NPV, PI, and IRR. Hence the company must
choose B.
Chapter 12
2. (i) Since there are 3 securities, there are 3 variance terms and 3 covariance
terms. Note that if there are n securities the number of covariance terms are: 1 +
2 +…+ (n + 1) = n (n –1)/2. In this problem all the variance terms are the same
(2A) all the covariance terms are the same (AB) and all the securities are equally
weighted (wA)
So,
2p = [3 w2A 2A + 2 x 3 AB]
2p = [3 w2A 2A + 6 wA wBAB]
1 2 1 1
=3x x 2A + 6 x x x AB
3 3 3
1 2
= 2A + AB
3 3
(ii) Since there are 9 securities, there are 9 variance terms and 36 covariance
terms. Note that if the number of securities is n, the number of covariance
terms is n(n – 1)/2.
In this case all the variance terms are the same (2A), all the covariance terms are
1
the same (AB) and all the securities are equally weighted wA
9
So,
n(n-1)
2p = 9 w2A 2A t 2 x wA wBAB
2
1 2 1 1
= 9 x x 2A + 9(8) x x AB
9 9 9
1 72
= 2A + AB
9 81
2M
Σ (RB - RB) (RM – RM) 320
Cov (RB, RM) = = = 16.84
n –1 19
Given a risk-free rate (Rf ) of 11 percent and the expected market risk premium
(E(RM – Rf ) of 6 percent we get the following:
Project Beta Required rate(%) Expected rate (%)
A 0.5 11 + 0.5 x 6 = 14 15
B 0.8 11 + 0.8 x 6 = 15.8 16
C 1.2 11 + 1.2 x 6 = 18.2 21
D 1.6 11 + 1.6 x 6 = 20.6 22
E 1.7 11 + 1.7 x 6 = 21.2 23
a. The expected return of all the 5 projects exceeds the required rate as per the CAPM.
So all of them should be accepted.
b. If the cost of capital of firm which is 16 percent is used as the hurdle rate, project A
will be rejected incorrectly.
5. The asset beta is linked to equity beta, debt-equity ratio, and tax rate as follows:
E
A =
[1 + D/E (1 –T)]
1.10
C = 0.45
[1 + (2.1) x 0.7]
As per the CAPM model, the cost of equity of the proposed project is:
12% + (17% - 12%) x 1.128 = 17.64%
The required rate of return for the project given a debt-equity ratio of 2:1 is:
1/3 x 17.64% + 2/3 x 11.2% = 13.35%
6. E
A =
[1 + D/E (1 –T)]
E = 1.25 D/E = 1.6 T = 0.3
E 1.30
A = =
[1 + D/E ( 1 –T)] [1 + 1.5 (1 –.4)]
= 0.68
The equity beta (systematic risk) for the petrochemicals project of Growmore,
when D/E = 1.25 and T = 0.4, is
0.68 [1 + 1.25 (1 – .4)] = 1.19
Chapter 13
1. PV Cost
UAE =
PVIFAr,n
= Rs.1,372,013
Present value of salvage value = 3,00,000 / (1.13)5 = Rs.162,828
Present value of costs of internal transportation = 1,500,000 –1,372,013
system – 162,828 = Rs.27,09,185
UAE of the internal transportation system = 27,09,185 / 3.517 = Rs.7,70,311
Since the less costly overhaul has a lower UAE, it is the preferred alternative
9.
a. Base case NPV = -12,000,000 + 3,000,000 x PVIFA (20%, b)
= -12,000,000 + 3,000,000 x 3,326
= - Rs.2,022,000
b. Adjusted NPV = Base case NPV – Issue cost + Present value of tax shield.
Term loan = Rs.8 million Equity finance = Rs.4 million
Issue cost of equity = 12%
Rs.4,000,000
Equity to be issued = = Rs.4,545,455
0.88
Cost of equity issue = Rs.545,455
10.
a. Base Case NPV = - 8,000,000 + 2,000,000 x PVIFA (18%, 6)
= - 8,000,000 + 2,000,000 x 3,498
= - Rs.1,004,000
b. Adjusted NPV = Base case NPV – Issue cost + Present value of tax shield.
Term loan = Rs.5 million
Equity finance = Rs.3 million
Issue cost of equity = 10%
Rs.3,000,000
Hence, Equity to be issued = = Rs.3,333,333
0.90
Cost of equity issue = Rs.333,333
= Rs.3406.2 million
Chapter 14
The IRR of the stream of social costs and benefits is the value of r in the
equation
Benefits
1. Resale value of the diesel train (one time) Rs.240,000
2. Avoidance of annual cash loss Rs.400,000
Fare collection = 1000 x 250 x Rs.4
= Rs.1,000,000
Cash operating expenses = Rs.1,400,000
3. The social costs and benefits of the project are estimated below:
Rs. in
million
Costs & Benefits Time Economic Explanation
value
1. Construction cost 0 24
2. Land development cost 0 150
3. Maintenance cost 1-40 1
4. Labour cost 0 40 This includes the cost of
transport and rehabilitation
5. Labour cost 1-40 12 The shadow price of labour
equals what others are willing
to pay.
6. Decrease in the value of the timber 2-40 4
output
Benefits
7. Savings in the cost of shipping the 1-40 0.5
agriculture produce
8. Income from cash crops 1-5 10
9. Income from the main crop 6-40 50
10. Increase in the value of timber output 1 20
Assuming that the life of the road is 40 years, the NPV of the stream of social costs and benefits
at a discount rate of 10 percent is:
40 1 + 12 40 4
NPV = - 24 - 150 - 40 - -
t=1 (1.1)t t=2 (1.1)t
40 0.5 5 10 40 50 20
+
t=1 (1.1)t t=1 (1.1)t t=6 (1.1)t (1.1)1
= - Rs.9.93 million
4.
Table 1
Social Costs Associated with the Initial Outlay
Rs. in
million
Item Financia Basis of Tradeable value T L R
l cost conversion ab initio
Land 0.30 SCF = 1/1.5 0.20
Buildings 12.0 T=0.50, L=0.25 6.0 3.0 3.0
R=0.25
Imported equipment 15.0 CIF value 9.0
Indigeneous equipment 80.0 CIF value 60.0
Transport 2.0 T=0.65, L=0.25 1.3 0.5 0.2
R=0.10
Engineering and know-how 6.0 SCF=1.5 9.0
fees
Pre-operative expenses 6.0 SCF=1.0 6.0
Bank charges 3.7 SCF=0.02 0.074
Working capital 25.0 SCF=0.8 20.0
requirement
150.0 104.274 7.3 3.5 3.2
Table 2
Conversion of Financial Costs into Social Costs
Rs. in
million
Item Financia Basis of Tradeable value T L R
l cost conversion ab initio
Indigeneous raw material 85 SCF=0.8 68
and stores
Labour 7 SCF=0.5 3.5
Salaries 5 SCF=0.8 4.0
Repairs and maintenance 1.2 SCF=1/1.5 0.8
Water, fuel, etc 6 T=0.5, L=0.25 3 1.5 1.5
R=0.25
Electricity (Rate portion) 5 T=0.71, L=0.13 3.55 0.65 0.8
R=0.16
Other overheads 10 SCF=1/1.5 6.667
119.2 82.967 6.55 2.15 2.3
As per table 1, the social cost of initial outlay is worked out as follows :
Rs. in million
Tradeable value ab initio 104.274
Social cost of the tradeable component 4.867
(7.3 / 1.5)
Social cost of labour component 1.75
(3.5 x 0.5)
Social cost of residual component 1.60
(3.2 x 0.5)
Total 112.491
As per Table 2, the annual social cost of operation is worked out as follows :
The annual CIF value of the output is Rs.110 million. Hence the annual social
net benefit will be : 110 – 89.559 = Rs.20.441 million
Working capital recovery will be Rs.20 million at the end of the 20th year.
Putting the above figures together the social flows associated with the project
would be as follows :
1. The ranking of the projects on the dimensions of NPV, IRR, and BCR is given below
Project NPV (Rs.) Rank IRR (%) Rank BCR Rank
M 60,610 3 34.1 2 2.21 1
N 58,500 4 34.9 1 1.59 3
O 40,050 5 18.6 4 1.33 5
P 162,960 1 26.2 3 2.09 2
Q 72,310 2 14.5 5 1.36 4
2. The ranking of the projects on the dimensions of NPV and BCR is given below
Project NPV (Rs.) Rank BCR Rank
A 61,780 5 1.83 2
B 208,480 2 1.52 3
C 315,075 1 2.05 1
D 411,90 6 1.14 6
E 95,540 4 1.38 4
F 114,500 3 1.23 5
A B
Initial outlay 10000 1000
Cash inflows
Year 1 5000 600
Year 2 5000 600
Year 3 5000 600
4. The two hypothetical 4-year projects for which BCR and IRR criteria give different
rankings are given below
Project A B
Investment outlay 20000 20000
Cash inflow
Year 1 2000 8000
Year 2 2000 8000
Year 3 2000 8000
Year 4 31500 8000
Project NPV Rank IRR Rank
A 4822 1 19% 2
B 4296 2 about 22% 1
Since B and E have negative NPV, they are rejected. So we consider only A, C,
and D. Further C and D are mutually exclusive. The feasible combinations, their
outlays, and their NPVs are given below.
6. The linear programming formulation of the capital budgeting problem under various
constraints is as follows:
Maximise 10 X1 + 15 X2 + 25 X3 + 40 X4 + 60 X5 + 100 X6
Subject to
15 X1 + 12 X2 + 8 X3 + 35 X4 + 100 X5
+ 50 X6 + SF1 = 150 Funds constraint for year 1
5 X1 + 13 X2 + 40 X3 + 25 X4 + 10 X5
+ 110 X6 ≤ 200 + 1.08 SF1 Funds constraint for year 2
5 X1 + 6 X2 + 5 X3 + 10 X4 + 12 X5
+ 40 X6 ≤ 60 Power constraint
15 X1 + 20 X2 + 30 X3 + 35 X4 + 40 X5
+ 60 X6 ≤ 120 Managerial constraint
0 ≤ Xj ≤ 1 (j = 1,….8) and SF1 ≥ 0
Rupees are expressed in ’000s. Power units are also expressed in ’000s.
7. Given the nature of the problem, in addition to the decision variables X1 through X10
for the original 10 projects, two more decision variables are required as follows:
X11 is the decision variable to represent the delay of projects 8 by one year
X12 is the decision variable for the composite project which represents the
combination of projects 4 and 5.
The integer linear programming formulation is as follows:
X3 + X7 ≥1
X5 + X8 + X9 + X10 ≥2
X2 ≤ X6
X8 ≤ X9
X4 + X5 + X12 ≤1
X8 + X11 ≤1
Xj = {0,1} j = 1, 2….12
SFi ≥ 0 i = 1, 2
It has been assumed that surplus funds can be shifted from one period to the next
and they will earn a post-tax return of r percent.
– – – – – – – +
8. Minimise [P1(3d1+ 2 d 2 + d 3) + P 2 (4 d 4 + 2 d 5 + d 6) + P 3 (d 7 – d 7 )]
Subject to:
Economic Constraints
12 X1 + 14 X2 + 15 X3 + 16 X4 + 11 X5 + 23 X6 + 20 X7 ≤ 65
Goal Constraints
4 X1 + 5 X2 + 6 X3 + 8 X4 + 4 X5
– +
+ 9 X6 + 7 X7 + d 7 – d 7 = 50 NPV
– +
Xj 0 d i, d i 0
9. The BCRs of the projects are converted into NPVs as of now as follows
Xj = {0,1} j = 1, 2, 3, 4, 6, 7, 8, 9
Chapter 22
Exhibit 1
Network for the Project
2 1 5
4 4 11 11
4 5
2 3
1 3 4 5 7
0 0 9 9 14 14
2 6
3
2 3
There are two critical paths: 1-2-4-5-7 and 1-2-4-7. The minimum time required
for completing the project is 14 weeks.
Exhibit 2
Time Estimates
(a) The network diagram with average time estimates is shown in Exhibit 3.
Exhibit 3
2
6⅓ 6⅓ EOT LOT
11 4⅓ 9⅓
6⅓
3⅚ 3⅙
4 5 6
17 ⅓ 17⅓ 21 ⅓ 21 ⅓ 24 ⅓ 24 ⅓
7⅙
6⅓
3
7⅙ 10 ⅙ 2½
7⅙
1 4 7
0 0 26 ⅚ 26 ⅚
Exhibit 3
Event slacks
Event LOT EOT Slack = LOT – EOT
1 0 0 0
2 6 1/3 6 1/3 0
3 10 1/6 7 1/6 3
4 17 1/3 17 1/3 0
5 21 1/6 21 1/6 0
6 24 1/3 24 1/3 0
7 26 5/6 26 5/6 0
Exhibit 4
Activity Floats
Activity Duration Total Float Free Float Independent Float
(i –j) dij LOT(j) – EOT(i) – dij EOT(j) – EOT(i) – dij EOT(j) – LOT (i) – dij
1-2 6 1/3 0 0 0
1-3 7 1/6 3 0 0
1-4 6 1/3 11 11 11
1-7 4 22 5/6 22 5/6 22 5/6
2-4 11 0 0 0
2-6 4 1/3 13 2/3 13 2/3 13 2/3
2-7 9 1/3 11 1/6 11 1/6 11 1/6
3-4 7 1/6 3 3 0
3-7 5 14 2/3 14 2/3 11 2/3
4-5 3 5/6 0 0 0
5-6 3 1/6 0 0 0
6-7 2 1/2 0 0 0
(d) Standard deviation of the critical path duration = [Sum of the variances of activity
durations on the critical path]1/2
The variances of the activity durations on the critical path are shown in Exhibit 5.
Exhibit 5
Variances of Activity Durations on critical path
Activity tp to tp – to 2
=
6
1-2 10 4 1.00 1.00
2-4 12 6 1.00 1.00
4-5 5 2 0.50 0.25
5-6 6 1 0.83 0.69
6-7 6 1 0.83 0.69
The standard deviation of the duration of critical path is:
= (1.00 + 1.00 + 0.25 + 0.69 + 0.69)1/2
= (3.63)1/2
= 1.91 weeks.
(e) Let D = specified completion date
T = mean of the critical path duration
c = standard deviation of the critical path duration
T = sum of the mean values of the activity durations on the critical path
= 6 1/3 + 9 2/3 + 3 5/6 + 3 1/6 + 2 ½
= 25 ½
D–T 30 – 25.5
Prob (D< 30) = Prob < = Prob [ Z < 2.356]
c 1.91
= 0.87
Exhibit 6
Network Diagram
10 7
2 6 4 9 7
5 7 6
1 4 3 12 5 12 9
(b) The all-normal critical paths are 1-2-4-6-7-9 and 1-3-4-6-7-9. For all-normal
network, the project duration is 34 weeks and the total direct cost is
Rs.66,000.
(c) The time-cost slope of the activities constituting the project is given in
Exhibit 7.
Exhibit 7
Time-Cost Slope of Activities
Time Cost (Rs.) Cost to expedite per
in weeks week (Rs.)
(1) (2) (3) (4) (5) (6)
Activity Normal Crash Normal Crash [(5)-(4) (2)-(3)]
(1-2) 5 2 6,000 9,000 1,000
(2-4) 6 3 7,000 10,000 1,000
(1-3) 4 2 1,000 2,000 500
(3-4) 7 4 4,000 8,000 1333.35
(4-7) 9 5 6,000 9,200 800
(3-5) 12 3 16,000 19,600 400
(4-6) 10 6 15,000 18,000 750
(6-7) 7 4 4,000 4,900 300
(7-9) 6 4 3,000 4,200 600
(5-9) 12 7 4,000 8,500 900
Examining the time-cost slope of activities on the critical path, we find that
activity (6-7) has the lowest slope on both the critical paths. The project network after
crashing this activity is shown below in Exhibit 8.
Exhibit 8
6
10 4
2 6 4 9 7
5 7 6
1 4 3 12 5 12 9
As per Exhibit 8, the critical paths are (1-3-4-6-7-9) and (1-2-4-6-7-9) with a
length of 31 weeks and the total cost is Rs.66,900.
Looking at the time-cost slope of the activities on the critical paths (1-3-4-6-7-9)
and (1-2-4-6-7-9), we find that activities (1-3) and (7-9) have the least time-cost slopes
on the two critical paths respectively. The project net work after crashing these
activities is shown in Exhibit 9.
Exhibit 9
6
10 4
2 6 4 9 7
5 7 4
1 2 3 12 5 12 9
As per Exhibit 9, the critical path is (1-2-4-6-7-9) with a length of 29 weeks and
the total direct cost is Rs.(66,900 + 2,200) = Rs.69,100. Activity (4-6) has the least
time-cost slope on the critical path. Hence this is crashed the net work after crashing
(4-6) is shown in Exhibit 10.
Exhibit 10
6
6 4
2 6 4 9 7
5 7 4
1 2 3 12 5 12 9
As per Exhibit 10, the critical path is (1-3-5-9), with a length of 26 weeks, and
total direct costs of Rs.72,100. Looking at the time-cost slope of the non-crashed
activities on this path we find that activity (3-5) has the lowest slope. Hence it is
crashed. The project net work after such crashing is shown in Exhibit 11.
Exhibit 11
6
6 4
2 6 4 9 7
5 7
1 2 3 3 5 12 9
As per Exhibit 11, the critical path is (1-2-4-6-7-9), with a length of 25 weeks
and a total direct cost of Rs.75,700.
Looking at the time cost slope of the activities on this critical path, we find both
activities (1-2) and (2-4) have the same slope. We crash activity (2-4). The resulting
project network net work is given in Exhibit 12.
Exhibit 12
6 4
2 3 4 9 7
5 7
1 2 3 3 5 12 9
As per Exhibit 12, the critical path is (1-3-4-6-7-9), with a length of 23 weeks
and a total direct cost of Rs.78,700. Crashing activity (3-4), the only uncrashed activity
on this critical path, we get the net work shown in Exhibit 13.
Exhibit 13
6
6 4
2 3 4 9 7
5 4 4
1 2 3 3 5 12 9
As per Exhibit 13, the critical path is (1-2-4-6-7-9), with a length of 22 weeks
and a total direct cost of Rs.82,700. The only uncrashed activity on this critical path is
(1-2). Crashing this we get Exhibit 14.
Exhibit 14
6 4
2 3 4 9 7
2 4 4
1 2 3 3 5 12 9
As per Exhibit 14, the critical path is (1-3-4-6-7-9) with a duration of 20 weeks,
and a total direct cost of Rs.85,700. Since all activities on this path are crashed, there is
no possibility of further time reduction.
Exhibit 15 shows the time-cost relationship.
Exhibit 15
Project Duration and Total Cost
Exhibit Activities Crashed Project Total Total Total cost
duration direct indirect (Rs.)
(in weeks) cost cost
(Rs.) (Rs.)
6 none 34 66,000 34,000 1,00,000
8 (6-7) 31 66,900 31,000 97,900
9 (6-7), (1-3) and (7-9) 29 69,100 29,000 98,100
10 (6-7), (1-3), (7-9) and (4-6) 26 72,100 26,000 98,100
11 (6-7), (1-3), (7-9), (4-6) and (3-5) 25 75,700 25,000 1,00,700
12 (6-7), (1-3), (7-9), (4-6), (3-5) and (2-4) 23 78,900 23,000 1,01,700
13 (6-7), (1-3), (7-9), (4-6), (3-5), (2-4) and (3-4) 22 80,500 22,000 1,02,500
14 (6-7), (1-3), (7-9), (4-6), (3-5), (2-4), (3-4) and 20 83,500 20,000 1,03,500
(1-2)
If the objective is to minimise the total cost of the project, the pattern to crashing
suggested by Exhibit 10 may appear as the best. However, it is possible to reduce the
cost further without increasing the project duration beyond 26 weeks by decrashing
some activities on the non-critical paths. To do so, begin with the activity which has the
highest time-cost slope and proceed in the order of decreasing time-cost slope.