Lenitnes Company is considering an investment in technology to improve its operations. The investment will require an initial outlay of 250000 and will yield the following expected cash flows . Management requires 10% return on its investments.

cash flow

period 1 =125000

period 2 =94000

period 3 =75000

period 4 =52000

Period 5 = 47000

Determine the payback period for investment .

Determine the break-even time for this investment .

Determine the net present value for its investment.

I would like to know how to do this problem in excel?