Print Download PDF Add to Portfolio Link to Property Reserve Property

Create a Dynamic Proforma

This is a static proforma. Easily create your own dynamic proformas for FREE at www.PropertyTracker.com.

Book Your Free Investment Consultation

Have questions about this property or your strategy? Schedule a quick consultation and we'll walk through next steps together.

Brand New SF Duplex in Edmond
Edmond, OK 73012
3bd • 2.5ba • Built: 2025

Projected Income	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10
Projected Rent	$48,000	$49,440	$50,923	$52,451	$54,024	$55,645	$57,315	$59,034	$60,805	$62,629
Vacancy Losses	($3,840)	($3,955)	($4,074)	($4,196)	($4,322)	($4,452)	($4,585)	($4,723)	($4,864)	($5,010)
Operating Income	$44,160	$45,485	$46,849	$48,255	$49,702	$51,194	$52,729	$54,311	$55,941	$57,619

Estimated Expenses	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10
Property Taxes	($7,119)	($7,333)	($7,553)	($7,779)	($8,012)	($8,253)	($8,500)	($8,755)	($9,018)	($9,289)
Insurance	($1,978)	($2,037)	($2,098)	($2,161)	($2,226)	($2,292)	($2,361)	($2,432)	($2,505)	($2,580)
Management Fees	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Leasing/Advertising Fees	($600)	($618)	($637)	($656)	($675)	($696)	($716)	($738)	($760)	($783)
Association Fees	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Maintenance	($960)	($989)	($1,018)	($1,049)	($1,080)	($1,113)	($1,146)	($1,181)	($1,216)	($1,253)
Other	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Operating Expenses	($10,657)	($10,976)	($11,305)	($11,645)	($11,994)	($12,354)	($12,724)	($13,106)	($13,499)	($13,904)

Income Analysis	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10
Net Operating Income	$33,504	$34,509	$35,544	$36,610	$37,708	$38,840	$40,005	$41,205	$42,441	$43,714
- Mortgage Payments	($30,897)	($30,897)	($30,897)	($30,897)	($30,897)	($30,897)	($30,897)	($30,897)	($30,897)	($30,897)
= Cash Flow	$2,606	$3,612	$4,647	$5,713	$6,811	$7,943	$9,108	$10,308	$11,544	$12,817
+ Principal Reduction	$5,083	$5,404	$5,744	$6,106	$6,491	$6,900	$7,334	$7,796	$8,287	$8,810
+ Appreciation	$33,900	$35,934	$38,090	$40,375	$42,798	$45,366	$48,088	$50,973	$54,031	$57,273
= Gross Equity Income	$41,590	$44,949	$48,481	$52,195	$56,100	$60,208	$64,530	$69,077	$73,863	$78,900
Capitalization Rate	5.6%	5.4%	5.3%	5.1%	5.0%	4.8%	4.7%	4.6%	4.4%	4.3%
Cash on Cash Return	1.5%	2.1%	2.7%	3.4%	4.0%	4.7%	5.4%	6.1%	6.8%	7.6%
Return on Equity	23.1%	20.3%	18.3%	16.7%	15.5%	14.6%	13.8%	13.1%	12.5%	12.0%

Loan Analysis	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10
Market Value	$598,900	$634,834	$672,924	$713,299	$756,097	$801,463	$849,551	$900,524	$954,556	$1,011,829
- Loan Balance	($418,667)	($413,263)	($407,519)	($401,413)	($394,922)	($388,023)	($380,688)	($372,892)	($364,605)	($355,795)
= Equity	$180,233	$221,571	$265,405	$311,887	$361,175	$413,441	$468,863	$527,632	$589,951	$656,034
Loan-to-Value Ratio	69.9%	65.1%	60.6%	56.3%	52.2%	48.4%	44.8%	41.4%	38.2%	35.2%
Potential Cash-Out Refi	$30,508	$62,863	$97,174	$133,562	$172,151	$213,075	$256,475	$302,501	$351,312	$403,077

Sale Analysis	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10
Equity	$180,233	$221,571	$265,405	$311,887	$361,175	$413,441	$468,863	$527,632	$589,951	$656,034
- Closing Costs	($41,923)	($44,438)	($47,105)	($49,931)	($52,927)	($56,102)	($59,469)	($63,037)	($66,819)	($70,828)
= Proceeds After Sale	$138,310	$177,133	$218,301	$261,956	$308,248	$357,338	$409,394	$464,595	$523,132	$585,206
+ Cumulative Cash Flow	$2,606	$6,218	$10,865	$16,578	$23,390	$31,332	$40,440	$50,748	$62,293	$75,110
- Approximate Cash Invested	($169,500)	($169,500)	($169,500)	($169,500)	($169,500)	($169,500)	($169,500)	($169,500)	($169,500)	($169,500)
= Net Profit	($28,583)	$13,851	$59,666	$109,034	$162,138	$219,171	$280,334	$345,844	$415,925	$490,816
Internal Rate of Return	-16.9%	4.0%	10.7%	13.5%	14.8%	15.4%	15.6%	15.6%	15.6%	15.5%
Return on Investment	-16.9%	8.2%	35.2%	64.3%	95.7%	129.3%	165.4%	204.0%	245.4%	289.6%

*Information is not guaranteed and investors should do their own research, get professional advice and conduct due diligence prior to investing.

Down payment

The amount you pay upfront.

