Module 1 Assignment Instructions for 5Y Financials and Exhibit 5- Common Size Income Percentages

Note: You have done this assignment for me before but it was for the wrong company, not fault to your end. You must do the Pandora Internet Company. Objective: Collect Balance Sheet and Income Statement data for your 5-Year Financials and calculate common size income percentages to compare the financial performance of your firm for the respective period of analysis.

There should be 5 years of analysis, unless there is no data in SEC-Form 10s for all those years.

DUE BY THE END OF THE DAY ON THE SATURDAY THAT ENDS THIS WEEK. Common Size Income Percentages IS WORTH 11 % OR 110 POINTS.

What is the 5Y financials?

Every firm in the list of possible cases for the capstone has a five-year period of analysis. Financial data comes from the Form 10 documents each firm submits to the U.S. Securities Exchange Commision. Form 10 includes Balance Sheets and Income Statements we collect for the Five-year Financials.

For most firms, there are five years of financial information. However, it may be there are only 4 or 3 years available. Just collect all what you can get in Excel.

The 5-Y financials Excel workbook includes six sheets: Balance Sheet, Income Statement with Common Size Percentages, and Financial Ratios you must complete in BUS485A. This Excel also includes three Pro-Forma Income sheets for three strategies that will be done in BUS485B.

Excel workbooks with the 5-Y financials for some firms are already available for you to customize in Course Resources/5Y Financials.

What is the Common Size Percentages?

Common size percentages are metrics to compare firm performance over the five years of analysis. All items in the income statement are presented as percentages of Sales or Revenue. For instance, when total costs are expressed as a percentage of sales, and it goes up from 43% to 49%, we could conclude costs have increased over time and we should research why costs went up. Is this because of internal or external factors?

What do you have to do?

After having chosen your firm of study, verify if there are already 5-Year financials for that firm in Course Resources. If it is, verify the data is correct with the Balance Sheet and Income Statement data in SEC-Form10 for the years of your analysis.

If there is no 5-Year financials Excel in Course Resources, you must create one using Form 10 for your period of analysis (USE STARBUCKS CORPORATION). Collect Balance Sheet and Income Statement annual data. Depending on your Excel skills, you should request help from your instructor to create formulas and the sheets for common size percentages, financial ratios, and Pro-Forma.

Use the template for Exhibit 5 Common Size Percentages

Use the TemplateSA-EXH 5-CommonSize.xlsx to guide your work. This template shows the income statement for five years, and the common size percentages calculated to the right. Review how formulas are created for the 1993 common size percentage column, G8 to G27. These formulas were copied to the other years to the right. Because, when you use formulas in Excel, you just type one time, and then you copy it to generate the entire table! You must do the same in your 5Y-financials, sheet Income Statement.

Download SA-WritingTemplate-BUS485A.docx

If you have not downloaded yet SA-WritingTemplate-BUS485A.docx from Course Resources/The Strategic Audit, do it from the attachments here. This writing template must be used to write all sections of the Strategic Audit in this capstone. Drafts of your writing are shared as part of Discussion One in each module, and you will get feedback from other students and the instructor there.

The 5-Y Financials and Common Size Percentages support the writing of Section I.

Assignment Submission Procedures

Click on the Module One Assignment Common Size link to submit your assignment. You can do it from Module One/Assignment or Course Work/Assignments. Attach your 5-Y Financials as an Excel file. It should have the Balance Sheet and Income Statement with the Common Size Percentages to the right. After attaching your document, you may add comments to your instructor in the Add Comments field if you wish. Then click the Submit button.

What to do after you receive my feedback

After you receive my feedback and comments, be sure to update/improve your 5-Y Financials. Your updated/improved work will be evaluated in the final version of your Strategic Audit to be submitted at the end of the term. If you do not update your intermediate products, you will lose points on them in the final Strategic Audit product.

Refer to the article you read in Wk 1 Discussion 2 – Critically Reflective Practice, Critically Reflective Practice, located in the .

Locate a minimum of 1 additional peer-reviewed article on perspective switching, differing perspectives, or another relevant topic.

Identify 1 of the following types of events of your choice and 1 example of the event to use for this assignment:

