Expert Answers

Hello, I need help with my Lab 5 Excel assignment/project, and I provide all the steps and the links that are required. Please confirm with me that you can access the files I provided.

Your senior leader has asked you to create a presentation for the group of managers about choosing appropriate communication methods and strategies for communicating effectively, taking into consideration the purpose of your message, your audience, and your context. In this case, you will want to highlight considerations for virtual teams, as well as culture, since Mexico is considered a higher-context culture compared to the United States. Your presentation must include a title slide and references slides that include appropriate academic and professional support for your ideas. You will also need to provide a script that you would use if you were delivering your presentation to your fellow group of U.S.-based managers. Each content slide should contain 3 to 5 bullet points (no more than 1 sentence each), with additional details and explanation provided in the accompanying script. The objectives for your presentation are as follows: Provide some basic information on the key components and process of communication. Highlight the importance of self-awareness and being a competent “sender.” Help the managers understand key considerations when communicating in a virtual team. Provide guidance about communicating effectively with those from a higher-context environment (such as Mexico) than the United States. Give the managers a framework that will help them plan for and run effective team meetings. Your presentation should include the following: Click each of the items below for more information on this Assessment. INTRODUCTION Provide an introductory slide that grabs the audience’s attention and answers the “why you should listen” question for the audience. The script that accompanies this slide should introduce the topic and purpose of the presentation and provide the key objectives for the presentation. (1 slide) PART 1: THE COMMUNICATION PROCESS Examine components of the communication process. Briefly define communication. Identify the parts of the process and how they work together to promote effective communication. (1–2 slides) Illustrate the importance of self-awareness in communication, including what it means to be a competent “sender.” (1 slide) Include one transition (“review/preview”) slide that offers a compelling conclusion to the material you just presented and connects to the material you are presenting next. The script contents should keep the audience engaged. (1 slide) PART 2: CONSIDERING CULTURE AND CONTEXT Develop three to five clear, specific, and actionable recommendations for communicating effectively in virtual teams. (1 slide) Synthesize three to five clear, specific, and actionable recommendations for communicating effectively in high-context, low-context, and mixed-context cultures. (3 slides) Include one transition (“review/preview”) slide that offers a compelling conclusion to the material you just presented and connects to the material you are presenting next. The script contents should keep the audience engaged. (1 slide) PART 3: PLANNING FOR TEAM MEETINGS Identify best practices for: Clarifying the purposes and outcomes of the meeting (1 slide) Including a team cohesion activity (1 slide) Clarifying types of outcomes for agenda items (1 slide) Sharing discussion leadership (1 slide) Managing time (1 slide) Evaluating the meeting (1 slide) Reviewing action items (1 slide) For each item, support the best practice identified with at least one source. CONCLUSION Provide one concluding slide in which you summarize key points and reinforce suggested practices through the script contents. (1 slide)

Students have benefited from using their reading logs as a permanent record of useful ideas and applications from the readings. The goal is to provide you an easily accessible set of resources when you are at work. Please refer to supplemental instructions for this reading log only. Use of a large language model to generate a second "duplicate" reading log is required for this assignment (cf. below). Instructions Select ONE reading from the Week 5, 6, and 7 readings. Following are some guidelines for your reading logs. Respond critically to the articles. Don’t summarize them. If you disagree (or agree) with a key idea, explain why. Provide an alternative view or position that you justify with a persuasive argument and/or specific example or experience that validates (or invalidates) article concepts. What applications does the reading have for you as a manager? What did you learn? Be specific and concise in referencing and applying concepts from the article. Don’t try to address too many points. The best logs focus on critiquing a few key points in the article. Reading logs aren’t bullet points, they’re analytical essays. Include a brief (1-2 sentence) intro of your main ideas, one key idea per paragraph, and a brief (1-2 sentence) conclusion. The best reading logs are concise (maximum about 750 words or pages double-spaced) For your reading log #2, I'd like you to use Chat GPT (or any similar Large Language Model) to generate a reading log on the article (or topic) you're writing about using these guidelines: Write your regular reading log according to the specifications noted in the bullet points above. Use Chat GPT (or any similar Large Language Model (LLM)) to write a “duplicate” reading log #2 on the focal article or topic. Document the content and number of prompts you used to generate the LLM-authored version of your reading log. E.g., it may take you several tries to get to an acceptable result. Make sure the LLM-authored log is in the same format as the one you wrote (e.g., about 750 words). Do not edit the final LLM-authored log. Write a paragraph (< 200 words) reflecting on what you learned from this exercise. E.g., do you think the LLM did anything better than you? Worse than you? Was the result of sufficient quality? Why or why not? Put the content for steps 1-3 in one document and upload it to the Turn it in assignment. It should be about 1700 words max (750 words for your original reading log, 750 words for the LLM version, 200 words for your reflection on the two).

