Pls help me solve this without Excel. I got this incorrect. A new IT server for a company will cost $448,864.00 today. The company expects the server will create an incremental cash flow to the firm of $131,277.00 per year. The company wants an 8.00% return for all capital budgeting projects. The company will run the server for the next 5 years. Based on the IRR and cost of capital, should they accept the project? (YES or NO)

Pls help me solve this without Excel. I got this incorrect. A new IT server for a company will cost $448,864.00 today. The company expects the server will create an incremental cash flow to the firm of $131,277.00 per year. The company wants an 8.00% return for all capital budgeting projects. The company will run the server for the next 5 years. Based on the IRR and cost of capital, should they accept the project? (YES or NO)

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter14: Real Options

Section: Chapter Questions

Problem 3MC: Tropical Sweets is considering a project that will cost $70 million and will generate expected cash...

See similar textbooks

Similar questions

Your boss has just presented you with the summary in the accompanying table of projected costs and annual receipts for a new product line. He asks you to calculate the IRR for this investment opportunity. What would you present to your boss, and how would you explain the results of your analysis? (It is widely known that the boss likes to see graphs of PW versus interest rate for this type of problem.) The company’s MARR is 10% per year.
I am opening a new factory. The factory will cost $10 million up front. I expect a cash flow of $6 million next year. The cash flows will grow at a rate of 1%. The NPV is $111,200,000. 1. draw the NPV vs r graph and locate the IRR 2. based on the graph, would I accept or reject the project if the cost of capital is between 3% and 5%
Innovation Company is thinking about marketing a new software product. Upfront costs to market and develop the product are $5 million. The product is expected to generate profits of $1 million per year for 10 years. The company will have to provide product support expected to cost $100,000 per year in perpetuity. Assume all profits and expenses occur at the end of the year. (1) What is the NPV of this investment if the cost of capital is 6%? Should the firm undertake the project? Repeat the analysis for discount rates of 2% and 12%.(2) How many IRRs does this investment opportunity have? (3) Can the IRR rule be used to evaluate this investment? Explain.
Use Microsoft Excel to assess the internal rate of return for an IT initiative. Suppose the initial investment is $60,000. The returns on investment in dollars for the following 5 years are (a) $10,000, (b) $12,000, (c) $15,000, (d) $21,000, and (e) $26,000. Use the IRR function to compute the internal rate of return after 2, 4, and 5 years. Next, assume that the loan for the initial $60,000 is at 8 percent and you are earning 16 percent on the annual returns. Use the MIRR function to calculate the internal rate of return. Required: 1. What is the Internal Rate of Return after 2 years? -46% -20% -1% -10% Required: 2. What is the Internal Rate of Return after 4 years? -46% -20% -1% 10% Required: 3. What is the Internal Rate of Return after 5 years? 10% 16% 8% 20%
Consider the following project data. A marketing study that costs $200 will be conducted at t = 0. The best estimate now is that there is a 70 percent chance that the study will indicate potential and a 30 percent chance that it will not. If the study indicates potential, the firm will spend $500 at t = 1 to start production. If the firm starts production, the firm is confident that cash inflows will be $1,000 annually for two years (t=2 and 3). If the appropriate cost of capital is 10 percent, what is the project's expected NPV to the nearest dollar? A) $1,300 B) $923 C) $646 D) $586 E) $446
K Innovation Company is thinking about marketing a new software product. Upfront costs to market and develop the product are $4.98 million. The product is expected to generate profits of $1.09 million per year for 10 years. The company will have to provide product support expected to cost $98,000 per year in perpetuity. Assume all profits and expenses occur at the end of the year. a. What is the NPV of this investment if the cost of capital is 5.6%? Should the firm undertake the project? Repeat the analysis for discount rates of 1.6% and 14.5%, respectively. b. What is the IRR of this investment opportunity? c. What does the IRR rule indicate about this investment? a. What is the NPV of this investment if the cost of capital is 5.6%? Should the firm undertake the project? Repeat the analysis for discount rates of 1.6% and 14.5%, respectively. If the cost of capital is 5.6%, the NPV will be $ (Round to the nearest dollar.) Should the firm undertake the project? (Select the best choice…
Innovation Company is thinking about marketing a new software product. Upfront costs to market and develop the product are $4.98 million. The product is expected to generate profits of $1.15 million per year for 10 years. The company will have to provide product support expected to cost $99,000 per year in perpetuity. Assume all profits and expenses occur at the end of the year. a. What is the NPV of this investment if the cost of capital is 5.6% ? Should the firm undertake the project? Repeat the analysis for discount rates of 1.3% and 16.3%, respectively. b. What is the IRR of this investment opportunity? c. What does the IRR rule indicate about this investment? a. What is the NPV of this investment if the cost of capital is 6.2%? Should the firm undertake the project? Repeat the analysis for discount rates of 1.1% and 17.8%, respectively. If the cost of capital is 6.2%, the NPV will be $ (Round to the nearest dollar.) answer this Should the firm undertake the project? (Select the…
Two new software projects are proposed to a young, start-up company. The Alpha project will cost $150,000 to develop and is expected to have annual net cash flow of $40,000. The Beta project will cost $200,000 to develop and is expected to have annual net cash flow of $50,000. The company is very concerned about their cash flow. Using the payback period, which project is better from a cash flow standpoint ? Why?
Use Excel’s NPV function for this problem. Riverside Inc. has an 8% cost of capital. The firm has an investment opportunity that costs $1,000. Riverside expects the investment to generate annual cash inflows $360 for each of the next three years. The net present value of the project (rounded to the nearest dollar) is Select one: a. $80. b. $72. c. ($72). d. ($80). Use Excel’s IRR function for this problem. Rancho Cucamonga has a 6% cost of capital. The firm has an investment opportunity that costs $2,000. Riverside expects the investment to generate annual cash inflows $600 for each of the next four years. The internal rate of return and Rancho’s decision are Select one: a. 7.7% and don’t invest in the project. b. 1.7% and don’t invest in the project. c. 1.7% and invest in the project. d. 7.7% and invest in the project. Whitelands Inc. bought equipment for $150. Whitelands estimated that the equipment would last ten years and used the double-declining balance method to depreciate it.…
Innovation Company is thinking about marketing a new software product. Upfront costs to market and develop the product are $4.97 million. The product is expected to generate profits of $1.15 million per year for 10 years. The company will have to provide product support expected to cost $95,000 per year in perpetuity. Assume all profits and expenses occur at the end of the year. a. What is the NPV of this investment if the cost of capital is 6.1%? Should the firm undertake the project? Repeat the analysis for discount rates of 1.2% and 16.5%, respectively. b. What is the IRR of this investment opportunity? c. What does the IRR rule indicate about this investment?
Innovation Company is thinking about marketing a new software product. Upfront costs to market and develop the product are $4.97 million. The product is expected to generate profits of $1.08 million per year for ten years. The company will have to provide product support expected to cost $99,000 per year in perpetuity. Assume all profits and expenses occur at the end of the year. a. What is the NPV of this investment if the cost of capital is 6.2%? Should the firm undertake the project? Repeat the analysis for discount rates of 1.6% and 14.2%, respectively. b. What is the IRR of this investment opportunity? c. What does the IRR rule indicate about this investment?
Innovation Company is thinking about marketing a new software product. Upfront costs to market and develop the product are $4.94 million. The product is expected to generate profits of $1.07 million per year for 10 years. The company will have to provide product support expected to cost $99,000 per year in perpetuity. Assume all profits and expenses occur at the end of the year. What is the NPV of this investment if the cost of capital is 5.8%? Should the firm undertake the project? Repeat the analysis for discount rates of 1.7% and 14.1%, respectively. What is the IRR of this investment opportunity? What does the IRR rule indicate about this investment?