Question

In: Finance

A company is using the Payback method to determine which project should be selected. The choice...

  1. A company is using the Payback method to determine which project should be selected. The choice is between two machines: Machine A and Machine B. The machines both have a useful life of 10 years. Which machine should be selected based on the following cash flows and what is its payback period?

    Year 1

    Machine A

    Machine B

    0

    ($500,000)

    ($500,000)

    1

    $100,000

    $ 25,000

    2

    $ 95,000

    $ 50,000

    3

    $ 85,000

    $ 75,000

    4

    $ 75,000

    $100,000

    5

    $ 65,000

    $125,000

    6

    $ 55,000

    $150,000

    7

    $ 45,000

    $175,000

    8

    $ 35,000

    $200,000

    9

    $ 25,000

    $225,000

    10

    $ 15,000

    $250,000

    A.

    Machine A should be selected. Payback is 4.68 years.

    B.

    Machine B should be selected. Payback is 5.83 years.

    C.

    Machine A should be selected. Payback is 6.12 years.

    D.

    Machine B should be selected. Payback is 6.60 years.

Solutions

Expert Solution

Payback period represents the time period in which the initial investment in a project is recovered.

Payback period of Machine A is computed as follows:

The cumulative cash inflow of year 1, 2, 3, 4, 5 and 6 is computed as follows:

= $ 100,000 + $ 95,000 + $ 85,000 + $ 75,000 + $ 65,000 + $ 55,000

= $ 475,000

The cumulative cash inflow of year 1, 2, 3, 4, 5, 6 and 7 is computed as follows:

= $ 100,000 + $ 95,000 + $ 85,000 + $ 75,000 + $ 65,000 + $ 55,000 + $ 45,000

= $ 520,000

It means that the initial investment of $ 500,000 is recovered between year 6 and year 7 and hence the payback period lies between year 6 and year 7 and is computed as follows:

= 6 years + Remaining investment to be recovered / Year 7 cash inflow

= 6 years + ( $ 500,000 - $ 475,000) / $ 45,000

= 6.56 years Approximately

Payback period of Machine B is computed as follows:

The cumulative cash inflow of year 1, 2, 3, 4, 5 is computed as follows:

= $ 25,000 + $ 50,000 + $ 75,000 + $ 100,000 + $ 125,000

= $ 375,000

The cumulative cash inflow of year 1, 2, 3, 4, 5 and 6 is computed as follows:

= $ 25,000 + $ 50,000 + $ 75,000 + $ 100,000 + $ 125,000 + $ 150,000

= $ 525,000

It means that the initial investment of $ 500,000 is recovered between year 5 and year 6 and hence the payback period lies between year 5 and year 6 and is computed as follows:

= 5 years + Remaining investment to be recovered / Year 6 cash inflow

= 5 years + ( $ 500,000 - $ 375,000) / $ 150,000

= 5.83 years Approximately

So, the correct answer is option B.

Feel free to ask in case of any query relating to this question

Payback period represents the time period in which the initial investment in a project is recovered.

Payback period of Investment A is computed as follows:

The cumulative cash inflow of year 1, 2 and 3 is computed as follows:

= $ 25,000 + $ 15,000 + $ 30,000

= $ 70,000

The cumulative cash inflow of year 1, 2, 3 and 4 is computed as follows:

= $ 25,000 + $ 15,000 + $ 30,000 + $ 30,000

= $ 100,000

It means that the initial investment of $ 95,000 is recovered between year 3 and year 4 and hence the payback period lies between year 3 and year 4 and is computed as follows:

= 3 years + Remaining investment to be recovered / Year 4 cash inflow

= 3 years + ( $ 95,000 - $ 70,000) / $ 30,000

= 3.83 years Approximately


Related Solutions

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?
What is the payback period, NPV, IRR of A. Using this information, should we accept Project...
What is the payback period, NPV, IRR of A. Using this information, should we accept Project A. Why or why not. Given the following information answer the question above. The discount rate is 10 percent.      PROJECT A       t           Cash Flow       0          (150,000)        1          40,000           2          40,000              3          40,000          4           40,000           5            40,000               ROUND TO NEAREST DOLLAR OR TEN %
Calculate the NPV for each project and determine which project should be accepted. Project A Project...
Calculate the NPV for each project and determine which project should be accepted. Project A Project B Project C Project D Inital Outlay (105,000.000) (99,000.00) (110,000.00) (85,000.00) Inflow year 1 53,000.00 51,000.00 25,000.00 45,000.00 Inflow year 2 50,000.00 47,000.00 55,000.00 50,000.00 Inflow year 3 48,000.00 41,000.00 15,000.00 30,000.00 Inflow year 4 30,000.00 52,000.00 21,000.00 62,000.00 Inflow year 5 35,000.00 40,000.00 35,000.00 68,000.00 Rate 7% 10% 13% 18% Your company is considering three independent projects. Given the following cash flow information,...
Calculate the NPV for each project and determine which project should be accepted. Project A Project...
Calculate the NPV for each project and determine which project should be accepted. Project A Project B Project C Project D Initial Outlay (105,000.00) (99,000.00) (110,000.00) (85,000.00) Inflow year 1 53,000.00 51,000.00 25,000.00 45,000.00 Inflow year 2 50,000.00 47,000.00 55,000.00 50,000.00 Inflow year 3 48,000.00 41,000.00 15,000.00 30,000.00 Inflow year 4 30,000.00 52,000.00 21,000.00 62,000.00 Inflow year 5 35,000.00 40,000.00 35,000.00 68,000.00 Rate 7% 10% 13% 18% NPV = $75,228.32 $77,364.07 -$2,531.00 $69,006.08 Answer: Project B How to show work...
Consider the following project. Using Discounted Payback Period method (10% rate), how long will it take...
Consider the following project. Using Discounted Payback Period method (10% rate), how long will it take to recover the investment? Year 0 1 2 3 4 5 6 Investment -4000 Profit 1100 1100 1100 1100 1100 1100
Calculate the following problems using Microsoft® Excel®: Calculate the NPV for each project and determine which project should...
Calculate the following problems using Microsoft® Excel®: Calculate the NPV for each project and determine which project should be accepted. Project A Project B Project C Project D Inital Outlay (105,000.000) (99,000.00) (110,000.00) (85,000.00) Inflow year 1 53,000.00 51,000.00 25,000.00 45,000.00 Inflow year 2 50,000.00 47,000.00 55,000.00 50,000.00 Inflow year 3 48,000.00 41,000.00 15,000.00 30,000.00 Inflow year 4 30,000.00 52,000.00 21,000.00 62,000.00 Inflow year 5 35,000.00 40,000.00 35,000.00 68,000.00 Rate 7% 10% 13% 18% Your company is considering three independent projects. Given...
Evaluate the following projects using the payback method assuming a rule of 4 years for payback....
Evaluate the following projects using the payback method assuming a rule of 4 years for payback. Year Project A Project B 0. -10,000 -10,000 1. 4000 4000 2. 4000 3000 3. 4000 2000 4. 0. 1,000,000 A. Project A can be accepted because the payback period is 2.5 years but Project B cannot be accepted because its payback period is longer than 3 years. B. Project B should be accepted, since there is a $1,000,000 payoff in the 4th year...
Evaluate the following projects using the payback method assuming a rule of 3 years for payback....
Evaluate the following projects using the payback method assuming a rule of 3 years for payback. Year Project A Project B 0 -10,000 -10,000 1 4,000 4,000 2 4,000 3,000 3 4,000 2,000 4 0 1,000,000
Using the Payback Method, IRR, and NPVTop of FormBottom of FormAssignment ContentTop...
Using the Payback Method, IRR, and NPVTop of FormBottom of FormAssignment ContentTop of FormResourceCorporate FinancePurpose of AssignmentThe purpose of this assignment is to allow the student to calculate the project cash flow using net present value (NPV), internal rate of return (IRR), and the payback methods.Assignment StepsCreate a 350-word memo to management including the following:Describe the use of internal rate of return (IRR), net present value (NPV), and the payback method in evaluating project cash flows.Describe the break-even point and...
Use the NPV method to determine whether Salon Products should invest in the following​ projects: Project...
Use the NPV method to determine whether Salon Products should invest in the following​ projects: Project A costs $290,000 and offers seven annual net cash inflows of $64,000. Salon Products requires an annual return of 12% on projects like A. Project B costs $390,000 and offers ten annual net cash inflows of $74,000. Salon Products demands an annual return of 14% on investments of this nature. What is the NPV of each​ project? What is the maximum acceptable price to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT