Using a MARR of 8%, which, if any of the above projects will your company undertake (Perform all calculations using 5 significant figures and round youranswer to one decimal place)?What is the IRR for Alternative A (round to one decimal point, e.g. 3.2%)?Should your company invest in Alternative A (Enter 'Yes' or 'No'):What is the IRR for Alternative B (round to one decimal point, e.g. 3.2%)?Should your company invest in Alternative B (Enter 'Yes' or 'No'):What is the IRR for Alternative C (round to one decimal point, e.g. 3.2%)?Should your company invest in Alternative C (Enter 'Yes' or 'No'):What is the IRR for Alternative D (round to one decimal point, e.g. 3.2%)?Should your company invest in Alternative D (Enter 'Yes' or 'No'):NumberNumberNumberNumber%%%2as You have four independant projects to consider investing in to improve your companies facilities. Their details are given in the following table:Answers entered using text are case sensitive!AlternativeABCDCash Flows at the end of each year12-$100,000 $25,000 $25,000-$120,000 5,00010,000-$90,00050,00050,000-$90,0000003$25,00020,00010,00004$25,00040,000005$25,00080,00001,000,000Using a MARR of 8%, which, if any of the above projects will your company undertake (Perform all calculations using 5 significant figures and round youranswer to one decimal place)?

Here,MARR is 8% YearAlternative 1Alternative 2Alternative 3Alternative 40 $ (100,000.00) $…

You have four independant projects to consider investing in to improve your companies facilities. Their details are given in the following table: Answers entered using text are case sensitive! Alternative A B C D Cash Flows at the end of each year 1 3 -$100,000 $25,000 -$120,000 5,000 -$90,000 50,000 -$90,000 0 0 2 $25,000 10,000 50,000 0 $25,000 20,000 10,000 0 4 $25,000 40,000 0 0 5 $25,000 80,000 0 1,000,000 Using a MARR of 8%, which, if any of the above projects will your company undertake (Perform all calculations using 5 significant figures and round your answer to one decimal place)?

You have four independant projects to consider investing in to improve your companies facilities. Their details are given in the following table: Answers entered using text are case sensitive! Alternative A B C D Cash Flows at the end of each year 1 3 -$100,000 $25,000 -$120,000 5,000 -$90,000 50,000 -$90,000 0 0 2 $25,000 10,000 50,000 0 $25,000 20,000 10,000 0 4 $25,000 40,000 0 0 5 $25,000 80,000 0 1,000,000 Using a MARR of 8%, which, if any of the above projects will your company undertake (Perform all calculations using 5 significant figures and round your answer to one decimal place)?

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

How much would you invest today in order to receive $30,000 in each of the following? (for further instructions on present value in Excel, see the Suggested Resources in the textbook: https://cnx.org/contents/kg0cimBs@14.13:bDQCmuJO@6/Suggested-Resources) a. 10 years at 9% b. 8 years at 12% c. 14 years at 15% d. 19 years at 18%
Calculate the NPV of each project. (Use the NPV function in Excel to solve this problem.) Which of the two projects would you fund if the decision is based only on financial information and you could only choose one of the projects? Omega Alpha Year Inflow YO 0 Y1 0 Outflow 207,000 110,000 Netflow Year Inflow Outflow Netflow (207,000) YO 0 217,000 (217,000) (110,000) Y1 7,000 190,000 (183,000) Y2 150,000 0 150,000 Y2 150,000 0 150,000 Y3 220,000 30,000 190,000 Y3 220,000 30,000 190,000 Y4 161,000 0 161,000 Y4 191,000 0 191,000 Y5 205,000 48,000 157,000 Y5 205,000 38,000 167,000 Y6 197,000 0 197,000 Y6 197,000 0 197,000 Y7 100,000 30,000 70,000 Y7 100,000 30,000 70,000 Total 1,033,000 425,000 608,000 Total 1,070,000 505,000 565,000 The NPV for Omega is The NPV for Alpha is The better project is
Below are four cases that you will have to solve using Excel spreadsheets. 2nd case The COMPETIDORA SA company has the possibility of investing in three different projects . The projections show us the following information on which a decision must be made: PROJECT X Y Initial Z$310,000 It is requested: investment $180,000 $250,000 Year 1 cash flows $50,000 $80,000 $150,000 1. Determine the internal rate of return. 2. Determine the present value. Year 2 cash flows 3. Determine the recovery period. 4. Define which is the most viable project. $70,000 $80,000 $120,000 The discount rate for the project will be 9% and the investors propose a MARR of 22%. Year 3 cash flows $80,000 $80,000 $100,000 Year 4 cash flows $100,000 $80,000
In planning for your retirement, you expect to save $500 in year 1, $1500 in year 2, and amounts increasing by $1000 each year through year 20. If your investments earn 10% per year, the amount you will have at the end of year 20 is closest to: O a. $97,974 O b. $225553 C. $659,125 O d. $401387 e. $596236 In enthusiastic new engineering graduate plans to start a consulting firm by borrowing $200,000 at 10% per year interest. The loan payment each year to pay off the loan in 7 years is closest to O a. $41,000 O b. $20540 O c. $35,000 Od. $82,100 e. $75,250
Cash Payback Period, Net Present Value Method, and Analysis Elite Apparel Inc. is considering two investment projects. The estimated net cash flows from each project are as follows: Plant Expansion Retail Store Expansion Year 1 2 3 4 5 Total Year 1 2 Each project requires an investment of $294,000. A rate of 15% has been selected for the net present value analysis. Present Value of $1 at Compound Interest 6% 10% 12% 15% 20% 0.893 0.870 0.833 0.797 0.756 0.694 3 4 5 $162,000 132,000 114,000 103,000 33,000 $544,000 6 7 8 9 10 Required: 0.909 0.826 $135,000 159,000 109,000 76,000 65,000 $544,000 0.943 0.890 0.840 0.751 0.792 0.683 0.747 0.621 0.705 0.564 0.665 0.627 0.592 0.558 0.712 0.658 0.636 0.572 0.567 0.497 0.507 0.432 0.513 0.452 0.376 0.467 0.404 0.327 0.424 0.361 0.284 0.386 0.322 0.247 1a. Compute the cash payback period for each project. Cash Payback Period 0.579 0.482 0.402 0.335 0.279 0.233 0.194 0.162 Plant Expansion Retail Store Expansion 1b. Compute the net present value.…
MIA Q.1) Your company expects to earn at least 18 percent on its investments. You have to choose between two similar projects (A&B). Below is the cash information for each project. Which of the two projects would you fund if the decision is based only on financial information by using net present value model? if you use payback model which project you will choose? show your calculations? Year 0 1 2 Outflow 225000 190000 0 0 Inflow C.f DE P.V Year Outflow Inflow c. f = R-C C. F D. F P.V 3 30000 0 150000 220000 -225000-190000 150000 10000 - (1+k)" 0 300000 0 5 7 30000 0 30000- 215000 205000 197000 100000 215000 175000 197000 70000 0.847 0.718 3.669 0.516 0.437 0.37 0.314 -225000-160930 107700 115710 110 94076475 72890 219743 7: Project A 4 0 1 2 100000 0 P.V of of WPV = 5PV Project B 3 4 50000 0 50000 150000 250000 250000 200000 250000 -50000 150000 300000 1 0-8470-718 0.609 0.516 -3.000.0042356107700 اسمان M 6 0 wp-v-11975 11976 15 7 50000 30000 200000 180000 120000 150000 180000 90000…
You have the ability to invest $100,000 and have a choice between the following investments that return $150,000 over the next 5 years: Year A B C D 1 $10,000 $30,000 $50,000 2 $20,000 $30,000 $40,000 3 $30,000 $30,000 $30,000 4 $40,000 $30,000 $20,000 5 $50,000 $30,000 $10,000 $150,000 Required: a. Based on cash flows given, with no other analysis, which investments would be a good investment? Which would be a bad investment? b. Based on cash flows given, and no other analysis, rank the investments based on preference/ desirability. Rank 1st, 2nd, 3rd, 4th. If ties, please explain why! c. If you analyzed the cash flows, what would you do? Briefly explain NOTE: Each of the above requires a short narrative answer.
Findell Corporation is considering two projects, A and B, and it has gathered the following estimates for the projects Project A Project B Useful life 5 years 5 years Present value of cash inflows $84,440 $53,300 Present value of cash outflows $79,000 $46,000 What is the present value index for Project A? Multiple Choice 1.069 0.862 1.097 0.886
For each requirement, change the values of the given information as shown and keep all other original data the same. Then enter your updated final answers for each scenario. Scenario A: Future value to be received $ 10,000 Future date received 3 years Discount Rate 6% 10% 16% Scenario B: Annual Cash Receipt $ 5,000 Number of Years 6 years Discount Rate 6% 10% 16% Scenario C: Discount Rate 8% Investment Project Cash Flow Initial Investment $ (6,500) Year 1 $ 700 Year 2 $ 800 Year 3 $ 1,400 Year 4 $ 3,600 Year 5 $ 6,800 Required: a. A company is expecting to receive a lump sum of money at a future date from now. Using the PV formula in Excel, what is the Present Value of that money at three different rates? (Round your answers to 2 decimal places.)
You work for an outdoor play structure manufacturing company and are trying to decide between the following two projects: (Click on the following icon in order to copy its contents into a spreadsheet.) Project Playhouse Fort Year-End Cash Flows ($ thousands) 1 2 18 IRR 33.8% 13.2% 52 You can undertake only one project. If your cost of capital is 7%, use the incremental IRR rule to make the correct decision. 0 -25 -75 The incremental IRR is%. (Round to two decimal places.) 20 39 Save OL
An interior design studio is trying to choose between the following two mutually exclusive design projects: Year 0 1 2 3 Cash Flow Cash Flow (0) -$64,000 31,000 31,000 31,000 a-1 If the required return is 10 percent, what is the profitability index for both projects? (Round your answers to 3 decimal places. (e.g., 32.161)) Project I Project II -$18,000 9,700 9,700 9,700 Profitability Index a-2 If the company applies the profitability index decision rule, which project should the firm accept? O Project I O Project II Project I Project II b-1 What is the NPV for both projects? (Round your answers to 2 decimal places. (e.g., 32.16)) O Project I Project II NPV b-2lf the company applies the NPV decision rule, which project should it take?
Simple Investment Allocation Case: This year, 2022 ABM Company selected your team to manage their allotted budget amounting to 10 million pesos for investment diversification portfolio. Your team was assigned to handle the said account. Question: How would you allocate funds?

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS