An investment project costs $10,000 and has annual cash flows of $2,940 for six years.

What is the discounted payback period if the discount rate is zero percent? (Do not round intermediate calculations. Enter 0 if the project never pays back. Round your answer to 2 decimal places (e.g., 32.16).)

Discounted payback period

years

What is the discounted payback period if the discount rate is 6 percent? (Do not round intermediate calculations. Enter 0 if the project never pays back. Round your answer to 2 decimal places (e.g., 32.16).)

Discounted payback period

years

What is the discounted payback period if the discount rate is 20 percent? (Do not round intermediate calculations. Enter 0 if the project never pays back. Round your answer to 2 decimal places (e.g., 32.16).)

Discounted payback period

years

How do I enter this into excel as well? Thanks!