Calculate the working capital (green) based on the provided information (yellow)

Design Your Own Doll Current year end Year counter Year Operating projections (given) Revenue Revenue Growth Production Costs: Fixed Production Expense (excl. depreciation) Variable Production Costs Depreciation Total Production Costs Selling, General & Administrative Total Operating Expenses Operating Profit Working Capital Assumptions: Minimum Cash Balance as % of Sales Days Sales Outstanding 31 Dec 10 Inventory Turnover (based on total production costs) Days Payable Outstanding (based on total cash op. exp.) Capital Expenditures Assumptions Tax rate Perpetuity growth rate Discount rate Investment in working capital Application development personnel costs Working capital Cash Receivables Inventory Payables Total working capital Change in working capital 1 2 2010 2011 2012 3 2013 4 5 6 7 8 9 10 2020 2014 2015 2016 2017 2018 2019 -- -- 6,000 (1,650) (2,250) (310) (4,210) (1,240) (5,450) 14,360 20,222 21,435 22,721 24,084 25,529 27,061 28,685 139.33% 40.82% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% (1,683) (1,717) (1,751) (1,786) (1,822) (1,858) (1,895) (1,933) (7,651) (11,427) (12,182) (12,983) (13,833) (14,736) (15,694) (16,712) (310) (310) (436) (462) (490) (520) (551) (584) (9,644) (13,454) (14,369) (15,231) (16,145) (17,113) (18,140) (19,229) (2,922) (4,044) (4,287) (4,544) (4,817) (5,106) (5,412) (5,737) (12,566) (17,498) (18,656) (19,775) (20,962) (22,219) (23,553) (24,966) (1,201) (1,201) -- -- (1,201) -- 550 1,794 2,724 2,779 2,946 3,123 3,310 3,509 3,719 3.00% 59.2x 12.2x 33.7x 3.00% 59.2x 12.3x 33.8x 3.00% 3.00% 3.00% 3.00% 59.2x 59.2x 59.2x 59.2x 59.2x 59.2x 12.6x 12.7x 12.7x 12.7x 12.7x 12.7x 12.7x 33.9x 33.9x 33.9x 33.9x 33.9x 33.9x 33.9x 3.00% 3.00% 3.00% 59.2x 4,610 310 310 2,192 826 875 928 983 1,043 1,105 40.00% 3.00% 9.00% (1,000) (435) -- 1,000 -- -- H