Question

Problem 16-19 Using net present value and internal rate of return to evaluate investment opportunities LO 16-2, 16-3

Dwight Donovan, the president of Rooney Enterprises, is considering two investment opportunities. Because of limited resources, he will be able to invest in only one of them. Project A is to purchase a machine that will enable factory automation; the machine is expected to have a useful life of five years and no salvage value. Project B supports a training program that will improve the skills of employees operating the current equipment. Initial cash expenditures for Project A are $107,000 and for Project B are $46,000. The annual expected cash inflows are $27,509 for Project A and $12,135 for Project B. Both investments are expected to provide cash flow benefits for the next five years. Rooney Enterprises’ cost of capital is 6 percent. (PV of $1 and PVA of $1) (Use appropriate factor(s) from the tables provided.)

Required

1. Compute the net present value of each project. Which project should be adopted based on the net present value approach?

2. Compute the approximate internal rate of return of each project. Which one should be adopted based on the internal rate of return approach?

Answer 1

Solution a:

Computation of NPV
			Project A		Project B
Particulars	Period	PV Factor (6%)	Amount	Present Value	Amount	Present Value
Cash outflows:
Initial investment	0	1	$107,000	$107,000.00	$46,000	$46,000.00
Present Value of Cash outflows (A)				$107,000.00		$46,000.00
Cash Inflows
Annual cash inflows	1-5	4.21236	$27,509	$115,877.81	$12,135	$51,116.99
Present Value of Cash Inflows (B)				$115,877.81		$51,116.99
Net Present Value (NPV) (B-A)				$8,877.81		$5,116.99

Project A should be adopted based on NPV approach.

Solution b:

Computation of IRR
Period	Project A		Project B
	Cash Flows	IRR	Cash Flows	IRR
0	-$107,000.00	9.00%	-$46,000.00	10.00%
1	$27,509.00		$12,135.00
2	$27,509.00		$12,135.00
3	$27,509.00		$12,135.00
4	$27,509.00		$12,135.00
5	$27,509.00		$12,135.00

Microsoft Excel Excel 8 Page Layout Review View File Home Insert Formulas Data Trace Precedents Show Formulas fix aDefine Name Calculate Now Trace DependentsError Checking fUse in Formula Calculation Calculate Sheet Options Date & Lookup & Insert AutoSum Recently Financial Logical Text Math More Name Watch Remove Arrows Evaluate Formula Window Time Reference & Trig Functions Manager Create from Selection Function Used Function Library Formula Auditing Defined Names Calculation fox O26 K M P Q R S Т U 14 15 16 Computation of IRR 17 First investment Second investment 18 Period Cash Flows Cash Flows 19 IRR IRR -G8 20 -E8 -E13 -G13 21 1 EM21 E021 22 2 EM22 EO22 3 23 4 -O23 24 M23 |=IRR(020 :025) 5 -IRR(M20: M25)024 M24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Sheet60 (2) Sheet34 Sheet191 (2) Sheet252 Sheet164 (7) Sheet76 Sheet42 (4) Sheet831 Sheet265 II 100% Ready Circular References EEE 9:45 AM Microsoft E... WAnswers - .. Inbox-pan... Lease Acco... image (7) -.. Libraries Answers Problem 16... PF 11/25/2019

Project B should be adopted based on IRR.

Note: As PV factor table not provided, therefore actual NPV answer may differ due to rounding off differences.