4811 Tealgate Analysis - 10 percent down

Property Information   Expense Information  
Address: 4811 Tealgate Dr    
After Rehab Value: $95,000 Management Fee (%): 0.00%
Purchase Price: $90,000 Annual Maintenance:  $                              -  
Estimated Rehab costs: $0 Vacancy Rate: 0%
Seller Contribution: $0.00 Pest Control  $                              -  
Base Costs $90,000
Estimated spread after rehab $5,000 Refi Information  
Spread %: 94.74%    
    Initial Purchase Price  $                              -  
Yearly Taxes: $2,719 Current Debt  $                              -  
Yearly HOA: $270 Current Equity 0%
Yearly Rental Insurance: $700 Target Equity 0%
Monthly Lease Amount: $995 Equity Cash Out  $                              -  
Target Appreciation: 50% Initial Investment  $                              -  
Target Sale Price: $142,500 Cash Invested After Refi $0.00
Financing Options   Prin.+Int. Int. Only Deferred Int.  
           
% Down Payment 10% $9,000 $9,000 $18,000  
1st Mortgage Amnt   $81,000 $81,000 $72,000  
Interest Rate   6.750% 7.000% 1.400% 7.90% <-- Annual Rate
Term (years)   30 10 40  
Monthly Payment   $525.36 $472.50 $195.98 $495.23
           
           
2nd Mortgage Amnt    $                            -    $                             -    $                              -    
Interest Rate   7.0000% 7.0000% 7.0000%  
Term          
Monthly Payment   $0.00 $0.00 $0.00  
Total Payment   $525.36 $472.50 $195.98  
Closing Costs Estimate---> Prin. + Int. Int. Only Deferred Int. Cash Purchase
Origination Fee %: Enter % 1.0% 1.0% 1.0%  
Origination Fees: Auto Fill $810 $810 $720  
Other Title Costs: Escrow fee, etc. $350 $350 $350 $350
Title Policy -Owner: includes mortgage policy if needed $225 $225 $225 $0
Doc & Closing Costs: depends on lender $1,250 $1,250 $500 $250
Mortgage Insurance: .7% Mtg if DP>10%, .9% Mtg if DP<10% $47.25 $47.25 $0.00  
Survey, Appraisal & Inspection: 375, 400, 200 $775 $775 $775 $375
Totals   $3,457 $3,457 $2,570 $975
Controlling Factors Property Information 4811 Tealgate Dr
Annual Rent Increases 5.00% Purchase Price $90,000.00
Annual Property Tax Change 2.00% Price + Rehab $90,000.00
Annual Appreciation Change 5.00% Market Value $95,000.00
Hold Term (years) 4 Target Resale Price $142,500.00
Expense Information Year 1 Year 2 Year 3 Year 4
Monthly Annual Monthly Annual Monthly Annual Monthly Annual
  Taxes $227 $2,719 $231 $2,773 $236 $2,829 $240 $2,885
  Insurance $58 $700 $58 $700 $58 $700 $58 $700
  Lawn service 0 $0 0 $0 0 $0 0 $0
  Maintenance $0.00 $0 $0.00 $0 $0.00 $0 $0.00 $0
  Water $0 $0 $0 $0 $0 $0 $0 $0
  Pest control $0 $0 $0 $0 $0 $0 $0 $0
  Lease fee $0.00 $0 $0.00 $0 $0.00 $0 $0.00 $0
  Management fee $0.00 $0 $0.00 $0 $0.00 $0 $0.00 $0
HOA Dues $23 $270 $23 $270 $23 $270 $23 $270
Total Expenses: $307 $3,689 $312 $3,743 $317 $3,799 $321 $3,855
Income Information
  Base Rent $995.00 $11,940 $1,044.75 $12,537.00 $1,096.99 $13,163.85 $1,151.84 $13,822.04
  Vacancy Allowance (%) 0.0% $0 $0 $0 $0 $0 $0 $0 $0
  Other Income $0 $0 $0 $0 $0 $0 $0 $0
Scheduled Gross Income $995 $11,940 $1,044.75 $12,537.00 $1,096.99 $13,163.85 $1,151.84 $13,822.04
NOI $8,251 $8,794 $9,365 $9,967
Investment Summary   Principle & Interest    Interest Only   Deferred Interest  
    6.750%     7.000%     7.90%    
