In: Finance
A project has an initial cost of $40,000, expected net cash inflows of $12,000 per year for 9 years, and a cost of capital of 11%. What is the project's payback period? Round your answer to two decimal places.
PLEASE SHOW ME A DETAILED EXPLANATION WITH EXCEL. THANKS!
Payback is the number of years it would take for the cash inflows to re-earn cash outflow.
Slightly more complex formula structure would have been: