Please use a spreadsheet or a step-by-step solution process (i.e., a formula and algebraic way of solving the problem) if possible. Thanks.

Consider two mutually exclusive new product launch projects that Hagano Golf is considering. Assume the discount rate for both products is 15 percent. 219\" Naga no NP30. Professional clubs that will take an initial investment of $130,000 at Year 0. For each of the next 5 years, [Years 1-5}, sales will generate a consistent cash flow of $330,000 per year. Introduction of new product at \"fear 6 will terminate further cash ows from this project. \"We\" Naga no idsso. Highend amateur clubs that will take an initial investment of $040,000 at \"fear 0. Cash ow at Year I is $230,000. In each subsequent year, cash ow will grow at 10 percent per year. Introduction of new product at \"fear 6 will tenninate further cash ows from this project. Year "Fl-30' NEED 0 $?30,000 $340,00-0 1 330,000 230,000 2 330,000 303,000 3 330,000 333,300 4 330,000 312,530 5 330,000 403,343 I Year NP-30 NX-20 -$730,000 -$940,000 330,000 280,000 330,000 308,000 3 330,000 338,800 330,000 372,680 330,000 409,948 Complete the following table: (Do not round intermediate calculations. Round your "PI" answers to 3 decimal places, e.g., 32.161, and other answers to 2 decimal places, e.g., 32.16. Enter your IRR answers as a percent.) NP-30 NX-20 Payback years years IRR % PI NPV