Topic 3 (II): Investment Selection, NPV and IRR (Problems 1 to 9)

Problem 1

Problem 1 — Capitalization of a deferred debt

Original statement · 3_II_NPV IRR.pdf

One person, Mr. Smith, is able to invest his available liquid capital at a 5 percent rate per year. Currently, another person, Mr. Martinez, must pay Mr. Smith the amount of USD 1,000, but he is going through a period of scarce liquidity and asks him to wait. How much money will Mr. Smith require if it is delayed a year? What if it is a two-year delay? What if it were three years of deferment?

Data and model

SymbolMeaningValue
$C_0$debt today1,000
$i$rate at which Mr. Smith can invest5% per year
$n$years of delay1, 2, 3

Mr. Smith must receive the amount that, invested at 5%, equals having the 1,000 today: the future (capitalized) value with compound interest,

$$C_n = C_0\,(1 + i)^n$$

This is the capitalization rule used in the key; the course decks on disk do not state it.

Solution

Step 1. One, two and three years

$$\begin{aligned} C_1 &= 1{,}000 \times 1.05 = 1{,}050 \\ C_2 &= 1{,}000 \times 1.05^2 = 1{,}000 \times 1.1025 = 1{,}102.50 \\ C_3 &= 1{,}000 \times 1.05^3 = 1{,}000 \times 1.157625 = 1{,}157.63 \end{aligned}$$

Each year the interest is earned on the previous year's balance, so the yearly increase grows: 50, then 52.50, then 55.13.

Checks and official key

  • Check: $C_3 = C_2 \times 1.05 = 1{,}102.50 \times 1.05 = 1{,}157.63$. ✓
  • Check against the official key (3_II_NPV_NPV IRR_solutions.pdf, p. 1): 1,050, 1,102.5 and 1,157.62. Same results ($1{,}157.625$ is truncated to 1,157.62 in the key and rounded to 1,157.63 here).
Problem 2

Problem 2 — Alfa, S.A.: new debt with a constant financial structure

Original statement · 3_II_NPV IRR.pdf

In year 0 the company Alfa S.A. has the following financial structure: capital 6,000,000; reserves 4,800,000; debt 7,200,000; total 18,000,000. If this company can retain profits of 1,200,000 euros at the end of year 1, what is its ability to obtain new debt in year 1 (how much more can it borrow in year 1 compared to year 0) without changing its financial structure?

Data and model

ItemYear 0 (€)
Capital6,000,000
Reserves4,800,000
Debt7,200,000
Total18,000,000
Retained profit of year 11,200,000

Equity is capital plus reserves, and the financial structure is the share of equity and of debt in the total [Slides 33-35 of Topic 3]. Retained profit increases the reserves, so equity grows; keeping the structure means keeping those shares.

Solution

Step 1. Structure in year 0

$$E_0 = 6{,}000{,}000 + 4{,}800{,}000 = 10{,}800{,}000 \qquad \frac{E_0}{18{,}000{,}000} = 0.60 \qquad \frac{D_0}{18{,}000{,}000} = \frac{7{,}200{,}000}{18{,}000{,}000} = 0.40$$

Step 2. Equity and total in year 1

$$E_1 = 10{,}800{,}000 + 1{,}200{,}000 = 12{,}000{,}000$$

Equity must still be 60% of the total:

$$0.60 = \frac{12{,}000{,}000}{T_1} \quad\Rightarrow\quad T_1 = 20{,}000{,}000$$

Step 3. Debt in year 1 and new debt

$$D_1 = 0.40 \times 20{,}000{,}000 = 8{,}000{,}000 \qquad \text{New debt} = D_1 - D_0 = 8{,}000{,}000 - 7{,}200{,}000 = 800{,}000 \ \text{€}$$

Checks and official key

  • Check of the ratio: debt-to-equity stays $7{,}200{,}000/10{,}800{,}000 = 8{,}000{,}000/12{,}000{,}000 = 0.667$. ✓
  • Check against the official key (3_II_NPV_NPV IRR_solutions.pdf, pp. 1-2): equity 60%, debt 40%, total 20,000,000, debt 8,000,000 and new debt 800,000 €. Same results.
Problem 3

Problem 3 — Límite, S.A.: payback of three projects

Original statement · 3_II_NPV IRR.pdf

Límite S.A. has 1,200 millions to invest in this period. Applying the criterion of recovery or payback, indicate which investment project is preferred and why.

ProjectInitial outlayQ1Q2Q3Q4Q5Q6
X1,200−200300500200400400
Y1,200200200200200200200
Z1,000125125250250250250

Data and model

Cash flows in millions, one per year. The payback (recovery) period is the time the cumulative cash flows take to equal the initial outlay; the shorter, the better. Within a year the flow is taken as uniform.

Solution

Step 1. Cumulative cash flows

YearXYZ
1−200200125
2100400250
3600600500
4800800750
51,2001,0001,000
61,6001,2001,250

Step 2. Payback periods

  • X recovers its 1,200 exactly at the end of year 5: 5 years.
  • Y recovers its 1,200 at the end of year 6: 6 years.
  • Z recovers its 1,000 exactly at the end of year 5: 5 years.

Step 3. Choice

Y is the worst. X and Z tie at 5 years, so the payback criterion alone does not separate them. Two remarks help: Z needs 200 million less, which stays available to the company, and X has a negative flow in the first year that must be financed. Beyond year 5, X returns 400 in year 6 against 250 for Z; payback ignores those flows.

Checks and official key

  • Check against the official key (3_II_NPV_NPV IRR_solutions.pdf, p. 2): payback X = 5 years and Y = 6 years agree; the key prefers X "even if it generates negative cash flow in the first year".
Discrepancy with the official solution

The key gives Z a payback of 5 years and 10 months. With the outlay of the statement (1,000) the cumulative flow reaches 1,000 exactly at the end of year 5 (table above), so the payback is 5 years. The key's figure is what an outlay of 1,200 would give: $5 + (1{,}200 - 1{,}000)/250 = 5.8$ years, about 5 years and 10 months. With the stated data X and Z tie, and the key's preference for X is not supported by payback alone.

Problem 4

Problem 4 — Maximum investment from the IRR

Original statement · 3_II_NPV IRR.pdf

What is the maximum amount we should invest in a project at time 0 if the estimated annual cash inflow is €30,000 over a period of 4 years starting from year 1? Assume that the estimated internal rate of return is 8%.

Data and model

Cash inflows $CF_1 = \dots = CF_4 = 30{,}000$ €; IRR 8%. The net present value of a project with outlay $I_0$ is

$$NPV = -I_0 + \sum_{t=1}^{n} \frac{CF_t}{(1 + k)^t}$$

and the internal rate of return is the rate that makes $NPV = 0$. The maximum outlay is the one that leaves the NPV at zero when discounted at 8%: any higher outlay would give a return below 8%.

Solution

Step 1. NPV equal to zero at 8%

$$0 = -I_0 + \frac{30{,}000}{1.08} + \frac{30{,}000}{1.08^2} + \frac{30{,}000}{1.08^3} + \frac{30{,}000}{1.08^4}$$

Step 2. Each discounted flow

$$\frac{30{,}000}{1.08} = 27{,}777.78 \qquad \frac{30{,}000}{1.1664} = 25{,}720.16 \qquad \frac{30{,}000}{1.259712} = 23{,}814.96 \qquad \frac{30{,}000}{1.36048896} = 22{,}050.90$$

Step 3. Maximum outlay

$$I_0 = 27{,}777.78 + 25{,}720.16 + 23{,}814.96 + 22{,}050.90 = 99{,}363.81 \ \text{€}$$

Checks and official key

  • Check with the annuity factor: $30{,}000 \times \dfrac{1 - 1.08^{-4}}{0.08} = 30{,}000 \times 3.312127 = 99{,}363.81$ €. ✓
  • Check against the official key (3_II_NPV_NPV IRR_solutions.pdf, pp. 2-3): $I_0 = 99{,}363.81$ €. Same result.
Problem 5

Problem 5 — NPV and payback of three projects

Original statement · 3_II_NPV IRR.pdf

Consider these projects (cash flows in euros) and answer the questions:

