1. Cuddles Enterprises is trying to select the best investment from among two alternatives. Each alternative involves an initial outlay of $100,000. Their cash flows follow:

Year	A	B
1	$10,000	$50,000
2	20,000	40,000
3	30,000	30,000
4	40,000	0
5	50,000	0

Required: (28 points)

Evaluate and rank each alternative based on:

(a) payback period (8 points)

(b) net present value (use a 10% discount rate) (14 points)

(c) profitability index (6 points)

Yes, excel is ok, thanks