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
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? Thank you
Step by Step Solution
There are 3 Steps involved in it
Step: 1
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started