"Money is Yours" has recently been about two years ago in Mexico. Over this period, the business has been tripled, and the company's CEO is planning to expand the operation by moving to a larger facility. Four sites have been visited. Cash flows for each option have been recorded for the next nine years. If the minimum acceptable rate of return (MARR) is 12%, which project would you recommend to the "Money is Yours" CEO using Net present value (NPV) analysis Use the incremental net present value and show which project must be selected? EOY Project#1 Project#2 Project#3 Project#4 -80,000 -70,000 -85,000 -100,000 1-9 10,000 12,000 15,000 16,000

"Money is Yours" has recently been about two years ago in Mexico. Over this period, the business has been tripled, and the company's CEO is planning to expand the operation by moving to a larger facility. Four sites have been visited. Cash flows for each option have been recorded for the next nine years. If the minimum acceptable rate of return (MARR) is 12%, which project would you recommend to the "Money is Yours" CEO using Net present value (NPV) analysis Use the incremental net present value and show which project must be selected? EOY Project#1 Project#2 Project#3 Project#4 -80,000 -70,000 -85,000 -100,000 1-9 10,000 12,000 15,000 16,000

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

If striving to meet schedule or budget isn't top priority, what is? Why? What type of risk analysis approach would have been most appropriate in this situation?
Finanace TRUE OR FALSE: Diagram 1 below is one way to frame a discussion of qualitive risk factors whether you are thinking about an investment at the very early seed stage of a growth company or undertaking new a project for a mature company. Please explain
George Zegoyan and Amir Gupta face a difficult decision. Their private auto parts manufacturing company has been a great success - too quickly. They cannon keep up with the demand for their product. They must expand their facilities, but have not had time to accumulate sufficient working capital, nor do they want to acquire long-term debt to finance the expansion. Discussions with there accountants, lawyers, and stockbrokers have confronted them with the necessity of going public to raise the required capital. Zegoyan and Gupta are concerned about maintaining control if they become a public company. They are also worried about loss of privacy because of the required reporting to various regulatory bodies and their their shareholders. Naturally, they are also pleased that the process will enable them to sell some of their shareholdings to the public and realize a faiir profit from their past and expected future successes. They will be able to sell 40 percent of the shares for…
Swan Cruises was formed in 1995 by a group of four friends who each owned cabin cruises and used redundancy payments to purchase additional four. From their own boating activities and contacts, they concluded that there was a good opportunity in the market for family cruising holidays on the canal system. They produced rough budgets and drew up an advertising plan. Because they wanted to get started quickly to catch the spring season, the partners did not give time to strategic planning. However, after their publicity leaflets and advertising in the press, they received a good number of bookings, but sooner than later they began to run into problems. The waterways authority demanded more safety measures and so their insurance premiums were more than budgeted for; Customers found the cruises too small for family parties to live in for a week; Customers regularly got into difficulties with running the boats and at the locks and the partners had to spend much time teaching and helping…
Fold back the decision tree (5 marks) to determine the best strategy for the circus; you must state this strategy (1 mark). What is the final expected profit?
1. How do you use the Johnson & Scholes framework to determine the optimal strategy choice? 2. How do we know an organization has made the optimal choice? What financial metrics might help to evaluate an optimal choice? 3. Describe a time an organization did not make an optimal choice. Using the Johnson & Scholes framework, how might the firm have improved its process?
Consider the payoff matrix below with actions, states of nature, and prior probabilities. 0.20 0.30 0.50 S1 S2 S3 a1 3 az 1 4 a3 4 -1 Ignore the prior probabilities. Which action should be taken based on the Hurwicz criterion with an index of optimism 0.6? O only a3 O none since the Hurwicz criterion does not apply O only a2 O only a1
Two weeks after New Orleans was devastated by Hurricane Katrina, you made the decision to postpone the conference and select a different city to hold the conference Based on your initial objectives and a survey you took of the registered attendees, you created the following consequence table based on the information available ALTERNATIVES Cancel conference for this yearâ€”schedule for next year Keep in New Orleans, but schedule for a later date (when the hotels re-open) Keep same dates, but move to another city Move to another city and schedule for a later date OBJECTIVES Maximize attendance Does not meet objectiveSenior management stated that cancelling is not an option Does not meet objectiveUncertainty on when New Orleans will be back in business is too far off Does not meet objectiveCost and logistics of finding a new location and getting attendees to change flights with such short notice is cost prohibitive Meets objectiveIn a survey…
These are some of the purposes that a business plan has. Describe how each goal contributes to the overall success of the business. Eliminate risks. Obtain funding for a business venture by luring potential partners, investors, and bankers. Demonstrate the potential financial return that it could generate.
George Zegoyan and Amir Gupta face a difficult decision. Their private auto parts manufacturing company has been a great success - too quickly. They cannot keep up with the demand for their product. They must expand their facilities, but have not had time to accumulate sufficient working capital, nor do they want to acquire long-term debt to finance the expansion. Discussions with their accountants, lawyers, and stockbrokers have confronted them with the necessity of going public to raise the required capital. Zegoyan and Gupta are concerned about maintaining control if they become a public company. They are also worried about loss of privacy because of the required reporting to various regulatory bodies and their shareholders. Naturally, they are also pleased that the process will enable them to sell some of their shareholdings to the public and realize a fair profit from their past and expected future successes. They will be able to sell 40 percent of the shares for $500,000, which…
Scenario:John is an infrastructure engineer who worked with the Cisco Systems software company forover 10 years. John is thinking about starting a new business where he will develop computerprograms for educational needs. He has always had entrepreneurial tendencies and has gainedgreat success in the past. He is having doubts and have hired you as a consultant to aid in guidinghis decision. He understands that the technology market is very competitive but believes thatthrough hard work and dedication he can reap success. You are required to discuss with John, as addressed in the course, three (3) main categories ofcreativity techniques and their application to entrepreneurial opportunity identification anddevelopment. You must incorporate at least two (2) examples for each main category and analyzehow these tools can be useful to John as an entrepreneur or any potential entrepreneur.
You are a manager at a certain factory that designs small gadgets. The factory has been quite successful in the past years. Your CEO is wondering whether or not it is a good idea to expand the factory this year. The cost to expand the factory is $1.5M. Doing nothing will resultin expected $3M in revenue if the economy stays good and people continue to buy plenty of gadgets, but only $1M in revenue is expected if the economy is bad. On the other hand, expanding the factory carries an expected $6M in revenue if economy is good and $2M if the economy is bad.Assume there is a 40% chance of a good economy and a 60% chance of a bad economy. Also,assume the costs of operating the factory account to $.5M if the factory is expanded and$.3M if not.a. Illustrate a Decision Tree showing these choices.b. What should you do?