Question

In: Finance

Time Cash Flow 0         (362,000) 1           103,000 2           108,000 3     &nb

Time

Cash Flow

0

        (362,000)

1

          103,000

2

          108,000

3

          116,000

4

          133,000

5

          142,000

What are the investment’s payback period, IRR, and NPV, assuming the firm’s WACC is 12%?- show working how you get these calculation.

If the firm requires a payback period of less than 3 years, should this project be accepted? Be sure to justify your choice.

Based on the IRR and NPV rules, should this project be accepted? Be sure to justify your choice.

Which of the decision rules (payback, NPV, or IRR) do you think is the best rule for a firm to use when evaluating projects? Be sure to justify your choice.

Solutions

Expert Solution

Please follow the excel file attached for the detailed calculation done for NPV, IRR and payback period calculation.

NPV is calculated using following formula in Excel: NPV(WACC, CASHFLOW YEAR1: YEAR5) +CASHFLOW YEAR0

NPV comes as $63726.25 which is positive.

IRR is calculated using following formula in Excel: IRR(CASHFLOW YEAR0: YEAR5)

IRR comes as 18.47% which is greater than WACC of 12%

For payback period calculation, we have added one extra column in Excel as "Balance".

Balance of Time period 1 calculated by: cashflow year0+cashflow year1 =-362000+103000= -259000

going by same calculation logic, year2, 3 & 4 balance comes as -151000,-35000,98000.

As in year4 balance becomes positive, we can understand payback is happening between year 3 and 4.

