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 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
Get step-by-step solutions from verified subject matter experts
