Rental property calculator (cap rate and cash flow)

Calculate a rental property's cap rate, NOI, monthly cash flow, cash-on-cash return and IRR, with a year-by-year projection of rent, value and equity.

更新于 已验证的示例:4

$
%
$
Cash spent at purchase besides the down payment; added to the cash invested.
%
years
$
%
Share of scheduled rent you expect not to collect.
%
$
$
$
$
%
%
%
years
%
Agent commissions, transfer taxes and closing costs when you sell.
更多选项
$
Parking, laundry, storage or pet fees.
$
Utilities you pay, landscaping, accounting, licences.
试一试
Cash flow per month (year 1)
$
Cash flow per month (year 1): $175.47
小数位数:2;取最近值,等距时取偶数末位
Cap rate
6.69%
Cash-on-cash return (year 1)
2.51%
Net operating income (year 1)
$20,068.80
Cash flow (year 1)
$2,105.63
Mortgage payment per month
$1,496.93
Cash invested
$84,000.00
Debt service coverage ratio
1.12
Gross rent multiplier
9.62
Internal rate of return (IRR)
12.13over 10 years
Cash from the sale
$185,906.56
Total profit
$152,341.18
Equity at sale
$210,097.05
The loan's payments cost 7.98% of the amount borrowed each year, more than the 6.69% cap rate, so borrowing lowers the cash return on your own money.

The property collects $29,640.00 of rent in year 1 and costs $9,571.20 to run, an NOI of $20,068.80 and a 6.69% cap rate. After $17,963.17 of mortgage payments you keep $175.47 a month, a cash-on-cash return of 2.51% on the $84,000.00 you invested. Selling after 10 years for $403,174.91 gives an IRR of 12.13% and a total profit of $152,341.18 before tax.

Where year-1 rent goes, per month

$175cash flow a month
Vacancy$130.00Operating costs$797.60房贷$1,496.93Cash flow$175.47

Value, loan and equity

$0$100K$200K$300K$400K0246810Year
Property valueLoan balanceEquityCumulative cash flow
Projection over 10 years 行数:10
年Rent collectedOperating costsNOI房贷Cash flowCash-on-cash数值Loan balanceEquity
1$29,640.00$9,571.20$20,068.80$17,963.17$2,105.632.51 %$309,000.00$222,714.43$86,285.57
2$30,529.20$9,858.34$20,670.86$17,963.17$2,707.703.22 %$318,270.00$220,263.63$98,006.37
3$31,445.08$10,154.09$21,290.99$17,963.17$3,327.823.96 %$327,818.10$217,635.67$110,182.43
4$32,388.43$10,458.71$21,929.72$17,963.17$3,966.554.72 %$337,652.64$214,817.73$122,834.92
5$33,360.08$10,772.47$22,587.61$17,963.17$4,624.445.51 %$347,782.22$211,796.08$135,986.15
6$34,360.88$11,095.64$23,265.24$17,963.17$5,302.076.31 %$358,215.69$208,555.99$149,659.70
7$35,391.71$11,428.51$23,963.20$17,963.17$6,000.037.14 %$368,962.16$205,081.68$163,880.48
8$36,453.46$11,771.37$24,682.09$17,963.17$6,718.938 %$380,031.02$201,356.21$178,674.81
9$37,547.07$12,124.51$25,422.56$17,963.17$7,459.398.88 %$391,431.96$197,361.43$194,070.53
10$38,673.48$12,488.25$26,185.23$17,963.17$8,222.069.79 %$403,174.91$193,077.86$210,097.05
计算方法 S
  1. Loan and monthly payment

    L=300,000.00−75,000.00=225,000.00,M=L r (1+r)360(1+r)360−1=1,496.93,r=0.005833333333L = 300{,}000.00 - 75{,}000.00 = 225{,}000.00,\qquad M = \frac{L\,r\,(1+r)^{360}}{(1+r)^{360} - 1} = 1{,}496.93,\quad r = 0.005833333333
  2. Rent collected in year 1

    31,200.00×(1−5%)=29,640.0031{,}200.00 \times (1 - 5\%) = 29{,}640.00
  3. Operating costs in year 1

    7,200.00+8%×29,640.00=9,571.207{,}200.00 + 8\% \times 29{,}640.00 = 9{,}571.20

    Property tax, insurance, HOA dues, maintenance and other costs, plus management as a share of rent collected. Mortgage payments are not operating costs.

  4. Net operating income and cap rate

    NOI=29,640.00−9,571.20=20,068.80,20,068.80300,000.00=6.69%\text{NOI} = 29{,}640.00 - 9{,}571.20 = 20{,}068.80,\qquad \frac{20{,}068.80}{300{,}000.00} = 6.69\%
  5. Cash flow and cash-on-cash return

    20,068.80−17,963.17=2,105.63,2,105.6384,000.00=2.51%20{,}068.80 - 17{,}963.17 = 2{,}105.63,\qquad \frac{2{,}105.63}{84{,}000.00} = 2.51\%

    Cash invested is the $75,000.00 down payment plus $9,000.00 of closing and repair costs.

  6. Sale after 10 years

    403,174.91×(1−6%)−193,077.86=185,906.56403{,}174.91 \times (1 - 6\%) - 193{,}077.86 = 185{,}906.56

    Value grows 3% a year from the purchase price.

  7. Internal rate of return

    −84,000.00+∑t=110CFt(1+i)t+185,906.56(1+i)10=0  ⇒  i=12.13%-84{,}000.00 + \sum_{t=1}^{10} \frac{CF_t}{(1+i)^t} + \frac{185{,}906.56}{(1+i)^{10}} = 0 \;\Rightarrow\; i = 12.13\%

    Solved numerically on the yearly cash flows, before income tax.

