Lepton Industries has a project with the following projected cash flows: Initial Cost, Year 0: $468,000...

Lepton Industries has a project with the following projected cash flows: Initial Cost, Year 0: $468,000 Cash flow year one: $135,000 Cash flow year two: $240,000 Cash flow year three: $185,000 Cash flow year four: $135,000 Plot the NPV profile of this project in Excel. Start with discount rate equal to zero and increase the discount rate by 2% increments until discount rate equal to 30%. For what discount rates would Lepton accept this project? For what discount rates would Lepton reject this project? What’s your estimate about the IRR of this project?

Solutions

Expert Solution

SEE EXCEL SHEET IMAGE

Go through it, Any doubts, please feel free to ask, Give positive feedback, Thank you

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Net present value. Lepton Industries has a project with the following projected cash flows: Initial cost:...

Net present value. Lepton Industries has a project with the following projected cash flows: Initial cost: $460,000 Cash flow year one: $132,000 Cash flow year two: $200,000 Cash flow year three: $191,000 Cash flow year four: $132,000 a. Using a discount rate of 11% for this project and the NPV model, determine whether the company should accept or reject this project. b. Should the company accept or reject it using a discount rate of 13%? c. Should the company accept...

Net present value. Quark Industries has a project with the following projected cash flows: Initial cost:...

Net present value. Quark Industries has a project with the following projected cash flows: Initial cost: $210,000 Cash flow year one: $25,000 Cash flow year two: $72,000 Cash flow year three: $146,000 Cash flow year four: $146,000 a. Using a discount rate of 11% for this project and the NPV model, determine whether the company should accept or reject this project. b. Should the company accept or reject it using a discount rate of 13%? c. Should the company accept...

Net present value. Quark Industries has a project with the following projected cash flows: Initial cost:...

Net present value. Quark Industries has a project with the following projected cash flows: Initial cost: $270,000 Cash flow year one: $24,000 Cash flow year two: $79,000 Cash flow year three: $155,000 Cash flow year four: $155,000 a. Using a discount rate of 10% for this project and the NPV model, determine whether the company should accept or reject this project. b. Should the company accept or reject it using a discount rate of 13%? c. Should the company accept...

Project Q has an initial cost of $257,412 and projected cash flows of $123,300 in Year...

Project Q has an initial cost of $257,412 and projected cash flows of $123,300 in Year 1 and $180,300 in Year 2. Project R has an initial cost of $349,000 and projected cash flows of $184,500 in Year 1 and $230,600 in Year 2. The discount rate is 12.2 percent and the projects are mutually exclusive. Which project(s), if any, should be accepted based on the net present value rule? A. Accept both Projects. B. Accept Project R and reject...

Project A has an initial cost of $211,400 and projected cash flows of $46,200, $64,900, and...

Project A has an initial cost of $211,400 and projected cash flows of $46,200, $64,900, and $135,800 for Years 1 to 3, respectively. Project B has an initial cost of $187,900 and projected cash flows of $43,200, $59,700, and $125,600 for Years 1 to 3, respectively. What is the incremental IRRA–B of these two mutually exclusive projects?

Tipton Industries is considering a project that has the following cash flows: Year Cash Flow 0...

Tipton Industries is considering a project that has the following cash flows: Year Cash Flow 0 -6,500 1 2,000 2 3,000 3 3,000 4 1,500 The project has a WACC (cost of capital) of 12% a. what is the firm's payback? b. what is the NPV? c. what is the IRR? d. is this profit profitable? explain

Hendrix Guitar is considering the following Project. The Projected cash flows are below: Initial Cost is...

Hendrix Guitar is considering the following Project. The Projected cash flows are below: Initial Cost is $ 2.1 million; annual net cash flows are $750, 000 per year for 5 years. what is the discounted Payback Period if the appropriate discount rate is 7.5%?

The projected net cash flows for a project are (in $thousands): Year Year 0 Year 1...

The projected net cash flows for a project are (in $thousands): Year Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 $(350) $40 $100 $210 $260 $160 Assuming the initial investment is depreciated over the life of the project, the accounting rate of return for the project is Select one: a. 40% b. 25% c. 48% d. 33%

Hodgkiss Enterprises has gathered projected cash flows for two projects. Year Project I Project J 0...

Hodgkiss Enterprises has gathered projected cash flows for two projects. Year Project I Project J 0 –$ 259,000 –$ 259,000 1 114,100 90,400 2 104,800 99,900 3 88,800 101,900 4 77,800 108,900 At what interest rate would the company be indifferent between the two projects? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Interest rate % Which project is better if the required return is above this interest...

Hodgkiss Enterprises has gathered projected cash flows for two projects. Year Project I Project J 0...

Hodgkiss Enterprises has gathered projected cash flows for two projects. Year Project I Project J 0 –$ 256,000 –$ 256,000 1 114,400 88,600 2 104,200 99,600 3 88,200 101,600 4 77,200 108,600 At what interest rate would the company be indifferent between the two projects? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Interest rate % Which project is better if the required return is above this interest...

Subjects