Question

In: Accounting

The management of Quest Media Inc. is considering two capital investment projects. The estimated net cash...

The management of Quest Media Inc. is considering two capital investment projects. The estimated net cash flows from each project are as follows:

Year Radio Station TV Station
1 $340,000 $610,000
2 340,000 610,000
3 340,000 610,000
4 340,000 610,000
Present Value of an Annuity of $1 at Compound Interest
Year 6% 10% 12% 15% 20%
1 0.943 0.909 0.893 0.870 0.833
2 1.833 1.736 1.690 1.626 1.528
3 2.673 2.487 2.402 2.283 2.106
4 3.465 3.170 3.037 2.855 2.589
5 4.212 3.791 3.605 3.352 2.991
6 4.917 4.355 4.111 3.784 3.326
7 5.582 4.868 4.564 4.160 3.605
8 6.210 5.335 4.968 4.487 3.837
9 6.802 5.759 5.328 4.772 4.031
10 7.360 6.145 5.650 5.019 4.192

The radio station requires an investment of $970,700, while the TV station requires an investment of $1,579,290. No residual value is expected from either project.

Required:

1a. Compute the net present value for each project. Use a rate of 10% and the present value of an annuity of $1 in the table above. If required, use the minus sign to indicate a negative net present value. If required, round to the nearest whole dollar.

Radio Station TV Station
Present value of annual net cash flows $ $
Less amount to be invested $ $
Net present value $ $

1b. Compute a present value index for each project. If required, round your answers to two decimal places.

Present Value Index
Radio Station
TV Station

2. Determine the internal rate of return for each project by (a) computing a present value factor for an annuity of $1 and (b) using the present value of an annuity of $1 in the table above. If required, round your present value factor answers to three decimal places and internal rate of return to the nearest whole percent.

Radio Station TV Station
Present value factor for an annuity of $1
Internal rate of return % %

3. The net present value, present value index, and internal rate of return all indicate that the   is a better financial opportunity compared to the  , although both investments meet the minimum return criterion of 10%.

Solutions

Expert Solution

1a)
Radio Station TV Station
Present value of Annual Net Cash flows
        = Annual net cash flow x PVAF (10%, 4 Years)
$ 1,077,800
( $ 340,000 x 3.170 )
$ 1,933,700
( $ 610,000 x 3.170 )
Less: Amount to be invested ( $ 970,700 ) ($ 1,579,290 )
Net present value $ 107,100 $ 354,410
1b)
Radio Station TV Station
Present Value index
       = Present value of Annual Net Cash flows / Amount invested
1.11
( $ 1,077,800 / $ 970,700 )
1.22
( $ 1,933,700 / $ 1,579,290)
2)
Radio Stattion TV Station
Internal rate of Return Factor
        = Amount invested / Annual Cash Flows
2.855
( $ 970,700 / $ 340,000 )
2.589
( $ 1,579,290 / $ 610,000 )
From Present value of Anuuity $ 1 table,
IRR for 4 Years
15% 20%
3)
The net present value, present value index, and internal rate of return all indicate that the TV Station is a better financial opportunity compared to the Radio station, although both investments meet the minimum return criterion of 10%.

Related Solutions

