Skip to content
×
Try PRO Free Today!
BiggerPockets Pro offers you a comprehensive suite of tools and resources
Market and Deal Finder Tools
Deal Analysis Calculators
Property Management Software
Exclusive discounts to Home Depot, RentRedi, and more
$0
7 days free
$828/yr or $69/mo when billed monthly.
$390/yr or $32.5/mo when billed annually.
7 days free. Cancel anytime.
Already a Pro Member? Sign in here

Join Over 3 Million Real Estate Investors

Create a free BiggerPockets account to comment, participate, and connect with over 3 million real estate investors.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
The community here is like my own little personal real estate army that I can depend upon to help me through ANY problems I come across.
Starting Out
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

Updated almost 5 years ago on . Most recent reply

User Stats

32
Posts
13
Votes
QuoVadis Gates
  • Investor
  • Chicago, IL
13
Votes |
32
Posts

30 day Analyzing Deal Challenge

QuoVadis Gates
  • Investor
  • Chicago, IL
Posted

Brandon Turner @BrandonTurner consistently ask of us listeners of PB podcast and webinars to Analysis deal, so for the next 30 consecutive days I'm going to analyze deals by hand to brush up and become well rounded in my investment pursuits. 

{I've invested without running numbers in the past, it wasn't the best of my decisions.} 

Here is a long hand template that I'll use:

= Analyze Deals:

  • Identify:
    • Property
    • Price:
      • Acquire:
        • Down Payment
        • Closing Cost
        • Loan
        • Transfer Stamps
      • Taxes:
      • Rehab Estimate:
      • After repair value:
    • Income:
      • Monthly Gross:
        • Rent
        • Parking
        • Washer/ Dryer
        • Storage
        • Advertising
    • Expenses: {Fixed}
      • Taxes
      • Electricity
      • Water & Sewer
      • PMI
      • Garbage
      • HOA's
      • Insurance {$100}
    • Expenses: {Variable}
      • Vacancy {5-10%}
      • Repairs and Maintenance {8%}
      • Cap Ex - {Capital Expenditures} {8%}
      • Management {10%}

{Optional}

    • Future Assumptions:
      • Annual Income Growth: {2%}
      • Annual PV Growth: {2%}
      • Annual Expenses Growth: {2%}
      • Sales Expenses: {9%}

Totals:

  • Monthly Expenses:
  • Monthly Cash Flow:
  • Monthly Income:
  • ______________
  • Total Cash Needed:
  • Cash On Cash Return:
  • ROI:
  • Cap Rate:

Most Popular Reply

User Stats

280
Posts
365
Votes
Erin Dorsey Robinson
  • Real Estate Agent
  • Cleveland, OH
365
Votes |
280
Posts
Erin Dorsey Robinson
  • Real Estate Agent
  • Cleveland, OH
Replied

By hand? Admirable! But why? My dad always says time is our greatest asset and we don't know how much of it we even have. Don't know if he made that up or not, full disclosure lol!

I have a really good spreadsheet I could share with you just in case you decide you'd rather spend that time polishing up some other skill that's not as easily automated. In either case, kudos to you for challenging yourself!

  • Erin Dorsey Robinson
  • [email protected]
  • Loading replies...