Ebit div0 545 602 653 755 div0 div0 ebitda div0 000

Info icon This preview shows pages 8–12. Sign up to view the full content.

EBIT #DIV/0! 5.45% 6.02% 6.53% 7.55% #DIV/0! #DIV/0! EBITDA #DIV/0! 0.00% 8.37% 0.00% 0.00% #DIV/0! #DIV/0! Pre-Tax #DIV/0! 5.07% #DIV/0! Err:509 6.43% #DIV/0! #DIV/0! Net Income #DIV/0! 0.00% 2.53% 3.53% 0.00% #DIV/0! #DIV/0! Expenses/ Sales COGS/ Sales #DIV/0! -80.39% 78.77% 81.89% -79.46% #DIV/0! #DIV/0! Sales expenses/ Sales #DIV/0! -10.75% 12.35% 8.22% -9.70% #DIV/0! #DIV/0! Admin expenses/ Sales #DIV/0! -3.40% 3.58% 3.82% -3.29% #DIV/0! #DIV/0! Growth Revenue #DIV/0! 13.35% 2.31% 10.53% -100.00% Account Receivables #DIV/0! -100.00% #DIV/0! 368.90% -100.00% EBITDA #DIV/0! Err:509 Err:509 #DIV/0! #DIV/0! EBIT #DIV/0! 76.28% 142.99% 1.54% -100.00% Pre-tax Income #DIV/0! -23.72% 42.09% Err:509 -100.00% Net Income #DIV/0! -23.40% 42.99% #DIV/0! #DIV/0! EPS #DIV/0! 76.60% 142.99% Err:509 -100.00% FCF #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! BVPS #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Invested Capital #DIV/0! 100.45% 107.12% Err:509 -100.00% Coverage Ratios Interest Cover (EBIT/Net Interest) #DIV/0! -196.46% Err:509 #DIV/0! -509.64% #DIV/0! #DIV/0! Net Debt/EBITDA #DIV/0! #DIV/0! Err:509 #DIV/0! #DIV/0! #DIV/0! #DIV/0! FCF/Net Debt #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Liquidity Ratios Current Ratio (Current assets/current liability) #DIV/0! 1.25 0.04 0.28 1.26 #DIV/0! #DIV/0! Quick Ratio (CA-Inventory/CL) #DIV/0! 0.57 0.48 0.55 0.69 #DIV/0! #DIV/0! Capital Structure Net Debt/Total Equity #DIV/0! 0% 3% 3% 0% #DIV/0! #DIV/0! Net Debt/Total Capital #DIV/0! 0% 78% 73% 0% #DIV/0! 0% Net Debt/Capital Employed #DIV/0! 0% #DIV/0! 0% 0% #DIV/0! #DIV/0! Debt/(Debt + Equity) #DIV/0! 67% #DIV/0! Err:509 64% #DIV/0! #DIV/0! Efficiency Cash Conversion (FCF/Recurring Net Income) #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Revenue/Invested Capital #DIV/0! 26.03 5.15 4.92 Err:509 0.00 0.00 Net Income/Invested Capital #DIV/0! 0.00 0.00 Err:509 Err:509 0.00 0.00 FCF/Invested Capital #DIV/0! 0.00 0.00 Err:509 Err:509 0.00 0.00 Business cycle Receivable days #DIV/0! 31.99 1903.02 1936.34 31.39 #DIV/0! #DIV/0! Inventory days #DIV/0! -172.07 18814.43 18814.43 -131.58 #DIV/0! #DIV/0! Payable days 9.17 1789.22 2041.39 13.88 -56.66 -56.66 Cash Conversion Cycle -149.25 18928.24 18709.39 -114.07 #DIV/0! #DIV/0!
Image of page 8

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

KEY ASSUMPTIONS - P&L 2012 2013 2014 2015 2016 REVENUE INCREASE #DIV/0! 13.4% 2.3% 10.5% COGS (% SALE) #DIV/0! -80.4% 78.8% 81.9% -79.5% SELLING EXP. (% SALES) #DIV/0! -10.8% 12.4% 8.2% -9.7% ADMIN. EXP. (% SALES) #DIV/0! -3.4% 3.6% 3.8% -3.3% OTHER INCOME (% SALES) OTHER EXPENSES (% SALES) TAX RATE 0.0% 0.0% 0.0% 0.0% 0.0% MINORITY INTEREST KEY ASSUMPTIONS - BS 2012 2013 2014 2015 2016 RECEIVABLES TURNOVER #DIV/0! 1141% 19% 19% 1163% INVENTORIES TURNOVER #DIV/0! -212% 2% 2% -277% ACCOUNT PAYABLES TURNOVER 0% 3981% 20% #REF! #REF! OTHER CURRENT ASSETS (% SALES) ADVANCE FROM CUSTOMERS (% SALES) #DIV/0! 1% #DIV/0! #REF! #REF! TAX PAYABLE TO GOVERNMENT (% SALES) #DIV/0! 2% #DIV/0! #REF! #REF! PAYABLE TO EMPLOYEES (% SALES) OTHER PAYABLE (% SALES) CAPEX DEPRECIATION (% FIXED ASSETS) #DIV/0! 0% Err:509 RETAINED EARNINGS (% net profit) #REF! #REF! #REF! #REF! #REF!
Image of page 9
2017 2018 2019 2020 <AVERAGE > #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.0% #DIV/0! 2017 2018 2019 2020 <AVERAGE > #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Image of page 10

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

2012 2013 Factory/ware house - - Original Increase Construction completed Re-classified Disposals Depreciation - - Original Increase Re-classified Disposals Equipment and Machinery - - Original Increase Construction completed Re-classified Disposals Depreciation - - Original Increase Re-classified Disposals Vehicles - - Original Increase Construction completed Re-classified Disposals Depreciation - - Original Increase Re-classified Disposals Office equipment - - Original Increase Construction completed Re-classified Disposals Depreciation - - Original Increase Re-classified Disposals Others - - Original Increase Re-classified Disposals Depreciation - - Original Increase Re-classified Disposals Total - - Under construction - - Original - Increase Completion - - Other decrease
Image of page 11
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.
  • Summer '15
  • Balance Sheet, Generally Accepted Accounting Principles, DIV/0

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern