please look at the file also this is also need to be answered 1look at PepsiCo finicial statement , calculate 5 ratios: Current Ratio (Working Capital Ratio) Profitability ratio Liquidity Ratio In

please look at the file also this is also need to be answered 1look at PepsiCo  finicial statement , calculate 5 ratios:Current Ratio (Working Capital Ratio)Profitability ratio Liquidity  RatioInventory Turnover RatioOperating MarginFor the current year and the prior year.  Discuss why the ratio’s changed from the prior year to the current year.Attaches also excel file for calculations please include the statement and references this need to be 2 pages and references !2 .Describe the characteristics of consolidated financial statements immediately following a business combination.Prepare consolidated financial statements immediately following a business combination, including:calculate consolidated balances on the consolidated balance sheet,understand consolidating investment eliminating entries, andunderstand intercompany receivable/payable eliminating entries.3. Describe the effects that the method a parent uses to carry an investment (on its books) in a subsidiary has on the investment balance that must be eliminated in the consolidating process.Consolidation Subsequent to Acquisition4. Describe the characteristics of the cost method of accounting for an investment.5. Describe the necessary treatment of the consolidating worksheet when a parent uses the cost method to account for an investment in a subsidiaryConsolidation Less than 100% Ownership6. Allocate the purchase price for a less than 100% acquisition.7 .Calculate the components of the balance sheet and income statement that would be represented on the consolidated statements with a less than 100% acquisition.Introduction to Earnings per Share8 .Complete a calculation of basic EPS.9 Complete a calculation of diluted EPS.Basic Earnings per Share10 .Complete a calculation of weighted average shares outstanding with stock issuance, repurchase, dividends, and splits.Diluted Earnings per Share11. Calculate the potentially dilutive effect of convertible preferred stock on basic EPS.12.Calculate the potentially dilutive effect of stock options and warrants using the “treasury stock method” on 13. Solve BOTH EPS (Earnings Per Share) questions below QUESTION #1) in the file!  Hide Hide