ProjectC0C1C2C3C4C5
A−1,000+1,0000000
B−2,000+1,000+1,000+4,000+1,000+1,000
C−3,000+1,000+1,0000+1,000+1,000

a) If the interest rate is 10%, which projects have a positive NPV? b) Calculate the payback period for each project. c) Which project(s) would be accepted by a company that uses the payback period model if the maximum period is three years?

Data and model

$NPV = \sum_{t=0}^{5} C_t/(1.10)^t$ with the discount factors $1.1^{-1} = 0.909091$, $1.1^{-2} = 0.826446$, $1.1^{-3} = 0.751315$, $1.1^{-4} = 0.683013$, $1.1^{-5} = 0.620921$. Payback: the time the cumulative flows take to recover the outlay.

Solution

Step 1. Part (a): NPV at 10%

$$NPV_A = -1{,}000 + 1{,}000 \times 0.909091 = -90.91 \ \text{€}$$
$$\begin{aligned} NPV_B &= -2{,}000 + 909.09 + 826.45 + 4{,}000 \times 0.751315 + 683.01 + 620.92 \\ &= -2{,}000 + 909.09 + 826.45 + 3{,}005.26 + 683.01 + 620.92 = 4{,}044.73 \ \text{€} \end{aligned}$$
$$NPV_C = -3{,}000 + 909.09 + 826.45 + 0 + 683.01 + 620.92 = 39.47 \ \text{€}$$

B and C have a positive NPV; A does not.

Step 2. Part (b): payback

YearA cumulativeB cumulativeC cumulative
11,0001,0001,000
21,0002,0002,000
31,0006,0002,000
41,0007,0003,000

A recovers its 1,000 in 1 year, B its 2,000 in 2 years and C its 3,000 in 4 years.

Step 3. Part (c): maximum payback of three years

A and B are accepted, C is rejected. The payback model accepts A although its NPV is negative and rejects C although its NPV is positive, because it ignores the time value of money and the flows after the cut-off. Between the two accepted projects, the NPV favours B.

Checks and official key

  • Check against the official key (3_II_NPV_NPV IRR_solutions.pdf, p. 3): $NPV_A = -90.91$, $NPV_B = 4{,}044.7$, $NPV_C = 39.47$; payback 1, 2 and 4 years; A and B accepted, and B chosen by NPV. Same results.
Problem 6

Problem 6 — NPV from a known IRR

Original statement · 3_II_NPV IRR.pdf, p. 2

Assuming an interest rate of 7%, consider a three-year investment period generating a positive cash flow of €10,000 per year with an internal rate of return of 10%. Calculate the NPV of this investment.

Data and model

$CF_1 = CF_2 = CF_3 = 10{,}000$ €, IRR 10%, discount rate $k = 7\%$. The outlay $I_0$ is not given: it follows from the IRR, the rate at which the NPV is zero. Then the NPV is computed at 7%.

Solution

Step 1. Outlay from the IRR

$$0 = -I_0 + \frac{10{,}000}{1.1} + \frac{10{,}000}{1.1^2} + \frac{10{,}000}{1.1^3} = -I_0 + 9{,}090.91 + 8{,}264.46 + 7{,}513.15$$
$$I_0 = 24{,}868.52 \ \text{€}$$

Step 2. NPV at 7%

$$NPV = -24{,}868.52 + \frac{10{,}000}{1.07} + \frac{10{,}000}{1.1449} + \frac{10{,}000}{1.225043} = -24{,}868.52 + 9{,}345.79 + 8{,}734.39 + 8{,}162.98 = 1{,}374.64 \ \text{€}$$

The NPV is positive because the discount rate (7%) is below the IRR (10%).

Checks and official key

  • Check: at $k = $ IRR the NPV would be zero; a lower rate gives a positive NPV, as found.
  • Check against the official key (3_II_NPV_NPV IRR_solutions.pdf, pp. 3-4): $I_0 = 24{,}868$ € and $NPV = 1{,}375$ €. Same results. The key also adds a part (b), not in the statement: at $k = 9\%$ the NPV is smaller but still positive, since $9\% < 10\%$; its value is $1{,}374.64 - 930.21 = 444.43$ €.
Problem 7

