Last week you had your first taste of portfolio critique. This week you further explored online portfolios designed by other members of the industry, and your competition. We will now marry these two concepts together as one creative, design-based project.

Look through the portfolios you examined this week as well as your notes and narrow in on one particular portfolio that simply missed the mark in its overall design and layout. Do now worry about the quality or quantity of its portfolio pieces for now. Simply analyze the construction and layout of the portfolio itself.

After noting what causes the portfolio to be less than successful or aesthetically pleasing, turn to your design program of choice (Photoshop, Illustrator, InDesign, or any combination therein) and create a revamped version of the portfolio’s main content page. Be sure that the major elements of the page (text, images, logo, etc) are still present, as you are simply redesigning the layout and framework of the portfolio itself, not its inner contents.

Think of it this way: someone tried to make their own portfolio and failed miserably, and has now hired you to redevelop their main page since you are so talented and experienced!

Since you will be reworking someone else’s digital content, your final layout will need to be in web resolution, RGB mode.

Once you have finished your redesign, save the project in its native file format and then save/export as a JPG, PNG, or PDF file. Upload this file, along with a screenshot of the original site design, to the drop box below in one zipped file.

Submit your completed assignment by following the directions linked below. Please check the Course Calendar for specific due dates.

Save your assignment and the screenshot into one zipped file. (Mac users, please remember to append the “.zip” extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:

Create a 3-5 page report that analyzes financial ratios for a company, uses the data to tell the financial story of that company, and concludes with a recommendation on whether the company would be a viable partner based on its financial condition.

Introduction

It’s essential for senior management to know the financial condition of an organization in order to make strategic decisions. In this assessment, you will apply the financial management skills learned thus far.

• Tell the financial story based on financial statements.
• Conduct a financial analysis and identify focus areas for enhancing shareholder value.
• Interpret ratio computations that are meaningful and inform business decisions and strategies.
• Make three recommendations that maximize shareholder value.

Scenario

Maria Gomez is founder and president of ABC Healthcare Corporation, a company that owns hospitals, ambulatory surgical centers, urgent care centers, and outpatient clinics. She has called on you to review various financial documents and to make recommendations to maximize shareholder value.

Your Role

You are one of Maria’s high-performing financial analyst managers at ABC Healthcare Corporation and she trusts your work and leadership.

Requirements

Here is what your report should provide for Maria:

• A summary of the financial strength of the company through your analysis of the price/earnings and price/book ratios.

See attached for information

The price-to-book ratio (P/B ratio) compares a firm’s market capitalization to its book value. It’s calculated by dividing the company’s stock price per share by book value per share. Here, for fiscal year 2019, the book value per share ratio was 0.42. This explains that investors were willing to pay $0.42 for $1 of book value equity. Price to book value is an important measure to see how much equity shareholders are paying for the net assets value of the company. P/B ratios under 1 are typically considered solid investments.

• Based on your analysis, what is your general perception of the company’s financial strength? Is it performing well given industry standards? How does it compare to its closest rival, HCA Healthcare? What information do you need in order to conduct such an analysis?
• Given your review, how can it maximize shareholder value? What are focus areas for enhancing shareholder value for the long term? What short-term steps might be necessary for longer-term gains?
• In your analysis you may choose to look at competitive data. You may calculate ratios to gain a true comparison.
• After conducting your analysis, provide at least three recommendations to Maria that maximize shareholder value.

Deliverable Format

Create a report that tells the financial condition of this company. Your report should provide information on the following:

• Analysis of the financial statements.
• Evaluation of the true condition and valuation of the company.
• Recommendation of actionable items for the company based on the financial analysis.

Financial Condition Analysis Report Requirements:

Remember that you’re preparing a professional document meant for executive leadership with limited time.

• Title Page.
• Executive Summary.
• Company Background.
• Overall Financial Analysis.
• Financial Ratio Analysis.
• Trend Analysis.
• Competitive Comparative Analysis.
• Recommendations.
• Conclusion.
• References.
• Appendix (if you have additional data, reports, charts, et cetera, to support your analysis).

Additional Requirements:

Your report should follow the corresponding MBA Academic and Professional Document Guidelines, including single-spaced paragraphs.

• Ensure written communication is free of errors that detract from the overall message and quality.
• Format your paper according to APA style and formatting.
• Use at least three scholarly resources.
• Length: Between 4-6 pages of content, beyond the title page, references, and appendices.
• Use 12 point, Times New Roman.

Evaluation

By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies through corresponding scoring guide criteria:

• Competency 1: Apply the theories, models, and practices of finance to the financial management of an organization.
  • Analyze financial ratio analysis, trend analysis, and competitive average analysis.
• Competency 3: Apply financial analyses to business planning and decision making.
  • Evaluate the provided financial statements of the firm to find its true condition and valuation.
• Competency 4: Use data to support evidence-based financial decisions.
  • Develop actionable items and conclusions, based on the analysis, recommending at least three ways to maximize shareholder value.
• Competency 5: Communicate financial information with multiple stakeholders
  • Tell the current financial story as to the overall health of the firm as it relates to current valuation and the future prospects of the company. Identify focus areas for enhancing shareholder value for the long term. Note what short-term steps might be necessary for longer-term gains.

Your homework assignment is to complete Exercises 7.1 and 7.2 on moving data with Sqoop on the AWS RDS Instance as we did in class.

Please download the requisite input files for these exercises from the Chapter 7 Exercise Files posted  as “Ch 07 Sqoop Exercise Files.zip” on Canvas under the Module entitled “CS  Course Project Data Sets”.  Unzip the folder and use the input files in your homework assignment in your work on this assignment.

Please submit a word document containing screenshots with section headings of how you managed to utilize Sqoop to load data from a RDMS onto the HDFS and then from the HDFS into Pig (7.1) and Hive (7.2) respectively in order to accomplish all of the tasks listed in Exercises 7.1 and 7.2.

Learn about 1v1 lol, an online third-person shooting and construction simulator. Enjoy game types including battle royale, build fights, box fights, zone wars, and more!

Competitors in the online third-person shooter known as “1v1 lol” use strategic map-building to outmaneuver their opponents. You can strengthen your defenses and gain an edge by constructing ramps, platforms, and walls. The primary mode is a deathmatch, where the winner is the person who is still alive at the end of the match.

With 1v1 lol, we were able to design an online shooting pvp simulator where you could battle against your opponents and utilize various construction options to hide from the adversaries. To accomplish your 1v1 lol build combat triumph, you may protect yourself with a ramp, wall, or ceiling, evade your actual opponents’ bullets, and attack them with your chosen weapons. 

Step 1: Using the information from your textbook, PowerPoint presentations, and the Internet; write a one to two-page paper on the following topic:

A community’s response to the physical and mental health needs of its aging population has become a highly publicized topic within recent years.   Taking into account your community’s elderly residential facilities, apply the following:

• Discuss what policies might a residential facility develop to minimize the chances that its residences will develop “institutionalism” 
• Include whether or not such policies are common or uncommon
• Determine which stage of Erikson’s psychosocial development an aging adult may be in if they are suffering from institutionalism
•  Explain how understanding the: social, emotional, cognitive, and physical development of the Aging Adult can be helpful in a clinical setting

Assignment Expectations for Grading:  

1. Demonstration of critical thinking, scholarship, and ability to connect and apply the material 

2. Comprehensiveness and completeness of your responses 

3. Adherence to the written instructions 

4. Spelling and grammar

5. Provide 3-5 APA Style References to support your paper.