So, payback period= 3 Years +(-(-35000/133000) =3.26 Years

Now, if the firm requires a payback period of less than 3 years, this project is not accepted as payback period comes as 3.26 Years.

Based on both NPV and IRR, this project should be accepted as NPV is positive, $63726.25

IRR comes as 18.47% which is greater than WACC of 12%?.So, project is in acceptance criteria based on IRR too.

Among, NPV, IRR and payback, payback is least important in terms of final decision making. It is used for initial filtering based on how early investors want get back their money. Payback doesn't consider cashflow once balance becomes positive or investor's money is back.Then among NPV and IRR, if both indicating for accepting the project like this case then both are fine. But if NPV, IRR produce difference acceptance criteria, thumb rule is going for NPV. Because higher IRR but lower NPV project 'might not be preferred'in cases where IRR might be lower in another project but that project duration is higher and project NPV is also much higher.

Basically NPV is always considered as the most important acceptance criteria as IRR doesn't consider project duration and project size. So going by IRR, one small project might become more significant compared to multi year large project with better NPV.

So, while in conflict, always go for NPV.

A B C
1 WACC 0.12
2
3 Time Cash Flow Balance
4 0 -362000 -362000
5 1 103000 -259000
6 2 108000 -151000
7 3 116000 -35000
8 4 133000 98000
9 5 142000
10
11 NPV=NPV(B1,B5:B9)+B4 $63,726.25
12
13 IRR=IRR(B4:B9) 18.47%
14
15 Payback Period=3 + (- C7)/B8
Years
3.26 Years


Related Solutions

Year Cash Flow 0 −$9,600           1 2,600           2 3,700           3 3,900      &nb
Year Cash Flow 0 −$9,600           1 2,600           2 3,700           3 3,900              (a) What is the profitability index for the cashflows if the relevant discount rate is 9 percent? $0.842   $0.931   $0.913   $0.887   $0.86    (b) What is the profitability index for the cashflows if the relevant discount rate is 15 percent? $0.834   $0.754   $0.794   $0.818   $0.77    (c) What is the profitability index for the cashflows if the relevant discount rate is 27 percent? 0.67   0.651   0.683   0.618   0.631
Year Cash Flow 0 −$9,600           1 5,600           2 4,000           3 4,800      &nb
Year Cash Flow 0 −$9,600           1 5,600           2 4,000           3 4,800              a. What is the profitability index for the cash flows if the relevant discount rate is 10 percent?    b. What is the profitability index for the cash flows if the relevant discount rate is 17 percent?    c. What is the profitability index for the cash flows if the relevant discount rate is 25 percent?
Year Cash Flow 0 −$8,600           1 5,700           2 3,200           3 5,700      &nb
Year Cash Flow 0 −$8,600           1 5,700           2 3,200           3 5,700              Required : (a) What is the profitability index for the cashflows if the relevant discount rate is 10 percent? (Click to select)  $1.45  $1.408  $1.338  $1.478  $1.366    (b) What is the profitability index for the cashflows if the relevant discount rate is 14 percent? (Click to select)  $1.249  $1.381  $1.315  $1.355  $1.276    (c) What is the profitability index for the cashflows if the relevant discount rate is 24 percent? (Click to select)  1.158  1.068  1.18  1.124  1.09
Year Cash Flow 0 −$7,800           1 4,300           2 5,200           3 3,200      &nb
Year Cash Flow 0 −$7,800           1 4,300           2 5,200           3 3,200              a. What is the profitability index for the cash flows if the relevant discount rate is 8 percent?    b. What is the profitability index for the cash flows if the relevant discount rate is 16 percent?    c. What is the profitability index for the cash flows if the relevant discount rate is 25 percent?
Time    Cash flow 0    -165,000 1 56,500 2    67,400 3    45,600 4...
Time    Cash flow 0    -165,000 1 56,500 2    67,400 3    45,600 4 29,800 5 7,500 Suppose your firm is considering investing in Project K with the cash flows shown in the table. Assume that the required rate of return on projects of this risk class is 7.5 percent, and that the maximum allowable payback and discounted payback statistics for the project are 3.0 and 3.6 years, respectively. Which of the following statements is (are) correct? (x)...
Project Y Time    Cash Flow 0    -5,000 1 500 2 2000 3    3000...
Project Y Time    Cash Flow 0    -5,000 1 500 2 2000 3    3000 4 1500 5    500 Compute the discounted payback statistic for Project Y and recommend whether the firm should accept or reject the project with the cash flows shown in the table if the appropriate cost of capital is 12 percent and the maximum allowable discounted payback is 3.5 years. A. 3.00 years, accept B. 3.45 years, accept C. 3.86 years, accept D. 3.45...
Discounted Cash Flow: Year (n) 0 1 2 3 4 Undiscounted cash flow -$600,000 $200,000 $200,000...
Discounted Cash Flow: Year (n) 0 1 2 3 4 Undiscounted cash flow -$600,000 $200,000 $200,000 $200,000 $200,000 DCF @ 11% ∑DCF @11% DCF @ 13% ∑DCF @13% DCF @ 15% ∑DCF @15% Notes: DCF = Discounted Cash Flow ∑DCF = Cumulative Discounted Cash Flow Refer to the following video on how to calculate IRR with Excel. Provide your completed spreadsheet in the space below. Alternatively, do the exercise in Excel and enter the values back into the table above....
Net Present Value ApproachB7:H23 Time Period 0 1 2 3 4 5 Cash Flow Purchase Price...
Net Present Value ApproachB7:H23 Time Period 0 1 2 3 4 5 Cash Flow Purchase Price $      (70,000) Labor Savings 20,000 20,000 20,000 20,000 20,000 Paint Savings 2,000 2,000 2,000 2,000 2,000 Maintenance -1000 (1,000) (1,000) (1,000) (1,000) (1,000) Residual Value 5,000 5,000 Total Cash Flow $      (70,000) 21,000 21,000 21,000 21,000 26,000 PV Factor 1 0.893 0.797 0.712 0.636 0.567 Total Cash Flow $      (70,000) $        18,753 $      16,737 $        14,952 $       13,356 $        14,742 Required Rate of Return...
Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5...
Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5 Project A: ($1000), 100, 600, 700, 900, 300 Project B: ($1000), 900, 700, 500, 300, 300 The cost of capital for both projects is 10% 1. Find NPV, IRR and profitability index (PI) of projects A and B. 2. If projects A and B are mutually exclusive, which project would you select 3. Find the crossover rate for projects A and B
Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5
  Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5 Project A: ($1000), 100, 600, 700, 900, 300 Project B: ($1000), 900, 700, 500, 300, 300 The cost of capital for both projects is 10% 1. Find NPV, IRR and profitability index (PI) of projects A and B. 2. If projects A and B are mutually exclusive, which project would you select 3. Find the crossover rate for projects A and B
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT