The investment committee of Sentry Insurance Co. is evaluating two projects, office expansion and upgrade to computer servers. The projects have different useful lives, but each requires an investment of $838,000. The estimated net
Net Cash Flow | ||
Year | Office Expansion | Server |
1 | $234,000 | $309,000 |
2 | 234,000 | 309,000 |
3 | 234,000 | 309,000 |
4 | 234,000 | 309,000 |
5 | 234,000 | |
6 | 234,000 |
The committee has selected a rate of 15% for purposes of
Present Value of $1 at Compound Interest | |||||
Year | 6% | 10% | 12% | 15% | 20% |
1 | 0.943 | 0.909 | 0.893 | 0.870 | 0.833 |
2 | 0.890 | 0.826 | 0.797 | 0.756 | 0.694 |
3 | 0.840 | 0.751 | 0.712 | 0.658 | 0.579 |
4 | 0.792 | 0.683 | 0.636 | 0.572 | 0.482 |
5 | 0.747 | 0.621 | 0.567 | 0.497 | 0.402 |
6 | 0.705 | 0.564 | 0.507 | 0.432 | 0.335 |
7 | 0.665 | 0.513 | 0.452 | 0.376 | 0.279 |
8 | 0.627 | 0.467 | 0.404 | 0.327 | 0.233 |
9 | 0.592 | 0.424 | 0.361 | 0.284 | 0.194 |
10 | 0.558 | 0.386 | 0.322 | 0.247 | 0.162 |
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 |
Required:
If required, use the minus sign to indicate a negative net present value.
For each project, compute the net present value, assuming that the office expansion is adjusted to a four-year life for purposes of analysis. Use the present value of $1 table above.
Office Expansion | Server Upgrade | |
Present value of net cash flow total | $ ? | $ ? |
Less amount to be invested | $ ? | $ ? |
Net present value | $ ? | $ ? |
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
- 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 Greenhouse Operating Net Cash Operating Net Cash Year Income Flow Income Flow $ 40,000 $11,250 $ 26,250 1 $25,000 2 20,000 35,000 11,250 26,250 3 7,000 22,000 11,250 26,250 4 3,000 18,000 11,250 26,250 5 1,250 16,250 11,250 26,250 Total $56,250 $131,250 $56,250 $131,250 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. Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683 0.636 0.572 0.482 0.747 0.621 0.567 0.497 0.402 6 0.705 0.564 0.507 0.432 0.335 0.665 0.513 0.452 0.376 0.279 0.627 0.467 0.404 0.327…arrow_forwardFollowing is information on two alternative investments. Beachside Resort is considering building a new pool or spa. The company requires a 10% return from its investments. Initial investment Net cash flows in: Year 1 40,000 Year 2 56,000 Year 3 80,295 Year 4 90,400 Year 5 65,000 Compute the internal rate of return for each of the projects using excel functions. (Round your answers to 2 decimal places.) Pool Spa IRR Pool Spa $ (160,000) $ (105,000) % % 32,000 50,000 66,000 72,000 24,000arrow_forwardThe City of Vancouver has appointed you as an Assistant Project Manager to oversee the aspect of some upcoming projects. The Project Manager is requesting you to conduct a discounted cash flow calculation to determine the NPV of one of the projects which is part of the municipality’s cultural tourism initiatives. The project is expected to generate a net cash flow of $100,000.00, $200,000.00, $300,000.00, $350,000.00 and $450,000,00 in the next five years. The project will cost $1,500,000.00 to implement and the required rate of return is 25 percent. Calculate the Net Present Value of the project to enable the Project Management to communicate the viability or otherwise to the Municipality’s Project Council.arrow_forward
- The dean of the School of Fine Arts is trying to decide whether to purchase a copy machine to place in the lobby of the building. The machine would add to student convenience, but the dean feels compelled to earn an 8 percent return on the investment of funds. Estimates of cash inflows from copy machines that have been placed in other university buildings indicate that the copy machine would probably produce incremental cash inflows of approximately $25,000 per year. The machine is expected to have a three-year useful life with a zero salvage value. (Use appropriate factor(s) from the tables provided.) Required a. Use Present Value Appendix PV of $1, to determine the maximum amount of cash the dean should be willing to pay for a copy machine. (Round your intermediate calculations and final answer to 2 decimal places.) b. Use Present Value Appendix PVA of $1, to determine the maximum amount of cash the dean should be willing to pay for a copy machine. (Round your final answer to 2…arrow_forwardThe dean of the School of Fine Arts is trying to decide whether to purchase a copy machine to place in the lobby of the building. The machine would add to student convenience, but the dean feels compelled to earn an 10 percent return on the investment of funds. Estimates of cash inflows from copy machines that have been placed in other university buildings indicate that the copy machine would probably produce incremental cash inflows of approximately $19,000 per year. The machine is expected to have a three-year useful life with a zero salvage value. (Use appropriate factor(s) from the tables provided.) Required a. Use Present Value Appendix PV of $1, to determine the maximum amount of cash the dean should be willing to pay for a copy machine. (Round your intermediate calculations and final answer to 2 decimal places.) b. Use Present Value Appendix PVA of $1, to determine the maximum amount of cash the dean should be willing to pay for a copy machine. (Round your final answer to 2…arrow_forwardA company is intending to invest in a capital budgeting project to manufacture a medical testing device and has projected the following sales: Year 1 Year 2 Year 3 Year 4 Year 5 50,000 66,400 81,200 68,500 54,500 The installed cost of the new assets will be $18,500,000 which will be depreciated using the 7-year MACRS schedule. The assets will have a salvage value of $3,700,000. Initial NWC requirements are $1,500,000 and additional working capital needs are estimated to be 15% of the projected sales increases for the following year. Total fixed costs are $2,000,000 per year. The medical device has a selling price of $300 per unit and variable production costs are $175. The firm has a marginal tax rate of 35% and a required rate of return of 18%. Analyze this project and give your recommendation as to whether they should invest in it or…arrow_forward
- Bridgeport Company has hired a consultant to propose a way to increase the company's revenues. The consultant has evaluated two mutually exclusive projects with the following information provided for each: Capital investment Annual cash flows Estimated useful life Project Turtle $1,125,000 184,000 10 years Project Snake $645,000 109,000 10 years Bridgeport Company uses a discount rate of 9% to evaluate both projects.arrow_forwardThe capital investment committee of Taiwan Semiconductor Company is considering two capital investments. The estimated income from operations and net cash flows from each investment are as follows: Lithography Machine Photoresist Machine Year Income from Operations Net Cash Flow Income from Operations Net Cash Flows 1 $26,000 $41,000 $12,250 $25,250 2 21,000 35,000 12,250 25,250 3 7,000 22,500 12,250 25,250 4 4,000 18,000 12,250 25,250 5 1,450 16,150 12,250 25,250 Total $59,450 $132,650 $61,250 $126,250 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. Compute the following: The average rate of return for each investment. The net present value for each investment. Use the present value of $1 table appearing in this…arrow_forwardplease answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)arrow_forward
- Please see attachedarrow_forwardKeone Products Company is considering an investment in one of two new product lines. The investment required for either product line is $750,000. The net cash flows associated with each product are as follows: Year Liquid Soap Body Lotion 1 $140,000 $ 125,000 2 150,000 125,000 3 160,000 125,000 4 150,000 125,000 5 150,000 125,000 6 100,000 125,000 7 80,000 125,000 8 70,000 125,000 Total $1,000,000 $1,000,000 a. Recommend a product offering to Keone Products Company, based on the cash payback period for each product line. Line Item Description Year Payback period for liquid soap Payback period for body lotion b. The project with the net cash flows in the early years of the project life will be favored over the one with the net cash flows in the initial years..arrow_forwardProvidence Health is evaluating two different linen supply vendors systems for handling facility linen replacement. There are no incremental revenues attached to the projects, so the decision will be made on the basis of the present value of costs. Providence's weighted average cost of capital is 6.25%. Here are the net cash flow estimates in thousands of dollars: Year 0 1 2 3 4 5 System X System Y S (1,800) $ (3,850) S (1,000) S (500) (1,000) S (500) S S (1,000) S S (1,000) S S (1,000) S (500) (500) (500) [a] Assume initially that the systems both have average risk. Which one should be chosen? [b] Assume that System Y is judged to have high risk. The organization accounts for differential risk by adjusting its corporate cost of capitalarrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education