Master File
| House Info | ||||||||||||
| Address | NA | 400 Broad St, Seattle, WA | 880 Harrison St, San Francisco, CA | 2400 Chestnut St, Philadelphia, PA | 1500 Sugar Bowl Dr, New Orleans, LA | 20 W 34th St, New York, NY | 600 E Grand Ave, Chicago, IL | 350 5th Ave, New York, NY | 400 Broad St, Seattle, WA | 111 S Michigan Ave, Chicago, IL | 2800 E Observatory Rd, Los Angeles, CA | 1600 Pennsylvania Avenue NW, Washington, DC |
| Unit Cost | sum of all | $1,200 | $2,500 | $1,800 | $1,500 | $3,000 | $2,200 | $3,200 | $2,800 | $2,100 | $2,600 | $4,000 |
| Bed | avg of all | 2 | 3 | 2 | 4 | 1 | 2 | 2 | 3 | 2 | 4 | 5 |
| Bath | avg of all | 1 | 2 | 1 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 4 |
| Sq Ft | avg of all | 80m2 | 120m2 | 90m2 | 200m2 | 60m2 | 100m2 | 110m2 | 150m2 | 95m2 | 180m2 | 300m2 |
| Lease Info | ||||||||||||
| Tenant Name | na | John Doe | Jane Smith | Mike Johnson | Sarah Williams | David Brown | Emily Davis | Michael Wilson | Jessica Taylor | Daniel Anderson | Lisa Thomas | James Jackson |
| Tenant Phone | na | 0909123456 | 415-555-0102 | 215-555-0103 | 504-555-0104 | 212-555-0105 | 312-555-0106 | 212-555-0107 | 206-555-0108 | 312-555-0109 | 323-555-0110 | 202-555-0111 |
| Tenant Email | na | john@mail.com | jane@mail.com | mike@mail.com | sarah@mail.com | david@mail.com | emily@mail.com | michael@mail.com | jessica@mail.com | daniel@mail.com | lisa@mail.com | james@mail.com |
| Monthly Rent $ | avg of all | 500 | 1500 | 800 | 600 | 2000 | 900 | 2200 | 1800 | 850 | 1600 | 3000 |
| Deposit $ | avg of all | 1000 | 3000 | 1600 | 1200 | 4000 | 1800 | 4400 | 3600 | 1700 | 3200 | 6000 |
| Lease agreement | na | |||||||||||
| Lease Start Date | na | 2025-01-01 | 2025-02-01 | 2025-01-15 | 2025-03-01 | 2025-01-01 | 2025-04-01 | 2025-02-15 | 2025-01-20 | 2025-03-15 | 2025-01-10 | 2025-01-05 |
| Lease End Date | na | 2025-12-31 | 2026-01-31 | 2026-01-14 | 2026-02-28 | 2025-12-31 | 2026-03-31 | 2026-02-14 | 2026-01-19 | 2026-03-14 | 2026-01-09 | 2026-01-04 |
| Late Payment / Day % | na | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% | 0.5% |
| Monthly Pay Date | na | 5th | 5th | 1st | 5th | 1st | 5th | 1st | 5th | 5th | 1st | 1st |
| Balance | ||||||||||||
| Deposits | QB balance | 1000 | 3000 | 1600 | 1200 | 4000 | 1800 | 4400 | 3600 | 1700 | 3200 | 6000 |
| Income | ||||||||||||
| Rent | QB total | 500 | 1500 | 800 | 600 | 2000 | 900 | 2200 | 1800 | 850 | 1600 | 3000 |
| Late Fees | QB total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Revenue | 21 + 22 | 500 | 1500 | 800 | 600 | 2000 | 900 | 2200 | 1800 | 850 | 1600 | 3000 |
| Expense | ||||||||||||
| Mortgage principal | QB total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Mortgage interest | QB total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Home insurance | QB total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Property taxes | QB total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Landscape maintenance | QB total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Electrical | QB total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Water | QB total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Gas | QB total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Repairs/ maintenance | QB total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Bank fees | QB total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| HOA Dues | QB total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Expense | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Profitability | ||||||||||||
| Net Profit | 500 | 1500 | 800 | 600 | 2000 | 900 | 2200 | 1800 | 850 | 1600 | 3000 | |
| Cash Flow | 500 | 1500 | 800 | 600 | 2000 | 900 | 2200 | 1800 | 850 | 1600 | 3000 | |
| Monthly ROI | 5% | 6% | 5.5% | 4.8% | 6.2% | 5.1% | 5.8% | 6.5% | 5.3% | 5.9% | 7% |