Financiamento - Price e SAC

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2			Financiamento	R$ 100,000.00		DÍVIDA
3	PRICE		Prazo (meses)	300		Principal	R$ 100,000.00
4	PRICE		Taxa anual (C.E.T)	10.00%		Juros	R$ 163,548.70
5			Mes/ano início	02/2004		Total	R$ 263,548.70
6			Taxa ao mês	0.797%
7
8	Parcela	Prestação	Pagamento de juros	Amortização da dívida	Soma dos pagamentos	Dívida já paga	% dívida real paga	Total juros pago	Total juros à pagar	Meses p/ quitar	Anos p/ quitar	Data quitar	Valor da dívida original para quitar	Dívida p/ quitar s/ desc. juros	A N O
9
10

12	1	878.50	797.41	81.08	878.50	81.08	0.08%	797.41	162,751.29	299	24.9	02/04	99,918.92	262,670.21	1
13	2	878.50	796.77	81.73	1,756.99	162.81	0.16%	1,594.18	161,954.52	298	24.8	03/04	99,837.19	261,791.71
14	3	878.50	796.12	82.38	2,635.49	245.19	0.25%	2,390.30	161,158.41	297	24.8	04/04	99,754.81	260,913.22
15	4	878.50	795.46	83.04	3,513.98	328.23	0.33%	3,185.76	160,362.95	296	24.7	05/04	99,671.77	260,034.72
16	5	878.50	794.80	83.70	4,392.48	411.93	0.41%	3,980.55	159,568.15	295	24.6	06/04	99,588.07	259,156.23
17	6	878.50	794.13	84.37	5,270.97	496.29	0.50%	4,774.68	158,774.02	294	24.5	07/04	99,503.71	258,277.73
18	7	878.50	793.46	85.04	6,149.47	581.33	0.58%	5,568.14	157,980.56	293	24.4	08/04	99,418.67	257,399.23
19	8	878.50	792.78	85.72	7,027.97	667.05	0.67%	6,360.92	157,187.79	292	24.3	09/04	99,332.95	256,520.74
20	9	878.50	792.09	86.40	7,906.46	753.45	0.75%	7,153.01	156,395.69	291	24.3	10/04	99,246.55	255,642.24
21	10	878.50	791.41	87.09	8,784.96	840.54	0.84%	7,944.42	155,604.29	290	24.2	11/04	99,159.46	254,763.75
22	11	878.50	790.71	87.78	9,663.45	928.32	0.93%	8,735.13	154,813.57	289	24.1	12/04	99,071.68	253,885.25
23	12	878.50	790.01	88.48	10,541.95	1,016.81	1.02%	9,525.14	154,023.56	288	24.0	01/05	98,983.19	253,006.76
24	13	878.50	789.31	89.19	11,420.44	1,106.00	1.11%	10,314.45	153,234.26	287	23.9	02/05	98,894.00	252,128.26	2
25	14	878.50	788.59	89.90	12,298.94	1,195.90	1.20%	11,103.04	152,445.66	286	23.8	03/05	98,804.10	251,249.76
26	15	878.50	787.88	90.62	13,177.44	1,286.52	1.29%	11,890.92	151,657.78	285	23.8	04/05	98,713.48	250,371.27
27	16	878.50	787.16	91.34	14,055.93	1,377.86	1.38%	12,678.07	150,870.63	284	23.7	05/05	98,622.14	249,492.77
28	17	878.50	786.43	92.07	14,934.43	1,469.93	1.47%	13,464.50	150,084.20	283	23.6	06/05	98,530.07	248,614.28
29	18	878.50	785.69	92.80	15,812.92	1,562.73	1.56%	14,250.19	149,298.51	282	23.5	07/05	98,437.27	247,735.78
30	19	878.50	784.95	93.54	16,691.42	1,656.27	1.66%	15,035.15	148,513.56	281	23.4	08/05	98,343.73	246,857.29
31	20	878.50	784.21	94.29	17,569.91	1,750.56	1.75%	15,819.35	147,729.35	280	23.3	09/05	98,249.44	245,978.79
32	21	878.50	783.45	95.04	18,448.41	1,845.60	1.85%	16,602.81	146,945.90	279	23.3	10/05	98,154.40	245,100.29
33	22	878.50	782.70	95.80	19,326.90	1,941.40	1.94%	17,385.51	146,163.20	278	23.2	11/05	98,058.60	244,221.80
34	23	878.50	781.93	96.56	20,205.40	2,037.96	2.04%	18,167.44	145,381.27	277	23.1	12/05	97,962.04	243,343.30
35	24	878.50	781.16	97.33	21,083.90	2,135.30	2.14%	18,948.60	144,600.10	276	23.0	01/06	97,864.70	242,464.81
36	25	878.50	780.39	98.11	21,962.39	2,233.40	2.23%	19,728.99	143,819.72	275	22.9	02/06	97,766.60	241,586.31	3
37	26	878.50	779.60	98.89	22,840.89	2,332.30	2.33%	20,508.59	143,040.11	274	22.8	03/06	97,667.70	240,707.82
38	27	878.50	778.82	99.68	23,719.38	2,431.97	2.43%	21,287.41	142,261.29	273	22.8	04/06	97,568.03	239,829.32
39	28	878.50	778.02	100.47	24,597.88	2,532.45	2.53%	22,065.43	141,483.27	272	22.7	05/06	97,467.55	238,950.82
40	29	878.50	777.22	101.28	25,476.37	2,633.73	2.63%	22,842.65	140,706.05	271	22.6	06/06	97,366.27	238,072.33
41	30	878.50	776.41	102.08	26,354.87	2,735.81	2.74%	23,619.06	139,929.64	270	22.5	07/06	97,264.19	237,193.83
42	31	878.50	775.60	102.90	27,233.37	2,838.71	2.84%	24,394.66	139,154.04	269	22.4	08/06	97,161.29	236,315.34
43	32	878.50	774.78	103.72	28,111.86	2,942.42	2.94%	25,169.44	138,379.27	268	22.3	09/06	97,057.58	235,436.84
44	33	878.50	773.95	104.54	28,990.36	3,046.97	3.05%	25,943.39	137,605.31	267	22.3	10/06	96,953.03	234,558.35
45	34	878.50	773.12	105.38	29,868.85	3,152.35	3.15%	26,716.51	136,832.20	266	22.2	11/06	96,847.65	233,679.85
46	35	878.50	772.28	106.22	30,747.35	3,258.57	3.26%	27,488.78	136,059.92	265	22.1	12/06	96,741.43	232,801.35
47	36	878.50	771.43	107.07	31,625.84	3,365.63	3.37%	28,260.21	135,288.49	264	22.0	01/07	96,634.37	231,922.86
48	37	878.50	770.58	107.92	32,504.34	3,473.55	3.47%	29,030.79	134,517.91	263	21.9	02/07	96,526.45	231,044.36	4
49	38	878.50	769.72	108.78	33,382.84	3,582.33	3.58%	29,800.50	133,748.20	262	21.8	03/07	96,417.67	230,165.87
50	39	878.50	768.85	109.65	34,261.33	3,691.98	3.69%	30,569.35	132,979.35	261	21.8	04/07	96,308.02	229,287.37
51	40	878.50	767.97	110.52	35,139.83	3,802.50	3.80%	31,337.33	132,211.38	260	21.7	05/07	96,197.50	228,408.88
52	41	878.50	767.09	111.40	36,018.32	3,913.90	3.91%	32,104.42	131,444.29	259	21.6	06/07	96,086.10	227,530.38
53	42	878.50	766.20	112.29	36,896.82	4,026.20	4.03%	32,870.62	130,678.08	258	21.5	07/07	95,973.80	226,651.89
54	43	878.50	765.31	113.19	37,775.31	4,139.38	4.14%	33,635.93	129,912.77	257	21.4	08/07	95,860.62	225,773.39
55	44	878.50	764.41	114.09	38,653.81	4,253.47	4.25%	34,400.34	129,148.37	256	21.3	09/07	95,746.53	224,894.89
56	45	878.50	763.50	115.00	39,532.31	4,368.47	4.37%	35,163.83	128,384.87	255	21.3	10/07	95,631.53	224,016.40
57	46	878.50	762.58	115.92	40,410.80	4,484.39	4.48%	35,926.41	127,622.29	254	21.2	11/07	95,515.61	223,137.90
58	47	878.50	761.65	116.84	41,289.30	4,601.23	4.60%	36,688.07	126,860.64	253	21.1	12/07	95,398.77	222,259.41
59	48	878.50	760.72	117.77	42,167.79	4,719.00	4.72%	37,448.79	126,099.91	252	21.0	01/08	95,281.00	221,380.91
60	49	878.50	759.78	118.71	43,046.29	4,837.71	4.84%	38,208.57	125,340.13	251	20.9	02/08	95,162.29	220,502.42	5
61	50	878.50	758.84	119.66	43,924.78	4,957.37	4.96%	38,967.41	124,581.29	250	20.8	03/08	95,042.63	219,623.92
62	51	878.50	757.88	120.61	44,803.28	5,077.98	5.08%	39,725.30	123,823.41	249	20.8	04/08	94,922.02	218,745.42
63	52	878.50	756.92	121.57	45,681.78	5,199.56	5.20%	40,482.22	123,066.49	248	20.7	05/08	94,800.44	217,866.93
64	53	878.50	755.95	122.54	46,560.27	5,322.10	5.32%	41,238.17	122,310.54	247	20.6	06/08	94,677.90	216,988.43
65	54	878.50	754.97	123.52	47,438.77	5,445.62	5.45%	41,993.14	121,555.56	246	20.5	07/08	94,554.38	216,109.94
66	55	878.50	753.99	124.51	48,317.26	5,570.13	5.57%	42,747.13	120,801.57	245	20.4	08/08	94,429.87	215,231.44
67	56	878.50	753.00	125.50	49,195.76	5,695.63	5.70%	43,500.13	120,048.57	244	20.3	09/08	94,304.37	214,352.95
68	57	878.50	752.00	126.50	50,074.25	5,822.13	5.82%	44,252.13	119,296.58	243	20.3	10/08	94,177.87	213,474.45
69	58	878.50	750.99	127.51	50,952.75	5,949.64	5.95%	45,003.11	118,545.59	242	20.2	11/08	94,050.36	212,595.95
70	59	878.50	749.97	128.52	51,831.25	6,078.16	6.08%	45,753.09	117,795.62	241	20.1	12/08	93,921.84	211,717.46
71	60	878.50	748.95	129.55	52,709.74	6,207.71	6.21%	46,502.03	117,046.67	240	20.0	01/09	93,792.29	210,838.96
72	61	878.50	747.91	130.58	53,588.24	6,338.29	6.34%	47,249.94	116,298.76	239	19.9	02/09	93,661.71	209,960.47	6
73	62	878.50	746.87	131.62	54,466.73	6,469.92	6.47%	47,996.82	115,551.89	238	19.8	03/09	93,530.08	209,081.97
74	63	878.50	745.82	132.67	55,345.23	6,602.59	6.60%	48,742.64	114,806.07	237	19.8	04/09	93,397.41	208,203.48
75	64	878.50	744.76	133.73	56,223.72	6,736.32	6.74%	49,487.40	114,061.30	236	19.7	05/09	93,263.68	207,324.98
76	65	878.50	743.70	134.80	57,102.22	6,871.12	6.87%	50,231.10	113,317.60	235	19.6	06/09	93,128.88	206,446.48
77	66	878.50	742.62	135.87	57,980.71	7,006.99	7.01%	50,973.72	112,574.98	234	19.5	07/09	92,993.01	205,567.99
78	67	878.50	741.54	136.96	58,859.21	7,143.95	7.14%	51,715.26	111,833.44	233	19.4	08/09	92,856.05	204,689.49
79	68	878.50	740.45	138.05	59,737.71	7,282.00	7.28%	52,455.71	111,093.00	232	19.3	09/09	92,718.00	203,811.00
80	69	878.50	739.35	139.15	60,616.20	7,421.15	7.42%	53,195.05	110,353.65	231	19.3	10/09	92,578.85	202,932.50
81	70	878.50	738.24	140.26	61,494.70	7,561.41	7.56%	53,933.29	109,615.41	230	19.2	11/09	92,438.59	202,054.01
82	71	878.50	737.12	141.38	62,373.19	7,702.78	7.70%	54,670.41	108,878.29	229	19.1	12/09	92,297.22	201,175.51
83	72	878.50	735.99	142.50	63,251.69	7,845.29	7.85%	55,406.40	108,142.30	228	19.0	01/10	92,154.71	200,297.01
84	73	878.50	734.85	143.64	64,130.18	7,988.93	7.99%	56,141.26	107,407.45	227	18.9	02/10	92,011.07	199,418.52	7
85	74	878.50	733.71	144.79	65,008.68	8,133.72	8.13%	56,874.96	106,673.74	226	18.8	03/10	91,866.28	198,540.02
86	75	878.50	732.55	145.94	65,887.18	8,279.66	8.28%	57,607.52	105,941.18	225	18.8	04/10	91,720.34	197,661.53
87	76	878.50	731.39	147.10	66,765.67	8,426.76	8.43%	58,338.91	105,209.79	224	18.7	05/10	91,573.24	196,783.03
88	77	878.50	730.22	148.28	67,644.17	8,575.04	8.58%	59,069.13	104,479.58	223	18.6	06/10	91,424.96	195,904.54
89	78	878.50	729.04	149.46	68,522.66	8,724.50	8.72%	59,798.16	103,750.54	222	18.5	07/10	91,275.50	195,026.04
90	79	878.50	727.84	150.65	69,401.16	8,875.15	8.88%	60,526.01	103,022.70	221	18.4	08/10	91,124.85	194,147.54
91	80	878.50	726.64	151.85	70,279.65	9,027.00	9.03%	61,252.65	102,296.05	220	18.3	09/10	90,973.00	193,269.05
92	81	878.50	725.43	153.06	71,158.15	9,180.07	9.18%	61,978.08	101,570.62	219	18.3	10/10	90,819.93	192,390.55
93	82	878.50	724.21	154.28	72,036.65	9,334.35	9.33%	62,702.29	100,846.41	218	18.2	11/10	90,665.65	191,512.06
94	83	878.50	722.98	155.52	72,915.14	9,489.87	9.49%	63,425.27	100,123.43	217	18.1	12/10	90,510.13	190,633.56
95	84	878.50	721.74	156.76	73,793.64	9,646.62	9.65%	64,147.01	99,401.69	216	18.0	01/11	90,353.38	189,755.07
96	85	878.50	720.49	158.01	74,672.13	9,804.63	9.80%	64,867.50	98,681.20	215	17.9	02/11	90,195.37	188,876.57	8
97	86	878.50	719.23	159.27	75,550.63	9,963.89	9.96%	65,586.73	97,961.97	214	17.8	03/11	90,036.11	187,998.08
98	87	878.50	717.96	160.54	76,429.12	10,124.43	10.12%	66,304.69	97,244.01	213	17.8	04/11	89,875.57	187,119.58
99	88	878.50	716.68	161.82	77,307.62	10,286.24	10.29%	67,021.38	96,527.33	212	17.7	05/11	89,713.76	186,241.08
100	89	878.50	715.39	163.11	78,186.12	10,449.35	10.45%	67,736.77	95,811.94	211	17.6	06/11	89,550.65	185,362.59
101	90	878.50	714.09	164.41	79,064.61	10,613.76	10.61%	68,450.85	95,097.85	210	17.5	07/11	89,386.24	184,484.09