Question

In: Finance

QUESTION Match up the payback period with the cash flows. CF0: -1360 CF1: 560 CF2: 330...

QUESTION Match up the payback period with the cash flows.

CF0: -1360 CF1: 560 CF2: 330 CF3: 820 CF4: 200

CF0: -530 CF1: 500 CF2: 100 CF3: 970 CF4: 130

CF0: -900 CF1: 680 CF2: 110 CF3: 950 CF4: 180

CF0: -1675 CF1: 580 CF2: 240 CF3: 700 CF4: 180

CF0: -1230 CF1: 590 CF2: 240 CF3: 550 CF4: 410

A. About 2.73 years B. About 2.12 years C. About 3.86 years D. About 2.57 years E. About 1.30 years

Solutions

Expert Solution

a.

Year Cash flows Cumulative Cash flows
0 (1360) (1360)
1 560 (800)
2 330 (470)
3 820 350
4 200 550

Payback period=Last period with a negative cumulative cash flow+(Absolute value of cumulative cash flows at that period/Cash flow after that period).

=2+(470/820)=2.57 years(D).

b.

Year Cash flows Cumulative Cash flows
0 (530) (530)
1 500 (30)
2 100 70
3 970 1040
4 130 1170

Payback period=Last period with a negative cumulative cash flow+(Absolute value of cumulative cash flows at that period/Cash flow after that period).

=1+(30/100)=1.30 years(E).

c.

Year Cash flows Cumulative Cash flows
0 (900) (900)
1 680 (220)
2 110 (110)
3 950 840
4 180 1020

Payback period=Last period with a negative cumulative cash flow+(Absolute value of cumulative cash flows at that period/Cash flow after that period).

=2+(110/950)=2.12 years(B).

d.

Year Cash flows Cumulative Cash flows
0 (1675) (1675)
1 580 (1095)
2 240 (855)
3 700 (155)
4 180 25

Payback period=Last period with a negative cumulative cash flow+(Absolute value of cumulative cash flows at that period/Cash flow after that period).

=3+(155/180)=3.86 years(C).

e.

Year Cash flows Cumulative Cash flows
0 (1230) (1230)
1 590 (640)
2 240 (400)
3 550 150
4 410 560

Payback period=Last period with a negative cumulative cash flow+(Absolute value of cumulative cash flows at that period/Cash flow after that period).

=2+(400/550)=2.73 years(A).


Related Solutions

Match up the payback period with the cash flows.    CF0: -1800 CF1: 930 CF2: 130...
Match up the payback period with the cash flows.    CF0: -1800 CF1: 930 CF2: 130 CF3: 830 CF4: 420 CF0: -1900 CF1: 800 CF2: 350 CF3: 720 CF4: 120    CF0: -2000 CF1: 820 CF2: 170 CF3: 830 CF4: 320 CF0: -1750 CF1: 700 CF2: 350 CF3: 520 CF4: 450 CF0: -1550 CF1: 500 CF2: 170 CF3: 840 CF4: 320 A. About 3.56 years B. About 3.40 years C. About 3.13 years D. About 2.89 years E. About 3.25...
There is a project with the following cash flows: CF0 = -850; CF1 = 300; CF2...
There is a project with the following cash flows: CF0 = -850; CF1 = 300; CF2 =320; CF3 = 340; CF4 = 360. If the appropriate discount rate is 10%, what is the project's MIRR? (Assume the same reinvestment rate) 14.08% 15.65% 17.21% 18.29% 19.15%
Match up the payback period with the cash flows.       -       A.   ...
Match up the payback period with the cash flows.       -       A.       B.       C.       D.       E.    CF0: -905 CF1: 830 CF2: 130 CF3: 770 CF4: 270       -       A.       B.       C.       D.       E.    CF0: -1075 CF1: 850 CF2: 320 CF3: 730 CF4: 100       -       A.       B.       C.   ...
A potential CB project has the following cash flows: CF0 = -$500, CF1 = $300, CF2...
A potential CB project has the following cash flows: CF0 = -$500, CF1 = $300, CF2 = $200, CF3 = $150. WACC = 6%. Compute the following: A. Payback Period B. NPV C. IRR
An investment project has the following cash flows: CF0 = -1,000,000; CF1 – CF8 = 200,000...
An investment project has the following cash flows: CF0 = -1,000,000; CF1 – CF8 = 200,000 each. If the required rate of return is 12%: a.       What decision should be made using NPV? (5%) b.      How would the IRR decision rule be used for this project? What decision would be reached? (10%)              c.       How are the above two decisions related? (10%)
a. Find present value of the following cash flows at 3% rate: CF0 = -1000; CF1...
a. Find present value of the following cash flows at 3% rate: CF0 = -1000; CF1 = 300; CF2 = 560; CF3 = -90; CF4 = 250. b. What is the future value of these cash flows?
Calculate the IRR(s) for a 10-year project with the following cash flows: CF0 = -30, CF1...
Calculate the IRR(s) for a 10-year project with the following cash flows: CF0 = -30, CF1 = 10 = CF2 = CF3 = CF4 = CF5 = CF6 = CF7 = CF8 = CF9, and CF10 = -65. In Excel, plot the NPV against r (= discount rate), using r = 0%, 2%, 4%, 6%, 8%, 10%, 12%, 14%, 16%, 18%, 20%, 22%, 24%, 26%, 28%, and so on until you find all IRRs on the horizontal axis. Approximately, what...
Your company is considering the following three projects. CF0 CF1 CF2 CF3 CF4 Project Whiskey -100...
Your company is considering the following three projects. CF0 CF1 CF2 CF3 CF4 Project Whiskey -100 80 20 80 20 Project Tango -100 20 80 20 80 Project Foxtrot -100 50 50 50 50 1) What is Project Foxtrot’s MIRR? And, should the project be accepted if we used MIRR as the basis of decision? Assume that the cost of capital is 8%. Show your calculator inputs (CF0=?, CF1=?, CF2=?, CF3=?, CF4=?, etc.) to receive full credit. 2) What is...
(Payback period​) What is the payback period for the set of cash flows in the popup​...
(Payback period​) What is the payback period for the set of cash flows in the popup​ window, LOADING... ​? The payback period for the set of cash flows is nothing years. 0 -11,200 1 3,800 2 4,800 3 3,700 4 4,600 5 3,200 ​ (Payback ​period, NPV,​ PI, and IRR calculations​) You are considering a project with an initial cash outlay of ​$75,000 and expected free cash flows of ​$22,000 at the end of each year for 6 years. The...
Question #1) Cash Payback Period A project has estimated annual net cash flows of $28,000. It...
Question #1) Cash Payback Period A project has estimated annual net cash flows of $28,000. It is estimated to cost $165,200. Determine the cash payback period. Round your answer to one decimal place. years Question #2) Average Rate of Return Determine the average rate of return for a project that is estimated to yield total income of $773,760 over six years, has a cost of $748,800, and has a $83,200 residual value. Round to the nearest whole number. %
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT