|
|
|
|
|
|
|
|
|
|
This page is for investors. The forms below are designed to assist in estimating the first year benefits of a real estate investment. It does not consider the effect of selling or exchanging (if you don't know what is meant by exchange see below) the property in the future. This form is not a substitute for legal or tax advice. Anyone contemplating the purchase of a real estate investment should seek the services of competent legal and tax advisors. Having said all that, used correctly, this form can help in the decision process to buy investment property based on Return On Investment.
There are 4 financial benefits from owning investment property:
-
Income: Cash flow before taxes.
-
Principal pay down (by renters).
-
Income tax savings.
-
Appreciation.
It is important to look at 3 items closely: Income, Expenses, and Financing. Missing just one of these items and there is no way to determine if the investment is good or not. This form can also be used to determine when to sell investment property. Yes, you don't keep investment property forever and you don't pay cash for investment property. Both ways you lose the tax advantage and money. When buying investment property obtain the seller's Schedule E which the seller sends to the IRS. This should give you all the important information such as Gross Operating Income and Annual Operating Expenses. This is the most important information you can receive from the seller. If the seller will not give you the Schedule E than I would worry the figures the seller is stating are not correct. With that information it is easy to figure the Return-On-Investment as shown below.
Some information on Depreciation:
-
Land: does not depreciate.
-
Personal property: refrigerator, stove, etc, depreciate value over 5 years.
-
Residential rental buildings: home, duplex, 4 plex, (live in it more than 30 days), etc, depreciate value over 27 1/2 years.
-
Non-residential buildings: motels, condos, (rented by day or week), etc, depreciate value over 39 years.
-
Land improvements: sprinkler system, pool, fence, landscaping, parking lot, etc, depreciate value over 15 years.
For tax purposes the depreciation starts the day you buy the property. It doesn't matter how old the item or building is or if the seller took all the depreciation on his/her tax return. Each time the property is sold the depreciation on Personal Items, Building, and Land Improvements starts over.
Another important item to remember: when putting an offer in on a property, write in the Earnest Money Agreement Land value (15% of the purchase price), Building value (65% of the purchase price), Land Improvement value (10% of the purchase price), and Personal Property value (10% of the purchase price). |
|
|
|
|
Investment Property Worksheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Address Of Property: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Purchase Price/Cost: |
|
|
|
|
|
|
|
|
Downpayment/Cash Invested: |
|
|
|
|
|
|
|
|
Finacing: |
|
Amount: |
|
Interest Rate: |
|
P&I / Month: |
0 |
|
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
1 Year Interest: |
0 |
|
Land Value (15% Of Purchase Price): |
|
|
0 |
|
|
|
|
Personal Property Value (10% Of Purchase Price): |
|
|
0 |
0 |
X 20% = |
0 |
|
|
Building Value (65% Of Purchase price): |
|
0 |
0 |
X 3.48% = |
0 |
|
|
Land Improvement (10% Of Purchase price): |
0 |
0 |
X 5% = |
0 |
|
|
|
|
|
|
|
Total Depreciation: |
|
0 |
|
|
Monthly Total Rent |
|
|
|
|
|
|
|
|
|
Annual Rent: |
0 |
Less Vacancy (10%)= |
0 |
Gross Operating Income |
|
|
|
|
|
|
|
|
|
|
|
|
|
Annual Operating Expenses: |
|
|
|
|
|
|
|
|
|
Real Estate Tax = |
|
|
|
|
|
|
|
|
|
Repairs = |
|
|
|
|
|
|
|
|
|
|
Association Dues = |
|
|
|
|
|
|
|
|
|
Management Fee = |
|
|
|
|
|
|
|
|
|
Insurance = |
|
|
|
|
|
|
|
|
|
Utilities = |
|
|
|
|
|
|
|
|
|
|
Advertising = |
|
|
|
|
|
|
|
|
|
Supplies = |
|
|
|
|
|
|
|
|
|
Miscellaneous = |
|
|
|
|
|
|
|
|
Total Annual Operating Expenses = |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
I. Gross Operating Income: |
|
|
0 |
|
|
|
|
|
Minus (-): Total Annual Operating Expenses |
0 |
|
|
|
|
|
Equals (=): Net Operating Income |
|
0 |
|
|
|
|
|
Minus (-): Annual Debt Servive (P & I X 12) |
0 |
|
|
|
|
|
Equals (=): Cash Flow Before Taxes |
|
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
II. Annual Debt Service (P & I X 12): |
|
0 |
|
|
|
|
|
Minus (-): Interest (1st Year Interest On Loan) |
0 |
|
|
|
|
|
Equals (=): Principle Reduction: |
|
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
III. Net Operating Income: |
|
|
0 |
|
|
|
|
|
Minus (-): Interest (1st Year Interest On Loan) |
0 |
|
|
|
|
|
Minus (-): Total Depreciation |
|
|
0 |
|
|
|
|
|
Equals (=): Taxable Income (Lower The Better & Negative (-) Is Best) |
0 |
|
|
|
Multiplied (X) By Your Tax Bracket: |
|
|
|
|
|
|
|
Equals (=): Tax Paid or Saved (Negative Saved/ Positive Paid) |
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Return On Investment Without Appreciation: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash Flow Before Taxes + Principle Reduction + Tax Saved |
0 |
0 |
8%+ Is OK |
|
|
Divided By Cash Invested/Downpayment |
|
0 |
|
But 14%+ Is Better |
|
|
|
|
|
|
|
|
|
|
|
|
Capitalization Rate: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Operating Income |
#DIV/0! |
Cap Rate |
|
|
|
|
|
|
Divided By Purchase Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash On Cash: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash Flow Before Taxes |
|
#DIV/0! |
|
|
|
|
|
|
Divided By Cash Invested/Downpayment |
|
|
|
|
|
| |
|
The form below is filled in using the following example: Purchase Price: $85,000 Down Payment/Cash Invested: $15,000 Owner Financing: $70,000, 30 years @ 10% Monthly Rent: $1,100 Annual Expenses: $4,800 as listed Tax Bracket: 35% (state & federal combined) |
|
|
|
|
Investment Property Worksheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Address Of Property: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Purchase Price/Cost: |
85,000 |
|
|
|
|
|
|
|
Downpayment/Cash Invested: |
15000 |
|
|
|
|
|
|
|
Finacing: |
|
Amount: |
70,000 |
Interest Rate: |
0.1 |
P&I / Month: |
19.178082 |
|
|
|
|
|
|
|
|
|
|
575.34247 |
|
|
|
|
|
|
|
|
1 Year Interest: |
6282.7397 |
|
Land Value (15% Of Purchase Price): |
|
|
12750 |
|
|
|
|
Personal Property Value (10% Of Purchase Price): |
|
|
85,000 |
8500 |
X 20% = |
1700 |
|
|
Building Value (65% Of Purchase price): |
|
85,000 |
55250 |
X 3.48% = |
1922.7 |
|
|
Land Improvements (10% Of Purchase price): |
85,000 |
8500 |
X 5% = |
425 |
|
|
|
|
|
|
|
Total Depreciation: |
|
4047.7 |
|
|
Monthly Total Rent |
1100 |
|
|
|
|
|
|
|
|
Annual Rent: |
13200 |
Less Vacancy (10%)= |
11880 |
Gross Operating Income |
|
|
|
|
|
|
|
|
|
|
|
|
|
Annual Operating Expenses: |
|
|
|
|
|
|
|
|
|
Real Estate Tax = |
|
2800 |
|
|
|
|
|
|
|
Repairs = |
|
|
750 |
|
|
|
|
|
|
|
Association Dues = |
|
|
|
|
|
|
|
|
|
Management Fee = |
|
|
|
|
|
|
|
|
|
Insurance = |
|
400 |
|
|
|
|
|
|
|
Utilities = |
|
|
200 |
|
|
|
|
|
|
|
Advertising = |
|
150 |
|
|
|
|
|
|
|
Supplies = |
|
|
|
|
|
|
|
|
|
Miscellaneous = |
|
500 |
|
|
|
|
|
|
Total Annual Operating Expenses = |
4800 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
I. Gross Operating Income: |
|
|
11880 |
|
|
|
|
|
Minus (-): Total Annual Operating Expenses |
4800 |
|
|
|
|
|
Equals (=): Net Operating Income |
|
7080 |
|
|
|
|
|
Minus (-): Annual Debt Servive (P & I X 12) |
6904.11 |
|
|
|
|
|
Equals (=): Cash Flow Before Taxes |
|
|
|
175.8904 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
II. Annual Debt Service (P & I X 12): |
|
6904.11 |
|
|
|
|
|
Minus (-): Interest (1st Year Interest On Loan) |
6282.74 |
|
|
|
|
|
Equals (=): Principle Reduction: |
|
|
|
621.3699 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
III. Net Operating Income: |
|
|
7080 |
|
|
|
|
|
Minus (-): Interest (1st Year Interest On Loan) |
6282.74 |
|
|
|
|
|
Minus (-): Total Depreciation |
|
|
4047.7 |
|
|
|
|
|
Equals (=): Taxable Income (Lower The Better & Negative (-) Is Best) |
-3250.44 |
|
|
|
Multiplied (X) By Your Tax Bracket: |
|
0.35 |
|
|
|
|
|
Equals (=): Tax Paid or Saved (Negative Saved/ Positive Paid) |
|
-1137.65 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Return On Investment Without Appreciation: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash Flow Before Taxes + Principle Reduction + Tax Saved |
1934.914 |
0.128994 |
8%+ Is OK |
|
|
Divided By Cash Invested/Downpayment |
|
15000 |
12.8994% |
But 14%+ Is Better |
|
|
|
|
|
|
|
|
|
|
|
|
Capitalization Rate: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Operating Income |
0.083294 |
Cap Rate |
|
|
|
|
|
|
Divided By Purchase Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash On Cash: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash Flow Before Taxes |
|
0.011726 |
|
|
|
|
|
|
Divided By Cash Invested/Downpayment |
|
|
|
|
|
| |
| Your tax savings is $-1,137.65(the more negative this number is, the better (tax savings)).
Your Return On Investment is 12.89%! This is a good investment!! |
|
Exchange: is not where you actually trade or exchange one property for another. A tax-deferred exchange permits a seller of nonresidential real property (your residence) to sell property, and defer tax on the profit earned from the sale. The seller “exchanges” by using sale proceeds from the sale of the “relinquished” property to purchase a “replacement” property. With the help of an intermediary, also called a Facilitator, the seller relinquishes one property, and replaces it with another property without actual receipt of funds. In this manner, the IRS considers the transaction to be an exchange of one property for another. Clients who exchange property may defer tax consequences until they actually receive funds. In fact, some clients may avoid tax consequences entirely. The properties sold and purchased must be real property located within the U.S., and neither may be one’s residence. At the closing of the sale, the Facilitate approves the closing documents and provides a set of exchange documents for signature. The sale proceeds are deposited with a local bank, directly into an interest-bearing trust account. The client receives the interest earned. When the closing of the purchase of the replacement property occurs, the Facilitate wires the exchange funds to the closing agent selected by the client. The IRS does not permit the seller to have possession of these funds. Two deadlines begin to run on the date the sale of the relinquished property closes. Within 45 days, the client must provide the Facilitator with a letter identifying up to three potential replacement properties. Within 180 days (or prior to filing one’s next IRS Return), the closing of the purchase of the replacement property must be concluded. This is very important! If you close on the new property on the 181 day, you will owe capital gains. 180 days or less you don't pay taxes. Notice I said 180 days and NOT 6 months. It is important for Facilitator to receive a copy of the Real Estate Purchase and Sale Agreements involved, and each Agreement should indicate that the transaction may involve a 1031 Exchange. It is also important for the Facilitator to be placed in contact with the closing agent early in the closing process. A Facilitator charges about $750 to process a tax-deferred exchange. |
|
|
|
Silver Hawk Home Owners
Home Page | Winterize your Home | Club House | Petition2009 | Update 2009 | Aerials Copyright © 2010 Silver Hawk Home Owners Portions Copyright © 2010 a la mode, inc. Another XSite by a la mode, inc. | Admin Login| Terms of Use| Site Map
|
 |
|