Total Capital Invested       $12,457.25     $12,457.25     $20,570.00  
Borrowed Capital        $          -        $             -        $              -    
Financing     Monthly Annual   Monthly Annual   Monthly Annual  
Payments     $525.36 $6,304.37   $472.50 $5,670.00   $195.98 $2,351.82  
  Mortgage Insurance (monthly) [PMI]     $47.25 $567   $47.25 $567   $0.00 $0  
Total Payments     $572.61 $6,871   $519.75 $6,237   $195.98 $2,352  
PITI     $880.03 $10,560.37   $827.17 $9,926.00   $503.40 $6,040.82  
                     
Total Expenses     $307 $3,689   $307 $3,689   $307 $3,689  
Total Income     $995 $11,940   $995 $11,940   $995 $11,940  
                     
Net Profit (Loss)     $115 $1,380   $168 $2,014   $492 $5,899  
Return on Capital (Year 1)       11.075%     16.167%     28.679%  
Principle Reduction       $3,967.22              
Return on Equity Line       #DIV/0!     #DIV/0!     #DIV/0!  
Deferred Interest                   $18,704.99  
Debt  to Income       118%     111%     67%  
                     
Net Income By Year   Year:   Net Inc. Year:   Net Inc. Year:   Net Inc.  
  1   $1,380 1   $2,014 1   $5,899  
  2   $1,922.25 2   $2,556.62 2   $6,441.80  
  3   $2,493.63 3   $3,128.00 3   $7,013.18  
  4   $3,095.24 4   $3,729.62 4   $7,614.80  
                     
Profit Margin By Year   Year:   Net Inc. Year:   Net Inc. Year:   Net Inc.  
(Net Income / Gross Revenue)   1   12% 1   17% 1   49%  
  2   15% 2   20% 2   51%  
  3   19% 3   24% 3   53%  
  4   22% 4   27% 4   55%  
Loan Amortization Schedule                       Deferred Interest Schedule
  Principle   Interest         Principle   Interest   Principle   Interest Interest Deferred
Principle Payment @ yr (est.) Year: Pd.   Pd.       Year: Pd.   Pd. Year: Pd.   Pd.
  (Annualized) 1 $896.84 E $5,407.53       1 $1,355.05 E $996.77 1 $285.34 E $5,678.57 $4,681.80
2 $957.38   $5,346.99       2 $1,374.02   $977.80 2 $307.88   $5,656.93 $4,679.13
3 $1,022.00   $5,282.37       3 $1,393.25   $958.57 3 $332.20   $5,633.51 $4,674.95
4 $1,090.99   $5,213.38       4 $1,412.76   $939.06 4 $358.45   $5,608.18 $4,669.12
5 $1,164.63   $5,139.74       5 $1,432.54   $919.28 5 $386.76   $5,580.77 $4,661.49
Investment Return                      
Property Value    $114,000.00          $114,000.00      $ 114,000.00  
Remaining Principle   -$77,032.78         -$81,000.00     -$72,000.00  
Interest Deferred                   $18,704.99  
Equity    $ 36,967.22          $ 33,000.00      $  23,295.01  
                     
Equity Return on Capital Invested   297%         265%     113%  
Equity Return on Borrowed Capital   #DIV/0!         #DIV/0!        
Net Profit from Rents   $11,159         $13,696     $26,969  
Rent Return on Capital Invested   90%         110%     131.11%  
                     
Gross Profit from Investment    $  48,125.97          $  46,696.24      $  50,263.98  
Gross Return on Capital Invested   386%         375%     244.36%  
                     
Schedule of Net Income  Cash Invested ($12,457.25)       Cash Invested ($12,457.25)   Cash Invested ($20,570.00)  
Year 1 $1,380       Year 1 $2,014   Year 1 $5,899  
Year 2 $1,922.25       Year 2 $2,556.62   Year 2 $6,441.80  
Year 3 $2,493.63       Year 3 $3,128.00   Year 3 $7,013.18  
Year 4 $3,095.24       Year 4 $3,729.62   Year 4 $7,614.80  
Equity $36,967.22       Equity $33,000.00   Equity $23,295.01  
IRR of Investment over 4 Years   35%         36%     30%  
Using Equity, Yearly Net Income and Property Appreciation