| | | | | | | | | | | | | | | | | | | | | | | | Rental Property Analyzer | |
| |
| | |
| Step 1: Replace sample data with your data and tab to next
entry. Analyzer updates after each
entry. | | Step
2: View your projected results! Note that you can see the projected results
in three views below. | |
| | | | |
| Purchase
of Property | | *-How to Enter Data | View 1--Gross return
(think compound interest) | | |
| Price
you will pay for the property? | | *-Enter amt., hit tab | Your safe investment
rate before taxes is | | |
| Down payment? | | | Your compound rate of
return on this property is | | |
| First mortgage amount? | | | This return is better
(worse) than your safe rate by | | |
| First mortgage period in years? | | *-Enter yrs., hit tab | | | |
| First mortgage interest rate? | | | View 2--After-tax
adjusted rate of return | | |
| Monthly payment (calculated) | | | Your safe investment
rate after taxes is | | | |
| First mortgage points (percent)? | | *-Enter %, hit tab | This property produces
an after-tax annual return of | | |
| Points (calculated dollar amount) | | | This return is better
(worse) than your safe rate by | | |
| Other first mortgage closing costs | | | | | |
| Total costs to obtain mortgage | | | View 3--After-tax cash profit
(loss) | | | |
| Closing costs to obtain title
(transfer/stamp taxes, survey, etc)? | | | In today's dollars
(present value), you invest | | |
| | In tomorrow's dollars
(future value), you walk away with | | |
| Second mortgage? Enter 1 for yes, 2 for no. | | | | This gives you a cash
profit (loss) of | | | |
| | | Number of years you will
own this property | | |
| Second mortgage amount? | | | | | | |
| | | | |
| Second mortgage period in years? | | | | | | |
| Second mortgage interest rate? | | |
| Monthly payment (calculated) | | |
| Balloon payment on second
mtg? Enter 1 for yes, 2 for no. | | | |
| |
| Year of balloon payment? | | |
| Balloon payment (calculated) | | | | |
| Second
mortgage points or other | | |
| acquisition
costs? | |
| | | |
| Rental
Income | | |
| Monthly
rent? | | |
| Annual rent | | |
| Vacancy rate
as a percentage? | | |
| Net annual rental income | | |
| Expected annual increase in rent
as a percentage (your best guess)? | | |
| |
| | | | | |
| Income
Taxes | | | | |
| Federal
tax rate on ordinary income? | | | | | | |
| State tax rate on ordinary income? | | | | |
| Federal tax rate on unrecaptured section 1250 gain? | | | | | | |
| Federal tax rate on capital gains? | | | | |
| State tax rate on capital gains? | | | | | | |
| Do you qualify according to tax law to deduct your passive
losses? Enter 1 for yes, 2 for no. | | | | | | |
| | | | | |
| Investment
Return | | | | |
| Annual
percentage return you earn on a safe investment? | | | | | | |
| Tax rate (combined state and federal) that applies to this safe
investment? | | For
reference, your combined ordinary income state and federal tax rate is to the
right of this note. | | | |
| After-tax safe return (calculated) | | | | | |
| | | | | | |
| Appreciation
in Property Value | | | | |
| Years
you intend to own this property? | | | | |
| Anticipated average annual appreciation in property value? | | |
| Selling price of property (calculated) | | | | |
| Real estate commissions and closing costs on the sale of this
property as a percentage of selling price? | | |
| | | |
| Property Ownership/Carrying Costs | | | |
| Real estate taxes per year? | | |
| Annual increase in real estate taxes? | | |
| Property management fees? | | | | |
| Annual increase in fees? | | | | |
| Tenant location fees? | | | | |
| Annual increase in fees? | | | | |
| Repairs and maintenance per year? | | | | |
| Annual increase in repairs/maint.? | | | | |
| Property insurance? | | | | |
| Annual increase in insurance? | | |
| Utilities per year? | | |
| Annual increase in utilities? | | | One-Time Property
Ownership/Carrying Costs by Year | | |
| Condo fees? | | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | |
| Annual increase in condo fees? | | | | | | | | | | |
| Other expenses? | | | 8 | 9 | 10 | 11 | 12 | 13 | 14 | |
| Annual increase in other expenses? | | | | | | | | | | |
| | | | 15 | 16 | 17 | 18 | 19 | 20 | 21 | |
| Allocation of Purchase Price to Land, Building | | | | | | | | | |
| Commercial property? Enter 1 Residential property? Enter 2 | | | | These costs appear in the calculations below. | |
| Purchase price of property? | | | | |
| Closing costs to perfect title? | | | | |
| Total cost (basis) of property | | | | |
| Percent of cost (basis) to land? | | |
| Basis of land | | |
| Basis of building | | |
| To
keep this worksheet straightforward, cost segregation, qualified improvement
property, and personal property depreciation are not considered. | |
