Recreate the financial statements Use the sum function to calculate the dollar amount only Create your own
Fantastic news! We've Found the answer you've been seeking!
Question:
- Use the sum function to calculate the dollar amount only
- Create your own formula for vertical analysis
Transcribed Image Text:
Income Statement for the years ended February 28, 2021 and 2022 2021 Net Sales Cost of Goods Sold Selling Expenses Depreciation Expense Other Expenses Earnings before taxes Taxes Net Earnings Assets Current Assets Cash Accounts Receivable. Supplies Total Total Assets Property, Plant, & Equipment Building, net Liabilites and Owners Eg. Current Liabilites Accounts Payable Salaries Payable Total Long-Term Notes Payable Owners' Equity Common Stock Retained Earnings $ 17,852 $ (8,999) Total Total Liab. And Owners Eq. $ (6,523) (1,113) (54) 1,163 Accounting in Excel Corporation Balance Sheet years ended February 28, 2021 and 2022 (504) 659 2021 $ 13,682 $ 43,806 $ 81,636 $ 139,124 $ 558,864 $ 697,988 $ 137,024 $ 67,882 $ 204,906 $100,000 $ 190,000 $ 203,082 $ 393,082 $ 697,988 100.00% $ 19,854 -50.41% $ (8,800) -36.54% (7,001) -6.23% (985) -0.30% $ (89) $ 6.51% -2.82% $ 3.69% 80.07% 100.00% 19.63% 9.73% 29.36% 14.33% 2,979 (984) $ 1,995 1.96% $ 16,950 6.28% $ 47,126 $ 110,580 11.70% 19.93% $ 174,656 2022 2022 $ 587,016 $ 761,672 $ 115,300 $ 90,428 $ 205,728 50,000 27.22% $ 190,000 $ 315,944 29.10% 56.32% $ 505,944 100.00% $ 761,672 100.00% -44.32% -35.26% -4.96% -0.45% 15.00% -4.96% 10.05% 2.23% 6.19% 14.52% 22.93% 77.07% 100.00% 15.14% 11.87% 27.01% 6.56% 24.95% 41.48% 66.43% 100.00% Income Statement for the years ended February 28, 2021 and 2022 2021 Net Sales Cost of Goods Sold Selling Expenses Depreciation Expense Other Expenses Earnings before taxes Taxes Net Earnings Assets Current Assets Cash Accounts Receivable. Supplies Total Total Assets Property, Plant, & Equipment Building, net Liabilites and Owners Eg. Current Liabilites Accounts Payable Salaries Payable Total Long-Term Notes Payable Owners' Equity Common Stock Retained Earnings $ 17,852 $ (8,999) Total Total Liab. And Owners Eq. $ (6,523) (1,113) (54) 1,163 Accounting in Excel Corporation Balance Sheet years ended February 28, 2021 and 2022 (504) 659 2021 $ 13,682 $ 43,806 $ 81,636 $ 139,124 $ 558,864 $ 697,988 $ 137,024 $ 67,882 $ 204,906 $100,000 $ 190,000 $ 203,082 $ 393,082 $ 697,988 100.00% $ 19,854 -50.41% $ (8,800) -36.54% (7,001) -6.23% (985) -0.30% $ (89) $ 6.51% -2.82% $ 3.69% 80.07% 100.00% 19.63% 9.73% 29.36% 14.33% 2,979 (984) $ 1,995 1.96% $ 16,950 6.28% $ 47,126 $ 110,580 11.70% 19.93% $ 174,656 2022 2022 $ 587,016 $ 761,672 $ 115,300 $ 90,428 $ 205,728 50,000 27.22% $ 190,000 $ 315,944 29.10% 56.32% $ 505,944 100.00% $ 761,672 100.00% -44.32% -35.26% -4.96% -0.45% 15.00% -4.96% 10.05% 2.23% 6.19% 14.52% 22.93% 77.07% 100.00% 15.14% 11.87% 27.01% 6.56% 24.95% 41.48% 66.43% 100.00%
Expert Answer:
Related Book For
Accounting Principles Volume 1
ISBN: 978-1119502425
8th Canadian Edition
Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel, Barbara Trenholm, Valerie Warren, Lori Novak
Posted Date:
Students also viewed these accounting questions
-
Suppose that the firm used the LIFO inventory method to obtain the inventory assessments. Let the LIFO reserves be $189, $158, $129, $293, $255, $103 (in millions) for the years from 2011 to 2016...
-
In July 2011, the finale to the Harry Potter movie series, Harry Potter and the Deathly Hallows Part 2, from Time Warner Inc.s Warner Bros. Pictures, earned an estimated $ 307 million in 59 countries...
-
The Thompson Toy Company manufactures toy building block sets for children. Thompson is planning for 2017 by developing a master budget by quarters. Thompsons balance sheet for December 31, 2016,...
-
Consider the following function. def f(x): a = [] while x > 0: a.append(x) f(x-1) A new object of type list is created for each recursive invocation of f. True or False
-
If the premining stress state in Problem 16 where hydrostatic (3D), what shape would be more favorable, an ellipse, rectangle, or ovaloid (with semi-axes ratio of 2)?
-
To reduce the use of drugs and other harmful substances, some public schools have started to use dogs to locate undesirable substances. Many arguments have been directed against this practice,...
-
What groups need the outputs of an accounting information system?
-
Freeman and Lueke, attorneys-at-law, provided legal representation to Murphy Equipment Inc. in a product liability suit. Twenty partner hours and 65 associate hours were worked in defending the...
-
(Alternative dividend policies) Final earnings estimates for the Smithfield Meat Packing Company have been prepared for the CFO of the company and are shown in the following table: The firm has...
-
For this assignment, you will select an alternative consumer subculture to explore and analyze. Although we all belong to multiple subcultures, this assignment requires that you choose a subculture...
-
Having read the article and considered the benefits of machine learning and big data, compare and contrast the characteristics and challenges of using the traditional survey method when conducting...
-
The Lawn Company provides commercial landscaping services in San Diego. The firm's owner wants to develop cost estimates that she can use to prepare bids on jobs. After analyzing the firm's costs,...
-
Saginaw Inc. completed its first year of operations with a pretax loss of $555,000. The tax return showed a net operating loss of $692,000, which the company will carry forward. The $137,000 book-tax...
-
Question 1 (8 marks) Today is January 2018 and company ABC, a manufacturer of jewelry, knows it will need to purchase 5,000 ounces of gold in a year to fulfill a large customer order. Each futures...
-
If my company pays a utilitty bill, will be assets increase or decrease. Will my liabilities increase or decrease and how will be net income be - increase, decrease, or no change?
-
Mind of Mine Corporation has provided the following data from its activity-based costing accounting system: Indirect factory wages P 16,000 Factory equipment depreciation P193,000 Distribution of...
-
Sheridan Service sells oil at a markup of 42% of the selling price. Sheridan paid $0.91 per litre of oil. (a) What is the selling price per litre? (b) What is the rate of markup based on cost? (a)...
-
In your audit of Garza Company, you find that a physical inventory on December 31, 2012, showed merchandise with a cost of $441,000 was on hand at that date. You also discover the following items...
-
Canadian Coat Company sells outdoor apparel to retailers all over Canada. The owner, Leo Wallace, is trying to decide whether to use the contract-based or earnings approach for revenue recognition....
-
ND Paint Designs began operations on April 1, 2021. The company completed the following transactions in its first month: Instructions a. For each transaction, indicate: (1) the basic type of account...
-
The accountant for Coulombe Company is almost finished preparing the work sheet for the year ended July 31, 2021. The totals of the accounts in the income statement and balance sheet columns are...
-
Which of the following is false about perfect competition? a. Perfectly competitive firms sell homogeneous products. b. A perfectly competitive industry allows easy entry and exit. c. A perfectly...
-
What is a price taker?
-
What is total revenue?
Study smarter with the SolutionInn App