Question

In: Finance

A 25-year project has a cost of $1,500,000 and has annual cash flows of $400,000 in...

A 25-year project has a cost of $1,500,000 and has annual cash flows of $400,000 in years 1-15, and $200,000 in years 16-25. The company's required rate is 14%. Given this information, calculate the payback of the project.

2.25 years

4.25 years

2.75 years

3.75 years

3.25 years

Solutions

Expert Solution

Payback period is the time period required to cover the initial investment back. It does not take in to account the time value of money. In the payback period, the all cost will be covered and after that the profit will start incurring.

Note : It is assumed that all the cash flows are evenly distributed through out the year.

Initial investment = $ 1,500,000

Cash flows are shown in the below table-

Year Cash flow (in $) Cumulative cash flow (in $)
1 4,00,000 4,00,000
2 4,00,000 8,00,000
3 4,00,000 12,00,000
4 4,00,000 16,00,000
5 4,00,000 20,00,000
6 4,00,000 24,00,000
7 4,00,000 28,00,000
8 4,00,000 32,00,000
9 4,00,000 36,00,000
10 4,00,000 40,00,000
11 4,00,000 44,00,000
12 4,00,000 48,00,000
13 4,00,000 52,00,000
14 4,00,000 56,00,000
15 4,00,000 60,00,000
16 2,00,000 62,00,000
17 2,00,000 64,00,000
18 2,00,000 66,00,000
19 2,00,000 68,00,000
20 2,00,000 70,00,000
21 2,00,000 72,00,000
22 2,00,000 74,00,000
23 2,00,000 76,00,000
24 2,00,000 78,00,000
25 2,00,000 80,00,000

Payback period = 3 + 300,000 / 400,000 = 3 + 0.75

= 3.75 year

( As the initial investment is $1500,000, we need to cover this cost, we will take year corresponding to the cumulative value which is less than or equal to 1500,000, here it is 3 year. In 3 year 1200,000 $ will be covered, we will be needing $300,000 (1500,000 - 1200,000) more to cover full initial cost. As the cash flows are evenly distributed, remaining 300,000 $ will be covered from 4th year inflows of amount 400,000$) . Hence 300,000 / 400,000 is taken.

Hence payback period = 3.75 years.


Related Solutions

1)A 25- year project has a cost of $1,500,000 and has annual cash flows of $400,000...
1)A 25- year project has a cost of $1,500,000 and has annual cash flows of $400,000 in years 1-15, and $200,000 in years 16-25. The company's required rate is 14%. Given this information, calculate the profitability index of the project. Answer is 1.74 Can someone explain this with the steps?
Q3 A 50- year project has a cost of $500,000 and has annual cash flows of...
Q3 A 50- year project has a cost of $500,000 and has annual cash flows of $100,000 in years 1-25, and $200,000 in years 26-50. The company's required rate is 8%. Given this information, calculate the profitability index of the project. Question 3 options: 2.46 2.16 2.76 2.06 1.76
A 50-year project has a cost of $500,000 and has annual cash flows of $100,000 in...
A 50-year project has a cost of $500,000 and has annual cash flows of $100,000 in years 1-25, and $200,000 in years 26-50. The company's required rate is 8%. Given this information, calculate the NPV of the project.
Calculate the NPV of a 20-year project with a cost of $300,000 and annual cash flows...
Calculate the NPV of a 20-year project with a cost of $300,000 and annual cash flows of $25,000 in years 1-10 and $50,000 in years 11-20. The company's required rate of return is 10%
Project A is as follows: $100,000 upfront cost and annual cash flows of $25,000 a year...
Project A is as follows: $100,000 upfront cost and annual cash flows of $25,000 a year for seven years. Project B is as follows: $100,000 upfront cost and cash flow of $20,000 per year for 8 years. what are the payback periods for projects A and B?
Project A is as follows: $100,000 upfront cost and annual cash flows of $25,000 a year...
Project A is as follows: $100,000 upfront cost and annual cash flows of $25,000 a year for seven years. Project B is as follows: $100,000 upfront cost and cash flow of $20,000 per year for 8 years. Project A Payback Period is 4 years and Project B is 5 years. using that data calculate NPV for projects A and B using a 10% discount rate. which project do you pick if they are mutually exclusive? Which do you pick if...
If a project has a cost of $10,000, expected net cash flows of $1500 a year...
If a project has a cost of $10,000, expected net cash flows of $1500 a year for 12 years and you use a discount rate of 6%, what is the following: Payback period (no application of discount rate) Payback period (using discount rate) NPV IRR Should the project be accepted? If another project has a cost of $10,000 and has expected life of 8 years and it will generate $3000 a year should you accept the project if your boss...
A project cost $650 and has cash flows of $150 for the first year, $100 for...
A project cost $650 and has cash flows of $150 for the first year, $100 for the second year, and $80 in each of the subsequent years. What is the payback period of the project?
a project with an initial cost of $73,600 is expected to generate annual cash flows of...
a project with an initial cost of $73,600 is expected to generate annual cash flows of $16,360 for the next 8 years. what is the projects internal rate of retu
Project A has the following Cash Flows: Cost = $1,200,000; Cash flows the following years as...
Project A has the following Cash Flows: Cost = $1,200,000; Cash flows the following years as follows: Year 1 = $274,600; Year 2 = $298,000; Year 3 = $303,950; Year 4 = $312,875; and Year 5 = $374,600. Calculate the Traditional Payback. Assume cash flows are even throughout the year. Calculate the Net Present Value using the WACC = 8.28%.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT