= = = = Merge & Center 4 xfx 8 D E F mancial Statements cel Assessment - Instructions 1. Please complete the following tab by completing a working, inked, three-statement model a P&L, Balance Sheet, Working Capital and Cash Flows should be inked, b Balance Sheet should balance Fikin every cell highlighted in yelow. 2 Instructions Financial Statements + 21 N atv A Mat AutoSave DEE Financial Statement Exc Home Insert Draw Page Layout Formulas Data Review View Tell me Arial 10 29 Wrap Text General Paste B T UM ch Merge & Center % H34 FH$6 A F G 1 Financial Statements Excel Assessment 4 15 in million 2016 $90.0 7 Sales YoY Grown COGS 10 11 12 18 PAL 2017 2010 2019 2020 2021 2022 $100.0 15.15 650 65.0% 65,0% 650 650% 05.0% 165.0% $35.0 $0.0 30.0 30.0 $0.0 $0.0 35.0% DIVIDI VOI DIV/0! #DIV/0! DIVO 206 20.0% 315.0 50.0 $0.0 50.0 $0.0 $0.0 15.0% ODVODOVODIV/! DIVIO DIVO Gross Margin Margin SGLA d. Depr. & Amort) of EBITDA Mergin 16 10 20 Depreciation & Amortation 22 24 25 25 Ines Expense Texable income TE Tax Rate Net Income 23 30 Caper of revenue 11 + 2018 2019 2020 2021 2022 15 Cash AR Inventory Prepaid Tot Current Assets Balance Sheet 2017 500 SD BO 220 38 39 40 41 13 41 PPRE ne Intangis Goodwil Tatal Assets 15.0 0.0 45.0 Instructions Financial Statements + 21 Maced Financial Statem ne Insert Draw Page Layout Formulas Data Review View Tell me Arial 10 ' Ge ste BIU V a. Av 2 Wrap Text Merge & Center $ > fx =H$6 B C D E F G H Accounts Payable Accrued Expenses Total Current Liabilities 6.0 4.0 - Revolver Term Loan Total Liabilities 0.0 20.0 0.0 20.0 0.0 20.0 0.0 20.0 0.0 20.0 0.0 20.0 Owners Equity 45.0 Total Liabilities & Owners Equity 2018 2019 2020 2021 2022 Days Receivable Inventory Tumover Prepaids as a % of Sales Days Payable Accrued Expenses as a % of Sales Working Capital 2017 18.25 8.13 2.00% 33.69 4.00% Change in: AR Inventory Prepaid Accounts Payable Accrued Expenses Change in NWC Excel File Edit View Insert Format Tools Data Window Help Autosave CFF Q Financial Statement Excel Home Insert Draw Page Layout Formulas Data Review View Tell me Arial 10 Wiap Text General Paste B i Oy A Marge & Center $ % 9 34 fx -H$6 A D G 3 Cash Flow Net Income 2018 2010 2020 2021 2022 Depreciation & Amortization Changes in Current Assets & Liabilities: AR Inventory Prepaid Accounts Payable Acered Expenses Total Changes in Current Assets & Liabilities: Capital Expenditures Net Cash Flow Cash at lleginning of Period Cash at End of Period + 5 Instructions Financial Statements + 21 NJ atv A = = = = Merge & Center 4 xfx 8 D E F mancial Statements cel Assessment - Instructions 1. Please complete the following tab by completing a working, inked, three-statement model a P&L, Balance Sheet, Working Capital and Cash Flows should be inked, b Balance Sheet should balance Fikin every cell highlighted in yelow. 2 Instructions Financial Statements + 21 N atv A Mat AutoSave DEE Financial Statement Exc Home Insert Draw Page Layout Formulas Data Review View Tell me Arial 10 29 Wrap Text General Paste B T UM ch Merge & Center % H34 FH$6 A F G 1 Financial Statements Excel Assessment 4 15 in million 2016 $90.0 7 Sales YoY Grown COGS 10 11 12 18 PAL 2017 2010 2019 2020 2021 2022 $100.0 15.15 650 65.0% 65,0% 650 650% 05.0% 165.0% $35.0 $0.0 30.0 30.0 $0.0 $0.0 35.0% DIVIDI VOI DIV/0! #DIV/0! DIVO 206 20.0% 315.0 50.0 $0.0 50.0 $0.0 $0.0 15.0% ODVODOVODIV/! DIVIO DIVO Gross Margin Margin SGLA d. Depr. & Amort) of EBITDA Mergin 16 10 20 Depreciation & Amortation 22 24 25 25 Ines Expense Texable income TE Tax Rate Net Income 23 30 Caper of revenue 11 + 2018 2019 2020 2021 2022 15 Cash AR Inventory Prepaid Tot Current Assets Balance Sheet 2017 500 SD BO 220 38 39 40 41 13 41 PPRE ne Intangis Goodwil Tatal Assets 15.0 0.0 45.0 Instructions Financial Statements + 21 Maced Financial Statem ne Insert Draw Page Layout Formulas Data Review View Tell me Arial 10 ' Ge ste BIU V a. Av 2 Wrap Text Merge & Center $ > fx =H$6 B C D E F G H Accounts Payable Accrued Expenses Total Current Liabilities 6.0 4.0 - Revolver Term Loan Total Liabilities 0.0 20.0 0.0 20.0 0.0 20.0 0.0 20.0 0.0 20.0 0.0 20.0 Owners Equity 45.0 Total Liabilities & Owners Equity 2018 2019 2020 2021 2022 Days Receivable Inventory Tumover Prepaids as a % of Sales Days Payable Accrued Expenses as a % of Sales Working Capital 2017 18.25 8.13 2.00% 33.69 4.00% Change in: AR Inventory Prepaid Accounts Payable Accrued Expenses Change in NWC Excel File Edit View Insert Format Tools Data Window Help Autosave CFF Q Financial Statement Excel Home Insert Draw Page Layout Formulas Data Review View Tell me Arial 10 Wiap Text General Paste B i Oy A Marge & Center $ % 9 34 fx -H$6 A D G 3 Cash Flow Net Income 2018 2010 2020 2021 2022 Depreciation & Amortization Changes in Current Assets & Liabilities: AR Inventory Prepaid Accounts Payable Acered Expenses Total Changes in Current Assets & Liabilities: Capital Expenditures Net Cash Flow Cash at lleginning of Period Cash at End of Period + 5 Instructions Financial Statements + 21 NJ atv A
