Question: Recreate the financial statements Use the sum function to calculate the dollar amount only Create your own formula for vertical analysis Income Statement for the

Recreate the financial statements

  1. Use the sum function to calculate the dollar amount only
  2. Create your own formula  for vertical analysis
Income Statement for the years ended February 28, 2021 and 2022 2021

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%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Vertical ana... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!