Calculation guide
Compare undiscounted landlord cash receipts over the same horizon. One-time costs include concessions, brokerage and preparation.
Inputs
Comparison months
Example entry 24. Allowed range 1.0 to 600.0. Use whole numbers.
Monthly renewal rent
Example entry 2200 (in the selected currency).
Renewal costs
Example entry 1000 (in the selected currency).
New monthly rent
Example entry 2400 (in the selected currency).
Vacant months
Example entry 3. Allowed range 0.0 to 600.0. Use whole numbers.
Reletting costs
Example entry 4000 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Comparison months | 24 |
| Monthly renewal rent | 2,200 |
| Renewal costs | 1,000 |
| New monthly rent | 2,400 |
| Vacant months | 3 |
| Reletting costs | 4,000 |
| Result | Value |
|---|---|
| Net advantage of renewal | 5,400 |
| Net renewal receipts | 51,800 |
| Net reletting receipts | 46,400 |
Calculation steps
Net advantage of renewal = ((((Comparison months × Monthly renewal rent) − Renewal costs) − ((Comparison months − Vacant months) × New monthly rent)) + Reletting costs)
((((24 × 2,200) − 1,000) − ((24 − 3) × 2,400)) + 4,000) = 5,400
Net renewal receipts = ((Comparison months × Monthly renewal rent) − Renewal costs)
((24 × 2,200) − 1,000) = 51,800
Net reletting receipts = (((Comparison months − Vacant months) × New monthly rent) − Reletting costs)
(((24 − 3) × 2,400) − 4,000) = 46,400
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Comparison months | 24 | 26 | Net advantage of renewal | 5,400 | 5,000 |
| Monthly renewal rent | 2,200 | 2,420 | Net advantage of renewal | 5,400 | 10,680 |
| Renewal costs | 1,000 | 1,100 | Net advantage of renewal | 5,400 | 5,300 |
| New monthly rent | 2,400 | 2,640 | Net advantage of renewal | 5,400 | 360 |
| Vacant months | 3 | 4 | Net advantage of renewal | 5,400 | 7,800 |
| Reletting costs | 4,000 | 4,400 | Net advantage of renewal | 5,400 | 5,800 |
