Present Value = Future value/ ((1+r)^t) | |||||||||
where r is the interest rate that is 9% and t is the time period in years. | |||||||||
Net present value (NPV) = initial investment + sum of present values of future cash flows. | |||||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | |
cash flow | -52000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | |
present value | 10091.74 | 9258.48 | 8494.018 | 7792.677 | 7149.245 | 6558.941 | 6017.377 | ||
NPV | 3362.481 | ||||||||
a) | The NPV is $3362.481. | ||||||||
The IRR is the internal rate of return | |||||||||
Use the financial formulas function in excel to find the IRR | |||||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | |
cash flow | -52000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | |
IRR | 10.90% | ||||||||
b) | The internal rate of return(IRR) is 10.90%. | ||||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | |
cash flow | -52000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | |
It takes 4 years to recover 44000 | |||||||||
Remaining amount to be recovered is 52000 - 44000 | |||||||||
Remaining amount to be recovered is 8000. | |||||||||
11000 is recovered in one year from year 4 to year 5. | |||||||||
8000 will be recovered in (8000/11000)*1 years | |||||||||
8000 will be recovered in .72 years. | |||||||||
Payback period | 4.72 years | ||||||||
c) | The payback period is approximately 4 years and 9 months. |
1. A project has and initial cost of $52,000, expected net cash inflows of $11,000 per...
A project has an initial cost of $55,000, expected net cash inflows of $11,000 per year for 10 years, and a cost of capital of 9%. What is the project's IRR? A project has an initial cost of $62,025, expected net cash inflows of $13,000 per year for 12 years, and a cost of capital of 10%. What is the project's MIRR? A project has an initial cost of $51,225, expected net cash inflows of $11,000 per year for 8...
A project has an initial cost of $57,000, expected net cash inflows of $11,000 per year for 7 years, and a cost of capital of 11%. What is the project's payback period? Round your answer to two decimal places.
1. A project has an initial cost of $59,925, expected net cash inflows of $14,000 per year for 6 years, and a cost of capital of 9%. What is the project's PI? Do not round your intermediate calculations. Round your answer to two decimal places. 2. A project has an initial cost of $56,300, expected net cash inflows of $12,000 per year for 8 years, and a cost of capital of 12%. What is the project's payback period? Round your...
1. A project has an initial cost of $37,050, expected net cash inflows of $12,000 per year for 7 years, and a cost of capital of 13%. What is the project's PI? Do not round your intermediate calculations. Round your answer to two decimal places. 2. A project has an initial cost of $49,700, expected net cash inflows of $11,000 per year for 8 years, and a cost of capital of 11%. What is the project's payback period? Round your...
A project has an initial cost of $42,200, expected net cash inflows of $12,000 per year for 9 years, and a cost of capital of 13%. 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 $56,300, expected net cash inflows of $14,000 per year for 9 years, and a cost of capital of 11%. What is the project's payback period? Round your answer to...
A project has an initial cost of $44,700, expected net cash inflows of $15,000 per year for 12 years, and a cost of capital of 13%. 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 $60,000, expected net cash inflows of $14,000 per year for 9 years, and a cost of capital of 8%. What is the...
A project has an initial cost of $43,175 expected net cash inflows of 11,000 per year for 10 years and a cost of capital of 10% what is the projects PI
A project has an initial cost of $60,000, expected net cash inflows of $13,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.
A project has an initial cost of $71,650, expected net cash inflows of $15,000 per year for 9 years, and a cost of capital of 12%. What is the project's payback period? Round your answer to two decimal places.
A project has an initial cost of $49,875, expected net cash inflows of $13,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.