Deal Analysis

Deal Analyzer (Excel)

Use this Excel spreadsheet to determine your maximum offer on a property

This Excel spreadsheet template includes:

  • Cells to input key cost variables, including property values, pricing, transaction and finance costs, holding costs, repairs, and more
  • Ability to customize to your own profit margin tolerance
  • Functions to automatically calculate totals that “work backwards” to give you your initial offer amount.

TIP: Use the different sheets included in the workbook to play with different possible scenarios, e.g., lower/higher repair budgets, longer holding costs, etc., to work out your best case and worst case scenarios. This is also a used tool to compare multiple properties.

What’s inside:

Property Values & Pricing
Purchase Price
After Repair Value (ARV)
65% Rule – 65% of After Repair Value  $             –
Repair Costs – Bring over from repair spreadsheet
Maximum Allowable Offer (MAO) 65% of selling value minus the repair costs  $             –
Estimated holding time (input in number of months)
Purchase price + Repair Costs  $             –
Buying Transaction Costs
Escrow / Attorney Fees  $           –
Title Insurance / Search Costs  $           –
Miscellaneous Buying Costs
Total Buying Transaction Costs:  $           –
Financing Costs
First Mortgage / Lien Amount 65%  $             –
First Mortgage Points 2  $             –
First Mortgage Interest 10%  $             –
Misc. Mortgage / Lien Amount 15%  $             –
Misc. Mortgage Points 1  $             –
Misc. Mortgage Interest  $             –
Total Financing Costs During Holding Period:  $             –
Holding Costs
Property Taxes (Enter annual amount, total will reflect holding period)  $             –
HOA & Condo Fees (Enter annual amount, total will reflect holding period)  $         –  $             –
Insurance Costs (Enter annual amount, total will reflect holding period)  $             –
Utility Costs
     Gas (Enter annual amount, total will reflect holding period)  $             –
     Water (Enter annual amount, total will reflect holding period)  $             –
     Electricity (Enter annual amount, total will reflect holding period)  $             –
Total Holding Costs  $             –
Repairs
Repairs – Total brought over from repair spreadsheet  $             –
Total Repair Costs  $             –
Selling Transaction Costs
Escrow / Attorney Fees
Selling Recording Fees
Realtor Fees 3.00%  $             –
Home Warranty
Staging Costs
Marketing Costs
Miscellaneous Selling Costs  $             –
Total Selling Transaction Costs:  $             –
Investment Totals
Original purchase price  $             –
Buying Transaction Costs  $             –
Financing Costs  $             –
Holding Costs  $             –
Repairs  $             –
Selling Transaction Costs  $             –
Total Investment  $             –
Estimated Net Profit
After Repair Value  $             –
Estimated Net Profit  $             –
Total Costs Return on Investment (ROI) #DIV/0!

Filed under Deal Analysis, Operations

Keep reading

Keep going with Think

Tell us about yourself and we will write to you about the Think Loan Portal and what else Think can do for you.

Request access