• An event that affected more than 1 person
• An event that has occurred in society to more than 1 person
• An event that has occurred in your professional field to more than 1 person

Use the to write a 500- to 700-word synthesized discussion on the chosen event and describe how the event could be perceived from each of Brookfields 4 lenses. Consider using Level I headings for each of Brookfields 4 lenses to organize your discussion.

Format citations and references according to APA 7th edition guidelines.

To adhere to APA style, do not use first-person perspective.

Submit your assignment.

Resources

Background: Tessile, S.A., headquartered in Turin, Italy, is a mid-sized textile manufacturer with a strong reputation for high-quality cotton and linen fabrics. Originally a cotton plantation business, the company was transformed under the leadership of CEO Giuseppe Franco into one of Northern Italy’s leading textile exporters. In the past decade, Tessile S.A. has seen increased international demand due to the European luxury apparel boom and rising popularity of sustainable, locally sourced fabrics. With strong operational capabilities and a loyal customer base, Tessile has enjoyed a solid financial positionuntil recently.

The Shift:

Over the last three years, Mr. Franco has pursued an aggressive diversification strategy, acquiring a series of boutique wineries across Southern and Central Italy. These moves, while initially welcomed, have raised concerns among board members and shareholders who view the shift as straying too far from the companys core competencies. Now, Mr. Franco has announced intentions to expand Tessile into the tourism and cheese industries by acquiring heritage farm properties with potential for agritourism and cheese production. The expansion will require:

• A 45 million loan from an international lender
• Reallocation of personnel from textile operations to manage new ventures
• Cross-functional leadership with limited industry expertise in hospitality or food production

Meanwhile, Tessile’s stock value has declined 28%, and debt-to-equity ratios have risen to concerning levels. Shareholder meetings have become contentious, and media outlets have begun questioning the direction of the company.

Risk and Strategic Evaluation: As a hired strategic consultant, you are tasked with presenting a formal report to Tessiles Board of Directors. Your responsibility is to identify and assess the risks associated with the companys current direction, and to advise on how to integrate a robust risk management system to protect the organization moving forward.

Risk Identification and Classification:

1. Define the difference between a hazard, threat, and risk.
2. Describe the process and tools you would use to identify risks in Tessiles business strategy (e.g., SWOT, PESTLE, stakeholder mapping).
3. Identify at least five key risks, classify them (strategic, operational, financial, reputational, legal), and assess their severity and likelihood.

Understanding Risk Management Systems:

1. What is the purpose of a risk management system in an organization like Tessile?
2. Describe how such a system would be applied in this case.
3. What roles do security (e.g., cybersecurity, asset protection) and capacity (e.g., staffing, financial flexibility) play in effective risk management?

Risk Assessment Methodologies:

1. Compare qualitative vs. quantitative risk assessment approaches.
2. Discuss at least two risk assessment methodologies (e.g., Risk Matrix, FMEA, Monte Carlo simulation) and how they support a systematic approach to evaluating risks.

Risk Response Strategies:

1. Describe the four risk response strategies: Avoid, Transfer, Mitigate, and Accept.
2. Apply each strategy to one of the risks identified in Tessiles current expansion strategy.

Strategic Recommendations:

1. How can Tessile realign its expansion into tourism and cheese production with its textile heritage to reduce reputational and strategic risk?
2. What would you recommend the board do to restore stakeholder confidence, manage current debt levels, and maintain long-term growth?

Requirements:

• There is no minimum or maximum required number of pages. Your response will be considered complete, if it addresses each of the components outlined above.
• Use of proper APA formatting and citations – If supporting evidence from outside resources is used those must be properly cited. A minimum of 3 -5 sources (excluding the course textbook) from scholarly articles or business periodicals is required.
• Include your best critical thinking and analysis to arrive at your justification.

Assigned Readings:

Chapter 5 – Executive Stakeholders

Chapter 7 – Stakeholder Communication

Initial Postings: Read and reflect on the assigned readings for the week. Then post what you thought was the most important concept(s), method(s), term(s), and/or any other thing that you felt was worthy of your understanding in each assigned textbook chapter.Your initial post should be based upon the assigned reading for the week, so the textbook should be a source listed in your reference section and cited within the body of the text. Other sources are not required but feel free to use them if they aid in your discussion.

