Exercise 24-17A Using Excel to compute IRR LO P4

Following is information on two alternative investments being considered by Jolee Company. The company requires a 11% return from its investments.

	Project A					Project B
Initial investment		$	(198,000	)			$	(143,000	)
Expected net cash flows in:
Year 1			49,500					41,500
Year 2			65,500					59,500
Year 3			89,795					75,500
Year 4			99,900					75,500
Year 5			74,500					75,500