Docstoc

House Flip Spreadsheet Worksheet

Document Sample
House Flip Spreadsheet Worksheet Powered By Docstoc
					     Use this spreadsheet to measure your proposed flip. Fields in yellow must
                             be estimated or assumed
P&L Worksheet
Property:


Purchase Price                                                                   Total Transaction Costs
Downpayment                                              0 10%                   Watch this number, it can kill your project!        3,575
Closing Costs                                        2,000
Initial Investment                                   2,000

Improvements                                               0

Sales prices                                                   **Check comps below
Closing costs                                        1,500
Commission @ X%                                          0       5%
Net Proceeds                                        -1,500
                                                                                 **Purchase rates are often higher than principal
                                                                                   residence purchases, check with your lender.
                                                                                     The balance of the funds are based on your
                                                                                         personal cost of funds or borrowing rate
                                                                                                                         capacity.

Carrying Costs:
   Financing - purchase               0                                          Carrying Cost Assumptions
   Financing repairs & downpayment 120                                                       Purchase Rate:      7.5%
   Property taxes                 1,200                                               Repair & downpay rate: 12.0%
   P&C Insurance                    250                                                P&C Insurance yearly:     $500
   Utilities                        300                                            Gas, Electric, Water / mo.     $50
                                                                                           Property tax / half: $1,200
Carrying costs                                           75                               Duration (months):       6

Profit/(Loss)                                       -3,575

Sales Price comps:                                             ** Ask your Realtor to assist with comparable sales




By: David Terbeek
Updated: 12/29/06                                                                                                                      www.DaveTrealestate.com
          This worksheet is for use when considering work
                      needed on a property
            Property: 0

Exterior                  Yes/No Estimate                   Comments
                                         Other Notes:

Roof
          Needed:
          Tear off:                                     0

Exterior walls
       Paint:
       New siding:

Garage
      Structure:
      Roof:

Driveway
      Fix:
      Replace:

Landscape
          Estimate:


Systems                   Yes/No Estimate                   Comments
Furnace
Hot water
Windows

Plumbing
          Age
          Status

Electrical
        Age
        Status



Interior                  Yes/No Estimate                   Comments
Basement
       Re-finish
       Finish

Carpet (overall)
      Sqr ft

Bedrooms
          Paint
          Trim

Bath
          Fixtures
          Floor/walls

Kitchen
          Cabinets
          Walls
          Floor
          Appliances
          Sink

          Total Improvements                            0




By: David Terbeek
Updated: 12/29/06                                                      www.DaveTrealestate.com
   Use this worksheet to value a lease option deal. As the
 example shows, it may still be profitable when there is a net
                         montly loss.



Cash out                                1         2         3       4      5      6      7      8      9     10     11     12     13     14     15     16       17       18
         P&I, Tax, Insurance         -800      -800      -800    -800   -800   -800   -800   -800   -800   -800   -800   -800   -800   -800   -800   -800     -800     -800
         2nd source financing        -110      -110      -110    -110   -110   -110   -110   -110   -110   -110   -110   -110   -110   -110   -110   -110     -110     -110
         Appliances                  -800         0         0       0      0      0      0      0      0      0      0      0      0      0      0      0        0        0
         O Fee + Credits                0         0         0       0      0      0      0      0      0      0      0      0      0      0      0      0        0    -5400
         payoff loan                                                                                                                                                 -95000
Cash In
         Rent                        900        900       900    900    900    900    900    900    900    900    900    900    900    900    900    900      900   900
         Option Fee                 1800          0         0      0      0      0      0      0      0      0      0      0      0      0      0      0        0     0
         Sale (net closing)            0          0         0      0      0      0      0      0      0      0      0      0      0      0      0      0        0 1E+05
Net                                  990        -10       -10    -10    -10    -10    -10    -10    -10    -10    -10    -10    -10    -10    -10    -10      -10 9590
         Rent Credit                 200        200       200    200    200    200    200    200    200    200    200    200    200    200    200    200      200   200

NPV=        $9,093.16
 10% Cost of capital

         Example:
         Rent = 900
         Rent Credit = 200
         Option fee = 1800
         Sales price = 110,000




By: David Terbeek
Updated: 12/29/06                                                                                                                                       www.DaveTrealestate.com

				
DOCUMENT INFO
Description: House Flip Spreadsheet Worksheet document sample