关于Rental property calculator (cap rate and cash flow)

Net operating income (NOI) is the rent you collect after vacancy, minus operating costs: property tax, insurance, HOA dues, maintenance, management and other running costs, but not the mortgage. The cap rate is NOI divided by the purchase price. Cash flow is NOI minus the year's mortgage payments, and the cash-on-cash return divides it by the cash you put in: down payment plus closing and repair costs.

With the defaults, a $300,000 property bought with 25% down at 7% and rented for $2,600 a month has a year-1 NOI of $20,068.80, a 6.69% cap rate and $175.47 a month of cash flow, a 2.51% cash-on-cash return on $84,000. Sold after 10 years at 3% yearly appreciation, it returns an IRR of 12.13%.

Rent, costs and value grow at the rates you set. Income tax, depreciation and capital-gains tax are left out, so every figure is before tax.

计算示例

$300,000 with 25% down at 7%

Purchase price
300,000
首付款
25%
Closing costs and repairs at purchase
9000
Loan interest rate (per year)
7%
Loan term
30 years
Monthly rent
2600
Other monthly income
0
Vacancy and unpaid rent
5%
Property management (% of rent collected)
8%
Property tax (per year)
3300
Insurance (per year)
1500
HOA dues (per month)
0
Maintenance and repairs (per year)
2400
Other operating costs (per year)
0
Property value growth (per year)
3%
Rent growth (per year)
3%
Operating cost growth (per year)
3%
Years until sale
10 years
Selling costs (% of sale price)
6%
Net operating income (year 1)
20,068.80
Cap rate
6.69%
Cash flow (year 1)
2,105.63
Cash flow per month (year 1)
175.47
Cash-on-cash return (year 1)
2.51%
Mortgage payment per month
1,496.93
Debt service coverage ratio
1.12
Internal rate of return (IRR)
12.13%
Cash from the sale
185,906.56

核验来源:Python decimal model: yearly rent and costs grown at 3%, month-by-month amortization, IRR by 300 bisection steps on the NPV of the ten yearly flows plus sale proceeds

Cash purchase with no growth or costs

Purchase price
300,000
首付款
100%
Closing costs and repairs at purchase
0
Loan interest rate (per year)
7%
Loan term
30 years
Monthly rent
2000
Other monthly income
0
Vacancy and unpaid rent
0%
Property management (% of rent collected)
0%
Property tax (per year)
0
Insurance (per year)
0
HOA dues (per month)
0
Maintenance and repairs (per year)
0
Other operating costs (per year)
0
Property value growth (per year)
0%
Rent growth (per year)
0%
Operating cost growth (per year)
0%
Years until sale
5 years
Selling costs (% of sale price)
0%
Net operating income (year 1)
24,000.00
Cap rate
8.00%
Cash-on-cash return (year 1)
8.00%
Internal rate of return (IRR)
8.00%
Total profit
120,000.00
Gross rent multiplier
12.50
Mortgage payment per month
0.00

核验来源:Hand calculation: 2,000 × 12 = 24,000 ÷ 300,000 = 8%; five years of 8% cash yield with the price returned at the end is an 8% IRR

Zero-rate loan, 5-year hold

Purchase price
300,000
首付款
25%
Closing costs and repairs at purchase
9000
Loan interest rate (per year)
0%
Loan term
30 years
Monthly rent
2600
Other monthly income
0
Vacancy and unpaid rent
5%
Property management (% of rent collected)
8%
Property tax (per year)
3300
Insurance (per year)
1500
HOA dues (per month)
0
Maintenance and repairs (per year)
2400
Other operating costs (per year)
0
Property value growth (per year)
3%
Rent growth (per year)
3%
Operating cost growth (per year)
3%
Years until sale
5 years
Selling costs (% of sale price)
6%
Mortgage payment per month
625.00
Cash flow (year 1)
12,568.80
Cash-on-cash return (year 1)
14.96%
Internal rate of return (IRR)
24.27%
Cash from the sale
139,415.29
Equity at sale
160,282.22

核验来源:Python decimal model as above: 225,000 ÷ 360 = 625 a month; balance after 60 payments 187,500; value 300,000 × 1.03^5

Negative cash flow with 10% down (edge)

Purchase price
300,000
首付款
10%
Closing costs and repairs at purchase
9000
Loan interest rate (per year)
8%
Loan term
30 years
Monthly rent
1900
Other monthly income
0
Vacancy and unpaid rent
5%
Property management (% of rent collected)
8%
Property tax (per year)
3300
Insurance (per year)
1500
HOA dues (per month)
0
Maintenance and repairs (per year)
2400
Other operating costs (per year)
0
Property value growth (per year)
3%
Rent growth (per year)
3%
Operating cost growth (per year)
3%
Years until sale
10 years
Selling costs (% of sale price)
6%
Net operating income (year 1)
12,727.20
Cash flow per month (year 1)
-920.56
Cash-on-cash return (year 1)
-28.33%
Debt service coverage ratio
0.54
Internal rate of return (IRR)
1.29%

核验来源:Python decimal model as above: 270,000 at 8% costs 1,981.16 a month, more than the 1,060.60 of monthly NOI

常见问题

How do you calculate cap rate?

Divide the year's net operating income by the property's price or value and multiply by 100. NOI is collected rent minus operating costs, before mortgage payments. A property earning $24,000 of NOI on a $300,000 price has an 8% cap rate. Because financing is left out, the cap rate compares properties regardless of how each is paid for; it is the direct-capitalization rate appraisers use in value = NOI ÷ rate.

What is the difference between cap rate and cash-on-cash return?

Cap rate ignores the loan; cash-on-cash return includes it. Cap rate = NOI ÷ price, and cash-on-cash = (NOI − mortgage payments) ÷ cash invested. With the defaults, NOI of $20,068.80 on $300,000 is a 6.69% cap rate, but after $17,963.17 of mortgage payments the $2,105.63 of cash flow is 2.51% of the $84,000 invested. Borrowing at a rate above the cap rate lowers the cash return.

What is net operating income on a rental property?

Rental income collected, after vacancy, minus the costs of running the property: property tax, insurance, HOA dues, repairs and maintenance, management and utilities you pay. Mortgage principal and interest, depreciation and income tax are not operating costs. On the defaults, $31,200 of scheduled rent less 5% vacancy is $29,640 collected; $9,571.20 of costs leaves an NOI of $20,068.80.

What does the debt service coverage ratio mean?

DSCR is NOI divided by the year's mortgage payments. At 1.0 the rent just covers the loan after operating costs; below 1.0 you pay the shortfall from other income. The defaults give 20,068.80 ÷ 17,963.17 = 1.12, and the 10%-down example at 8% gives 0.54. Lenders that qualify a loan on the property's income set their own minimum DSCR, so ask for yours before you rely on the rent.

“Rental property calculator (cap rate and cash flow)”有多准确?

准确性取决于输入值和方法的假设。十进制运算使用50位有效数字,但估算、数值方法和源数据的精度可能较低;显示时的舍入并不能消除这些限制。 已按独立来源核验的计算示例:4。 例如,“$300,000 with 25% down at 7%”根据Python decimal model: yearly rent and costs grown at 3%, month-by-month amortization, IRR by 300 bisection steps on the NPV of the ten yearly flows plus sale proceeds进行核验。

这种方法出自哪里?

Appraisal Institute, The Appraisal of Real Estate (15th ed.): direct capitalization, V = I ÷ R; IRS Publication 527 (2025), Residential Rental Property: rental income and expenses; Microsoft Excel IRR function.

关于此计算器

NOI=rent collected−operating costs,cap rate=NOIprice,cash-on-cash=NOI−debt servicecash invested,∑t=0NCFt(1+IRR)t=0\text{NOI} = \text{rent collected} - \text{operating costs},\quad \text{cap rate} = \frac{\text{NOI}}{\text{price}},\quad \text{cash-on-cash} = \frac{\text{NOI} - \text{debt service}}{\text{cash invested}},\quad \sum_{t=0}^{N} \frac{CF_t}{(1+\text{IRR})^t} = 0

来源

  1. Appraisal Institute, The Appraisal of Real Estate (15th ed.): direct capitalization, V = I ÷ R
  2. IRS Publication 527 (2025), Residential Rental Property: rental income and expenses
  3. Microsoft Excel IRR function

仅用于规划。贷款机构、税务机关和市场采用各自的舍入方式、费用和规则;作出承诺前,请向相关机构确认数值。

已对照来源验证

此计算器包含 4 个已解示例,答案来自独立来源。这些示例会在测试套件中运行,你也可以在此运行验证。

相关计算器