Real Estate Investment Investment

Document Sample
Real Estate Investment Investment Powered By Docstoc
					                                                                        Investment Analyzer
                                                                                                                                                               Investment Acronyms
                                                                        INPUT FIELDS
Purchase Price of Investment Property:                                                  $0.00 Utilities & Maintenance Breakdown/Year                       NOI:        Net Operating Income
Gross Monthly Scheduled Income:                                                         $0.00 WSG                                             0.00         Cap:        Capitilization Rate
Your interest rate on your 1st mortgage will be:                                    0.000% Gas                                                0.00         C/C:        Cash on Cash
Your interest rate on your 2nd mortgage will be:                                    0.000% Electric                                           0.00         LTV:        Loan To Value
Your Loan to Value Ratio on 1st Mortgage will be:                                   0.000% General Maintenance                                0.00         NPV:        Net Present Value

                                                                                    0.000% Preventive Maintenance                             0.00
                                                                                                                                                           IRR:        Internal Rate of Return
Your Loan to Value Ratio on 2nd Mortgage will be:
                                                                                                                                                           ROI:         Return On Investment
Number of years over which loan will be amortized:                                           0 Appliance Repair/replace                       0.00
                                                                                                                                                           P&I:        Principal and Interest
Your Discount Rate (as effective annual rate)                                       0.000% Phone                                              0.00
                                                                                                                                                           PMI:        Private Mortage Ins.
Adjusted Taxable Income (Wages, other investment, etc.)                                 $0.00 Advertising                                     0.00
                                                                                                                                                           GRM:        Gross Rents Multiplier
Annual Appreciation on Property & Cash flow (pre-tax only)                              0.00% Pest Control                                    0.00         DSCR:     Debt Service Coverage Ratio
Other Costs of Acquisition (Closing costs, appraisal, etc.)                              $0.00 Janitorial/Cleaning                            0.00
                                   Estimated Vacancy Factor (%):                        0.00% Office Supplies                                 0.00
                           Monthly Property Management Fixed Fee:                        $0.00 Onsite Manager Wage                           $0.00
                                   Property management fee (%):                         0.00% Association Dues                                0.00
Number of years to analyze investment: (1-10)                                               10 Lawn Maintenance                               0.00
                                   Prop. Taxes                                          $0.00 Snow Removal                                    0.00                                  RATIOS
                                   Haz. Ins.                                                 0 Alarm                                          0.00                   DSCR            #DIV/0!
                                   PMI                                                       0 Capital Improve Reserve                        0.00       Actual Cap Rate:            #DIV/0!
