Question: Please show all intermediate steps and formulas used. Use excel to complete the problem. An Investment project provides cash Inflows of $735 per year for
Please show all intermediate steps and formulas used. Use excel to complete the problem.
An Investment project provides cash Inflows of $735 per year for eight years. a. What is the project payback period of the initial cost is $1,950? (Enter o If the project never pays back. Do not round Intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the project payback period if the initial cost is $3,800? (Enter O if the project never pays back. Do not round Intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. What is the project payback period if the initial cost is $5,900? (Enter o if the project never pays back. Do not round Intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) a. years Payback period Payback period b. years Payback period years
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
