Following is information on two alternative investment projects being considered by Tiger Company. The company requires a 5%return from its investments.Initial investmentNet cash flows in:Year 1Year 2Year 3Project X2Project X1$ (112,000)$ (184,000)41,00084,00051,50076,50074,00064,000Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whethereach project is acceptable.Note: Round your answers to 2 decimal places.Project X1Project X2IRRAcceptable?% Yes% Yes

Step 1:Finding the rate of discount that will allow the present value of the total of the yearly…

Answered: Following is information on two…

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 7PA: There are two projects under consideration by the Rainbow factory. Each of the projects will require...

See similar textbooks

Similar questions

Fenton, Inc., has established a new strategic plan that calls for new capital investment. The company has a 9.8% required rate of return and an 8.3% cost of capital. Fenton currently has a return of 10% on its other investments. The proposed new investments have equal annual cash inflows expected. Management used a screening procedure of calculating a payback period for potential investments and annual cash flows, and the IRR for the 7 possible investments are displayed in image. Each investment has a 6-year expected useful life and no salvage value. A. Identify which project(s) is/are unacceptable and briefly state the conceptual justification as to why each of your choices is unacceptable. B. Assume Fenton has $330,000 available to spend. Which remaining projects should Fenton invest in and in what order? C. If Fenton was not limited to a spending amount, should they invest in all of the projects given the company is evaluated using return on investment?
There 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.
Following is information on two alternative investment projects being considered by Tiger Company. The company requires a 6% return from its investments. Project X1 Project X2 Initial investment $ (114,000) $ (188,000) Net cash flows in: Year 1 42,000 85,500 Year 2 52,500 75,500 Year 3 77,500 65,500 Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable. Note: Round your answers to 2 decimal places.
Following is information on two alternative investment projects being considered by Tiger Company. The company requires a 4% return from its investments. Initial investment Net cash flows in: Year 1 Year 2 Year 3 Project X1 Project X2 IRR 21.00 % 12.00 % Project X1 $ (90,000) Yes Yes 30,000 40,500 65,500 Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable. Note: Round your answers to 2 decimal places. Acceptable? Project X2 $ (140,000) 67,500 57,500 47,500
Following is information on two alternative investment projects being considered by Tiger Company. The company requires a 5% return from its investments. Project X1 Project X2 Initial investment $ (112,000) $ (184,000) Net cash flows in: Year 1 41,000 84,000 Year 2 51,500 74,000 Year 3 76,500 64,000 Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable. (Round your answers to 2 decimal places.)
Following is information on two alternative investment projects being considered by Tiger Company. The company requires a 4% return from its investments. Project X1 Project X2 Initial investment $ (120,000) $ (200,000) Net cash flows in: Year 1 45,000 90, 000 Year 2 55,500 80,000 Year 3 80,500 70,000 Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable.
Following Is Information on two alternative Investments belng considered by Tiger Co. The company requires a 4% return from Its Investments. Project X1 $(100,000) Project X2 $(160,800) Initial investment Expected net cash flows in: Year 1 35,000 45,500 70,500 75,000 65, 000 55,000 Year 2 Year 3 Compute the Internal rate of return for each of the projects using Excel functlons. Based on Internal rate of return, Indicate whether each project Is acceptable. (Round your answers to 2 declmal places.) IRR Acceptable? Project X1 Project X2 Mc Graw Hill Lducation Type here to search *+ F10 F11 AI F2 F7 F8 F9 F3 F4 F5 F6 F1 & 23 4 5 7 T G H. V N M C * 0O B
Below are four cases that you will have to solve using Excel spreadsheets. 1st case The company COMERCIAL SA has two investment alternatives that present the following information: PROJECT A B It is requested Initial investment. $25,000 $22,000 Cash flows year 1 1. Determine the internal rate of return. 2. Determine the present value. $7,000 $12,000 The discount rate for the project will be 10% and the MARR will be 20%. 3. Determine the recovery period. 4. Define which is the most viable project. Year 2 cash flows $15,000 $8,000 Year 3 cash flows $18,000 $12,000
Following is information on two alternative investment projects being considered by Tiger Company. The company requires a 7% return from its investments (PV of $1. EV of $1. PVA of $1, and EVA of $1) (Use appropriate factor(s) from the tables provided.) Initial investment Net cash flows in: Year 1 Year 2 Year 3 Required A Required B Project X1 Year 11 Year 2 Year 3 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? Totals Initial investment Net present value Complete this question by entering your answers in the tabs below. Project X2 Year 1 Year 2 Year 3 Totais Initial investment S Project X1 $ (116,000) Compute each project's net present value. (Round your final answers to the nearest dollar) Net Cash Flows Present Value of Net Cash Flows S 43,000 53,500 78,500 Required C O 0 Present Value of 1 at 7% Project X2 $ (192,000) $ 87,000 77,000…
Consider the cash flows for the following investment projects. Assume that MARR=12%/year. A B 0 -PhP 1,000 -PhP 1,000 - PhP2,000 1 900 600 900 2 500 500 900 3 100 500 900 4 50 100 900 Which project should be selected using incremental analysis (AW method)? ANSWERS: AWA = PhP Blank 1 AWB = PhP Blank 2 AWc = PhP Blank 3 %3D AW (B-A) = PhP BIlank 4 AW (C-B) = PhP Blank 5 Investment Blank 6 (use capital letter) is better.
Financial Manager of Timmy Company is considering two projects (project A and project H), which have cash flows as follows: Year Cash Flow of Project A (in $) Cash Flow of Project H (in $) 0 -100 -100 1 10 70 2 60 50 3 80 20 Timmy Company’s cost of capital is 10 percent. Calculate payback, NPV, IRR, and MIRR for both projects. (Please have a step by step format to your answer with explainations. Thanks (=)
Based on the following, obtain the Incremental Cash Flow and determine the NPV (12% discount) for the project: \begin{tabular}{|l|r|r|r|r|r|r|} \hline & \multicolumn{6}{|c|}{ Year } \\ \hline & & 1 & 2 & 3 & 4 & 5 \\ \hline Investment i Show Transcribed Text $403.93 $280.28 $356.63 $179.41

SEE MORE QUESTIONS

Recommended textbooks for you

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

SEE MORE TEXTBOOKS