Guided project · 5 steps Cellwise Plus
Rental expenses by property in Excel
Turn a year of landlord expenses into a per-property report with net income, expense ratio and the property to look at first.
You will use: SUMIF, ROUND, SUMIFS, MAX, MATCH, INDEX
Starting data
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Date | Property | Category | Amount | Property | Expenses | Rent collected | Net | Expense ratio | |
| 2 | Jul 3, 2026 | Maple duplex | Repairs | 420 | Maple duplex | 8400 | ||||
| 3 | Jul 15, 2026 | Oak condo | HOA | 310 | Oak condo | 4950 | ||||
| 4 | Jul 28, 2026 | Maple duplex | Insurance | 1140 | Elm house | 6300 | ||||
| 5 | Aug 6, 2026 | Elm house | Repairs | 185 | ||||||
| 6 | Aug 15, 2026 | Oak condo | HOA | 310 | Maple duplex repairs | |||||
| 7 | Aug 22, 2026 | Elm house | Lawn care | 160 | Look at first | |||||
| 8 | Sep 2, 2026 | Maple duplex | Repairs | 960 | ||||||
| 9 | Sep 15, 2026 | Oak condo | HOA | 310 | ||||||
| 10 | Sep 18, 2026 | Elm house | Insurance | 860 | ||||||
| 11 | Sep 30, 2026 | Maple duplex | Lawn care | 120 |
Build it step by step
Step 1
Total the expenses for each property in G2, fill to G4.
Step 2
Net income is rent collected minus expenses. Write it in I2, fill to I4.
Step 3
Expense ratio: what share of the rent went on expenses? Expenses divided by rent, rounded to 2 decimals, in J2. Fill to J4.
Step 4
How much went on repairs at the Maple duplex? Use two conditions, in G6.
Step 5
Which property has the highest expense ratio? Return its name in G7.