Free Essay

Risk Managmeent

In: Business and Management

Submitted By cknapik
Words 2318
Pages 10
1. Analyze strategic pre-incident changes the company would follow to ensure the well-being of the enterprise.

Pre-incident plan for changes the company should take in advance of a disaster. First, our company needs to develop a team which should consist of someone from each department. The next order of business would be to organize, develop and administer a preparedness program that should include training, procedures, etc. With EPLAN, the main pieces for a disaster program would be around data. This company data is its key. This does not just contain customer data, but each individual’s data and their work needs to be backed up. Also they will need a plan for backing up all human resources filing and information, billing and finance and marketing data. First steps would be for the team to assemble a list of what are some of the hazards and assess the risks of losing this data. Second they would need to conduct an impact analysis plan to see if this will hurt the business. Third examine ways to prevent hazards from happening. With a company such as EPLAN, the team would evaluate all data and where the data is housed. Some servers are currently overseas but most data is stored in the office of Farmington Hills, MI. The server room is not protected by any Fire protection walls. The company data for employees are on their computers and are currently not being backed up onto the server as most of the employees work from home. The only employees that are backed up on the server are out of the Farmington Hills office. This office is where the Finance and human resource departments are located. So all of the electronic documentation is housed on the in house server but there currently they do not have a data warehouse to back up this data. All marketing data is housed on the marketing manager’s computer with no back up. This position works out of the home and has all data on laptop. Now that we know where each data location is stored, we can take it to the next step of what to do in advance of a disaster. First is the concern of the main customer data and any technical support data that is housed on the internal server. There are two things that need to be addressed in this scenario. One – current server room set up and two – data warehouse location for backup. The plan needs to include a fire safe room for all servers so in the case of a fire, the data is protected. Second, routing to a data center. First thing to think about it is where to house the data. If a natural disaster where to hit this area, we do not want all data in the same vicinity. Most likely in a different climate at least 3-4 states over or more. Currently we have a sister company based in Houston and some of the employees work out of this location so it would be a good contender for a data warehouse location. Next is the concern of all employees who are not currently on any server. Each employee should be given a back up drive to house all data. There should be processes that every so many days that the employees are required to back up data on this drive. This isn’t the best solution so the company can look into a possible cloud service for backing up data. 2. Analyze the ethical use and protection of sensitive data.

All customers have the right to have protection of their data whether they consider it to be sensitive or not. As a business, we need to be sure that we are ethical with their data and protect it at all costs. Not only do we need to protect our customer’s data but also our employees. Our employees trust that any information given to the company in confidence will be protected such as social security numbers, payroll information, any reviews, write ups, complaints filed and much more.
First let’s discuss our strategy on protection of sensitive data and the ethical use of this data for our customers and what this data entails. This data needs to be protected and comply with laws, regulations, policies within the country and company. We have legal and ethical responsibilities to protect the privacy and confidentiality of all gathered customer data. We will need to create a privacy and confidential policy for all customer data with guidelines and procedures on how to protect their data. Also since some companies pay with credit card information there needs to be Data Security Standards for all payments made by credit card.
First we need to create degree of data sensitivity levels. Bottom level is public that is defined as not protected and made public to employees. This data could include basic policies of how the company is to use data. What is included publically in their contracts? Middle level is sensitive that is data that is not disclosed without good reason due to private information and is protected by company procedures and have high ethical standards. This data is data that cannot be disclosed without the right clearance level in the company. The next level is confidential. This level is the most highly protected data such as company financial records; credit card information which needs to be protected by security standards and this is anything that is protected by laws, regulations, and our contracts.
Employees also need procedures on how to protect individual privacy and reducing the potential for identity theft. First we need to create degree of sensitivity levels for data for employee too. Bottom level is public that is defined as not protected and made public to anyone in the organization. This data could include basic policies of the company such as dress codes, work hours, employee handbooks. Middle level is sensitive that is data that is not disclosed without good reason due to private information and is protected by company procedures and have high ethical standards. This data includes employment data such as salary data, employee personal information such as race/ethnicity, any special needs, etc. The next level is confidential. This level is the most highly protected data such as employees reviews, any financial data such as 401k, social security numbers, date of birth, drivers license #’s, health records and any banking information.
Now that we know what data levels are assigned, we need to know how to protect the data in case of emergency. One of the simplest strategies is strong passwords. Making sure that employees follow a strong password policy such as capital letters, numerical values, symbols are some examples. This will protect the information for the customers they are working on. Limiting access to all customer data is also important. Just because an employee works with a customer does not mean that they should have access to all data. So clearance levels should be in effect due to job titles. Another factor is a high security data system. Protecting the customer data is first priority. Encryption of all data is necessary and finding the right tools to be effective will be important. Also an anti-phishing software program is another option. It will alert you to any fraudulent activities when detected against your customer’s data.
Having firewalls, anti-phishing, levels of security are important but educating the employees is even more important. Developing policies and regular training for employees on how to handle customer data is extremely important. Regular updating of documentation and policies will go far in protecting all data. This works the same for personal employee information. 3. Analyze the ethical use and protection of customer records.

