| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | Cash Conversion Cycle: Selected Data | Days Sales Outstanding | Total | Start Date | End Date | |||||
2 | [COMPANY] | Total AR | $2,555,104.91 | |||||||
3 | Period Ending [DATE] | Total Sales Sum | $17,102,416.03 | |||||||
4 | Days in Period | 262 | 1/1/2023 | 9/20/2023 | ||||||
5 | Total accounts receivable | $2,555,105 | DSO | 39.1428606 | ||||||
6 | Total revenue | $17,102,416 | ||||||||
7 | Total inventory cost | $1,500,213 | Days Inventory Outstanding | |||||||
8 | Total COGS | $13,266,430 | Average Inventory Cost | $1,500,212.85 | ||||||
9 | Total accounts payable | $1,004,446 | Cost of Goods Sold | $13,266,430.25 | ||||||
10 | Days in Period | 262 | 1/1/2023 | 9/20/2023 | ||||||
11 | DIO | 29.62784715 | ||||||||
12 | Days Sales Outstanding | 39 | ||||||||
13 | Days Inventory Outstanding | 30 | Accounts Payable Average | |||||||
14 | Days Payable Outstanding | 20 | Total AP | $1,004,446.28 | ||||||
15 | Cash conversion cycle | 49 | Cost of Goods Sold | $13,266,430.25 | ||||||
16 | Days in Period | 262 | 1/1/2023 | 9/20/2023 | ||||||
17 | DPO | 19.8369057 | ||||||||
18 | ||||||||||
19 | ||||||||||
20 | Uncover the secrets with The Optimized Report, an exclusive Sunday morning newsletter with 1 actionable tip to dramatically improve your performance, profit, and potential without sacrificing what's most important—TIME. | |||||||||
21 | ||||||||||
22 | Get optimized this Sunday: | https://www.nateanglin.com/newsletter | ||||||||