Hello, please help
Question 1. Please solve for the gross margin ratio using the Income Statement below and show excel work. Thank you.
Gross Margin (Solve for Gross Margin Profitability Ratio) - Show excel work
INCOME STATEMENT
of Revenue 2018 2017 2016 2015 2014 16,753,000,000 15,110,000,000 12,318,000,000 11,327,000,000 10,320,000,000 20,609,000,000 18,358,000,000 15,082,000,000 13,880,000,000 12,702,000,000 25,156,000,000 22,082,000,000 17,668,000,000 15,918,000,000 14,524,000,000 -5,491,000,000 -4,565, 1,565,000,000 -3,409,000,000 -2,861,000,000 -2,592,000,000 944,000,000 841,000,000 823,000,000 823,000,000 770,000 -3,856,000,000 -3,248,000,000 -2,764,000,000 -2,553,000,000 -2,382,000,000 -3,170,000,000 -2,628,000,000 -2,226,000,000 -2,079,000,000 -1,875,000,000 -686,000,000 -620,000,000 -538,000,000 . -474,000,000 -507,000,000 -3,192,000,000 -2,947,000,000 -2,556,000,000 -2,249,000,000 -2,170,000,000 -2,579,000,000 -2,391,000,000 -2,054,000,000 -1,755,000,000 -1,735,000,000 -1,145,000,000 -1,060,000,000 -796,000,000 -547,000,000 -507,000,000 -446,000,000 -409,000,000 -389,000,000 -336,000,000 -328,000,000 -446,000,000 -409,000,000 -389.000.000 -336,000.000 -328,000,000 -988,000,000 -922,000,000 -869,000,000 -872.000.000 -900,000,000 -613,000,000 -556,000,000 -502,000,000 -494,000,000 -435,000,000 -613,000,000 -556,000,000 -502,000,000 -494,000,000 -435,000,000 13,561,000,000 12,163,000,000 9,762,000,000 9,078,000,000 8,150,000,000 -755,000,000 -469,000,000 -1,750,000,000 -83,000,000 -426,000,000 -612,000,000 -563,000,000 -427,000,000 -612,000,000 -563,000,000 -427,000,000 -612,000,000 -563,000,000 -427,000,000 Name Gross Profit Total Revenue Business Revenue Sales Return and Allowances/Discounts Other Revenue Cost of Staff Cost, Cost of Revenue Other Cost of Revenue Operating Income/Expenses Selling, General and Administrative Expenses General and Administrative Expenses 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 Income from Associates, Joint Ventures and Other Participating Interests Other Investment Income 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 Provision for Income Tax Net Income from Continuing Operations Net Income after Extraordinary Items and Discontinued Operations Net Income after Non-Controlling/Minority Interests Net Income Available to Common Stockholders Net Income Available to Common Stockholders Other Adjustments to Net Income Available to Common Stockholders to Earnings Non-Controlling/Minority Interests Reported Total Revenue Reported Operating Expense Reported Total Operating Profit/Loss Reported Normalized Income Reported Effective Tax Rate Reported Normalized Operating Profit Fiscal year ends in Sep 30 USD -607,000,000 -19,000,000 -1,879,000,000 -14,000,000 -453,000,000 -607,000,000 - 19,000,000 -2,000,000 -14,000,000 -453,000,000 07 0 -1,877,000,000 464,000,000 113,000,000 556,000,000 -69,000,000 27,000,000 12,806,000,000 11,694,000,000 8,012,000,000 8,995,000,000 7,724,000,000 -2,505,000,000 -4,995,000,000 -2,021,000,000 -2,667,000,000 -2,286,000,000 10,301,000,000 6,699,000,000 5,991,000,000 6,328,000,000 5,438,000,000 10,301,000,000' 6,699,000,000' 5,991,000,000' 6,328,000,000 5,438,000,000 10,301,000,000' 6,699,000,000' 5,991,000,000 6,328,000,000' 5,438,000,000 9,942,000,000 6.467,000,000 5,929,000,000 6313,000,000 5,421,000,000 10,301,000,000 6,699,000,000 5,991,000,000 6,328,000,000 5,438,000,000 -359,000,000 -232,000,000 -62,000,000 -15,000,000 -17,000,000 359,000,000 232,000,000 62,000,000 15,000,000 17,000,000 0 20,609,000,000 18,358,000,000 15,082,000,000 13,880,000,000 12,702,000,000 7,655,000,000 -6,214,000,000 -7,199,000,000 -4,816,000,000 -5,005,000,000 12,954,000,000 12,144,000,000 7,883,000,000 9,064,000,000 7,697,000,000 10,729,000,000 8,335,000,000 6,862,000,000' 6,438,000,000' 5,721,000,000 0 0 07 13,749,000,000 Diluted Net Dilution 0 0
