Question

In: Accounting

Figure 14-11. Present value of an Annuity of $1 in Arrears Periods 4% 6% 8% 10%...

Figure 14-11.

Present value of an Annuity of $1 in Arrears

Periods 4% 6% 8% 10% 12% 14%
1 0.962 0.943 0.926 0.909 0.893 0.877
2 1.886 1.833 1.783 1.736 1.690 1.647
3 2.775 2.673 2.577 2.487 2.402 2.322
4 3.630 3.465 3.312 3.170 3.037 2.914
5 4.452 4.212 3.993 3.791 3.605 4.433
6 5.242 4.917 4.623 4.355 4.111 3.889
7 6.002 5.582 5.206 4.868 4.564 4.288
8 6.733 6.210 5.747 5.335 4.968 4.639
9 7.435 6.802 6.247 5.759 5.328 4.946
10 8.111 7.360 6.710 6.145 5.650 5.216

Problem 14-15

Refer to Figure 14-11. Cleves Company is considering two projects.

Project X Project Y
Initial investment $500,000 $100,000
Annual cash flows $88,500 $34,320
Life of the project 10 years 4 years
Depreciation per year $50,000 $25,000

Cleves requires a minimum rate of return of 8 percent.

Required:

A. What is the accounting rate of return for each project? If required, round your answers to two decimal places.

Project X, ARR %
Project Y, ARR %

B. What is the net present value for each project?

Project X, NPV $
Project Y, NPV $

C. What is the internal rate of return for each project?

Project X, IRR %
Project Y, IRR %

D. Given that only one project can be selected, which project should be chosen?

Solutions

Expert Solution

A. ARR means Average Rate of Return or Accounting Rate of Return.

It is a measure to derive the Rate of Return but it doesn’t consider the Time Value of Money, It is measured by dividing the Average Annual Profit by the Initial Investment. Average Annual Profit can be derived in this case by deducting the depreciation from the annual cash flows.

Project X:

Average annual profit = $38,500 ($88,500 - $50,000)

Initial investment = $500,000

ARR = 7.7%

Project Y:

Average annual profit = $9,320 ($34,320 - $25,000)

Initial investment = $100,000

ARR = 9.32%

Cleves minimum rate of return is 8%, if ARR is the measure to chose, Project-X would be rejected by accepting Project-Y.

B. NPV

NPV refers to the Net Present Value, the measure by which we can decide whether to invest in the project or not. If the NPV is greater than 0, it is profitable to invest, otherwise it is not recommended. NPV is calculated by deducting the discounted cash outflows from the discounted cash inflows and discounting factor used is the Cost of Capital of the Project. In this case we can take the discounting factor as 8% as it is the minimum expected return.

NPV is calculated as follows:

Project-X:

Project-Y:

From the above table it is evident that NPV is positive with a value of $93,835 for Project X and $13,667.84 for Project Y, hence it is acceptable to invest in the proposed projects.

C. IRR

IRR refers to the Internal Rate of Return, it is the rate at which the NPV of the project equals to 0. It is the highest rate of return which can be achieved from the proposed investment.

Generally, it is easy to compute IRR by taking the discounting values at two different discount factors and deriving thereupon.

IRR is calculated as follows:

Project X:

Since, NPV at 12% is $ 25 and at 14% is $ (38,384) , we can find the rate at which NPV will be 0 as follows,

= [14%] – [(38,384 - 25) ÷ 38,384] × 2%

= 14 - 1.9987

= 12.0013%

Project Y:

Since, NPV at 14% is $ 8.48 and at 16% is $ (3,972.64) , we can find the rate at which NPV will be 0 as follows,

= [16%] – [(3,972.64 – 8.48) ÷ 3,972.64] × 2%

= 16 - 1.9957

= 14.0043%

When IRR is concerned, Project - Y is beneficial than Project - X but both are feasible as the IRR is more than the minimum expected return.

D. If only one project can be selected, then this becomes the case of mutually exclusive projects. In this case, NPV favours Project X and IRR favors Project Y as the respective projects hold good in those measures. In this conflict, we always consider the project with higher NPV as it theoritically sounds good. In such a situation, one should go with Project X.


Related Solutions

Present value of an Annuity of $1 in Arrears ? Periods 4% 6% 8% 10% 12%...
Present value of an Annuity of $1 in Arrears ? Periods 4% 6% 8% 10% 12% 14% 1 0.962 0.943 0.926 0.909 0.893 0.877 2 1.886 1.833 1.783 1.736 1.690 1.647 3 2.775 2.673 2.577 2.487 2.402 2.322 4 3.630 3.465 3.312 3.170 3.037 2.914 5 4.452 4.212 3.993 3.791 3.605 4.433 6 5.242 4.917 4.623 4.355 4.111 3.889 7 6.002 5.582 5.206 4.868 4.564 4.288 8 6.733 6.210 5.747 5.335 4.968 4.639 9 7.435 6.802 6.247 5.759 5.328 4.946...
Figure 14-10. Present value of $1 Periods 4% 6% 8% 10% 12% 14% 1 0.962 0.943...
Figure 14-10. Present value of $1 Periods 4% 6% 8% 10% 12% 14% 1 0.962 0.943 0.926 0.909 0.893 0.877 2 0.925 0.890 0.857 0.826 0.797 0.769 3 0.889 0.840 0.794 0.751 0.712 0.675 4 0.855 0.792 0.735 0.683 0.636 0.592 5 0.822 0.747 0.681 0.621 0.567 0.519 6 0.790 0.705 0.630 0.564 0.507 0.456 7 0.760 0.665 0.583 0.513 0.452 0.400 8 0.731 0.627 0.540 0.467 0.404 0.351 9 0.703 0.592 0.500 0.424 0.361 0.308 10 0.676 0.558 0.463...
Present value of $1 Periods 4% 6% 8% 10% 12% 14% 1 0.96154 0.94340 0.92593 0.90909...
Present value of $1 Periods 4% 6% 8% 10% 12% 14% 1 0.96154 0.94340 0.92593 0.90909 0.89286 0.87719 2 0.92456 0.89000 0.85734 0.82645 0.79719 0.76947 3 0.88900 0.83962 0.79383 0.75131 0.71178 0.67497 4 0.85480 0.79209 0.73503 0.68301 0.63552 0.59208 5 0.82193 0.74726 0.68058 0.62092 0.56743 0.51937 6 0.79031 0.70496 0.63017 0.56447 0.50663 0.45559 7 0.75992 0.66506 0.58349 0.51316 0.45235 0.39964 8 0.73069 0.62741 0.54027 0.46651 0.40388 0.35056 9 0.70259 0.59190 0.50025 0.42410 0.36061 0.30751 10 0.67556 0.55839 0.46319 0.38554 0.32197...
Present Value of $1 at 5% for 5 periods .78353 Present Value of $1 at 6%...
Present Value of $1 at 5% for 5 periods .78353 Present Value of $1 at 6% for 5 periods .74726 Present value of $1 at 10% for 5 periods .62092 Present Value of $1 at 12% for 5 periods .56743 Present Value of $1 at 5% for 10 periods .61391 Present Value of $1 at 6% for 10 periods .55840 Present value of $1 at 10% for 10 periods .38554 Present Value of $1 at 12% for 10 periods .32197...
Periods ​1% ​2% ​3% ​4% ​5% ​6% ​7% ​8% ​9% ​10% ​12% ​14% ​15% ​16% ​18%...
Periods ​1% ​2% ​3% ​4% ​5% ​6% ​7% ​8% ​9% ​10% ​12% ​14% ​15% ​16% ​18% ​20% 1 0.990 0.980 0.971 0.962 0.952 0.943 0.935 0.926 0.917 0.909 0.893 0.877 0.870 0.862 0.847 0.833 2 0.980 0.961 0.943 0.925 0.907 0.890 0.873 0.857 0.842 0.826 0.797 0.769 0.756 0.743 0.718 0.694 3 0.971 0.942 0.915 0.889 0.864 0.840 0.816 0.794 0.772 0.751 0.712 0.675 0.658 0.641 0.609 0.579 4 0.961 0.924 0.888 0.855 0.823 0.792 0.763 0.735 0.708 0.683 0.636...
1 a) The present value of an annuity lasting 72 interest periods and paying $ 2,000...
1 a) The present value of an annuity lasting 72 interest periods and paying $ 2,000 at the beginning of each “k” interest periods is $ 9,538.60. Given that the effective interest rate per interest period is 3.6575%, find k. 1 b) Find an expression in terms of i(4) for the accumulated value at the end of the twenty-one years of an annuity that pays $ 400 at the beginning of each four-month period for 21 years. Your expression should...
Use the following table, Present Value of an Annuity of 1 Period 8% 9% 10% 1...
Use the following table, Present Value of an Annuity of 1 Period 8% 9% 10% 1 0.926 0.917 0.909 2 1.783 1.759 1.736 3 2.577 2.531 2.487 A company has a minimum required rate of return of 9%. It is considering investing in a project which costs $350000 and is expected to generate cash inflows of $150000 at the end of each year for three years. The net present value of this project is $379650. $75000. $37965. $29650.
Match No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14...
Match No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Player A 8 42 56 68 91 123 12 46 57 137 5 80 14 10 19 Player B 38 44 46 59 57 61 48 42 51 39 58 41 55 45 68 1. For the given data set representing the runs scored by two players in last 15 matches, conduct the following analysis: i. Which average you will use to summarize...
(a) What is the present value of $29,400 due 8 periods from now, discounted at 6%?...
(a) What is the present value of $29,400 due 8 periods from now, discounted at 6%? (Round answer to 2 decimal places, e.g. 25.25.) (b) What is the present value of $29,400 to be received at the end of each of 12 periods, discounted at 12%? (Round answer to 2 decimal places, e.g. 25.25.) ------------------ Ivanhoe Company is about to issue $298,700 of 6-year bonds paying an 11% interest rate, with interest payable semiannually. The discount rate for such securities...
Post Position 1 2 3 4 5 6 7 8 9 10 Wins 19 14 11...
Post Position 1 2 3 4 5 6 7 8 9 10 Wins 19 14 11 15 15 7 8 12 5 11 The table below lists the frequency of wins for different post positions in the Kentucky Derby horse race. Use a 0.05 significance level to test the claim that the likelihood of winning is the same for the different post positions. What is the critical value (the X2 value)? [Round to the nearest thousandths place]
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT