Complete all the blue cells !

B D E F G H 1 J K L M N 1 2 2016 2017 FINANCIAL STATEMENTS Balance Sheet Check 2018 OK 2019 OK 2020 OK Forecast Period 2021 2022 COMMENTS OK OK Describe assumptions 3 OK OK 4 5 FOR ENTIRE WORKSHEET ONLY INPUT INTO BLUE FILLED CELLS. ALL OTHER CELLS A 6 7 8 9 10 n/a 40.7% 22,658 10,125 39.9% 5.0% 29.2% 11.2% 37.4% 23,872 10,087 40.6% 3.0% 28.7% Assumptions Income Statement Revenue Growth (% Change) Cost of Goods Sold (% of Revenue) Salaries and Benefits ($000's) Rent and Overhead ($000's) Depreciation & Amortization (% of PP&E) Interest (% of Beginning Debt) Tax Rate (% of Earnings Before Tax) Balance Sheet Accounts Receivable (Days) Inventory (Days) Accounts Payable (Days) Capital Expenditures ($000's) Debt Issuance (Repayment) ($000's) Equity Issued (Repaid) ($000's) Dividends 8.4% 37.4% 23,002 11,020 41.2% 3.0% 29.0% 5.9% 38.0% 25,245 11,412 41.7% 3.0% 29.1% 11 12 13 14 15 16 18 73 37 15,000 18 73 37 15,000 (20,000) 18 72 36 15,000 18 72 36 15,000 17 18 19 20 21 22 B D E F G H 1 J K L M N 1 2 2016 2017 FINANCIAL STATEMENTS Balance Sheet Check 2018 OK 2019 OK 2020 OK Forecast Period 2021 2022 COMMENTS OK OK Describe assumptions 3 OK OK 4 5 FOR ENTIRE WORKSHEET ONLY INPUT INTO BLUE FILLED CELLS. ALL OTHER CELLS A 6 7 8 9 10 n/a 40.7% 22,658 10,125 39.9% 5.0% 29.2% 11.2% 37.4% 23,872 10,087 40.6% 3.0% 28.7% Assumptions Income Statement Revenue Growth (% Change) Cost of Goods Sold (% of Revenue) Salaries and Benefits ($000's) Rent and Overhead ($000's) Depreciation & Amortization (% of PP&E) Interest (% of Beginning Debt) Tax Rate (% of Earnings Before Tax) Balance Sheet Accounts Receivable (Days) Inventory (Days) Accounts Payable (Days) Capital Expenditures ($000's) Debt Issuance (Repayment) ($000's) Equity Issued (Repaid) ($000's) Dividends 8.4% 37.4% 23,002 11,020 41.2% 3.0% 29.0% 5.9% 38.0% 25,245 11,412 41.7% 3.0% 29.1% 11 12 13 14 15 16 18 73 37 15,000 18 73 37 15,000 (20,000) 18 72 36 15,000 18 72 36 15,000 17 18 19 20 21 22