kindly provide it on excel file Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC). Both projects require an annual retum of 15 percent.YearProject A850,000480,000Project B2,100,0001,500,000750.000lo430,000320,0003600,000As a financial analyst for BRC, you are asked the following questions.(a.) If your decision rule is to accept the project with the greater MIRR, which project should you choose?(b.) To be prudent, you compute the NPV for both projects. Which project should you choose?

Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC). Both projects require an annual retum of 15 percent. Project A -850,000 480,000 430,000 320,000 Project B 2,100,000 1,500,000 750,000 600,000 Year 2 3 As a financial analyst for BRC, you are asked the following questions. (a.) If your decision rule is to accept the project with the greater MIRR, which project should you choose? (b.) To be prudent, you compute the NPV for both projects. Which project should you choose?

Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC). Both projects require an annual retum of 15 percent. Project A -850,000 480,000 430,000 320,000 Project B 2,100,000 1,500,000 750,000 600,000 Year 2 3 As a financial analyst for BRC, you are asked the following questions. (a.) If your decision rule is to accept the project with the greater MIRR, which project should you choose? (b.) To be prudent, you compute the NPV for both projects. Which project should you choose?

Financial And Managerial Accounting

15th Edition

ISBN:9781337902663

Author:WARREN, Carl S.

Publisher:WARREN, Carl S.

Chapter26: Capital Investment Analysis

Section: Chapter Questions

Problem 2CMA: Staten Corporation is considering two mutually exclusive projects. Both require an initial outlay of...

See similar textbooks

Similar questions

Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year for 5 years. Project L costs $25,000 and is expected to produce cash flows of $7,400 per year for 5 years. Calculate the two projects’ NPVs, IRRs, MIRRs, and PIs, assuming a cost of capital of 12%. Which project would be selected, assuming they are mutually exclusive, using each ranking method? Which should actually be selected?
Redbird Company is considering a project with an initial investment of $265,000 in new equipment that will yield annual net cash flows of $45,800 each year over its seven-year life. The companys minimum required rate of return is 8%. What is the internal rate of return? Should Redbird accept the project based on IRR?
Garnette Corp is considering the purchase of a new machine that will cost $342,000 and provide the following cash flows over the next five years: $99,000, $88,000, $92,000. $87,000, and $72,000. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return in Excel. see Appendix C.
Your company is planning to purchase a new log splitter for is lawn and garden business. The new splitter has an initial investment of $180,000. It is expected to generate $25,000 of annual cash flows, provide incremental cash revenues of $150,000, and incur incremental cash expenses of $100,000 annually. What is the payback period and accounting rate of return (ARR)?
Jasmine Manufacturing is considering a project that will require an initial investment of $52,000 and is expected to generate future cash flows of $10,000 for years 1 through 3, $8,000 for years 4 and 5, and $2,000 for years 6 through 10. What is the payback period for this project?
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.
Consolidated Aluminum is considering the purchase of a new machine that will cost $308,000 and provide the following cash flows over the next five years: $88,000, 92,000, $91,000, $72,000, and $71,000. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return in Excel, see Appendix C.
Buena Vision Clinic is considering an investment that requires an outlay of 600,000 and promises a net cash inflow one year from now of 810,000. Assume the cost of capital is 10 percent. Required: 1. Break the 810,000 future cash inflow into three components: a. The return of the original investment b. The cost of capital c. The profit earned on the investment 2. Now, compute the present value of the profit earned on the investment. 3. Compute the NPV of the investment. Compare this with the present value of the profit computed in Requirement 2. What does this tell you about the meaning of NPV?
The Pinkerton Publishing Company is considering two mutually exclusive expansion plans. Plan A calls for the expenditure of 50 million on a large-scale, integrated plant that will provide an expected cash flow stream of 8 million per year for 20 years. Plan B calls for the expenditure of 15 million to build a somewhat less efficient, more labor-intensive plant that has an expected cash flow stream of 3.4 million per year for 20 years. The firms cost of capital is 10%. a. Calculate each projects NPV and IRR. b. Set up a Project by showing the cash flows that will exist if the firm goes with the large plant rather than the smaller plant. What are the NPV and the IRR for this Project ? c. Graph the NPV profiles for Plan A, Plan B, and Project .
Gallant Sports s considering the purchase of a new rock-climbing facility. The company estimates that the construction will require an initial outlay of $350,000. Other cash flows are estimated as follows: Assuming the company limits its analysis to four years due to economic uncertainties, determine the net present value of the rock-climbing facility. Should the company develop the facility if the required rate of return is 6%?