There are two elements for the submission:An Excel workbook with your results.A report of about 1000 words (+/- 150 words not including legends to figures) which writes up your analysis of the 5 tasks listed below.Consider a UK fund currently holding an international equity portfolio with the following characteristics:£1m invested in UK stocks in the FTSE 100 index, with a % portfolio beta relative to the FTSE 100 of 1.5£2m invested in European stocks in the STOXX 50 index, with a % portfolio beta relative to the STOXX50 of 1£3m invested in US stocks in the S&P 500 index, with a % portfolio beta relative to the S&P 500 of 1.75£4m invested in Chinese stocks from the SSE index, with a % portfolio beta relative to the SSE index of 2.25Suppose the risk factor returns follow correlated normal i.i.d. processes.Tasks: (Each task carries a weight of 20% in final grade)Use the historical daily risk factor closing price data in the Excel spreadsheet provided at the bottom of this page to calculate the daily returns and hence estimate the volatilities of all the risk factors – and their correlations – over the entire data period.Calculate the vector of portfolio betas in £ terms.Define the normal linear Value-at-Risk (VaR) model and apply the model to calculate the 1% 10-day total systematic VaR for this portfolio. Interpret your result and discuss how it changes with the holding period and significance level.Decompose this total VaR into Equity and Foreign Exchange (FX) VaR components. Explore how the VaR decomposition changes with different values for the risk factor correlations and explain your results. Why do some values for correlation fail to produce meaningful answers?Now perform a stress test for the portfolio by selecting some different values for the volatilities and correlations which are appropriate to stressful market conditions, and again comment on your results.Instructions and Marks Awarded:Start by building your Excel workbook. You may adapt any relevant Excel spreadsheets used in this module for your own calculations.Use the workbook to perform the tasks listed above. Attribute each task to a different spreadsheet in your workbook, so there are 5 spreadsheets labelled Task 1 to Task 5.Do not use any macros but type the formulae directly in the cells, exactly as done in lectures and seminars. Do not annotate your workbook but collate all relevant results in a report.Write your report based on the tables and/or figures in your spreadsheet. The title page contains your candidate number, an abstract of no more than 100 words which does not contribute to your word count, and the final word count. Penalties are incremental for any deviations of the final count from the interval [850, 1150].There should be 5 sections in the report, one corresponding to each task. In each section there are 10 marks awarded for the Excel spreadsheet and 10 for the presentation of results in the report.Thank you!! 😊

Part A: Safety and Security in the WorkplaceDiscuss some of the common safety and security concerns in today's workplace. What are some important laws that may help organizations reduce risk? What are some strategies HR managers can develop to mitigate some of these issues? Use the resources provided to support your ideas.Part B: Employee and Labor RelationsOutline what legal and statutory protections are in place today to prevent worker abuse. What additional protections are needed? What industries or jobs do you think could become the next fertile area for union organizing attempts?

Being able to participate in and contribute to an effective team is crucial in today’s work world. Many corporations use ad hoc work teams to accomplish their goals, projects, tasks or initiatives. Learning to work effectively in teams is therefore a skill that employers are seeking in their new hires. Once you feel confident in your ability to work in teams, you can in turn include that skill in your résumé.The foci of your assigned readings in Chapters 8, 9, and 10 are motivation, groups, and teams. These readings along with your Learning Activities should be of assistance in completing this Assessment in a Microsoft® PowerPoint®presentation.The following Course Outcomes are assessed in this Assignment:MT302-4: Apply teamwork concepts to an organizational problem.PC-1.2: Contribute to team goals and objectives through active participation and collaboration.Team Assignment: Assignment 1:In this Assignment you will participate in a team to address an organization’s problem. Read the scenario below, and address the checklist items regarding a work team.Instructions:For this Assignment 1 you will work in teams as assigned by your instructor in Unit 4. You will join your assigned team below Unit 10 in the Team Area. Go to the "Team Area" below Unit 10 and select "Team Area Discussion," then scroll down and when you see "Filter by: all groups" click on “All groups” then you will see the option to choose Team 1, 2, 3, etc., in the dropdown menu.There you will address the following scenario addressing all the checklist items, and designate a person to submit the final team presentation response to the Unit 6 Dropbox. Once complete, each team member will be responsible for submitting his/her own peer evaluation form to the Unit 6 Peer Evaluation Assignment 2 Dropbox demonstrating how they contributed to the assigned team goals and objectives.Access the Learning Activities and readings to assist the team in addressing the checklist items.Scenario (fictional):Artificial Intelligence Medical (i.e., AIM) Inc. is a very profitable new company. Although it has only been in business for two years, it has already doubled the size of its workforce and quadrupled its profits. The CEO/founder has stepped aside recently in favor of a new CEO in the wake of employees’ frustration and social media messages about the benefits inequity and lack of motivation for teams at the company. The new CEO wants to change the way executive salaries are determined and find ways to motivate the project teams. The project teams typically are assigned to an artificial intelligence product such as a robot to perform routine surgeries or diagnostic software used by different medical units of a hospital for patient diagnosis.The new CEO has tasked your team of employees with determining a general proposed solution to the inequity in pay at the company and to address the lack of motivation for the 125 technicians and medical staff that work in project teams of 25 employees each. Each technician or staff member receives a salary of $35,000 per year while the CEO and V.P.s receive $500,000 per year (the CEO also holds 10% of the company stock) and the managers receive $50,000 per year. There is a CEO, 2 VPs (Manufacturing and Finance), a Marketing Manager, a Sales/Customer Service Manager, and a Technical Support Manager along with the 125 technology-savvy employees working at the company.Access the Learning Activities and readings to assist the team in addressing the checklist items.Checklist: After identifying the team letter/number and members on the title slide:Describe the problems based on the scenario.Describe the overall goal(s) and objectives of your assigned team.Describe the tasks necessary to realize a successful response to the new CEO, allocating tasks for each member.Provide a proposed overall salary/benefits solution and provide your team’s reasoning. Support the solution with a short citation from each of two (2) scholarly* articles (citations and references in APA format).Apply at least two teamwork concepts and at least six (6) team process steps from the Learning Activity for improving the company project team effectiveness and motivation at AIM Inc. to address the assigned response to the CEO.Explain how each of you, as a team member, contributed to the team success to address the CEO’s concerns.Have the assigned team member submit the team PowerPoint presentation in a minimum of 10 slides with additional title and reference slides using 24-point font and correct spelling and grammar, to the Unit 6 Assignment Dropbox. The presentation should be titled Team X_Unit 6 Assignment (insert assigned team letter in place of X) and each slide should have no more than five bulleted points and explanations should be placed below each slide in the notes section or provide an audio explanation for each slide. If audio explanation is chosen, it must be audible and intelligible.*Scholarly sources have been put through a peer-review by experts to ascertain that the content is original, proves any statements or claims with viable research, etc. Select “Library” under the Academic Tools area. Then select “Peer Reviewed” before doing your search on a topic.