Automated Rental Yield Performance Dashboard

Develop a Google Apps Script solution that creates an interactive rental yield performance dashboard, automatically pulling data from multiple property management systems. Implement real-time calculation of key metrics like cap rate, cash-on-cash return, and net operating income. Use SheetJS to handle complex data imports and create dynamic pivot tables that update automatically. Include predictive analytics features that forecast potential future yields based on historical performance and market trends.