Question

In: Finance

Suppose your firm is considering investing in a project with the cash flows shown as follows,...

Suppose your firm is considering investing in a project with the cash flows shown as follows, that the required rate of return on projects of this risk class is 8 percent, and that the maximum allowable payback and discounted payback statistic for the project are three and three and a half years, respectively.

Time 0 1 2 3 4 5
Cashflow -100,000 30,000 45,000 55,000 30,000 10,000

Use the IRR decision rule to evaluate this project; should it be accepted or rejected and why?    

Solutions

Expert Solution

First of all we have to check if the payback period and Discounted payback period less than three and half years.

Payback period is simply the time taken by the project to recover the intitial cash outlay.

So, we take the cumulative cash flows or add the yearly cash flows till the time the time the initial cash outflow is fully recovered. At the end of second year, we have to recover 25,000 and the cash flow for the third year is 55,000 ,so our initial cash outflow would simply be recovererd by 3rd year. The fraction can be calculated by dividing 25,000 by 55,000 which is 0.45.

Therefore the investment can be recovered in 2.45 years.

Similar is the case with Discounted payback period, we just have to discount the future cash flows to the present and then repeat the same process we did in payback period.

To discount we just use the PV(Rate,periods,pmt,fv) formula in excel.

The payback and the discounted payback periods of the project are lower than what the firm can bear.

To calculate the IRR.

We just use the IRR Function. which is =IRR(values). According to the IRR rule, the IRR Should be greated than the project rate of return in order to accept the project.

So, 23% > 8%, Hence we accept this project.


Related Solutions

Suppose your firm is considering investing in a project with the cash flows shown as follows,...
Suppose your firm is considering investing in a project with the cash flows shown as follows, that the required rate of return on projects of this risk class is 8 percent, and that the maximum allowable payback and discounted payback statistic for the project are two and two and a half years, respectively. Time 0, 1, 2, 3, 4, 5 Cash Flow: -125,000/ 65,000, 78,000, 105,000, 105,000, 25,000 Use the NPV decision rule to evaluate this project; should it be...
Suppose your firm is considering investing in a project with the cash flows shown as follows,...
Suppose your firm is considering investing in a project with the cash flows shown as follows, that the required rate of return on projects of this risk class is 8 percent, and that the maximum allowable payback and discounted payback statistic for the project are three and three and a half years, respectively. . Use the IRR decision rule to evaluate this project; should it be accepted or rejected and why? Time 0 1 2 3 4 5 Cash Flow...
Suppose your firm is considering investing in a project with the cash flows shown as follows,...
Suppose your firm is considering investing in a project with the cash flows shown as follows, that the required rate of return on projects of this risk class is 8 percent, and that the maximum allowable payback and discounted payback statistic for the project are three and three and a half years, respectively. . Use the IRR decision rule to evaluate this project; should it be accepted or rejected and why? Trying to solve manually with a calculator and not...
.   Suppose your firm is considering investing in a project with the cash flows shown as...
.   Suppose your firm is considering investing in a project with the cash flows shown as follows, that the required rate of return on projects of this risk class is 8 percent, and that the maximum allowable payback and discounted payback statistic for the project are three and three and a half years, respectively. Time 0 1 2 3 4 5 Cashflow -100,000 30,000 45,000 55,000 30,000 10,000 Calculate the payback and use the payback decision rule to evaluate this...
Suppose your firm is considering investing in a project with the cash flows shown below, that...
Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 8 percent. Time: 0 1 2 3 4 5 6 Cash flow: –$8,600 $1,080 $2,280 $1,480 $1,480 $1,280 $1,080 Use the IRR decision rule to evaluate this project. (Negative amount should be indicated by a minus sign. Round your answer to 2 decimal places.) IRR%= Should it be accepted or rejected?
Suppose your firm is considering investing in a project with the cash flows shown below, that...
Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 9 percent, and that the maximum allowable payback and discounted payback statistics for the project are 2.0 and 3.0 years, respectively. Time: 0 1 2 3 4 5 6 Cash flow: −$7,600 $1,190 $2,390 $1,590 $1,590 $1,390 $1,190 Use the NPV decision rule to evaluate this project. (Negative amount should be indicated...
Suppose your firm is considering investing in a project with the cash flows shown below, that...
Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 12 percent, and that the maximum allowable payback and discounted payback statistic for the project are 2 and 3 years, respectively. Time 0 1 2 3 4 5 6 Cash Flow -1,150 30 570 770 770 370 770 Use the discounted payback decision rule to evaluate this project; should it be accepted...
Suppose your firm is considering investing in a project with the cash flows shown below, that...
Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 9 percent, and that the maximum allowable payback and discounted payback statistics for the project are 3.5 and 4.5 years, respectively. Time: 0 1 2 3 4 5 6 Cash flow –$5,200 $1,250 $2,450 $1,650 $1,570 $1,450 $1,250 Use the payback decision rule to evaluate this project. (Round your answer to 2...
Suppose your firm is considering investing in a project with the cash flows shown below, that...
Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 10 percent, and that the maximum allowable payback and discounted payback statistic for the project are 2 and 3 years, respectively.   Time 0 1 2 3 4 5 6   Cash Flow -1,050 150 450 650 650 250 650 Use the payback decision rule to evaluate this project; should it be accepted or...
Suppose your firm is considering investing in a project with the cash flows shown below, that...
Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 8 percent, and that the maximum allowable payback and discounted payback statistics for the project are 3.5 and 4.5 years, respectively. Time: 0 1 2 3 4 5 6 Cash flow: ?$5,000 $1,200 $2,400 $1,600 $1,600 $1,400 $1,200 Use the discounted payback decision rule to evaluate this project.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT