Question
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
Calculate the working capital (green) based on the provided information (yellow)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/664433f615d4b_781664433f5e2a3b.jpg)
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started