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 $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
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 $827,950, while the TV station requires an investment of $1,852,570. 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 (radio station / TV station) is a better financial opportunity compared to the (radio station / TV station), although both investments meet the minimum return criterion of 10%.

Solutions

Expert Solution

1.a. Calculation of PV of Cash Inflow
Radio Station TV Station
Cash Inflow per year $290,000 $610,000
Annuity of $1 at 4 years for 10% 3.170 3.170
PV of annual net cash flows $919,300 $1,933,700
(290,000*3.170, 610,000*3.170)
Less: Amount Invested $827,950 $1,852,570
Net Present Value $91,350 $81,130
1.b PV Index or Profitability Index = PV of Cash Flows / Amount Invested
Radio Station TV Station
PV of annual net cash flows $919,300 $1,933,700
Amount Invested $827,950 $1,852,570
PV Index 1.1103 1.0438
2 At Internal rate of return(IRR) the NPV is 0, in other words the PV of net cash flows is equal to amount invested
So in this case we have to find out the rate at which the PV of cash inflow is equal to amount invested
Radio Station TV Station
Amount Invested $827,950 $1,852,570
PV factor for an annuity of $1 at 15% $290,000*2.855 = $827,950
IRR 15%
PV factor for an annuity of $1 at 12% $610,000*3.037 = $1,852,570
IRR 12%
3 Since the NPV, PV Index and IRR of Radio station is more then as compared to TV station, hence it is a better investment opportunity

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 $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...
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