Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

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

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_step_2

Step: 3

blur-text-image_step3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Handbook Of Credit Risk Management

Authors: Sylvain Bouteille, Diane Coogan-Pushner

2nd Edition

ISBN: 1119835631, 978-1119835639

More Books

Students explore these related Finance questions