Fill in the yellow cells using excel funtions (trying to build excel model please use excel functions) Given the following information about 4 mutually exclusive projects that are expected to be repeated infinitely, complete the table information (the shaded blanks). Assume that all projects are equally risky and will have the same cost of capital. Which project 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 to be repeated infinitely, complete the table information (the shaded blanks). Assume that all projects are equally risky and will have the same cost of capital. Which project should be chosen? (20 Points) CF Inflows (equal for life of the project) Project Life A B C ($1,600,000) ($2,225,000) ($2,460,000) ($1,500,000) $565,000 $712,000 D 5 3 4 NPV $350,000 IRR 20.00% MIRR 18.50% PAYBACK (Yrs) Terminal Value WACC 2.5

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

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.

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

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

Use the information for the question(s) below. Project A - 10,000 Project B Time 0 - 10,000 Time 1 5,000 4,000 Time 2 4,000 3,000 Time 3 3,000 10,000 If WiseGuy Inc. uses IRR rule to choose projects, which of the projects (Project A or Project B) will rank highest? OA. Project A OB. Project B OC. Project A and Project B have the same ranking OD. Cannot calculate a payback period without a discount rate.