Ratio Analysis Excel

1. your company and its 2
comparable companies should have financial statement & stock price
available for past 3 years, preferrably in Morningstar
(https://www.morningstar.com/)

2. Each one of you should choose a different company, as your main
company

3. please do NOT choose (1) Nike (2) Sample Report Companies (Marriott,
Hilton, InterContinental), (3) Disney, Netflix, Comcast, Viacom, (4)
Financial Companies as your main company

My Main Company
Name: Porsche Morningstar Link: https://www.morningstar.com/stocks/pinx/poahy/quote
Comparable Company
1 Name: Tesla Morningstar Link: https://www.morningstar.com/stocks/xnas/tsla/financials
Comparable Company
2 Name: Toyota Morningstar Link: https://www.morningstar.com/stocks/pinx/toyof/quote

Need data for 2019.2020.2021, the main company compares the other two companies. All data from the three companies are required.
Watch my video (Nike Recording) on downloading data
& calculating ratios, and use the Nike Excel (see attached) file as a
template to start (you will need to put the ratio calculations of each
company in one sheet, and make it one Excel file);
Calculate all the ratios using the financial
statement and with formula of Lecture 3 PPT (see attached);
Please make sure you read and understand the Academic Integrity file. Follow
the APA style with single space.

Here is a sample
report for Marriott International submitted by an MBA student.
This is an A+
report. So you know the expectation.
Please note that
the sample report is to demonstrate how to approach each question. You are not allowed to copy & paste
content of the report.
Please also note
that some questions of the Sample Report may be different from the questions
you get, so please read the “Sample Report Questions” carefully.
Final Report Sample Report (see attached)

Last Completed Projects

topic title academic level Writer delivered