Case Study (Must have STRONG Finance Background)

Please complete the attached Mattel Incorporated spreadsheet assignment. The Mattel Income Statements and Balance Sheets (attached above) will be needed to complete this assignment. I’ve included (14) documents. Needs to be APA style. Strong finance background required!

Note: Mattel Incorporated’s 2019 Fiscal Year Ends 12/31/2019. There is preliminary 2Q 2020 data attached above.

Note: Please use the “Commonly Used Financial Ratios” handout formulas for completing the financial ratios on this assignment.

Note: Use N=4 in your calculation of revenue CAGR.

Expand or Contract Mortgage Exposure to lower income borrowers

Make an argument to senior management as to whether the bank should expand or contract its mortgage exposure to lower income borrowers.

The location of choice is Cleveland Ohio. Graphs and tables are definitely needed. I pulled data some data on 3 separate spreadsheets.
A couple of paragraphs on the banks, the background on MSA’s (employment is the most important fundamental for housing).

Housing Data using https://www.redfin.com/blog/data-center/

Analysis. Tell me whether the bank is performing well in its requirements regarding supporting housing for lower-income households in your msa.

Final point. The main goal here is to demonstrate to me your ability to make assessments backed by a broad set of disparate information. This is both hard data and broad regional and firm trends. Creativity is highly encouraged

Mental Models/Education

    How do mental models reveal individuals assumptions of how the world and how organizations work?
    How can mental models both impede and accelerate learning in the organization?
    How can understanding mental models be institutionalized in organizational practice?

Film pitch about a viral outbreak in 18th century

The year is 2020. Since COVID-19 has spread throughout the world, Hollywood has become very interested in producing films about contagion, epidemics, and disease. You are a young filmmaker who majored in History at CU Boulder. You have an idea to pitch a historical film that tells the story of a viral outbreak in the eighteenth century. This is your first independent film and you are looking for funding. Building off of stories and evidence found in Elizabeth Fenns Pox Americana, write a three-page film proposal that will convince a funding agency to support your film. Pick a story or stories from Pox Americana that you wish to adapt to screen. Who will be your narrator or protagonist? George Washington? A Continental soldier? A former slave in Dunmores army? A pueblo child in New Mexico? A trader in the Hudsons Bay Company? What particular historical lessons do you think contemporary audiences will learn from this eighteenth century story? What lessons do you want audiences to take away?

Decide how you want to tell this story and pitch it to your investors. Remember: There are several former History majors at this funding agency, so your description should both tell a story and make a historical argument about what you represent in your film. Youll impress the funders most if you give examples of primary and secondary sources that inform your film.

I was given this link to a youtube video.
https://www.youtube.com/watch?v=W4INB562_LA

Also I don’t know how to link the book pox Americana but I think you can find it online.