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 حل شدہ مثالیں شامل ہیں۔ یہ ٹیسٹ مجموعے میں چلتی ہیں اور آپ انہیں یہاں بھی چلا سکتے ہیں۔

متعلقہ کیلکولیٹر