Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2014A 2015A 2016A 2017E 2018E 2019E 2020E 2021E Cash and equivalents 279.7 251.3 304.3 371.3 359.7 368.6 437.5 Accounts receivable 1,552.5 1,894.0 2,315.4 2,824.9

image text in transcribed

2014A 2015A 2016A 2017E 2018E 2019E 2020E 2021E Cash and equivalents 279.7 251.3 304.3 371.3 359.7 368.6 437.5 Accounts receivable 1,552.5 1,894.0 2,315.4 2,824.9 3,276.9 3,539.1 3,751.4 Inventory 1,672.9 2,096.7 2,436.3 2,997.9 3,477.6 3,755.8 3,981.1 Other current assets 253.5 311.8 371.9 461.2 535.0 577.8 612.5 Current assets 3,758.6 4.553.8 5,427.8 6,655.3 7,649.2 8,241.3 8,782.5 484.6 3,976.5 (24.5% of projected sales). 4,220.0 (26% of projected sales) 649.2 (4% of projected sales) 9,330.3 Net PP&E 3,874.0 4,293.3 4,654.1 4,847.8 4,938.8 4,875.2 4,789.5 4,698.6 Total assets Accounts payable 7,632.6 8,847.2 10,082.0 11,503.2 12,588.0 13,116.5 13,572.0 14,028.9 773.1 935.3 1,153.0 1,383.6 1,605.0 1,733.4 1,837.4 Accrued expenses 418.2 491.0 567.2 714.9 829.3 895.6 949.3 1,947.7 (12% of projected sales) 1,006.3 (6.2% of projected sales) Bank loans 3,020.0 3,880.0 4,580.0 5,080.0 5,230.0 4,930.0 4,530.0 4,030.0 Deferred taxes 351.9 360.7 406.2 527.9 590.1 624.0 658.3 702.5 Long-term debt, current portion 150.0 150.0 150.0 150.0 150.0 150.0 150.0 150.0 Current Liabilities 4,713.2 5,817.0 6,856.5 7,856.4 8,404.4 8,333.1 8,125.1 7,836.5 Long-term debt 1,980.0 1,830.0 1,680.0 1,530,0 1,380.0 1,230.0 1,080.0 930.0 Total liabilities 6,693.2 7,647.0 8,536.5 9,386.4 9,784.4 9,563.1 9,205.1 8,766.5 Shareholders' equity 939.4 1,200.1 1,545.5 2,116.8 2,803.6 3,553.4 4,366.9 5,262.4 Total liabilities and equity 7,632.6 8,847.2 10,082.0 11,503.2 12,588.0 13,116.5 13,572.0 14,028.9 Bank loan (receivables + inventory) 0.94 0.97 0.96 0.87 0.77 0.68 0.59 0.49 Liabilities book equity 7.1x 6.4x 5.5x 4.4x 3.5x 2.7x 2.1x 1.7x -954.6 Total interest-bearing debt / book equity 5.5x 4.9x 4.1x 3.2x 2.4x 1.8x 1.3x 1.0x Tables below are not shown in case Working Capital Assumptions (U.S. $ thousands) 2014A 2015A 2016A 2017E 2018E 2019E 2020E 2021E Income Statement Metrics Revenue 6,336.9 7,794.4 9,298.7 11,530.4 Cost of Goods Sold 2,686.8 3,359.4 4,035.6 4,958.1 13,375.3 5,751.4 14,445.3 6,211.5 15,312.0 16,230.7 6,584.2 6,979.2 Working Capital Ratios Accounts receivable (% Sales) 24.5% 24.3% 24.9% 24.5% 24.5% 24.5% 24.5% 24.5% Inventory (% Sales) 26.4% 26.9% 26.2% 26.0% 26.0% 26.0% 26.0% 26.0% Accounts payable (% Sales) 12.2% 12.0% 12.4% 12.0% 12.0% 12.0% 12.0% 12.0% Other Activity Ratios Other Current Assets (% Sales) 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% Accrued Expenses (% Sales) 6.6% 6.3% 6.1% 6.2% 6.2% 6.2% 6.2% 6.2% 2014A 2015A 2016A 2017E 2018E 2019E 2020E 2021E PP&E (Beginning) 3,618.0 3,874.0 4,293.3 4,654.1 4,847.8 4,938.8 4,875.2 4,789.5 Less: Depreciation (98.9) (102.9) (122.7) (152.2) (176.6) Add: CapEx & Purchase of PP&E 354.9 522.2 483.5 PP&E (Ending) 3,874.0 4,293.3 4,654.1 345.9 4,847.8 267.5 4,938.8 (208.0) 144.5 4,875.2 (238.9) (253.2) 153.1 4,789.5 162.3 4,698,6 Depreciation (% Sales) 1.6% 1.3% 1.3% 1.3% 1.3% 1.4% 1.6% 1.6% CapEx (% Sales) 5.6% 6.7% 5.2% 3.0% 2.0% 1.0% 1.0% 1.0% Long-Term Debt Schedule (U.S. $ thousands) 2014A 2015A 2016A 2017E 2018E 2019E 2020E 2021E Beginning balance (with current portion) 2,280.0 2,130.0 1,980.0 1,830.0 Add: issuances 0.0 Less: retirements (150.0) 0.0 (150.0) 0.0 (150.0) 0.0 (150.0) 1,680.0 0.0 (150.0) Ending balance (with current portion) 2,130.0 1,980.0 1,830.0 1,680.0 1,530.0 1,530.0 0.0 (150.0) 1,380.0 Ending balance (without current portion) 1,980.0 1,830.0 1,680.0 1,530.0 1,380.0 1,230.0 1,380.0 0.0 (150.0) 1,230.0 1,080.0 1,230.0 0.0 (150.0) 1,080.0 930.0 Current portion of long-term debt 150.0 150.0 150.0 150.0 150.0 150.0 150.0 150.0 Interest rate as % of beginning balance 5.5% 5.5% 5.5% 5.5% 5.5% 5.5% 5.5% 5.5% Interest payment 247.5 283.3 322.3 352.6 371.8 371.8 347.1 316.8 Deferred Tax Schedule (U.S. $ thousands) 2014A 2015 A 2016A 2017E 2018E 2019E 2020E 2021E Beg, accrued taxes 515.8 351.9 360.7 406.2 527.9 590.1 624.0 658.3 Accrual of taxes 131.6 140.4 186.0 307.6 369.8 403.8 438.0 482.2 Tax payments 295.5 131.6 140.4 186.0 307.6 369.8 403.8 438.0 End. accrued taxes 351.9 360.7 406.2 527.9 590.1 624.0 658.3 702.5 Tax payments as % of previous year's EBT 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance

Authors: Thomas Garman, Raymond Forgue

12th edition

9781305176409, 1133595839, 1305176405, 978-1133595830

More Books

Students also viewed these Finance questions

Question

How much autonomy and independence will you have in your work life?

Answered: 1 week ago