Retirement budget worksheet - Monthly view

.	Retirement Budget Worksheet
.	.
.	The worksheet below can give you a rough idea of how much income you’ll need in retirement and a comparison of living in different cities
.	Note that your expenses in retirement will likely be different from current expenses since your habits and routines are likely to change.
.	.
.	Category or Description	Houston	Cochabamba	Percent
.	.	Monthly	Monthly	Cochabamba
.	.	Amount	Amount	vs Houston
.
.	Income	.	.	.
1	Social Security
2	Pension(s)
3	Investments
4	Other sources (rentals, etc.)
5	Total income (add lines 1 through 4)	$5,833	$5,833	100%
.	Regular expenses
6	Mortgage or rent	$800	$200	25%
7	Utilities (Water, sewer, garbage, electricity, natural gas)	$133	$0	0%
8	Phone (Fixed line and cellular)	$50	$50	100%
9	Cable TV	$40	$40	100%
10	Broadband internet	$40	$50	125%
11	Food and household supplies	$400	$100	25%
12	Dining out	$200	$100	50%
13	Entertainment (Movies, theater, etc.)	$60	$20	33%
14	Transportation (including gas and maintenance)	$300	$50	17%
15	Memberships and subscriptions	$30	$15	50%
16	Health insurance premiums	$750	$65	9%
17	Other insurance premiums	$90	$15	17%
18	Other regular expenses (e.g. lawn care, home cleaning)	$75	$20	27%
19	Minimum payment on credit card debt (largely interest)	$89	$89	100%
20	Total regular expenses (add lines 6 through 19)	$3,057	$814	27%
.	Occasional expenses
21	Out-of-pocket long term care costs (medicines, etc)	$25	$15	60%
22	Out-of-pocket medical, dental, and optical costs	$100	$30	30%
23	Travel	$75	$75	100%
24	Home repairs and projects	$40	$20	50%
25	Gifts and other occasional expenses (e.g. clothing)	$100	$100	100%
26	Total occasional expenses (add lines 21 through 25)	$340	$240	71%
.	Allocations for onetime expenses expected in a typical year
27	Major gift	$17	$17	100%
28	Major home improvement or second home	$83	$83	100%
29	Replace car (Cash down payment only)	$125	$83	67%
30	Other one-time expenses	$25	$13	50%
31	Total onetime expenses (add lines 27 through 30)	$250	$196	78%
.	Taxes
32	State income taxes	$0	$0	0%
33	State property and sales taxes	$167	$0	0%
34	Federal income taxes	$2,000	$2,000	100%
35	Other taxes (incl. currency exchange & fees)	$1	$33	3333%
36	Total taxes (add lines 32 through 36)	$2,168	$2,033	94%
.	Budget Surplus or Shortfall
31	Total expenses (add lines 20, 26, 31, & 36)	$5,815	$3,283	56%
32	Total Surplus or Shortfall (subtract line 31 from line 5)	$19	$2,550	13662%
.	.
	Total cost of living excluding US taxes	$3,648	$1,283	35%