A Demonstration on How Copilot Helps Estate Agents to Produce a Rental Revenue Forecasting
Scenario
You manage multiple rental properties and need to prepare a 6-month revenue forecast for your agency’s quarterly planning meeting.
Copilot for Estate Agents: Rental Revenue Forecasting
In Microsoft Excel: Analyse Current Rentals & Project Income
Prompt: Copilot, calculate monthly rental income from my current rental portfolio and forecast revenue for the next 6 months. Assume a 5% increase in occupancy from August.
Copilot generates:
- Summary of total rent per property per month
- Occupancy rate assumptions
- Automatic inclusion of new tenancies starting in the next quarter
- Charts showing income growth trends
Projected Revenue Data:
- July: £24,500
- August: £25,725
- September: £26,000
- October: £26,250
- November: £26,500
- December: £26,750
In Microsoft Word: Create a Revenue Report for Management
Prompt: Copilot, draft a rental income report summarising projections for the next 6 months, based on my Excel sheet.
Copilot creates Rental Revenue Forecast (Jul–Dec 2025):
Total projected revenue for the next 6 months is £155,725, with a steady increase due to improving occupancy rates and new lease agreements. Revenue is expected to grow by 9% over the period. Key opportunities include newly refurbished units and properties in high-demand postcodes.
In PowerPoint: Build a Presentation for Stakeholders
Prompt: Copilot, make 3 slides to present the rental forecast and growth strategy.
Slides contain:
- Overview of Current Portfolio & Rent Roll
- 6-Month Revenue Forecast (with charts)
- Action Plan for Optimising Occupancy
Result
For you, within a short time, the estate agent has a clear, data-backed revenue forecast across Excel, Word, and PowerPoint, ready to impress clients, partners, or investors.
