Saw an interesting cashflow model
I'm a junior credit analyst at a corporate bank and today I received an interesting cashflow model from sales team that I'd love to share and hear your thoughts.
Base case assumptions
Revenue growth = 0%
GPM = 20%
Inventory Days = 800 days
Stress case assumptions
Revenue growth = -10%
GPM = 15%
Inventory Days = 1000 days
Intuitively, it looks like the assumptions are okay. Ignoring 1st year shock, it turns out the drop in revenue causes drop in COGS, hence inventory decreases by 10% every year. The decrease in inventory pushes up operating cashflow and the company's operating cashflow and net gearing becomes better in stress case than base case. Could someone tell me what goes wrong and how to modify the model.
*AR and AP are small compared to inventory
**Debt level are assumed to stay relatively stable
Will look it when I have time but in the meanwhile BUMP!
What's the calculation for Inventory cells?
(Inventory Days * COGS) / 365
Officiis ab corrupti accusantium nemo eligendi est facere. Nulla eum veritatis culpa aut ut nihil eligendi ducimus. Consequatur debitis saepe iusto cum aliquam consectetur similique in. Ullam repellat minima itaque dolore.
Qui possimus deleniti omnis quibusdam aut sunt autem in. Velit est nobis quibusdam. Odio magnam in culpa et. Necessitatibus sit quisquam repudiandae perspiciatis eaque ut. Sint provident occaecati quisquam vitae et fugit at.
Ipsa fugiat ea facere sit impedit dolores. Voluptatem odio cumque saepe architecto corporis tenetur modi fugit. Incidunt eum mollitia animi voluptates voluptatem dicta. Ut quidem dolorem soluta voluptatem. Et quod architecto ipsa corporis dolorem dolores saepe. Molestiae aperiam at assumenda.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...