Question

In: Finance

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.

Solutions

Expert Solution

Calculation of NPV:
Particulars Time PVF 6.64% Amount PV
Cash Outflow                        -                                                          1.00                     (3,39,858.00)                     (3,39,858.00)
Cash Inflows                      1.00                                                    0.9377                        1,63,676.00                        1,53,484.62
Cash Inflows                      2.00                                                    0.8793                        1,47,656.00                        1,29,840.69
Cash Inflows                      3.00                                                    0.8246                        1,23,800.00                        1,02,084.60
Cash Inflows                      4.00                                                    0.7732                        1,78,407.00                        1,37,953.06
Cash Inflows                      5.00                                                    0.7251                        1,49,077.00                        1,08,096.08
NPV                        2,91,601.06
NPV is $291601.06

Related Solutions

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...
Find the present value of the following stream of cash flows, assuming that the firm's opportunity...
Find the present value of the following stream of cash flows, assuming that the firm's opportunity cost is 12 percent. What would be the future value of those cash flows? Year Amount 1 $10,000 2 35,000 3 24,000 4 53,000
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...
Net Present Value of Payouts The NPV of a series of values is calculated using a...
Net Present Value of Payouts The NPV of a series of values is calculated using a discount rate applied to those values. Apply the NPV function to the series of expected benefit payouts using .075 as the discount rate. You can hard-code the discount rate. How would you calculate this in Excel? Please show calculation and logic used in excel, so I understand. Below are the values: Year Expected Benefit Payouts 2016 NA 2017 $19,661,882,100.00 2018 $19,909,120,629.23 2019 $20,162,051,346.58 2020...
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
The NPV (net present value) of Plan Alpha is $ (130,539) The NPV (net present value)...
The NPV (net present value) of Plan Alpha is $ (130,539) The NPV (net present value) of Plan Beta is $ 233,001 The IRR (internal rate of return) of Plan Alpha is $ 19.36 %. The IRR (internal rate of return) of Plan Beta is $ 21.25 %. Which​ plan, if​ any, should the company​ pursue? Based on the results​ above, the company should pursue Plan Beta because the NPV is positive and the IRR is greater than the​ company's...
Net present value (NPV)The net present value (NPV) rule is considered one of the most...
Net present value (NPV)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 Pheasant Pharmaceuticals is evaluating a proposed capital budgeting project (project Beta) that will require an initial investment of $2,225,000. The project is expected to generate the following net cash flows:YearCash FlowYear 1$275,000Year 2$475,000Year 3$450,000Year 4$450,000Pheasant Pharmaceuticals’s weighted average cost of capital is 8%, and project Beta has the same risk as the...
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...
Find the modified internal rate of return (MIRR) for the following series of future cash flows...
Find the modified internal rate of return (MIRR) for the following series of future cash flows if the company is able to reinvest cash flows received from the project at an annual rate of 8.91 percent.The initial outlay is $354,000. Year 1: $169,600 Year 2: $137,900 Year 3: $178,100 Year 4: $132,200 Year 5: $182,300 Round the answer to two decimal places in percentage form.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT