0
coffee Support Penke with Coffee
10 XP 0   0   5  
0coffee
Main menu

πŸ“‰ The Great Reset πŸ“ˆ

Data gone? Yes, I pulled the plug. I shut down my paid data feeds and deleted the entire dataset to become fully independent.

No worries! Penke(Bot) will find new copyright-free data.

Curious how? Read it here… πŸ₯Έ Penke

Merlin Properties


Can this company survive a downturn?

How efficiently does it turn assets into profit?

Is the business becoming more valuable over time?

1.1. Financial Health of Merlin Properties (5 min.)




3rd party ad coffee SUPPORTERis ad-free.

πŸ€– Analyze $MRL using your own AI

Download Penke’s AI-structured dataset for Merlin Properties.
Ask your own questions, run scenarios, and test assumptions in the AI you already use.

Your edge in this era:
πŸ₯Έ Penke’s data + πŸ€– AI + 🧠 YOUR judgment.

πŸ”’ Become a Member to Unlock

You can use the AI prompts per pain point I prepared to guide your analysis.

Want to see how it works first? Start with a real example:

πŸ“₯ Download example dataset ($NVDA)

* I continuously improve the AI structure.
If something feels unclear or incomplete, email me or message me on Discord.
β€” I’ll fix it. πŸ₯Έ Penke

Key Takeaways

What matters most right now.

βœ… Revenue growth

Revenue grew 6.4% last quarter to $0.5B. Compared to the 5-year average revenue level of $0.5B, the business continues to expand in scale.

βž– Profitability

Net profit margin is 57.4%, close to its 5-year average of 44.3%. This indicates profitability is broadly in line with the company’s long-term performance.

⚠️ Cash generation

Free cash flow jumped to $0.3B this quarter, far above its normal 5-year margin of 35.1%. This suggests a one-off boost rather than a new baseline.

βž– Financial resilience

The company has a current ratio of 2.02, compared to a 5-year average of 1.8. This shows how well it can cover short-term obligations if conditions worsen.

βž– Debt levels

Debt relative to equity is 0, compared to a 5-year average of 0. This shows whether leverage is increasing or staying disciplined.

βž– Capital efficiency

Return on equity is 3.8%, compared to a 5-year average of 2.9%. This shows how effectively management turns shareholder capital into profit.

Why this matters

The facts behind the takeaways.

βž– How much profit the business keeps

The company keeps 75.9% profit from its sales. Over the past 5 years, this was about 53.6%.

βž– How much cash the business generates

About 54.5% of sales turns into real cash. Historically, this was closer to 35.1%.

βž– Ability to pay short-term bills

The company’s short-term financial buffer is 2.02, compared to 1.8 historically.

βž– Debt pressure

Debt levels are 0 today, compared to 0 over the last 5 years.

What to watch next

Focus points for the next quarters.

βž– Next earnings

Watch whether revenue growth translates into sustained margin improvement next quarter.

3rd party ad coffee SUPPORTERis ad-free.

Balance Sheet

Showing financial position from 2019-01-01 to 2025-01-01.

 2025-01-012024-01-012023-01-012022-01-012021-01-012020-01-022020-01-012019-01-022019-01-01
Assets
   TotalπŸ”’ Member12,065,41112,051,48314,272,83713,477,612πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Current
      TotalπŸ”’ Member599,966429,4491,038,443415,855πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      CashπŸ”’ Member461,223429,449866,721252,022πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Cash EquivalentsπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Short Term InvestmentsπŸ”’ Member4,9902,96082,91979,365πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Accounts ReceivableπŸ”’ Member62,59849,84039,62533,368πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Inventory
         TotalπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
         Inventory Finished GoodsπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
         Inventory Raw MaterialsπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
         Inventory PartsπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
         Inventory WIPπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Prepaid ExpensesπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Noncurrent
      Property Plant And EquipmentπŸ”’ Member7,1426,3239,1607,106πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Intangible AssetsπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      GoodwillπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Right Of Use AssetsπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Long Term InvestmentsπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Deferred Tax AssetsπŸ”’ Member77,57378,64683,80887,469πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Other AssetsπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      TotalπŸ”’ Member84,71584,96992,96894,575πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
Liabilities
   TotalπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Current
      TotalπŸ”’ Member214,672950,512736,630179,260πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Accounts PayableπŸ”’ Member164,008146,850114,155111,112πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Accrued LiabilitiesπŸ”’ Member10,21011,5667,6688,342πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Short Term DebtπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Deferred RevenueπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Lease LiabilitiesπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Other Current LiabilitiesπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Noncurrent
      Long Term DebtπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Lease LiabilitiesπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Operating Lease LiabilitiesπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Deferred RevenueπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Deferred Tax LiabilitiesπŸ”’ Member613,190613,479681,013684,454πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      TotalπŸ”’ Member5,311,7014,251,7476,509,2856,602,085πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
Equity
   TotalπŸ”’ Member6,539,0386,849,2247,026,9236,696,267πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Common StockπŸ”’ Member469,771469,771469,771469,771πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Preferred StockπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Additional Paid In CapitalπŸ”’ Member3,541,3793,541,3793,647,8763,813,409πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Retained EarningsπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Accumulated Other Comprehensive IncomeπŸ”’ Member2,729,4033,023,6302,566,2762,509,875πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Treasury StockπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Minority InterestπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Temporary EquityπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member

Income Statement

Performance overview from 2019-01-01 to 2025-01-01.

 2025-01-012024-01-012023-01-012022-01-012021-01-012020-01-022020-01-012019-01-022019-01-01
Revenue
   TotalπŸ”’ Member464,779439,038468,203446,132πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Segments
      Segment1πŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Segment2πŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Segment3πŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
Cost Of Revenue
   TotalπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
Gross ProfitπŸ”’ Member464,779439,038468,203446,132πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
Operating Expenses
   TotalπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Research And DevelopmentπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Selling General And AdministrativeπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Stock Based CompensationπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Allocated Stock Based CompensationπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Impairment ChargesπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Restructuring ChargesπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Other Operating ExpensesπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
Operating IncomeπŸ”’ Member8,90788,441543,495240,536πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
Non Operating
   Interest IncomeπŸ”’ Member10,1063,9425,4213,387πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Interest ExpenseπŸ”’ Member127,786109,203136,400149,653πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Gain On Asset SalesπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Other Non Operating IncomeπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
Income Before TaxπŸ”’ Member-74,99248,156518,79855,612πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
Income TaxπŸ”’ Member8,5056,8006,581-746πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
Net IncomeπŸ”’ Member-83,497263,087512,21756,358πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member

Cash Flow Statement

Operational cash dynamics from 2019-01-01 to 2025-01-01.

 2025-01-012024-01-012023-01-012022-01-012021-01-012020-01-022020-01-012019-01-022019-01-01
Operating Activities
   Net IncomeπŸ”’ Member-83,497263,087512,21756,358πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Adjustments
      Depreciation And AmortizationπŸ”’ Member2,0751,8851,8581,614πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Stock Based CompensationπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      ImpairmentsπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Deferred TaxesπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Gain On Asset SalesπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
      Change In Working CapitalπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Cash From OperationsπŸ”’ Member-81,422264,972230,466134,660πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
Investing Activities
   Cash From InvestingπŸ”’ Member00110,230-229,866πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Capital ExpendituresπŸ”’ Member1,1016442,3322,000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   AcquisitionsπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Purchase Of InvestmentsπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Sale Of InvestmentsπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
Financing Activities
   Cash From FinancingπŸ”’ Member00274,00393,212πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Debt IssuedπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Debt RepaidπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Convertible Debt RepaidπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Debt Issuance CostsπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Dividends PaidπŸ”’ Member207,023561,926210,099-68,518πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Share RepurchasesπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Share IssuanceπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Lease Principal PaymentsπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Minority Interest DistributionsπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
Other
   Taxes PaidπŸ”’ Member01,5283,6961,746πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Interest PaidπŸ”’ Member109,299100,588120,864126,695πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Effect Of Exchange Rate On CashπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
Summary
   Net Change In CashπŸ”’ Member-461,223-429,449-866,721-252,022πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Beginning CashπŸ”’ Member461,223429,449866,721252,022πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
   Ending CashπŸ”’ Member0000πŸ”’ MemberπŸ”’ MemberπŸ”’ MemberπŸ”’ Member
3rd party ad coffee SUPPORTERis ad-free.