The Company I am choosing is BlackRock. I will need you to create a research paper, finish an Excel spread sheet, and create a PowerPoint. Here are the in-depth instructions. The Project to be addressed by the Paper: You have just graduated from Keiser University’s MBA program and have secured a position as a fund manager for a well-known investment banking house. You have been given $25 million to manage/invest in a single stock. The fund is a pension/retirement fund, so its perspective is long term with moderate risk of loss of capital and a required return of 9% per annum. Your assignment is to determine if the fund you are managing should invest $25 million dollars in the stock of the company you have selected. Select a publicly traded US based company (BlackRock) Your decision to invest or not invest will be supported by the research paper, Excel spreadsheet of ratios, and a Power Point Presentation showing a SWOT analysis. NOTE: Most of the data needed for this assignment can be found in Yahoo/finance or SEC.gov. Your analysis, based on the concepts covered in this course, will address each of the following: 1)Financial Ratio Analysis (Week 2): Analyze financial ratios and cash flow measures of the company relative to its historical performance. For purposes of this research paper a 2 year look back is sufficient and required. You must use the Piotroski Method and discuss in detail the company’s profitability, capital structure, and operating efficiency based on the ratio results and comparison to its competitors. Show your calculations and use reputable sources. What trends are occurring? What are the company’s financial strengths and weaknesses? Research two (2) articles to review (one (1) peer reviewed not more than 5 years old and one (1) current year article from a reputable website. Minimum two (2) pages not including title and reference page using APA format including an Excel spreadsheet. 2)Business Strategy and Annual Report Analysis (Week 4): Discuss the business strategy and competitive strategies of the company based on the notes in their most recent 10K annual report Item 1A Risk Factors. 3)Prospective Analysis (Week 6): Create a forecast of future cash flows for the next five (5) years using the current income statement. First estimate the growth rate of revenue and expenses, to derive estimated earnings before interest and taxes. Then estimate the interest expense and tax liability to derive the net come. Create a proforma Income Statement for your company for the next 5 years and complete a sensitivity analysis. 4)During Week 7, you will combine your article reviews together as one complete research paper and add the following conclusion: Will you or will you not invest $25 million in this particular Company? Support your conclusion? Remember a negative conclusion is just as valid and valuable as a positive conclusion. What are your companies financial and strategic strengths, weaknesses, opportunities, and threats? Use the attached SWOT framework as your guide. Most important: make recommendations and answer the overarching question: to invest or not to invest? Research two (2) articles to review (one (1) peer reviewed not more than 5 years old and one (1) current year article from a reputable website. Minimum two (2) pages not including title and reference page using APA format. (a) Review and summarize the areas on the annual report that discuss: Risk Factors., Strategic, Operational and Competitive Risk, Infrastructure Risks, Supply Chain and Third-Party Risk, Economic, Global, Legal and External Risks, Financial Risk. What is the company doing to mitigate the impact of these risks? (b)Management’s Discussion and Analysis of Financial Condition and Results of Operations, what outlook does the company have for its business, its subsidiaries, its product line? Mergers or acquisitions or Goodwill transactions? (c) Review and summarize any research found regarding any public announcements of restatement of earnings or criticism due to ethics or misrepresentation? (d) What is your company’s BETA? What does it mean regarding your company’s risk? Compare the beta to its competitor Research two (2) articles to review (one (1) peer reviewed not more than 5 years old and one (1) current year article from a reputable website. Minimum three (3) pages not including title and reference page using APA format. Calculate and share the results of your company's Free Cash Flow, Value of Operations, and Value of Equity. Calculate your company’s Weighted Average Cost of Capital (WACC) and use the Capital Assets Pricing Model (CAPM) to estimate the cost of equity. (Hint: take a look at Yahoo/finance - analysts opinion). Discuss your findings. Research two (2) articles to review (one (1) peer reviewed not more than 5 years old and one (1) current year article from a reputable website. Minimum three (3) pages not including title and reference page using APA format. Conducting Library Research: Participate in a research orientation offered by the graduate librarian. Use Keiser University’s library LIRN database. Use my list of reputable sources for non-peer-review news sources. Writing the Paper: The following are general guidelines for format and organization. Format: 1)Minimum of ten (10) pages (not including self-prepared exhibits, title page or reference page), with numbered pages. 2)Typed, double spaced. 3)New Times Roman (i.e. business) font, 12 point. 4)Margins – 1 inch 5)Include boldface headings and subheadings. 6)Note source citations as appropriate under APA 7th edition guideline. Please use in-text citations. See the attached template for assistance with the organization. Preparing the Presentation: Presentations will be made in class during the last day of class. The presentation will be supported by 7 to 10 Power Point slides and will last not more than 10 minutes (Executive Committee length). Please see the week 8 instructions. Show all of your calculations clearly, number your responses, and write in your own words and complete sentences if writing is required. Please include APA format in-text citations and references, if you cite any sources.

PowerPoint presentation for Marketing Plan. 12-15 slides required. Please cover the main sections of the plan.

This assignment is worth 10 points. Read the article linked below and answer the question(s). Your answer to the question(s) should be in your own words, adhere to the expected more than 250 word count criteria, and exhibit a depth of analysis by connecting the concept to a principle in your textbook or other related articles/readings. Make sure to cite references (preferably "in-text") to support your response. You have 1 attempt for this assignment. After beginning your attempt, you may save and resume later. Only select 'Submit' after you have finalized your response .Questions: 1. What are your thoughts on Walmart's new dominance in the retail industry? 2. Would Amazon or Target feel threatened by this? Why and Why not? Note: Please answer each question separately.

How is Amazon so fast and efficient as a company? Here is my topic I chose in a paragraph summary: My term paper will focus on why Amazon is such a quick and efficient company. I'll discuss how the organization accomplishes its rapid delivery times by narrowing down a few significant factors. I'll examine how Amazon's logistics differ from those of other businesses. Amazon is faster than anyone I know of; the other companies are probably almost as efficient, but not quite as quick. Keep in mind that Amazon runs over 175 huge warehouses located near important transportation hubs, providing speedy access to merchandise. I chose this topic since I used to work at Amazon and I'm just interested in how my brother and dad receive these Amazon Prime packages in a day or two. I believe that Amazon is one of the fastest and most efficient companies, but I'm curious about the logistics and the reasoning behind that. Instructions listed below: Submit a rough draft of your paper (including at least 3 sources). Sources may include the internet, personal interview, textbook, journal articles, trade magazine articles, etc. Times New Roman 12pt and default margins, the paper should be approximately 8 pages, double spaced, not including title page, references, and any figure. The paper must reference at least three reputable sources. Please use MLA or APA citation format. The grading rubric is also attached if you need that. I attached a Grade A paper example as well.

no ai or copy and paste. Use template below.

student The Company I am choosing is BlackRock. I will need you to create a research paper, finish an Excel spread sheet, and create a PowerPoint. Here are the in-depth instructions. The Project to be addressed by the Paper: You have just graduated from Keiser University’s MBA program and have secured a position as a fund manager for a well-known investment banking house. You have been given $25 million to manage/invest in a single stock. The fund is a pension/retirement fund, so its perspective is long term with moderate risk of loss of capital and a required return of 9% per annum. Your assignment is to determine if the fund you are managing should invest $25 million dollars in the stock of the company you have selected. Select a publicly traded US based company (BlackRock) Your decision to invest or not invest will be supported by the research paper, Excel spreadsheet of ratios, and a Power Point Presentation showing a SWOT analysis. NOTE: Most of the data needed for this assignment can be found in Yahoo/finance or SEC.gov. Your analysis, based on the concepts covered in this course, will address each of the following: 1)Financial Ratio Analysis (Week 2): Analyze financial ratios and cash flow measures of the company relative to its historical performance. For purposes of this research paper a 2 year look back is sufficient and required. You must use the Piotroski Method and discuss in detail the company’s profitability, capital structure, and operating efficiency based on the ratio results and comparison to its competitors. Show your calculations and use reputable sources. What trends are occurring? What are the company’s financial strengths and weaknesses? Research two (2) articles to review (one (1) peer reviewed not more than 5 years old and one (1) current year article from a reputable website. Minimum two (2) pages not including title and reference page using APA format including an Excel spreadsheet. 2)Business Strategy and Annual Report Analysis (Week 4): Discuss the business strategy and competitive strategies of the company based on the notes in their most recent 10K annual report Item 1A Risk Factors. 3)Prospective Analysis (Week 6): Create a forecast of future cash flows for the next five (5) years using the current income statement. First estimate the growth rate of revenue and expenses, to derive estimated earnings before interest and taxes. Then estimate the interest expense and tax liability to derive the net come. Create a proforma Income Statement for your company for the next 5 years and complete a sensitivity analysis. 4)During Week 7, you will combine your article reviews together as one complete research paper and add the following conclusion: Will you or will you not invest $25 million in this particular Company? Support your conclusion? Remember a negative conclusion is just as valid and valuable as a positive conclusion. What are your companies financial and strategic strengths, weaknesses, opportunities, and threats? Use the attached SWOT framework as your guide. Most important: make recommendations and answer the overarching question: to invest or not to invest? Research two (2) articles to review (one (1) peer reviewed not more than 5 years old and one (1) current year article from a reputable website. Minimum two (2) pages not including title and reference page using APA format. (a) Review and summarize the areas on the annual report that discuss: Risk Factors., Strategic, Operational and Competitive Risk, Infrastructure Risks, Supply Chain and Third-Party Risk, Economic, Global, Legal and External Risks, Financial Risk. What is the company doing to mitigate the impact of these risks? (b)Management’s Discussion and Analysis of Financial Condition and Results of Operations, what outlook does the company have for its business, its subsidiaries, its product line? Mergers or acquisitions or Goodwill transactions? (c) Review and summarize any research found regarding any public announcements of restatement of earnings or criticism due to ethics or misrepresentation? (d) What is your company’s BETA? What does it mean regarding your company’s risk? Compare the beta to its competitor Research two (2) articles to review (one (1) peer reviewed not more than 5 years old and one (1) current year article from a reputable website. Minimum three (3) pages not including title and reference page using APA format. Calculate and share the results of your company's Free Cash Flow, Value of Operations, and Value of Equity. Calculate your company’s Weighted Average Cost of Capital (WACC) and use the Capital Assets Pricing Model (CAPM) to estimate the cost of equity. (Hint: take a look at Yahoo/finance - analysts opinion). Discuss your findings. Research two (2) articles to review (one (1) peer reviewed not more than 5 years old and one (1) current year article from a reputable website. Minimum three (3) pages not including title and reference page using APA format. Conducting Library Research: Participate in a research orientation offered by the graduate librarian. Use Keiser University’s library LIRN database. Use my list of reputable sources for non-peer-review news sources. Writing the Paper: The following are general guidelines for format and organization. Format: 1)Minimum of ten (10) pages (not including self-prepared exhibits, title page or reference page), with numbered pages. 2)Typed, double spaced. 3)New Times Roman (i.e. business) font, 12 point. 4)Margins – 1 inch 5)Include boldface headings and subheadings. 6)Note source citations as appropriate under APA 7th edition guideline. Please use in-text citations. See the attached template for assistance with the organization. Preparing the Presentation: Presentations will be made in class during the last day of class. The presentation will be supported by 7 to 10 Power Point slides and will last not more than 10 minutes (Executive Committee length). Please see the week 8 instructions. Show all of your calculations clearly, number your responses, and write in your own words and complete sentences if writing is required. Please include APA format in-text citations and references, if you cite any sources. Requirements: Minimum of ten 10 pages (not including self-prepared exhibits, title page or reference page) | .doc file Requirements: Indicated | .ppt file Make sure the company is BlackRock and complete everything that is missing on the Excel spreadsheet.

the specific instructions are attached in the word document below.