Concept explainers
Concept Introduction:
NPV:
To Calculate:
The Net Present Value for each project
Answer to Problem 15.4.1P
The Net Present value for each project for each project is as follows:
Net Present Value | |
Radio Station | $ 176,325 |
TV Station | $ 148,809 |
Explanation of Solution
The Net Present value for each project is calculated as follows:
Radio Station | Amount | PVF (10%) | PV |
A | B | =A*B | |
Annual Net Cash Flows | |||
Year 1 | $ 560,000 | 0.90909 | $ 509,091 |
Year 2 | $ 560,000 | 0.82645 | $ 462,810 |
Year 3 | $ 560,000 | 0.75131 | $ 420,736 |
Year 4 | $ 560,000 | 0.68301 | $ 382,488 |
Present Value of | $ 1,775,125 | ||
Investment (B) | $ 1,598,800 | 1.00000 | $ 1,598,800 |
Net Present Value (A-B) | $ 176,325 | ||
TV Station | Amount | PVF (20%) | PV |
A | B | =A*B | |
Annual Net Cash Flows | |||
Year 1 | $ 1,120,000 | 0.90909 | $ 1,018,182 |
Year 2 | $ 1,120,000 | 0.82645 | $ 925,620 |
Year 3 | $ 1,120,000 | 0.75131 | $ 841,473 |
Year 4 | $ 1,120,000 | 0.68301 | $ 764,975 |
Present Value of Cash Inflow (A) | $ 3,550,249 | ||
Investment (B) | $ 3,401,440 | 1.00000 | $ 3,401,440 |
Net Present Value (A-B) | $ 148,809 |
Concept Introduction:
NPV:
Net present value (NPV) is the method to evaluate the project feasibility. This method calculates the present value of cash inflows and outflows, and then calculates the net present value of the investment. A project should be accepted if it has a positive NPV. The formula to calculate the NPV is as follows:
To Calculate:
The Present Value Index for each project
Answer to Problem 15.4.1P
The Present Value Index for each project is as follows:
Present Value Index | |
Radio Station | 1.11 |
TV Station | 1.04 |
Explanation of Solution
The Present Value Index for each project is calculated as follows:
Radio Station | Amount | PVF (10%) | PV |
A | B | =A*B | |
Annual Net Cash Flows | |||
Year 1 | $ 560,000 | 0.90909 | $ 509,091 |
Year 2 | $ 560,000 | 0.82645 | $ 462,810 |
Year 3 | $ 560,000 | 0.75131 | $ 420,736 |
Year 4 | $ 560,000 | 0.68301 | $ 382,488 |
Present Value of Cash Inflow (A) | $ 1,775,125 | ||
Investment (B) | $ 1,598,800 | 1.00000 | $ 1,598,800 |
Present Value Index (A/B) | 1.11 | ||
TV Station | Amount | PVF (20%) | PV |
A | B | =A*B | |
Annual Net Cash Flows | |||
Year 1 | $ 1,120,000 | 0.90909 | $ 1,018,182 |
Year 2 | $ 1,120,000 | 0.82645 | $ 925,620 |
Year 3 | $ 1,120,000 | 0.75131 | $ 841,473 |
Year 4 | $ 1,120,000 | 0.68301 | $ 764,975 |
Present Value of Cash Inflow (A) | $ 3,550,249 | ||
Investment (B) | $ 3,401,440 | 1.00000 | $ 3,401,440 |
Present Value Index (A/B) | 1.04 |
Want to see more full solutions like this?
Chapter 15 Solutions
CengageNOWv2, 1 term Printed Access Card for Warren's Survey of Accounting, 8th
- Net present value method, internal rate of return method, and analysis for a service company The management of Advanced Alternative Power Inc. is considering two capital investment projects. The estimated net cash flows from each project are as follows: The wind turbines require an investment of 887,600, while the biofuel equipment requires an investment of 911,100. No residual value is expected from either project. Instructions 1. Compute the following for each project: A. The net present value. Use a rate of 6% and the present value of an annuity table appearing in Exhibit 5 of this chapter. B. A present value index. (Round to two decimal places.) 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 table appearing in Exhibit 5 of this chapter. 3. What advantage does the internal rate of return method have over the net present value method in comparing projects?arrow_forwardAverage rate of return method, net present value method, and analysis for a service company The capital investment committee of Arches Landscaping Company is considering two capital investments. The estimated operating income and net cash flows from each investment are as follows: Each project requires an investment of 75,000. Straight-line depreciation will be used, and no residual value is expected. The committee has selected a rate of 12% for purposes of the net present value analysis. Instructions 1. Compute the following: A. The average rate of return for each investment. B. The net present value for each investment. Use the present value table appearing in Exhibit 2 of this chapter. (Round present values to the nearest dollar.) 2. Prepare a brief report for the capital investment committee, advising it on the relative merits of the two investments.arrow_forwardNet present value method, present value index, and analysis for a service company First United Bank Inc. is evaluating three capital investment projects by using the net present value method. Relevant data related to the projects are summarized as follows: Instructions 1. Assuming that the desired rate of return is 15%, prepare a net present value analysis for each project. Use the present value table appearing in Exhibit 2 of this chapter. 2. Determine a present value index for each project. (Round to two decimal places.) 3. Which project offers the largest amount of present value per dollar of investment? Explain.arrow_forward
- Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year for 5 years. Project L costs $25,000 and is expected to produce cash flows of $7,400 per year for 5 years. Calculate the two projects’ NPVs, IRRs, MIRRs, and PIs, assuming a cost of capital of 12%. Which project would be selected, assuming they are mutually exclusive, using each ranking method? Which should actually be selected?arrow_forwardThere are two projects under consideration by the Rainbow factory. Each of the projects will require an initial investment of $35,000 and is expected to generate the following cash flows: Use the information from the previous exercise to calculate the internal rate of return on both projects and make a recommendation on which one to accept. For further instructions on internal rate of return in Excel, see Appendix C.arrow_forwardA company is considering three alternative investment projects with different net cash flows. The present value of net cash flows is calculated using Excel and the results follow. Potential Projects Present value of net cash flows (excluding initial investment) Initial investment Project A $ 11,226 (10,000) Project B $ 10,568 (10,000) a. Compute the net present value of each project. b. If the company accepts all positive net present value projects, which of these will it accept? c. If the company can choose only one project, which will it choose on the basis of net present value? Complete this question by entering your answers in the tabs below. Required A Required B Required C Compute the net present value of each project. Potential Projects Project A Project B Project C Present value of net cash flows Initial investment Net present value $ $ $arrow_forward
- The management of Winstead Corporation is considering the following three investment projects (Ignore income taxes.): Project Q Project R Project S Investment required $ 57,200 $ 97,200 $ 176,000 Present value of cash inflows $ 62,092 $ 111,792 $ 193,320 The only cash outflows are the initial investments in the projects. Required: Rank the investment projects using the project profitability index.arrow_forwardAverage Rate of Return Method, Net Present Value Method, and Analysis for a service company The capital investment committee of Arches Landscaping Company is considering two capital investments. The estimated operating income and net cash flows from each investment are as follows: Front-End Loader Year 1 2 3 4 5 Total Year 1 2 3 4 5 6 7 8 9 10 Required: Operating Income $62,000 62,000 62,000 62,000 62,000 $310,000 Each project requires an investment of $620,000. Straight-line depreciation.will be used, and no residual value is expected. The committee has selected a rate of 10% for purposes of the net present value analysis. Present Value of $1 at Compound Interest 6% 10% 15% 0.943 0.909 0.870 0.890 0.826 0.756 0.840 0.751 0.658 0.792 0.683 0.636 0.572 0.747 0.621 0.567 0.497 0.705 0.564 0.507 0.432 0.665 0.513 0.452 0.376 0.627 0.467 0.404 0.327 0.592 0.361 0.284 0.558 0.322 0.247 Front-End Loader Greenhouse 0.424 Net Cash Flow $187,000 187,000 187,000 0.386 187,000 187,000 $935,000…arrow_forwardNet present value method, internal rate of return method, and analysis for a service company The management of Advanced Alternative Power Inc. is considering two capital investment projects. The estimated net cash flows from each project are as follows: Year Wind Turbines Biofuel Equipment 1 $230,000 $410,000 2 230,000 410,000 3 230,000 410,000 4 230,000 410,000 The wind turbines require an investment of $698,510, while the biofuel equipment requires an investment of $1,170,550. No residual value is expected from either project. 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.353 2.991 6 4.917 4.355 4.111 3.785 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 Required: 1a. Compute the net present value for each project. Use a rate of…arrow_forward
- Net Present Value Method, Internal Rate of Return Method, and Analysis for a Service Company The management of Advanced Alternative Power Inc. is considering two capital investment projects. The estimated net cash flows from each project are as follows: Year Wind Turbines Biofuel Equipment 1 $410,000 $860,000 2 410,000 860,000 3 410,000 860,000 4 410,000 860,000 The wind turbines require an investment of $1,061,490, while the biofuel equipment requires an investment of $2,455,300. No residual value is expected from either project. 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.353 2.991 6 4.917 4.355 4.111 3.785 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…arrow_forwardA company is considering three alternative investment projects with different net cash flows. The present value of net cash flows is calculated using Excel and the results follow. Potential Projects Present value of net cash flows (excluding initial investment) Initial investment Project A $ 8,328 (10,000) Project B $ 10,809 (10,000) Project C $ 10,685 (10,000) a. Compute the net present value of each project. b. If the company accepts all positive net present value projects, which of these will it accept? c. If the company can choose only one project, which will it choose on the basis of net present value? Complete this question by entering your answers in the tabs below. Required A Required B Required C Compute the net present value of each project. Potential Projects Project A Project B Project C Present value of net cash flows Initial investment Net present valuearrow_forwardManagerial Accounting (Please help ASAP. Solutions only. Rate will be given) ABC Corporation is considering the following three investment projects: Project P Project Q Project R Investment required 15,000 50,000 71,000 Present Value of Cash Inflows 15,150 54,500 75,970 The only cash outflows are the initial investements in the projects. a. Determine the Project Profitability Index of Project P? b. Determine the Project Profitability Index of Project Q? c. Determine the Project Profitability Index of Project R?arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeIntermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning