Question

In: Economics

What value of G makes the two series of cash flows described below (A and B)...

What value of G makes the two series of cash flows described below (A and B) equivalent at an interest rate of 20% per year?
A: 14 annual deposits in the amount of $150
B: 7 annual deposits, starting in the amount of $150 in the first year and increasing by
$G each year.

Solutions

Expert Solution

This question is solved as follows. First calculate the PV of A, which is straightforward. Then calculate the PV of B without G first. Then we need to find the difference PV of A and PV of B, and this would be equal to the PV of a growing annuity G. It would be easy to solve for G. Pls see table below.

Step 1: PV of A = 692

A / (1.2^Time)
Time A PV(A)
1           150           125
2           150           104
3           150             87
4           150             72
5           150             60
6           150             50
7           150             42
8           150             35
9           150             29
10           150             24
11           150             20
12           150             17
13           150             14
14           150             12
Total           692

Step 2: PV of B, without G

A / (1.2^Time)
Time B PV(B)
1           150           125
2           150           104
3           150             87
4           150             72
5           150             60
6           150             50
7           150             42
Total           541

Step 3: PV of growing annuity G is 692 - 541 = 151

1 / (1.2^Time)
Time CF PV Factor CF * PV Factor (G omitted)
1 G          0.83          0.83
2 2G          0.69          1.39
3 3G          0.58          1.74
4 4G          0.48          1.93
5 5G          0.40          2.01
6 6G          0.33          2.01
7 7G          0.28          1.95
Total        11.86

So 11.86G = 151, hence G = 12.73


Related Solutions

For what value of W will the NPV of the series of cash flows be zero...
For what value of W will the NPV of the series of cash flows be zero at 12% per period interest rate? please use excel and the Goal seek function solving for W. and explain work please....the answer is one of the four Year Cash Flow 0 +$25000 1 -4W 2 18W 3 -16W 4 48W 5 -64W 6 42W 7 -256W 8 52W 9 -64W 10 42W 11 -256W 12 52W $98 $124 $167 $184
Question 1: What is the present value (PV) of the following series of cash flows at...
Question 1: What is the present value (PV) of the following series of cash flows at 10% and its IRR? Year 0: -2,000$ | Year 1: +800$ | Year 2: +600$ | Year 3: +700$ | Year 4: +500$ Question 2: Draw a present value (PV) profile of the following project and determine the IRR(s). Is the project acceptable at 10% cost of capital? Year 0: -4,000$ | Year 1: +10,200$ | Year 2: -6,300$ Observation: if you find cumbersome...
The cash flows for two projects, A and B, are shown in the table, below. Notice...
The cash flows for two projects, A and B, are shown in the table, below. Notice that Project A has a life of 5 years and Project B has a 3 year life. Calculate the NPV of each project and calculate which should be adopted using the replacement chain approach. Assume that the cost of capital is 10%. Project CFs Project CFs Time A B 0 -100 -150 1 20 75 2 25 60 3 30 50 4 30 5...
Suppose you are given the following two projects A and B with the cash flows below,...
Suppose you are given the following two projects A and B with the cash flows below, if the cost of capital is 10%, what is the Profitability Index (PI) of projects A and B? Year Project A Project B 0 -5000 -6000 1 1500 1500 2 2000 2500 3 3000 4000 4 3500 4000
Look at the cash flows for projects F and G given below. Cash Flows($) Project C0...
Look at the cash flows for projects F and G given below. Cash Flows($) Project C0 C1 C2 C3 C4 C5 C6 C7 C8 IRR (%) NPV at 10% F (10,000 ) 6,000 6,000 6,000 0 0 0 0 0 36.3 4,921 G (10,000 ) 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 25.0 6,005 The cost of capital was assumed to be 10%. Assume that the forecasted cash flows for projects of this type are overstated by 8% on...
CRA Company is considering three investment opportunities with cash flows as described below: Project C: Cash...
CRA Company is considering three investment opportunities with cash flows as described below: Project C: Cash investment now………………………………… $ 16,000 Annual Cash inflow for 5 years……………………… $ 10,000 Cash outflow at the end of 3 years…………………..$ 3,000 Additional cash inflow at the end of 5 years……….. $12,000 Project R: Cash investment now…………………………………. $ 7,000 Cash inflow at the end of 2 years……….…………… $ 18,000 Cash inflow at the end of 7 years……………………. $ 40,000 Project A: Cash investment now………………………………….. $...
Find the net present value (NPV) for the following series of future cash flows, assuming the...
Find the net present value (NPV) for the following series of future cash flows, assuming the company’s cost of capital is 6.64 percent. The initial outlay is $339,858. Year 1: 163,676 Year 2: 147,656 Year 3: 123,800 Year 4: 178,407 Year 5: 149,077 Round the answer to two decimal places.
16. Uneven cash flows A series of cash flows may not always necessarily be an annuity....
16. Uneven cash flows A series of cash flows may not always necessarily be an annuity. Cash flows can also be uneven and variable in amount, but the concept of the time value of money will continue to apply. Consider the following case: The Purple Lion Beverage Company expects the following cash flows from its manufacturing plant in Palau over the next five years: Annual Cash Flows Year 1 Year 2 Year 3 Year 4 Year 5 $250,000 $37,500 $180,000...
1) A series of cash flows may not always necessarily be an annuity. Cash flows can...
1) A series of cash flows may not always necessarily be an annuity. Cash flows can also be uneven and variable in amount, but the concept of the time value of money will continue to apply. Consider the following case: The Purple Lion Beverage Company expects the following cash flows from its manufacturing plant in Palau over the next five years: Annual Cash Flows Year 1 Year 2 Year 3 Year 4 Year 5 $100,000 $20,000 $480,000 $450,000 $550,000 The...
A series of cash flows may not always necessarily be an annuity. Cash flows can also...
A series of cash flows may not always necessarily be an annuity. Cash flows can also be uneven and variable in amount, but the concept of the time value of money will continue to apply. Consider the following case: The Purple Lion Beverage Company expects the following cash flows from its manufacturing plant in Palau over the next six years: Annual Cash Flows Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 $400,000 $37,500 $480,000 $450,000 $550,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT