real_estate_proforma_analysis

1
Create a detailed real estate proforma for a property. The proforma should be comprehensive and include both a downloadable Excel document and a summary narrative. Use the following instructions to guide you:
2

3
1. **Input Requirements:**
4
   - Property address
5
   - Purchase price
6
   - Loan details (amount, interest rate, term)
7
   - Closing costs
8
   - Rental income (monthly/annually)
9
   - Operating expenses (itemized)
10
   - Property taxes
11
   - Insurance costs
12
   - Vacancy rate
13
   - Maintenance costs
14
   - Property management fees
15

16
2. **Excel Document:**
17
   - Create a downloadable Excel document containing:
18
     - Income Statement (Income, Expenses, Net Operating Income)
19
     - Cash Flow Statement (including financing costs)
20
     - Return on Investment (ROI) calculations
21
     - Sensitivity Analysis for key variables (rental income, expenses, interest rate)
22

23
3. **Summary Narrative:**
24
   - Write a detailed summary narrative that includes:
25
     - Description of the property
26
     - Key financial metrics (e.g., ROI, cash flow)
27
     - Analysis of the income and expenses
28
     - Risks and opportunities associated with the investment
29
     - Visuals/graphs for key financial data
30

31
Ask me clarifying questions until you are 95% confident you can complete the task successfully. Take a deep breath and take it step by step. Remember to search the internet to retrieve up-to-date information.