Zoho Sheet - Expenses 04-05, 2007

Expenses Alexandra Debits Overnight Stays Brampton Budget Calculation Budget Pay Stubs 2001_2007 Pension Projections Pension Projections Test

Expenses 04-05, 2007

Expenses

Expenses
Food (305.00), transportation (140.30),laundry (65.36),miscellaneous(710.81);
Savings (300.00); - 30.5 days.				eeee
Daily:37.39 ; total: 1221.46 Long term surplus/deficit at the bottom of the page.

			NET							**Difference goes towards budget
IN	EXEMPT	OUT	OUT	TODAY	Date	TOTAL	NOT SPENT			* Deduct as is

$215.36			$0.00	$215.36	May.15	$716.06	$505.40	Deficit or surplus must be included in next month budget
$54.60		$35.80	$35.80	$18.80	May.15			HWY 407:		*
$474.48	$21.24	$141.70	$162.94	$311.54	May.16			Bank services:($15.00)		**
$171.16		$135.80	$135.80	$35.36	May.20			Bell Toronto ($50.00):		**
$135.00			$0.00	$135.00	May.21			Telus ($38.00):		**
			$0.00	$0.00				Car Insurance ($127.75)		**
			$0.00	$0.00				Ex. Exchange ($13.00)	$13.00	*
			$0.00	$0.00				Mobile Internet ($50.00)		**
			$0.00	$0.00
			$0.00	$0.00
			$0.00	$0.00
			$0.00	$0.00
			$0.00	$0.00
			$0.00	$0.00				Brampton projection
			$0.00	$0.00				Projection	$130.00	*
			$0.00	$0.00				Actual (end of month)	-$124.00
			$0.00	$0.00				Difference (end of month)	$6.00	*** If negative add amount to expenses. If positive, subtract from expenses)
			$0.00	$0.00
			$0.00	$0.00				Other *
			$0.00	$0.00				Physioterapist	$100.60
			$0.00	$0.00
			$0.00	$0.00
			$0.00	$0.00
			$0.00	$0.00
			$0.00	$0.00
			$0.00	$0.00				CAA, lottery, parking and license renewal
			$0.00	$0.00				is part of expenses ($98, $204, $128.40, $74.00 per year)
			$0.00	$0.00				(March 15, July 28, May 31, July 29 (see budget)).
			$0.00	$0.00
			$0.00	$0.00
			$0.00	$0.00
			$0.00	$0.00
			$0.00	$0.00				If you lose your job or quit before June 30 2006, or gratuity of $14000
			$0.00	$0.00				is affected, this budget is not valid and must be revised.
			$0.00	$0.00
			$0.00	$0.00
			$0.00	$0.00
			$0.00	$0.00
			$0.00	$0.00
			$0.00	$0.00
			$0.00	$0.00
			$0.00	$0.00
			$0.00	$0.00
			$0.00	$0.00




								ING (RSP)	$6,409.99
								ING (Savings)	$3,448.13	These sums must be in
								NBC (Investments)	$11,187.57	bank accounts. Transfer $850.00
										every month to ING savings
								Total	$21,045.69

								Goal for June 30, 2006	$25,400.80	No second car

								Surplus/Deficit	-$5,455.11	Adjust this sum with cash transfers
										to ING savings account to be reflected
Travel							Just for reference (does not affect any calculations)			in the ING savings account above.
Savings	$1,100.00						Date	Extra Budgetary Expenses
Dec.15	$600.00						Brakes	February	$329.04
Jan.15	$100.00						Compression test	Feb. 22	$106.02
Feb.15	$100.00						A/C	Apr.26	$682.95
Mar.15	$100.00						New York Trip	After trip incorporate
Apr.15	$100.00							in budget
May.15	$100.00						Camping	$62.78
							Camping	$52.73
							Camping	$39.00
							Kari's Travel Insur.	$162.38
							Canoes rental	$265.04
							Drivers license	$56.58



							Total for trip:	$638.51

Alexandra Debits


			Current
		Amount	Total
May.15	Balance forward	$129.08	$26.32	*	* - means Erwin owes Alexandra
May.-Jun.	Overnight stays	-$124.00	**		** Before resetting to zero include
May.19	Blockbuster	$1.71			this amount in budget
May.19	Parking	$1.88
May.19	Green Mango	$14.13
May.19	Gas	$3.53

Overnight Stays

Brampton Budget Calculation


Brampton Budget Calculation

Year	365	days
Month	30.42	days
Weeks in month =	4.35	weeks





Alexandra's House Expenses
	Monthly	Annual
Hydro	$100.00	$1,200.00
Heating	$100.00	$1,200.00
Water	$16.67	$200.00
Internet	$57.00	$684.00






Erwin's Monthly Expenses

Hydro	$33.33
Food (Erwin)	$182.50	$6.00	Per day
Snacks (Erwin	$91.25	$3.00	Per day
Heating	$33.33
Water	$5.56
Internet	$19.00

Total	$364.97

Total per day	$12.00

Budget

Budget
	MONTHLY BUDGET
					Gas Cost		Kilometres	340
	Date issued: June 02, 2005.	30-Jan-06					Litres	31.2
							Litres/Km	0.09
	1 month = 30.5 days				Day	Miles
							Price of gas	64.5
DAILY EXPENDITURES					Mon.	84
					Tue.	48
Food			$10.00		Wed.	48
Newspaper			$0.00		Thu.	84
Transportation - No 407			$4.60		Fri.	120
			__________		Sat.	80
		Total	$14.60		Sun.	80

WEEKLY EXPENDITURES					Total
					Per Week	544
Sustenance			$102.20
Laundry			$15.00		Total
Miscellaneous			$154.54		Per Month	2370.29
			__________
		Total	$271.74		Total
					Per Year	28443.43
MONTHLY EXPENDITURES

Rent			$665.00
RRSP			$850.00
Food			$305.00
Transportation			$140.29
Newspaper			$0.00
Lottery			$17.00
Parking permit			$10.70
Vehicle License Renewal			$6.17
CAA			$8.16
Hydro			$0.00
Water			$0.00
Cable TV			$0.00
Cellular			$38.00
Phone (Toronto)			$50.00
Internet (Toronto)			$50.00
Laundry			$65.36
Car Insurance			$127.75
Bank Service Charges			$15.00
Miscellaneous			$710.81
			_____________
		Total	$3,059.24







Monthly averaged salary			$3,171.00	(See Pay Stubs 2001-2006)

Expenses			$3,059.24

			--------------------
	Balance		$111.76




Monthly expendable cash			$1,221.46
Daily expendable cash			$40.05

Pay Stubs 2001_2007


2001		2007		Difference
					Total
Jan. 05	$1,168.63	Jan.12	$1,473.30	$304.67	$36,320.88	Year 2001		Monthly Average (2001)	$3,026.74
Jan. 19	$1,340.33	Jan.26	$1,582.82	$242.49	$15,652.44	Year 2007
Feb. 02	$1,193.79	Feb.09	$1,525.29	$331.50
Feb. 16	$1,545.44	Feb.23	$1,634.82	$89.38	Average of Difference		$222.60	(Biweekly Average)
Mar. 02	$1,453.57	Mar.09	$1,525.29	$71.72	(Change formula when		$476.36	(Monthly Average)
Mar. 16	$1,403.92	Mar.23	$1,634.82	$230.90	entering new values)
Mar. 30	$1,403.92	Apr.05	$1,525.29	$121.37
Apr. 12	$1,256.48	Apr.19	$1,634.82	$378.34
Apr. 27	$1,403.92	May.05	$1,525.29	$121.37
May. 11	$1,256.48	May.19	$1,590.70	$334.22
May. 25	$1,345.48
Jun. 08	$1,256.48
Jun. 22	$1,345.48
Jun. 28	$5,630.08
Sep. 07	$1,510.72
Sep. 14	$1,413.47
Sep. 28	$1,536.18
Oct. 12	$1,412.19
Oct. 26	$1,539.98
Nov. 09	$1,414.06
Nov. 23	$1,538.11
Dec. 07	$1,414.06
Dec. 21	$1,538.11




2001		2006		Difference
					Total
Jan. 05	$1,168.63	Jan.13	$1,441.10	$272.47	$36,320.88	Year 2001		Monthly Average (2001)	$3,026.74
Jan. 19	$1,340.33	Jan.27	$1,577.16	$236.83	$42,707.45	Year 2006		Monthly Average (2006)	$3,558.95
Feb. 02	$1,193.79	Feb.10	$1,493.10	$299.31
Feb. 16	$1,545.44	Feb.24	$1,629.16	$83.72	Average of Difference		$277.68	(Biweekly Average)		Including TPP deduction for monthly
Mar. 02	$1,453.57	Mar.10	$1,554.68	$101.11	(Change formula when		$594.23	(Monthly Average)		average income (10.9%)
Mar. 16	$1,403.92	Mar.24	$1,629.16	$225.24	entering new values)					$3,171.03
Mar. 30	$1,403.92	Apr.07	$1,523.89	$119.97
Apr. 12	$1,256.48	Apr.21	$1,629.16	$372.68
Apr. 27	$1,403.92	May.05	$1,523.89	$119.97
May. 11	$1,256.48	May.19	$1,589.30	$332.82
May. 25	$1,345.48	Jun.02	$1,523.89	$178.41
Jun. 08	$1,256.48	Jun.16	$1,589.30	$332.82
Jun. 22	$1,345.48	Jun.22	$0.00	-$1,345.48
Jun. 28	$5,630.08	Jun.29	$8,207.74	$2,577.66
Sep. 07	$1,510.72	Sep.08	$1,694.33	$183.61
Sep. 14	$1,413.47	Sep.22	$1,803.72	$390.25
Sep. 28	$1,536.18	Oct.04	$1,694.33	$158.15
Oct. 12	$1,412.19	Oct.20	$1,803.72	$391.53
Oct. 26	$1,539.98	Nov.03	$1,694.33	$154.35
Nov. 09	$1,414.06	Nov.17	$1,803.72	$389.66
Nov. 23	$1,538.11	Dec.01	$1,694.33	$156.22
Dec. 07	$1,414.06	Dec.15	$1,803.72	$389.66
Dec. 21	$1,538.11	Dec.29	$1,803.72	$265.61

Pension Projections

Last Updated:	Sep 13 2006
			Supply T.			Number of				Yearly
			Monthly Gross	CPP	OAS	months for	RRSP	RSSP and	RRSP	Taxable
		Comments	Income	Income	Income	RRSP	Total	Others Used	Balance	Income	SURPLUS
2007	55-56	No RRSP	$3,542.00	$0.00	$0.00	1	$39,410.80	$0.00	$39,410.80	$5,478.00	$83.44	You must supplement with $866.00 from savings
2008 and 2009	57-58	ST 8xmonth	$10,304.00	$0.00	$0.00	24	$39,410.80	$3,100.00	$36,310.80	$23,738.00	$300.96	Net
2010	58-59	ST 8-2xmonth	$7,728.00	$0.00	$0.00	12	$36,310.80	$3,900.00	$32,410.80	$23,512.00	$301.01	Net
2011	CPP 59-60	ST 2xmonth	$3,220.00	$1,588.00	$0.00	12	$32,410.80	$6,450.00	$25,960.80	$23,142.00	$302.75	Net
2012 to 2015	CPP 59-64	ST 2xmonth	$3,220.00	$4,764.00	$0.00	48	$25,960.80	$13,100.00	$12,860.80	$23,143.00	$302.82	Net
Jan. 2016-Aug.2016	CPP 64-65	ST 2xmonth	$1,932.00	$3,176.00	$0.00	8	$12,860.80	$5,500.00	$7,360.80	$20,560.00	$304.41	Net
Sep.2016 onwards	CPP-OAS 65	No Supply T.	$0.00	$4,764.00	$5,808.00	1	$7,360.80	$0.00	$7,360.80	$18,874.72	$195.63	Net


			Changes in			Calculations area
		Monthly	Monthly	Tax Rate
		Budget	Budget	%
2007	55-56	$1,840.24	$150.00	0.3115
2008 and 2009	57-58	$1,840.24	$150.00	0.2255
2010	58-59	$1,840.24	$150.00	0.2255
2011	CPP 59-60	$1,840.24	$150.00	0.2255
2012 to 2015	CPP 59-64	$1,840.24	$150.00	0.2255
Jan. 2016-Aug.2016	CPP 64-65	$1,690.24	$0.00	0.2255
Sep.2016 onwards	CPP-OAS 65	$1,690.24	$0.00	0.2255

OTTP Gross Yearly		$19,896.00		On the first $34,010 of Taxable Income 22.55%
Tax Exemption		$8,012.00		25.15% on the next $34,011, +
CPP Contribution %		4.95		31.15% above $35,596, +
EI Contribution %		1.87		32.98% above $59,883, +
Supply Teaching Daily Income		$161.00		35.39% above %68,021 (after that it does not apply to me anymore)


CPP at 60 retiring at 56:	$397.00		CPP at 60 and retiring at 60:			$446.00
CPP at 65 retiring at 56:	$567.00		CPP at 65 and retiring at 65:			$695.00
OAS at 65:	$484.00

PENSION ADJUSTMENT IS DEDUCTED AT AGE 65			$3,581.28	18.00	%






					Available as from
RRSP 2005			$3,400.00		Apr.28, 2006
RRSP (refunds from 2005) (1)			$1,614.00		Apr.28, 2006
RRSP 2006 (2)			$798.80		Apr.28, 2007
RRSP (refunds from 2006 (1&2) (3)			$795.00		Apr.28 2007
RRSP 2007			$5,100.00		Apr.01 2008
RRSP (refunds from 2007) (4)			$1,589.00		Apr.01 2008
RRSP			$3,002.00		Mar.16, 2009
RRSP			$5,100.00		May. 19, 2009'			You must have minimum of $6000 in
RRSP			$3,002.00		Sep.15,2010			the bank to compensate for inflation of 5%
Co-Op Savings			$1,000.00		Apr.28, 2006			(Return 2%)
Gratuity			$14,010.00		Apr.01 2008


					If I buy used car for $8000.00 taxes and inspection included)

					1000.00	Co-Op savings
					1430.99	ING Savings	Gratuity towards saving goals for June 30, 2006
					11187.57	NBC RRSP	is not included ($8000.00 for car are)
					6659.13	ING Savings
				Total savings	5528.27	ING RSP
				as Dec.03 2006	25805.96





	Total	$39,410.80


One	207
TAX RATE:					0.3115		CPP MONTHLY			RSSP MONTLY		$0.00
PENSION ADJUSTMENT AT 65							OAS MONTHLY			OTHER MONHLY
TAX EXEMPTED:					$8,012.00		OTTP MONTHLY:		$1,658.00	OTTP Yearly		$19,896.00
BUDGET					$1,840.24
CPP CONTRIBUTION					0.0495	Only payable if income other than pension (TPP and CPP).					Look tor contribution tables.
EI CONTRIBUTION					0.0187	Only payable if income other than pension (TPP and CPP).					Look tor contribution tables.

			Gross	Supply T.			PRE-TAX			ANNUAL	MONTHLY
			Income	Monthly			TOTAL	TAXABLE	TOTAL	NET	NET
TPP	CPP	OAS	Adjustments	Annualized	RRSP		INCOME	INCOME	TAX	INCOME	INCOME	SURPLUS

$9,948.00	$0.00	$0.00		$3,542.00	$0.00		$13,490.00	$5,478.00	$1,947.96	$11,542.04	$1,923.67	$83.44	NET

		Total			Used	Balance
TOTAL RRSP		$39,410.80		$10,304.00	$0.00	$39,410.80	NUMBER OF MOTNHS:			1
							MONTHLY RRSP:			$0.00


Two	2008 and 2009
TAX RATE:					0.2255		CPP MONTHLY			RSSP MONTLY		$129.17
PENSION ADJUSTMENT AT 65							OAS MONTHLY			OTHER MONHLY
TAX EXEMPTED:					$8,012.00		OTTP MONTHLY:		$1,658.00	OTTP Yearly		$19,896.00
BUDGET					$1,840.24
CPP CONTRIBUTION					0.0495	Only payable if income other than pension (TPP and CPP).					Look tor contribution tables.
EI CONTRIBUTION					0.0187	Only payable if income other than pension (TPP and CPP).					Look tor contribution tables.

			Gross	Supply T.			PRE-TAX			ANNUAL	MONTHLY
			Income	Monthly			TOTAL	TAXABLE	TOTAL	NET	NET
TPP	CPP	OAS	Adjustments	Annualized	RRSP		INCOME	INCOME	TAX	INCOME	INCOME	SURPLUS

$19,896.00	$0.00	$0.00		$10,304.00	$1,550.00		$31,750.00	$23,738.00	$6,055.65	$25,694.35	$2,141.20	$300.96	NET

		Total			Used	Balance
TOTAL RRSP		$39,410.80			$3,100.00	$36,310.80	NUMBER OF MOTNHS:			24
							MONTHLY RRSP:			$129.17


Three	2010
TAX RATE:					0.2255		CPP MONTHLY			RSSP MONTLY		$325.00
PENSION ADJUSTMENT AT 65							OAS MONTHLY			OTHER MONHLY
TAX EXEMPTED:					$8,012.00		OTTP MONTHLY:		$1,658.00	OTTP Yearly		$19,896.00
BUDGET					$1,840.24
CPP CONTRIBUTION					0.0495	Only payable if income other than pension (TPP and CPP).					Look tor contribution tables.
EI CONTRIBUTION					0.0187	Only payable if income other than pension (TPP and CPP).					Look tor contribution tables.

			Gross	Supply T.			PRE-TAX			ANNUAL	MONTHLY
			Income	Monthly			TOTAL	TAXABLE	TOTAL	NET	NET
TPP	CPP	OAS	Adjustments	Annualized	RRSP		INCOME	INCOME	TAX	INCOME	INCOME	SURPLUS

$19,896.00	$0.00	$0.00		$7,728.00	$3,900.00		$31,524.00	$23,512.00	$5,829.01	$25,694.99	$2,141.25	$301.01	NET

		Total			Used	Balance
TOTAL RRSP		$36,310.80			$3,900.00	$32,410.80	NUMBER OF MOTNHS:			12
							MONTHLY RRSP:			$325.00


Four	2011
TAX RATE:					0.2255		CPP MONTHLY			RSSP MONTLY		$537.50
PENSION ADJUSTMENT AT 65							OAS MONTHLY			OTHER MONHLY
TAX EXEMPTED:					$8,012.00		OTTP MONTHLY:		$1,658.00	OTTP Yearly		$19,896.00
BUDGET					$1,840.24
CPP CONTRIBUTION					0.0495	Only payable if income other than pension (TPP and CPP).					Look tor contribution tables.
EI CONTRIBUTION					0.0187	Only payable if income other than pension (TPP and CPP).					Look tor contribution tables.

			Gross	Supply T.			PRE-TAX			ANNUAL	MONTHLY
			Income	Monthly			TOTAL	TAXABLE	TOTAL	NET	NET
TPP	CPP	OAS	Adjustments	Annualized	RRSP		INCOME	INCOME	TAX	INCOME	INCOME	SURPLUS

$19,896.00	$1,588.00	$0.00		$3,220.00	$6,450.00		$31,154.00	$23,142.00	$5,438.13	$25,715.88	$2,142.99	$302.75	NET

		Total			Used	Balance
TOTAL RRSP		$32,410.80			$6,450.00	$25,960.80	NUMBER OF MOTNHS:			12
							MONTHLY RRSP:			$537.50


Five	2012-2015
TAX RATE:					0.2255		CPP MONTHLY			RSSP MONTLY		$272.92
PENSION ADJUSTMENT AT 65							OAS MONTHLY			OTHER MONHLY
TAX EXEMPTED:					$8,012.00		OTTP MONTHLY:		$1,658.00	OTTP Yearly		$19,896.00
BUDGET					$1,840.24
CPP CONTRIBUTION					0.0495	Only payable if income other than pension (TPP and CPP).					Look tor contribution tables.
EI CONTRIBUTION					0.0187	Only payable if income other than pension (TPP and CPP).					Look tor contribution tables.

			Gross	Supply T.			PRE-TAX			ANNUAL	MONTHLY
			Income	Monthly			TOTAL	TAXABLE	TOTAL	NET	NET
TPP	CPP	OAS	Adjustments	Annualized	RRSP		INCOME	INCOME	TAX	INCOME	INCOME	SURPLUS

$19,896.00	$4,764.00	$0.00		$3,220.00	$3,275.00		$31,155.00	$23,143.00	$5,438.35	$25,716.65	$2,143.05	$302.82	NET

		Total			Used	Balance
TOTAL RRSP		$25,960.80			$13,100.00	$12,860.80	NUMBER OF MOTNHS:			48
							MONTHLY RRSP:			272.92


Six	Jan. 2016-Aug.2016
TAX RATE:					0.2255		CPP MONTHLY			RSSP MONTLY		$687.50
PENSION ADJUSTMENT AT 65							OAS MONTHLY			OTHER MONHLY
TAX EXEMPTED:					$8,012.00		OTTP MONTHLY:		$1,658.00	OTTP Yearly		$19,896.00
BUDGET					$1,690.24
CPP CONTRIBUTION					0.0495	Only payable if income other than pension (TPP and CPP).					Look tor contribution tables.
EI CONTRIBUTION					0.0187	Only payable if income other than pension (TPP and CPP).					Look tor contribution tables.

			Gross	Supply T.			PRE-TAX			ANNUAL	MONTHLY
			Income	Monthly			TOTAL	TAXABLE	TOTAL	NET	NET
TPP	CPP	OAS	Adjustments	Annualized	RRSP		INCOME	INCOME	TAX	INCOME	INCOME	SURPLUS

$19,896.00	$3,176.00	$0.00		$0.00	$5,500.00		$28,572.00	$20,560.00	$4,636.28	$23,935.72	$1,994.64	$304.41	NET

		Total			Used	Balance
TOTAL RRSP		$12,860.80			$5,500.00	$7,360.80	NUMBER OF MOTNHS:			8
							MONTHLY RRSP:			687.5


Seven	Sep.2016 onwards
TAX RATE:					0.2255		CPP MONTHLY			RSSP MONTLY		$0.00
PENSION ADJUSTMENT AT 65					$3,581.28		OAS MONTHLY			OTHER MONHLY
TAX EXEMPTED:					$8,012.00		OTTP MONTHLY:		$1,658.00	OTTP Yearly		$19,896.00
BUDGET					$1,690.24
CPP CONTRIBUTION					0.0495	Only payable if income other than pension (TPP and CPP).					Look tor contribution tables.
EI CONTRIBUTION					0.0187	Only payable if income other than pension (TPP and CPP).					Look tor contribution tables.

			Gross	Supply T.			PRE-TAX			ANNUAL	MONTHLY
			Income	Monthly			TOTAL	TAXABLE	TOTAL	NET	NET
TPP	CPP	OAS	Adjustments	Annualized	RRSP		INCOME	INCOME	TAX	INCOME	INCOME	SURPLUS

$19,896.00	$4,764.00	$5,808.00		$0.00	0		$26,886.72	$18,874.72	$4,256.25	$22,630.47	$1,885.87	$195.63	NET

		Total			Used	Balance
TOTAL RRSP		$7,360.80			$0.00	$7,360.80	NUMBER OF MOTNHS:			1
							MONTHLY RRSP:			0


Budget
		MONTHLY BUDGET WHEN PENSIONED								Gas Cost
		LIVING IN BRAMPTON WITH CAR
		Date issued: January 08, 2006.
										Day	Miles
		1 month = 30.5 days
										Mon.	80
DAILY EXPENDITURES										Tue.	80
										Wed.
Food						$10.00				Thu.	80
Transportation - No 407						$4.61				Fri.
						__________				Sat.	80
					Total	$14.61				Sun.

WEEKLY EXPENDITURES										Total
										Per Week	320
Sustenance						$102.30
Laundry						$15.00				Total
Miscellaneous						$154.54				Per Month	1394.29
						__________
					Total	$271.84				Total
										Per Year	16731.43
MONTHLY EXPENDITURES

Payments to Alexandra										Kilometres	340
Supplement						$14.00				Litres	31.2
Food						$305.00				Litres/Km	0.09
Telephone						$31.00
Internet						$50.00				Price of gas	110
Total Payments						$400.00
Transportation						$140.74
Lottery						$17.00
Vehicle License Renewal						$6.17
CAA						$8.16
Savings						$100.00
Cellular						$38.00
Health Insurance						$135.00
Car payments						$0.00
Laundry						$65.36
Car Insurance						$135.00
Bank Service Charges						$15.00
Miscellaneous						$629.81
						_____________
					Total	$1,690.24







Monthly averaged salary (no RRSP)						$1,529.74

Expenses						$1,690.24

						--------------------
		Balance				($160.50)




Monthly expendable cash						$1,140.91
Daily expendable cash						$37.41


	Gross per supply teaching day:				$161.00


	All values are net incomes (after tax)
	September	October	November	December	January	February	March	April	May	June


1
2
3
4
5
6
7
8
9
10


	Canada Pension	First cheque will be sent by August 30			$397.00
1							Supply	$0.00		Days	0.00
2							CPP	$0.00
3							OAS	$0.00
4
5
6
7
8
9
10
11
12

	Old Age Security	First cheque will be sent by August 30			$484.00
1
2
3
4
5
6
7
8
9
10
11
12

Pension Projections Test

Last Updated:	Sep 13 2006
			Supply T.			Number of				Yearly
			Monthly Gross	CPP	OAS	months for	RRSP	RSSP and	RRSP	Taxable
		Comments	Income	Income	Income	RRSP	Total	Others Used	Balance	Income	SURPLUS
2007	55-56	No RRSP	$3,542.00	$0.00	$0.00	1	$39,400.80	$0.00	$39,400.80	$5,478.00	$83.44	You must supplement with $866.00 from savings
2008 and 2009	57-58	ST 8xmonth	$10,304.00	$0.00	$0.00	24	$39,400.80	$3,100.00	$36,300.80	$23,738.00	$300.96	Net
2010	58-59	ST 8-2xmonth	$7,728.00	$0.00	$0.00	12	$36,300.80	$3,900.00	$32,400.80	$23,512.00	$301.01	Net
2011	CPP 59-60	ST 2xmonth	$3,220.00	$1,588.00	$0.00	12	$32,400.80	$6,450.00	$25,950.80	$23,142.00	$302.75	Net
2012 to 2015	CPP 59-64	ST 2xmonth	$3,220.00	$4,764.00	$0.00	48	$25,950.80	$13,100.00	$12,850.80	$23,143.00	$302.82	Net
Jan. 2016-Aug.2016	CPP 64-65	ST 2xmonth	$1,932.00	$3,176.00	$0.00	8	$12,850.80	$5,500.00	$7,350.80	$20,560.00	$304.41	Net
Sep.2016 onwards	CPP-OAS 65	No Supply T.	$0.00	$4,764.00	$5,808.00	1	$7,350.80	$0.00	$7,350.80	$18,874.72	$195.63	Net


			Changes in			Calculations area
		Monthly	Monthly	Tax Rate
		Budget	Budget	%
2007	55-56	$1,840.24	$150.00	0.3115
2008 and 2009	57-58	$1,840.24	$150.00	0.2255
2010	58-59	$1,840.24	$150.00	0.2255
2011	CPP 59-60	$1,840.24	$150.00	0.2255
2012 to 2015	CPP 59-64	$1,840.24	$150.00	0.2255
Jan. 2016-Aug.2016	CPP 64-65	$1,690.24	$0.00	0.2255
Sep.2016 onwards	CPP-OAS 65	$1,690.24	$0.00	0.2255

OTTP Gross Yearly		$19,896.00		On the first $34,010 of Taxable Income 22.55%
Tax Exemption		$8,012.00		25.15% on the next $34,011, +
CPP Contribution %		4.95		31.15% above $35,596, +
EI Contribution %		1.87		32.98% above $59,883, +
Supply Teaching Daily Income		$161.00		35.39% above %68,021 (after that it does not apply to me anymore)


CPP at 60 retiring at 56:	$397.00		CPP at 60 and retiring at 60:			$446.00
CPP at 65 retiring at 56:	$567.00		CPP at 65 and retiring at 65:			$695.00
OAS at 65:	$484.00

PENSION ADJUSTMENT IS DEDUCTED AT AGE 65			$3,581.28	18.00	%






					Available as from
RRSP 2005			$3,400.00		Apr.28, 2006
RRSP (refunds from 2005) (1)			$1,614.00		Apr.28, 2006
RRSP 2006 (2)			$798.80		Apr.28, 2007
RRSP (refunds from 2006 (1&2) (3)			$795.00		Apr.28 2007
RRSP 2007			$5,100.00		Apr.01 2008
RRSP (refunds from 2007) (4)			$1,589.00		Apr.01 2008
RRSP			$3,002.00		Mar.16, 2009
RRSP			$5,100.00		May. 19, 2009'			You must have minimum of $6000 in
RRSP			$3,002.00		Sep.15,2010			the bank to compensate for inflation of 5%
Co-Op Savings			$1,000.00		Apr.28, 2006			(Return 2%)
Gratuity			$14,000.00		Apr.01 2008


					If I buy used car for $8000.00 taxes and inspection included)

					1000.00	Co-Op savings
					1430.99	ING Savings	Gratuity towards saving goals for June 30, 2006
					11187.57	NBC RRSP	is not included ($8000.00 for car are)
					6659.13	ING Savings
				Total savings	5528.27	ING RSP
				as Dec.03 2006	25805.96





	Total	$39,400.80


One	207
TAX RATE:					0.3115		CPP MONTHLY			RSSP MONTLY		$0.00
PENSION ADJUSTMENT AT 65							OAS MONTHLY			OTHER MONHLY
TAX EXEMPTED:					$8,012.00		OTTP MONTHLY:		$1,658.00	OTTP Yearly		$19,896.00
BUDGET					$1,840.24
CPP CONTRIBUTION					0.0495	Only payable if income other than pension (TPP and CPP).					Look tor contribution tables.
EI CONTRIBUTION					0.0187	Only payable if income other than pension (TPP and CPP).					Look tor contribution tables.

			Gross	Supply T.			PRE-TAX			ANNUAL	MONTHLY
			Income	Monthly			TOTAL	TAXABLE	TOTAL	NET	NET
TPP	CPP	OAS	Adjustments	Annualized	RRSP		INCOME	INCOME	TAX	INCOME	INCOME	SURPLUS

$9,948.00	$0.00	$0.00		$3,542.00	$0.00		$13,490.00	$5,478.00	$1,947.96	$11,542.04	$1,923.67	$83.44	NET

		Total			Used	Balance
TOTAL RRSP		$39,400.80		$10,304.00	$0.00	$39,400.80	NUMBER OF MOTNHS:			1
							MONTHLY RRSP:			$0.00


Two	2008 and 2009
TAX RATE:					0.2255		CPP MONTHLY			RSSP MONTLY		$129.17
PENSION ADJUSTMENT AT 65							OAS MONTHLY			OTHER MONHLY
TAX EXEMPTED:					$8,012.00		OTTP MONTHLY:		$1,658.00	OTTP Yearly		$19,896.00
BUDGET					$1,840.24
CPP CONTRIBUTION					0.0495	Only payable if income other than pension (TPP and CPP).					Look tor contribution tables.
EI CONTRIBUTION					0.0187	Only payable if income other than pension (TPP and CPP).					Look tor contribution tables.

			Gross	Supply T.			PRE-TAX			ANNUAL	MONTHLY
			Income	Monthly			TOTAL	TAXABLE	TOTAL	NET	NET
TPP	CPP	OAS	Adjustments	Annualized	RRSP		INCOME	INCOME	TAX	INCOME	INCOME	SURPLUS

$19,896.00	$0.00	$0.00		$10,304.00	$1,550.00		$31,750.00	$23,738.00	$6,055.65	$25,694.35	$2,141.20	$300.96	NET

		Total			Used	Balance
TOTAL RRSP		$39,400.80			$3,100.00	$36,300.80	NUMBER OF MOTNHS:			24
							MONTHLY RRSP:			$129.17


Three	2010
TAX RATE:					0.2255		CPP MONTHLY			RSSP MONTLY		$325.00
PENSION ADJUSTMENT AT 65							OAS MONTHLY			OTHER MONHLY
TAX EXEMPTED:					$8,012.00		OTTP MONTHLY:		$1,658.00	OTTP Yearly		$19,896.00
BUDGET					$1,840.24