. Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback A project has an initial...

. Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback A project has an initial cost of $60,000, expected net cash inflows of $10,000 per year for 8 years, and a cost of capital of 12%. Show your work. a. What is the project’s NPV? (Hint: Begin by constructing a timeline). b. What is the project’s IRR? c. What is the project’s MIRR? d. What is the project’s PI? e. What is the project’s payback period? f. What is the project’s discounted payback period?

Expert Solution

Using Discounted cash flow method, the project does not payback its cash flows.

Formulae

jeff jeffy answered 2 years ago

SHOW YOUR WORK AND EXPLAIN PLEASE! Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback...

SHOW YOUR WORK AND EXPLAIN PLEASE! Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback A project has an initial cost of $60,000, expected net cash inflows of $10,000 per year for 8 years, and a cost of capital of 12%. Show your work. a. What is the project’s NPV? (Hint: Begin by constructing a timeline). b. What is the project’s IRR? c. What is the project’s MIRR? d. What is the project’s PI? e. What is the project’s...

Problem #4 Calculate NPV, Payback, Discounted Payback, IRR and Modified IRR for the following project Initial...

Problem #4 Calculate NPV, Payback, Discounted Payback, IRR and Modified IRR for the following project Initial Investment: -100,000 Annual project cash flow 22,000 for 6 years Cost of capital is 6%

. For each project, calculate the NPV, IRR, profitability index (PI) and the payback period. For...

. For each project, calculate the NPV, IRR, profitability index (PI) and the payback period. For each capital budgeting decision tool, indicate if the project should be accepted or rejected, assuming that each project is independent of the others. Important Note: The venture capital folks have a firm maximum payback period of four years. Project A= Required rate of Return= 16.30% Project B= R= 12.50% Project C= R= 15.35% Project D= R= 17.25% Expected cash flows for the four...

For each project, calculate the NPV, IRR, profitability index (PI) and the payback period. For each...

For each project, calculate the NPV, IRR, profitability index (PI) and the payback period. For each capital budgeting decision tool, indicate if the project should be accepted or rejected, assuming that each project is independent of the others. Important Note: The venture capital folks have a firm maximum payback period of four years. Risk free rate = 1.10%, MRP = 9.5%, Required return = 14.40% Yes excel is fine Expected cash flows for the four potential projects that Avalon is...

Calculate the five different criteria for evaluating projects (regular payback, discounted payback, NPV, IRR, and MIRR)...

Calculate the five different criteria for evaluating projects (regular payback, discounted payback, NPV, IRR, and MIRR) for the two projects listed below. The firm’s WACC is 9.90%. If the projects are mutually exclusive and the firm has sufficient budget available, which project (if any) would you choose to proceed with, and why? (Hint: you may want to create the full cash flow table for each project to fully show your work.) periods 0 1 2 3 4 project Hay cash...

23. Does the Payback Period, Discounted Payback Period, NPV, IRR, PI ratio and MIRR given you...

23. Does the Payback Period, Discounted Payback Period, NPV, IRR, PI ratio and MIRR given you the same accept/reject decision. Discuss the limitations of the methods that give you a decision different than that of the NPV.

If these two projects are mutually exclusive, which project should the company accept based on the NPV, IRR, MIRR, payback, and discounted payback period for each project?

Considering the following projects.ProjectYear01234ACash flows-$100$35$35$35$35BCash flows-$100$60$50$40$30Project A has WACC = 6.00% while project B has WACC = 8.50%.If these two projects are mutually exclusive, which project should the company accept based on the NPV, IRR, MIRR, payback, and discounted payback period for each project?Would your decision (Your answer from part A) change if these two projects were independent?

Explain how to calculate the capital budgeting criterion (in excel) : NPV, IRR, MIRR, Payback, Discounted...

Explain how to calculate the capital budgeting criterion (in excel) : NPV, IRR, MIRR, Payback, Discounted Payback, Crossover Rate, and decide between mutually exclusive and/or independent projects

Apple's Project NPV ($) 10,258 IRR (%) 13 MIRR (%) 10 PI 1.5 Payback (Years) 3...

Apple's Project NPV ($) 10,258 IRR (%) 13 MIRR (%) 10 PI 1.5 Payback (Years) 3 Discounted Payback (years) 3.5 Apple's cost of capital is 9%. Its critical payback and discounted payback periods are 2 and 2.5. Should the project be accepted or not. NPV - (Accept or Do Not Accept) IRR - (Accept or Do Not Accept) MIRR - (Accept or Do Not Accept) PI - (Accept or Do Not Accept) Payback - (Accept or Do Not Accept) Discounted...

Calculations of the NPV, IRR and the payback for the project and an analysis of the...

Calculations of the NPV, IRR and the payback for the project and an analysis of the results. I need the excel formula calculation and analysis of the questions You have identified a potential opportunity for WBC, which involves undertaking a project that will have a ten-year life. The project requires an initial purchase of equipment and furniture totalling $4,500,000, plus ancillary programming capability and machinery costing $1,500,000. The equipment and furniture will depreciate and have a salvage value of $500,000...

Question