Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Project Rationale The objective of the financial analysis research project are to enable a person to make and produce a comprehensive financial analysis of two

Project Rationale The objective of the financial analysis research project are to enable a person to make and produce a comprehensive financial analysis of two publicly-traded corporation. Using the two companies (Visa and Mastercard) compare these two competitors and provide a critical analysis of these two corporations financial ratios to make recommendations regarding investing in either of these companies.

Calculate the required financial ratios for each company (Visa and Mastercard) using their annual data from 2018, and present in MS Excel.

Visa Financial Statements Final

https://canvas.park.edu/courses/52639/files/6732491/download?wrap=1

MasterCard Financial Statements https://canvas.park.edu/courses/52639/files/6732486/download?wrap=1

Second, make financial analysis report that utilizes the financial ratios and supported with written analysis, interpretation, and evaluation of the data. The analysis should be focused on the main theme: Would you invest your financial capital in either firm as a shareholder?

Excel Financial Ratios For this project. make a financial ratios in MS Excel using the accounting statements provided.

provide the calculations for the following ratios for each company using the 2018 annual data. Calculations must be performed and submitted in an MS Excel spreadsheet.

Profitability Ratios

Gross Margin

Operating Margin

Net Profit

Margin Liquidity Ratios

Current Ratio

Cash Ratio

Leverage Ratios

Debt to Equity

Operating Returns

ROE

ROA

Project Deliverables For this project: prepare financial ratios using the accounting statements provided.

1. make an Excel document which provides the calculations for the ratios required for the project. The Excel document should clearly identify each company and their specific ratio calculations.

2. written analysis of your findings. This final analysis should be written as a professional stock analysis of these two competitors and utilize supporting evidence in the analysis (citations and references).

The final written analysis must follow A P A s t y l e and should be no more than 15 p a g e s (including charts and references). The analysis should include: Analysis of the two businesses and a discussion of the payments industry, including but not limited to, strengths of these businesses, opportunities moving forward, potential threats to their business models. Critical analysis of each of the main ratio calculations related to each company.

This critical analysis should include the calculations, results, an explanation of the importance of the ratio, and an analysis of which company has an advantage based upon the calculations.

This analysis should include graphs and figures to supplement your written analysis. Clear conclusion which summarizes the advantages and disadvantages for each company, with an ultimate answer related to which company you would choose to invest using clear and convincing reasoning.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Tools for Business Decision Making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

5th edition

9780470418239, 470239808, 9780470239803, 470418230, 978-1118128169

More Books

Students also viewed these Accounting questions