Question

In: Finance

Use both the NET present value (NPV) and the Internal Rate of return (IRR) to assess...

Use both the NET present value (NPV) and the Internal Rate of return (IRR) to assess and draw conclusions when advising a company which is wondering whether to K18 000 on an item of equipment in order to obtain cash profits as shown below

                      Year                                          K

                        1                                              6000

                        2                                              8000

3            5000

4                                              1000

Note: The company requires a return of 10% per annum.

Solutions

Expert Solution

Intial Investment, C0 = k 18000

Cashflows in

Year 1, C1 = K 6000

Year 2, C2 = K 8000

Year 3, C3 = K 5000

Year 4, C4 = K 1000

Required rate of return, r = 10%

NPV = Present value of future cashflow - Initial investment

NPV = [ (6000 / (1+ 10%)^1 ] + [ (8000 / (1+ 10%)^2 ] + [ (5000 / (1+ 10%)^3 ] + [ (1000 / (1+ 10%)^4 ]   - 18000

NPV = 5455 + 6612 + 3757 + 683 - 18000

NPV =    K - 1494.30

Since, NPV is negative, company should not invest in this equipment.

Now calculating IRR

At IRR

NPV = 0

[ (6000 / (1+ r%)^1 ] + [ (8000 / (1+ r%)^2 ] + [ (5000 / (1+ r%)^3 ] + [ (1000 / (1+ r%)^4 ] = 18000

solving this will give

r = 5.325%

now, IRR < required rate of return wanted by the company (10%)

Hence, company SHOULD NOT invest in this equipment.

Showing the same calculation in excel:

Discount Rate/WACC (r) 10%
PROJECT W
years 0 1 2 3 4
Cash-Outflows 18,000
Cash-Inflows 6,000 8,000 5,000 1,000
Net Cashflows (Inflow - Outflow) -18,000 6,000 8,000 5,000 1,000
Discounted Cashflow
= Net CF / (1+r)^years
-18,000 5,455 6,612 3,757 683
NPV = sum of all discounted CF -1,494.30
IRR = IRR (net CF) 5.325%

Related Solutions

Describe the use of internal rate of return (IRR), net present value (NPV), and the payback...
Describe the use of internal rate of return (IRR), net present value (NPV), and the payback method in evaluating project cash flows.
3. Understanding the IRR and NPV The net present value (NPV) and internal rate of return...
3. Understanding the IRR and NPV The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting decisions. Consider the case of Cute Camel Woodcraft Company: Last Tuesday, Cute Camel Woodcraft Company lost a portion of its planning and financial data when both its main and its backup servers crashed. The company’s CFO remembers that the internal rate of return (IRR) of Project Gamma is...
3. Understanding the IRR and NPV The net present value (NPV) and internal rate of return...
3. Understanding the IRR and NPV The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting decisions. Consider the case of Blue Hamster Manufacturing Inc.: Last Tuesday, Blue Hamster Manufacturing Inc. lost a portion of its planning and financial data when both its main and its backup servers crashed. The company’s CFO remembers that the internal rate of return (IRR) of Project Delta is...
3. Understanding the IRR and NPV The net present value (NPV) and internal rate of return...
3. Understanding the IRR and NPV The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting decisions. Consider the case of Cold Goose Metal Works Inc.: Last Tuesday, Cold Goose Metal Works Inc. lost a portion of its planning and financial data when both its main and its backup servers crashed. The company’s CFO remembers that the internal rate of return (IRR) of Project...
The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are...
The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting decisions. Consider the case of Cold Goose Metal Works Inc.: Last Tuesday, Cold Goose Metal Works Inc. lost a portion of its planning and financial data when both its main and its backup servers crashed. The company’s CFO remembers that the internal rate of return (IRR) of Project Omicron is 13.2%, but he can’t...
The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are...
The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting decisions. Consider the case of Blue Hamster Manufacturing Inc.: Last Tuesday, Blue Hamster Manufacturing Inc. lost a portion of its planning and financial data when both its main and its backup servers crashed. The company’s CFO remembers that the internal rate of return (IRR) of Project Lambda is 11.3%, but he can’t recall how...
Net Present Value (NPV) and Internal Rate of Return (IRR) (question) The City and County of...
Net Present Value (NPV) and Internal Rate of Return (IRR) (question) The City and County of Denver is completing a $45 million renovation of City Park Golf Course. To complete the renovation, the course has been closed to the public for 2.5 years (planned re-opening is Spring 2020). The project updated the course, built a new clubhouse that can accommodate golf and community events, resulted in a “net gain of 500 trees”, and reduced flood risk “for thousands of homes”.[1]...
1 (b) Compare the merits of the net present value (NPV), internal rate of return (IRR)...
1 (b) Compare the merits of the net present value (NPV), internal rate of return (IRR) and discounted payback period methods of capital investment project appraisal, assuming the firm’s objective is to maximise the wealth of its equityholders. What conditions must apply for the net present value (NPV) and internal rate of return (IRR) methods to always give the same signal to accept or reject a capital investment project? (210 words)
If a project's net present value (NPV) is positive, its internal rate of return (IRR) must...
If a project's net present value (NPV) is positive, its internal rate of return (IRR) must be ______ the firm's required rate of return (r) a. less than b. greater than c. equal to
Net present value (NPV) method and internal rate of return (IRR) are largely used by firms...
Net present value (NPV) method and internal rate of return (IRR) are largely used by firms to assess financial feasibility of an investment. It is also not uncommon to find that these two methods provide conflicting signals on the viability of a project. Explain how do these two methods differ from payback period and accounting rate of return methods, and discuss how NPV-IRR conflict can be remedied.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT