Using the 2022 annual report for Shopify Inc., Calculate the following ratios for the current and prior
Fantastic news! We've Found the answer you've been seeking!
Question:
Using the 2022 annual report for Shopify Inc., Calculate the following ratios for the current and prior period with excel:
a) Working Capital Ratio
b) Qucik Ratio
c) Profit Margin
d) Price to earnings ratio
e) Debt equity ratio
f) Return on assets
g) Return on equity
State the formulas used and show all supporting work. If any ratios are not relevant, please explain why.
Transcribed Image Text:
Assets Current assets Cash and cash equivalents Marketable securities Trade and other receivables, net Merchant cash advances, loans and related receivables, net Income taxes receivable Other current assets Long-term assets Property and equipment, net Right-of-use assets, net Intangible assets, net Deferred tax assets Equity and other investments ($868,960 and $3,412,166, carried at fair value) Goodwill Total assets Liabilities and shareholders' equity Current liabilities Accounts payable and accrued liabilities. Income taxes payable Deferred revenue Lease liabilities Long-term liabilities Deferred revenue Lease liabilities Convertible senior notes Deferred tax liabilities Commitments and contingencies Shareholders' equity Common stock, unlimited Class A subordinate voting shares authorized. 1,195,697,614 and 1,139,544,920, issued and outstanding; unlimited Class B restricted voting shares authorized. 79,430,952 and 119,426,670 issued and outstanding; 1 Founder share authorized, 1 and nil issued and outstanding (12) Additional paid-in capital Accumulated other comprehensive loss (Accumulated deficit) retained earnings Total shareholders' equity Total liabilities and shareholders' equity Shopify Inc. Consolidated Balance Sheets Expressed in US $000's except share amounts On Behalf of the Board: "/s/ Tobias Ltke" Tobias Ltke Chair, Board of Directors "/s/ Colleen Johnston" Colleen Johnston Chair, Audit Committee Note 6 4 5 6 7 21 8 9 10 11 21 5 12 13 21 14 10 14 10 15 21 10, 17 19 20 December 31, 2022 $ 1,649,328 3,403,622 273,055 580,114 4,695 139,659 6,050,473 130,821 355,145 390,148 40,822 () Prior year share amounts have been retrospectively adjusted to reflect the ten-for-one share split ("Share Split") effected in June 2022. See Note 19 for details. (2) As a result of the implementation of the updated governance structure in June 2022, Class B multiple voting shares are now described as Class B restricted voting shares. The accompanying notes are an integral part of these consolidated financial statements. 1,953,460 1,836,282 4,706,678 10,757,151 532,569 9,390 295,888 18,161 856,008 267.513 465,135 913,312 16,294 1,662,254 As at 8,747,432 30,206 (16,473) (522,276) 8,238,889 10,757,151 December 31, 2021 S 2,502,992 5,265,101 192,209 470,722 5,023 103,273 8,539,320 105,526 196,388 138,496 48,369 3,955,545 356,528 4,800,852 13,340,172 456,688 13,505 216,792 15,748 702,733 162,932 246,776 910,963 183,427 1,504,098 8,040,099 161,074 (5,974) 2,938,142 11,133,341 13,340,172 Assets Current assets Cash and cash equivalents Marketable securities Trade and other receivables, net Merchant cash advances, loans and related receivables, net Income taxes receivable Other current assets Long-term assets Property and equipment, net Right-of-use assets, net Intangible assets, net Deferred tax assets Equity and other investments ($868,960 and $3,412,166, carried at fair value) Goodwill Total assets Liabilities and shareholders' equity Current liabilities Accounts payable and accrued liabilities. Income taxes payable Deferred revenue Lease liabilities Long-term liabilities Deferred revenue Lease liabilities Convertible senior notes Deferred tax liabilities Commitments and contingencies Shareholders' equity Common stock, unlimited Class A subordinate voting shares authorized. 1,195,697,614 and 1,139,544,920, issued and outstanding; unlimited Class B restricted voting shares authorized. 79,430,952 and 119,426,670 issued and outstanding; 1 Founder share authorized, 1 and nil issued and outstanding (12) Additional paid-in capital Accumulated other comprehensive loss (Accumulated deficit) retained earnings Total shareholders' equity Total liabilities and shareholders' equity Shopify Inc. Consolidated Balance Sheets Expressed in US $000's except share amounts On Behalf of the Board: "/s/ Tobias Ltke" Tobias Ltke Chair, Board of Directors "/s/ Colleen Johnston" Colleen Johnston Chair, Audit Committee Note 6 4 5 6 7 21 8 9 10 11 21 5 12 13 21 14 10 14 10 15 21 10, 17 19 20 December 31, 2022 $ 1,649,328 3,403,622 273,055 580,114 4,695 139,659 6,050,473 130,821 355,145 390,148 40,822 () Prior year share amounts have been retrospectively adjusted to reflect the ten-for-one share split ("Share Split") effected in June 2022. See Note 19 for details. (2) As a result of the implementation of the updated governance structure in June 2022, Class B multiple voting shares are now described as Class B restricted voting shares. The accompanying notes are an integral part of these consolidated financial statements. 1,953,460 1,836,282 4,706,678 10,757,151 532,569 9,390 295,888 18,161 856,008 267.513 465,135 913,312 16,294 1,662,254 As at 8,747,432 30,206 (16,473) (522,276) 8,238,889 10,757,151 December 31, 2021 S 2,502,992 5,265,101 192,209 470,722 5,023 103,273 8,539,320 105,526 196,388 138,496 48,369 3,955,545 356,528 4,800,852 13,340,172 456,688 13,505 216,792 15,748 702,733 162,932 246,776 910,963 183,427 1,504,098 8,040,099 161,074 (5,974) 2,938,142 11,133,341 13,340,172
Expert Answer:
Answer rating: 100% (QA)
Introduction Analyzing financial ratios is a fundamental aspect of assessing a companys performance and financial health In this case well utilize the ... View the full answer
Related Book For
Financial Accounting Tools for Business Decision Making
ISBN: 978-1119493631
9th edition
Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso
Posted Date:
Students also viewed these accounting questions
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Refer to the data in E13-11 and assume instead that Mustafa Limited has chosen not to recognize paid sick leave until it is used, and has chosen to accrue vacation time at expected future rates of...
-
Presented here are selected transactions for Spector Limited for 2012. Spector uses straight-line depreciation. Jan. 1 Sold a delivery truck for $10,000 cash. The truck cost $62,000 when it was...
-
The functions in Exercises 1128 are all one-to-one. For each function, a. Find an equation for f -1 (x), the inverse function. b. Verify that your equation is correct by showing that f( f -1 (x)) = x...
-
A significant issue when a contract is breached is whether the cause of action is strictly in breach of contract or may be expanded to negligence and strict liability. The significance comes into...
-
Transferred-in costs, weighted-average method. Bookworm, Inc., has two departments: printing and binding. Each department has one direct-cost category (direct materials) and one indirect-cost...
-
Assume your health insurance has a $500 deductible and a 10% co-pay. How much would you have to pay for a $800 medical bill, assuming this is the only charge you have for the entire year?Disability...
-
Your CEO has just finished a long flight. They are stranded in the plane on the tarmac at the airport due to a mechanical delay. Their laptop has died. It is up to you to produce a full PowerPoint...
-
Multiple-Choice Exercise 6-6 Morgan Inc. has the following units and costs for the month of April: Units Purchased at Cost Units Sold at Retail Beginning inventory, April 1 1,200 units at $25...
-
The code is missing some elements. I know there have been other similar questions asked. I just need some assistance, an alternate method to get the code running. The lottery game is based on a...
-
AllCity Inc. is financed 40% with debt, 15% with preferred stock, and 45% with common stock. Its pre-tax cost of debt is 6%; its preferred stock pays an annual dividend of $2.50 and is priced at $28....
-
2. Given f(x) = 2x cos(x): (a) Find the first 8 derivatives of f. Note: this can be easily done with list comprehension. (b) Given a number n that is divisible by 4, state the formulas for the nth...
-
Cullumber Electronics uses a perpetual inventory system which, at the company's year-end December 31, 2023, indicated an inventory value of $1,035,150. A physical inventory count was conducted and it...
-
[1 0 11 0 1 1 1 A) Let A = {1, 2, 3, 4, 5} and R a relations on A whose matrices is MR = 0 0 1 1 0 0 1. 1) Show that (A, R) is a poset (5 pts) 2) Find maximal, minimal, least and greatest if they...
-
What are the key dimensions of critical thinking 2. Watch the NBC Learn video on Diet Scams. What types of claims are made in this video Are they valid Elaborate on your responses. Discuss this video...
-
Anglo Corporation has a current ratio of 1.1:1. Jon has always been told that a corporations current ratio should exceed 2.0:1. The company maintains that its ratio is low because it has a minimal...
-
Data for Rewe Company are presented in P12.5A. Instructions Prepare the operating activities section of the statement of cash flows using the direct method. Data From P12.5A. Rewe Companys income...
-
Hoff man Corporation reported income taxes of $370,000,000 on its 2022 income statement and income taxes payable of $277,000,000 at December 31, 2021, and $528,000,000 at December 31, 2022. What...
-
Suppose that the universe of available risky securities consists of a large number of stocks, identically distributed with E(r) = 15%, = 60%, and a common correlation coefficient of = .5. a. What...
-
Suppose that two portfolio managers who work for competing investment management houses each employs a group of security analysts to prepare the input list for the Markowitz algorithm. When all is...
-
What is the Sharpe ratio of the best feasible CAL?
Study smarter with the SolutionInn App