Home and property

Working out your rental yield from your own records

Work out gross and net rental yield from your own records: rent actually received, costs you paid and the amount invested, with a step-by-step example.

Editorial illustration for Working out your rental yield from your own records

Rental yield is the rent you received in a year, less any costs you want to count, divided by the amount you put into the property, shown as a percentage. Gross yield uses rent only; net yield subtracts the costs you actually paid. Both come straight from your own records once you decide which amounts count.

What goes into the formula?

Three numbers decide the result. The first is rent actually received, which is lower than rent on paper if the flat was empty for a month. The second is costs you paid in the same period, only if you decide they belong in a net figure. The third is the amount invested, which is the figure most people argue about.

  • Gross yield = annual rent received ÷ amount invested × 100
  • Net yield = (annual rent received − costs paid) ÷ amount invested × 100

What counts as the amount invested?

Pick one definition and use it every year. Some owners use the purchase price alone. Others add registration, brokerage and furnishing so that it reflects the full outlay. Either is legitimate, but a figure built on the lower base will look better, so note which one you used beside the result.

Can we run a worked example?

Say the amount invested is ₹60,00,000, monthly rent is ₹22,000 and the flat sat empty for one month in the year, so rent was received for 11 months.

LineCalculationAmount
Rent received11 × ₹22,000₹2,42,000
Society maintenance paid by owner12 × ₹2,500₹30,000
Repairs paidTwo bills₹8,000
Property tax paidOne payment₹6,000
Total costs30,000 + 8,000 + 6,000₹44,000
Net rent after costs2,42,000 − 44,000₹1,98,000

Gross yield = ₹2,42,000 ÷ ₹60,00,000 = 0.0403, or about 4.03%. Net yield = ₹1,98,000 ÷ ₹60,00,000 = 0.033, or 3.3%. These figures are hypothetical and only show the arithmetic. They say nothing about what a good yield is, and they leave out loan interest, income tax and any change in the property's value.

How do you set it up in a sheet?

Put rent received in B1, costs in B2 and invested amount in B3. Then:

  • Gross yield: =B1/B3
  • Net yield: =(B1-B2)/B3
  • Format both cells as percentages.

To keep it honest, make B1 a SUM of the rent credits tagged to this flat for April to March, rather than a number you remember. A SUMIFS on the flat code and date range will do it. Keep costs in a separate list so you can see what was counted.

One more point on timing: a repair bill paid in April for work done in March belongs to whichever year you decide, but be consistent. Many owners go by the date money left the account, because it matches the statement. Whichever you pick, say it in a note at the bottom of the page, so that a year later you read the figures the way you meant them.

Which costs should you leave in or out?

Count what the property cost to keep it let: society charges you bore, repairs, property tax, a property manager's fee, insurance if you carry it. Whether to include interest on a loan, or tax, is a choice, and which treatment applies for tax purposes is a matter for your CA. If you leave something out, say so beside the result so the comparison with last year stays fair.

Where does SpendixAI help?

The costs side is the part a tracker captures well. With SpendixAI you can keep society charges, repairs and property tax as their own categories and run a report for the financial year, which gives you the cost total for your net yield. Rent received and the amount invested are best kept in your sheet.

Checklist

  • Rent actually received for the year, from statements.
  • Costs you paid, listed with bills.
  • One definition of the amount invested, written down.
  • Both yields worked out, with the date and the figures beside them.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports