Question

In: Finance

Determine the interest rate (i) that makes the pairs of cash flows below economically equivalent. Year...

Determine the interest rate (i) that makes the pairs of cash flows below economically equivalent.

Year

Pair 1

Pair 2

0

$0

0

1

$2000

$2500

2

$2000

$1875

3

$2000

$1406

4

$2000

$1055

5

$2000

$791

6

$2000

$595

Solutions

Expert Solution

as we press the enter buttong the changed screen is as below

the value in cell d293 tuns zero and the disount factor turns 23.96%.so the answer is 23.96%. please ask if any query.

the goal function is in tab data and goal seek.


Related Solutions

Consider the following cash flows and interest rates: End of Year   Interest Rate During Period   Cash...
Consider the following cash flows and interest rates: End of Year   Interest Rate During Period   Cash Flow at End of Period 0 $0 1 10% $2,000 2 8% −$3,000 3 12% $4,000 A. Determine the future worth of this series of cash flows. B. Determine the present worth of this series of cash flows. C. Determine a 3-year uniform annual series that is equivalent to the original series.
For the alternatives shown below, determine the incremental rate of return for cash flows for Q...
For the alternatives shown below, determine the incremental rate of return for cash flows for Q – P. Alternative P Alternative Q First cost, $ -50,000 -85,000 Annual operating cost, $ per year -8,600 -2,000 Annual revenue, $ per year 22,000 45,000 Salvage value, $ 3,000 8,000 Life, years 2 3
Below are the expected cash flows and interest rates for the next nine years. Cash flows...
Below are the expected cash flows and interest rates for the next nine years. Cash flows will occur at the end of the nominated years. Cash Flows Interest Rates Year 0 Years 1 - 2 8% Year 1 Year 2 +$ 6,500 Year 3 +$ 1,500 Years 3 – 8 6% Year 4 Year 5 Year 6 -$ 2,500 Year 7 Year 8 Year 9 +$ 10,000 Years 9 - 10 7% Year 10 i. Using the Table function within...
For the cash flows shown, determine the equivalent uniform annual worth in years 1 through 5...
For the cash flows shown, determine the equivalent uniform annual worth in years 1 through 5 at an interest rate of 18% per year, compounded monthly. Year 1 2 3 4 5 Cash Flow, $ 0 0 350,000 350,000 350,000 The equivalent uniform annual worth in years 1 through 5 at an interest rate of 18% per year, compounded monthly is $
Interest rate = 6.5%, calculate the future value of the following cash flows
Interest rate = 6.5%, calculate the future value of the following cash flows Years:                          0                      1                      2                      3                      4 |                      |                      |                      |                      | Cash Flows:                 $0                   $75                  $225                  $0                  $300 a.   $526.0 b.   $553.7 c.    $582.8 d.   $645.8
What was the PV of the following cash flows using interest rate = 6.0%.
What was the PV of the following cash flows using interest rate = 6.0%. Years:                          0                      1                      2                      3                      4 |                      |                      |                      |                      | Cash Flows:                 $0                 $1,000              $2,000              $2,000              $2,000 a.   $5,987 b.   $6,276 c.    $6,505 d.   $6,730
Two projects A and B with the following cash flows with a fix interest rate of...
Two projects A and B with the following cash flows with a fix interest rate of 12%. A. Use the present worth to select which project is better? Table 1 Project A 0 1 2 3 -9000 3000 3000 6000 Table 2 Project B 0 1 2 3 -12000 4000 3000 8000 B. Repeat the question in part A using AW analysis C. Repeat the question in part A using FW analysis
The IRR is the interest rate that makes the Present Worth "PW" of all the cash...
The IRR is the interest rate that makes the Present Worth "PW" of all the cash flows (inflows and outflows) equal to zero True False
The present value of the following cash flows at 6% interest would be what? YEAR                CASH...
The present value of the following cash flows at 6% interest would be what? YEAR                CASH FLOW     1                    $4 500     2                    $5 600     3`                   $8 500     4                    $9 000 Multiple Choice $23 495 $18 766 $24 675 $21 223
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.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT