Investment Analysis

Investment Property
Worksheet.

Before you buy any investment property, run the numbers. This step-by-step worksheet shows you exactly how to analyze a deal and determine if it's worth your money.

Every successful real estate investor knows that the numbers tell the truth. A property can look great on the outside, but if the math doesn't work, it's not a good investment. This worksheet walks you through the exact analysis process Tim Tepes uses to evaluate every investment property across the Lehigh Valley.

Grab a calculator and work through each step. By the end, you'll know whether a property is worth pursuing — or walking away from.

1

Purchase Price

Start with the asking price (or the price you negotiate). This is the foundation for every calculation that follows. In the Lehigh Valley, single-family investment properties typically range from $150,000 to $350,000, while small multifamily (2–4 units) range from $200,000 to $500,000.

Enter Your Numbers
Purchase Price: $
_______________
2

Expected Monthly Rent

Research comparable rentals in the immediate area. Look at similar properties — same bedroom count, same condition, same neighborhood. Don't guess. Use actual rental listings and recent lease data. Tim Tepes provides a fair market rent analysis for every property he recommends.

Enter Your Numbers
Monthly Rent: $
_______________
3

Gross Annual Income

Multiply your monthly rent by 12. This is your gross annual income — the total rent you'd collect if the property were occupied every single month.

Calculation
Monthly Rent × 12 = Gross Annual Income

Example: $1,800/month × 12 = $21,600

4

Vacancy Rate

No property is occupied 100% of the time. Between tenant turnover, maintenance periods, and market fluctuations, you'll experience some vacancy. A safe assumption is 5–8% of gross annual income for well-located Lehigh Valley properties. Always budget for vacancy — it's not a matter of if, but when.

Conservative (5%)

Best for high-demand areas with strong rental markets — downtown Bethlehem, center-city Easton, established neighborhoods.

Moderate (8%)

Better for emerging neighborhoods, rural areas, or properties with higher turnover history.

Calculation
Gross Annual Income × Vacancy % = Vacancy Allowance

Example: $21,600 × 5% = $1,080

5

Effective Gross Income (EGI)

Subtract your vacancy allowance from gross annual income. This is what you'll actually collect — your effective gross income. This is the real number to work from, not the theoretical max.

Calculation
Gross Annual Income − Vacancy = Effective Gross Income

Example: $21,600 − $1,080 = $20,520

6

Operating Expenses Breakdown

Now subtract every cost of owning and operating the property. Here's the full breakdown:

Property Taxes

Northampton and Lehigh Counties typically assess at 1.5–2.5% of value. Check the actual tax bill.

1.5–2.5% of value
Insurance

Landlord/rental property insurance covers liability, structure, and loss of rent.

$800–$1,500/year
Maintenance & Repairs

Budget for HVAC service, plumbing, appliances, roof, and general upkeep.

5–10% of gross rent
Property Management

Professional management handles tenants, rent collection, maintenance calls, and accounting.

8–12% of gross rent
Utilities (if owner-paid)

Water, sewer, trash, electric, gas — only if not tenant-paid. Turnkey properties have tenant-paid utilities.

Varies
HOA Fees

If applicable. Some condos, townhomes, and planned communities charge monthly or annual fees.

$0–$400/month
Capital Expenditure Reserves

Set aside money for big-ticket items: roof replacement, water heater, flooring, appliances.

3–5% of gross rent
Enter Your Numbers
Total Annual Operating Expenses: $
_______________
7

Net Operating Income (NOI)

Subtract total operating expenses from your effective gross income. The result is your Net Operating Income — the true income the property generates before mortgage payments. This is the number you use to calculate cap rate and evaluate the property's inherent profitability.

Key Formula
Effective Gross Income − Operating Expenses = NOI
8

Debt Service (Mortgage Payment)

If you're financing the property (and most investors do — that's Leverage at work), calculate your annual mortgage payment. Include principal and interest. Property taxes and insurance are typically included in your monthly payment via escrow, but they're already counted in your operating expenses above.

Enter Your Numbers
Annual Mortgage Payment (P&I): $
_______________
9

Cash Flow

This is the number every investor wants to know: how much money lands in your pocket each month? Subtract your annual mortgage payment from your NOI. Divide by 12 for monthly cash flow.

Calculation
NOI − Annual Mortgage Payment = Annual Cash Flow
÷ 12 = Monthly Cash Flow

Goal: Positive cash flow from day one. If the numbers show negative cash flow, the property either needs a lower purchase price, higher rent, or both. Never buy a property hoping it will "work out" — the numbers must work on paper first.

10

Cap Rate Calculation

The capitalization rate tells you the property's yield if you paid all cash. It lets you compare different properties on an apples-to-apples basis. See our full Cap Rate guide for details.

Formula
Cap Rate = NOI ÷ Purchase Price × 100

Example: $14,000 ÷ $200,000 = 7.0% cap rate

11

Cash-on-Cash Return

This is the metric that matters most for financed purchases. It tells you what your actual invested cash earns each year. See our full Cash-on-Cash Return guide for details.

Formula
Cash-on-Cash = Annual Cash Flow ÷ Total Cash Invested × 100

Total Cash Invested = down payment + closing costs + rehab

12

The 1% Rule

The 1% rule is a quick screening tool. It says: the monthly rent should be approximately 1% of the purchase price. If a $200,000 property rents for $2,000/month, it passes the 1% rule. If it only rents for $1,200/month, it likely won't generate positive cash flow.

Quick Test
Monthly Rent ÷ Purchase Price = Ratio
≥ 1%
Passes — likely positive cash flow
< 0.7%
Caution — run full analysis

Important: The 1% rule is a rough guide, not a hard rule. In appreciating markets like the Lehigh Valley, a property that "fails" the 1% rule may still be an excellent investment when you factor in appreciation, equity building, and tax advantages. Always do the full analysis.

Complete Example: Lehigh Valley Rental

Here's a real-world example using typical Lehigh Valley numbers:

Purchase Price $200,000
Down Payment (20%) $40,000
Closing Costs (3%) $6,000
Total Cash Invested $46,000
Monthly Rent $1,800
Gross Annual Income $21,600
Less: Vacancy (5%) − $1,080
Less: Property Taxes − $3,400
Less: Insurance − $1,100
Less: Management (10%) − $2,052
Less: Maintenance (8%) − $1,642
Less: CapEx Reserves (5%) − $1,026
NOI $11,300
Less: Annual Mortgage (P&I) − $8,370
Annual Cash Flow $2,930
Monthly Cash Flow $244
Cap Rate
5.7%
Cash-on-Cash
6.4%
1% Rule
0.9%

This property just misses the 1% rule (0.9%), but with a 5.7% cap rate, 6.4% cash-on-cash return, plus tax benefits from depreciation and appreciation, it's a solid investment — especially in the Lehigh Valley's appreciating market.


Want Tim Tepes to run this analysis on a property you're considering? He evaluates every deal personally with 36+ years of Lehigh Valley market data.