Problem One Problem is a simple NPV calculation that combines common sense with its practical implications. The first questions asked for the NPV of a series of cash flows with a discount rate of zero percent. In this instance, investors are not assuming any risk associated with lending the money over the three year period. As such, the NPV will be position as the cash flows are not being discounted. This situation, although rare, is prevailing in our current market economy with interest rates near 0%. The calculation itself was relative easy as the present value of a series or cash flows with a 0% discount rate is simply the value of the cash flows altogether. Therefore, the NPV is simply all the cash flows from the investment added up (Khan, 1993). Problem B was similar in concept to that of Problem A. However, a more realistic discount rate was involved. In this instance, the investor had a required rate of return of 5%. Through the calculations, the NPV was ultimately positive. As such, the investor should provide the initial cash outlay. Finally problem see was a simply IRR calculation using the excel spreadsheet. Through the calculations, the investor or corporation has a 7% hurdle rate before a project can be undertaken (Baker, 2000). Problem 1 Discount Rate 0% Problem A Year Cash Flow Present Value $98,000.00 0 -$549,000.00 -$549,000.00 1 $91,000.00 $91,000.00 2 $182,000.00 $182,000.00 3 $374,000.00
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.
If the IRR exceeds the required rate of return (10%), the project should be accepted. Otherwise, it should be rejected.
32) Compute the NPV for the following project. The initial cost is $5,000. The net cash flows are $1,900 for four years. The net salvage value is $1,000 when the project terminates. The cost of capital is 10%.
d. internal rate of return (IRR) the discount rate that forces a project’s NPV to equal zero. The project should be accepted if the IRR is greater than the cost of capital.
Inc. Corp. is considering a new investment whose data are shown below. The equipment would be depreciated on a straight-line basis over the project's 3-year life, would have a zero salvage value, and would require some additional working capital that would be recovered at the end of the project's life. Revenues and other operating costs are expected to be constant over the project's life. What is the project's NPV? (Hint:
(TCO F) Cornell Enterprises is considering a project that has the following cash flow and WACC data. What is the project's NPV? Note that a project's expected NPV can be negative, in which case it will be rejected.
(二選一) 4.2.Perform a financial analysis for a project using the format provided in Figure4-5. Assume the projected costs and benefits for this project are spread over four years as follows: Estimated costs are $200,000 in Year 1 and $30,000 each year in years 2, 3, and 4. Estimated benefits are $0 in Year 1 and $100,000 each year in years 2, 3, and 4. Use a 9 percent discount rate, and round the discount factors to two decimal places. Create a spreadsheet (or use the business case financials template provided on the companion Web site) to calculate and clearly display the NPV, ROI, and year in which payback occurs. In addition, write a paragraph explaining whether you would recommend investing in this
Financial risks include the short payback period. A 3-year payback period would not allow Hansson the opportunity to breakeven. With a negative NPV in the first 3 years Hansson’s decision to invest in the project would be based on his ability to negotiate a longer contract time. The Net Present Value (NPV) would have to be examined in tandem with the other non-financial variables.
Net Present Value (NPV) calculates the sum of discounted future cash flows and subtracting that amount with the initial investment of the project. If the NPV of a project results in a positive number, the project should be undertaken. It is the most widely used method of capital budgeting. While discount rate used in NPV is typically the organization’s WACC, higher risk projects would not be factored in into the calculation. In this case, higher discount rate should be used. An example of this is when the project to be undertaken happens to be an international project where the country risk is high. Therefore, NPV is usually used to determine if a project will add value to the company. Another disadvantage of NPV method is that it is fairly complex compared to the other methods discussed earlier.
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
Internal rate of return (IRR) and Payback period “IRR of a project provides useful information regarding the sensitivity of the project’s NPV to errors in the estimate of its cost of capital” (Pierson et al.2011, pp.157).This proposal also shows the project is profitable by using Excel to get the IRR of 18.9%, which is
Rainbow Products is considering the purchase of a paint-mixing machine to reduce labor costs.The savings are expected to result in additional cash flows to Rainbow of $5,000 per year. Themachine costs $35,000 and is expected to last for 15 years. Rainbow has determined that the cost ofcapital for such an investment is 12%.[A] Compute the payback, net present value (NPV), and internal rate of return (IRR) for this machine.Should Rainbow purchase it? Assume that all cash flows (except the initial purchase) occur at the endof the year, and do not consider taxes. Rainbow Products is considering the purchase of a paint-mixing machine to reduce labor costs.The savings are expected to result in additional cash flows to Rainbow of $5,000 per
The change in incremental cash flow can be examined through looking at the factors causing change
Scenario 1 which resembles the steady state has a nominal cash flow of 2.5 million. The NPV of scenario 1 is 118,245.21 with an IRR of 8.59%. In scenario 2 the expected cash flow is (2,500,000*1.3) with an NPV of 2,202,737.72 and IRR 16.44%. Scenario 3 has an expected cash flow of (2,500,000*0.85) with an NPV of -960,507.80 and IRR of 4.25%. Taking the three scenarios into account, an expected value of NPV that incorporates the probabilities of each scenario needs to be considered.
If the IRR is less than the capital then that project should be rejected because it is not very feasible. If the Internal Rate of Return is larger than the capital required for the project, it should be accepted while if the IRR is just equal to the capital then the project could be considered because it is at the very least earning its cost of capital and should therefore be accepted at the margin.