J K L M N Prepared by Reviewed by Horizontal Ratios 2020 2021 2020 2021 Audited...

Transcribed Image Text:

J K L M N Prepared by Reviewed by Horizontal Ratios 2020 2021 2020 2021 Audited Unaudited Audited Unaudited A B 1 2 3 4 Vacuum.2021. Fluctuation Analysis Vacuum Bonanza, Inc. D E F G H Date Date - 5 Vertical Ratios 6 7 Balance Sheet 8 2019 2020 2021 Audited Audited Unaudited 2019 Audited 9 Assets 10 Cash 621 718 802 11 Accounts receivable 12,926 27,801 51,076 12 Inventories 9,762 19,577 39,135 13 Prepaid expenses 708 1,449 3,015 14 Total current assets 24,017 49,545 94,028 15 16 Property and equipment 63,000 70,000 90,000 17 Accumulated depreciation 43,818 55,212 64,802 18 Net PPE 19,182 14,788 25,198 19 20 Total assets 43.199 64.333 119.226 21 22 Liabilities and Equity 23 Accounts payable 7,344 15,072 13,288 24 Accrued liabilities 3,127 5,468 4,145 25 Current portion L/T debt 2,707 900 1,250 26 Income taxes payable 1,554 2,619 3,782 27 Total current liabilities 14,732 24,059 22,465 28 29 Bank debt 14,800 19,841 62,057 30 Deferred income taxes 685 1,254 1,881 31 Total liabilities 30,217 45,154 86,403 32 33 Common stock 7,775 7,775 7,903 34 Retained Earnings 5,207 11,404 24,920 35 Total liabilities and equity 43.199 64.333 119.226 36 37 Income Statement 38 39 Gross sales 78,428 133,504 183,767 40 Less: Returns and allowances 2,284 5,270 41 Net sales 76,144 128,234 2,644 181,123 42 43 Cost of goods sold 46,213 70,756 94,934 44 Gross margin 29,931 57,478 86,189 45 46 Selling, advertising, R & D expenses 20,105 43,508 63,199 47 Income from operations 9,826 13,970 22,990 48 49 Interest expense 1,930 1,584 3,189 50 Income before taxes 7,896 12,386 19,801 51 52 Income taxes 3,807 6,189 53 Net income 4.089 6.197 7,761 12.040 54 55 EPS 0.46 0.78 1.21 56 57 58 Ratios 59 60 Current 61 Quick 62 Receivable turnover 5.3 63 Day's sales in ending receivables 64 Inventory turnover 4.7 65 Day's sales in ending inventory 66 Interest expense/Debt 67 68 69 Excel Matters 70 71 72 73 74 Shortcut: Use control p, then shift, then move with arrows over, then control v Use conditional formatting to find large percent changes. Use an "if, then" statement to find large changes that are also material to the balance sheet Consider using Merge and Center from the home tab, to label work Consider using different colors to differentiate between years 75 P J K L M N Prepared by Reviewed by Horizontal Ratios 2020 2021 2020 2021 Audited Unaudited Audited Unaudited A B 1 2 3 4 Vacuum.2021. Fluctuation Analysis Vacuum Bonanza, Inc. D E F G H Date Date - 5 Vertical Ratios 6 7 Balance Sheet 8 2019 2020 2021 Audited Audited Unaudited 2019 Audited 9 Assets 10 Cash 621 718 802 11 Accounts receivable 12,926 27,801 51,076 12 Inventories 9,762 19,577 39,135 13 Prepaid expenses 708 1,449 3,015 14 Total current assets 24,017 49,545 94,028 15 16 Property and equipment 63,000 70,000 90,000 17 Accumulated depreciation 43,818 55,212 64,802 18 Net PPE 19,182 14,788 25,198 19 20 Total assets 43.199 64.333 119.226 21 22 Liabilities and Equity 23 Accounts payable 7,344 15,072 13,288 24 Accrued liabilities 3,127 5,468 4,145 25 Current portion L/T debt 2,707 900 1,250 26 Income taxes payable 1,554 2,619 3,782 27 Total current liabilities 14,732 24,059 22,465 28 29 Bank debt 14,800 19,841 62,057 30 Deferred income taxes 685 1,254 1,881 31 Total liabilities 30,217 45,154 86,403 32 33 Common stock 7,775 7,775 7,903 34 Retained Earnings 5,207 11,404 24,920 35 Total liabilities and equity 43.199 64.333 119.226 36 37 Income Statement 38 39 Gross sales 78,428 133,504 183,767 40 Less: Returns and allowances 2,284 5,270 41 Net sales 76,144 128,234 2,644 181,123 42 43 Cost of goods sold 46,213 70,756 94,934 44 Gross margin 29,931 57,478 86,189 45 46 Selling, advertising, R & D expenses 20,105 43,508 63,199 47 Income from operations 9,826 13,970 22,990 48 49 Interest expense 1,930 1,584 3,189 50 Income before taxes 7,896 12,386 19,801 51 52 Income taxes 3,807 6,189 53 Net income 4.089 6.197 7,761 12.040 54 55 EPS 0.46 0.78 1.21 56 57 58 Ratios 59 60 Current 61 Quick 62 Receivable turnover 5.3 63 Day's sales in ending receivables 64 Inventory turnover 4.7 65 Day's sales in ending inventory 66 Interest expense/Debt 67 68 69 Excel Matters 70 71 72 73 74 Shortcut: Use control p, then shift, then move with arrows over, then control v Use conditional formatting to find large percent changes. Use an "if, then" statement to find large changes that are also material to the balance sheet Consider using Merge and Center from the home tab, to label work Consider using different colors to differentiate between years 75 P