Discounted Cash flow question. Your company is seriously considering investing in a new project opportunity, but cash flow is tight. Top management is concerned about how long it will take for this new project to pay back the initial investment of $50,000. You have determined that the project should generate inflows of $30,000 , $30,000 , $40,000 , $25,000 and $15,000 for the next five years. Your firms required rate of return is 15%. How long will it take to pay back the initial investment?
Is there a easier way to figure this out either with a calculator and if so how do you input in to a calculator. Or is this there a way to do this through excel that makes it easier? If so what is the formula for excel?