The management of Quest Media Inc. is considering two capital investment projects. The estimated net cash...
The management of Quest Media Inc. is considering two capital investment projects. The estimated net cash flows from each project are as follows: Year Radio Station TV Station 1 $170,000 $310,000 2 170,000 310,000 3 170,000 310,000 4 170,000 310,000 Present Value of an Annuity of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 1.833 1.736 1.690 1.626 1.528 3 2.673 2.487 2.402 2.283 2.106 4 3.465 3.170 3.037 2.855 2.589...
The management of Quest Media Inc. is considering two capital investment projects. The estimated net cash...
The management of Quest Media Inc. is considering two capital investment projects. The estimated net cash flows from each project are as follows: Year Radio Station TV Station 1 $220,000 $460,000 2 220,000 460,000 3 220,000 460,000 4 220,000 460,000 Present Value of an Annuity of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 1.833 1.736 1.690 1.626 1.528 3 2.673 2.487 2.402 2.283 2.106 4 3.465 3.170 3.037 2.855 2.589...
The management of Quest Media Inc. is considering two capital investment projects. The estimated net cash...
The management of Quest Media Inc. is considering two capital investment projects. The estimated net cash flows from each project are as follows: Year Radio Station TV Station 1 $290,000 $610,000 2 290,000 610,000 3 290,000 610,000 4 290,000 610,000 Present Value of an Annuity of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 1.833 1.736 1.690 1.626 1.528 3 2.673 2.487 2.402 2.283 2.106 4 3.465 3.170 3.037 2.855 2.589...
Capital Investment Appraisal Techniques X construction is considering two projects to develop. The estimated net cash...
Capital Investment Appraisal Techniques X construction is considering two projects to develop. The estimated net cash flow from each project is as follows: Project X Project Y Year 1 110,000 75,000 Year 2 65,000 150,000 Year 3 100,000 60,000 Year 4 115,000 55,000 Year 5 35,000 60,000 Project requires an investment of $200,000. A rate of 15% has been selected for the NPV analysis. Requires to a) Calculate Payback period, ARR, Net Present Value and Profitability Index b) Which Project...
Elite Apparel Inc. is considering two investment projects. The estimated net cash flows from each project...
Elite Apparel Inc. is considering two investment projects. The estimated net cash flows from each project are as follows: Year Plant Expansion Retail Store Expansion 1 $142,000 $119,000 2 117,000 140,000 3 101,000 96,000 4 91,000 67,000 5 28,000 57,000 Total $479,000 $479,000 Each project requires an investment of $259,000. A rate of 20% has been selected for the net present value analysis. Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893...
Elite Apparel Inc. is considering two investment projects. The estimated net cash flows from each project...
Elite Apparel Inc. is considering two investment projects. The estimated net cash flows from each project are as follows: Year Plant Expansion Retail Store Expansion 1 $105,000 $88,000 2 86,000 103,000 3 74,000 71,000 4 67,000 49,000 5 21,000 42,000 Total $353,000 $353,000 Each project requires an investment of $191,000. A rate of 6% has been selected for the net present value analysis. Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893...
Elite Apparel Inc. is considering two investment projects. The estimated net cash flows from each project...
Elite Apparel Inc. is considering two investment projects. The estimated net cash flows from each project are as follows: Year Plant Expansion Retail Store Expansion 1 $129,000 $108,000 2 106,000 127,000 3 91,000 87,000 4 83,000 61,000 5 26,000 52,000 Total $435,000 $435,000 Each project requires an investment of $235,000. A rate of 10% has been selected for the net present value analysis. Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893...
Elite Apparel Inc. is considering two investment projects. The estimated net cash flows from each project...
Elite Apparel Inc. is considering two investment projects. The estimated net cash flows from each project are as follows: Year Plant Expansion Retail Store Expansion 1 $102,000 $85,000 2 83,000 100,000 3 72,000 68,000 4 65,000 48,000 5 20,000 41,000 Total $342,000 $342,000 Each project requires an investment of $185,000. A rate of 10% has been selected for the net present value analysis. Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893...
Elite Apparel Inc. is considering two investment projects. The estimated net cash flows from each project...
Elite Apparel Inc. is considering two investment projects. The estimated net cash flows from each project are as follows: Year Plant Expansion Retail Store Expansion 1 $151,000 $127,000 2 124,000 148,000 3 107,000 102,000 4 97,000 71,000 5 30,000 61,000 Total $509,000 $509,000 Each project requires an investment of $275,000. A rate of 12% has been selected for the net present value analysis. Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893...
The capital investment committee of Ellis Transport and Storage Inc. is considering two investment projects. The...
The capital investment committee of Ellis Transport and Storage Inc. is considering two investment projects. The estimated income from operations and net cash flows from each investment are as follows: Warehouse Tracking Technology Year Income from Operations Net Cash Flow Income from Operations Net Cash Flow 1 $49,300 $162,000 $104,000 $259,000 2 49,300 162,000 79,000 219,000 3 49,300 162,000 39,000 154,000 4 49,300 162,000 17,000 105,000 5 49,300 162,000 7,500 73,000 Total $246,500 $810,000 $246,500 $810,000 Each project requires an...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT