rent_vs_buy.xlsx

	A	C	E	G	H	I	J	K	L	M	N	P	Q	R	S	T	U	V	W
1	RENT vs. BUY — 30-Year Family Comparison
2	Lee Family vs. Park Family — Saskatoon, SK
3
4	INPUT PARAMETERS (blue = editable)
5	Parameter	Lee Family 🏠	Park Family 🏢→🏠
6	Combined Annual Income	$105,000	$105,000
7	House Purchase Price	$350,000	$400,000
8	Year of Purchase	1	5
9	Down Payment ($)	$20,000	$112,000
10	Mortgage Amount	$330,000	$288,000
11	Mortgage Rate (%)	6.5%	6.5%
12	Amortization (years)	30	25
13	Monthly Mortgage Payment	$2,085.82	$1,944.60
14	Annual Mortgage Payment	$25,030	$23,335
15	Property Tax (annual)	$3,500	$3,500
16	Utilities & Maint. (house, annual)	$6,200	$6,200
17	Monthly Rent	$0	$1,800
18	Annual Rent	$0	$21,600
19	Utilities (rental, annual)	$1,800	$1,800
20	Savings Interest Rate (%)	3.0%	3.0%
21	Monthly Living Expenses	$5,000	$5,000
22	Annual Living Expenses	$60,000	$60,000
23	Initial Savings ($)	$20,000	$20,000
24	Row refs: Income=C6, Price=C7, BuyYr=C8, Down=C9, Mortg=C10, Rate=C11, Amort=C12, MoPmt=C13, AnnPmt=C14, PropTax=C15, UtilH=C16, MoRent=C17, AnnRent=C18, UtilR=C19, SaveRate=C20, MoLiv=C21, AnnLiv=C22, InitSav=C23
25
26				LEE FAMILY — Year-by-Year Tracking								PARK FAMILY — Year-by-Year Tracking
27				Yr	Income (+)	Housing Cost (−)	Utilities (−)	Unexpected (−)	Living Exp. (−)	Debt Left	Cash Saved	Yr	Income (+)	Housing Cost (−)	Utilities (−)	Unexpected (−)	Living Exp. (−)	Debt Left	Cash Saved
28						Mortgage+PropTax or Rent	House or Rental	Repairs, breakdowns	$5,000/mo	Mortgage balance	Accumulated (+interest)			Mortgage+PropTax or Rent	House or Rental	Repairs, breakdowns	$5,000/mo	Mortgage balance	Accumulated (+interest)
29				1	$105,000	-28,530	-6,200	0	-60,000	$326,312	$10,270	1	$105,000	-21,600	-1,800	0	-60,000	$0	$42,200
30				2	$105,000	-28,530	-6,200	0	-60,000	$322,376	$20,848	2	$105,000	-21,600	-1,800	0	-60,000	$0	$65,066
31				3	$105,000	-28,530	-6,200	-3,500	-60,000	$318,177	$28,244	3	$105,000	-21,600	-1,800	0	-60,000	$0	$88,618
32				4	$105,000	-28,530	-6,200	0	-60,000	$313,697	$39,361	4	$105,000	-21,600	-1,800	0	-60,000	$0	$112,877
33				5	$105,000	-28,530	-6,200	0	-60,000	$308,916	$50,812	5	$105,000	-26,835	-6,200	0	-60,000	$283,245	$12,868
34				6	$105,000	-28,530	-6,200	0	-60,000	$303,816	$62,607	6	$105,000	-26,835	-6,200	0	-60,000	$278,171	$25,219
35				7	$105,000	-28,530	-6,200	-6,000	-60,000	$298,374	$68,755	7	$105,000	-26,835	-6,200	0	-60,000	$272,758	$37,940
36				8	$105,000	-28,530	-6,200	0	-60,000	$292,567	$81,088	8	$105,000	-26,835	-6,200	-3,000	-60,000	$266,982	$48,043
37				9	$105,000	-28,530	-6,200	0	-60,000	$286,372	$93,791	9	$105,000	-26,835	-6,200	0	-60,000	$260,819	$61,449
38				10	$105,000	-28,530	-6,200	0	-60,000	$279,761	$106,874	10	$105,000	-26,835	-6,200	0	-60,000	$254,244	$75,257
39				11	$105,000	-28,530	-6,200	0	-60,000	$272,708	$120,351	11	$105,000	-26,835	-6,200	0	-60,000	$247,228	$89,480
40				12	$105,000	-28,530	-6,200	-4,500	-60,000	$265,183	$129,731	12	$105,000	-26,835	-6,200	0	-60,000	$239,742	$104,129
41				13	$105,000	-28,530	-6,200	0	-60,000	$257,153	$143,893	13	$105,000	-26,835	-6,200	-4,000	-60,000	$231,755	$115,218
42				14	$105,000	-28,530	-6,200	0	-60,000	$248,586	$158,480	14	$105,000	-26,835	-6,200	0	-60,000	$223,233	$130,639
43				15	$105,000	-28,530	-6,200	0	-60,000	$239,445	$173,505	15	$105,000	-26,835	-6,200	0	-60,000	$214,140	$146,523
44				16	$105,000	-28,530	-6,200	0	-60,000	$229,692	$188,980	16	$105,000	-26,835	-6,200	0	-60,000	$204,438	$162,884
45				17	$105,000	-28,530	-6,200	-5,000	-60,000	$219,286	$199,920	17	$105,000	-26,835	-6,200	0	-60,000	$194,087	$179,735
46				18	$105,000	-28,530	-6,200	0	-60,000	$208,183	$216,187	18	$105,000	-26,835	-6,200	-6,500	-60,000	$183,042	$190,592
47				19	$105,000	-28,530	-6,200	0	-60,000	$196,336	$232,943	19	$105,000	-26,835	-6,200	0	-60,000	$171,258	$208,275
48				20	$105,000	-28,530	-6,200	0	-60,000	$183,695	$250,201	20	$105,000	-26,835	-6,200	0	-60,000	$158,684	$226,488
49				21	$105,000	-28,530	-6,200	0	-60,000	$170,209	$267,977	21	$105,000	-26,835	-6,200	0	-60,000	$145,268	$245,247
50				22	$105,000	-28,530	-6,200	-8,000	-60,000	$155,819	$278,287	22	$105,000	-26,835	-6,200	0	-60,000	$130,954	$264,570
51				23	$105,000	-28,530	-6,200	0	-60,000	$140,465	$296,906	23	$105,000	-26,835	-6,200	-5,000	-60,000	$115,681	$279,471
52				24	$105,000	-28,530	-6,200	0	-60,000	$124,083	$316,083	24	$105,000	-26,835	-6,200	0	-60,000	$99,386	$299,820
53				25	$105,000	-28,530	-6,200	0	-60,000	$106,604	$335,835	25	$105,000	-26,835	-6,200	0	-60,000	$81,999	$320,780
54				26	$105,000	-28,530	-6,200	0	-60,000	$87,954	$356,181	26	$105,000	-26,835	-6,200	0	-60,000	$63,447	$342,368
55				27	$105,000	-28,530	-6,200	-7,000	-60,000	$68,055	$370,136	27	$105,000	-26,835	-6,200	0	-60,000	$43,653	$364,604
56				28	$105,000	-28,530	-6,200	0	-60,000	$46,824	$391,510	28	$105,000	-26,835	-6,200	-5,500	-60,000	$22,534	$382,007
57				29	$105,000	-28,530	-6,200	0	-60,000	$24,170	$413,526	29	$105,000	-26,835	-6,200	0	-60,000	$0	$405,432
58				30	$105,000	-28,530	-6,200	0	-60,000	$0	$436,202	30	$105,000	-3,500	-6,200	0	-60,000	$0	$452,895
59				TOTAL	$3,150,000	-$855,897	-$186,000	-$34,000	-$1,800,000	$0	$436,202	TOTAL	$3,150,000	-$760,779	-$168,400	-$24,000	-$1,800,000	$0	$452,895
60
61
62				30-YEAR TOTAL HOUSING COST BREAKDOWN
63
64					Component	Lee Family	Park Family
65					House Price	$350,000	$400,000
66					Total Interest Paid	$420,897	$295,379
67					Total Rent Paid	$0	$86,400
68					Total Property Tax	$105,000	$91,000
69					GRAND TOTAL PAID	$875,897	$872,779
70					× House Price Multiplier	2.50×	2.18×
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