Also, provide a graduate-level response to each of the following questions:

Before attempting this case study, students must review the following article:

This article provides essential context on the characteristics, expectations, and influence of C-level stakeholders in project environments. Your insights should reflect an understanding of how executive relationships impact project outcomes.

Tania, a senior consultant at Nexen Business Consultants, has been assigned to lead a high-impact digital transformation initiative for MediCore, a $1.5B healthcare technology company. The project has broad implications for MediCores operations, from patient record systems to supply chain analytics.

Tania is not just managing tasks and timelinesshes navigating a complex network of executive stakeholders, each of whom has high influence and unique expectations:

• The Chief Executive Officer (CEO) is focused on competitive advantage and investor confidence, and expects to see clear ROI metrics early.
• The Chief Financial Officer (CFO) is concerned about cost overruns and is hesitant to approve additional resource requests.
• The Chief Operating Officer (COO) wants detailed risk assessments tied to operational disruptions.
• The Chief Information Officer (CIO) has mandated Agile delivery but rarely attends sprint reviews.
• The Chief Human Resources Officer (CHRO) is interested in how the change will affect staffing and culturebut feels left out of the loop.

Tania knows that executive stakeholders can make or break project success. If she fails to win their trust, attention, and ongoing support, the project may lose funding, hit resistance, or fall short of strategic alignment.

Tania is developing a Stakeholder Management Plan focused specifically on executive-level stakeholders. She is also creating a Stakeholder Network Register to track conversations, expectations, influence, and commitment levels across the executive suite. Her goals are to:

• Communicate effectively across multiple leadership styles
• Build credibility and trust
• Align the project to strategic goals
• Prevent disengagement or passive resistance

Discussion Questions

1. Why do executive stakeholders require a unique engagement strategy compared to mid-level or operational stakeholders? How do power, influence, and organizational knowledge shape their involvement?
2. What is the specific role of a Stakeholder Register in managing executive engagement? How can Tania use this tool to support her communication strategy and anticipate challenges?
3. What are the essential components of a Stakeholder Management Plan focused on C-level executives? How do these elements differ from plans designed for non-executive stakeholders?
4. Based on the lessons learned in the PMI abstract (e.g., Let them quickly catch on, Be visible, Break hierarchy), which two tactics should Tania prioritize when developing relationships with the MediCore C-Suite? Why?

[Your post must be substantive and demonstrate insight gained from the course material. Postings must be in the student’s own words – do not provide quotes!]

[Your initial post should be at least 450+ words and in APA format (including Times New Roman with font size 12 and double spaced). Post the actual body of your paper in the discussion thread then attach a Word version of the paper for APA review]

Chapter 5 – Executive Stakeholders

Overview:

Executive stakeholders are typically powerful. The project manager should pay close attention to this stakeholder group to ensure the project is aligned with their expectations. Executive stakeholders include the customer, the executive sponsor, the executives who are on the Executive Council, executives actively involved in the project, and supplemental executive stakeholders who are likely to come and go as the project ebbs and flows. The project manager should include executive stakeholders in the project, clearly communicate project success and shortcomings, and always find ways to proactively identify potential barriers to success. We discuss the importance of relationships between the project manager and key executives. Executives, like most stakeholders, are busy. We discuss the top watch-outs for working with executive stakeholders. The project manager and project team should constantly be vigilant for ways to make their communications with the engagement of executives concise and efficient.

Learning Objectives

• Understand the categories used to analyze stakeholders
• Understand the need for and use of the stakeholders engagement assessment matrix
• Able to articulate the importance of a stakeholder management plan
• Define the elements within a stakeholder management plan

Chapter 7 – Stakeholder Communication

Overview:

Project stakeholder communication is part science and part art. The main point of this chapter is that there are many different types of communication: verbal, nonverbal, written, visual, kinesthetic, and emotional. The most effective communicators learn how to use these communication channels holistically. Since poor communication has been the cause of failure for so many projects, the savvy project manager embraces the holistic approach to communication. It is important to be persistent in the communication of the message. Successful project managers communicate the same message to their stakeholders over and over. It takes repetition for the message to sink in. The successful project manager realizes that communication is a two-way street and is constantly open to communication from their stakeholders. The project manager should ask clarifying questions and ensure that they understand the message being communicated to them.