Is the Property Residential 'r' (1-4 units) or Commercial 'c':                                  Legal Fees                                    0.00          Pre-Tax C/C:             #DIV/0!
What is the value of the land without improvements:                                     $0.00                                                                          GRM:          #DIV/0!
What is the estimated value of the improvements:                                        $0.00                                                          IRR after 10 Years             #NUM!
Tax Status: M=Married Joint, MS=Married Filing Seperate S=Single,                                                                         NPV after 10 Years (HP10BII)                #NUM!
H=Head of household)
H=Head of household                Estimated Cost of Sale %                                           Average Annual ROI over a 10 year period w/ 1031 exchange                      #NAME?
                                                                                        0.00%
           Estimated Capital Gains Tax Rate at time of Sale                             0.00%           Average Annual ROI over a 10 year period w/ cash out sale                    #NAME?
                                                                                                             Average Annual ROI over a 10 year period with no sale                   #NAME?
                                                                                                                                 (ROI accounts for Total profit earned.)
                                                                       AUTOFILL                                                                                               AUTOFILL
           Estimated Annual Vacancy                                                     $0.00 1st Mortgage Loan Amount                                                                         $0.00
           Estimated Annual Management Fees                                             $0.00 2nd Mortgage Loan Amount                                                                         $0.00
           Annual Utilities and Maintenance                                             $0.00 Monthly P&I Payments on 1st Mortgage                                                   #DIV/0!
           Estimated Annual Expense, Vacancy, etc. Total :                              $0.00 Monthly P&I Payments on 2nd Mortgage                                                   #DIV/0!
           Net Operating Income:                                                        $0.00 Total Monthly P&I payments:                                                            #DIV/0!
           Annual Debt Service                                                #DIV/0!           Total Monthly Payments                                                               #DIV/0!
           Down Payment:                                                                $0.00 Mortgage Constant                                                                      #DIV/0!
           Other Costs of Acquisition                                                   $0.00 Nominal Interest Rate                                                                   #NUM!
           Total Costs of Acquisition:                                                  $0.00 Purchase Price:                                        Initial                                   $0.00
           Monthly Pre-Tax Cashflow                                           #DIV/0!           Tax Savings from Depreciation                        10 Years                        #NAME?
           Monthly After-Tax Cashflow                                        #NAME?             Estimated Appreciation after:                        10 Years                                  $0.00
           Annual Pre-Tax Cashflow                                            #DIV/0!           Annual After Tax Cash flows after:                   10 Years                        #NAME?
           Annual After-Tax Cash flow:                                       #NAME?             Remaining Principal on Loan after:                   10 Years                         #NUM!
           Annual Gross Scheduled Income:                                               $0.00 Equity paydown on loan after:                          10 Years                         #NUM!
           Annual Tax Depreciation                                           FALSE              (doesn't include down payment)
           Annual Taxable Income after Depreciation                          #DIV/0!            Cost to sell after                                   10 Years                                  $0.00
           Depreciation Recapture After 10 years                             #NAME?             Total Profit Earned after:                           10 Years                        #NAME?
           Estimated Capital GainsTax after 10 Years                                    $0.00 Total Profit Earned is the sum of Appreciation, Annual After-Tax Cash Flow, Equity Pay down and
                                                                                                assumes an the property is sold after E18 number or years. Assumes a fixed rate, monthly amortized
           PTCF Perfect Month- Net lease, Commercial/SFR. No Vacancy         #DIV/0!            mortgage with minimum monthly payments made. Estimated Sales costs are included, but capital
           PTCF Perfect Month- Multi-Family- WSG paid No Vacancy             #DIV/0!            gains and depreciation are not but should be analyzed if the intent is to cash out at the end of this
                                                                                                holding period vs. doing a 1031 exchange.


Internal Rate of Return (IRR) and Net Present Value (NPV):
Annual Cash Flows are After-Tax after appreciation. (IRR must have a least one positive cash flow)
Initial Investment Required:                        Cash flows increase by 0% each year.
                  AUTOFILL                                                    AUTOFILL                         AUTOFILL              AUTOFILL                  AUTOFILL
                                Planned Cap.                                                                             NPV                  NPV                    IRR
                                Improvments
                          $0.00 (Negative #)                           Final Cash Flow                   (Excel Calculation)
                                                                                                                          (HP10BII Calculation)         (Excel & HP10BII)
CF #1:           #NAME?                             1st Year                 #NAME?                        #NUM!                  #NUM!                        #NUM!
CF #2:           #NAME?                             2nd Year                 #NAME?                        #NUM!                      #NUM!                    #NUM!
CF #3:           #NAME?                             3rd Year                 #NAME?                        #NUM!                      #NUM!                    #NUM!
CF #4:           #NAME?                             4th Year                 #NAME?                        #NUM!                      #NUM!                    #NUM!
CF #5:           #NAME?                             5th Year                 #NAME?                        #NUM!                      #NUM!                    #NUM!
CF #6:           #NAME?                             6th Year                 #NAME?                        #NUM!                      #NUM!                    #NUM!
CF #7:           #NAME?                             7th Year                 #NAME?                        #NUM!                      #NUM!                    #NUM!
CF #8:           #NAME?                             8th Year                 #NAME?                        #NUM!                      #NUM!                    #NUM!
CF #9:           #NAME?                             9th Year                 #NAME?                        #NUM!                      #NUM!                    #NUM!
CF #10:          #NAME?                             10th Year                #NAME?                        #NUM!                      #NUM!                    #NUM!


Notes:
1. If IRR returns #NUM!, the IRR is to big of a negative percentage for that year. IRR is     HP10BII Conversion rate   84.53967791895890%
affected by the amount of down payment which can throw the numbers off.                                                   #NAME?
2. Due to Differences between Excel's NPV compared to an HP10BII Financial                                                #NUM!
Calculator's NPV, the conversion rate is listed to the right. (It is our determination that
HP10BII is a more accurate NPV.)
Mortgage Loan Payments

                      Enter Values                                            Loan Summary
                        Loan Amount         $0.00                          Scheduled Payment
                Annual Interest Rate      0.00 %                Scheduled Number of Payments
                Loan Period in Years            0                  Actual Number of Payments
        Number of Payments Per Year            12                         Total Early Payments
                   Start Date of Loan     1/1/2001                                Total Interest
            Optional Extra Payments

      Lender Name:


Pmt                       Beginning     Scheduled       Extra                                                  Ending     Cumulative
No.   Payment Date          Balance      Payment     Payment    Total Payment         Principal    Interest   Balance        Interest
                                                     #VALUE!         #VALUE!                                  #VALUE! $          -
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
                                                     #VALUE!         #VALUE!                                  #VALUE!           0.00
Pmt                  Beginning   Scheduled      Extra                                            Ending   Cumulative
No.   Payment Date     Balance    Payment    Payment    Total Payment   Principal   Interest    Balance      Interest
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
Pmt                  Beginning   Scheduled      Extra                                            Ending   Cumulative
No.   Payment Date     Balance    Payment    Payment    Total Payment   Principal   Interest    Balance      Interest
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
Pmt                  Beginning   Scheduled      Extra                                            Ending   Cumulative
No.   Payment Date     Balance    Payment    Payment    Total Payment   Principal   Interest    Balance      Interest
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
Pmt                  Beginning   Scheduled      Extra                                            Ending   Cumulative
No.   Payment Date     Balance    Payment    Payment    Total Payment   Principal   Interest    Balance      Interest
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
Pmt                  Beginning   Scheduled      Extra                                            Ending   Cumulative
No.   Payment Date     Balance    Payment    Payment    Total Payment   Principal   Interest    Balance      Interest
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
Pmt                  Beginning   Scheduled      Extra                                            Ending   Cumulative
No.   Payment Date     Balance    Payment    Payment    Total Payment   Principal   Interest    Balance      Interest
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
Pmt                  Beginning   Scheduled      Extra                                            Ending   Cumulative
No.   Payment Date     Balance    Payment    Payment    Total Payment   Principal   Interest    Balance      Interest
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
                                             #VALUE!          #VALUE!                          #VALUE!          0.00
Federal Income Tax Analysis
Based on the information input in 'Real Estate Investment' data sheet.

Adjusted Taxable Income:                                 $0.00
Annual expected rental income:                      #DIV/0!
Gross expected annual income:                       #DIV/0!
Annual Depreciation:                                FALSE
Net Annual Income after Depreciation                #DIV/0!

Tax for Adjusted Income (Single)                                                                Tax Rate Schedule for 2009 (Single)
                                               (2009 Tax Rate) (after Depreciation)                          Low Percentage              High
                                                   #DIV/0!            #DIV/0!                                0.00        10%        $8,350.00
                                                   #DIV/0!            #DIV/0!                            8,350.00        15%      $33,950.00
                                                   #DIV/0!            #DIV/0!                           33,950.00        25%      $82,250.00
                                                   #DIV/0!            #DIV/0!                           82,250.00        28% $171,550.00
                                                   #DIV/0!            #DIV/0!                          171,550.00        33% $372,950.00
                                                   #DIV/0!            #DIV/0!                          372,950.00        35%         Unlimited
Taxes Due on Annual Income:                        #DIV/0!            #DIV/0!
                                                                      #DIV/0!       Total Savings/Income From Property Depreciation

After Tax Monthly Cash Flow                        #DIV/0!               #DIV/0!
                                               w/o depreciation
Tax for Adjusted Income (Married)
                                               (2009 Tax Rate) (after Depreciation)             Tax Rate Schedule for 2009 (married)
                                                    #DIV/0!              #DIV/0!                                Low Percentage            High
                                                    #DIV/0!              #DIV/0!                              $0.00        10%      $16,700.00
                                                    #DIV/0!              #DIV/0!                         $16,700.00        15%      $67,900.00
                                                    #DIV/0!              #DIV/0!                         $67,900.00        25% $137,050.00
                                                    #DIV/0!              #DIV/0!                        $137,050.00        28% $208,850.00
                                                    #DIV/0!              #DIV/0!                        $208,850.00        33% $372,950.00
Taxes Due for adjusted Income:                      #DIV/0!              #DIV/0!                        $372,950.00        35%        Unlimited
                                                                         #DIV/0!      Total Savings/Income From Property Depreciation

After Tax Monthly Cash Flow                        #DIV/0!               #DIV/0!
                                               w/o depreciation
page 2 of Federal Tax Analysis
Tax for Adjusted Income (Married Separate)
                                 (2009 Tax Rate) (after Depreciation)             Tax Rate Schedule for 2009 (married separate)
                                     #DIV/0!            #DIV/0!                                   Low Percentage             High
                                     #DIV/0!            #DIV/0!                                 $0.00        10%        $8,350.00
                                     #DIV/0!            #DIV/0!                             $8,350.00        15%      $33,950.00
                                     #DIV/0!            #DIV/0!                            $33,950.00        25%      $68,525.00
                                     #DIV/0!            #DIV/0!                            $68,525.00        28% $104,425.00
                                     #DIV/0!            #DIV/0!                           $104,425.00        33% $186,475.00
Taxes Due for adjusted Income:       #DIV/0!            #DIV/0!                           $186,475.00        35%         unlimited
                                                        #DIV/0!         Total Savings/Income From Property Depreciation

After Tax Monthly Cash Flow          #DIV/0!            #DIV/0!




Tax for Adjusted Income Head of Household                                         Tax Rate Schedule for 2009 (Head of Household)
                                 (2009 Tax Rate) (after Depreciation)
                                     #DIV/0!            #DIV/0!                                 Low Percentage            High
                                     #DIV/0!            #DIV/0!                               $0.00        10%      $11,950.00
                                     #DIV/0!            #DIV/0!                          $11,950.00        15%      $45,500.00
                                     #DIV/0!            #DIV/0!                          $45,500.00        25% $117,450.00
                                     #DIV/0!            #DIV/0!                         $117,450.00        28% $190,200.00
                                     #DIV/0!            #DIV/0!                         $190,200.00        33% $372,950.00
Taxes Due for adjusted Income:       #DIV/0!            #DIV/0!                         $372,950.00        35%        Unlimited
                                                        #DIV/0!       Total Savings/Income From Property Depreciation

After Tax Monthly Cash Flow          #DIV/0!            #DIV/0!
09 (Single)




09 (married)
09 (married separate)




09 (Head of Household)

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:44
posted:5/17/2012
language:Hungarian
pages:14
fanzhongqing fanzhongqing http://
About