Upsize/Downsize Calculator - SAMPLE

	A	B	C	D	F
1	Analysis of Upsizing and Downsizing your Home - Today, and at some Future Point
2	Provided by Sebastian "Seb" Frey, REALTOR®			https://SebFrey.com
3
4
5	Edit the cells which are this color
6
7
8	Cost of Sale	5.75%			includes commissions, repairs, closing costs
9	Eligible for Prop 19 Tax Basis Transfer
10
11		Current House	Upsize	Downsize
12	Present Value	$1,350,000	$1,400,000	$1,200,000
13	Equity/Downpayment	$575,000	$497,375	$497,375	Assume all of proceeds (equity minus cost of sale) of sale go to down payment to new home
14	Mortgage	$775,000	$902,625	$702,625
15	Interest Rate	2.80%	7.25%	7.25%	Interest rate can vary depending on loan-to-value ratio, loan term
16	Loan Term (Years)	30	30	30
17	Mortgage Payment (Principal/Interest)	$3,205	$6,157	$4,793	This is Principal + Interest
18	Property Tax Rate	1.08%	1.08%	1.08%	Property tax can vary depending on location
19	Assessed Value	$905,000	$905,000	$905,000
20	Taxes/Year	$9,774	$9,774	$9,774
21	Taxes/Month	$815	$815	$815
22	Insurance/Year	$2,025	$2,100	$1,800	Insurance can vary, here it is assumed to be 0.15% of value per year
23	Insurance/Month	$169	$175	$150
24	HOA Dues	$0	$0	$0	HOA Dues can vary, assume downsizing to a townhouse
25	Total Monthy Cost	$4,188	$7,147	$5,758	This is a cost before taxes
26
27	Today Difference in Cost/Month (Stay vs. Move)		$2,959	$1,569	This is how much more or less per month it will cost you to move now
28
29	Time Value Adjustment	5.00%			This can be adjusted up, or down - this is not per year, this is total, over whatever time period
30
31		Current House	Upsize	Downsize
32
33	Future Value	$1,417,500	$1,470,000	$1,260,000
34	Equity/Downpayment	$642,500	$642,500	$642,500	Assume all of proceeds (equity minus cost of sale) of sale go to down payment to new home
35	Mortgage	$775,000	$827,500	$617,500
36	Interest Rate	2.80%	7.00%	7.00%	In the future, your mortgage rate may be higher or lower; this assumes a higher rate in the future
37	Loan Term (Years)	30	30	30
38	Payment	$3,205	$5,505	$4,108
39	Property Tax Rate	1.08%	1.08%	1.08%
40	Assessed Value	$923,000	$923,000	$923,000
41	Taxes/Year	$9,968	$9,968	$9,968
42	Taxes/Month	$815	$831	$831
43	Insurance/Year	$2,126	$2,205	$1,890
44	Insurance/Month	$177	$184	$158
45	HOA Dues	$0	$0	$0	HOA dues are assumed to be higher in the future
46	Total Monthy Cost	$4,197	$6,520	$5,096
47
48	Future Difference in Cost/Month (Stay vs. Move)		$2,323	$900	This is how much more or less you will pay in the future, given the variables (time value adjustment, etc.)
49
50	Future Difference in Cost/Month (Now vs. Later)		-$636	-$670	This is the difference in cost for waiting to upsize or downsize today vs. in the future
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100