finance Excel work + 5 pages paper
nimab8
JBS_STemplate.xlsxJBS's Working Capital
| JBS'S WORKING CAPITAL - Appendix A | ||||||
| Fiscal Year | Gross Current Assets as % of TA | Net Current Assets as % of TA | Currents Assets | Current Liabilities | Current Ratio | Liquid Ratio |
| 2010/11 | ||||||
| 2011/12 | ||||||
| 2012/13 | ||||||
| 2013/14 | ||||||
| 2014/15 | ||||||
| Note* TA = Total Assets (Exhibit 6) | ||||||
| Gross Working Capital = Current Assets | ||||||
| Net Working Capital = Current Assets - Current Liabilities |
JBS Capital Ratios
| KEY WORKING CAPITAL RATIOS FOR JBS - Appendix B | ||||
| 2010/11 | 2011/12 | 2012/13 | 2013/14 | 2014/15 |
| Inventory Conversion Period (in days) | ||||
| Average Collection Period (iin days) | ||||
| Payables Deferral Period (in days) | ||||
| Operating Cycle (in days) | ||||
| Cash Conversion Cycle (in days) | ||||
Competitor Comparisons
| KEY WORKING CAPITAL RATIOS FOR JBS - Appendix C | |
| INDUSTRY | JBS |
| Inventory Conversion Period (in days) | |
| Average Collection Period (iin days) | |
| Payables Deferral Period (in days) | |
| Operating Cycle (in days) | |
| Cash Conversion Cycle (in days) | |
| Current Ratio | |
| Liquid Ratio |
Sheet2
| PART A - Appendix D | ||||
| In Millions | ||||
| Existing Revenue (2014/15) | ||||
| Existing COGS (78.8% of existing revenue) | ||||
| Increase in Revenue by 8% | ||||
| Less: COGS (78.8% increased revenue) | ||||
| Margin | ||||
| PART B - APPENDIX E | In Millions | |||
| Existing Revenue (2014/15) | ||||
| Less: Existing COGS (78.8% of existing revenue) | ||||
| Margin | ||||
| 8% | 10% | 12% | 14% | 16% |
| Revenue (in millions) | ||||
| Cost of Goods Sold (78.8% of existing revenue) | ||||
| Margin (in millions) | ||||
| Less: Discount of 2% on 50% of Sales (in millions) | ||||
| Margin after discount | ||||
