Fill in the yellow cells using excel funtions (trying to build excel model please use excel functions) Given the followinginformation about 4 mutually exclusive projects that are expected to be repeated infinitely, complete the tableinformation (the shaded blanks). Assume that all projects are equally risky and will have the same cost of capital. Whichproject should be chosen? (20 Points) \table[[, A, B, C, D], [CF (0), ($1,600, 000), ($2, 225, 000), ($2, 460,000), ($1,500,000)], [Inflows (equal for life of the project), $565,000,,, $712,000], [Project Life,5,3,4,], [NPV,, $350,000,,], [IRR,,,, 20.00%], [MIRR, 18.50%,..], [PAYBACK (Yrs),,, 2.5,], [Terminal Value,,,,], [WACC,,,,]]6.Given the following information about 4 mutually exclusive projects that are expected tobe repeated infinitely, complete the table information (the shaded blanks). Assume thatall projects are equally risky and will have the same cost of capital. Which project shouldbe chosen? (20 Points)CFInflows (equal for life of the project)Project LifeABC($1,600,000) ($2,225,000) ($2,460,000) ($1,500,000)$565,000$712,000D534NPV$350,000IRR20.00%MIRR18.50%PAYBACK (Yrs)Terminal ValueWACC2.5

In mutually exclusive projects, if NPV and IRR are conflicting, then we should go with NPV because…

Answered: Fill in the yellow cells using excel…

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

Determine the feasibility of below presented project using FW Method. Use MARR = 10% Note: Round off your answer to the NEAREST WHOLE NUMBER and show complete solution Answer the following: FW of Alt. A is $Blank 1 FW of Alt. B is $Blank 2 FW of Alt. C is $Blank 3 FW of Alt. D is $Blank 4 Select Alternative (Write only the letter if A,B,C or D) Blank 5
Internal rate of return For the project shown in the following table, calculate the internal rate of return (IRR). Then indicate, for the project, the maximum cost of capital that the firm could have and still find the IRR acceptable. The project's IRR is %. (Round to two decimal places.) Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Initial investment (CF,) $100,000 Year (t) Cash inflows (CF;) $10,000 $10,000 $45,000 $30,000 $35,000 1 4 5 Print Done
For this question you need to attach a file in Excel with your calculations. What do we call the cost of capital at which the two projects have the same NPV? Find this cost of capital for projects X and Y below Project X: CFo= - $3,500; CF1 = $900; CF2 = $1,000; CF3 = $1,200; CF4 = $750; CF5 = $120. Project Y: CFo = -$3,000; CF1 = $700; CF2 = $900, CF3= $1,000; CF4 = $700.
Whispering Winds Company is considering a long-term investment project called ZIP. ZIP will require an investment of $130,000. It will have a useful life of four years and no salvage value. Annual cash inflows would increase by $81,000, and annual cash outflows would increase by $40,500. In addition, the company's required rate of return is 10% Click here to view the factor table (a) Calculate the net present value on this project. (If the answer is negative, use either a negative sign preceding the number eg-5,275 or parentheses es. (5,275), For calculation purposes, use 5 decimal places as displayed in the factor table provided, eg. 1.25124 and final answer to O decimal places, eg. 5,275) Net present value $ Identify whether the project should be accepted or rejected. The project should be (b) Q Search 458 PM
Compute the Profitability Index (PI) for each project? Project A Project B Profitability Index (PI) 5- In light of your answers above, suppose that these two projects might be mutually exclusive or independent. According to these two assumptions, fill in the blanks in the table below with the suitable answer: Points Investment Criteria If A and B are mutually exclusive, then I would select If A and B are independent, then I would select PBP NPV IRR PI
use excel 9. A firm faces three investment opportunities A, B and C: A. NPV = $3m, investment = $1m B. NPV = $2m, investment = $2m C. NPV = $2.5m, investment = $3m Given a total of $4m initial resources, which one(s) should the firm take? Explain.
Problem 4. Which project would you select on the basis of rate of return, assuming MARR =15%. Please use excel spreadsheet to answer.
(use the attached picture to answer question) (6.3) This question relates to the Quiz 6.3 diagram, which shows the NPV profile for Projects X and Y. For what range of costs of capital is the NPV of both projects negative? Select one: a. Greater than 9% b. Between 9% and 13% c. Less than 4% d. Greater than 13%
A2. (PaybackandNPV)Threeprojectshavethecashflowsgivenhere.Thecostofcapitalis10%. a. Calculate the paybacks for all three projects. Rank the projects from best to worst based on their paybacks. Calculate the NPVs for all three projects. Rank the projects from best to worst based on their NPVs c. Why are these two sets of rankings different? YEAR 0 1 2 3 4 5Project 1 −10 4 3 2 1 5 Project 2 −10 1 2 3 4 5 Project 3 −10 4 3 2 1 10
Given the following two mutually exclusive projects, always choose Project A (the project with a higher IRR). Project NPV IRR A $100 10.5% B $150 9.5% Group of answer choices True False
d. What is the profitability index for each project? (Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.) Using excel how to I find the PI for this question?
I need help with the attached empty fields Laurman, Incorporated is considering a new project and has provided the details of the project. The Controller has asked you to compute various capital budgeting methods to help aid in the decision to pursue the investment. Cell Reference: Allows you to refer to data from another cell in the worksheet. If you entered “=B5” into a blank cell, the formula would output the value from cell B5. Basic Math Functions: Allow you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add), - (minus sign to subtract), * (asterisk sign to multiply), and / (forward slash to divide). For example, if you entered “=B4+B5” in a blank cell, the formula would add the values from those cells and output the result. SUM Function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges. If you entered “=SUM(C4,C5,C6)” into a blank cell, the formula…

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

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