Question: Please show all intermediate steps and formulas used. Use excel to complete the problem. An Investment project has annual cash Inflows of $5,200, $3,000, $4,300,

Please show all intermediate steps and formulas used. Use excel to completePlease show all intermediate steps and formulas used. Use excel to complete the problem.

An Investment project has annual cash Inflows of $5,200, $3,000, $4,300, and $3,500, and a discount rate of 13 percent. a. What is the discounted payback period for these cash flows if the initial cost is $4,900? (Do not round Intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the discounted payback period for these cash flows if the initial cost is $7,000? (Do not round Intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. What is the discounted payback period for these cash flows if the initial cost is $10,000? (Do not round Intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) years b. Discounted payback period Discounted payback period Discounted payback period years c. years

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!