Purchase price − First loan − Second loan

Approximate cash invested

All the cash you put in at the start.

Down payment + Closing costs + Fix-up costs + Loan fees

Cost per square foot

Helps you compare prices across properties.

Purchase price / Square feet

Rent per square foot

Useful for comparing rental income.

Monthly rent / Square feet

Nominal / Real interest rate

Nominal is the stated interest rate on the loan.

Real approximates the interest rate after inflation.

Real rate = Nominal rate − Projected inflation rate

Vacancy losses

Expected lost rent when the property is empty.

Rent × Vacancy rate (as a percent)

Operating income

Income after accounting for empty periods.

Rent − Vacancy losses

Net operating income (NOI)

Income before mortgage payments.

Operating income − All property expenses (taxes, insurance, management, maintenance, etc.)

Cash flow

What's left after paying the mortgage. Positive means the property pays for itself.

Net operating income − Monthly loan payment

Capitalization rate

A quick way to compare similar properties.

Annual net operating income / Purchase price × 100 → %

Debt coverage ratio

How many times your income covers the mortgage. Above 1.0 means income exceeds the payment.

Net operating income / Monthly mortgage payment

Cash on cash return

Shows how hard your money is working.

Annual cash flow / Cash invested × 100 → %

Return on investment

Total return as a percent of what you invested. We also show versions that include Inflation Induced Debt Destruction^® (IIDD) and tax benefits.

Gross equity income (cash flow + principal + appreciation) / Cash invested × 100 → %

Return on Investment with IIDD

Return on investment including the benefit of inflation reducing the real value of your debt.

Gross equity income including Inflation Induced Debt Destruction^® (IIDD) / Cash invested × 100 → %

Inflation Induced Debt Destruction^® (IIDD)

As inflation happens, the real value of your loan balance goes down.

Projected inflation rate (as a percent) × Total loan amount

Loan fees

Fees charged by the lender for the first and second loans. Spread over the life of the loan for tax purposes.

First loan fees + Second loan fees

Closing costs

One-time costs to buy the property (e.g. title, escrow). Counted in your initial investment and in depreciation for taxes.

Gross rent

Total rental income. Year 1 uses your current rent; later years:

Prior year rent × (1 + Rental growth rate)

Operating expenses

All property expenses. In later years each line grows with inflation (management with rental growth).

Property tax + Insurance + Management + Leasing + Association fees + Maintenance + Other

Principal reduction

The part of your mortgage payment that pays down the loan balance each year (not interest). From the first and second loans combined.

Appreciation

Increase in the property's value from one year to the next. Market value grows at your assumed appreciation rate.

This year's market value − Last year's market value

Gross equity income

The total gain from the property in that year.

Cash flow + Principal paydown + Appreciation

Capitalization rate (10-year)

Uses current value instead of purchase price.

Net operating income / Market value (that year) × 100 → %

Return on equity

Shows how well your equity is performing.

Gross equity income / Equity (market value − loan balance) × 100 → %

Market value

Estimated value each year. Year 1 starts from initial market value.

Prior year's market value × (1 + Appreciation rate)

Loan balance

How much you still owe on the first and second mortgages. It goes down each year as you pay principal.

Equity

Your stake in the property.

Market value − Loan balance

Loan-to-value ratio

Your loan balance as a percent of the property's value. Lower means you own a bigger share.

Loan balance / Market value × 100 → %

Assumptions

This is a projection from our Local Market Specialists. If you would like to set your own assumptions, sign up at PropertyTracker.com and unlock a suite of investment tools.

Potential cash-out refi

Cash you could take out if you refinanced at the rate shown. Positive result means cash out.

(Refinance loan-to-value % × Market value) + Loan balance (loan balance is negative)

Closing costs (sale)

Estimated cost to sell (e.g. agent commission, transfer taxes). Shown as a negative.

Closing cost % × Market value

Proceeds after sale

What you'd receive from selling.

Equity + Closing costs of sale (closing costs are negative)

Cumulative cash flow

Total of all cash flow from year 1 through this year.

Cash flow (year 1) + Cash flow (year 2) + … + Cash flow (this year)

Net profit

If you sold at the end of this year.

Sale proceeds + Cumulative cash flow + Initial cash invested (initial investment is negative)

Internal rate of return (IRR)

An annual return rate that accounts for when you put money in and when you get it back, including the sale. Calculated from your initial investment and the series of cash flows plus sale proceeds in the chosen year. Good for comparing different investments.

Return on investment (sale)

If you sold at the end of this year.

Net profit / Cash invested × 100 → %

Rents received

Total rental income for the year from your tracker. Times your ownership share if applicable.

Rent + Pet fees + Damage credits + Reimbursements + Other income

Depreciation

Tax deduction for the wear and tear on the building. Special rules for the first year and year of sale (mid-month), and for GO Zone.

Basis / Life (years)

Total expenses (Schedule E)

All expenses for the year for Schedule E.

Actual expenses (operating + mortgage interest + loan fee amortization + other) + Depreciation

Net income (or loss)

The number you use for Schedule E on your tax return.

Total income − Total expenses

Amortization of loan fees

Loan fees spread over the life of the loan. Straight-line over the term; special rules for first year and payoff year. You deduct that portion for tax purposes.

Total loan fees / Loan term (years)

Learn How to Read a Performa

Create a Dynamic Proforma

Book Your Free Investment Consultation

Schedule a Consultation