please show all the steps and formula
Net cash flow each year = cash flow - cost.
MIRR is calculated using MIRR function in Excel.
MIRR is 10.97%.
The project should be rejected as the MIRR is lower than the discount rate.
please show all the steps and formula 1. DUULIUL LUI . ILUOPUITUJOUL. 5. A project will...
make sure you show all the steps 1. DUULIUL LUI . ILUOPUITUJOUL. 5. A project will cost $95,000 today and there will be an additional cost in year 3 of $15,000. The project will have the following projected cash flows: Cash Flow $30,000 $50,000 $0 $50,000 The discount rate is 14%. Calculate the modified internal rate of return. Do you accept or reject? (Must have correct set-up and your answer should be between two consecutive whole percentages.)
Yr 5. A project will cost $95,000 today and there will be an additional cost in year 3 of $15,000. The project will have the following projected cash flows: Cash Flow $30,000 $50,000 $0 $50,000 The discount rate is 14% Calculate the modified internal rate of return. Do you accept or reject? (Must have correct set-up and your answer should be between two consecutive whole percentages.)
A project will cost $95,000 today and there will be an additional cost in year 3 of $15,000. The project will have the following projected cash flows: Yr Cash Flow 1 $30,000 2 $50,000 3 $0 4 $50,000 The discount rate is 14%. Calculate the modified internal rate of return. Do you accept or reject? (Must have correct set-up and your answer should be between two consecutive whole percentages.)
Provide your solutions in sequential order below the line. Round final answer to the nearest hundredth. Show all work and circle your final answer. You are analyzing a project which has a $20,000 sunk cost. The project's cost is $150,000 and the expected cash flows are: (Use this info for questions #1-4) Year 1: $60,000 Year 2: $0 Year 3: $100,000 Year 4: $0 Year 5: $60,000 The discount rate is 18% (the required return is also 18%). The required...
You are analyzing a project which has a $20,000 sunk cost. The project’s cost is $150,000 and the expected cash flows are: (Use this info for questions #1-4) Year 1: $60,000 Year 2: $0 Year 3: $100,000 Year 4: $0 Year 5: $60,000 The discount rate is 18% (the required return is also 18%). The required payback is 2.3 years. 1. Calculate the internal rate of return (must have correct set-up and your answer should be between two consecutive whole...
Net present value. Lepton Industries has a project with the following projected cash flows: 3: a. Using a discount rate of 12% 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 17%? c. Should the company accept or reject it using a discount rate of 22%? a. Using a discount rate of 12%, this project should be . (Select...
Net present value. Lepton Industries has a project with the following projected cash flows: 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 17%? c. Should the company accept or reject it using a discount rate of 20%? a. Using a discount rate of 10%, this project should be V. (Select from...
P9-8 (similar to) EQuestion Help Net present value. Lepton Industries has a project with the following projected cash flows: a. Using a discount rate of 9% 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 17% ? c. Should the company accept or reject it using a discount rate of 20 %? . (Select from the drop-down menu.) a....
10. Cashflow patterns and the modified rate of return calculation Locke Manufacturing Inc. is analyzing a project with the following projected cash flows: Year 0 Cash Flow - $1,740,000 375,000 600,000 720,000 480,000 This project exhibits conventional cash flows. Locke's desired rate of return is 6.00%. Given the cash flows expected from the company's new project, compute the project's anticipated modified internal rate of return (MIRR). (Hint: Round all dollar amounts to the nearest whole dollar, and your final MIRR...
4. 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...