Real Estate Investment Worksheet

Download a spreadsheet

NOI and CAP Rate

Monthly Rent*
Annual Rent
Other Income
Total Gross
Vacancy and
Unpaid Rent %
3 Year Replacements
5 Year Replacements
12 Year Replacements
Reserve Fund
Maintenance
Utilities
Property Taxes
Insurance
Management Fees
Net Operating Income
Market Value
Down Payment
Closing Costs
Cash on Cash Return
CAP Rate

Finance

1st Loan Amount
Type
Term
Interest Rate
Property Tax (Annual)
Insurance(Annual)
Monthly Prin + Int
Monthly Tax
Monthly Ins
Monthly Total
2nd Loan Amount
Type
Term
Interest Rate
Monthly Prin + Int

Cash Flow

Annual Monthly
Net Operating Income
1st Loan
2nd Loan
DSCR  
Cash Flow