Learning Objectives

• Understand the various types of communication
• Understand the need for constant, persistent stakeholder communications
• Discuss how a project manager communicates differently with an executive stakeholder as opposed to other stakeholders
• Discuss various communication channels and which each is more applicable

Supplementary Readings:

Orion Manufacturing, a global producer of precision components for the aerospace sector, has launched a strategic initiative to modernize its enterprise resource planning (ERP) system. The project, titled Orion CoreStream, aims to consolidate multiple legacy systems into a single, cloud-based platform to streamline procurement, production, and inventory management.

Ravi Patel, the project manager, is excited but aware of the enormous communication challenges ahead. With operations spread across North America, Europe, and Southeast Asiaand a diverse group of stakeholdersthe project demands precise and inclusive communication strategies to ensure stakeholder alignment.

The stakeholder list includes:

• Executive Sponsor (COO) Highly invested in business transformation and expects detailed dashboards showing milestones and risks. Prefers briefings every other week.
• IT Director Supports technical execution and prioritizes data security and integration risks. Wants technical documentation and weekly status updates.
• Regional Operations Managers Care most about operational disruptions and training for their staff. Want monthly email updates and site-specific video walkthroughs.
• Procurement Team Frustrated with legacy systems and eager for change but feel uninformed. Need hands-on demos and clear task assignments.
• External Vendor (Cloud ERP provider) Provides implementation support. Seeks timely, consistent documentation and decisions to avoid scope creep.

The Challenge

Three months into the project, Ravi notices communication cracks forming:

• The COO has expressed frustration about not being informed early enough on vendor delays.
• The IT Director is overwhelmed by change requests but claims decisions are made without full technical input.
• Regional managers are resisting training sessions, claiming theyre too generic and not tailored to their operational context.
• The vendor is warning that scope misalignment could derail the timelineand they blame inconsistent communication from Orions internal teams.

Ravi realizes the Stakeholder Communication Plan he developed at the beginning of the project may have been too general and not tailored to the communication preferences, roles, and concerns of each group. With team morale slipping and executive confidence faltering, he must quickly reassess and redesign the plan to regain control of the project narrative and stakeholder confidence.

Your Task What You Must Do

You have been brought in as an external consultant to diagnose communication issues in the Orion CoreStream project and help project manager Ravi rebuild an effective stakeholder communication strategy.

To complete this assignment, you must:

Step 1: Identify Key Communication Failures

• Analyze the case study and describe at least three specific communication breakdowns.
• Explain what went wrong, which stakeholders were affected, and what the consequences were.

Step 2: Design a Stakeholder Communication Plan

Select three stakeholders or stakeholder groups from the case (e.g., COO, IT Director, Procurement Team, Vendor).

For each selected stakeholder:

• Define their communication needs, preferences, and pain points.
• Propose a tailored communication strategy, including:
• Frequency of communication (e.g., weekly, monthly)
• Preferred format (e.g., dashboard, email, video, live meeting)
• Communication channel (e.g., Teams, email, phone call, in-person)
• Key content or focus areas
• Responsible communicator (e.g., Ravi, project coordinator)

Step 3: Propose a Communication Feedback Mechanism

• Describe how Ravi can ensure communication is two-way, not just top-down.
• Include a method for stakeholders to give feedback or raise concerns (e.g., check-ins, surveys, stakeholder meetings).

Step 4: Prepare a Response for an Executive Meeting

• Imagine Ravi is invited to an urgent executive review meeting.
• Prepare a brief action plan or slide outline (in bullet points) that Ravi can present to:
• Show an understanding of the issues
• Communicate next steps
• Reassure leadership that the project is under control

Requirements:

• There is no minimum or maximum required number of pages. Your analysis will be considered complete, if it addresses each of the components outlined above.
• Use of proper APA formatting and citations. If supporting evidence from outside resources is used those must be properly cited. A minimum of 3 – 5 sources (excluding the course textbook) from scholarly articles or business periodicals is required.
• Include your best critical thinking and analysis to arrive at your justification.