Question

Payback Period: Initial Investment Year 1 Cash Inflow Year 2 Cash Inflow Year 3 Cash Inflow...

Payback Period:

Initial Investment

Year 1

Cash Inflow

Year 2 Cash Inflow

Year 3 Cash Inflow

Year 4 Cash Inflow

Year 5 Cash Inflow

Project A

100,000

10,000

10,000

20,000

30,000

30,000

Project B

200,000

50,000

60,000

90,000

60,000

60,000

  1. In years, what is the payback period for Project A?
  2. In years, what is the payback period for Project B?
  3. Based on payback period, which project would you recommend for your company to pursue?

Initial Investment

1st Year Cash Inflow

Quarterly Cash Inflow after 1st Year

Project C

250,000

50,000

25,000

Project D

150,000

30,000

20,000

  1. In months, what is the payback period for Project C?
  2. In months, what is the payback period for Project D?
  3. Based on payback period, which project would you recommend for your company to pursue?

if you can detail the month project payback period calcuations i would appreciate it

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Pay Back Period is the method of capital budgeting in which we calculate for the business time period of recoup of its investment.

If there is even cash flow then we simply divide the initial investment by cash flow we get the pay back period but if the cash flow is uneven then the calculation is done as shown below in the figure.

It is helpful in finding out the appropriate business project among number of projects.

4 100, 000 Annual Period o, ooo o, oo o teaで1. to, 0oo20, 00o ,o o,oo) Yeah 3 Year 4 | (49000+3000: 30,000-, ooo (40,000-+30 0o ear 30, oo0 loo, obo (7o00o+-sopmp In this year we got- inial So this i& baak year initial trwestment tr Project b一串200,000 Annua tears | cash 50, 000 in tsis yearne got initial Year3 ao, ooo 60, Beo

to the caleulation Projest A anal orijest s re dund tat Proest as lngoak foriod 5 years than proj profitable the cerr mng to future

Project C intitial Investment 250,000 Cumulative Cash Month wise MONTHLY Pay Back Years Months Inflow cash inflow Cash Inflow Period Year 1 4167 4167 4167 4167 4167 4167 4167 4167 4167 4167 4167 4167 8333 8333 8333 8333 8333 8333 8333 8333 8333 8333 8333 8333 8333 8333 8333 8333 8333 8333 8333 8333 8333 8333 8333 8333 4167 8333 4 20833 2916 37500 41 45833 10 12 58333 2 25000 75000 4 83333 5 25000 91 100000 108333 116667 125000 133333 Year 2 825000 10 11 25000 12 141 150000 158333 2 25000 175000 In this year 183333 we got 191 200000 investment 208333 of $ 250,000 4 5 25000 initial Year 3 8 25000 So it is the 10 11 25000 12 225000 pay back 233333 period 241 250000

Project Cintitial Investment 250,000 Cumulative MONTHLY Cash Years Months Cash Inflow Month wise cash inflow -D4/12 -SD$A/12 -SD$4/12 -ŞD$4/12 -SD$4/12 SD$4/12 SD$4/12 SD$4/12 -ŞD$4/12 -SD$4/12 -SD$4/12 SD$4/12 -D16/3 -D16/3 -D16/3 -D19/3 D19/3 D19/3 -D22/3 -SD$22/3 -SD$22/3 SD$22/3 SD$22/3 -SD$22/3 -D28/3 -ŞD$28/3 -SD$28/3 -SD$28/3 SD$28/3 -SD$28/3 -SD$28/3 -ŞD$28/3 -SD$28/3 -ŞD$28/3 -$D$28/3 -SD$28/3 Inflow Pay Back Period Year 1 2 -F4+E5 4 -F6+E7 F8 E9 F9+E10 -F10+E11 F11+E12 -F12+E13 -F13+E14 -F14+E15 -F15+E16 -F16+E17 F17+E18 -F18+E19 -F19+E20 -F20+E21 -F21+E22 10 12 4 Year 2 22+E23 F23+E24 -F24+E25 -F25+E26 -F26+E27 -F27+E28 -F28+E29 F29+E30 -F30+E31 -F31+E32 -F32+E33 F33+E34 -F34+E35 -F35+E36 -F36+E37 F37+E38 -F38+E39 10 12 25000 4. In this year we got initial investment of $ 250,000 So it is the pay back period Year 3 25000 10 12

Project C intitial Investment 150,000 Cumulative MONTHLY Cash Cash Month wise Years Months Inflow cash inflow Inflow Pay Back Period Year 1 4 10000 17500 10 27500 12 2500 6667 36667 2 20000 43333 4 6667 56667 5 20000 63333 Year 2 6667 820000 83333 10 11 20000 12 6667 6667 8333 8333 8333 103333 110000 118333 126 135000 2 25000 In this year, in between 4th and 5th month, we got 143333 initial investment of $150,000 So it is the pay back 1516 160000 168333 4 8333 8333 8333 8333 8333 8333 8333 8333 8333 eriod Year 3 825000 10 11 25000 12 185000 193333 2016 210000

The project C has pay back period of 3 years whereas project D has pay back period of 2 years and in between 4 to 5 months. So, the project D has the less payback period hence, this project is recommended to pursue.

Add a comment
Know the answer?
Add Answer to:
Payback Period: Initial Investment Year 1 Cash Inflow Year 2 Cash Inflow Year 3 Cash Inflow...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT