Columbia Works (TSE:146A) Days Inventory : 374.18 (As of Dec. 2023)

View and export this data going back to 2024. Start your Free Trial

What is Columbia Works Days Inventory?

Days Inventory is also known as Days Sales of Inventory (DSI). Columbia Works's Average Total Inventories for the three months ended in Dec. 2023 was 円17,752 Mil. Columbia Works's Cost of Goods Sold for the three months ended in Dec. 2023 was 円4,329 Mil. Hence, Columbia Works's Days Inventory for the three months ended in Dec. 2023 was 374.18.

The historical rank and industry rank for Columbia Works's Days Inventory or its related term are showing as below:

TSE:146A' s Days Inventory Range Over the Past 10 Years
Min: 475.84 Med: 604.13 Max: 1481.67
Current: 1481.67

During the past 3 years, Columbia Works's highest Days Inventory was 1481.67. The lowest was 475.84. And the median was 604.13.

TSE:146A's Days Inventory is ranked worse than
72.42% of 1327 companies
in the Real Estate industry
Industry Median: 699.45 vs TSE:146A: 1481.67

Columbia Works's Days Inventory increased from . 20 (0.00) to Dec. 2023 (374.18). It might indicate that Columbia Works's sales slowed down.

Warning Sign:

If a company builds up inventory, it may mean it is having difficulties selling its goods.

Inventory Turnover measures how fast the company turns over its inventory within a year. Columbia Works's Inventory Turnover for the three months ended in Dec. 2023 was 0.24.

Inventory-to-Revenue determines the ability of a company to manage their inventory levels. It measures the percentage of Inventories the company currently has on hand to support the current amount of Revenue. Columbia Works's Inventory-to-Revenue for the three months ended in Dec. 2023 was 3.09.

Columbia Works Days Inventory Historical Data

The historical data trend for Columbia Works's Days Inventory can be seen below:

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

* Premium members only.

Columbia Works Days Inventory Chart

Columbia Works Annual Data

Trend

Dec21

Dec22

Dec23

Days Inventory

475.84

646.04

604.13

Columbia Works Quarterly Data
	Dec21	Dec22	Sep23	Dec23
Days Inventory	-	-	-	374.18

Competitive Comparison of Columbia Works's Days Inventory

For the Real Estate - Development subindustry, Columbia Works's Days Inventory, along with its competitors' market caps and Days Inventory data, can be viewed below:

* Competitive companies are chosen from companies within the same industry, with headquarter located in same country, with closest market capitalization; x-axis shows the market cap, and y-axis shows the term value; the bigger the dot, the larger the market cap. Note that "N/A" values will not show up in the chart.

Columbia Works's Days Inventory Distribution in the Real Estate Industry

For the Real Estate industry and Real Estate sector, Columbia Works's Days Inventory distribution charts can be found below:

* The bar in red indicates where Columbia Works's Days Inventory falls into.

Columbia Works Days Inventory Calculation

Days Inventory indicates the number of days of goods in sales that a company has in the inventory.

Columbia Works's Days Inventory for the fiscal year that ended in Dec. 2023 is calculated as

	Days Inventory (A: Dec. 2023 )
=	Average Total Inventories					/	Cost of Goods Sold	*	Days in Period
=	( (Total Inventories (A: Dec. 2022 )	+	Total Inventories (A: Dec. 2023 ))	/	count )	/	Cost of Goods Sold (A: Dec. 2023 )	*	Days in Period
=	( (17216	+	17933)	/	2 )	/	10618	*	365
=	17574.5					/	10618	*	365
=	604.13

Columbia Works's Days Inventory for the quarter that ended in Dec. 2023 is calculated as:

	Days Inventory (Q: Dec. 2023 )
=	Average Total Inventories					/	Cost of Goods Sold	*	Days in Period
=	( (Total Inventories (Q: Sep. 2023 )	+	Total Inventories (Q: Dec. 2023 ))	/	count )	/	Cost of Goods Sold (Q: Dec. 2023 )	*	Days in Period
=	( (17570	+	17933)	/	2 )	/	4329	*	365 / 4
=	17751.5					/	4329	*	365 / 4
=	374.18

Columbia Works (TSE:146A) Days Inventory Explanation

Days Inventory indicates the liquidity of the inventory. Generally, a lower Days Inventory is preferred as it indicates a shorter duration to clear off the inventory. An increase of the ratio may indicate the company's sales slowed. Similar ratios related to Days Inventory are:

1. Inventory Turnover measures how fast the company turns over its inventory within a year.

Columbia Works's Inventory Turnover for the three months ended in Dec. 2023 is calculated as

Inventory Turnover	=	Cost of Goods Sold	/	Average Total Inventories
	=	4329	/	17751.5
	=	0.24

2. Inventory-to-Revenue determines the ability of a company to manage their inventory levels. It measures the percentage of Inventories the company currently has on hand to support the current amount of Revenue.

Columbia Works's Inventory to Revenue for the three months ended in Dec. 2023 is calculated as

Inventory-to-Revenue	=	Average Total Inventories	/	Revenue
	=	17751.5	/	5739
	=	3.09

Be Aware

A lot of business are seasonable. It makes more sense to compare Days Inventory from the same period in the previous year instead of from the previous quarter.

Columbia Works Days Inventory Related Terms

Thank you for viewing the detailed overview of Columbia Works's Days Inventory provided by GuruFocus.com. Please click on the following links to see related term pages.

Columbia Works (TSE:146A) Business Description

Industry

GURUFOCUS.COM » STOCK LIST » Real Estate » Real Estate » Columbia Works Inc (TSE:146A) » Definitions » Days Inventory

Comparable Companies

Traded in Other Exchanges

N/A

Address

3-28-15 Shibuya, Shibuya-ku, Tokyo, JPN, 150-0002

Website

https://www.columbiaworks.jp

Columbia Works Inc is engaged in Real estate development, Real estate leasing and management and Hotel management.

Columbia Works (TSE:146A) Headlines

No Headlines