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