One of the most expensive mistakes in property is signing first and calculating later.
A beautiful apartment in a popular neighbourhood does not automatically make a profitable deal.
Before committing to any property, you need to answer five questions:
1. How much revenue can the property realistically generate?
2. How much will it cost to operate?
3. How much money must be invested before opening?
4. How long will it take to recover that investment?
5. What happens if occupancy or rent collections are lower than expected?
The calculation should be completed before paying a deposit, agency fee or renovation cost.
## Step 1: Select the Revenue Model
The calculation depends on how the property will generate income.
Common models include:
* Monthly residential rental
* Student accommodation
* Room-by-room rental
* Shortlet or nightly accommodation
* Corporate accommodation
* Mixed monthly and short-stay use
Do not combine different revenue models without separating their assumptions.
## Step 2: Calculate Potential Gross Revenue
### Monthly rental model
If a property has four rentable rooms at ₦300,000 per month:
**Potential monthly revenue = 4 × ₦300,000**
**Potential monthly revenue = ₦1,200,000**
### Shortlet model
If the average nightly rate is ₦60,000 and you expect 18 occupied nights:
**Potential monthly revenue = ₦60,000 × 18**
**Potential monthly revenue = ₦1,080,000**
Use realistic occupancy. Do not automatically calculate with 30 occupied nights.
## Step 3: Account for Vacancy
A property will not always be fully occupied.
For monthly rentals, you may experience:
* Delayed move-ins
* Tenant turnover
* Unpaid rent
* Empty rooms
* Maintenance periods
For shortlets, some nights will remain unbooked.
A useful formula is:
**Effective revenue = Potential revenue − Vacancy allowance**
If potential monthly revenue is ₦1,200,000 and you apply a 10% vacancy allowance:
**Vacancy allowance = ₦120,000**
**Effective revenue = ₦1,080,000**
This is more realistic than assuming perfect occupancy.
## Step 4: List Every Operating Expense
Operating expenses vary by model.
Possible expenses include:
* Property rent or mortgage payment
* Service charge
* Electricity
* Generator fuel
* Water
* Internet
* Cleaning
* Laundry
* Waste disposal
* Security
* Staff salaries
* Management fees
* Booking-platform charges
* Marketing
* Repairs
* Replacement of damaged items
* Insurance
* Local permits
* Accounting
* Taxes
* Vacancy provision
Do not exclude an expense simply because it is paid annually. Convert it into a monthly amount.
For example:
**Annual property rent ÷ 12 = Monthly rent allocation**
If annual rent is ₦3,600,000:
**₦3,600,000 ÷ 12 = ₦300,000 monthly allocation**
## Step 5: Calculate Net Operating Income
Net operating income measures what remains after operating expenses, before financing costs and tax.
The formula is:
**NOI = Effective revenue − Operating expenses**
Assume:
* Effective monthly revenue: ₦1,080,000
* Monthly operating expenses: ₦650,000
Then:
**NOI = ₦1,080,000 − ₦650,000**
**NOI = ₦430,000 per month**
Annual NOI would be:
**₦430,000 × 12 = ₦5,160,000**
## Step 6: Subtract Loan or Financing Payments
If you borrowed money for furniture, renovation or property acquisition, loan repayments must be included.
Assume monthly debt repayment is ₦120,000.
**Monthly cash flow = NOI − Debt repayment**
**₦430,000 − ₦120,000 = ₦310,000**
Your estimated monthly cash flow is ₦310,000 before tax.
## Step 7: Calculate Your Initial Investment
Your startup investment may include:
* Rent advance
* Caution deposit
* Agency fee
* Legal fee
* Renovation
* Furniture
* Appliances
* Bedding
* Kitchen equipment
* Branding
* Photography
* Security installation
* Utility connection
* Opening inventory
* Marketing
* Emergency reserve
Assume total startup investment is ₦5,000,000.
Do not calculate ROI using only the rent. Include the complete amount required to open the property.
## Step 8: Calculate Annual Return on Investment
The formula is:
**ROI = Annual net profit ÷ Total startup investment × 100**
If monthly net cash flow is ₦310,000:
**Annual net profit = ₦310,000 × 12 = ₦3,720,000**
Then:
**ROI = ₦3,720,000 ÷ ₦5,000,000 × 100**
**ROI = 74.4%**
This is an illustrative projection, not a guaranteed return.
## Step 9: Calculate the Payback Period
The payback period estimates how long it will take to recover your startup investment.
The formula is:
**Payback period = Startup investment ÷ Monthly net cash flow**
Using the example:
**₦5,000,000 ÷ ₦310,000 = approximately 16.1 months**
This means the original investment may be recovered in about 16 months if the projected cash flow is achieved consistently.
## Step 10: Calculate Break-Even Occupancy
Break-even occupancy tells you the minimum occupancy required to cover expenses.
The simplified formula is:
**Break-even occupancy = Monthly expenses ÷ Maximum possible revenue × 100**
Assume:
* Maximum shortlet revenue: ₦1,800,000
* Monthly expenses: ₦900,000
Then:
**₦900,000 ÷ ₦1,800,000 × 100 = 50%**
The property needs approximately 50% occupancy to cover those expenses.
A deal with very high break-even occupancy may be risky because a small decline in bookings can create a loss.
## Run Three Scenarios
Never prepare only one projection.
### Conservative scenario
Use:
* Lower occupancy
* Lower rental rate
* Higher expenses
* Larger maintenance reserve
### Expected scenario
Use the figures you genuinely believe are achievable.
### Strong scenario
Use higher occupancy and pricing, but keep the figures realistic.
If the property only works under the strong scenario, the deal may not be safe.
## Questions to Ask Before Signing
* What was the property’s previous occupancy?
* What do comparable properties charge?
* How seasonal is the demand?
* Which utilities are included?
* Are there unpaid service charges?
* Which repairs are required?
* How frequently can rent increase?
* Is your intended use permitted?
* Are there restrictions from the estate or neighbours?
* Can you survive three weak months?
* Do you have an emergency reserve?
## Common Calculation Mistakes
### Using gross revenue as profit
Revenue is the total amount collected. Profit is what remains after expenses.
### Ignoring vacancy
Even strong properties experience empty periods.
### Underestimating electricity
Energy costs can significantly affect Nigerian shortlet operations.
### Forgetting replacements
Bedding, towels, appliances, furniture and locks will eventually need repair or replacement.
### Excluding your own management cost
Your time has value. If someone else would need to be paid to perform the work, include the cost.
### Assuming the rent will remain unchanged
Calculate how a future rent increase could affect the business.
## Final Decision Rule
A deal should not be approved because the potential revenue is exciting.
Approve it only when:
* The assumptions are supported by market research
* All major expenses are included
* The conservative scenario remains manageable
* You have enough working capital
* The approved property use is documented
* The expected return justifies the risk
**Use the Rent2Rent World Advanced Profit Calculator to test monthly rentals, shortlets, operating expenses, loans, ROI, break-even occupancy and payback period before signing.**