Question
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:
This is Visa information:
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 | USDStep 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