Chapter 8, Problem 15QP

LO1, LO3, LO4, LO6 15.    Comparing Investment Criteria. Consider the following two mutually exclusive projects:

Year	Cash Flow (A)	Cash Flow (B)
0	–$235,000	–$47,000
1	29,000	28,700
2	45,000	19,900
3	51,000	17,300
4	325,000	16,200

Whichever project you choose, if any, you require a return of 13 percent on your investment.

a.    If you apply the payback criterion, which investment will you choose? Why?

b.    If you apply the NPV criterion, which investment will you choose? Why?

c.    If you apply the IRR criterion, which investment will you choose? Why?

d.    If you apply the profitability index criterion, which investment will you choose? Why?

e.    Based on your answers in parts (a) through (d), which project will you finally choose? Why?

Summary Introduction

To compute: The payback period.

Introduction:

Capital budgeting is a process, where the business identifies and assesses potential investments or expenses that are larger (in general).

Answer to Problem 15QP

Here, Project B must be accepted as it pays back sooner than Project A.

Explanation of Solution

Given information:

The cash flows for two mutually exclusive projects are $29,000, $45,000, $51,000, $325,000 for Project A for year 1, year 2, year 3, and year 4 respectively. Project A has an initial investment of $235,000. The cash flows of Project B are $28,700, $19,900, $17,300, and $16,200 for year 1, year 2, year 3, and year 4 respectively. The initial investment for Project B is $47,000. The rate of return is 13%.

Formula to compute the payback period of a project:

$\text{Payback period}=\left[\begin{array}{l}\text{Maximum number of years to }\\ \text{recover the amount}+\left(\frac{\text{Amount remaining to be recovered}}{4^{\text{th}}\text{ year cash flow}}\right)\end{array}\right]$

Compute the payback period of a project for Project A:

$\begin{array}{c}\text{Payback period}=\left[\begin{array}{l}\text{Maximum number of years to }\\ \text{recover the amount}+\left(\frac{\text{Amount remaining to be recovered}}{4^{\text{th}}\text{ year cash flow}}\right)\end{array}\right]{\displaystyle \sum _{}^{}}\\ =3+\left(\frac{\$110,000}{\$325,000}\right)\\ =3.34\text{ years}\end{array}$

Hence, the payback period is 3.34 years for Project A.

Compute the payback period of a project for Project B:

$\begin{array}{c}\text{Payback period}=\left[\begin{array}{l}\text{Maximum number of years to }\\ \text{recover the amount}+\left(\frac{\text{Amount remaining to be recovered}}{2^{\text{nd}}\text{ year cash flow}}\right)\end{array}\right]\\ =1+\left(\frac{\$18,300}{\$19,900}\right)\\ =1.92\text{ years}\end{array}$

Hence, the payback period is 1.92 years for Project B.

Summary Introduction

To compute: The NPV (Net Present Value).

Introduction:

Capital budgeting is a process, where the business identifies and assesses potential investments or expenses that are larger (in general).

Answer to Problem 15QP

Here, Project A must be accepted as the NPV is higher in Project A.

Explanation of Solution

Given information:

The cash flows for two mutually exclusive projects are $29,000, $45,000, $51,000, $325,000 for Project A for year 1, year 2, year 3, and year 4 respectively. Project A has an initial investment of $235,000. The cash flows of Project B are $28,700, $19,900, $17,300, and $16,200 for year 1, year 2, year 3, and year 4 respectively. The initial investment for Project B is $47,000. The rate of return is 13%.

Formula to calculate the NPV:

$\text{NPV}=\left[\begin{array}{l}\frac{\text{Cash flow of Year}1}{1+\text{Rate of discount}}+\frac{\text{Cash flow of Year}2}{1+\text{Rate of discount}}+\\ \frac{\text{Cash flow of Year}3}{1+\text{Rate of discount}}+\frac{\text{Cash flow of Year}4}{1+\text{Rate of discount}}-\\ \text{Initial investment}\end{array}\right]$

Calculate the NPV for Project A:

$\begin{array}{c}\text{NPV for Project A}=\left[\begin{array}{l}\frac{\text{Cash flow of Year}1}{1+\text{Rate of discount}}+\frac{\text{Cash flow of Year}2}{1+\text{Rate of discount}}+\\ \frac{\text{Cash flow of Year}3}{1+\text{Rate of discount}}+\frac{\text{Cash flow of Year}4}{1+\text{Rate of discount}}-\\ \text{Initial investment}\end{array}\right]\\ =\frac{\text{\$29,000}}{1.13}+\frac{\$45,000}{{\left(\text{1}\text{.13}\right)}^{\text{2}}}+\frac{\$51,000}{{\left(\text{1}\text{.13}\right)}^3}+\frac{\$325,000}{{\left(\text{1}\text{.13}\right)}^4}-\$235,000\\ =\$25,663.71681+\$35,241.60075+\$35,345.55828+\$199,328.5865-\$235,000\\ =\$60,579.46\end{array}$

Hence, the NPV for Project A is $60,579.46.

Calculate the NPV for Project B:

$\begin{array}{c}\text{NPV for Project A}=\left[\begin{array}{l}\frac{\text{Cash flow of Year}1}{1+\text{Rate of discount}}+\frac{\text{Cash flow of Year}2}{1+\text{Rate of discount}}+\\ \frac{\text{Cash flow of Year}3}{1+\text{Rate of discount}}+\frac{\text{Cash flow of Year}4}{1+\text{Rate of discount}}-\\ \text{Initial investment}\end{array}\right]\\ =\frac{\text{\$28,700}}{1.13}+\frac{\$19,900}{{\left(\text{1}\text{.13}\right)}^{\text{2}}}+\frac{\$17,300}{{\left(\text{1}\text{.13}\right)}^3}+\frac{\$16,200}{{\left(\text{1}\text{.13}\right)}^4}-\$47,000\\ =\$25,398.23009+\$15,584.619+\$11,989.76781+\$9,935.763388-\$47,000\\ =\$15,908.38\end{array}$

Hence, the NPV for Project B is $15,908.38.

Summary Introduction

To compute: The IRR for the project.

Introduction:

Capital budgeting is a process, where the business identifies and assesses potential investments or expenses that are larger (in general).

Answer to Problem 15QP

Here, Project B must be accepted as the IRR is higher in Project B.

Explanation of Solution

Given information:

The cash flows for two mutually exclusive projects are $29,000, $45,000, $51,000, $325,000 for Project A for year 1, year 2, year 3, and year 4 respectively. Project A has an initial investment of $235,000. The cash flows of Project B are $28,700, $19,900, $17,300, and $16,200 for year 1, year 2, year 3, and year 4 respectively. The initial investment for Project B is $47,000. The rate of return is 13%.

Equation of IRR of Project A:

$0=-\$235,000+\frac{\$29,000}{\left(1+\text{IRR}\right)}+\frac{\$45,000}{{\left(1+\text{IRR}\right)}^2}+\frac{\$51,000}{{\left(1+\text{IRR}\right)}^3}+\frac{\$325,000}{{\left(1+\text{IRR}\right)}^4}$

Compute IRR for Project A using a spreadsheet:

Step 1:

• Type the equation of NPV in H6 in the spreadsheet and consider the IRR value as H7.

Step 2:

• Assume the IRR value as 10%.

Step 3:

• In the spreadsheet, go to data and select the what-if analysis.
• In the what-if analysis, select goal seek.
• In set cell select H6 (the formula).
• The “To value” is considered as 0 (the assumption value for NPV).
• The H7 cell is selected for the by changing cell.

Step 4:

• Following the previous step click OK in the goal seek. The goal seek status appears with the IRR value.

Step 5:

• Thevalue appears to be 21.0164258735852%.

Hence, the IRR value is 21.02%.

Equation of IRR of Project B:

$0=-\$47,000+\frac{\$28,700}{\left(1+\text{IRR}\right)}+\frac{\$19,900}{{\left(1+\text{IRR}\right)}^2}+\frac{\$17,300}{{\left(1+\text{IRR}\right)}^3}+\frac{\$16,200}{{\left(1+\text{IRR}\right)}^4}$

Compute IRR for Project B using a spreadsheet:

Step 1:

• Type the equation of NPV in H6 in the spreadsheet and consider the IRR value as H7.

Step 2:

• Assume the IRR value as 10%.

Step 3:

• In the spreadsheet, go to data and select the what-if analysis.
• In the what-if analysis, select goal seek.
• In set cell, select H6 (the formula).
• The “To value” is considered as 0 (the assumption value for NPV).
• The H7 cell is selected for the by changing cell.

