Striking the Balance: Navigating Short-term Performance and Long-term Viability in CRE