Question

In: Finance

A project has an initial cost of $40,000, expected net cash inflows of $12,000 per year...

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!

Solutions

Expert Solution

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:


Related Solutions

A project has an initial cost of $58,975, expected net cash inflows of $12,000 per year...
A project has an initial cost of $58,975, expected net cash inflows of $12,000 per year for 11 years, and a cost of capital of 10%. What is the project's NPV? (Hint: Begin by constructing a time line.) Do not round your intermediate calculations. Round your answer to the nearest cent.
A project has an initial cost of $70,000, expected net cash inflows of $12,000 per year...
A project has an initial cost of $70,000, expected net cash inflows of $12,000 per year for 9 years, and a cost of capital of 9%. What is the project's NPV? (Hint: Begin by constructing a time line.) Do not round intermediate calculations. Round your answer to the nearest cent. $
A project has an initial cost of $70,225, expected net cash inflows of $12,000 per year...
A project has an initial cost of $70,225, expected net cash inflows of $12,000 per year for 12 years, and a cost of capital of 8%. What is the project's NPV? (Hint: Begin by constructing a time line.) Do not round your intermediate calculations. Round your answer to the nearest cent.
A project has an initial cost of $50,675, expected net cash inflows of $12,000 per year...
A project has an initial cost of $50,675, expected net cash inflows of $12,000 per year for 9 years, and a cost of capital of 13%. What is the project's payback period? Round your answer to two decimal places.
A project has an initial cost of $42,450, expected net cash inflows of $12,000 per year...
A project has an initial cost of $42,450, expected net cash inflows of $12,000 per year for 11 years, and a cost of capital of 14%. What is the project's NPV? (Hint: Begin by constructing a time line.) Do not round your intermediate calculations. Round your answer to the nearest cent.
A project has an initial cost of $37,875, expected net cash inflows of $12,000 per year...
A project has an initial cost of $37,875, expected net cash inflows of $12,000 per year for 8 years, and a cost of capital of 12%. What is the project's PI? Do not round your intermediate calculations. Round your answer to two decimal places.
A project has an initial cost of $52,125, expected net cash inflows of $12,000 per year...
A project has an initial cost of $52,125, expected net cash inflows of $12,000 per year for 7 years, and a cost of capital of 12%. What is the project's discounted payback period? (Hint: Begin by constructing a time line.) Do not round intermediate calculations. Round your answer to two decimal places.
A project has an initial cost of $65,475, expected net cash inflows of $12,000 per year...
A project has an initial cost of $65,475, expected net cash inflows of $12,000 per year for 11 years, and a cost of capital of 10%. What is the project's NPV? (Hint: Begin by constructing a time line.) Do not round your intermediate calculations. Round your answer to the nearest cent.
A project has an initial cost of $40,000, expected net cash inflows of $9,000 per year...
A project has an initial cost of $40,000, expected net cash inflows of $9,000 per year for 7 years, and a cost of capital of 11%. What is the project’s NPV? (Hint: Begin by constructing a time line.) (10-2) Refer to Problem 10-1. What is the project’s IRR? (10-3) Refer to Problem 10-1. What is the project’s MIRR? (10-4) Refer to Problem 10-1. What is the project’s PI? (10-5) Refer to Problem 10-1. What is the project’s payback period? (10-6)...
A project has an initial cost of $40,000, expected net cash inflows of $9,000 per year...
A project has an initial cost of $40,000, expected net cash inflows of $9,000 per year for 9 years, and a cost of capital of 11%. What is the project's discounted payback period? Round your answer to two decimal places.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT