1. Calculate the NPV of a project that has an initial investment of $700,000.00 at an...

1. Calculate the NPV of a project that has an initial investment of $700,000.00 at an IRR of 15% with inflows of $200,000.00 each year for the next five years. Will this project be acceptable or rejected and why?

2. A company wants to find what the Net Present Value of a project is: if the initial investment is $500,000.00 at an internal rate of return of 20% with potential inflows of $250,000.00; $200,000.00; $350,000.00; $200,000.00; $275,000.00 during the next five years with additional outflows or investments in years 2, 3, and 4 of $50,000.00 for each of those years. Will this project be acceptable or rejected and why?

How to calculate in Excel

Please help!!

Thank you

Solutions

Expert Solution

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

What is the NPV of a project that has an initial investment of $7,300, with end...

What is the NPV of a project that has an initial investment of $7,300, with end of year cash flows as follows: year 1: $1,500 year 2: $2,500 year 3: $3,000 year 4: $2,500 year 5: $1,500 The interest rate is 8%

(a) Calculate the net present value (NPV) of a project which requires an initial investment of...

(a) Calculate the net present value (NPV) of a project which requires an initial investment of $243,000 and it is expected to generate a cash inflow of $58,000 each month for 12 months. Assume that the salvage value of the project is zero. The target rate of return is 12 % per annum. (b) An initial investment of $8,720 thousand (i.e. × 1,000) on plant and machinery is expected to generate cash inflows of $3,411 thousand, $4,070 thousand, $5,824 thousand...

Calculate the net present value (NPV) for a 1515-year project with an initial investment of $45...

Calculate the net present value (NPV) for a 1515-year project with an initial investment of $45 comma 00045,000 and a cash inflow of $7 comma 0007,000 per year. Assume that the firm has an opportunity cost of 1515%. Comment on the acceptability of the project. The project's net present value is $nothing. (Round to the nearest cent.)

What is the NPV for a project with the following characteristics? Initial investment is $1,700,000 Initial...

What is the NPV for a project with the following characteristics? Initial investment is $1,700,000 Initial investment is depreciated to $0 over its 10 year life Project generates incremental after-tax cash flows (OCF) of $325,000 per year over the projects life Project requires a net working capital (NWC) investment today of $40,000, which is recovered at the end of the project Assets purchased with the initial investment are expected to have a salvage value of $62,000 at the end of...

caclulate the NPV for the project that has an initial investment of $20,000 with expected after-tax...

caclulate the NPV for the project that has an initial investment of $20,000 with expected after-tax operating cash flows of $125,000 per year for each of the next 3 years. However, in preparation for its termination at the end of year 3, an additional investment of $350,000 must be made at the end of Year 2. What is the NPV? the cost of capital is 12%. Please show all calculations in excel!

What is the NPV of project A? The project would require an initial investment in equipment...

What is the NPV of project A? The project would require an initial investment in equipment of 60,000 dollars and would last for either 3 years or 4 years (the date when the project ends will not be known until it happens and that will be when the equipment stops working in either 3 years from today or 4 years from today). Annual operating cash flows of 18,600 dollars per year are expected each year until the project ends in...

Find the net present value (NPV) of a project that requires an initial investment of $110,000...

Find the net present value (NPV) of a project that requires an initial investment of $110,000 and provides cash flows of $13,500 per year for 15 years? The investor’s required return is 18.5%.

17. Find the net present value (NPV) of a project that requires an initial investment of...

17. Find the net present value (NPV) of a project that requires an initial investment of $100,000 and provides cash flows of $14,000 per year for 12 years? The investor’s required return is 11%.

Calculate the Payback Period and Discounted Payback Period for the following project: 1. An initial investment...

Calculate the Payback Period and Discounted Payback Period for the following project: 1. An initial investment of $20,000 with expected after-tax operating cash flows of $125,000 per year for each of the next 3 years. However, in preparation for its termination at the end of year 3, an additional investment of $350,000 must be made at the end of Year 2. Please show all work in excel.

3. A project has the following characteristics: Initial investment is $1,700,000 Initial investment is depreciated to...

3. A project has the following characteristics: Initial investment is $1,700,000 Initial investment is depreciated to $0 over its 10 year life Project generates incremental after-tax cash flows (OCF) of $325,000 per year over the projects life Project requires a net working capital (NWC) investment today of $50,000, which is recovered at the end of the project Assets purchased with the initial investment are expected to have a salvage value of $74,000 at the end of the project The firm...

Subjects