Question

In: Finance

Consider the following two cash flows: CF1: 100 at t=0, 200 at t=2, and 300 at...

Consider the following two cash flows:

CF1: 100 at t=0, 200 at t=2, and 300 at t=3

CF2: X at t=1, X at t=2, and 2X at t=4

The interest rate rises by 3% every year, so:

between t=0 and t=1: i=0%; between t=1 and t=2: i=3%; between t=2 and t=3: i=6%, etc.

What the value of X that makes the two cash flows equivalent?

Question 3 options:

86-106

106-126

126-146

146-166

None of the above

Solutions

Expert Solution

146-166

We first chalk out the cash-flows and discount them using the interest rates given

We input X=1, for assumption

Input the following constraints in an excel solver ( We take the Present value of both the cash flows equal)

Solving, we get

Hence, X= 155.815

Hence, 146-166 is the correct option


Related Solutions

Consider the following cash flows for two mutually exclusive investments : t=0 t=1 t=2 t=3 A...
Consider the following cash flows for two mutually exclusive investments : t=0 t=1 t=2 t=3 A ($1,212) $898 $543 $111 B ($911) $101 $234 $1,033 Given the cost of capital is 8% what is the internal rate of return of the better project?
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%
The cash flows of a firm next year will be $100, $200 and $300 in (equally...
The cash flows of a firm next year will be $100, $200 and $300 in (equally probable) bad, normal and good states, respectively. The firm dissolves at the end of the year and discount rates are zero. Shareholders decide to issue bonds with face value $100 and distribute the proceeds as dividends. Shareholders decide to issue additional debt, according to the existing covenants, with face value $100 and pocket the proceeds as dividends. 1. What is the change in shareholder...
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
Scenario Information: Assume that two gas stations are for sale with the following cash flows: CF1...
Scenario Information: Assume that two gas stations are for sale with the following cash flows: CF1 is the Cash Flow in the first year, and CF2 is the Cash Flow in the second year. This is the timeline and data used in calculating the Payback Period, Net Present Value, and Internal Rate of Return. The calculations are done for you. Your task is to select the best project and explain your decision. The methods are presented and the decision each...
Consider a project with the following cash flows: $3,500 at t=1, $12,500 at t=2, $15,000 at...
Consider a project with the following cash flows: $3,500 at t=1, $12,500 at t=2, $15,000 at t=3, $15,000 at t=4. The Discounted Payback Period of this project is 3.3 years. The appropriate discount rate is 11%. Find the Net Present Value of the project. (Note that the cash flow for t=0 is not provided to you.) A.  $6,916.67 B.  ($11,852.73) C.  ($1,627.27) D.  $4,952.58 E.  Insufficient information.
Consider the following cash flows:    Year Cash Flow 0 $-28,400       1 15,300       2...
Consider the following cash flows:    Year Cash Flow 0 $-28,400       1 15,300       2 13,600       3 10,000          Requirement 1: What is the profitability index for the above set of cash flows if the relevant discount rate is 8 percent? (Do not round intermediate calculations. Round your answer to 3 decimal places (e.g., 32.161).)      Profitability index       Requirement 2: What is the profitability index if the discount rate is 13 percent? (Do not round...
Time 0 1 2 3 4 5 Cash flows -800 80 100 300 500 500 Financing...
Time 0 1 2 3 4 5 Cash flows -800 80 100 300 500 500 Financing rate=15% Reinvestment rate=20% a) Write the excel command to calculate the NPV: b) Write the NPV numerical value: c) Write the excel command to calculate the IRR: d) Write the IRR numerical value: e) Write the excel command to calculate the MIRR: f) Write the MIRR numerical value: h) Write the excel command to calculate the PI: i) Write the PI numerical value:
Assume continuous compounding. Year (t) Bond A's Cash Flows Bond B's Cash Flows 1 0 100...
Assume continuous compounding. Year (t) Bond A's Cash Flows Bond B's Cash Flows 1 0 100 2 0 100 3 0 100 4 0 100 5 1000 1100 The yield to maturity on both bonds is 5.5%. a. What are the current prices for the bonds? b. What is the duration for each of the bonds? c. If the yield to maturity of both bonds were to increase 85 basis points, what would be the approximate percentage change in the...
​​ Considering the following projects. Project Year 0 1 2 3 4 A Cash flows -$100...
​​ Considering the following projects. Project Year 0 1 2 3 4 A Cash flows -$100 $35 $35 $35 $35 B Cash flows -$100 $60 $50 $40 $30 If project B is risker than project A, in which project A has WACC = 6.00% while project B has WACC = 8.50%. If these two projects are mutually exclusive, which project should the company accept? Compute: NPV, IRR, MIRR, payback, and discounted payback period for each project. # please with details.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT