Rental Yield Calculator – Gross Yield, Net Yield & Cash-on-Cash Return in Excel

Description
This Rental Yield Calculator is a comprehensive, formula-driven Excel template built for property investors, landlords, real estate agents, and financial analysts who need to quickly evaluate whether a rental property is a good investment. Rather than juggling separate spreadsheets or manual formulas for each metric, this single template pulls together acquisition costs, rental income, operating expenses, and financing into one clear picture — and calculates every key return metric automatically.

The template is organized into five logical sections. Property & Purchase Details captures the purchase price, additional acquisition costs (stamp duty, legal fees, agent commissions), and renovation costs to arrive at a Total Acquisition Cost. Rental Income takes monthly rent and a vacancy rate assumption to produce an effective annual income figure that accounts for realistic downtime. Operating Expenses covers property management fees, maintenance, insurance, property tax, and other recurring costs. The optional Financing section lets users model a mortgage — entering down payment percentage, interest rate, and loan term — with the annual mortgage payment calculated automatically using standard amortization formulas; it can be skipped entirely for all-cash purchases.

The final section, Yield & Return Calculations, is where it all comes together: Net Operating Income, Gross Rental Yield, Net Rental Yield, Cap Rate, Annual Cash Flow, and Cash-on-Cash Return are all computed live from the inputs above. Every formula recalculates instantly as assumptions change, making this ideal for comparing multiple properties or stress-testing different financing scenarios. The color-coded input/formula design keeps the sheet easy to use even for first-time investors, and it works seamlessly in Excel, Google Sheets, and LibreOffice Calc.