Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your team will prepare an Excel document which provides the calculations for the ratios required for the project for the past three years. The Excel

Your team will prepare an Excel document which provides the calculations for the ratios required for the project for the past three years. The Excel document should clearly identify each company and their specific ratio calculations.

For this project your team will prepare financial ratios in MS Excel using the accounting statements provided. Teams must provide the calculations for the ratios over a three year period (2017, 2018, 2019) for each company using the annual data. Calculations must be performed and submitted in an MS Excel spreadsheet for each.

Liquidity Ratios

Current Ratio

Cash Ratio

Leverage Ratios

Debt to Equity

This is Mastercard information:

image text in transcribed

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

This is Visa information:

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribedimage text in transcribedimage text in transcribed

image text in transcribed

V_IncomeStatement_Annual_As_Originally_Reported 1 V_IncomeStatement_Annual_As_Originally_Reported 2 Gross Profit 15,110,000,00016,753,000,00018,812,000,000 7 Cost of Revenue :3,248,000,000>3,856,000,000>4,165,000,000 11 Selling, General and Administrative Expenses 12 General and Administrative Expenses 13 Legal, Accounting, Auditing and Consulting Fees Other Professional Accounting and Consulting Fees Selling and Marketing Expenses Depreciation, Amortization and Depletion Depreciation and Amortization Total Operating Profit/Loss Non-Operating Income/Expenses, Total Total Net Finance Income/Expense Net Interest Income/Expense Interest Expense Net of Capitalized Interest Net Investment Income Dividend and Investment Income Gain/Loss on Investments and Other Financial Instruments Fair Value or Unrealized Gain/Loss on Financial Assets Irregular Income/Expenses Litigation Income/Expense Other Irregular Income/Expenses Impairment/Write Off/Write Down of Other Assets Other Income/Expense, Non-Operating Pretax Income 113,000,000464,000,000 Provision for Income Tax 11,694,000,00012,806,000,00014,884,000,000 34 Net Income from Continuing Operations :6,699,000,00010,301,000,000:12,080,000,000 4,995,000,000=2,505,000,000=2,804,000,000 37 Net Income Available to Common Stockholders 6,467,000,0009,942,000,00012,080,000,000 38 Diluted Net Income Available to Common Stockholders 39 Other Adjustments to Net Income Available to Common Stockholders 40 Dilution to Earnings 41 Non-Controlling/Minority Interests 42 Reported Total Revenue 43 Reported Operating Expense 18,358,000,00020,609,000,000222,977,000,000 44 Reported Total Operating Profit/Loss 6,214,000,0007,655,000,0007,976,000,000 45 Reported Normalized Income 12,144,000,00012,954,000,00015,001,000,000 44 Reported Total Operating Profit/Loss Reported Effective Tax Rate Reported Normalized Operating Profit 48 Basic EPS 49 Diluted EPS 50 Basic WASO 51 Diluted WASO 52 Fiscal year ends in Sep 30 | USD V_IncomeStatement_Annual_As_Originally_Reported 1 V_IncomeStatement_Annual_As_Originally_Reported 2 Gross Profit 15,110,000,00016,753,000,00018,812,000,000 7 Cost of Revenue :3,248,000,000>3,856,000,000>4,165,000,000 11 Selling, General and Administrative Expenses 12 General and Administrative Expenses 13 Legal, Accounting, Auditing and Consulting Fees Other Professional Accounting and Consulting Fees Selling and Marketing Expenses Depreciation, Amortization and Depletion Depreciation and Amortization Total Operating Profit/Loss Non-Operating Income/Expenses, Total Total Net Finance Income/Expense Net Interest Income/Expense Interest Expense Net of Capitalized Interest Net Investment Income Dividend and Investment Income Gain/Loss on Investments and Other Financial Instruments Fair Value or Unrealized Gain/Loss on Financial Assets Irregular Income/Expenses Litigation Income/Expense Other Irregular Income/Expenses Impairment/Write Off/Write Down of Other Assets Other Income/Expense, Non-Operating Pretax Income 113,000,000464,000,000 Provision for Income Tax 11,694,000,00012,806,000,00014,884,000,000 34 Net Income from Continuing Operations :6,699,000,00010,301,000,000:12,080,000,000 4,995,000,000=2,505,000,000=2,804,000,000 37 Net Income Available to Common Stockholders 6,467,000,0009,942,000,00012,080,000,000 38 Diluted Net Income Available to Common Stockholders 39 Other Adjustments to Net Income Available to Common Stockholders 40 Dilution to Earnings 41 Non-Controlling/Minority Interests 42 Reported Total Revenue 43 Reported Operating Expense 18,358,000,00020,609,000,000222,977,000,000 44 Reported Total Operating Profit/Loss 6,214,000,0007,655,000,0007,976,000,000 45 Reported Normalized Income 12,144,000,00012,954,000,00015,001,000,000 44 Reported Total Operating Profit/Loss Reported Effective Tax Rate Reported Normalized Operating Profit 48 Basic EPS 49 Diluted EPS 50 Basic WASO 51 Diluted WASO 52 Fiscal year ends in Sep 30 | USD

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

Step: 3

blur-text-image

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

More Books

Students also viewed these Finance questions