Problem 7 — Ranking projects by NPV with a budget

Original statement · 3_II_NPV IRR.pdf, p. 2

You want to rank, in order of preference, according to the criterion of NPV, the investment projects with initial payments and cash flows generated in the different years of their duration, listed in the table below:

ProjectYear 1Year 2Year 3Year 4Year 5Initial outlay
A2,0002,0003,5003,5003,50010,000
B2,0002,0004,0004,0004,00011,000
C3,0003,0004,0004,0004,00012,000
D2,0002,00015,000——13,000
E2,0003,0005,0005,0005,00014,000
F4,0004,0004,5004,5004,50015,000

The required profitability is the same for all projects (10 percent). Which projects should be undertaken by an individual who has 40,000 euros to invest if they cannot be repeated?

Data and model

Net cash flows in euros, discount rate 10% with the factors $0.909091$, $0.826446$, $0.751315$, $0.683013$, $0.620921$ for years 1 to 5. $NPV = -I_0 + \sum CF_t/1.1^t$.

Solution

Step 1. NPV of project A

$$NPV_A = -10{,}000 + 2{,}000\,(0.909091 + 0.826446) + 3{,}500\,(0.751315 + 0.683013 + 0.620921) = -10{,}000 + 3{,}471.07 + 7{,}193.37 = 664.45 \ \text{€}$$

Step 2. All the projects

ProjectOutlayPresent value of the flowsNPVRank
A10,00010,664.45664.455
B11,00011,692.07692.074
C12,00013,427.611,427.612
D13,00014,740.801,740.801
E14,00014,573.77573.776
F15,00016,190.771,190.773

All six have a positive NPV.

Step 3. Choice with 40,000 €

Taking the projects in order of NPV: D (13,000), then C (12,000, total 25,000), then F (15,000, total 40,000). The budget is used exactly, so the individual undertakes D, C and F, with a total NPV of $1{,}740.80 + 1{,}427.61 + 1{,}190.77 = 4{,}359.18$ €.

Checks and official key

  • Check of the budget choice: no four projects fit in 40,000 € (the four cheapest cost 46,000 €), and every other set of three that fits gives less: D + C + B (36,000 €) 3,860.48 €, D + C + E (39,000 €) 3,742.18 €, D + F + A (38,000 €) 3,596.02 €.
  • Check against the official key (3_II_NPV_NPV IRR_solutions.pdf, pp. 4-5): NPVs 664.45, 692.07, 1,427.61, 1,740.8, 573.77 and 1,190.77 with the same ranking, and D, C and F selected. Same results.
Problem 8

Problem 8 — GOFRES, S.A.: return against the cost of capital

Original statement · 3_II_NPV IRR.pdf, p. 2

The director of the financial department of GOFRES, S.A. raises the possibility of investing in a project with a profitability of 8.5%. GOFRES, S.A. is funded 30% with equity capital, whose cost is estimated at 15%, and the rest with external funds, with an average cost of 8%. What would be your advice to this executive: to carry out the project or not to invest, and why? How does your answer change if you were offered another investment project with a yield of 18.5%?

Data and model

SourceShareCost
Equity30%15%
Liabilities (external funds)70%8%

The cost of capital is the weighted average cost, $K_{WACC} = K_{EQ}\,\frac{E}{E+L} + K_L\,\frac{L}{E+L}$ [Slide 37 of Topic 3]. A project creates value when its return is above that cost (profitability > cost, Slide 5 of Topic 3).

Solution

Step 1. Cost of capital

$$K = 0.30 \times 0.15 + 0.70 \times 0.08 = 0.045 + 0.056 = 0.101 = 10.1\%$$

Step 2. Project with 8.5%

$8.5\% < 10.1\%$: the project returns less than the funds cost. Advice: do not invest.

Step 3. Project with 18.5%

$18.5\% > 10.1\%$: the project returns more than the funds cost. Advice: invest.

Checks and official key

  • Check against the official key (3_II_NPV_NPV IRR_solutions.pdf, p. 5): $K = 0.3 \times 0.15 + 0.7 \times 0.08 = 10.1\%$; reject at 8.5%, accept at 18.5%. Same results.
Problem 9

