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...
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………………………………….. $...
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...
Consider the time-series data in columns A and B on the below (picture). Week (A) Value...
Consider the time-series data in columns A and B on the below (picture). Week (A) Value (B) 1 24 2 13 3 20 4 12 5 19 6 23 7 15 a. Using the naive method, develop a forecast for this time series. Compute MSE and MAPE. Show the forecast for week 8. b. Using all previous values, develop a forecast for this time series. Compute MSE and MAPE. Show the forecast for week 8. c. Develop a three-week moving...
Consider the time-series data in columns A and B on the below (picture). Week (A) Value...
Consider the time-series data in columns A and B on the below (picture). Week (A) Value (B) 1 24 2 13 3 20 4 12 5 19 6 23 7 15 a. Using the naive method, develop a forecast for this time series. Compute MSE and MAPE. Show the forecast for week 8. b. Using all previous values, develop a forecast for this time series. Compute MSE and MAPE. Show the forecast for week 8. c. Develop a three-week moving...
Consider investments A and B with cash flows given below n A B 0 -30000 -30000...
Consider investments A and B with cash flows given below n A B 0 -30000 -30000 1 2000 11000 2 6000 10000 3 10000 10000 4 24000 8000 5 26000 5000 a) Find the IRR for each investment. b) Find the incremental IRR, i.e., find IRR for B-A. c) Plot the present worth of the cash flows of A and of B as a function of the interest rate, i.e., consister interest rates 5%,10%,15%,…, 40%. Identify the interest rate at...
An ordinary annuity is characterised by: a. a series of cash flows that are identical in...
An ordinary annuity is characterised by: a. a series of cash flows that are identical in amount and occur at the end of consecutive time periods over a finite period of time. b. a series of cash flows that are identical in amount and occur at the start of consecutive time periods over a finite period of time. c. None of the answers are correct. d. a series of cash flows that are identical in amount and occur at the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT