60.1K

Verified Solution

Link Copied!

Mastery Problem: Net Present Value and Internal Rate of Return

Part One

Companies use capital investment analysis to evaluate long-term investments. Capital investment evaluation methods that use present values are (1) Net present value method (NPV) and (2) Internal rate of return (IRR) method.

Methods That Use Present Values

Of the two capital investment evaluation methods, a defining characteristic NPV and IRR is that they

consider or ignore

the time value of money. This means that money tomorrow is worth

less than or more than the same as

money today. And, that cash invested today has the potential to earn income and

decrease or increase

in value over time.

True or False: When making an investment decision between two mutually exclusive projects, the project with the greatest return on investment should be chosen.

False or True

Part Two

Net Present Value Method

Net present value (NPV) is one method that can be used to evaluate the financial viability of potential projects. It determines the present value of all future cash flowsassociated with potential projects and measures this against the cost of the project. To use net present value, a required rate of return must be defined. The required rate of return is the

maximum or minimum only

acceptable rate of return that an investment must yield for it to make sense economically. Managers often choose a required rate of return above their cost of capital to ensure that the inherent uncertainties surrounding future cash flows is addressed. This can be risky, however, as it biases the process toward short-term projects. If the NPV is positive, then the project should be

accepted or rejected

; if it is negative, then the project should be

accepted or rejected

.

Let's look at a net present value example using the present value of an ordinary annuity table.

The company has a project with a 5-year life that requires an initial investment of $200,000, and is expected to yield annual cash flows of $61,000. What is the net present value of the project if the required rate of return is set at 8%?

Calculation Steps

Present Value of an Annuity of $1 at Compound Interest.

Net Present Value =

(

$fill in the blank 637b85ffe066fbb_4

x

fill in the blank 637b85ffe066fbb_5

)

-

$fill in the blank 637b85ffe066fbb_6

Note: Round your answer to the nearest whole dollar.

What NPV does the previous calculation yield?$fill in the blank 637b85ffe066fbb_7

Based on the NPV computed above, what is indicated?

1.	The project is profitable or not profitable
2.	Yes or No , the initial investment will be recovered.
3.	Yes or No , the required rate of return will be recovered.
4.	A positive or negative NPV in excess of the initial investment and required rate of return has been achieved.

Part Three

Present Value Index

When funds for capital investments are limited, projects can be ranked using a present value index. A project with a negative net present value will have a present value index below 1.0. Also, it is important to note that a project with the largest net present value may, in fact, return a lower present value per dollar invested.

Let's look at an example of how to determine the present value index.

The company has a project with a 5-year life, an initial investment of $170,000, and is expected to yield annual cash flows of $57,000. Whathat is the present value index of the project if the required rate of return is set at 6%?

Present value index	=	Total present value of net cash flows
Initial investment

Calculation Steps

Note: Round total present value of net cash flows and initial investment to nearest dollar. Round present value index to two decimal places.

Present value index =	$fill in the blank 772ba903f024ffa_1	= fill in the blank 772ba903f024ffa_2
$fill in the blank 772ba903f024ffa_3

Part Four

Internal Rate of Return Method

The internal rate of return (IRR) method uses present value concepts to compute the rate of return from a capital investment proposal based on its expected net cash flows. This method, sometimes called the time-adjusted rate of return method, starts with the proposal's net cash flows and works backward to estimate the proposal's expected rate of return.

Let's look at an example of internal rate of return calculation with even cash flows.

A company has a project with a 6-year life, requiring an initial investment of $251,200, and is expected to yield annual cash flows of $56,000. What is the internal rate of return?

IRR Factora	=	Investmentb
		Annual cash flowsc

aIRR Factor: This is the factor which you'll use on the table for the present value of an annuity of $1 dollar in order to find the percentage which corresponds to the internal rate of return.
bInvestment: This is the present value of cash outflows associated with a project. If all of the investment is up front at the beginning of the project, the present value factor is 1.000.
cAnnual Cash Flows: This is the amount of cash flows to be received annually as a result of the project.

Calculation Steps

Present Value of an Annuity of $1 at Compound Interest.

IRR Factor =	$fill in the blank 865bad044fb5fe4_1	= fill in the blank 865bad044fb5fe4_2, rounded to 6 decimals
$fill in the blank 865bad044fb5fe4_3

The calculated factor corresponds to which percentage in the present value of ordinary annuity table?

fill in the blank 865bad044fb5fe4_4%

Part Five

APPLY THE CONCEPTS: Net present value and Present value index

Ewing Engineering is looking to invest in Project A or Project B. The data surrounding each project is provided below. Ewing's cost of capital is 10%.
Project A	Project B
This project requires an initial investment of $167,500. The project will have a life of 3 years. Annual revenues associated with the project will be $130,000 and expenses associated with the project will be $35,000.	This project requires an initial investment of $130,000. The project will have a life of 5 years. Annual revenues associated with the project will be $115,000 and expenses associated with the project will be $60,000.

Calculate the net present value and the present value index for each project using the present value tables provided below.

Present Value of $1 (a single sum) at Compound Interest.

Present Value of an Annuity of $1 at Compound Interest.

Note:
	Use a minus sign to indicate a negative NPV.
	If an amount is zero, enter "0".
	Enter the present value index to 2 decimals.

	Project A	Project B
Total present value of net cash flow	$fill in the blank 0c20effbd037fd3_1		$fill in the blank 0c20effbd037fd3_2
Amount to be invested	fill in the blank 0c20effbd037fd3_3		fill in the blank 0c20effbd037fd3_4
Net present value	$fill in the blank 0c20effbd037fd3_5		$fill in the blank 0c20effbd037fd3_6
Present value index:
Project A	fill in the blank 0c20effbd037fd3_7
Project B			fill in the blank 0c20effbd037fd3_8

Based upon net present value, which project has the more favorable profit prospects?

Both are favorable Project B Project A Can't determine

Based upon the present value index, which project is ranked higher?

Both are favorable Project B Project A Can't determine

Part Six

APPLY THE CONCEPTS: Internal rate of return

The Ewing purchasing department has made revisions to their costs and annual cash flows for Project A and Project B, as outlined below.
Project A	Project B
Project A's revised investment is $226,500. The project's life and cash flow have changed to 6 years and $49,000, respectively, while expenses have been eliminated.	Project B's revised investment is $97,300. The project's life and cash flow have changed to 5 years and $80,000 while expenses reduced slightly to $55,000.

Compute the internal rate of return factor for Project A and Project B and then identify each project's corresponding percentage from the PV ordinary annuity table.

Note: Enter the IRR factor, to 5 decimal places.

Project A: The calculated IRR factor is fill in the blank bd3862088ff0ff6_1 and this value corresponds to which percentage in the present value of ordinary annuity table? fill in the blank bd3862088ff0ff6_2%

Project B: The calculated IRR factor is fill in the blank bd3862088ff0ff6_3 and this value corresponds to which percentage in the present value of ordinary annuity table? fill in the blank bd3862088ff0ff6_4%

Answer & Explanation Solved by verified expert

See Answer