Step 4:

• Following the previous step, click OK in the goal seek. The goal seek status appears with the IRR value.

Step 5:

• Thevalue appears to be 30.5678172386103%.

Hence, the IRR value is 30.57%.

Summary Introduction

To compute: The profitability index.

Introduction:

Capital budgeting is a process, where the business identifies and assesses potential investments or expenses that are larger (in general).

Answer to Problem 15QP

Here, Project B must be accepted as the PI is higher in Project B.

Explanation of Solution

Given information:

The cash flows for two mutually exclusive projects are $29,000, $45,000, $51,000, $325,000 for Project A for year 1, year 2, year 3, and year 4 respectively. Project A has an initial investment of $235,000. The cash flows of Project B are $28,700, $19,900, $17,300, and $16,200 for year 1, year 2, year 3, and year 4 respectively. The initial investment for Project B is $47,000. The rate of return is 13%.

Formula to compute the profitability index:

$\text{PI}\left(\text{Profitability Index}\right)=\left[\frac{\left(\begin{array}{l}\frac{\text{Cash flow for year}1}{1+\text{Rate of discount}}+\frac{\text{Cash flow for year}2}{1+\text{Rate of discount}}+\\ \frac{\text{Cash flow for year}3}{1+\text{Rate of discount}}+\frac{\text{Cash flow for year4}}{1+\text{Rate of discount}}\end{array}\right)}{\text{Initial investment}}\right]$

Compute the profitability index for Project A:

$\begin{array}{c}\text{PI}\left(\text{Profitability Index}\right)=\left[\frac{\left(\begin{array}{l}\frac{\text{Cash flow for year}1}{1+\text{Rate of discount}}+\frac{\text{Cash flow for year}2}{1+\text{Rate of discount}}+\\ \frac{\text{Cash flow for year}3}{1+\text{Rate of discount}}+\frac{\text{Cash flow for year4}}{1+\text{Rate of discount}}\end{array}\right)}{\text{Initial investment}}\right]\\ =\left[\frac{\frac{\text{\$29,000}}{1.13}+\frac{\$45,000}{{\left(\text{1}\text{.13}\right)}^{\text{2}}}+\frac{\$51,000}{{\left(\text{1}\text{.13}\right)}^3}+\frac{\$325,000}{{\left(\text{1}\text{.13}\right)}^4}}{\$235,000}\right]\\ =\frac{\$25,663.71681+\$35,241.60075+\$35,345.55828+\$199,328.5865}{\$235,000}\\ =1.258\end{array}$

Hence, the profitability index for Project A is $1.258.

Compute the profitability index for Project B:

$\begin{array}{c}\text{PI}\left(\text{Profitability Index}\right)=\left[\frac{\left(\begin{array}{l}\frac{\text{Cash flow for year}1}{1+\text{Rate of discount}}+\frac{\text{Cash flow for year}2}{1+\text{Rate of discount}}+\\ \frac{\text{Cash flow for year}3}{1+\text{Rate of discount}}+\frac{\text{Cash flow for year4}}{1+\text{Rate of discount}}\end{array}\right)}{\text{Initial investment}}\right]\\ \text{=}\frac{\frac{\text{\$28,700}}{1.13}+\frac{\$19,900}{{\left(\text{1}\text{.13}\right)}^{\text{2}}}+\frac{\$17,300}{{\left(\text{1}\text{.13}\right)}^3}+\frac{\$16,200}{{\left(\text{1}\text{.13}\right)}^4}}{\$47,000}\\ =\frac{\$25,398.23009+\$15,584.619+\$11,989.76781+\$9,935.763388}{\$47,000}\\ =1.338\end{array}$

Hence, the profitability index for Project B is $1.338.

Summary Introduction

To discuss: The project that Person X will select with a reason.

Introduction:

Capital budgeting is a process, where the business identifies and assesses potential investments or expenses that are larger (in general).

Explanation of Solution

In this case, the criteria of NPV denote that Project A must be accepted, while payback period, profitability index, and IRR denote that Project B must be accepted. The overall decision must be based on the NPV as it does not have the ranking problem when compared with the other techniques of capital budgeting. Hence, Project A must be accepted.