Could you help with this financial model that requires indepth understanding of finance and accounting

Intro Financial Modeling V Overview Key Topics 3-Statement Model Depreciation Amortization Earnings Per Share Dividends Working Capital Schedule PP&E Schedule Intangibles Schedule Capital Expenditures Simple Debt Schedule Revolver Interest Calculations Circular Reference For Training Purposes Only Pillars of Wall Street www.pillarsofwallstreet.com AllinRights Reserved. which may not be reproduced or Pillars of Wall Street owns all rights this publication, distributed, in whole or in part, without Pillars of Wall Street's prior consent. Pillars of Wall Street info@pillarsofwallstreet.com Intro Financial Modeling V Assumptions 2015A Income Statement YoY sales growth COGS % of sales SG&A % of sales Depreciation % of sales Amortization % of sales Effective tax rate WASO Dividend payout ratio Balance Sheet A/R % of sales Inventory % of COGS Other current assets % of sales Capex % of sales Additions to intangibles Other long term assets % of sales A/P % of COGS Other current liabilities % of COGS Long term debt issuance Long term debt repayment Other long term liabilities Common stock Interest Rates Cash Revolver Long term debt Pillars of Wall Street 2016P 2017P 2018P 2019P 2020P 3.0% 50.0% 15.0% 6.7% 1.7% #DIV/0! 4,000.0 #DIV/0! 3.0% 50.0% 17.0% 6.7% 1.7% 32.0% 4,000.0 #DIV/0! 3.0% 50.0% 17.0% 6.7% 1.7% 32.0% 4,000.0 #DIV/0! 3.0% 50.0% 17.0% 6.7% 1.7% 32.0% 4,000.0 #DIV/0! 3.0% 50.0% 17.0% 6.7% 1.7% 32.0% 4,000.0 #DIV/0! 3.0% 50.0% 17.0% 6.7% 1.7% 32.0% 4,000.0 #DIV/0! 25.0% 20.0% 8.3% 600.0 800.0 25.0% 20.0% 9.0% 12.0% 0.0 2.5% 63.3% 10.0% 700.0 600.0 600.0 800.0 25.0% 20.0% 9.0% 12.0% 0.0 2.5% 63.3% 10.0% 0.0 600.0 600.0 800.0 25.0% 20.0% 9.0% 12.0% 0.0 2.5% 63.3% 10.0% 0.0 600.0 600.0 800.0 25.0% 20.0% 9.0% 12.0% 200.0 2.5% 63.3% 10.0% 0.0 600.0 600.0 800.0 25.0% 20.0% 9.0% 12.0% 200.0 2.5% 63.3% 10.0% 0.0 600.0 600.0 800.0 2.0% 4.0% 8.0% 2.0% 4.0% 8.0% 2.0% 4.0% 8.0% 2.0% 4.0% 8.0% 2.0% 4.0% 8.0% 2.0% 4.0% 8.0% 2.5% 63.3% 10.0% info@pillarsofwallstreet.com Intro Financial Modeling V Calculations 2015A Pillars of Wall Street 2016P 2017P 2018P 2019P 2020P info@pillarsofwallstreet.com Intro Financial Modeling V Debt Schedule 2015A Pillars of Wall Street 2016P 2017P 2018P 2019P 2020P info@pillarsofwallstreet.com Intro Financial Modeling V Income Statement 2015A Sales COGS Depreciation Gross profit Gross margin SG&A Amortization Operating profit Operating margin Interest income Interest expense Profit before taxes Taxes Net income Net margin Shareholder data WASO Earnings per share Dividends Pillars of Wall Street 2016P 2017P 2018P 2019P 2020P 12,000.0 6,000.0 800.0 1,800.0 200.0 25.0 350.0 1,016.0 4,000.0 900.0 info@pillarsofwallstreet.com Intro Financial Modeling V Balance Sheet 2015A Cash Accounts receivable Inventory Other current assets Total current assets 2,950.0 3,000.0 1,200.0 1,000.0 PP&E Intangibles Other long term assets Total assets 5,050.0 1,000.0 300.0 Revolver Accounts payable Other current liabilities Total current liabilities 1,900.0 3,800.0 600.0 Long term debt Other long term liabilities Total liabilities 5,500.0 600.0 Common stock Retained earnings Total equity 800.0 1,300.0 2016P 2017P 2018P 2019P 2020P Total liabilities and equity Balance sheet check Pillars of Wall Street info@pillarsofwallstreet.com Intro Financial Modeling V Cash Flow Statement 2016P Pillars of Wall Street 2017P 2018P 2019P 2020P info@pillarsofwallstreet.com