User Account

All Pages

Complete the excel case file

Assignment Help Other Subject
Reference no: EM132621793

Question - Complete the excel case file.

The following are the instructions for completing the file

A company is assessing an opportunity to grow sales by implementing a robust customer relationship management (CRM) software tool that will improve their interaction with customers. See the attached file for the information you will need to complete the case study. Should the Company invest in this tool? Why or why not?

1. In order to determine the effect of implementing the CRM project you will need to isolate the incremental cash flows. This can be done by preparing a baseline projection for the time period in question. On the "Baseline Projection" sheet you will need to continue the historical income statement forward another five years. Using the model built for FYs 2015-2018 determine the appropriate projection values for each of the line items. For some items you will need to determine historical growth rates or ratio trends, for others you will simply need to continue the accounting formulas. By looking at the data and formulas in each of the cells and lines you will be able to work through these. As this is the baseline you will have no data in the "Incremental..." lines.

2. Now you must determine the effect of implementing the CRM project. Using your projections from the "Baseline Projection" you will now have to account for the incremental impact of the project. Consult the "Data and Assumptions" sheet and use that information to build out your "CRM Investment" sheet.

3. With full projections for the Baseline Projection and CRM Investment completed, you can now isolate the incremental changes in cash flow per year. Fill this information in on the "Calculation" sheet. You will then need to take that data and complete both an NPV and IRR analysis. The results of each of these analyses should influence your recommendation to pursue the project.

4. Submit a word document with a short report summarizing your process and recommendations. While there is no standard format you should follow use your own judgement on making this appear like a professional memo you would be sending to a boss or decision maker. Assume that this report is the first time they're hearing about the possible project.

Attachment:- Case File.rar

Reference no: EM132621793

Questions Cloud

Fundamental software engineering principles of process : Explain why the fundamental software engineering principles of process, dependability, requirements management,
Find out cost of goods sold-mineral labs : At the end of January, Mineral Labs had an inventory of 795 units, which cost $8 per unit to produce. During February the company produced 1,000
Responsibilities for organization staff regarding security : What are the roles and responsibilities for the organization's staff regarding security? Is there any concern about Dayton Soft Products' overall communications
Information systems research in digital world : Journal article was focused on the Complexity of Information Systems Research in the Digital World.
Complete the excel case file : Complete the excel case file. In order to determine the effect of implementing the CRM project you will need to isolate the incremental cash flows
Management step is to develop metrics and measure results : In order to have a successful IG program, one of the eight (8) Information Risk Planning and Management step is to develop metrics and measure results.
What is the depreciation : Norraine Company uses the composite method of depreciation based on a composite rate of 25%. What is the depreciation for 2010
Describe the potential disadvantages of PaaS : List the benefits of PaaS. Describe the potential disadvantages of PaaS. List the computing resources normally provided with PaaS.
Determine the amount presented as a component of profit : Assuming the securities are held as trading securities, determine the amount presented as a component of profit or loss as a result of change in fair value

Reviews

Write a Review

Other Subject Questions & Answers

  Discuss the attributes of spiritual care in nursing practice

Disasters take different forms, but their impact on the communities they affect is devastating. Importantly, these disasters affect individuals as well as entire communities when they occur significantly impacting their daily operations. Healthcar..

  What reorder point should be used

Suppose that usage of cooking oil at Harry's Fish Fry is normally distributed with an average of 15 gallons/day and a standard deviation of two gallons/day. Harry has just fired the manager and taken over operating the restaurant himself.

  Role of freight consultant to assist alice

Introduce the project by creating a Freight Consulting Company and a MARKETING description outlining the company background and credentials that qualify you for the role of freight consultant to assist Alice.

  Evaluate judy stokleys level of success

Create a personal leadership development plan for Judy Stokley so that she may be eligible for future promotions to leadership roles beyond program director.

  Discuss the events that have contributed to nursing shortage

Discuss the events that have contributed (or will continue to contribute) to the nursing shortage, or that contribute to a shortage in a region or specialty.

  Has managed care successful in controlling health costs

Has managed care been successful in controlling health care costs? Why or why not. What are the advantages for a hospital in conducting a cost-benefit analysis?

  Discuss the steps that will be taken to present information

For this assignment, develop a document that contains the community resources for breast cancer patients. Discuss the steps that will be taken to gather and present the information. Include a procedure to update the information on a regular basis.

  Explain what the divine command theory is

Thomas Aquinas offered 5 ways, or proofs, for the existence of God in his writing, Summa Theologicae.

  How are your vision and mission statements used in the firm

When did your organization first develop its vision or mission statement? Who was primarily responsible for its development?

  What are the major provisions

Research a federal, state, or municipal tax credit relevant to engineering projects. When was it enacted? What are its major provisions.

  Discuss the method you would take to empower your team

Empowerment: In Chapter 4, London and London (2007) outline eight steps to creating and leading a high performance team. Assume you are the leader of one.

  Define the fundamental makeup of the groups

Explain the differences and similarities between the fundamental makeup of the groups' origins as they relate to ethnic background

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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