Payback, NPV, Managerial Incentives, Ethical Behavior

Kent Tessman, manager of a Dairy Products Division, was pleased with his divisions performance over the past three years. Each year, divisional profits had increased, and he had earned a sizable bonus. (Bonuses are a linear function of the divisions reported income.) He had also received considerable attention from higher management. A vice president had told him in confidence that if his performance over the next three years matched his first three, he would be promoted to higher management.

Determined to fulfill these expectations, Kent made sure that he personally reviewed every capital budget request. He wanted to be certain that any funds invested would provide good, solid returns. (The divisions cost of capital is 10 percent.) At the moment, he is reviewing two independent requests. Proposal A involves automating a manufacturing operation that is currently labor intensive. Proposal B centers on developing and marketing a new ice cream product. Proposal A requires an initial outlay of $250,000, and Proposal B requires $312,500. Both projects could be funded, given the status of the divisions capital budget. Both have an expected life of six years and have the following projected after-tax cash flows:

Year	Proposal A	Proposal B
1	$150,000	$(37,500)
2	125,000	(25,000)
3	75,000	(12,500)
4	37,500	212,500
5	25,000	275,000
6	12,500	337,500

After careful consideration of each investment, Kent approved funding of Proposal A and rejected Proposal B.

The present value tables provided in Exhibit 19B.1 and Exhibit 19B.2 must be used to solve the following problems.

Required:

1. Compute the NPV for each proposal. Round intermediate calculations and your final answers to the nearest dollar.

	NPV
Proposal A	$
Proposal B	$

Can you show how you calculate NPV in Excel