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
  • A company is considering two projects. Project I Project II Initial investment $200,000 $200,000 Cash inflow...

    A company is considering two projects. Project I Project II Initial investment $200,000 $200,000 Cash inflow Year 1 50,000 60,000 Cash inflow Year 2 50,000 60,000 Cash inflow Year 3 50,000 80,000 Cash inflow Year 4 50,000 10,000 Cash inflow Year 5 50,000 50000 What is the payback period for Project II? a.5 years b.1 year c.4.3 years d.2.5 years e.3 years

  • A company is considering two projects. Project A Project B Initial investment $200,000 $200,000 Cash inflow...

    A company is considering two projects. Project A Project B Initial investment $200,000 $200,000 Cash inflow Year 1 $60,000 $90,000 Cash inflow Year 2 $60,000 $90,000 Cash inflow Year 3 $60,000 $40,000 Cash inflow Year 4 $60,000 $50,000 Cash inflow Year 5 $60,000 $70,000 What is the payback period for Project B? a. 4.5 years b. 3.5 years c. 2.5 years d. 2 years e. 3 years

  • What is the payback period for a project with the following costs: Initial investment: $46,700 Year...

    What is the payback period for a project with the following costs: Initial investment: $46,700 Year 1 cash inflow: $10,000 Year 2 cash inflow: $10,000 Year 3 cash inflow: $12,000 Year 4 cash inflow: $12,000 Year 5 cash inflow: $12,000 3.23 years 3.41 years 3.79 years 4.23 years

  • Based upon the following data: calculate the Payback Period. Initial Cost Year 1 Year 2 Year...

    Based upon the following data: calculate the Payback Period. Initial Cost Year 1 Year 2 Year 3 Project A -$50,000 $20,000 $15,000 $20,000 Multiple Choice 1.5 years 2.0 years 2.25 years

  • cash payback method Cash Payback Method Lly Products Company is considering an investment in one of...

    cash payback method Cash Payback Method Lly Products Company is considering an investment in one of two new product lines. The investment required for elither product line is $540,000. The net cash flows associated with each product are as follows: Year Liquid Soap Body Lotion $ 90,000 $170,000 150,000 90,000 3 120,000 90,000 100,000 90,000 4 70,000 90,000 90,000 40,000 40,000 90,000 30,000 90,000 8 $720,000 $720,000 Total a. Recommend a product offering to Lily Products Company, based on the...

  • 1. Will is trying to select the best investment from among 3 alternatives. Each alternative involves...

    1. Will is trying to select the best investment from among 3 alternatives. Each alternative involves an initial outlay of 100,000$. Their cash flows returns for each project are as follows (in $): year project C project A 10,000 20,000 30,000 40,000 50,000 project B 50,000 40,000 30,000 min 45,000 55,000 60,000 a) Evaluate and rank each alternative based on the payback period? What are the general problems associated with using this method? b) Evaluate and rank each alternative based...

  • 1. The cash flows associated with an investment project are as follows: Initial Outflow -$70,000 Year...

    1. The cash flows associated with an investment project are as follows: Initial Outflow -$70,000 Year 1 $20,000 Year 2 $30,000 Year 3 $30,000 Year 4 $30,000 a) What’s the payback period of the project? If a firm’s cutoff payback period is 3 years, should it accept the project? b) If a firm uses discounted payback with a 15% discount rate and a 3-year cutoff period, what’s the discount payback period of the project? Should the firm accept the project?...

  • 1. A&B Enterprises is trying to select the best investment from among three alternatives. Each alternative...

    1. A&B Enterprises is trying to select the best investment from among three alternatives. Each alternative involves an initial outlay of S100,000. The company's cost of capital is 10%. The incremental after tax cash inflows for each project are as follows: Year A B 20,000 $50,000 $25,000 2 20,000 40,000 25,000 3 20,000 30,000 25,000 4 30.000 25,000 5 60,000 25,000 8 a) Payback i) Calculate the payback period (1 decimal) for each project (3 marks). ii) Evaluate and rank...

  • SHOW ALL YOUR WORKS FOR YOUR CALCULATIONS: Calculate "Initial investment and Expected annual net cash inflow"...

    SHOW ALL YOUR WORKS FOR YOUR CALCULATIONS: Calculate "Initial investment and Expected annual net cash inflow" Playmore Products is considering producing toy action figures and sandbox toys. The products require different specialized machines each costing $1 million. Each machine has a five-year life and zero residual value. The two products have different patterns of predicted net cash inflows. (Click the icon to view the data.) Calculate the toy action figure project's payback period. If the toy action figure project had...

  • need question 3 answered 2. Calculating Payback (LO2) An investment project provides cash inflows of $585...

    need question 3 answered 2. Calculating Payback (LO2) An investment project provides cash inflows of $585 per year for eight years. What is the project payback period if the initial cost is $1,700? What if the initial cost is $3,300? What if it is $4,900? 3. Calculating Payback (LO2) McKernan Inc. imposes a payback cutoff of three years for its international investment projects. If the company has the following two projects available, should they accept either of them? -$60,000 Year...

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