Question

In: Economics

Projects A B Cost (initial investment) 40000 250000 Year Cash flows of A Cash flows of...

Projects A B
Cost (initial investment) 40000 250000
Year Cash flows of A Cash flows of B
1 10000 40000
2 10000 120000
3 10000 200000
4 10000 200000
5 10000 200000
6 10000 200000

What are the Payback Periods of Projects A, and B? Assume all cash flows are evenly spread throughout the year and already discounted. If the cut-off period ( الفتره المقبوله) is three years, which projects do you accept?

Solutions

Expert Solution

Year A Cumulative Cashflow A B Cumulative Cashflow B
(Initial Investment) -40000 -40000 -250000 -250000
1 10000 -30000 40000 -210000
2 10000 -20000 120000 -90000
3 10000 -10000 200000 110000
4 10000 0 200000 310000
5 10000 10000 200000 510000
6 10000 20000 200000 710000

Payback periods:

Payback period is the time when cumulative cashflow becomes zero. At this time the project has recovered all of its initial investment and starts generating profit.

Project A

As we can see in the table above, the cumulative cashflow of A becomes zero in year 4, so the payback period of A is 4 years

Project B

As we can see in the table above the cumulative cashflow becomes zero between year 2 and 3, so the payback period exists between 2 and 3. further we can calculate exact payback period by interpolation.

Interpolation formula:

Putting values in above formula

y-2=(3-2)/(110000-(-90000)) x (0-2)

y=2.45

so the payback period of project B is 2.45 years

if the cutoff period is 3 years then we would select project B as it has payback period of 2.45 years, that means it will have recovered its investment before cutoff period. similarly we will not choose project A as its payback period is 4 years, that means it will not have recovered its initial invesment till the cutoff period.


Related Solutions

The cash flows for three independent projects are found​ below:   Year 0 ​ (Initial investment) ​$(70,000​)...
The cash flows for three independent projects are found​ below:   Year 0 ​ (Initial investment) ​$(70,000​) ​$(110,000​) ​$(420,000​) Year 1 ​$11,000 ​$28,000 ​$220,000 Year 2 17,000 28,000 220,000 Year 3 21,000 28,000 220,000 Year 4 26,000 28,000 — Year 5 33,000 28,000 — . a. Calculate the IRR for each of the projects. b. If the discount rate for all three projects is 13 percent​, which project or projects would you want to​ undertake? c. What is the net present...
An investment has an initial cost of $1,000. The cash flows for the following four-year life...
An investment has an initial cost of $1,000. The cash flows for the following four-year life of project are $347, $394, $424, and $600. If discount rate is 14%, calculate the discounted payback period for this project. Round your answer to 4 decimal places.
Q1)  An investment with an initial cost of $16,000 produces cash flows of $5000 per year for...
Q1)  An investment with an initial cost of $16,000 produces cash flows of $5000 per year for 5 years. If the required rate of return is 10%, - what is the payback period? - what is the discounted payback period for the investment? Q2) The Balistan Rug Company is considering investing in a new loom that will cost $12,000. The new loom will create positive end of year cash flow of $4999.62 for each of the next 3 years. The internal...
Consider the following cash flows for projects A and B. Year                                &
Consider the following cash flows for projects A and B. Year                                                    Project A         Project B 0                                                          -$1000             -$1000 1                                                          375                 900 2                                                          375                 700 3                                                          375                 500 4                                                          375                 -200 5                                                          -100                 200 The cost of capital for both projects is 10%. What is the cross over rate for projects A and B (the rate at which NPV profiles of the projcets intersect each other)? 1. There is no cross over rate as the NPV profiles of projects A and B do not cross each other for any rate between 0% and 100%. 2....
1).A project requires an initial investment of $973,000. The projects generates cash flows of $250,000 in...
1).A project requires an initial investment of $973,000. The projects generates cash flows of $250,000 in year 1, $300,000 in year 2, $300,000 in year 3, $400,000 in year 4 and $400,000 in year 5. If the required rate of return for the project is 12 percent, the payback period is ____________ and the discounted payback period is _______________. A).3.7 years; 4.5 years B).2.8 years; 3.9 years C). 2.8 years; 4.2 years D).3.3 years; 3.9 years E).3.3 years; 4.2 years...
contains a list of available investment projects and their respective cash flows. Using a cost of...
contains a list of available investment projects and their respective cash flows. Using a cost of capital of 10%, please answer the following questions: 1- Find the payback period, net present value and internal rate of return for each project. (Using excel to do this will save you a lot of time). 2- Based on the results, identify conflicts in ranking the above projects based on the IRR and NPV approaches, i.e. a project that has a higher rank using...
An investment that Kevin is considering offers the following cash flows. Year 1 Initial investment of...
An investment that Kevin is considering offers the following cash flows. Year 1 Initial investment of $10,000 Year 2 Inflow of $2,000 Year 3 Inflow of $1,500 Year 4 Additional investment of $5,000 Year 5 Inflow of $1,200 Year 6 Inflow of $2,200 Year 7 Inflow of 1,500 Year 8 Inflow of $1,000 Year 9 Inflow of $1,200 Year 10 Sale proceeds of $17,000 5. What is the internal rate of return (IRR) that this investment offers if all cash...
a) Four investment projects have the following net cash flows. The cost of capital is 15%....
a) Four investment projects have the following net cash flows. The cost of capital is 15%. Decide which of them should be accepted using the net present value method. Find the discounted payback period. YEAR PROJECT A PROJECT B PROJECT C PROJECT D 0 (10,000) (15,000) (20,000) (30,000) 1 5,000 5,000 10,000 0 2 5000 5,000 10,000 0 3 20,000 5,000 4,000 100,000 4 1,000 10,000 2,000 120,000 5 - 5,000 - 60,000
The following are the cash flows of two projects: Year Project A Project B 0 ?$...
The following are the cash flows of two projects: Year Project A Project B 0 ?$ 380 ?$ 380 1 210 280 2 210 280 3 210 280 4 210 If the opportunity cost of capital is 11%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.)
The following are the cash flows of two projects: Year Project A Project B 0 ?$...
The following are the cash flows of two projects: Year Project A Project B 0 ?$ 280 ?$ 280 1 160 180 2 160 180 3 160 180 4 160 If the opportunity cost of capital is 10%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.) Project A Profitability Index Project B
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT