AssetCalcs.

Rental Yield Calculator: Excel

Model your property cash flow and returns with our advanced True Yield calculator.

Property Financials

£
£
Initial Buying Costs
£
£
£
£
Annual Operating Expenses
15%

Deducts a flat percentage from your gross rent for all costs.

True Yield (ROI)

4.8%

Yield on Total Capital Deployed

Gross Yield
5.8%
Net Yield
5.1%
Total Capital Deployed£267,000
Annual Gross Rent£14,400
Annual Expenses-£2,160
Net Operating Income£12,240

Next Steps for Investors

Calculate Cap Rate →

Evaluate the property's operating efficiency before applying for the loan.

Calculate DSCR Loan Eligibility →

See if this property qualifies for a non-recourse DSCR loan based on your estimated NOI.

The Ultimate Guide to Rental Yields (Excel)

Accurately determining the return on investment for a property is the cornerstone of successful real estate investing in the UK. Using a precise rental yield calculator is the fastest way to compare multiple deals against one another to identify the highest performing assets.

Important Context: While many investors build a rental yield calculator in Excel, maintaining complex spreadsheets across mobile devices can be cumbersome and prone to broken formula errors. Our web-based True Yield Engine runs the exact same institutional-grade math directly in your browser.

What is a Rental Yield Calculator?

A rental yield calculator uk measures the annual return an investor makes on a property relative to its purchase price. Unlike simply looking at gross rent, our tool accounts for the Operating Expense Ratio (OER), providing you with the Net Rental Yield, which gives a much truer picture of your actual profitability.

Whether you are evaluating a standard buy-to-let or a specialized rental yield calculator holiday let scenario, factoring in ongoing costs such as management fees, void periods, insurance, and maintenance is critical to avoiding a bad investment.

Gross vs. Net Rental Yield

If you want to work out rental yield calculator numbers correctly, you must understand the difference between gross and net:

  • Gross Yield: Annual rent divided by the property value. It ignores all running costs.
  • Net Yield: Annual rent MINUS operating expenses, divided by the property value. This is the metric our net rental yield calculator focuses on.

Frequently Asked Questions

How do you calculate gross rental yield?

Gross rental yield is calculated by taking the total annual rental income, dividing it by the property's purchase price (or current market value), and multiplying by 100 to get a percentage. This provides a quick baseline for comparing different investment properties.

What is the difference between gross and net rental yield?

Gross yield only looks at the rental income relative to the property value. Net yield gives a much more accurate picture of your actual ROI by deducting all operating expenses—such as management fees, maintenance, service charges, insurance, and void periods—from the rental income before doing the calculation.

What is considered a good rental yield in the UK?

A "good" rental yield depends heavily on the region and asset class. In the UK, a gross yield between 5% and 8% is generally considered healthy for residential property. Yields in the North of England tend to be higher (7-9%), whereas London properties often yield lower (3-5%) but may offer stronger capital appreciation.

Why is rental yield important for property investors?

Rental yield is the primary metric for assessing the cash flow performance of a property. A high yield indicates that the property generates strong income relative to its cost, which is crucial for covering mortgage payments, building a safety buffer, and qualifying for Buy-to-Let financing.