-ollowlng Is Information on two alternative Investments belng considered by Jolee Company. The company requires a 10% return fromIts Investments.Project A$(196,000)Project B$(141, 000)Initial investmentExpected net cash flows in:Year 149,00065,00089,29541,00059,00075, 00075,00075,000Year 2Year 3Year 499,40074,000Year 5Compute the Internal rate of return for each of the projects using excel functlons. (Round your answers to 2 declmal places.)IRRProject A%Project B< Prev9 of 9NextLType here to searchF11F1F6F7F8F9F10F2F3F4F5F123124.78TYUPGKSCN MBEI

Project A Total inflows=49000+65000+89295+99400+74000=$376,695

FOlTowing is Informaion on two aiternative Investments belng considered by Jolee Company. The company requires a 10% return from ts Investments. Project A $(196,000) Project B $(141, 000) Initial investment Expected net cash flows in: Year 1 49,000 65,000 89, 295 99,400 74,000 41,000 Year 2 59,000 Year 3 75, 000 75,000 75, 000 Year 4 Year 5 Compute the Internal rate of return for each of the projects using excel functlons. (Round your answers to 2 declmal places.) IRR Project A Project B

FOlTowing is Informaion on two aiternative Investments belng considered by Jolee Company. The company requires a 10% return from ts Investments. Project A $(196,000) Project B $(141, 000) Initial investment Expected net cash flows in: Year 1 49,000 65,000 89, 295 99,400 74,000 41,000 Year 2 59,000 Year 3 75, 000 75,000 75, 000 Year 4 Year 5 Compute the Internal rate of return for each of the projects using excel functlons. (Round your answers to 2 declmal places.) IRR Project A Project B

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Following is information on two alternative investments being considered by Jolee Company. The company requires a 8% return from its investments. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Project A Project B Initial investment $ (180,325 ) $ (140,960 ) Expected net cash flows in: Year 1 49,000 33,000 Year 2 57,000 52,000 Year 3 78,295 67,000 Year 4 87,400 69,000 Year 5 70,000 35,000 a. For each alternative project compute the net present value.b. For each alternative project compute the profitability index. If the company can only select one project, which should it choose?
Following is information on two alternative investment projects being considered by Tiger Company. The company requires a 4% return from its investments. (PV of $1, FV of $1, PVA of $1, and FVA of $1) Note: Use appropriate factor(s) from the tables provided. Initial investment Project X1 $ (80,000) Project X2 $ (120,000) Net cash flows in: Year 1 25,000 60,000 Year 2 Year 3 35,500 50,000 60,500 40,000 a. Compute each project's net present value. b. Compute each project's profitability index. c. If the company can choose only one project, which should it choose on the basis of profitability index? Complete this question by entering your answers in the tabs below. Required A Required B Required C Compute each project's net present value. Net Cash Flows Present Value of Present Value of Net 1 at 4% Cash Flows Project X1 Year 1 $ 25,000 Year 2 35,500 Year 3 60,500 0.8890 Totals $ 121,000 $ 0 Initial investment (80,000) Net present value $ (80,000) Project X2 Year 1 Year 2 Year 3 Totals…
Case 1: Assume you are evaluating two mutually exclusive projects,the cash flows of which appear below, and that your company uses a cost of capital of 8 percent to evaluate projects such as these. Time Project A Cash Flow Project B Cash Flow 0 -$650 -$700 1 100 300 2 250 -200 3 250 550 4 200 200 5 100 80 a. Calculate the payback of Project A. b. Calculate the discounted payback of Project A. c. Calculate the IRR of Project A. d. Using the NPV method and assuming a cost of capital of 8 percent, which of these projects should be accepted?
Following is information on two alternative investments being considered by Jolee Company. The company requires a 8% return from its investments. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Project A $(171,325) Project B $(159,960) Initial investment Expected net cash flows in: 35,000 59,000 55,000 Year 1 54,000 45,000 87,295 81,400 65,000 Year 2 Year 3 73,000 20,000 Year 4 Year 5 a. For each alternative project compute the net present value. b. For each alternative project compute the profitability index. If the company can only select one project, which should it choose? Complete this question by entering your answers in the tabs below. Required A Required B For each alternative project compute the net present value.
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…
Annual cash inflows that will arise from two competing investment projects are given below: Year Investment A Investment B 1 $7,000 $ 10,000 2 8,000 3 9,000 4 10,000 $ 34,000 9,000 8,000 7,000 $ 34,000 The discount rate is 7%. Click here to view Exhibit 12B-1 and Exhibit 12B-2, to determine the appropriate discount factor(s) using tables. Required: Compute the present value of the cash inflows for each investment.
Consider the following projects: Cash Flows ($) Co -10,000 -20,000 Project D E Assume that the projects are mutually exclusive and that the opportunity cost of capital is 10%. a. Calculate the profitability index for each project. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Project D E Profitability Index C1 20,000 35,000 b-1. Calculate the profitability-index using the incremental cash flows. (Do not round intermediate calculations. Round your answer to 2 decimal places.) Profitability-index
Pls show proper steps correctly with explanation.
man.9
Please complete these charts
For the cash flows given below, find the ERR and evaluate the project when the external reinvestment rate is ε = 10% and MARR = 8%. EOY 0 1 23 2 3 4 5 Cash Flow -$10,000 -$2,000 $2,500 $4,000 $4,000 $4,000
Compute the internal rate of return for the cash flows of the following two projects. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) Year Project A 0 -$13,800 Project B -$ 11,400 1 5,400 2,900 2 6,200 8,500 3 5,000 4,600 Project A Project B % %