phi Deta Sigma B Dropbox Folder x er/Downloads/S21Chapter 12ExcelHomework.pdf L Page view A) Read aloud IV Draw V Chapter 12 - Vertical Analysis (Common Size Financial Statements) Recreate the financial statements on the next page in Excel and submit to dropbox - The file submitted to dropbox should be in Excel format Use Excel formulas wherever possible (note shaded areas!) a) Use the sum function to calculate dollar amounts only b) Create your own formula for the vertical analysis percent's (No sum function) Example: -A3/$A$10 Remember the S sign is called the absolute key, when coping formulas, whatever appears before the $ sign is absolute (ie, doesn't change) Make your statements look nicell Anyone caught submitting someone else's work will receive a zero on this assignment ions.pdf S21Chapter04 Home....pdf Open file 521Chapter 12 ExcelH...pdf Open file O TV 2 Study Guide 5FX bphi beta sigma X B Dropbox Folder Downloads/S21Chapter 12Excel Homework.pdf 1 D Page view A Read aloud Draw Online Accounting Corporation Income Statement for the years ended October 31, 2020 and 2021 Net Sales Cost of Goods Sold Selling Expenses Depreciation Expense Other Expenses Earnings before taxes Taxes Net Earnings $ $ $ $ $ 5 $ $ 2020 17.852 (8.999) (6,523) (1.113) 54) 1.163 1504) 100.00% -50.41% -36.54% -6.23% 0.30% 6.51% -2.82% 3.69% 2021 $ 19,854 $ (8.800) $ (7,001) S (985) $ (89) S 2.979 $ 1984) S 1.995 100.00% 44.32% -35.26% 4.96% -0.45 15.00% 4.96% 10.05% Online Accounting Corporation Balance Sheet years ended October 31, 2020 and 2021 2020 2021 Assets Current Assets Cash Accounts Receivable Supplies Total Property. Plant & Equipment Building.net Total Assets $ 13,682 $ 43,800 $ 81,636 $ 139,124 1.96% $ 16,950 $ 47,126 11.70% $110.580 19.93% 174.656 6.28% 2.23% 6.1998 14.52 22.93% $ 558.864 $ 697,988 80.07% 100.00% $ 587,016 $ 761,672 77.07% 100.00% Liabilites and Owners Eq Current Liabilites Accounts Payable Salaries Payable Total Long-Term Notes Payable Owners' Equity Common Stock Retained Earnings Total Total Liab. And Owners Eq $ 137 024 $ 67 882 $ 204,906 $ 100,000 19.63% 9.73% 29.36% 14,33% $ 115,300 $90,428 $ 205,728 $ 50,000 15.14% 11.87% 27.01% 6.56' $ 190,000 $ 203 062 $ 393,082 S097,988 27,22% 29.10% 56 32% 100.00% $ 190,000 $ 315944 SSOS, 944 $761.672 24.95% 41.48% 66.43% 100.00% Note: you should have an Excel formula in all shaded areas pdf PDF S21Chapter 04 Home....pdf Open file S21 Chapter 12ExcelH....pdf Open file ... phi Deta Sigma B Dropbox Folder x er/Downloads/S21Chapter 12ExcelHomework.pdf L Page view A) Read aloud IV Draw V Chapter 12 - Vertical Analysis (Common Size Financial Statements) Recreate the financial statements on the next page in Excel and submit to dropbox - The file submitted to dropbox should be in Excel format Use Excel formulas wherever possible (note shaded areas!) a) Use the sum function to calculate dollar amounts only b) Create your own formula for the vertical analysis percent's (No sum function) Example: -A3/$A$10 Remember the S sign is called the absolute key, when coping formulas, whatever appears before the $ sign is absolute (ie, doesn't change) Make your statements look nicell Anyone caught submitting someone else's work will receive a zero on this assignment ions.pdf S21Chapter04 Home....pdf Open file 521Chapter 12 ExcelH...pdf Open file O TV 2 Study Guide 5FX bphi beta sigma X B Dropbox Folder Downloads/S21Chapter 12Excel Homework.pdf 1 D Page view A Read aloud Draw Online Accounting Corporation Income Statement for the years ended October 31, 2020 and 2021 Net Sales Cost of Goods Sold Selling Expenses Depreciation Expense Other Expenses Earnings before taxes Taxes Net Earnings $ $ $ $ $ 5 $ $ 2020 17.852 (8.999) (6,523) (1.113) 54) 1.163 1504) 100.00% -50.41% -36.54% -6.23% 0.30% 6.51% -2.82% 3.69% 2021 $ 19,854 $ (8.800) $ (7,001) S (985) $ (89) S 2.979 $ 1984) S 1.995 100.00% 44.32% -35.26% 4.96% -0.45 15.00% 4.96% 10.05% Online Accounting Corporation Balance Sheet years ended October 31, 2020 and 2021 2020 2021 Assets Current Assets Cash Accounts Receivable Supplies Total Property. Plant & Equipment Building.net Total Assets $ 13,682 $ 43,800 $ 81,636 $ 139,124 1.96% $ 16,950 $ 47,126 11.70% $110.580 19.93% 174.656 6.28% 2.23% 6.1998 14.52 22.93% $ 558.864 $ 697,988 80.07% 100.00% $ 587,016 $ 761,672 77.07% 100.00% Liabilites and Owners Eq Current Liabilites Accounts Payable Salaries Payable Total Long-Term Notes Payable Owners' Equity Common Stock Retained Earnings Total Total Liab. And Owners Eq $ 137 024 $ 67 882 $ 204,906 $ 100,000 19.63% 9.73% 29.36% 14,33% $ 115,300 $90,428 $ 205,728 $ 50,000 15.14% 11.87% 27.01% 6.56' $ 190,000 $ 203 062 $ 393,082 S097,988 27,22% 29.10% 56 32% 100.00% $ 190,000 $ 315944 SSOS, 944 $761.672 24.95% 41.48% 66.43% 100.00% Note: you should have an Excel formula in all shaded areas pdf PDF S21Chapter 04 Home....pdf Open file S21 Chapter 12ExcelH....pdf Open file
