This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Cash-on-cash Yield Calculator
Calculate the cash-on-cash yield for a rental investment property.
Purchase price
$
Purchase price:
Enter the total cost to acquire the property plus applicable closing costs (e.g., real estate broker, mortgage broker and legal fees) and set-up costs (e.g., furniture).
Cash-on-cash yield:
A measure of financial return calculated by dividing annual profit by equity invested.
Cash-on-cash
Amount borrowed
$
Amount borrowed:
Enter the starting balance of your mortgage when you acquired the property.
Monthly rent
$
Monthly operating costs
$
Monthly operating costs:
Enter the monthly costs related to operating a property that the landlord covers. Do not include monthly mortgage costs or costs paid by the tenant.
Monthly operating costs could include: utilities, cable, internet, property taxes, insurance, maintenance, cleaning, security and HOA fees.
Monthly mortgage payment
$
Occupancy rate
Occupancy rate:
Enter the average occupancy rate which is the percent of total nights with a tenant in occupancy and paying rent.