Net Present Value Method, Present Value Index, and AnalysisFirst United Bank Inc. is evaluating three capital investment projects using the net present value method. Relevant data related to the projects are summarized as follows:BranchComputerATMOfficeSystemKioskExpansionUpgradeExpansionAmount to be invested$863,421$519,486$311,214Annual net cash flows:Year 1358,000243,000165,000Year 2333,000219,000114,000Year 3304,000194,00083,000Present Value of $1 at Compound InterestYear6%10%12%15%20%0.9430.9090.8930.8700.83320.8900.8260.7970.7560.69430.8400.7510.7120.6580.57940.7920.6830.6360.5720.48250.7470.6210.5670.4970.4020.7050.5640.5070.4320.33570.6650.5130.4520.3760.27980.6270.4670.4040.3270.2330.5920.4240.3610.2840.194100.5580.3860.3220.2470.162 100.5580.3860.3220.2470.162Required:1. Assuming that the desired rate of return is 6%, prepare a net present value analysis for each proposal. Use the present value of $1 table above. If required, use the minus sign to indicate a negative net presentvalue. If required, round to the nearest dollar.Branch OfficeComputer SystemATM KioskExpansionUpgradeExpansionPresent value of net cash flow%24$totalAmount to be invested$$Net present value$2. Determinepresent value index for each proposal. If required, round your answers to two decimal places.Present Value IndexBranch Office ExpansionComputer System UpgradeInstall Internet Bill-Pay3. Which proposal offers the largest amount of present value per dollar of investment?

Net present value (NPV) is the difference between the present value of cash inflows and the present…

value. If required, round to the nearest dollar. Branch Office Computer System ATM Kiosk Expansion Upgrade Expansion Present value of net cash flow total Amount to be invested %$4 $ Net present value 2. Determine a present value index for each proposal. If required, round your answers to two decimal places. Present Value Index Branch Office Expansion Computer System Upgrade Install Internet Bill-Pay

value. If required, round to the nearest dollar. Branch Office Computer System ATM Kiosk Expansion Upgrade Expansion Present value of net cash flow total Amount to be invested %$4 $ Net present value 2. Determine a present value index for each proposal. If required, round your answers to two decimal places. Present Value Index Branch Office Expansion Computer System Upgrade Install Internet Bill-Pay

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter15: Capital Investment Analysis

Section: Chapter Questions

Problem 15.3.3P

See similar textbooks

Similar questions

