Introduction The purpose of this analysis is to make a determination about a project that the PowerCo is considering. The project runs for twelve years. The discount rate is 8%. There are costs for the first two years and then there are net positive cash flows for the subsequent ten years. A net present value calculation will be used in order to determine if the company should undertake this project or not. The present value calculations will be done according to this formula:
INCLUDEPICTURE "http://i.investopedia.com/inv/dictionary/terms/NPV.gif" * MERGEFORMATINET
Source: Investopedia (2012)
The present value of the costs is as follows:
Year
1
2
Cash Flow
-25
-28
PV
-23.1481
-24.0055
So therefore the total PV of the costs is $47.15.
The total after-tax PV of the revenues is $47.24, using the same formula.
The total NPV for the project, therefore, is $.08 million, or $80,000, based on the formula of $47.24-$47.15 (with rounding). The full calculation is shown in Appendix A.
Approving the project is fraught with risk. Although it has a positive NPV, it is only positive by the slimmest of margins. This means that any change for the negative in any of the assumptions and the project would have a negative NPV. Normally, this type of project would need to be subjected to a rigorous sensitivity analysis before it is approved. All of the calculations are based on assumptions, and if any of those assumptions is poorly-conceived, the project would have a
Free cash flows of the project for next five years can be calculated by adding depreciation values and subtracting changes in working capital from net income. In 2010, there will be a cash outflow of $2.2 million as capital expenditure. In 2011, there will be an additional one time cash outflow of $300,000 as an advertising expense. Using net free cash flow values for next five years and discount rate for discounting, NPV for the project comes out to be $2907, 100. The rate of return at which net present value becomes zero i.e.
Any type of project should be accepted if the NPV is positive and rejected if it is negative.
In the case of Worldwide Paper Company we performed calculations to decide whether they should accept a new project or not. We calculated their net income and their cash flows for this project (See Table 1.6 and 1.5). We computed WPC’s weighted average cost of capital as 9.87%. We then used the cash flows to calculate the company’s NPV. We first calculated the NPV by using the 15% discount rate; by using that number we calculated a negative NPV of $2,162,760. We determined that the discount rate of 15% was out dated and insufficient. To calculate a more accurate NPV for the project, we decided to use the rate of 9.87% that we computed. Using this number we got the NPV of $577,069. With the NPV of $577,069 our conclusion is to accept this
NPV and IRR: When examining the NPV and the IRR of the Merseyside project, the numbers were very attractive. It had a positive net present value and an IRR above 10 percent. By these numbers, along with others,
The present value of the net incremental cash flows, totaling $5,740K, is added to the present value of the Capital Cost Allowance (CCA) tax shield, provided by the Plant and Equipment of $599K, to arrive at the project’s NPV of $6,339K. (Please refer to Exhibit 4 and 5 for assumptions and detailed NPV calculations.) This high positive NPV means that the project will add a significant amount of value to FMI. In addition, using the incremental cash flows (excluding CCA) generated by the NPV calculation, we calculated the project’s IRR to be 28%. This means that the project will generate a higher rate of return than the company’s cost of capital of 10.05%. This is also a positive indication that the company should undertake the project.
This analysis is done assuming the benefits accrued in the year 2050. The costs are evaluated from the year 2011 – the proposed time of starting the project, while the benefits are calculated from the year 2020 – the expected time of launching the project. The estimated streams of benefits and costs occurring each year between 2011 and 2050 were discounted to their present value and summarized to calculate the benefit cost ratio.
The purpose of the following analysis is to determine whether PowerCo, a medium sized power company in the southeast United States should build a new generator. It is the belief of PowerCo that demand for electricity will significantly increase over the next 10-12 years. In order to meet this demand, the investment in a new generator needs to be reviewed. PowerCo’s Treasury department has prepared financial projections to facilitate the analysis of the investment. This information will be used for the analysis in order to provide a recommendation of whether PowerCo should build or not build the new generator.
4. Based on the information provided in the case, our group calculated the NPV for the project under both tax environment and tax-free condition, respectively, by using the excel spreadsheet and the NPV function. (For a detailed calculation of NPV, please refer to Appendix Under 15-yr.) According to our calculation, we have the following results: In the first case scenario, which the firm is in a tax environment (35% income tax), the NPV of the project equals to -$6,366,054.53
To be able to analyze the project, we need to calculate the project’s NPV, IRR, MIRR, Payback Period, and Profitability Index.
Evaluating the risks, calculating the probability of success, and factoring in the projected profit from sales will provide a clearer NPV to be compared with other projects in the
5. Estimate the project’s operating cash flows. (Hint: Again use Table 1 as a guide.) What are the project’s NPV, IRR, modified IRR (MIRR), and payback? Should the project be undertaken? [Remember: The MIRR is found in three steps: (1) compound all cash inflows forward to the terminal year at the cost of capital, (2) sum the compounded cash inflows to obtain the terminal
This analysis will determine whether or not the project is worth pursuing using a net present value (NPV) approach.
The use of an accounting rate of return also underscores a project 's true future profitability because returns are calculated from accounting statements that list items at book or historical values and are, thus, backward-looking. According to the ARR, cash flows are positive due to the way the return has been tabulated with regard to returns on funds employed. The Payback Period technique also reflects that the project is positive and that initial expenses will be retrieved in approximately 7 years. However, the Payback method treats all cash flows as if they are received in the same period, i.e. cash flows in period 2 are treated the same as cash flows received in period 8. Clearly, it ignores the time value of money and is not the best method employed. Conversely, the IRR and NPV methods reflect that The Super Project is unattractive. IRR calculated is less then the 10% cost of capital (tax tabulated was 48%). NPV calculations were also negative. We accept the NPV method as the optimal capital budgeting technique and use its outcome to provide the overall evidence for our final decision on The Super Project. In this case IRR provided the same rejection result; therefore, it too proved its usefulness. Despite that, IRR is not the most favorable method because it can provide false results in the case where multiple negative
The following paper analyzes a project from financial perspectives using the capital budgeting techniques like Net Present Value (NPV) and Internal Rate of Return (IRR).
This project evaluates the discounted Net Present Value which shows the estimated cash flow. The cash flow forecast is for 10 year which incorporates International complexities as well as the cost of capital.