Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I choose Pepsi Co and Coca Cola, USA. Please prepare the detailed financial analysis for the same. Provide detailed step by step formula and calculations
I choose Pepsi Co and Coca Cola, USA. Please prepare the detailed financial analysis for the same. Provide detailed step by step formula and calculations for the year Consider financial reports for for both the companies.
For your Final Project in the course you will work in the roles of financial analysts and create a full analysis between two different companies in the same industry for example, Coca Cola and Pepsi Please ensure that you fully explain all calculations and that you answer every question thoroughly. Your Team will need to locate information about the two companies' annual financial statements for the most recent year available. To do so go to one of the many financial sites on the Internet to download their reports.
MSN Money
Yahoo Finance
Your analyses should address the following items:
What are the primary lines of business of these two companies as shown in their notes to the financial statement?
Which company has the dominant position in their industry?
What are the gross profits, operating profits, and net income for these two companies?
Compute both companies' cash coverage ratio, current ratio, and free cash flow.
What ratios do each of these companies use in the Management's Discussion and Analysis section of the annual report to explain their financial condition related to debt financing meaning you MUST find each of the two firms' annual reports
What are the gross profits, net income, EBIT, EBITDA and free cash flow FCF for these two companies?
For both companies, compute:
current ratio
quick ratio
total debt ratio
debtequity ratio
total asset turnover
inventory turnover
days sales in inventory
profit margin on sales
return on assets and
return on equity
Fully explain what each ratio is telling you NOT just a definition but relevant to your firms.
Complete your study with a full DuPont Model.
Specifically, after calculating the ratios, explain what each tells you about the company and comparecontrast with the other company. For example, when discussing the days sales in inventory and inventory turnover, indicate where and why there might be a significant difference between the two companies you have selected.
Finally, using two of the several valuation models we have studied in this course, demonstrate whether the stock is overvalued, undervalued, or correctly valued by the market. The might include CAPM, Dividend Discount, Free Cash Flow, or Earnings Multiplier... your choice, but be prepared to defend your answer in your final classroom presentation.
The paper must follow APA writing style guidelines for citation both intext and reference structure, grammar, spelling, and punctuation. Include your analytical comments and add charts or graphs if they help to prove your point more clearly.
Submit your work for this assignment here. Submit one paper per Team. Remember to make sure all Team members' names are present.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started