Question

In: Finance

Calculate the payback period for each of the following projects, then comment on the advisability of...

Calculate the payback period for each of the following projects, then comment on the advisability of selection based on the payback period criterion in contrast to NPV: Project A has a cost of $15,000, returns $4,000 after-tax the first year and this amount increases by $1,000 annually over the five-year life; Project B costs $15,000 and returns $13,000 after-tax the first year, followed by four years of $2,000 per year. The firm uses a 10 percent discount rate.

Show each step.

Solutions

Expert Solution

Pay back period of project A
Time Amount($) Cumulative
                                                              -                 -15,000.00                      -15,000.00
                                                         1.00                   4,000.00                      -11,000.00
                                                         2.00                   5,000.00                         -6,000.00
                                                         3.00                   6,000.00                                       -  
                                                         4.00                   7,000.00                          7,000.00
                                                         5.00                   8,000.00                        15,000.00
Pay Back period is 3years
Pay back period of project B:
Time Amount Cumulative
                                                              -                 -15,000.00                      -15,000.00
                                                         1.00                13,000.00                         -2,000.00
                                                         2.00                   2,000.00                                       -  
                                                         3.00                   2,000.00                          2,000.00
                                                         4.00                   2,000.00                          4,000.00
                                                         5.00                   2,000.00                          6,000.00
Pay back period is 2years
Using the pay back period alone, Project B looks more attractive as the payback period
of Project B is lower than Project A.However, The problem reinforces the fact that pay back  
period ignores the timing of cash flows and also ignore the flows that occur beyond the  
payback period and both of these factors are considered in case of NPV.

Related Solutions

Given the following two projects and their cash​ flows, ​, calculate the discounted payback period with...
Given the following two projects and their cash​ flows, ​, calculate the discounted payback period with a discount rate of 6%, 8​%,and 18​%. What do you notice about the payback period as the discount rate​ rises? Explain this relationship. With a discount rate of 6​%, the cash outflow for project A​ is:  A. recovered in 5 years. B.recovered in 3.16 years. C.recovered in 3 years. D.never fully recovered.  Cash Flow A B   Cost ​ $8,000 ​$100,000   Cash flow year 1...
Calculate the Payback Period                                               &nbsp
Calculate the Payback Period                                                              The payback period is the length of time required for the cash to be coming in from an investment                                to equal the amount of cash originally spent when the investment was acquired.                                                                                    ...
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.
Find out the NPV, IRR and Payback period for each of the following three projects. Assume...
Find out the NPV, IRR and Payback period for each of the following three projects. Assume I=6%.                                                                                                                                    (60 points) Project CF0 CF1 CF2 CF3 CF4 CF5 A -12,000 3000 3000 4000 4000 1000 B -12,000 4000 4000 3000 3000 1000 C -12,000 3000 3000 3000 3000 1000 D -12,000 5000 3000 5000 3000 0 E -12,000 3000 3000 3000 3000 5000 F -12,000 0 0 6000 6000 6000
Find out the NPV, IRR and Payback period for each of the following three projects. Assume...
Find out the NPV, IRR and Payback period for each of the following three projects. Assume I=6%. Please show work and write out answers. Do not put into a table. Thank you    Project CF0 CF1 CF2 CF3 CF4 CF5 A -12,000 3000 3000 4000 4000 1000 B -12,000 4000 4000 3000 3000 1000 C -12,000 3000 3000 3000 3000 1000 D -12,000 5000 3000 5000 3000 0 E -12,000 3000 3000 3000 3000 5000 F -12,000 0 0 6000...
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...
For the following two projects, determine the Payback Period Discounted Payback Net Present Value Profitability Index...
For the following two projects, determine the Payback Period Discounted Payback Net Present Value Profitability Index (Benefit-Cost Ratio) Internal Rate of Return Modified Internal Rate of Return             Project A Project B Year Net Income Cash Flow Net Income Cash Flow 0 (15,000) (19,000) 1 5,000 6,000 3,000 4,000 2 5,000 6,000 5,000 6,000 3 5000 6,000 7,000 8,000 4 5,000 6,000 11,000 12,000 Risk Index 1.80 .60 The firm’s cost of capital ko is 15% and the risk free...
Capital Budgeting Assignment For the following two projects, determine the Payback Period Discounted Payback Net Present...
Capital Budgeting Assignment For the following two projects, determine the Payback Period Discounted Payback Net Present Value Profitability Index (Benefit-Cost Ratio) Internal Rate of Return Modified Internal Rate of Return             Project A Project B Year Net Income Cash Flow Net Income Cash Flow 0 (15,000) (19,000) 1 5,000 6,000 3,000 4,000 2 5,000 6,000 5,000 6,000 3 5000 6,000 7,000 8,000 4 5,000 6,000 11,000 12,000 Risk Index 1.80 .60 The firm’s cost of capital ko is 15% and...
Capital Budgeting For the following two projects, determine the 1. Payback Period 2. Discounted Payback 3....
Capital Budgeting For the following two projects, determine the 1. Payback Period 2. Discounted Payback 3. Net Present Value 4. Profitability Index (Benefit-Cost Ratio) 5. Internal Rate of Return 6. Modified Internal Rate of Return Project A Project B Year Net Income Cash Flow Net Income Cash Flow 0 (15,000) (19,000) 1 5,000 6,000 3,000 4,000 2 5,000 6,000 5,000 6,000 3 5000 6,000 7,000 8,000 4 5,000 6,000 11,000 12,000 Risk Index 1.80 .60 The firm’s cost of capital...
Given the following cash flows for a capital project, calculate its payback period and discounted payback...
Given the following cash flows for a capital project, calculate its payback period and discounted payback period. The required rate of return is 8 percent. Year 0 1 2 3 4 5 Cash Flows $-37500 $11250 $11250 $15000 $6000 $6000 The discounted payback period is 0.16 year longer than the payback period. 0.80 year longer than the payback period. 1.27 years longer than the payback period. 1.85 years longer than the payback period.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT