Question

In: Finance

Find the discounted payback period for the following project. The discount rate is 10% Project X...

Find the discounted payback period for the following project. The discount rate is 10%

Project X
Initial Outlay $8,845
Year 1 $3,480
Year 2 $3,765
Year 3 $5,094
Year 4 $6,366

Round the answer to two decimal places.

Solutions

Expert Solution

Present Value factor

= 1 / ( 1 + r) ^ n

Where,

r = Discount rate = 10% or 0.10

So, PV Factor for year 2 will be

= 1 / ( 1.10 ^ 2)

= 1 / 1.21

= 0.826446

The following table shows the calculations :

Discounted Payback Period = A +

B

C

Where,
A = Last period with a negative discounted cumulative cash flow;
B = Absolute value of discounted cumulative cash flow at the end of the period A; and
C = Discounted cash flow during the period after A.

Calculations A B C = A x B D = Sum C
Period Cash Flow PV Factor Present Value Cumulative
0 -8,845.00 1 -8,845.00 -8,845.00
1    3,480.00 0.909091    3,163.64 -5,681.36
2    3,765.00 0.826446    3,111.57 -2,569.79
3    5,094.00 0.751315    3,827.20     1,257.40
4    6,366.00 0.683013    4,348.06     5,605.47

So, as per above formula, discounted payback period

= 2 + | -2569.79| / 3827.19

= 2.67 Years


Related Solutions

Find the Discounted Payback period for the following project. The discount rate is 10% Project X...
Find the Discounted Payback period for the following project. The discount rate is 10% Project X Initial Outlay $17,249 Year 1 $5,113 Year 2 $5,108 Year 3 $5,772 Year 4 $8,459 Round the answer to two decimal places.
Find the discounted payback period for the following project. THe discount rate is 7%. Initial Outlay...
Find the discounted payback period for the following project. THe discount rate is 7%. Initial Outlay - $8,273 Year 1 - $3.774 Year 2 - $3,300 Year 3 - $5,328 Year 4 - $7,303 Round the answer to two decimal places. Show your work.
4. Find the Discounted Payback period for the following projects. The discount rate is 7%. Initial...
4. Find the Discounted Payback period for the following projects. The discount rate is 7%. Initial Outlay 17,827 Year 1 5917 Year 2 5484 Year 3 5968 Year 4 8405
Consider the following project. Using Discounted Payback Period method (10% rate), how long will it take...
Consider the following project. Using Discounted Payback Period method (10% rate), how long will it take to recover the investment? Year 0 1 2 3 4 5 6 Investment -4000 Profit 1100 1100 1100 1100 1100 1100
Calculate the Payback Period and Discounted Payback Period for the following project: 1. An initial investment...
Calculate the Payback Period and Discounted Payback Period for the following project: 1. An initial investment of $20,000 with expected after-tax operating cash flows of $125,000 per year for each of the next 3 years. However, in preparation for its termination at the end of year 3, an additional investment of $350,000 must be made at the end of Year 2. Please show all work in excel.
What is the discounted payback period using the given discount rate and the cumulative cash flow...
What is the discounted payback period using the given discount rate and the cumulative cash flow in the payback period (must get both correct for full credit) of the investment and annual cash flow given below? Discount Rate Investment Annual Income Cash Flow Useful Life 6% 67,000 12,800 12
Find the discounted payback period. YEAR PROJECT A PROJECT B PROJECT C PROJECT D 0 (10,000)...
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 answer : A(3 years) B(4years) C(4 years) D(3 years) Pls show me the working on how to get the discounted payback period. Pls do not show the working in excel, pls do it manually and attached...
What is the discounted payback period of the following investment if the required return is 10%?...
What is the discounted payback period of the following investment if the required return is 10%? Year Cash Flows 0 = -$90 1 = $30 2 = $35 3 = $30 4 = $25 5 = $20
Given the following cash flows for a capital project, calculate its payback period and discounted payback...
Given the following cash flows for a capital project, calculate its payback period and discounted payback period. The required rate of return is 8 percent. Year 0 1 2 3 4 5 Cash Flows $-37500 $11250 $11250 $15000 $6000 $6000 The discounted payback period is 0.16 year longer than the payback period. 0.80 year longer than the payback period. 1.27 years longer than the payback period. 1.85 years longer than the payback period.
Given the following cash flows for a capital project, calculate its payback period and discounted payback...
Given the following cash flows for a capital project, calculate its payback period and discounted payback period. The required rate of return is 8 percent. Year 0 1 2 3 4 5 Cash Flows $-56900 $13650 $18050 $25200 $10000 $5000 The discounted payback period is
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT