Question
In: Finance
An investment project costs $18,700 and has annual cash flows of $4,000 for six years. Required...
An investment project costs $18,700 and has annual cash flows of $4,000 for six years. Required : (a) What is the discounted payback period if the discount rate is zero percent? (b) What is the discounted payback period if the discount rate is 6 percent? (c) What is the discounted payback period if the discount rate is 22 percent?
Solutions
Expert Solution
Answer :
a) 4.68 Years
b) 5.66 Years
c) Never
Notes:
a) Discounted Payback Period =
( Last Year with a Negative Cumulative Cash Flow ) + [( Absolute Value of negative Cumulative Cash Flow in that year)/ Total Present Cash Flow in the following year)]
At Zero Percent :
Discounted Payback Period =
= 4+(2700/4000)
= 4.68 Years
Working:
| Cash Flow | Discounting Factor ( 0%) | Present Value (Cash Flow * Discounting Factor) | Cumulative Cash Flow (Present Value of Current Year+ Cumulative Cash Flow of Previous Year) | |
| 0 | -18,700 | 1 | -18,700.00 | -18,700.00 |
| 1 | 4,000 | 1.0000 | 4,000.00 | -14,700.00 |
| 2 | 4,000 | 1.0000 | 4,000.00 | -10,700.00 |
| 3 | 4,000 | 1.0000 | 4,000.00 | -6,700.00 |
| 4 | 4,000 | 1.0000 | 4,000.00 | -2,700.00 |
| 5 | 4,000 | 1.0000 | 4,000.00 | 1,300.00 |
| 6 | 4,000 | 1.0000 | 4,000.00 | 5,300.00 |
b) At 6% ,
Discounted Payback Period =
( Last Year with a Negative Cumulative Cash Flow ) + [( Absolute Value of negative Cumulative Cash Flow in that year)/ Total Present Cash Flow in the following year)]
= 5+(1850.54/2819.84)
= 5.66 years
Working :
| Cash Flow | Discounting Factor ( 6%) | Present Value (Cash Flow * Discounting Factor) | Cumulative Cash Flow (Present Value of Current Year+ Cumulative Cash Flow of Previous Year) | |
| 0 | -18,700 | 1 | -18,700.00 | -18,700.00 |
| 1 | 4,000 | 0.9434 | 3,773.58 | -14,926.42 |
| 2 | 4,000 | 0.8900 | 3,559.99 | -11,366.43 |
| 3 | 4,000 | 0.8396 | 3,358.48 | -8,007.95 |
| 4 | 4,000 | 0.7921 | 3,168.37 | -4,839.58 |
| 5 | 4,000 | 0.7473 | 2,989.03 | -1,850.54 |
| 6 | 4,000 | 0.7050 | 2,819.84 | 969.30 |
c) At 22% ,
Discounted Payback Period =
( Last Year with a Negative Cumulative Cash Flow ) + [( Absolute Value of negative Cumulative Cash Flow in that year)/ Total Present Cash Flow in the following year)]
= Never
Working :
| Cash Flow | Discounting Factor ( 6%) | Present Value (Cash Flow * Discounting Factor) | Cumulative Cash Flow (Present Value of Current Year+ Cumulative Cash Flow of Previous Year) | |
| 0 | -18,700 | 1 | -18,700.00 | -18,700.00 |
| 1 | 4,000 | 0.8197 | 3,278.69 | -15,421.31 |
| 2 | 4,000 | 0.6719 | 2,687.45 | -12,733.86 |
| 3 | 4,000 | 0.5507 | 2,202.83 | -10,531.03 |
| 4 | 4,000 | 0.4514 | 1,805.60 | -8,725.44 |
| 5 | 4,000 | 0.3700 | 1,480.00 | -7,245.44 |
| 6 | 4,000 | 0.3033 | 1,213.11 | -6,032.33 |
jeff jeffy answered 2 years agoRelated Solutions
An investment project costs $20,500 and has annual cash flows of $4,300 for six years. Required...
An investment project costs $20,500 and has annual cash flows of
$4,300 for six years. Required : (a) What is the discounted payback
period if the discount rate is zero percent? (b) What is the
discounted payback period if the discount rate is 3 percent? (c)
What is the discounted payback period if the discount rate is 19
percent?
An investment project costs $18,900 and has annual cash flows of $3,700 for six years. ...
An investment project costs $18,900 and has annual cash flows
of $3,700 for six years.
Required :
(a)
What is the discounted payback period if the discount rate is
zero percent?
(b)
What is the discounted payback period if the discount rate is 4
percent?
(c)
What is the discounted payback period if the discount rate is
22 percent?
An investment project costs $10,000 and has annual cash flows of $2,850 for six years. ...
An investment project costs $10,000 and has annual cash flows of
$2,850 for six years.
a.
What is the discounted payback period if the discount rate is
zero percent? (Enter 0 if the project never pays back. Do
not round intermediate calculations and round your answer to 2
decimal places, e.g., 32.16.)
b.
What is the discounted payback period if the discount rate is 5
percent? (Enter 0 if the project never pays back. Do not
round intermediate calculations...
An investment project costs $12,500 and has annual cash flows of $3,100 for six years. a....
An investment project costs $12,500 and has annual cash flows of
$3,100 for six years.
a. What is the discounted payback period if the discount rate is
zero percent? b. What is the discounted payback period if the
discount rate is 5 percent? c. What is the discounted payback
period if the discount rate is 21 percent?
An investment project costs $17,400 and has annual cash flows of $4,300 for six years. a....
An
investment project costs $17,400 and has annual cash flows of
$4,300 for six years.
a. What is the discounted payback period if the discount rate
is 5 percent?
4.64, 4.73, 4.55, 4.99
b. What is the discounted payback period is the discount rate
is 18 percent?
never, 1.02, 3.98, 3.35
An investment project costs $18,300 and has annual cash flows of $3,900 for six years. ...
An investment project costs
$18,300 and has annual cash flows of $3,900 for six years.
Required
:
(a)
What is the discounted payback
period if the discount rate is zero percent?
(Click to
select)4.344.64.794.695.04
(b)
What is the discounted payback
period if the discount rate is 4 percent?
(Click to
select)5.415.655.25.34.95
(c)
What is the discounted payback
period if the discount rate is 20 percent?
An investment project costs $16,600 and has annual cash flows of $4,300 for six years. a....
An investment project costs $16,600 and has annual cash flows of
$4,300 for six years.
a. What is the discounted payback period if the
discount rate is zero percent?
b. What is the discounted payback period if the
discount rate is 4 percent?
c. What is the discounted payback period if the
discount rate is 21 percent?
An investment project costs $17,200 and has annual cash flows of $4,200 for six years. ...
An investment project costs $17,200 and has annual cash flows
of $4,200 for six years.
a. What is the discounted payback period if
the discount rate is zero percent?
4.10
4.18
4.01
4.45
3.75
b. What is the discounted payback period if
the discount rate is 3 percent?
4.44
4.53
4.35
4.79
4.09
c. What is the discounted payback period if
the discount rate is 20 percent?
Never
1.02
3.98
3.35
4.35
An investment project costs $15,000 and has annual cash flows of $3,300 for six years. a....
An investment project costs $15,000 and has annual cash flows of
$3,300 for six years. a. What is the discounted payback period if
the discount rate is zero percent? b. What is the discounted
payback period if the discount rate is 5 percent? c. What is the
discounted payback period if the discount rate is 18 percent?
An investment project costs $12,900 and has annual cash flows of $3,000 for six years. ...
An investment project costs $12,900 and has annual cash flows
of $3,000 for six years.
Required :
(a)
What is the discounted payback period if the discount rate is
zero percent?
(Click to
select) 4.39 4.21 4.65 3.95 4.3
(b)
What is the discounted payback period if the discount rate is 3
percent?
(Click to
select) 4.33 4.68 4.77 4.58 5.03
(c)
What is the discounted payback period if the discount rate is
21 percent?
(Click to
select) Never 3.98 1.02 3.35 4.35
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Write a method speedingTicket() that decides whether a driver should be given a ticket from a...
- Beasley Ball Bearings paid a $4 dividend last year. The dividend is expected to grow at...
- 7. In order to improve the network performance and security, ACLs is recommended. Please explain what...
- Noting that there has been an increasing interest in organic foodstuffs with increasing affluence, Mr Tommy...
- 1. the physical sites at which crossing over occurs are the.... A. chiasmata B. Centrioles C....
- Develop a Java program that determines the gross pay for an employee. The company pays hourly...
- Discuss the four evolving company orientations. Which orientation is considered most successful and why?
ADVERTISEMENT