FOTRF (Mitsui Fudosan Retail Fund Investment) Days Payable: (As of Jun. 2026)

Author: Vera Yuan Vera Yuan
Vera Yuan
Vera Yuan
Director of Data and Quant Analytics at GuruFocus
Focused on building reliable datasets, financial models, and research tools for value-minded investors. Committed to turning complex data into practical guidance for value-investing and long-term wealth.
Reviewed by: Charlie Tian Charlie Tian
Charlie Tian
Charlie Tian
Founder & CEO of GuruFocus
Dr. Charlie Tian is the founder and CEO of GuruFocus.com, a leading global investment research platform established in 2004. With a Ph.D. in physics, Dr. Tian transitioned from science to finance, applying a data-driven, disciplined approach to value investing.

FOTRF Mitsui Fudosan Retail Fund Investment Corp FOTRF
55 GF Score
Price $765.00
GF Value $905.91
! 3 Warning Signs
View Full Analysis

What is Mitsui Fudosan Retail Fund Investment Days Payable?

Mitsui Fudosan Retail Fund Investment's average Accounts Payable for the six months ended in Jun. 2026 was $0.0 Mil. Mitsui Fudosan Retail Fund Investment's Cost of Goods Sold for the six months ended in Jun. 2026 was $34.9 Mil. Hence, Mitsui Fudosan Retail Fund Investment's Days Payable for the six months ended in Jun. 2026 was 0.00.

The historical rank and industry rank for Mitsui Fudosan Retail Fund Investment's Days Payable or its related term are showing as below:

FOTRF' s Days Payable Range Over the Past 10 Years
Min: 26.05   Med: 40.38   Max: 79.87
Current: 52.74

During the past 13 years, Mitsui Fudosan Retail Fund Investment's highest Days Payable was 79.87. The lowest was 26.05. And the median was 40.38.

FOTRF's Days Payable is ranked worse than
69.39% of 539 companies
in the REITs industry
Industry Median: 112.89 vs FOTRF: 52.74

Mitsui Fudosan Retail Fund Investment's Days Payable stayed the same from Jun. 2025 () to Jun. 2026 ().

Mitsui Fudosan Retail Fund Investment Days Payable Related Terms

Mitsui Fudosan Retail Fund Investment Days Payable Historical Data

* Premium members only.

The historical data trend for Mitsui Fudosan Retail Fund Investment's Days Payable 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.

Mitsui Fudosan Retail Fund Investment Days Payable Chart

Mitsui Fudosan Retail Fund Investment Annual Data
Trend Dec16 Dec17 Dec18 Dec19 Dec20 Dec21 Dec22 Dec23 Dec24 Dec25
Days Payable
Get a 7-Day Free Trial Premium Member Only Premium Member Only

Mitsui Fudosan Retail Fund Investment Semi-Annual Data
Dec16 Jun17 Dec17 Jun18 Dec18 Jun19 Dec19 Jun20 Dec20 Jun21 Dec21 Jun22 Dec22 Jun23 Dec23 Jun24 Dec24 Jun25 Dec25 Jun26
Days Payable Get a 7-Day Free Trial Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only

FOTRF vs SPG, O, KIM: Days Payable Comparison

For the REIT - Retail subindustry, Mitsui Fudosan Retail Fund Investment's Days Payable, along with its competitors' market caps and Days Payable 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.

Mitsui Fudosan Retail Fund Investment Days Payable vs REITs Industry

For the REITs industry and Real Estate sector, Mitsui Fudosan Retail Fund Investment's Days Payable distribution charts can be found below:

* The bar in red indicates where Mitsui Fudosan Retail Fund Investment's Days Payable falls into.


FOTRF
55GF Score
Mitsui Fudosan Retail Fund Investment Corp FOTRF
Days Payable is just one metric. See GF Score™, valuation, warning signs, and more.
View Full Analysis

Mitsui Fudosan Retail Fund Investment Days Payable Calculation

Days Payable indicates the number of days that the account payable relative to cost of goods sold the company has. An increase of Days Payable may suggest that the company delays paying its suppliers.

Mitsui Fudosan Retail Fund Investment's Days Payable for the fiscal year that ended in Dec. 2025 is calculated as

Days Payable (A: Dec. 2025 )
=Average Accounts Payable /Cost of Goods Sold*Days in Period
=( (Accounts Payable (A: Dec. 2024 ) + Accounts Payable (A: Dec. 2025 )) / count ) / Cost of Goods Sold (A: Dec. 2025 )*Days in Period
=( ( + ) / 1 ) / 72.45*365
=0 / 72.45*365
=0.00

Mitsui Fudosan Retail Fund Investment's Days Payable for the quarter that ended in Jun. 2026 is calculated as:

Days Payable (Q: Jun. 2026 )
=Average Accounts Payable / Cost of Goods Sold*Days in Period
=( (Accounts Payable (Q: Dec. 2025 ) + Accounts Payable (Q: Jun. 2026 )) / count ) / Cost of Goods Sold (Q: Jun. 2026 )*Days in Period
=( ( + ) / 1 ) / 34.905*365 / 2
=0 / 34.905*365 / 2
=0.00

* 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.

Is Mitsui Fudosan Retail Fund Investment (FOTRF) Overvalued in 2026?

Based on GuruFocus' analysis, Mitsui Fudosan Retail Fund Investment stock appears to be undervalued. The current stock price of $765.00 is trading 15.6% below its estimated GF Value™ of $905.91.

Key valuation signals for FOTRF:

  • Days Payable:
  • GF Value™: $905.91 vs. price of $765.00 (15.6% below fair value)
  • GF Score™: 55/100 with 3 warning signs

No single metric tells the full story. See the FOTRF stock analysis page for a complete view including 30-year financials, guru trades, and insider activity.

Mitsui Fudosan Retail Fund Investment Business Description

Industry Real EstateREITs
Other Exchanges 8964:Japan
Address Kojun Building, 6th Floor, 6-8-7 Ginza, Chuo-ku, Tokyo, JPN, 104-0061
Frontier Real Estate Investment Corp is a real estate investment trust specializing in retail facilities. The company mainly invests in commercial buildings in the metropolitan area and local cities. The company aims at stable earnings and steady asset growth from midterm to long-term perspectives. Its property portfolio consists of AEON Shinagawa Seaside Shopping Center, AEON MALL Ibaraki, Papillon Plaza, Kamiikedai Tokyu Store, and Belltown Tambaguchi Eki-mae Store, among others.
55GF Score

Get the complete analysis for FOTRF

Days Payable is just one metric. See GF Value™, 30-year financials, guru trades, warning signs, and more.

$765.00
Price
$905.91
GF Value