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 $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
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 $485,350, while the TV station requires an investment of $941,470. 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 538900 982700
Less amount to be invested 485350 941470
Net present value 53550 41230
1b
Present Value Index
Radio Station 1.11
TV Station 1.04
2
Radio Station TV Station
Present value factor for an annuity of $1 2.855 3.037
Internal rate of return 15% 12%
3
The net present value, present value index, and internal rate of return all indicate that the
Radio Station is a better financial opportunity compared to the TV station,
although both investments meet the minimum return criterion of 10%.
Workings:
Present value of annual net cash flows :
Radio Station = 170000*3.170 = 538900
TV Station = 310000*3.170 = 982700
Present Value Index:
Radio Station =538900/485350=1.11
TV Station =982700/941470 = 1.04
Present value factor for an annuity of $1 :
Radio Station =485350/170000=2.855
TV Station =941470 /310000 = 3.037

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 $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...
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...
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...
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 $50,400 $164,000 $106,000 $262,000 2 50,400 164,000 81,000 221,000 3 50,400 164,000 40,000 156,000 4 50,400 164,000 18,000 107,000 5 50,400 164,000 7,000 74,000 Total $252,000 $820,000 $252,000 $820,000 Each project requires an...
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 $44,000 $138,000 $92,000 $221,000 2 44,000 138,000 70,000 186,000 3 44,000 138,000 35,000 131,000 4 44,000 138,000 15,000 90,000 5 44,000 138,000 8,000 62,000 Total $220,000 $690,000 $220,000 $690,000 Each project requires an...
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 $36,100 $115,000 $76,000 $184,000 2 36,100 115,000 58,000 155,000 3 36,100 115,000 29,000 109,000 4 36,100 115,000 13,000 75,000 5 36,100 115,000 4,500 52,000 Total $180,500 $575,000 $180,500 $575,000 Each project requires an...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT