Firm A plans to buy Firm T in a LBO for $759,600. The target is projected to earn $270,000; $290,000, and $300,000 for the next three years respectively. If Firm A plans to sell Firm T after year 3 for $3,060,000, what is the IRR of the investment? (Assume a WACC of 12%)

1.

2. Create a formula that will return "Extend Credit" or "No Credit" in column F. In order to be receive credit, the customers must have DTI that is lower than .30 (30%) and annual income of at least $37,000 or have a credit score higher than 4.0

Enter an IF statement in G4 that will return the appropriate bonus for the sales recorded in F4. The actual bonus rate depend on the amount sold. The table B2:D5 show the bonus rate for different sales levels. This assignment will require a statement with multiple if's.

Please mention the excel formula used here.

Unit price: $50
Variable cost: $30
Fixed Cost: $430,000
Expected Sales: 42,000 units per year
However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 10% high or 10% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1.9 million, which will be depreciate straight line over the project life to a final value of zero. The firm’s tax rate is 35% and the required rate of return is 10%.

1. What is project NPV in the best case scenario, that is, assuming all variables take on the best possible value?
2. What is project NPV in the worst case scenario?

Scenario

You are an information technology (IT) intern working for Health Network, Inc. (Health Network), a fictitious health services organization headquartered in Minneapolis, Minnesota. Health Network has over 600 employees throughout the organization and generates $500 million USD in annual revenue. The company has two additional locations in Portland, Oregon and Arlington, Virginia, which support a mix of corporate operations. Each corporate facility is located near a co-location data center, where production systems are located and managed by third-party data center hosting vendors.

Company Products

Health Network has three main products: HNetExchange, HNetPay, and HNetConnect.

HNetExchange is the primary source of revenue for the company. The service handles secure electronic medical messages that originate from its customers, such as large hospitals, which are then routed to receiving customers such as clinics.

HNetPay is a Web portal used by many of the company’s HNetExchange customers to support the management of secure payments and billing. The HNetPay Web portal, hosted at Health Network production sites, accepts various forms of payments and interacts with credit-card processing organizations much like a Web commerce shopping cart.

HNetConnect is an online directory that lists doctors, clinics, and other medical facilities to allow Health Network customers to find the right type of care at the right locations. It contains doctors’ personal information, work addresses, medical certifications, and types of services that the doctors and clinics offer. Doctors are given credentials and are able to update the information in their profile. Health Network customers, which are the hospitals and clinics, connect to all three of the company’s products using HTTPS connections. Doctors and potential patients are able to make payments and update their profiles using Internet-accessible HTTPS Web sites.

Information Technology Infrastructure Overview

Health Network operates in three production data centers that provide high availability across the company’s products. The data centers host about 1,000 production servers, and Health Network maintains 650 corporate laptops and company-issued mobile devices for its employees.

Threats Identified

Upon review of the current risk management plan, the following threats were identified:

• Loss of company data due to hardware being removed from production systems
• Loss of company information on lost or stolen company-owned assets, such as mobile devices and laptops
• Loss of customers due to production outages caused by various events, such as natural disasters, change management, unstable software, and so on
• Internet threats due to company products being accessible on the Internet
• Insider threats
• Changes in regulatory landscape that may impact operations

Management Request

Senior management at Health Network has determined that the existing risk management plan for the organization is out of date and a new risk management plan must be developed. Because of the importance of risk management to the organization, senior management is committed to and supportive of the project to develop a new plan. You have been assigned to develop this new plan.

Additional threats other than those described previously may be discovered when re-evaluating the current threat landscape during the risk assessment phase.

The budget for this project has not been defined due to senior management’s desire to react to any and all material risks that are identified within the new plan. Given the company’s annual revenue, reasonable expectations can be determined.

Project Part 2 Task 2: Business Continuity Plan (BCP)

After having reviewed and being impressed by your business impact analysis (BIA), senior management at Health Network has decided that your team must also develop a BCP. Management has allocated all funds for a BCP and your team has their full support, as well as permission to contact any of them directly for participation or inclusion in your BCP plan. You have been assigned to develop this new plan.

