The Total Cost and Benefits Calculator
?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Expense Categories
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Quickly
determine the total net financial benefit of owning any property over a
selected number of years
|
|
|
Loan Amount =
|
|
|
P&I Payment =
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Interest Only Option
|
|
|
|
|
|
|
|
|
|
|
|
|
Property Reference
|
|
|
|
|
|
|
|
|
|
Real
Estate Tax Table
|
|
|
Maintenance Cost Table
|
|
|
|
|
Insurance
Cost Table
|
|
|
|
Loan Parameter Table
|
|
|
|
Interest
Only Loan Interest
|
|
Amortizing
Loan Interest
|
|
Interest
Table on Selected Loan
|
|
Condo or Coop Fees
|
|
|
Deductible
Portion of Condo or Coop Fees
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Lists
|
|
Year
|
R.E. Taxes
|
Increase
|
Cumulative
|
|
Year
|
Annual Cost
|
Inflation
|
Increase
|
Cumulative
|
|
Year
|
Annual
|
Inflation
|
Increase
|
Cumulative
|
|
Year
|
IO true/false
|
Start
|
Finish
|
Rate
|
Term
|
Loan Amount
|
|
Year
|
Yearly Interest
|
Accrued Int.
|
|
Year
|
Annual
|
Accrued Int.
|
|
Year
|
Annual Int. on
|
Accrued Int. on
|
|
Year
|
Inflation
|
Monthly
|
Yearly with
|
Accrued with
|
|
Year
|
Deductible
|
Deductible
|
Yearly
|
Accrued
|
|
|
|
Enter and Select the
Property Information and Settings
|
|
|
|
|
|
|
|
|
|
|
Years
|
State List
|
DP %
|
Months
|
Percentage
|
Values
|
Costs %
|
Term
|
Rates
|
Tax Bracket
|
Taxes
|
Ins factor
|
Condo fee
|
PMI
|
Rent
|
|
|
|
Expense
|
|
|
|
Rate
|
|
|
|
|
Cost
|
Rate
|
|
Cost
|
|
|
|
Month
|
Month
|
|
|
|
|
|
Interest Only
|
Interest Only
|
|
|
Interest
|
Amortizing
|
|
|
Selected Loan
|
Selected Loan
|
|
|
Rate
|
Cost
|
Inflation
|
Inflation
|
|
|
%
|
Cost
|
Deductible
|
Deductible
|
|
|
|
Property Sale Price or Value
|
|
|
|
Annual
|
|
|
|
|
New Relays
|
|
|
|
|
|
Appreciation
|
|
|
|
Total benefits
|
|
|
|
1
|
AK 5.24%
|
0.00%
|
|
1.00%
|
$ -
|
0.0000
|
5
|
1.000%
|
0%
|
$
1,000
|
0
|
$
-
|
0
|
$
-
|
|
1
|
|
|
$ 2,250.00
|
|
1
|
|
|
|
$ 750.00
|
|
1
|
|
|
|
$540
|
|
1
|
|
1
|
12
|
|
|
|
|
1
|
|
|
|
1
|
|
$5,357
|
|
1
|
|
|
|
1
|
|
|
|
$1,200
|
|
1
|
|
|
|
|
|
|
|
Current Real Estate Taxes
|
|
|
|
|
|
|
|
|
Lost Opportunity
|
|
|
|
Tax Savings/R.E. Taxes
|
|
|
Total Costs
|
|
|
|
2
|
AL 4.69%
|
3.00%
|
|
2.00%
|
$ 5,000
|
0.0050
|
10
|
1.250%
|
5%
|
$ 1,500
|
0.1
|
$ 50
|
0.19
|
$ 300
|
|
2
|
|
|
$ 4,545.00
|
|
2
|
|
|
|
$ 1,515.00
|
|
2
|
|
|
|
$1,091
|
|
2
|
|
|
|
|
|
|
|
2
|
|
|
|
2
|
|
$10,617
|
|
2
|
|
|
|
2
|
|
|
|
$2,424
|
|
2
|
|
|
|
|
|
|
|
Homeowners Insurance Factor
|
|
|
|
|
|
|
|
|
annual Condo/Coop
|
|
|
Insurance
|
|
|
|
Tax Savings/ Interest
|
|
|
Net Benefit
|
|
|
|
3
|
AR 4.81%
|
5.00%
|
|
3.00%
|
$ 10,000
|
0.0100
|
15
|
1.500%
|
10%
|
$ 2,000
|
0.2
|
$ 100
|
0.21
|
$ 350
|
|
3
|
|
|
$ 6,885.00
|
|
3
|
|
|
|
$ 2,295.00
|
|
3
|
|
|
|
$1,652
|
|
3
|
|
|
|
|
|
|
|
3
|
|
|
|
3
|
|
$15,776
|
|
3
|
|
|
|
3
|
|
|
|
$3,672
|
|
3
|
|
|
|
|
|
|
|
Annual Maintenance Expense Factor
|
|
|
|
|
|
|
|
|
PMI'
|
|
|
|
Maintenance
|
|
|
|
Tax Savings/Condo Fee
|
|
|
|
|
4
|
AZ 6.99%
|
10.00%
|
|
4.00%
|
$ 15,000
|
0.0150
|
20
|
2.000%
|
15%
|
$ 2,500
|
0.3
|
$ 150
|
0.22
|
$ 400
|
|
4
|
|
|
$ 9,271.80
|
|
4
|
|
|
|
$ 3,090.30
|
|
4
|
|
|
|
$2,225
|
|
4
|
|
|
|
|
|
|
|
4
|
|
|
|
4
|
|
$20,830
|
|
4
|
|
|
|
4
|
|
|
|
$4,946
|
|
4
|
|
|
|
|
|
|
|
Condo or Coop Fee
|
Tax Deductible %
|
|
|
|
|
|
Closing Costs
|
|
|
|
Condo/Coop Fees
|
|
|
|
Housing Value
|
|
|
|
|
|
5
|
CA 9.25%
|
15.00%
|
|
5.00%
|
$ 20,000
|
0.0200
|
25
|
2.500%
|
20%
|
$ 3,000
|
0.4
|
$ 200
|
0.23
|
$ 450
|
|
5
|
|
|
$ 11,706.34
|
|
5
|
|
|
|
$ 3,901.20
|
|
5
|
|
|
|
$2,809
|
|
5
|
|
|
|
|
|
|
|
5
|
|
|
|
5
|
|
$25,775
|
|
5
|
|
|
|
5
|
|
|
|
$6,245
|
|
5
|
|
|
|
|
|
|
|
Other Monthly Expenses (check box if expense will increase over time)
|
FALSE
|
|
|
|
|
|
|
Annual IO Value
|
|
|
Other Expenses
|
|
|
|
|
|
6
|
CO 6.42%
|
20.00%
|
|
6.00%
|
$ 25,000
|
0.0250
|
30
|
3.000%
|
25%
|
$ 3,500
|
0.5
|
$ 250
|
0.32
|
$ 500
|
|
6
|
|
|
$ 14,189.56
|
|
6
|
|
|
|
$ 4,728.01
|
|
6
|
|
|
|
$3,404
|
|
6
|
|
|
|
|
|
|
|
6
|
|
|
|
6
|
|
$30,606
|
|
6
|
|
|
|
6
|
|
|
|
$7,570
|
|
6
|
|
|
|
|
|
|
|
Housing Value / Monthly Rent Saved
|
|
|
|
|
|
|
|
|
Interest Rate
|
|
|
|
PMI/MIP
|
|
|
|
|
|
|
7
|
CT 7.10%
|
25.00%
|
|
7.00%
|
$ 30,000
|
0.0300
|
40
|
4.000%
|
28%
|
$ 4,000
|
0.6
|
$ 300
|
0.33
|
$ 600
|
|
7
|
|
|
$ 16,722.45
|
|
7
|
|
|
|
$ 5,571.03
|
|
7
|
|
|
|
$4,011
|
|
7
|
|
|
|
|
|
|
|
7
|
|
|
|
7
|
|
$35,319
|
|
7
|
|
|
|
7
|
|
|
|
$8,921
|
|
7
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Annual Taxes
|
|
|
|
Cost of Sale
|
|
|
|
Cash Invested Graph
|
|
|
8
|
DC 8.48%
|
30.00%
|
|
8.00%
|
$ 35,000
|
0.0350
|
50
|
4.125%
|
30%
|
$ 4,500
|
0.7
|
$ 350
|
0.37
|
$ 700
|
|
8
|
|
|
$ 19,306.00
|
|
8
|
|
|
|
$ 6,430.59
|
|
8
|
|
|
|
$4,630
|
|
8
|
|
|
|
|
|
|
|
8
|
|
|
|
8
|
|
$39,909
|
|
8
|
|
|
|
8
|
|
|
|
$10,300
|
|
8
|
|
|
|
|
|
|
|
Enter and Select the
Loan Information and Settings
|
|
|
|
|
|
|
R.E. Taxes
|
|
|
|
down payment
|
|
|
|
9
|
DE 6.63%
|
35.00%
|
|
9.00%
|
$ 40,000
|
0.0400
|
|
4.250%
|
33%
|
$ 5,000
|
0.8
|
$ 400
|
0.41
|
$ 800
|
|
9
|
|
|
$ 21,941.22
|
|
9
|
|
|
|
$ 7,307.01
|
|
9
|
|
|
|
$5,261
|
|
9
|
|
|
|
|
|
|
|
9
|
|
|
|
9
|
|
$44,371
|
|
9
|
|
|
|
9
|
|
|
|
$11,706
|
|
9
|
|
|
|
|
|
|
|
Down Payment
|
|
|
|
|
|
|
|
|
Interest
|
|
|
|
Closing Costs
|
|
|
|
10
|
FL 6.73%
|
40.00%
|
|
10.00%
|
$ 45,000
|
0.0450
|
|
4.375%
|
35%
|
$ 5,500
|
0.9
|
$ 450
|
0.52
|
$ 900
|
|
10
|
|
|
$ 24,629.15
|
|
10
|
|
|
|
$ 8,200.62
|
|
10
|
|
|
|
$5,904
|
|
10
|
|
|
|
|
|
|
|
10
|
|
|
|
10
|
|
$48,700
|
|
10
|
|
|
|
10
|
|
|
|
$13,140
|
|
10
|
|
|
|
|
|
|
|
Term & Loan Amount
|
|
|
|
|
|
|
|
|
Total =
|
|
|
|
11
|
GA 5.02%
|
45.00%
|
|
11.00%
|
$ 50,000
|
0.0500
|
|
4.500%
|
36%
|
$ 6,000
|
1
|
$ 500
|
0.54
|
$ 1,000
|
|
11
|
|
|
$ 27,370.83
|
|
11
|
|
|
|
$ 9,111.76
|
|
11
|
|
|
|
$6,560
|
|
11
|
|
|
|
|
|
|
|
11
|
|
|
|
11
|
|
$52,889
|
|
11
|
|
|
|
11
|
|
|
|
$14,602
|
|
11
|
|
|
|
|
|
|
|
Rate & Payment (check box for
interest only)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
12
|
HI 9.21%
|
50.00%
|
|
12.00%
|
$ 75,000
|
0.0550
|
|
4.625%
|
38%
|
$ 6,500
|
1.1
|
$ 550
|
0.56
|
$ 1,200
|
|
12
|
|
|
$ 30,167.35
|
|
12
|
|
|
|
$ 10,040.78
|
|
12
|
|
|
|
$7,229
|
|
12
|
|
|
|
|
|
|
|
12
|
|
|
|
12
|
|
$56,935
|
|
12
|
|
|
|
12
|
|
|
|
$16,095
|
|
12
|
|
|
|
|
|
|
|
Interest Only Savings (check box if
investing this)
|
|
|
|
|
|
|
|
|
|
|
|
Pre-Paid
Expense Calculation
|
|
|
|
|
|
|
13
|
IA 4.46%
|
55.00%
|
|
13.00%
|
$ 100,000
|
0.0600
|
|
4.750%
|
40%
|
$ 7,000
|
1.2
|
$ 600
|
0.61
|
$ 1,500
|
|
13
|
|
|
$ 33,019.79
|
|
13
|
|
|
|
$ 10,988.01
|
|
13
|
|
|
|
$7,911
|
|
13
|
|
|
|
|
|
|
|
13
|
|
|
|
13
|
|
$60,830
|
|
13
|
|
|
|
13
|
|
|
|
$17,616
|
|
13
|
|
|
|
|
|
|
|
Private Mortgage
Insurance (typically only required with less than a 20%
downpayment)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Periodic
|
|
Due at Closing
|
|
|
|
|
|
14
|
ID 5.68%
|
60.00%
|
|
14.00%
|
$ 125,000
|
0.0650
|
|
4.875%
|
45%
|
$ 7,500
|
1.3
|
$ 650
|
0.65
|
$ 1,800
|
|
14
|
|
|
$ 35,929.29
|
|
14
|
|
|
|
$ 11,953.83
|
|
14
|
|
|
|
$8,607
|
|
14
|
|
|
|
|
|
|
|
14
|
|
|
|
14
|
|
$64,569
|
|
14
|
|
|
|
14
|
|
|
|
$19,169
|
|
14
|
|
|
|
|
|
|
|
Closing Costs
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
15
|
IL 5.74%
|
65.00%
|
|
15.00%
|
$ 150,000
|
0.0700
|
|
5.000%
|
50%
|
$ 8,000
|
1.4
|
$ 700
|
0.67
|
$ 2,000
|
|
15
|
|
|
$ 38,896.98
|
|
15
|
|
|
|
$ 12,938.59
|
|
15
|
|
|
|
$9,316
|
|
15
|
|
|
|
|
|
|
|
15
|
|
|
|
15
|
|
$68,145
|
|
15
|
|
|
|
15
|
|
|
|
$20,752
|
|
15
|
|
|
|
|
|
|
|
Total Initial Cash Investment =
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Monthly Insurance Cost
|
|
|
|
|
|
|
16
|
IN 4.64%
|
70.00%
|
|
16.00%
|
$ 175,000
|
0.0750
|
|
5.125%
|
|
$ 8,500
|
1.5
|
$ 750
|
0.77
|
$ 2,500
|
|
16
|
|
|
$ 41,924.02
|
|
16
|
|
|
|
$ 13,942.66
|
|
16
|
|
|
|
$10,039
|
|
16
|
|
|
|
|
|
|
|
16
|
|
|
|
16
|
|
$71,551
|
|
16
|
|
|
|
16
|
|
|
|
$22,367
|
|
16
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Insurance @
|
|
Months
|
|
|
|
|
|
|
|
|
17
|
KS 4.34%
|
75.00%
|
|
17.00%
|
$ 200,000
|
0.0800
|
|
5.250%
|
|
$ 9,000
|
1.6
|
$ 800
|
0.78
|
$ 3,000
|
|
17
|
|
|
$ 45,011.60
|
|
17
|
|
|
|
$ 14,966.43
|
|
17
|
|
|
|
$10,776
|
|
17
|
|
|
|
|
|
|
|
17
|
|
|
|
17
|
|
$74,781
|
|
17
|
|
|
|
17
|
|
|
|
$24,014
|
|
17
|
|
|
|
|
|
|
|
Enter and Select the
Financial Settings
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
18
|
KY 4.87%
|
|
|
18.00%
|
$ 225,000
|
|
|
5.375%
|
|
$ 9,500
|
1.7
|
$ 850
|
0.8
|
$ 3,500
|
|
18
|
|
|
$ 48,160.93
|
|
18
|
|
|
|
$ 16,010.29
|
|
18
|
|
|
|
$11,527
|
|
18
|
|
|
|
|
|
|
|
18
|
|
|
|
18
|
|
$77,828
|
|
18
|
|
|
|
18
|
|
|
|
$25,695
|
|
18
|
|
|
|
|
|
|
|
Inflation Rate
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Daily Interest Expense
|
|
|
|
|
|
|
|
19
|
LA 4.96%
|
|
|
19.00%
|
$ 250,000
|
|
|
5.500%
|
|
$ 10,000
|
1.8
|
$ 900
|
0.81
|
$ 4,000
|
|
19
|
|
|
$ 51,373.25
|
|
19
|
|
|
|
$ 17,074.62
|
|
19
|
|
|
|
$12,294
|
|
19
|
|
|
|
|
|
|
|
19
|
|
|
|
19
|
|
$80,684
|
|
19
|
|
|
|
19
|
|
|
|
$27,409
|
|
19
|
|
|
|
|
|
|
|
Marginal Tax Bracket
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Per Diem @
|
|
Days
|
|
|
|
|
|
|
20
|
MA 8.17%
|
|
|
20.00%
|
$ 275,000
|
|
|
5.625%
|
|
$ 10,500
|
1.9
|
$ 950
|
0.85
|
$ 5,000
|
|
20
|
|
|
$ 54,649.81
|
|
20
|
|
|
|
$ 18,159.82
|
|
20
|
|
|
|
$13,075
|
|
20
|
|
|
|
|
|
|
|
20
|
|
|
|
20
|
|
$83,341
|
|
20
|
|
|
|
20
|
|
|
|
$29,157
|
|
20
|
|
|
|
|
|
|
|
Lost Opportunity Rate
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
21
|
MD 7.10%
|
|
|
|
$ 300,000
|
|
|
5.750%
|
|
$ 11,000
|
2
|
$ 1,000
|
0.88
|
$ 6,000
|
|
21
|
|
|
$ 57,991.91
|
|
21
|
|
|
|
$ 19,266.31
|
|
21
|
|
|
|
$13,872
|
|
21
|
|
|
|
|
|
|
|
21
|
|
|
|
21
|
|
$85,791
|
|
21
|
|
|
|
21
|
|
|
|
$30,940
|
|
21
|
|
|
|
|
|
|
|
Alternative Investment Rate
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Monthly Real Estate
Taxes
|
|
|
|
|
|
|
22
|
ME 6.76%
|
|
|
|
$ 325,000
|
|
|
5.875%
|
|
$ 11,500
|
2.1
|
$ 1,050
|
0.92
|
$ 7,000
|
|
22
|
|
|
$ 61,400.85
|
|
22
|
|
|
|
$ 20,394.51
|
|
22
|
|
|
|
$14,684
|
|
22
|
|
|
|
|
|
|
|
22
|
|
|
|
22
|
|
$88,026
|
|
22
|
|
|
|
22
|
|
|
|
$32,759
|
|
22
|
|
|
|
|
|
|
|
Expected Appreciation
|
Lookup List
|
|
|
|
|
|
|
|
|
|
|
|
Taxes @
|
|
Months
|
|
|
|
|
|
|
23
|
MI 5.62%
|
|
|
|
$ 350,000
|
|
|
6.000%
|
|
$ 12,000
|
2.2
|
$ 1,100
|
0.96
|
$ 8,000
|
|
23
|
|
|
$ 64,877.96
|
|
23
|
|
|
|
$ 21,544.84
|
|
23
|
|
|
|
$15,512
|
|
23
|
|
|
|
|
|
|
|
23
|
|
|
|
23
|
|
$90,037
|
|
23
|
|
|
|
23
|
|
|
|
$34,614
|
|
23
|
|
|
|
|
|
|
|
Cost of Future Sale
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
24
|
MN 5.95%
|
|
|
|
$ 375,000
|
|
|
6.125%
|
|
$ 12,500
|
2.3
|
$ 1,150
|
1.06
|
$ 9,000
|
|
24
|
|
|
$ 68,424.62
|
|
24
|
|
|
|
$ 22,717.73
|
|
24
|
|
|
|
$16,357
|
|
24
|
|
|
|
|
|
|
|
24
|
|
|
|
24
|
|
$91,815
|
|
24
|
|
|
|
24
|
|
|
|
$36,506
|
|
24
|
|
|
|
|
|
|
|
Years of Ownership & Ending Value
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Monthly PMI Expense
|
|
|
|
|
|
|
|
25
|
MO 5.08%
|
|
|
|
$ 400,000
|
|
|
6.250%
|
|
$ 13,000
|
2.4
|
$ 1,200
|
1.1
|
$ 10,000
|
|
25
|
|
|
$ 72,042.21
|
|
25
|
|
|
|
$ 23,913.62
|
|
25
|
|
|
|
$17,218
|
|
25
|
|
|
|
|
|
|
|
25
|
|
|
|
25
|
|
$93,350
|
|
25
|
|
|
|
25
|
|
|
|
$38,436
|
|
25
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
MI/PMI @
|
|
Months
|
|
|
|
|
|
|
|
26
|
MS 4.29%
|
|
|
|
$ 425,000
|
|
|
6.375%
|
|
$ 13,500
|
2.5
|
$ 1,250
|
1.17
|
$ 11,000
|
|
26
|
|
|
$ 75,732.16
|
|
26
|
|
|
|
$ 25,132.98
|
|
26
|
|
|
|
$18,096
|
|
26
|
|
|
|
|
|
|
|
26
|
|
|
|
26
|
|
$94,632
|
|
26
|
|
|
|
26
|
|
|
|
$40,405
|
|
26
|
|
|
|
|
|
|
|
Transaction Details and
Results:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
27
|
MT 6.22%
|
|
|
|
$ 450,000
|
|
|
6.500%
|
|
$ 14,000
|
2.6
|
$ 1,300
|
1.21
|
$ 12,000
|
|
27
|
|
|
$ 79,495.90
|
|
27
|
|
|
|
$ 26,376.25
|
|
27
|
|
|
|
$18,991
|
|
27
|
|
|
|
|
|
|
|
27
|
|
|
|
27
|
|
$95,652
|
|
27
|
|
|
|
27
|
|
|
|
$42,413
|
|
27
|
|
|
|
|
|
|
|
|
|
|
Costs
|
|
|
|
|
|
|
|
|
|
|
Fuel Adjustments
|
|
|
|
|
|
|
|
28
|
NC 5.06%
|
|
|
|
$ 475,000
|
|
|
6.625%
|
|
$ 14,500
|
2.7
|
$ 1,350
|
|
$ 13,000
|
|
28
|
|
|
$ 83,334.92
|
|
28
|
|
|
|
$ 27,643.91
|
|
28
|
|
|
|
$19,904
|
|
28
|
|
|
|
|
|
|
|
28
|
|
|
|
28
|
|
$96,398
|
|
28
|
|
|
|
28
|
|
|
|
$44,461
|
|
28
|
|
|
|
|
|
|
|
Closing Costs
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
29
|
ND 4.54%
|
|
|
|
$ 500,000
|
|
|
6.750%
|
|
$ 15,000
|
2.8
|
$ 1,400
|
|
$ 14,000
|
|
29
|
|
|
$ 87,250.72
|
|
29
|
|
|
|
$ 28,936.44
|
|
29
|
|
|
|
$20,834
|
|
29
|
|
|
|
|
|
|
|
29
|
|
|
|
29
|
|
$96,859
|
|
29
|
|
|
|
29
|
|
|
|
$46,551
|
|
29
|
|
|
|
|
|
|
|
Lost Opportunity Value of Invested Cash
|
|
|
|
|
|
|
|
|
|
|
|
|
Other
|
|
|
|
|
|
|
|
30
|
NE 4.42%
|
|
|
|
$ 525,000
|
|
|
6.875%
|
|
$ 15,500
|
2.9
|
$ 1,450
|
|
$ 15,000
|
|
30
|
|
|
$ 91,244.83
|
|
30
|
|
|
|
$ 30,254.31
|
|
30
|
|
|
|
$21,783
|
|
30
|
|
|
|
|
|
|
|
30
|
|
|
|
30
|
|
$97,024
|
|
30
|
|
|
|
30
|
|
|
|
$48,682
|
|
30
|
|
|
|
|
|
|
|
Total Cost of Insurance
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
31
|
NH 7.07%
|
|
|
|
$ 550,000
|
|
|
7.000%
|
|
$ 16,000
|
3
|
|
|
$ 16,000
|
|
31
|
|
|
$ 95,318.83
|
|
31
|
|
|
|
$ 31,598.04
|
|
31
|
|
|
|
$22,751
|
|
31
|
|
|
|
|
|
|
|
31
|
|
|
|
31
|
|
$97,024
|
|
31
|
|
|
|
31
|
|
|
|
$50,855
|
|
31
|
|
|
|
|
|
|
|
Total Maintenance Over Term
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Pre-Paid Expenses
|
|
|
|
|
|
|
32
|
NJ 7.77%
|
|
|
|
$ 575,000
|
|
|
7.125%
|
|
$ 16,500
|
3.1
|
|
|
$ 17,000
|
|
32
|
|
|
$ 99,474.31
|
|
32
|
|
|
|
$ 32,968.13
|
|
32
|
|
|
|
$23,737
|
|
32
|
|
|
|
|
|
|
|
32
|
|
|
|
32
|
|
$97,024
|
|
32
|
|
|
|
32
|
|
|
|
$53,072
|
|
32
|
|
|
|
|
|
|
|
Total Condo or Coop Fees
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash to Close Graph
|
|
|
33
|
NM 5.96%
|
|
|
|
$ 600,000
|
|
|
7.250%
|
|
$ 17,000
|
3.2
|
|
|
$ 18,000
|
|
33
|
|
|
$ 103,712.89
|
|
33
|
|
|
|
$ 34,365.09
|
|
33
|
|
|
|
$24,743
|
|
33
|
|
|
|
|
|
|
|
33
|
|
|
|
33
|
|
$97,024
|
|
33
|
|
|
|
33
|
|
|
|
$55,334
|
|
33
|
|
|
|
|
|
|
|
Total Other Expenses
|
|
|
|
|
|
|
|
|
|
|
|
|
|
First Year's Insurance
Premium
|
|
|
|
|
|
|
34
|
NV 6.85%
|
|
|
|
$ 625,000
|
|
|
7.375%
|
|
$ 17,500
|
3.3
|
|
|
$ 19,000
|
|
34
|
|
|
$ 108,036.25
|
|
34
|
|
|
|
$ 35,789.45
|
|
34
|
|
|
|
$25,768
|
|
34
|
|
|
|
|
|
|
|
34
|
|
|
|
34
|
|
$97,024
|
|
34
|
|
|
|
34
|
|
|
|
$57,641
|
|
34
|
|
|
|
|
|
|
|
Total Cost of Private
Mortgage Insurance (PMI)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Closing Costs
|
|
|
|
|
|
35
|
NY 7.27%
|
|
|
|
$ 650,000
|
|
|
7.500%
|
|
$ 18,000
|
3.4
|
|
|
$ 20,000
|
|
35
|
|
|
$ 112,446.07
|
|
35
|
|
|
|
$ 37,241.75
|
|
35
|
|
|
|
$26,814
|
|
35
|
|
|
|
|
|
|
|
35
|
|
|
|
35
|
|
$97,024
|
|
35
|
|
|
|
35
|
|
|
|
$59,993
|
|
35
|
|
|
|
|
|
|
|
Cost of Future Sale
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Grand Total Pre-Paid
Expenses
|
|
|
|
|
Down Payment
|
|
|
|
|
36
|
OH 4.77%
|
|
|
|
$ 675,000
|
|
|
7.625%
|
|
$ 18,500
|
3.5
|
|
|
|
|
36
|
|
|
$ 116,944.10
|
|
36
|
|
|
|
$ 38,722.54
|
|
36
|
|
|
|
$27,880
|
|
36
|
|
|
|
|
|
|
|
36
|
|
|
|
36
|
|
$97,024
|
|
36
|
|
|
|
36
|
|
|
|
$62,393
|
|
36
|
|
|
|
|
|
|
|
Total Real Estate Tax over Term
|
|
|
|
|
|
|
|
|
|
First Year's Insurance
|
|
|
|
|
37
|
OK 4.20%
|
|
|
|
$ 700,000
|
|
|
7.750%
|
|
$ 19,000
|
3.6
|
|
|
|
|
37
|
|
|
$ 121,532.08
|
|
37
|
|
|
|
$ 40,232.38
|
|
37
|
|
|
|
$28,967
|
|
37
|
|
|
|
|
|
|
|
37
|
|
|
|
37
|
|
$97,024
|
|
37
|
|
|
|
37
|
|
|
|
$64,841
|
|
37
|
|
|
|
|
|
|
|
Total Interest Paid
|
|
|
|
|
|
|
|
|
|
Insurance to Escrow
|
|
|
|
|
38
|
OR 7.30%
|
|
|
|
$ 725,000
|
|
|
7.875%
|
|
$ 19,500
|
3.7
|
|
|
|
|
38
|
|
|
$ 126,211.82
|
|
38
|
|
|
|
$ 41,771.83
|
|
38
|
|
|
|
$30,076
|
|
38
|
|
|
|
|
|
|
|
38
|
|
|
|
38
|
|
$97,024
|
|
38
|
|
|
|
38
|
|
|
|
$67,338
|
|
38
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Monthly Payment Graph
|
|
|
|
|
|
Per Diem Interest
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Benefits
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
R.E. Tax to Escrow
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Gross Profit/Appreciation
|
|
|
|
|
|
|
|
|
|
PMI to Escrow
|
|
|
|
|
|
39
|
PA 5.82%
|
|
|
|
$ 750,000
|
|
|
8.000%
|
|
$ 20,000
|
3.8
|
|
|
|
|
39
|
|
|
$ 130,985.16
|
|
39
|
|
|
|
$ 43,341.48
|
|
39
|
|
|
|
$31,206
|
|
39
|
|
|
|
|
|
|
|
39
|
|
|
|
39
|
|
$97,024
|
|
39
|
|
|
|
39
|
|
|
|
$69,885
|
|
39
|
|
|
|
|
|
|
|
Tax Savings from Real
Estate Taxes Paid
|
|
|
|
|
|
|
|
|
Fuel Adjustment
|
|
|
|
|
40
|
RI 7.73%
|
|
|
|
$ 775,000
|
|
|
8.125%
|
|
$ 20,500
|
3.9
|
|
|
|
|
40
|
|
|
$ 135,853.96
|
|
40
|
|
|
|
$ 44,941.91
|
|
40
|
|
|
|
$32,358
|
|
40
|
|
|
|
|
|
|
|
40
|
|
|
|
40
|
|
$97,024
|
|
40
|
|
|
|
40
|
|
|
|
$72,482
|
|
40
|
|
|
|
|
|
|
|
Tax Savings on Interest Paid
|
|
|
|
|
|
|
|
|
|
Other
|
|
|
|
|
|
41
|
SC 4.97%
|
|
|
|
$ 800,000
|
|
|
8.250%
|
|
$ 21,000
|
4
|
|
|
|
|
41
|
|
|
$ 140,820.14
|
|
41
|
|
|
|
$ 46,573.74
|
|
41
|
|
|
|
$33,533
|
|
41
|
|
|
|
|
|
|
|
41
|
|
|
|
41
|
|
$97,024
|
|
41
|
|
|
|
41
|
|
|
|
$75,132
|
|
41
|
|
|
|
|
|
|
|
Tax Savings on Deductible Portion of Condo or Coop
Fee
|
|
|
|
|
|
|
|
|
|
42
|
SD 4.29%
|
|
|
|
$ 825,000
|
|
|
8.375%
|
|
$ 21,500
|
4.1
|
|
|
|
|
42
|
|
|
$ 145,885.64
|
|
42
|
|
|
|
$ 48,237.58
|
|
42
|
|
|
|
$34,731
|
|
42
|
|
|
|
|
|
|
|
42
|
|
|
|
42
|
|
$97,024
|
|
42
|
|
|
|
42
|
|
|
|
$77,835
|
|
42
|
|
|
|
|
|
|
|
Total Housing Value / Rent Saved
|
|
|
|
|
|
|
|
|
|
Total =
|
|
|
|
|
|
43
|
TN 4.72%
|
|
|
|
$ 850,000
|
|
|
8.500%
|
|
$ 22,000
|
4.2
|
|
|
|
|
43
|
|
|
$ 151,052.45
|
|
43
|
|
|
|
$ 49,934.06
|
|
43
|
|
|
|
$35,953
|
|
43
|
|
|
|
|
|
|
|
43
|
|
|
|
43
|
|
$97,024
|
|
43
|
|
|
|
43
|
|
|
|
$80,591
|
|
43
|
|
|
|
|
|
|
|
Earnings from
Alternative Investment Account (IO Savings)
|
|
|
|
|
|
|
|
|
|
44
|
TX 4.24%
|
|
|
|
$ 875,000
|
|
|
8.625%
|
|
$ 22,500
|
4.3
|
|
|
|
|
44
|
|
|
$ 156,322.60
|
|
44
|
|
|
|
$ 51,663.81
|
|
44
|
|
|
|
$37,198
|
|
44
|
|
|
|
|
|
|
|
44
|
|
|
|
44
|
|
$97,024
|
|
44
|
|
|
|
44
|
|
|
|
$83,403
|
|
44
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total of All Costs & Benefits
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
45
|
UT 6.09%
|
|
|
|
$ 900,000
|
|
|
8.750%
|
|
$ 23,000
|
4.4
|
|
|
|
|
45
|
|
|
$ 161,698.15
|
|
45
|
|
|
|
$ 53,427.49
|
|
45
|
|
|
|
$38,468
|
|
45
|
|
|
|
|
|
|
|
45
|
|
|
|
45
|
|
$97,024
|
|
45
|
|
|
|
45
|
|
|
|
$86,271
|
|
45
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
46
|
VA 6.50%
|
|
|
|
$ 925,000
|
|
|
8.875%
|
|
$ 23,500
|
4.5
|
|
|
|
|
46
|
|
|
$ 167,181.22
|
|
46
|
|
|
|
$ 55,225.76
|
|
46
|
|
|
|
$39,763
|
|
46
|
|
|
|
|
|
|
|
46
|
|
|
|
46
|
|
$97,024
|
|
46
|
|
|
|
46
|
|
|
|
$89,197
|
|
46
|
|
|
|
|
|
|
|
Net Benefit -The
total of all benefits minus the total of all costs =
|
|
|
|
|
|
|
|
|
|
|
|
|
47
|
VT 6.36%
|
|
|
|
$ 950,000
|
|
|
9.000%
|
|
$ 24,000
|
4.6
|
|
|
|
|
47
|
|
|
$ 172,773.94
|
|
47
|
|
|
|
$ 57,059.31
|
|
47
|
|
|
|
$41,083
|
|
47
|
|
|
|
|
|
|
|
47
|
|
|
|
47
|
|
$97,024
|
|
47
|
|
|
|
47
|
|
|
|
$92,181
|
|
47
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Return on Initial Cash Investment
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
48
|
WA 7.89%
|
|
|
|
$ 975,000
|
|
|
9.125%
|
|
$ 24,500
|
4.7
|
|
|
|
|
48
|
|
|
$ 178,478.52
|
|
48
|
|
|
|
$ 58,928.83
|
|
48
|
|
|
|
$42,429
|
|
48
|
|
|
|
|
|
|
|
48
|
|
|
|
48
|
|
$97,024
|
|
48
|
|
|
|
48
|
|
|
|
$95,224
|
|
48
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Annual Return on Initial
Cash Investment
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
49
|
WI 5.07%
|
|
|
|
$ 1,000,000
|
|
|
9.250%
|
|
$ 25,000
|
4.8
|
|
|
|
|
49
|
|
|
$ 184,297.19
|
|
49
|
|
|
|
$ 60,835.02
|
|
49
|
|
|
|
$43,801
|
|
49
|
|
|
|
|
|
|
|
49
|
|
|
|
49
|
|
$97,024
|
|
49
|
|
|
|
49
|
|
|
|
$98,329
|
|
49
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash Positions at
Purchase and Sale:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
50
|
WV 4.72%
|
|
|
|
$ 1,025,000
|
|
|
9.375%
|
|
$ 25,500
|
4.9
|
|
|
|
|
50
|
|
|
$ 190,232.24
|
|
50
|
|
|
|
$ 62,778.59
|
|
50
|
|
|
|
$45,201
|
|
50
|
|
|
|
|
|
|
|
50
|
|
|
|
50
|
|
$97,024
|
|
50
|
|
|
|
50
|
|
|
|
$101,495
|
|
50
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
51
|
WY 5.55%
|
|
|
|
$ 1,050,000
|
|
|
9.500%
|
|
$ 26,000
|
5
|
|
|
|
|
51
|
|
|
$ 196,285.98
|
|
51
|
|
|
|
$ 64,760.29
|
|
51
|
|
|
|
$46,627
|
|
51
|
|
|
|
|
|
|
|
51
|
|
|
|
51
|
|
$97,024
|
|
51
|
|
|
|
51
|
|
|
|
$104,725
|
|
51
|
|
|
|
|
|
|
|
Cash Invested at Purchase =
|
|
Cash Upon Sale =
|
|
|
|
|
|
|
|
|
|
|
|
|
52
|
|
|
|
|
$ 1,075,000
|
|
|
9.625%
|
|
$ 26,500
|
5.1
|
|
|
|
|
52
|
|
|
$ 202,460.80
|
|
52
|
|
|
|
$ 66,780.87
|
|
52
|
|
|
|
$48,082
|
|
52
|
|
|
|
|
|
|
|
52
|
|
|
|
52
|
|
$97,024
|
|
52
|
|
|
|
52
|
|
|
|
$108,020
|
|
52
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
53
|
|
|
|
|
$ 1,100,000
|
|
|
9.750%
|
|
$ 27,000
|
5.2
|
|
|
|
|
53
|
|
|
$ 208,759.12
|
|
53
|
|
|
|
$ 68,841.07
|
|
53
|
|
|
|
$49,566
|
|
53
|
|
|
|
|
|
|
|
53
|
|
|
|
53
|
|
$97,024
|
|
53
|
|
|
|
53
|
|
|
|
$111,380
|
|
53
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
54
|
|
|
|
|
$ 1,125,000
|
|
|
9.875%
|
|
$ 27,500
|
5.3
|
|
|
|
|
54
|
|
|
$ 215,183.40
|
|
54
|
|
|
|
$ 70,941.69
|
|
54
|
|
|
|
$51,078
|
|
54
|
|
|
|
|
|
|
|
54
|
|
|
|
54
|
|
$97,024
|
|
54
|
|
|
|
54
|
|
|
|
$114,808
|
|
54
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
55
|
|
|
|
|
$ 1,150,000
|
|
|
10.000%
|
|
$ 28,000
|
5.4
|
|
|
|
|
55
|
|
|
$ 221,736.17
|
|
55
|
|
|
|
$ 73,083.51
|
|
55
|
|
|
|
$52,620
|
|
55
|
|
|
|
|
|
|
|
55
|
|
|
|
55
|
|
$97,024
|
|
55
|
|
|
|
55
|
|
|
|
$118,304
|
|
55
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash on
Sale Analysis
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sale Price
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Subtractions
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Loan Balance at sale
|
-
|
|
|
|
|
|
|
|
|
|
|
|
Cost of Sale
|
|
-
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Additions
|
|
|
|
|
|
|
|
|
|
|
|
Balance of Investment
Account
|
+
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Cash on Sale
|
=
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The Total Monthly
payment =
|
|
With Maintenance
included, the total monthly expense =
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Over time, the structure
of this payment will change. The amount of principal you pay each month on
amortizing
|
|
|
|
|
|
|
|
|
|
loans will increase and
the cost of interest will decline. Taxes and insurance costs will typically
rise with inflation
|
|
|
|
|
|
|
|
|
|
and depending on the
mortgage insurance plan type and term of your loan, rate of appreciation,
etc., MI or PMI
|
|
|
|
|
|
|
|
|
|
costs if applicable can
be reduced or eliminated.
|
|
|
|
|
|
|
|
|
|
|
|