| Property | Total Rent Collected | Contract Rent | Collection Rate |
|---|---|---|---|
| 12637 Appleton | 0 | 900 | 0 |
| 14430-2 Mansfield | 0 | 700 | 0 |
| 14432 Mansfield | 0 | 500 | 0 |
| 17399 Edinborough | 0 | 850 | 0 |
| 18264 Forrer | 650 | 650 | 1 |
| 18560 Edinborough | 800 | 800 | 1 |
| 7549 Parkland | 0 | NA | NA |
| 7686 Dacosta | 1238 | 1238 | 1 |
2023 Portfolio Preformance
This is a monthly reporting document meant to show analytics on past performance of a portfolio. By looking at previous performance we will be able to strategize on how best to optimize our KPI’s for each aspect of our business (Operations, & Aquistions).
KPIs
Collections Rate: 47.68%
Variable Expense Per Unit: $593.26
Annual Leases Rate: 33.33%
Collections Breakdown
?(caption)
Ideas:
I want a graph that shows the collection rate per property/tenant and shows there volatility
Expenses Breakdown
| Property | Unit | Date | Sub-Category | Amount |
|---|---|---|---|---|
| 12637 Appleton | Unnamed | 2023-05-31 | Eviction Fees | 600.00 |
| 18560 Edinborough | 18560 | 2023-05-31 | Plumbing Repairs | 2500.00 |
| 7549 Parkland | Unnamed | 2023-05-31 | Gardening & Landscaping | 130.00 |
| 7549 Parkland | Unnamed | 2023-05-31 | NA | 300.00 |
| 7549 Parkland | Unnamed | 2023-05-31 | NA | 320.00 |
| 7549 Parkland | Unnamed | 2023-05-31 | Plumbing Repairs | 510.00 |
| 7549 Parkland | Unnamed | 2023-05-31 | Cleaning & Janitorial | 225.00 |
| 7549 Parkland | Unnamed | 2023-05-31 | Gardening & Landscaping | 50.00 |
| 7549 Parkland | Unnamed | 2023-05-31 | Gas & Electric | 111.06 |
| AMAA LLC | NA | 2023-05-23 | Accounting | 800.00 |
Leases Breakdown
THIS SECTION WILL HAVE ANAYLTICS ON OUR CURRENT LEASES
Tab 1: Lollipop Graph of leases
x axis = date
y axis = property name Tab 2: Table
with lease start, end, tenant names
late payment counter ?
vacancy/eviction counter ? Year to Date Performance
Collection Rate
Collections Rate Year to Date: 57.72%
Expense
| Property | Total |
|---|---|
| 12637 Appleton | 6396.00 |
| 14430-2 Mansfield | 3821.00 |
| 14432 Mansfield | 0.00 |
| 17399 Edinborough | 605.00 |
| 18264 Forrer | 175.00 |
| 18560 Edinborough | 2792.50 |
| 7549 Parkland | 4098.43 |
| 7686 Dacosta | 210.00 |
Equity Summary
Long Term Debt
Mortgage Payments
Total Mortgage Expense for May 2023 -2578.74
Raw data
Notes
TODOs
Outstanding Todos:
- ADD TITLE PAGE MONTH AUTOMATION
- Recalculate KPI1 variable expense with tidy data
- add data validation checks
- look at how to deal with duplexs in calculations
- print collections rates > 100% to check contract rent and collection is correct
- check KPI output with AMAA KPI Spreadsheet results
- add a "Trailing 12 month section" - maybe even instead of year to date
- MAKING VERSION 2.0 WITH 7.31.23 DATAFeature Ideas
IDEAS: Maybe at a "last updated" column to the KPM spreadsheet - so I can now how up to date the data is
- look at what APP Folio can offer
- fair market value --> Current Locations: Stessa / Zillow Old Notes
Old Notes:
DataSource Todos:
- lease start date, end date, & amount --> Current Location: Stessa or KPM spreadsheet
- Vacancy or Eviction Status --> Current Locations: KPM spreadsheet
- aquistion price, sale price, loan info, and dates --> Current Locations: Stessa