Question

In: Accounting

Chandler Chairs is considering an equipment investment that will cost $945,000. Projected net cash inflows over...

Chandler Chairs is considering an equipment investment that will cost $945,000.

Projected net cash inflows over the? equipment's three-year life are as? follows: Year? 1:$490,000?;

Year? 2: $402,000?; and Year? 3: $282,000. Chandler wants to know the? equipment's IRR.

LOADING...

?(Click the icon to view the present value annuity? table.)                                            

LOADING...

?(Click the icon to view the present value factor? table.)

LOADING...

?(Click the icon to view the future value annuity? table.)                                                     

LOADING...

?(Click the icon to view the future value factor? table.)

Requirement

Use trial and error to find the IRR within a? 2% range.

?(Hint?:

Use Chandler?'s hurdle rate of 10?% to begin the? trial-and-error process.) Use a business calculator or spreadsheet to compute the exact IRR. Begin by calculating the NPV at three? rates:

10?%,

12?%,

and

1414?%.

?

Begin by calculating the NPV at three? rates: 10?%, 12?%, and 14?%. ?(Round your answers to the nearest whole dollar. Use parentheses or a minus sign for negative net present? values.)

Solutions

Expert Solution

Solution:

Computation of NPV
Particulars Period Amount Discount rate - 10% Discount rate - 12% Discount rate - 14%
PV factor Present Value PV factor Present Value PV factor Present Value
Cash outflows:
Initial Investment 0 $945,000 1 $945,000 1 $945,000 1 $945,000
Present Value of Cash outflows (A) $945,000 $945,000 $945,000
Cash Inflows
Annual Cash Inflows:
Year 1 1 $490,000 0.90909 $445,455 0.89286 $437,500 0.87719 $429,825
Year 2 2 $402,000 0.82645 $332,231 0.79719 $320,472 0.76947 $309,326
Year 3 3 $282,000 0.75131 $211,871 0.71178 $200,722 0.67497 $190,342
Present Value of Cash Inflows (B) $989,557 $958,694 $929,492
Net Present Value (NPV) (B-A) $44,557 $13,694 -$15,508

As NPV is positive at discount factor 12% and NPV is negative at discount factor 14% therefore IRR falls between 12% to 14%.

IRR = 12% + (NPV at 12% - NPV at IRR) / (NPV at 12% - NPV at 14%)*2

= 12% + ($13694 - 0) / ($13,694 + $15,508)*2 = 12.94%


Related Solutions

Tracey Table's is considering an equipment investment that will cost $950,000. Projected net cash inflows over...
Tracey Table's is considering an equipment investment that will cost $950,000. Projected net cash inflows over the​ equipment's three-year life are as​ follows: Year​ 1: $488,000​;Year​ 2: $390,000​; and Year​ 3: $300,000. Tracey wants to know the​ equipment's IRR. Requirement Use trial and error to find the IRR within a​ 2% range. ​(Hint​: Use Tracey​'s hurdle rate of 10​% to begin the​ trial-and-error process.) Use a business calculator or spreadsheet to compute the exact IRR. Begin by calculating the NPV...
The table shows the investment projected net cash inflows of the two projects over the coming...
The table shows the investment projected net cash inflows of the two projects over the coming 5 years. Year Project A Project B 1 $200000 $120000 2 $200000 $130000 3 $200000 $150000 4 $200000 $200000 5 $200000 $240000 Initial investment of $500000 and discount rate at 18% per year under each project. Discount factors for Year 1 to Year 5 as follows: Year 1 0.8475 Year 2 0.7182 Year 3 0.6086 Year 4 0.5158 Year 5 0.4370 Find the payback...
The Zinger Company is considering an $11,000 investment that has the following net cash inflows: Year...
The Zinger Company is considering an $11,000 investment that has the following net cash inflows: Year 1………..$2,000 Year 2………..$2,000 Year 3………..$5,000 Year 4………..$4,000 Year 5………..$4,000 The payback period for this investment is: a. 3.0 years. b. 3.5 years. c. 4.0 years. d. 4.5 years.
Helsinki Co. is considering a new project that will cost $328,500. The expected net cash inflows...
Helsinki Co. is considering a new project that will cost $328,500. The expected net cash inflows from this project are $62,000 per year for 8 years. If Helsinki’s weighted average cost of capital (WACC) is 6%, what is the project’s net present value (NPV), IRR, Payback Period, and Discount Period? Please show work.
Peri Corporation is considering an investment opportunity with the following expected net cash inflows: Year 1,...
Peri Corporation is considering an investment opportunity with the following expected net cash inflows: Year 1, $260,000; Year 2, $340,000; Year 3, $390,000. The company uses a discount rate of 11%, and the initial cost of the investment is $770,000. The IRR of the project will be ________. a between 11% and 12% b between 12% and 13% c more than 13% d less than 11%
A project is projected to cost $2,000,000 to undertake.  It will generate positive cash inflows as follows:  Year...
A project is projected to cost $2,000,000 to undertake.  It will generate positive cash inflows as follows:  Year 1 - $400,000; Year 2 – 500,000; Year 3 - $650,000; Year 4 – 750,000; Year 5 – 800,000.  What is the project’s discounted payback, given a 10% required rate of return? Select one: a. 4.45 years b. 4.82 years c. 4.92 years d. 5.0 years e. Discounted payback does not occur
A project is projected to cost $2,000,000 to undertake.  It will generate positive cash inflows as follows:  Year...
A project is projected to cost $2,000,000 to undertake.  It will generate positive cash inflows as follows:  Year 1 - $400,000; Year 2 – 500,000; Year 3 - $650,000; Year 4 – 750,000; Year 5 – 800,000.  What is the project’s Profitability Index? Select one: a. 1.22 b. 1.20 c. 1.16 d. 1.14 e. 1.12
A new machine will provide the following net annual cash inflows. If the cost of the...
A new machine will provide the following net annual cash inflows. If the cost of the machine is $12,000, what is the payback period? What is the discounted payback period if the discount rate is 10%? Year    Cash Inflow 1 $ 1,345 2. 2,605 3 4,509 4 5,219 5 4,481 6 3,823 7 3,500
A company estimates the following net cash inflows and outflows for a capital investment project that...
A company estimates the following net cash inflows and outflows for a capital investment project that is currently under consideration. year Cash flow 0 (575,000) 1 45,800 2 99,000 3 104,300 4 118,700 5 130,400 6 129,000 7 116,500 8 77,200 9 55,000 10 12,500 Calculate the ARR and NPV of the project.
Blossom Corp. is considering the purchase of a piece of equipment that costs $30000. Projected net...
Blossom Corp. is considering the purchase of a piece of equipment that costs $30000. Projected net annual cash flows over the project’s life are: Year Net Annual Cash Flow 1 $8000 2 15000 3 25000 4 9000 The cash payback period is
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT