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
- Use the sum function to calculate the dollar amount only
- Create your own formula for vertical analysis
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
Vertical ana... View full answer
Get step-by-step solutions from verified subject matter experts
