Question

In: Finance

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

Solutions

Expert Solution

Option C $167 is correct
To calculate value of W, We can find NPV which should be equal to zero
Year 1 2 3 4 5 6 7 8 9 10 11 12 Disc. Outflow
Flow                -4               18              -16               48              -64               42           -256               52              -64               42           -256               52
Disc rate=1/(1+12%)^n     0.89286     0.79719     0.71178     0.63552     0.56743     0.50663     0.45235     0.40388     0.36061     0.32197     0.28748     0.25668
Disc Flow        -3.571       14.349      -11.388       30.505      -36.315       21.279 -115.801       21.002      -23.079       13.523      -73.594       13.347         -149.745
NPV must be equal to zero so 25000-149.745W=0
W=25000/149.745
W=167

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

The NPV of a series of cash flows is the following: At a 5% required rate...
The NPV of a series of cash flows is the following: At a 5% required rate of return, the NPV is $41,728 At a 10% required rate of return, the NPV is $24,708 At a 15% required rate of return, the NPV is $9,940 At a 20% required rate of return, the NPV is -$2,968 (note the negative sign) The IRR for the series of cash flows is in which range: Multiple Choice 0% to 5% Between 5% and 10%...
1. Net present value (NPV) Evaluating cash flows with the NPV method The net present value...
1. Net present value (NPV) Evaluating cash flows with the NPV method The net present value (NPV) rule is considered one of the most common and preferred criteria that generally lead to good investment decisions. Consider this case: Suppose Cold Goose Metal Works Inc. is evaluating a proposed capital budgeting project (project Alpha) that will require an initial investment of $450,000. The project is expected to generate the following net cash flows: Year Cash Flow Year 1 $325,000 Year 2...
1. Net present value (NPV) Evaluating cash flows with the NPV method The net present value...
1. Net present value (NPV) Evaluating cash flows with the NPV method The net present value (NPV) rule is considered one of the most common and preferred criteria that generally lead to good investment decisions. Consider this case: Suppose Happy Dog Soap Company is evaluating a proposed capital budgeting project (project Beta) that will require an initial investment of $3,000,000. The project is expected to generate the following net cash flows: Year Cash Flow Year 1 $300,000 Year 2 $475,000...
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...
Evaluating cash flows with the NPV method The net present value (NPV) rule is considered one...
Evaluating cash flows with the NPV method The net present value (NPV) rule is considered one of the most common and preferred criteria that generally lead to good investment decisions. Consider this case: Suppose Happy Dog Soap Company is evaluating a proposed capital budgeting project (project Alpha) that will require an initial investment of $600,000. The project is expected to generate the following net cash flows: Year Cash Flow Year 1 $350,000 Year 2 $475,000 Year 3 $425,000 Year 4...
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.
Given the cash-flows in the table, what is the NPV of project A?
1. Project A Year Cash Flow 0 -$107 1 $69 2 $80 3 $120 WACC = 6.19% Given the cash-flows in the table, what is the NPV of project A?   State your answer to the nearest penny. Give just the number with no dollar sign (e.g., 3.26) If the NPV is negative include the - sign (e.g. -4.28) 2. Using the information in the table, what is the IRR for Project A? Cash Flow Year Project A 0 ($175) 1...
A. What is the NPV of the following cash flows if the required rate of return...
A. What is the NPV of the following cash flows if the required rate of return is 0.05? Year 0 1 2 3 4 CF -13868 2129 2503 694 3244    Enter the answer with 2 decimals (e.g. 1000.23). B. Winnebagel Corp. currently sells 39298 motor homes per year at $59840 each, and 17359 luxury motor coaches per year at $116566 each. The company wants to introduce a new portable camper to fill out its product line; it hopes to...
"We can calculate future cash flows precisely and obtain an exact value for the NPV of...
"We can calculate future cash flows precisely and obtain an exact value for the NPV of an investment." Explain. Do you agree or disagree with the statement ? a new answer please.
What is NPV, IRR, PI, MIRR of a project with the following cash flows if the...
What is NPV, IRR, PI, MIRR of a project with the following cash flows if the discount rate is 14 percent? Year CF 0 -18,000    1 5000 2 7500 3 8400 4 2100 Also upload your excel files showing your work.
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT