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…

Financial Management: Theory & Practice

16th Edition

ISBN:9781337909730

Author:Brigham

Publisher:Brigham

Chapter10: The Basics Of Capital Budgeting: Evaluating Cash Flows

Section: Chapter Questions

Problem 23SP: Start with the partial model in the file Ch10 P23 Build a Model.xlsx on the textbooks Web site....

See similar textbooks

Similar questions

(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%
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.
Please use excel and show formulas/work. Can use a graph to visualize if that helps.
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
Please see attached:
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.
3e.a.Determinethe payback period for each b.Calculatethe net present value (NPV) for each c.Calculatethe profitability index (PI) for each project. d.Calculatethe internal rate of return (IRR) for each e.Basedon ALL your answers above, explain briefly which project should be Note: i just need (e) no question answer not all no need excle formula , thank you
Just need b-1, d-1, and e-1 answered.
Answer this question as it is pertaining to two MUTUALLY EXCLUSIVE projects on the following figure. Given r=6%, which project would you choose if you decide to use the internal rate of return (IRR) as the criterion? Group of answer choices Project A Project B Neither Either
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
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?

SEE MORE QUESTIONS

Recommended textbooks for you

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

SEE MORE TEXTBOOKS