| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | Rockford | HAKP Offer | 30 yrs | 15 yrs | |||||
2 | Acres | 124 | |||||||
3 | Price/Acre | $40,000 | $50,000 | $58,089 | $46,799 | ||||
4 | Total | 4,960,000 | $6,200,000 | $7,203,036 | $5,803,058 | ||||
5 | Brokerage | 3% | (148,800) | 0 | 0 | 0 | |||
6 | Net | 4,811,200 | $6,200,000 | $7,203,036 | $5,803,058 | ||||
7 | |||||||||
8 | Term (yrs) | 30 | 30 | 15 | |||||
9 | Annual | $206,667 | $240,101 | $386,871 | |||||
10 | Rate | 2.83% | 2.83% | 2.44% | |||||
11 | PV | $4,811,200 | $4,141,240 | $4,811,210 | $4,811,200 | ||||
12 | |||||||||
13 | per acre | $38,800 | $33,397 | $38,800 | $38,800 | ||||
14 | Difference | ($5,403) | $0 | $0 | |||||
15 | |||||||||
16 | |||||||||
17 | |||||||||
18 | |||||||||
19 | |||||||||
20 |