Winter storms on the East Coast have affected the ability of Health Network employees to reach the Arlington offices in a safe and timely manner. However, no BCP plan currently exists to address corporate operations. The Arlington office is the primary location for business units, such as Finance, Legal, and Customer Support. Some of the corporate systems, such as the payroll and accounting applications, are located only in the corporate offices. Each corporate location is able to access the other two, and a remote virtual private network (VPN) exists between each Production data center and the corporate locations.

The corporate systems are not currently being backed up and should be addressed in the new plan. The BCP should also include some details regarding how the BCP will be tested.

You may refer to the following additional resources to help you and your team develop a BCP, and you may use a BCP template if found during your research.

References:

• Guide to Business Continuity Management: Frequently Asked Questions (Protiviti, 2013),
  http://www.protiviti.com/en-US/Documents/Resource-Guides/Guide-to-BCM-Third-Edition-Protiviti.pdf
• Business Continuity Plan (Ready.gov), http://www.ready.gov/business/implementation/continuity

Evaluation Criteria and Rubrics (Ask these questions to yourself)

• Did I develop a BCP that could recover business operations while efforts are ongoing to restart pervious operations?
• Did I completely fill out a BCP template if found during their research?
• Did I completely understand BCP concepts presented in class?
• Did I develop a BCP test plan with correct processes?
• Did I create a professional, well-developed report with proper grammar, spelling, and punctuation?

Project Part 2 Task 3: Disaster Recovery Plan (DRP)

Your project on risk management, the BIA, and the BCP have been well received by senior management at Health Network. They now want you to develop a DRP in order to overcome any mishaps that might occur in the future. You may research and use National Institute of Standards and Technology (NIST) templates to develop a DRP plan for the company.

Evaluation Criteria and Rubrics (Ask these questions to yourself)

• Did I develop a DRP that could recover business operations while efforts are ongoing to restart pervious operations?
• Did I completely fill out the template found in their research?
• Did I completely understand the DRP constructs presented in class?
• Did I create a professional, well-developed report with proper grammar, spelling, and punctuation?

Prove by construction that the language A_n = { aⁱ | i is a multiple of n } is regular.

In other words the language A_n contains all strings composed of the letter a some multiple of n times

*Describe the social and the culture roles that malls play in your community?

*Beside purchasing goods,why else do you think people visit malls?

*do you think malls become communities primary culture?

what you think might cause somebody to literally emerge from a situation as the leader… Any thoughts on this?

Assume that you are an IT Security Manager who needs to develop access control policies for the following areas: networking, server administration, database administration, and physical security. Choose one area and develop five actual policies that you could provide your employees. Please explain your choices and why these policies are important.Assume that you are an IT Security Manager who needs to develop access control policies for the following areas: networking, server administration, database administration, and physical security. Choose one area and develop five actual policies that you could provide your employees. Please explain your choices and why these policies are important.

REVIEW: KNOWLEDGE MANAGEMENT AND KNOWLEDGE MANAGEMENT SYSTEMS: CONCEPTUAL FOUNDATIONS AND RESEARCH ISSUES

Explain the following in summary;

1 a) Knowledge Storage and Retrieval and related research issues

b) Knowledge Transfer and related research issues

c) Knowledge Application and related research issues

Meteorology: Storms Weather-wise magazine is published in association with the American Meteorological society. Volume 46, Number 6 has a rating system to classify Nor’easter storms that frequently hit New England states and can cause much damage near the ocean coast. A severe storm has an average peak wave height of 16.4 feet for waves hitting the shore. Suppose that a Nor’easter is in progress at the severe storm class rating.

(a) Let us say that we want to set up a statistical test to see if the wave action (i.e, height) is dying down or getting worse. What would be the null hypothesis regarding average wave height?

(b) If you wanted to test the hypothesis that the storm is getting worse, what would you use for the alternate hypothesis?

(c) If you wanted to test the hypothesis that the waves are dying down, what would you use for the alternate hypothesis?

(d) Suppose you do not know if the storm is getting worse or dying out. You just want to test the hypothesis that the average wave height is different (either higher or lower) from the severe storm class rating. What would you use for the alternate hypothesis?

(e) For each of the tests in parts (b), (c), and (d), would the area corresponding to the P-value be on the left, on the right, or on both sides of the mean?

Describe these 4 medium-size security tools.( Wireshark, nmap, Snort, SQLMap)

Reflect and assess your leadership skills: use inventories from class as well as others you’ve taken, feedback you have received from various individuals, etc. to identify your strengths and weaknesses