Question

In: Finance

While NPV and IRR are measures of return of a project/investment. Payback is a measure of...

While NPV and IRR are measures of return of a project/investment. Payback is a measure of risk. Explain what payback tells about a project/investment and how is it calculated.

Solutions

Expert Solution

Payback period is the time in which the initial cash outflow of an investment is expected to be recovered from the cash inflows generated by the investment. It is one of the simplest investment appraisal techniques.

Formula

The formula to calculate payback period of a project depends on whether the cash flow per period from the project is even or uneven. In case they are even, the formula to calculate payback period is:

Payback Period = Initial Investment
Cash Inflow per Period

When cash inflows are uneven, we need to calculate the cumulative net cash flow for each period and then use the following formula for payback period:

Payback Period = A + B/C

In the above formula,


A is the last period with a negative cumulative cash flow;
B is the absolute value of cumulative cash flow at the end of the period A;
C is the total cash flow during the period after A

Both of the above situations are applied in the following examples.

Decision Rule

Accept the project only if its payback period is LESS than the target payback period.

Thanks


Related Solutions

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...
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%
How does the NPV, IRR and the payback period of an Investment usually react to the...
How does the NPV, IRR and the payback period of an Investment usually react to the following developments (please indicate, UP/DOWN or N/A)? 1. Increasing Investment amount 2. Increasing tax rate 3. Increased annual depreciation due to change of depreciation method 4. Increasing cost of capital 5. Increasing residual value So I actually Need 15 indications (5*3) - TIA
IN EXCEL< SHOW THE FORMULAS > Determine the Payback period, NPV and IRR for both project...
IN EXCEL< SHOW THE FORMULAS > Determine the Payback period, NPV and IRR for both project A and B (show work). Which Project would you select and why? Be specific. Project A will require an initial investment of $ 200,000 and Project B will require and initial investment of $ 325,000. The cost of capital for both projects is 12%. The cash inflows for the next 5 years are listed below: Project A Project B 0 ($200,000) ($325,000) 1 $50,000...
. 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...
. 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...
Describe the use of internal rate of return (IRR), net present value (NPV), and the payback...
Describe the use of internal rate of return (IRR), net present value (NPV), and the payback method in evaluating project cash flows.
(Payback ​period, NPV,​ PI, and IRR calculations​) You are considering a project with an initial cash...
(Payback ​period, NPV,​ PI, and IRR calculations​) You are considering a project with an initial cash outlay of ​$90,000 and expected free cash flows of ​$28,000 at the end of each year for 5 years. The required rate of return for this project is 6 percent. a. What is the​ project's payback​ period? b. What is the​ project's NPV​? c. What is the​ project's PI​? d. What is the​ project's IRR​?
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...
(Payback ​period, NPV,​ PI, and IRR calculations​) You are considering a project with an initial cash...
(Payback ​period, NPV,​ PI, and IRR calculations​) You are considering a project with an initial cash outlay of ​$80000 and expected free cash flows of ​$25000 at the end of each year for 6 years. The required rate of return for this project is 9 percent. a. What is the​ project's payback​ period? b. What is the​ project's NPV​? c. What is the​ project's PI​? d. What is the​ project's IRR​?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT