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)...

70.2K

Verified Solution

Question

Finance

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 paybackperiod. Pls do not show the working in excel, pls do it manuallyand attached the formula and also pls explain how you get theanswers. Thank you

Answer & Explanation Solved by verified expert

4.0 Ratings (499 Votes)

YEARValue ofProject ACumulativevalue of ProjectAValue ofProject BCumulativevalue of ProjectBValue ofProject CCumulativevalue of ProjectCValue ofProject DCumulativevalue of See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Transcribed Image Text

Find the discounted payback period.YEARPROJECT APROJECT BPROJECT CPROJECT D0(10,000)(15,000)(20,000)(30,000)15,0005,00010,0000250005,00010,0000320,0005,0004,000100,00041,00010,0002,000120,0005-5,000-60,000answer : A(3 years) B(4years) C(4 years) D(3 years)Pls show me the working on how to get the discounted paybackperiod. Pls do not show the working in excel, pls do it manuallyand attached the formula and also pls explain how you get theanswers. Thank you

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