-ollowlng Is Information on two alternative Investments belng considered by Jolee Company. The company requires a 10% return fromIts Investments.Project A$(196,000)Project B$(141, 000)Initial investmentExpected net cash flows in:Year 149,00065,00089,29541,00059,00075, 00075,00075,000Year 2Year 3Year 499,40074,000Year 5Compute the Internal rate of return for each of the projects using excel functlons. (Round your answers to 2 declmal places.)IRRProject A%Project B< Prev9 of 9NextLType here to searchF11F1F6F7F8F9F10F2F3F4F5F123124.78TYUPGKSCN MBEI

Project A Total inflows=49000+65000+89295+99400+74000=$376,695

FOlTowing is Informaion on two aiternative Investments belng considered by Jolee Company. The company requires a 10% return from ts Investments. Project A $(196,000) Project B $(141, 000) Initial investment Expected net cash flows in: Year 1 49,000 65,000 89, 295 99,400 74,000 41,000 Year 2 59,000 Year 3 75, 000 75,000 75, 000 Year 4 Year 5 Compute the Internal rate of return for each of the projects using excel functlons. (Round your answers to 2 declmal places.) IRR Project A Project B

FOlTowing is Informaion on two aiternative Investments belng considered by Jolee Company. The company requires a 10% return from ts Investments. Project A $(196,000) Project B $(141, 000) Initial investment Expected net cash flows in: Year 1 49,000 65,000 89, 295 99,400 74,000 41,000 Year 2 59,000 Year 3 75, 000 75,000 75, 000 Year 4 Year 5 Compute the Internal rate of return for each of the projects using excel functlons. (Round your answers to 2 declmal places.) IRR Project A Project B

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter10: Capital Budgeting: Decision Criteria And Real Option

Section: Chapter Questions

Problem 21P

See similar textbooks

Similar questions

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?
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)?
The management of Ryland International Is considering Investing in a new facility and the following cash flows are expected to result from the investment: A. What Is the payback period of this uneven cash flow? B. Does your answer change if year 6s cash inflow changes to $920,000?
Assume that an investment of 100,000 produces a net cash flow of 60,000 per year for two years. The discount factor for year 1 is 0.89 and for year 2 is 0.80. The NPV is a. 0 b. 6,800 c. 1,400 d. (4,000)
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?
Assume San Lucas Corporation in MAD 26-1 assigns the following probabilities to the estimated annual net cash flows: a. Compute the expected value of the annual net cash flows. b. Determine the expected net present value of the equipment, assuming a desired rate of return of 10% and the expected annual net cash flows computed in part (a). Use the present value tables (Exhibits 2 and 5) provided in the chapter in determining your answer. c. Based on your results in parts (a) and (b), should San Lucas Corporation invest in the equipment?
An investment of 1,000 produces a net cash inflow of 500 in the first year and 750 in the second year. What is the payback period? a. 1.67 years b. 0.50 year c. 2.00 years d. 1.20 years e. Cannot be determined
Manzer Enterprises is considering two independent investments: A new automated materials handling system that costs 900,000 and will produce net cash inflows of 300,000 at the end of each year for the next four years. A computer-aided manufacturing system that costs 775,000 and will produce labor savings of 400,000 and 500,000 at the end of the first year and second year, respectively. Manzer has a cost of capital of 8 percent. Required: 1. Calculate the IRR for the first investment and determine if it is acceptable or not. 2. Calculate the IRR of the second investment and comment on its acceptability. Use 12 percent as the first guess. 3. What if the cash flows for the first investment are 250,000 instead of 300,000?