| A | B | C | D | E | |
|---|---|---|---|---|---|
1 | FLIP CALCULATOR | ||||
2 | Everything in yellow must be entered. Everything in red and blue will auto fill. | ||||
3 | ARV AMOUNT | $350,000 | |||
4 | PROPERTY COSTS | ||||
5 | REHAB COSTS | $75,000 | |||
6 | SALES COMMISSIONS | 2.5% | $8,750 | ||
7 | LISTING COMMISSIONS | FLAT | $1,500 | ||
8 | CLOSING COSTS | 3% | $10,500 | ||
9 | UTILITIES, TAXES, INSURANCE | $2,625 | |||
10 | ESTIMATED HOA COST | $0 | |||
11 | TOTAL PROPERTY COSTS | $98,375 | |||
12 | |||||
13 | MONEY COSTS | LOAN AMOUNT | $240,000 | ||
14 | INTEREST RATE | 12.0% | $28,800 | ||
15 | POINTS | 0% | $0 | ||
16 | MONTHLY PAYMENT | $2,400 | |||
17 | HOLD TIME (MONTHS) | 3 | $7,200 | ||
18 | TOTAL MONEY COST | $7,200 | |||
19 | |||||
20 | TOTAL COSTS | ARV AMOUNT | $350,000 | ||
21 | PROPERTY AND MONEY COSTS | $105,575 | |||
22 | BREAK EVEN AMOUNT PURCHASE $ | $244,425 | |||
23 | MINIMUM PROFIT AMOUNT | $52,500 | < 15% Profit (Change as needed) | ||
24 | |||||
25 | MAX OFFER | $191,925 | |||
26 | |||||
27 | |||||
28 | |||||
29 | PURCHASE PRICE | $165,000 | |||
30 | PROJECTED PROFIT | $79,425 | |||