Investment Detective
Autor: Ahmed Zaman • November 2, 2016 • Case Study • 265 Words (2 Pages) • 677 Views
Appendix 1:
Table 1: Assumptions
2016 | 2017 | 2018 | 2019 | Reasons for the assumptions | |
Sales | 1160.44 | 1244.93 | 1307.59 | 1332.64 | |
Revenue growth | 5.62% | 7.28% | 5.03% | 1.92% | Average of last 10 yrs growth |
Shipping & Handling | 27.47% | 26.79% | 26.59% | 26.32% | Average of last 10 yrs % of sale |
Product Cost | 44.05% | 44.41% | 44.38% | 44.25% | Average of last 10 yrs % of sale |
SG&A Expenses | 8.36% | 8.59% | 8.62% | 8.69% | Average of last 10 yrs % of sale |
Other Expenses | 0.72% | 0.07% | 0.20% | 0.10% | Average of last 10 yrs % of sale |
Depreciation | 10.52% | 10.40% | 10.36% | 10.38% | Average of last 10 yrs in % of fix. asst |
Dep. Amount | 91.29 | 98.28 | 106.99 | 118.56 | Fixed asset*Depreciation Rate |
Tax rate | 40.00% | 40.00% | 40.00% | 40.00% | Normal rate |
Net Fix. Asst Growth | 8.36% | 8.96% | 9.27% | 10.54% | Avge of last 10 yrs % of fix. asst growth |
Total Current Asset | 46.92% | 47.09% | 47.46% | 47.90% | Average of last 10 yrs % of sale |
Tot. Current Liability | 19.85% | 19.95% | 20.12% | 20.20% | Average of last 10 yrs % of sale |
...