Problem 9 — OSOPANDA, S.L.: payback, IRR and the Fisher rate

Original statement · 3_II_NPV IRR.pdf, p. 2

Company OSOPANDA, S.L. is considering an investment, for which it has two offers. The first offer (Project A) has an initial payment of €16,653 and generates cash flows of €6,500 and €13,000 during the first and second years (two-year period), respectively. The second offer (Project B) means a much higher initial payment, €71,428. It will end in a year, and it is expected to generate a positive cash flow of €76,428 by the end of that year. Answer the following questions and account for your answers:

a) Which project would the company choose if it uses the payback period model?

b) Analyze both alternatives in terms of internal rate of return (IRR).

Data and model

Project$I_0$ (€)$CF_1$ (€)$CF_2$ (€)
A16,6536,50013,000
B71,42876,428—

Payback with flows spread evenly over each year (30-day months). IRR: the rate that makes $NPV = 0$. The Fisher rate is the discount rate at which both projects have the same NPV.

Solution

Step 1. Part (a): payback

A recovers 6,500 in year 1; the remaining $16{,}653 - 6{,}500 = 10{,}153$ € come from the 13,000 of year 2 after $10{,}153/13{,}000 = 0.781$ years $= 9.37$ months: 1 year, 9 months and 11 days (0.37 × 30 days), recovered during the 12th day.

B recovers 71,428 out of 76,428 after $71{,}428/76{,}428 = 0.9346$ years $= 11.21$ months: 11 months and 6 days (0.21 × 30), recovered during the 7th day.

B has the shorter payback, so the payback model chooses B.

Step 2. Part (b): IRR of B

$$0 = -71{,}428 + \frac{76{,}428}{1 + r_B} \quad\Rightarrow\quad 1 + r_B = \frac{76{,}428}{71{,}428} = 1.0700 \quad\Rightarrow\quad r_B = 7.00\%$$

Step 3. Part (b): IRR of A

$$0 = -16{,}653 + \frac{6{,}500}{1 + r_A} + \frac{13{,}000}{(1 + r_A)^2}$$

With $x = 1 + r_A$ and multiplying by $x^2$: $16{,}653\,x^2 - 6{,}500\,x - 13{,}000 = 0$, so

$$x = \frac{6{,}500 + \sqrt{6{,}500^2 + 4 \times 16{,}653 \times 13{,}000}}{2 \times 16{,}653} = \frac{6{,}500 + \sqrt{908{,}206{,}000}}{33{,}306} = \frac{6{,}500 + 30{,}136.46}{33{,}306} = 1.1000$$

$r_A = 10.00\%$ (the negative root has no economic meaning). By IRR, A is better (10% > 7%).

Step 4. Fisher rate and the decision by the cost of capital

The two criteria disagree because the projects differ in size and duration. Setting $NPV_A(i) = NPV_B(i)$,

$$-16{,}653 + \frac{6{,}500}{1 + i} + \frac{13{,}000}{(1 + i)^2} = -71{,}428 + \frac{76{,}428}{1 + i}$$

whose root between 0 and 10% is $i \approx 5.08\%$. At $i = 0$, $NPV_A = 2{,}847$ € and $NPV_B = 5{,}000$ € (B better); at $i = 8\%$, $NPV_A = 510.92$ € and $NPV_B = -661.33$ € (A better). So:

  • cost of capital below about 5.08%: choose B (higher NPV);
  • between 5.08% and 10%: choose A;
  • above 10%: neither project has a positive NPV.

Checks and official key

  • Check of $r_A$: $6{,}500/1.1 + 13{,}000/1.21 = 5{,}909.09 + 10{,}743.80 = 16{,}652.89 \approx 16{,}653$. ✓
  • Check against the official key (3_II_NPV_NPV IRR_solutions.pdf, p. 6): payback A "1 year, 9 months and days (12...)" and B "11 months and 7 days", B preferred; IRR(A) ≈ 10%, IRR(B) ≈ 7%; Fisher rate ≈ 5% (0.0507); B below 5%, A between 5% and 10%, neither above 10%. Same results; the key counts the day in which the outlay is recovered (12th and 7th), which is why it gives one day more than the completed days above.