Year

(t)

Cash inflows (CF)

1

$35 comma 00035,000

2

$40 comma 00040,000

3

$20 comma 00020,000

4

$40 comma 00040,000

5

$25 comma 00025,000

Using Excel and all formulas.Payback, NPV, and IRRRieger International is attempting to evaluate the feasibility of investing

$106 comma 000106,000

in a piece of equipment that has a

55-year

life. The firm has estimated the cash inflows associated with the proposal as shown in the following table:

LOADING...

. The firm has a

1111%

cost of capital.

a.Calculate the payback period for the proposed investment.

b.Calculate the net present value (NPV) for the proposed investment.

c.Calculate the internal rate of return

(IRR),

rounded to the nearest whole percent, for the proposed investment.

d.Evaluate the acceptability of the proposed investment using NPV and IRR. What recommendation would you make relative to implementation of theproject?