A company has $340,000 to invest in either Project Y or Project Z. The cash flows are as follows:

Project Y generates cash flows of $75,000 each year for five years. Project Z generates cash flows of $25,000 in the first year, $45,000 in the second year, $90,000 in the third year, $140,000 in the fourth year, and $65,000 in the fifth year. The discount rate is 8%.

Required:

1. For each project, calculate the:
   • Simple payback period
   • Discounted payback period
   • Net present value
   • Internal rate of return
2. Prepare a cash flow statement for the chosen project over the five years.
3. Advise the company on which project to select based on the results of your calculations.