NPV/IRR. Growth Enterprises believes its latest project, which will cost $80,000 to install, will generate a perpetual growing stream of cash flows. Cash flow at the end of this year will be $5,000, and cash flows in future years are expected to grow indefinitely at an annual rate of 5 percent. a. If the discount rate for this project is 10 percent, what is the project NPV? b. What is the project IRR?
Please show excel sheet and formulas. I had OTA 102799 help me with this but did not get the formula or excel. Original answer for NPV was $20,000 - not sure if this is correct or not?
Solution Preview
We can find the NPV in 2 ways: 1 way is through Excel formulae (see the attached sheet). The other and more rigorous way ...
... If the net present value is negative, use either a negative sign preceding the number eg -45 or ...NPV/IRR questions for Bonita Corporation are examined. ...
NPV & IRR question. Solution required for this question. ... a) Determine the investment's net present value, the internal rate of return and payback period. ...
... The solution is clear and understandable. Thank you. ...NET PRESENT VALUE CALCULATION ABCDE CHART ;=(1+C)^A ;=B*D NPV(Y) Discount Rate(X) DISCUSSION YEAR ...
... The solution, presented in a Word document, contains the full detailed solution for all the ... The solutions will be useful to accounting and finance students ...
...IRR is a discount rate: the rate at which ...Net present value should be found out by subtracting present value ... The project should be accepted if NPV is positive ...
... What is the net present value (NPV) of for the expansion project ... is the internal rate of return (IRR) for the ... This solution provides an in depth explanation to ...
... Answer: Expected net present value= ($2,677). ...IRR, NPV, Expected Value of Cash Flow: 1) IRR for the ... manufacturing equipment by Home Security Systems 2) NPV of 2 ...
... FORMULA IRR. 46346.xls Problem 8-22 Buy versus Lease. ... The firm's tax rate is 35 percent. What is the net present value of the project? ...NPV = FORMULA. ...
... and Future value, NPV, IRR, Profitability index ... This solution provides calculations in Excel for ... rate, calculate the Net Present Value, Payback, Profitability ...