Net Present Value Method, Present Value Index, and Analysis First United Bank Inc. is evaluating three capital investment projects using the net present value method. Relevant data related to the projects are summarized as follows: BranchOfficeExpansion ComputerSystemUpgrade ATMKioskExpansion Amount to be invested $787,317 $584,976 $298,035 Annual net cash flows: Year 1 391,000 278,000 164,000 Year 2 364,000 250,000 113,000 Year 3 332,000 222,000 82,000 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 Required: 1. Assuming that the desired rate of return is 10%,…
Average Rate of Return Method, Net Present Value Method, and Analysis 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 fromOperations Net CashFlow Income fromOperations Net CashFlow 1 $34,200 $104,000 $72,000 $166,000 2 34,200 104,000 55,000 140,000 3 34,200 104,000 27,000 99,000 4 34,200 104,000 12,000 68,000 5 34,200 104,000 5,000 47,000 Total $171,000 $520,000 $171,000 $520,000 Each project requires an investment of $360,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…
First United Bank Inc. is evaluating three capital investment projects using the net present value method. Relevant data related to the projects are summarized as follows: BranchOfficeExpansion ComputerSystemUpgrade ATMKioskExpansion Amount to be invested $686,053 $516,654 $295,458 Annual net cash flows: Year 1 411,000 288,000 177,000 Year 2 382,000 259,000 122,000 Year 3 349,000 230,000 89,000 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 Required: 1. Assuming that the desired rate of return is 20%, prepare a net present value analysis for each project. Use the…
Average Rate of Return Method, Net Present Value Method, and Analysis 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 fromOperations Net CashFlow Income fromOperations Net CashFlow 1 $50,400 $162,000 $106,000 $259,000 2 50,400 162,000 81,000 219,000 3 50,400 162,000 40,000 154,000 4 50,400 162,000 18,000 105,000 5 50,400 162,000 7,000 73,000 Total $252,000 $810,000 $252,000 $810,000 Each project requires an investment of $560,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…
sent value index Tasty Doughnuts has computed the net present value for capital expenditure at two locations. Relevant data related to the computation are as follows: Total present value of net cash flow Amount to be invested Net present value Des Moines Cedar Rapids $192,610 $214,080 (187,000) $5,610 (223,000) $(8,920) a. Determine the present value index for each proposal. Round your answers for the present value index to two decimal places. Total present value of net cash flow Amount to be invested Des Moines Cedar Rapids Present value index b. Which location does your analysis support? (If both present value indexes are the same, either location will grade as correct.) , because the net present value index is 1.
Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: MaintenanceEquipment RampFacilities ComputerNetwork Amount to be invested $923,468 $584,381 $269,896 Annual net cash flows: Year 1 400,000 292,000 168,000 Year 2 372,000 263,000 116,000 Year 3 340,000 234,000 84,000 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 Required: 1. Assuming that the desired rate of return is 12%, prepare a net present value analysis for each proposal. Use…
Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: MaintenanceEquipment RampFacilities ComputerNetwork Amount to be invested $614,361 $418,741 $186,316 Annual net cash flows: Year 1 318,000 229,000 134,000 Year 2 296,000 206,000 92,000 Year 3 270,000 183,000 67,000 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 Required: 1. Assuming that the desired rate of return is 20%, prepare a net present value analysis for each proposal. Use…
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 fromOperations Net CashFlow Income fromOperations Net CashFlow 1 $62,000 $200,000 $130,000 $320,000 2 62,000 200,000 99,000 270,000 3 62,000 200,000 50,000 190,000 4 62,000 200,000 22,000 130,000 5 62,000 200,000 9,000 90,000 Total $310,000 $1,000,000 $310,000 $1,000,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 15% 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…
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: MaintenanceEquipment RampFacilities ComputerNetwork Amount to be invested $898,519 $578,342 $279,983 Annual net cash flows: Year 1 389,000 276,000 171,000 Year 2 362,000 248,000 118,000 Year 3 331,000 221,000 86,000 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 Required: 1. Assuming that the desired…
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: MaintenanceEquipment RampFacilities ComputerNetwork Amount to be invested $909,173 $541,268 $278,555 Annual net cash flows: Year 1 405,000 284,000 178,000 Year 2 377,000 256,000 123,000 Year 3 344,000 227,000 89,000 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 Required: 1. Assuming that the desired…
Information on four investment proposals is given below:Investment ProposalA B C DInvestment required ........................ $(90,000) $(100,000) $(70,000) $(120,000)Present value of cash inflows ......... 126,000 138,000 105,000 160,000Net present value ............................ $ 36,000 $ 38,000 $ 35,000 $ 40,000Life of the project ............................ 5 years 7 years 6 years 6 yearsRequired:1. Compute the project profitability index for each investment proposal.2. Rank the proposals in terms of preference.
Average Rate of Return Method, Net Present Value Method, and Analysis The capital investment committee of Overnight Express Inc. is considering two investment projects. The estimated income from operations and net cash flows from each investment are as follows: Distribution Center Expansion Internet Tracking Technology Year Income fromOperations NetCash Flow Income fromOperations NetCash Flow 1 $55,000 $175,000 $116,000 $280,000 2 55,000 175,000 88,000 236,000 3 55,000 175,000 44,000 166,000 4 55,000 175,000 19,000 114,000 5 55,000 175,000 8,000 79,000 Total $275,000 $875,000 $275,000 $875,000 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…