First we need to analyze the ethical use and protection of our customer’s records. This is a common threat to any organizations information systems. It comes from inadequate protection of company information and data. There are many risks that go with unauthorized activity of customer data. The impacts are negative and not always considered during the risks assessments of their data.
Through the business impact analysis/risk assessment phase, the organization will evaluate its security process for all of its internal and external data and how well their security system holds up to external viruses and usage. The loss, destruction and/or disclosure of company data and information may have far more significant consequences and should be included for consideration in the continuity process (The Definitive Handbook of Business Continuity Management, ch. 16 ).
This first stage involves the analysis and decision-making that will feed into planning and strategy to ensure overall business continuity for the organization as well as to understand which approaches are needed throughout the organization in order to deliver a workable information availability strategy. Often this process will involve an external consultant and/or one or more individuals in the organization in order to understand the internal and external pieces of the business which involve both the business and IT operations. By prioritizing their importance and time criticality companies can begin to determine the directions the information availability strategy will lead as well as which individuals within the company should run it. Once plans have been formulated, keeping them in line with the organization is very important to the ongoing success of the company, this shows the need for business continuity provision to incorporate ongoing plan maintenance and testing, which will highlight any changes required as the business moves.
After the organization decides which data is sensitive and which data needs to be protected, they have formulated their strategy to protect the data. Now how do they know this strategy will work? They need to test it with a pilot group that has certain rights depending on their clearance level. By testing to make sure the employees cannot access the sensitive data will ensure that the policies are in effect.

4. Discuss the communication plan to be used during and following the disruption.

Our communication plan includes a brief background of the plan, who it involves (stakeholder analysis), clear objectives, strategy for communicating the plan, and potential issues and risks of the plan. This plan is to address any customer and employee communication, safety and security of their protected information, recovery of information due to a disaster and how to communicate this plan to all stakeholders. Our stakeholders include customers, employees and executives. Everyone it may affect. The customers are affected by the data they provide to the company. During the disruption, all customers will be informed that their data is protected by the security measures that have been put into place by IT with an expected timeline for resolution. They should already have copies of all policies on risk management by the company. Next they need to be informed on the strategies that have been put into place to recover the data. It is extremely important that the customer be involved through all the steps so that they are secure with the company. Next the need to communicate to them after the data has been recovered and depending on the situation of data loss, how they will be able to access their data. If it was a facility fire, the location of the back up facility and the server information that will be encoded for their specific company needs to be communicated. Next, the employees will need the same assurance that their personal data will not be leaked out. So again through the company policies and efforts, the company will need to communicate the security measures that were taken to keep their data safe. The encryption, servers, etc. Lastly, the executives need to be briefed on all moving parts. This communication is essential to the business as they are the ones that will be face to face with all people involved.
Communication Plan for Customers
Customers require accurate, timely and apologetic communications, usually via email including: * What products or services you won’t be able to provide at the usual times * What alternate accommodations they can make * Any compensation we plan to make depending on the disaster * Timeframe of the expected resolution
Communication Plan for Employees * HR to keep open communication with Employees and ensure that their personal information has not been compromised * Follow up with them on the risk management strategies that have been put into place * Keep communication open to resolve any concerns employees have about the recovery

5. Discuss restoring operations after the disruption has occurred (post-incident).

Restoring operations after a disruption is one of the most common pieces to any disaster plan. The most common and most effective plan is data backup which EPLAN uses. This recovery is done by retrieving the data from their data warehouse that is in compliance with all regulations. This warehouse can be accessed externally through a cloud server. This is important to keep backups done daily with a backup tape system. This way historical data is not compromised.
Now, there is the concern of restoring actual operations if a disaster occurs. The Information technology team would work with the data warehouse to make sure the data for our customers and internal employees has been restored but being an international company, most of our data is housed on our German server so operations will not be affected. All employees will be able to access the same data through their own portable laptops and Germany’s server. Germany and other countries will be able to back up our technicians for support calls if needed. This is part of our recovery policy for all countries. The customer’s should not feel any downtime due to our recovery time. The main part will be making sure everything is secure and that the employee records are secure. The team will have to follow our recovery plan and checklist to ensure that everything is safe and accessible to the right teams.

Similar Documents

Premium Essay

Assessing Materality and Risk Simulation

...TEAM B TEAM B ------------------------------------------------- Assessing Materiality and Risk Simulation University of Phoenix ACC/491 Dwayne Thompson March 10, 2013 ------------------------------------------------- Assessing Materiality and Risk Simulation University of Phoenix ACC/491 Dwayne Thompson March 10, 2013 The objective of the audit of financial statements is to enable the auditor to express an opinion if the financial statements are prepared in accordance with an identified financial reporting framework. The reason that materiality is allocated to those accounts sampled because materiality represents the magnitude of an omission or misstatement of an item in a financial report. The three function of the audit risk are inherent risk (IR), control risk (CR), and detection risk (DR). Every level of audit risk has an opposite connection that exists between assessed levels of controls, inherent risk, and level of detection risk Why do certain accounts have to be audited 100%? Accounts need to be audited 100% so the users of the financial statements can rely on the information and be able to make decisions for investment purposes. It also helps management make sure the company is profitable as well as following rules and regulations of the accounting standards and policies. Auditing accounts are done to protect the investors, shareholders, banks, and to give assurance that the information...

Words: 804 - Pages: 4

Premium Essay

Change Management

...| Entrepreneurship | SBMG 6006 | | Discussion on an importance of risk taking and innovation in entrepreneurship. | | 7/14/2011 | | Executive summary: - This academic work explores that how risk taking and innovation play an important role in entrepreneurship process. This report provides critical view about these given topics by examined different models, theories and opinions of different authors etc. This report also puts light on differences between term entrepreneurship and entrepreneur. Methodology: - Introduction: - Entrepreneurship is a dynamic process of vision, change and innovation. It requires an application of energy and passion toward the creation and implementation of new ideas and creative solutions. Entrepreneurship has been categorized in different skills such as inner control, planning and goal setting, risk taking, innovation, reality perception, use of feedback, decision making and human relation etc. Miller (1983) defines entrepreneurship as a multidimensional concept encompassing a company’s action relating to innovation and risk taking and proactive measures.Innovation and risk-taking has an important place in entrepreneurship. Schumpeter (1994) described role of entrepreneurship as tendency of company to engage in and support new ideas, novelty, and experimentation that may result in new products, services. Risk taking describes the nature of entrepreneur. A.H. Cole has explained entrepreneurship as, “the...

Words: 307 - Pages: 2

Premium Essay

The Cost of Capital, Corporation Finance and the of Investmient

...THE COST OF CAPITAL, CORPORATION FINANCE AND THE OF INVESTMIENT In the business world we make investment for two main reasons or either of them that can be for the maximization of our profite from a business or it can be for the maximaization of the market value of the assets. Businesses generally aquire the assets if the perceives that the particular asset can help in increasing the profit of the organisation. According to the theory the acquisition of the asset can help to increase the profit only if the returns arising due to that asset are more than the interest costs arising due to that asset. On the individual level when we are cosidering the purchase of any asset we should also consider the risk factor associated with that asset. Profit maximization and value maximization they both have more or less same meanings and implications. But if the case is of uncertainity then the profit maximization has no meanings, it remains meaningless for the investors. When the situation is uncertain then in that case the market value maximization becomes the basis for the theory of investment, if this notion is kept in mind then every time when we are going to make a decision to invest or not we should simply keep one thing in our mind that can be the basis of the decision, that is if we aquire the particular asset will it help to increase the value of the firm’s share? If in response of this question we comes on this point that yes it will result in increase in the value of the firm’s...

Words: 300 - Pages: 2

Premium Essay

A Rose by Any Other Name Case Study

...retailers. However, pursuing this option would drain Rose’s resources and prevent them from launching their own branded goods. Additionally private-labels would make Rose into a manufacturer-only role and limit its long-term prospects, but having its own brand is very costly to promote and comes with many short-term risks. Possible Solutions: 1. Proceed with Rose Partyware branded party supplies. * Retain loyalty of small independent retailers (35% of sales) * Brand advantage in party supplies versus other generic suppliers * Positive long-term returns * Control over pricing, branding, and distribution of goods * Short-term technological advantage 2. Pursue manufacturing private-label goods for retailers. * Retain largest Rose customer (20% of sales) * Supplier of choice in private-label manufacturing * Lowest short-term risk * Cheapest option in terms of change to company structure & spending The Decision: If I were in Tom Roses’ position I would choose to proceed with Rose Partyware branded party supplies and persuade Party! to hold off its test launch. While this decision would expose Rose Partyware to the short-term risk of promoting their new brand, the potential returns as well as the prospects for long-term growth results in a net advantage for Rose Partyware. The threat of operating as an easy-to-replace private-label supplier is too risky Rose Partyware despite the short-term payoff....

Words: 350 - Pages: 2

Premium Essay

Hot and Cold

...in order to improve the company. What benefits do you think the employees derive from this arrangement? There are many benefits that the employees can derive from this arrangement. If the business can decide to expand, which creates more opportunities for work and even a promotion if need to. Another example is that if the business keeps up with the latest technology, the employee will work less since technology makes life easier. As machinery innovates as the year passes. With a HR, the employees will have several more benefits and will be protective in case of an accident where to occur at work. What do you think are the risks involved (to HR and the organization as a whole) if HR does not make this a priority and instead remains a purely task-oriented department mostly administrative in nature? In a business everything is a risk there or not there will be a HR or not. However, a HR is a useful organization that can help the business if handle properly with the right decision obviously. By finding the “middle ground” as we say, in order to keep the employees satisfied and at the same time keeps the production going the outcome should be a total...

Words: 324 - Pages: 2

Premium Essay

Case Study

...* Posted on: Wednesday, March 13, 2013 Apache Questions 1.     What risks does Apache face? Do they differ by country of property type?  Do the risks of the major integrated oil companies differ from those faced by Apache or other independents?  How does Apache’s operating strategy affect its risk exposures?  2.     What is Apache doing now to manage risk?  What risks are they attempting to hedge? What are its competitors doing? 3.     What are the potential hazards Apache faces if it manages risk? 4.     As a member of Apache’s board, how would you recommend they proceed?  If they decide to manage risk, what steps should they take? Which risks should they shed? Which risks should they retain/keep? Should they manage some types of risks but not others?  Some types of investment decisions but not others? How should FAS 133 affect their strategy?   Case Study Questions Each team is required to address the four questions posted above.  You should view your case report as a report to senior management or the board of directors. It is to provide the decision makers with all relevant information of a particular case and your policy recommendation, using the assigned questions as a guide.   There is no formal size limit for a case report, but you should keep in mind that conciseness and clarity make reports more convincing and will be rewarded accordingly. In particular, a summary of the facts from the case should not include the facts that are not relevant to your analysis...

Words: 514 - Pages: 3

Free Essay

Summary

...Decision and Risk Analysis for the evaluation of Strategic Options The process of evaluating and selecting options is complicated involving high stakes, a mount of diverse and dispersed data, multiple and conflicting objectives, uncertainty regarding the future and different stakeholders have different views and considerations. Strategy evaluation is a complex social-technical process=>decision and risk analysis is a powerful way to approach it. Understanding the decision situation Tool: scenarios planning, SWOT/TOWS analysis. The identification and develop fundamental objectives is typically informed by setting “strategic direction and goals “ element of the strategic development process. tool: use value tree (top down approach or bottom up approach: start from the attributes and them identify the objectives) associated attribute should be specified, three types of attributes: Quantitative direct ,Quantitative indirect, Qualitative attributes. Each attribute should follow five properties: Comprehensive: the upper and lower limits of attributes are well specified. Otherwise it will distort out trade-off When building a value tree, fundamental objectives must follow the following properties: Preferential independence: Sometimes, it’s difficult to avoid preferential independence. A practical way of dealing with preferential dependence is to redefine the objectives, usually aggregating two dependent objectives into single one. Notice also that statistical...

Words: 666 - Pages: 3

Premium Essay

Bank of Tokyo-Mitsubishi Ufj, Ltd.

...OVERVIEW……………………………………………2 - History of Japanese Economy - Japanese Financial & Banking System - Mitsubishi UFJ Financial Group BANK OF TOKYO MITSUBISHI UFJ………………16 - Structure - Rating - Capital - Competition - Services BANK MANAGEMENT ANALYSIS…………...……29 - Asset Management - Liability Management - Risk Management - Other Developments (Social Responsibilities) REPORTS ANALYSIS………………………………..35 - Financial Sheets - Financial Ratios FORECASTING……………………………………….38 - Forecasted Financial Sheets CONCLUSION………………………………………...40 I. OVERVIEW A) History of Japanese Economy The Japanese economy is the 3rd largest economy in the world, coming right behind the American economy and the economy of China. It’s one of the most studied economies among all due to its rapid growth in different eras. Its economy first interacted with Europe in the 16th century, and the Europeans were admirers of the country as it was one of the richest in metals and became a major exporter of copper and silver. In 1603, which is the beginning of the Edo period, the interaction between the Japanese and Europeans was extremely intense, and that, however, exposed Japan to Christianization waves, which lead Japan to enter a period of isolation in order to avoid such religious waves. Significant expansion of domestic industries increased during this phase. The construction trade grew along with banking dealing activities. The Edo period ended in 1868, and by that time Japan...

Words: 4633 - Pages: 19

Premium Essay

Dgjihwdegi

...ASSESSMENT ITEM 1—WRITTEN ASSIGNMENT Due date: Weighting: Length: Week 6 40% Less than 5MB ASSESSMENT 1 OBJECTIVES This assessment item related to course learning outcomes 1, 2 and 6. QUESTION 1 (5 MARKS) List and describe the major components of BI. What are the major similarities and differences between DSS and BI? QUESTION 2 (20 MARKS) XYZ is a manufacturing company specialising in a variety of dairy products. The company is planning to launch a new product in the Australian market. The product development group claims that the anticipated net present value for the new product is over $1,000,000 (one million dollars) and they have recommended the project to proceed. Your task is to check the group‟s claim to determine if it is reasonable. In doing so, you are required to develop a decision support system using Visual DSS. This decision support system will be used to assist the management of the company to make an informed decision about manufacturing of the new product. Table 1 summarises the related information. Cost of production: $7.25 per unit Annual overhead cost: $1,000,000 Initial investment needed: $5,000,000 Estimated selling price: $15.75 per unit Market at time of introduction: 900,000 units per year Market growth: 9.5% per year Market share: 36% Assumed economically useful lifetime: 5 years, commencing in 2014 Discount rate used to analyse new product proposals is 12% Table 1: Production details 1 Your task details: 1. Develop...

Words: 973 - Pages: 4

Premium Essay

Ppt Nursing Home Presentation

...Decision-Making Case Study HCS/514 Ed Paluch Decision-Making Case Study It has been estimated that approximately 75% of the average managers time is spent on the decision-making process (Free Case Study on Decision Making, 2011). A critical component in managing an organization, its staff and resources is successful decision-making. The quality and efficiency of those decisions will determine how well the manager is doing. Managers have plenty of responsibility because they are the ones that have to make the right decision when solving issues. Today, decision-making regarding health services for consumers and patients are becoming guided by evidence of need, effectiveness, and ways to use resources optimally. This is becoming a growing model among health care organizations and its managers. However, there are barriers for managers in using evidence decision-making. Time is a big barrier, there are deadlines that managers usually have to work with that is very time consuming. For instance, plenty of time is required to research, accessing relevant data, reliance on outside consultants and subordinates in acquiring quality information, politics, and lack of resources. The use of an sufficient decision-making tool that assists managers in efficiently making strategic, evidence based decision-making as well as improving the performance of their organizations is the Informed Decisions Toolbox as outlined by Thomas Rundall. The Informed Decisions Toolbox is...

Words: 1125 - Pages: 5

Premium Essay

Marketing Practices in Rural India

...Current Marketing Practices in Consumer Durables in Rural India Contents Introduction ........................................................................................................... 3 Indian Rural Market: ........................................................................................... 3 Recent shift in attention from urban to rural market:......................................... 3 Special Features of rural markets: ...................................................................... 4 Methodology ......................................................................................................... 6 Questionnaire ........................................................................................................ 7 Responses .............................................................................................................. 8 Respondent 1...................................................................................................... 8 Respondent 2...................................................................................................... 9 Respondent 3.................................................................................................... 11 Learnings from the Project................................................................................... 14 Awareness ........................................................................................................ 14 Acceptability .......................

Words: 2902 - Pages: 12

Premium Essay

Finance

...Compiled by Allan Simiyu for BBM 312 Students only 1 CHAPTER ONE INTRODUCTION 1.1 Introduction Whether a business concern is big or small, it needs finance to fulfill its business activities. Finance may be defined as the art and science of managing money. According to Oxford dictionary, the word ‗finance‘ connotes ‗management of money‘. Webster‘s Ninth New Collegiate Dictionary defines finance as ―the Science on study of the management of funds‘ and the management of funds as the system that includes the circulation of money, the granting of credit, the making of investments, and the provision of banking facilities. Therefore, Finance is defined as the procurement of funds and their effective utilization in business concerns. The concept of finance includes capital, funds, money, and amount. But each word has a unique meaning. Studying and understanding the concept of finance become has an important part of the business concern. 1.2 Corporate Finance Financial Management or corporate finance, deals with procurement of funds and their effective utilization in the business entities. Financial management is the broadest of the three areas of finance and is important in all types of businesses including banks, financial institutions, industrial concerns, and retail firms, governmental institutions such as schools, hospitals and even local governmental departments. Corporate finance is concerned with budgeting, financial forecasting, cash management, credit administration,...

Words: 23807 - Pages: 96

Premium Essay

Decision Making Process Paper

...Decision Making Process Paper Tiffany Camphouse November 21, 2011 MGT 230 A time in my life that I had to make a personal decision was when I decided to move. I had a pretty good job, but the rest of my family was moving away, and I did not want to be the only one left there. I had been working at my job for just over a year, and had just recently found out that I was pregnant for the first time. My boyfriend and I had our own place, but neither one of us had a vehicle. With my family planning to move out of state I was forced to make a decision. I had to decide if I was going to move closer to my job, or quit my job and move closer to my boyfriend’s parents, or move back to the place that I was born and raised for most of my life. The first thing that I did when I found out that I was going to have to move was talk to my boyfriend. He said that he didn’t know what we should do, but he didn’t want to move to the town that was close to my job. He felt that the town was too small, and the fact that we did not know anyone there was the other reason. The next thing that we did was talk about who’s parents we were going to move with. I wanted to move with my parents, because I was seven months pregnant and wanted to be with my mom to have the baby. He was torn because he had never been more than a few hours away from his mom, but he thought it would be cool to see some place new. After about three weeks of discussing our options we came to an agreement on moving...

Words: 678 - Pages: 3

Premium Essay

Solutions

...Selecting the optimum Health Care Coverage Plan <<your name>> <<instructor’s name>> <<course title>> <<date>> Assume you are the HR Director for a midsized company and must make a decision about the company’s employee benefits package. You have not been in this position before and must maintain the current benefits budget; there may be no increases or changes to the package that will result in additional spending. 1. Describe the selection process you would use to make the most cost-effective and employee-friendly decision. Answer – Choosing the right type of benefits package is a very critical component of being attractive employer, helping attract and retain satisfied employees, by ensuring that majority of employee needs are taken care of. Given the huge number of options that are available in the market, with many more coming up every year, it becomes very tricky to determine what benefits package would be the most beneficial to the employee. Given the constraints on budgets, there must be multiple trade offs made between the extent and variety of benefits provided, and therefore the employer has to determine which package would cover the needs of majority of its employees. In this scenario, given that the available budget is fixed and the benefit plan for the next year has to at least as good as or even better than the previous year, the HR director has to think creatively to come up with a package that best aligns...

Words: 1853 - Pages: 8

Free Essay

Portfolio Analytics

...Portfolio Analytics 1. Introduction: To analyze our portfolio and determine its exposure to risk factors, we assumed that: Rit+1=a+bi,1F1t+bi,2F2t+…+bi,nFnt+eit+1 First, we calculated z-score for logarithm of b_p and logarithm of cap to determine sensitivities for stock-specific factors. After we got all 13 sensitivities, we did a weighted regression of the 13 sensitivities against the 1000 stock’s forward return in 60 periods, respectively. For each period, we got 13 coefficients, which were the risk premiums for each risk factor. Finally, we regressed the risk premium from our regression against the portfolio return, bench return and active return. Doing so, we get these returns’ sensitivities against risk factors and were able to determine our portfolio’s exposure to various risk factors. 2. Procedures and Analysis 2.1. Working Procedure Nearly all of the calculations in part II were done by VBA Macros. In the Project part2.xlsm, there were 6 worksheets. The Data recorded all the cross-sectional data for 60 periods, having 1000 stocks in each period. StockPriceData recorded the data for stocks in our portfolio. To run the regression, we assumed that for a particular stock, the forward return in a particular period was, rt+1=bisec10λsec10+…+bisec55λsec55+bibetaλbeta+bilnbpλlnbp+bilncpλlncp+e . The equation has no intercept, the risk premium for sector factor has already included the zero beta rate. To prevent stocks with smaller market capitalization...

Words: 1386 - Pages: 6