Question

In: Finance

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) If you use the payback decision rule to evaluate this project then you accept the project since the payback period is 2.9 years.

(y) If you use the discounted payback decision rule to evaluate this project then you reject the project since the discounted payback period is 3.8 years. (z) The NPV of this project is more than $10,000. If you use the NPV decision rule to evaluate this project; then it should be accepted.

Solutions

Expert Solution

(x) First of all lets calculate payback period:

Year Cash Flows Cumulative Cash Flows Cumulative cash flows calculation
0 (165000) (165000) (Year 0 cash flows)
1 56500 (108500) (Year 0 cash flows + Year 1 cash flows)
2 67400 (41100) (Year 0 cash flows + Year 1 cash flows + Year 2 cash flows)
3 45600 4500 (Year 0 cash flows + Year 1 cash flows + Year 2 cash flows + Year 3 cash flows)

Since in the year between 2 and 3 we get a cumulative cash flow equal to 0, it means that the payback period is in between 2nd and 3rd year, Payback period is calculated by using the below function:

= 2 years + 2nd year cumulative cash flow in positive sign (since the payback period is in between 2nd and 3rd year) / Next years cash flow (i.e. 3rd year cash flow)

= 2 years + 41100 / 45600

= 2.90 years (Approximately)

Hence we can accept the project since the payback period is within the maximum allowable payback period, hence statement (x) is correct.

(y) Now, we shall calculate the discounted pay back period as follows:

Year Cash Flows (1) Discount Factor (2) Discounted Cash Flows (1 x 2) Cumulative discounted cash flows
0 (165000) 1 (165000) (165000)
1 56500 1 / 1.075 = 0.93 52545 (112455)
2 67400 1 / 1.0752 = 0.87 58638 (53817)
3 45600 1 / 1.0753 = 0.80 36480 (17337)
4 29800 1 / 1.0754 = 0.75 22350 5013

Cumulative discounted cash flows are calculated by taking the sum of discounted cash flows

Since in the year between 3 and 4 we get a cumulative cash flow equal to 0, it means that the discounted payback period is in between 3rd and 4th year, Discounted payback period is calculated by using the below function:

= 3 years + 3rd year cumulative cash flow in positive sign (since the discounted payback period is in between 3rd and 4th year) / Next years cash flow (i.e. 4th year cash flow)

= 3 years + 17337 / 22350

= 3.8 years (Approximately)

Hence we can't accept the project since the discounted payback period is more than the maximum allowable discounted payback period, hence statement (y) is correct.

(z). Now, we shall calculate the project's NPV as follows:

= Initial cash outflow + 1st year inflow / ( 1 + required rate of return )1 + 2nd year inflow / ( 1 + required rate of return )2 + 3rd year inflow / ( 1 + required rate of return )3 + 4th year inflow / ( 1 + required rate of return )4 + 5th year inflow / ( 1 + required rate of return )5

= (165000) + 56500 / (1.075)1 + 67400 / (1.075)2 + 45600 / (1.075)3 + 29800 / (1.075)4 + 7500 / (1;.075)5

= 10,126 Approximately   

Since the NPV is more than 10,000 which is more than NPV required in the question, hence the project can be accepted. So statement z is also correct.

So, we can conclude all the three statements are correct.


Related Solutions

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...
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....
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
Year Cash flow (€) 0 - Investment -? 1 150,000 2 150,000 3 4 150,000 ?...
Year Cash flow (€) 0 - Investment -? 1 150,000 2 150,000 3 4 150,000 ? Some years ago X AG paid €15’000 for a vacant lot with planning permission. The plot could easily be sold today for 10 times that amount. X AG has however a project in mind that would occupy the plot and require investment of €200,000 but generate positive cash flows of €150,000 for the next 4 years. X AG will be able to sell the...
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...
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...
Consider the following uneven cash flow stream 0 0 1 $250 2 $400 3 $500 4...
Consider the following uneven cash flow stream 0 0 1 $250 2 $400 3 $500 4 $600 5 $600 What is the present (Year 0) value if the opportunity cost (discount) rate is 10%? Add an outflow (or cost) of $1,000 at Year 0. What is the present value of the cash flow stream? Your oldest daughter is about to start kindergarten at a private school. Tuition is $10,000 per year payable at the beginning of the school year. You...
Consider the following cash flows: Year 0 1 2 3 4 5 6 Cash Flow -$10,000...
Consider the following cash flows: Year 0 1 2 3 4 5 6 Cash Flow -$10,000 $2,200 $3,300 $2,500 $2,500 $2,300 $2,100 A. Payback The company requires all projects to payback within 3 years. Calculate the payback period. Should it be accepted or rejected? B. Discounted Payback Calculate the discounted payback using a discount rate of 10%. Should it be accepted or rejected? C. IRR Calculate the IRR for this project. Should it be accepted or rejected? D. NPV Calculate...
Year Cash Flow 0 $0 1 $250 2 $400 3 $500 4 $600 5 $600 What...
Year Cash Flow 0 $0 1 $250 2 $400 3 $500 4 $600 5 $600 What is the present (Year 0) value if the opportunity cost (discount) rate is 10 percent? Add an outflow (or cost) of $1,000 at Year 0. What is the present value (or net present value) of the stream?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT