Calculate the net present value and pay-back period

Assignment Help Project Management
Reference no: EM132019404

Information Systems R Us, Inc.

You have recently been assigned as the Deputy for Portfolio Management in the Program Management Office of your company, Information Systems R Us, Inc. (ISRU). In discussing this new assignment with your senior manager, you learn that the Chief Executive Officer (CEO) has approved a budget for new investments of $10,000,000 for the next Fiscal Year. In the past, the Chief Financial Officer (CFO) has allocated the investment budget to each Department and allowed them to allocate their budget as they see fit. The CEO is uncomfortable with this approach and has directed the PMO to work with the CFO and come up with an integrated approach to investment selection.

You decide that your first action in your new position is to analyze the potential investments for the next FY. Before you review these investments, though, you decide it would be a good idea to review the CEO's latest strategic plan for ISRU. The Executive Summary reads, in part:

ISRU has reached a crossroads in its growth as a specialty provider of information technology products. We have established an enviable reputation as an innovator of quality products in our corner of the information technology arena. However, more and more of our traditional customer base has opted to select products from foreign companies offering lower priced products that have lower quality and fewer features. Revenue has declined over recent years and our profits have dropped dramatically as we have been forced to lower prices in an attempt to maintain volume. One area of my concern is to reduce the turnover of key personnel, particularly within our engineering workforce.

Four strategic objectives over the next five years and, in order of priority:

1. First and foremost, we must continue to develop new products that can maintain our reputation as an innovator.

2. Second, we must reduce the cost of these products to discourage our competition from underselling our products. This may require off-shore production in countries with lower labor costs.

3. Third, we must enter new fields, including the provision of information management services for products other than our own.

4. Finally, it is important that we maintain the quality and skills of our workforce. I would like to reduce turnover from the current rate of 25% a year to a rate of 10% or less.

Regardless of the priorities I have outlined above, I expect each initiative to achieve a positive cash flow and meet our internal rate of return. Our stockholders expect nothing less.

After reviewing the Executive Summary, your next step is to visit the Chief Financial Officer of ISRU. In discussions, you learn that the internal rate of return for ISRU will remain at 15% for the next five years and that, for planning purposes, the CFO foresees an inflation rate of 2%. In addition, the CFO indicates that ISRU investment policy requires that for budgetary analysis all investment costs will be assumed to occur at the beginning of the year and all recurring costs and revenues at the end of the year. He also indicates that while all investments must have a payback period of less than five years, and that while a payback period less than that is important, it is not nearly as important as NPV in comparing investments. Finally, the CFO reminds you that policy requires that if you use a weighted factor scoring table, the weighted factors should add up to 100%.

The CFO has asked the Program Management Office to develop a prioritized list of proposed investments, and your senior manager, the Director of Program Planning and Management, has turned this over to you. Her only guidance is to be sure to consider all of the CEO's strategic objectives and that you comply the all CFO guidelines. She wishes you good luck.

Finally, you feel prepared to tackle the proposed investments submitted by the ISRU Departments and major staff positions. These are:

1. Investment 1: Advanced Security Router
Extract from Product Development justification: This product will offer features until recently only available on military systems, meeting an expanding market demand. While the investment is significant, the anticipated revenue should be significant, particularly in the first two years. There will be additional benefits in retaining technical personnel due to the challenge associated with the application of new cyber-security technologies.

2. Investment 2: Multi-Frequency Modem
Extract from Business Development justification: This initiative includes the purchase of patent and production rights for a product developed by a small business that is currently in bankruptcy. The product will fill a hole in a key marketing area that ISRU has been unable to penetrate to date. While the market for this product is limited, it tends to be very stable. We anticipate significant revenue for the next four years with only limited sustainment costs.

3. Investment 3: Service Organization
Extract from the Product Services Division justification: At the present, ISRU contracts out first level system maintenance to various small businesses. This initiative will bring that support in-house, improving customer satisfaction and reducing system life cycle costs. It will have the ancillary benefit of improving retention of the lower grade technical workforce, from which many of our senior engineering personnel are drawn.

4. Investment 4: State of the Art Manufacturing
Extract from the Manufacturing Division justification: ISRU manufacturing costs are a significant part of its overall cost structure. By the use of state of the art 3-D Printing, ISRU can realize significant cost savings. This will also enhance retention of key technical personnel. One of the major factors influencing the decision to leave ISRU, per employee departure interviews, has been the amount of time from design to production and the lack of support for prototyping new products.

5. Investment 3: HR Initiative
Extract from the Human Resources Department: This initiative provides a training and mentoring program designed to reduce new employee turnover. While the cost of developing this program would normally be included in our HR budget, treating these costs as an investment will significantly speed the implementation of this critical program.
Leaning on your experience as a Graduate Student at UMUC, you next tackle the quantitative aspects of these investments. The anticipated cash flow for each of these initiatives is attached .

Requirements:

1. Calculate the Net Present Value and Pay-Back Period for each investment . Provide your calculations as a separate excel file.

2. Using the weighted factor scoring method, rank-order these investments.

3. Assuming you have an investment budget of $10,000,000, which combination of investments would you recommend?

4. Prepare a recommendation for the CFO as to which investments you would recommend. Use the following sections:
a. Executive Summary
b. Analysis (including the weighted factor scoring model table)
c. Conclusions
d. Recommendation

Administrative Instructions:
- Your recommendation to the CFO should be no more than five pages, using APA formatting, not including the cover page, table of contents, references and supporting calculations. The supporting calculations should be included as a separate Excel file or files.
- Be sure to explain how you established the weights used in developing your weighted factor scoring table, how you determined the relative rankings, how you developed scales that you used, how you treated financial versus non-financial factors, etc.
- Be sure to include the group name (group 1, group 2, etc.) when naming your files. Text files should be posted as MS Word files and calculations as Excel files.

*Note: Just need from #4

Reference no: EM132019404

Questions Cloud

What is the journal entry needed to correct this error : A $375 purchase of supplies on account was recorded by debiting Supplies for $375 & crediting Cash for $375. What is the journal entry needed to correct error
What you see and hear is filtered through who you are : What you see and hear is filtered through who you are. Each person has a different perspective.
What you have read and researched in given case : Based on what you have read and researched, do you believe that the loss of biodiversity is a concern for humans? Should the government not only preserve.
Calculate npv of the project : Purchasing the equipment will not change the risk level of the company. Calculate the NPV of the project.
Calculate the net present value and pay-back period : Calculate the Net Present Value and Pay-Back Period for each investment Provide your calculations as a separate excel file
What will the value of the firm : What will the value of the firm be if the company takes on debt equal to 100 percent of its unlevered value?
What evidence can you find to support your opinion : Which CEO-Jobs or Cook-do you think developed and executed the most effective strategic plan? What evidence can you find to support your opinion?
Construct an outline of the homo naledi fossil : Construct an outline of the Homo naledi fossil finds and assess whether the characteristics of this hominin are derived or primitive.
What is the accrued interest : For Bond Z listed in Table 8.0 what is the accrued interest per 100 of par value on the settlement date of 22 Aug 2014 is:

Reviews

Write a Review

Project Management Questions & Answers

  Manage an it project or a traditional project

Do you think it's harder to manage an IT project or a traditional project, such as building construction? Justify your response. Please ensure response is 1-2 paragraphs in length.

  Roi of project and determinationoakley co produces

roi of project and determinationoakley co. produces pipes.oakley co. operating results includecontrollable margin

  Was the sample size adequate

Was the sample size adequate?

  What combination of x and y will provide

What combination of x and y will provide a feasible solution and a minimum objective function value for the following problem

  Find the average number of customers waiting for haircuts

Find the average number of customers waiting for haircuts.-  Find the average number of customers in the shop.

  A stationary gaussian process with mean mx and variance

Determine the necessary and sufficient conditions, for which Y(t1) and Z(t2) are statistically independent Gaussian processes.

  Business process and functional modeling

Advanced Business Systems (ABS) is a consulting and staffing company providing specialized staffing and consulting services to clients in a variety of different industries. It has offices in major U.S. metro areas and has ongoing relationships wit..

  Develop risk mitigation plans to address each

Develop risk mitigation plans to address each of these risks, and a plan to enhance the opportunity. You may find that more than one risk mitigation strategy is available for any given risk. Make sure to indicate the risk or opportunity strategy-avoi..

  How would you council catha to help her meet her commitments

What are the next steps you should take in the progressive discipline process? How would you council Catha to help her meet her commitments?

  What was the objective of the project in general

MBA7023 - Project Management Theory and Practice - Comparative Study of Project Management Software

  What percentage of patients would you expect to stay

A) What percentage of patients would you expect to stay between 11.5 weeks and 13.0 weeks?

  Supply chain management for the focal firm

Examine the problems and causes that may contribute to low quality throughout the supply chain. Soltani, et al. (2011) recommended that the leadership in the focal firm or buyer select good partners, ensure cooperation, and motivate loyalty to the..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd