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
0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 2 2.1 2.2 2.3 2.4 2.5 2.6 2.7 2.8 2.9 3 3.1 3.2 3.3 3.4 3.5 3.6 3.7 3.8 3.9 4 4.1 4.2 4.3 4.4 4.5 4.6 4.7 4.8 4.9 5 5.1 5.2 5.3 5.4 5.5 5.6 5.7 5.8 5.9
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
0 0.50% 1.00% 1.50% 2.00% 2.50% 3.00% 3.50% 4.00%
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.