Simulador-PRT-REFIS-2017-v0-3-13-02-17

Prévia do material em texto

SEM Créditos
					PLANILHA DE SIMULAÇÃO DO PRT (NOVO REFIS 2017)
	TABELA SELIC			CONTRIBUINTE:	Contribuinte Digital Ltda.						VERSÃO:	0.3
	SELIC Anual	13.00%		IDENTIFICADOR:	01.234.567/0001-99						INSTRUÇÕES:	Clique aqui
	02/2017	1.08%	PJ	PF OU PJ:	PJ
	03/2017	1.08%	PF	PARCELA MÍNIMA	1,000.00						LEGENDA
	04/2017	1.08%		MÊS DE ADESÃO AO PRT	02/2017							Permite Alteração
	05/2017	1.08%		VALOR TOTAL DA DÍVIDA	500,000.00							Não permite alteração
	06/2017	1.08%
	07/2017	1.08%		(1) Entrada de 20% no mínimo e o restante em até 96 parcelas.							(2) Em 120 parcelas, com valor mínimo nas 36 primeiras.
	08/2017	1.08%
	09/2017	1.08%		% da Entrada	20.0%						Faixa de Parcelas
	10/2017	1.08%		Valor da Entrada	100,000.00						Inicial	Final	Parc. Base
	11/2017	1.08%		Valor restante a Parcelar	400,000.00						001	012	2,500.00
	12/2017	1.08%		Qtd. Máxima de Parcelas	96						013	024	3,000.00
	01/2018	1.08%		Qtd. Parcelas Desejadas	10						025	036	3,500.00
	02/2018	1.08%		Valor da Parcela Base	40,000.00						037	120	4,666.67
	03/2018	1.08%
	04/2018	1.08%		Competência	N.° Parc.	Parc. Base ($)	Juros (%)	Juros ($)	Total		Competência	N.° Parc.	Parc. Base ($)	Juros (%)	Juros ($)	Total
	05/2018	1.08%		03/2017	001	40,000.00	1.00%	400.00	40,400.00		02/2017	001	2,500.00	0.00%	0.00	2,500.00
	06/2018	1.08%		04/2017	002	40,000.00	2.08%	833.33	40,833.33		03/2017	002	2,500.00	1.00%	25.00	2,525.00
	07/2018	1.08%		05/2017	003	40,000.00	3.17%	1,266.67	41,266.67		04/2017	003	2,500.00	2.08%	52.08	2,552.08
	08/2018	1.08%		06/2017	004	40,000.00	4.25%	1,700.00	41,700.00		05/2017	004	2,500.00	3.17%	79.17	2,579.17
	09/2018	1.08%		07/2017	005	40,000.00	5.33%	2,133.33	42,133.33		06/2017	005	2,500.00	4.25%	106.25	2,606.25
	10/2018	1.08%		08/2017	006	40,000.00	6.42%	2,566.67	42,566.67		07/2017	006	2,500.00	5.33%	133.33	2,633.33
	11/2018	1.08%		09/2017	007	40,000.00	7.50%	3,000.00	43,000.00		08/2017	007	2,500.00	6.42%	160.42	2,660.42
	12/2018	1.08%		10/2017	008	40,000.00	8.58%	3,433.33	43,433.33		09/2017	008	2,500.00	7.50%	187.50	2,687.50
	01/2019	1.08%		11/2017	009	40,000.00	9.67%	3,866.67	43,866.67		10/2017	009	2,500.00	8.58%	214.58	2,714.58
	02/2019	1.08%		12/2017	010	40,000.00	10.75%	4,300.00	44,300.00		11/2017	010	2,500.00	9.67%	241.67	2,741.67
	03/2019	1.08%		01/2018	011	0.00	0.00%	0.00	0.00		12/2017	011	2,500.00	10.75%	268.75	2,768.75
	04/2019	1.08%		02/2018	012	0.00	0.00%	0.00	0.00		01/2018	012	2,500.00	11.83%	295.83	2,795.83
	05/2019	1.08%		03/2018	013	0.00	0.00%	0.00	0.00		02/2018	013	3,000.00	12.92%	387.50	3,387.50
	06/2019	1.08%		04/2018	014	0.00	0.00%	0.00	0.00		03/2018	014	3,000.00	14.00%	420.00	3,420.00
	07/2019	1.08%		05/2018	015	0.00	0.00%	0.00	0.00		04/2018	015	3,000.00	15.08%	452.50	3,452.50
	08/2019	1.08%		06/2018	016	0.00	0.00%	0.00	0.00		05/2018	016	3,000.00	16.17%	485.00	3,485.00
	09/2019	1.08%		07/2018	017	0.00	0.00%	0.00	0.00		06/2018	017	3,000.00	17.25%	517.50	3,517.50
	10/2019	1.08%		08/2018	018	0.00	0.00%	0.00	0.00		07/2018	018	3,000.00	18.33%	550.00	3,550.00
	11/2019	1.08%		09/2018	019	0.00	0.00%	0.00	0.00		08/2018	019	3,000.00	19.42%	582.50	3,582.50
	12/2019	1.08%		10/2018	020	0.00	0.00%	0.00	0.00		09/2018	020	3,000.00	20.50%	615.00	3,615.00
	01/2020	1.08%		11/2018	021	0.00	0.00%	0.00	0.00		10/2018	021	3,000.00	21.58%	647.50	3,647.50
	02/2020	1.08%		12/2018	022	0.00	0.00%	0.00	0.00		11/2018	022	3,000.00	22.67%	680.00	3,680.00
	03/2020	1.08%		01/2019	023	0.00	0.00%	0.00	0.00		12/2018	023	3,000.00	23.75%	712.50	3,712.50
	04/2020	1.08%		02/2019	024	0.00	0.00%	0.00	0.00		01/2019	024	3,000.00	24.83%	745.00	3,745.00
	05/2020	1.08%		03/2019	025	0.00	0.00%	0.00	0.00		02/2019	025	3,500.00	25.92%	907.08	4,407.08
	06/2020	1.08%		04/2019	026	0.00	0.00%	0.00	0.00		03/2019	026	3,500.00	27.00%	945.00	4,445.00
	07/2020	1.08%		05/2019	027	0.00	0.00%	0.00	0.00		04/2019	027	3,500.00	28.08%	982.92	4,482.92
	08/2020	1.08%		06/2019	028	0.00	0.00%	0.00	0.00		05/2019	028	3,500.00	29.17%	1,020.83	4,520.83
	09/2020	1.08%		07/2019	029	0.00	0.00%	0.00	0.00		06/2019	029	3,500.00	30.25%	1,058.75	4,558.75
	10/2020	1.08%		08/2019	030	0.00	0.00%	0.00	0.00		07/2019	030	3,500.00	31.33%	1,096.67	4,596.67
	11/2020	1.08%		09/2019	031	0.00	0.00%	0.00	0.00		08/2019	031	3,500.00	32.42%	1,134.58	4,634.58
	12/2020	1.08%		10/2019	032	0.00	0.00%	0.00	0.00		09/2019	032	3,500.00	33.50%	1,172.50	4,672.50
	01/2021	1.08%		11/2019	033	0.00	0.00%	0.00	0.00		10/2019	033	3,500.00	34.58%	1,210.42	4,710.42
	02/2021	1.08%		12/2019	034	0.00	0.00%	0.00	0.00		11/2019	034	3,500.00	35.67%	1,248.33	4,748.33
	03/2021	1.08%		01/2020	035	0.00	0.00%	0.00	0.00		12/2019	035	3,500.00	36.75%	1,286.25	4,786.25
	04/2021	1.08%		02/2020	036	0.00	0.00%	0.00	0.00		01/2020	036	3,500.00	37.83%	1,324.17	4,824.17
	05/2021	1.08%		03/2020	037	0.00	0.00%	0.00	0.00		02/2020	037	4,666.67	38.92%	1,816.11	6,482.78
	06/2021	1.08%		04/2020	038	0.00	0.00%	0.00	0.00		03/2020	038	4,666.67	40.00%	1,866.67	6,533.33
	07/2021	1.08%		05/2020	039	0.00	0.00%	0.00	0.00		04/2020	039	4,666.67	41.08%	1,917.22	6,583.89
	08/2021	1.08%		06/2020	040	0.00	0.00%	0.00	0.00		05/2020	040	4,666.67	42.17%	1,967.78	6,634.44
	09/2021	1.08%		07/2020	041	0.00	0.00%	0.00	0.00		06/2020	041	4,666.67	43.25%	2,018.33	6,685.00
	10/2021	1.08%		08/2020	042	0.00	0.00%	0.00	0.00		07/2020	042	4,666.67	44.33%	2,068.89	6,735.56
	11/2021	1.08%		09/2020	043	0.00	0.00%	0.00	0.00		08/2020	043	4,666.67	45.42%	2,119.44	6,786.11
	12/2021	1.08%		10/2020	044	0.00	0.00%	0.00	0.00		09/2020	044	4,666.67	46.50%	2,170.00	6,836.67
	01/2022	1.08%		11/2020	045	0.00	0.00%	0.00	0.00		10/2020	045	4,666.67	47.58%	2,220.56	6,887.22
	02/2022	1.08%		12/2020	046	0.00	0.00%	0.00	0.00		11/2020	046	4,666.67	48.67%	2,271.11	6,937.78
	03/2022	1.08%		01/2021	047	0.00	0.00%	0.00	0.00		12/2020	047	4,666.67	49.75%	2,321.67	6,988.33
	04/2022	1.08%		02/2021	048	0.00	0.00%	0.00	0.00		01/2021	048	4,666.67	50.83%	2,372.22	7,038.89
	05/2022	1.08%		03/2021	049	0.00	0.00%	0.00	0.00		02/2021	049	4,666.67	51.92%	2,422.78	7,089.44
	06/2022	1.08%		04/2021	050	0.00	0.00%	0.00	0.00		03/2021	050	4,666.67	53.00%	2,473.33	7,140.00
	07/2022	1.08%		05/2021	051	0.00	0.00%	0.00	0.00		04/2021	051	4,666.67	54.08%	2,523.89	7,190.56
	08/2022	1.08%		06/2021	052	0.00	0.00%	0.00	0.00		05/2021	052	4,666.67	55.17%	2,574.44	7,241.11
	09/2022	1.08%		07/2021	053	0.00	0.00%	0.00	0.00		06/2021	053	4,666.67	56.25%	2,625.00	7,291.67
	10/2022	1.08%		08/2021	054	0.00	0.00%	0.00	0.00		07/2021	054	4,666.67	57.33%	2,675.56	7,342.22
	11/2022	1.08%		09/2021	055	0.00	0.00%	0.00	0.00		08/2021	055	4,666.67	58.42%	2,726.11	7,392.78
	12/2022	1.08%		10/2021	056	0.00	0.00%	0.00	0.00		09/2021	056	4,666.67	59.50%	2,776.67	7,443.33
	01/2023	1.08%		11/2021	057	0.00	0.00%	0.00	0.00		10/2021	057	4,666.67	60.58%	2,827.22	7,493.89
	02/2023	1.08%		12/2021	058	0.00	0.00%	0.00	0.00		11/2021	058	4,666.67	61.67%	2,877.78	7,544.44
	03/2023	1.08%		01/2022	059	0.00	0.00%	0.00	0.00		12/2021	059	4,666.67	62.75%	2,928.33	7,595.00
	04/2023	1.08%		02/2022	060	0.00	0.00%	0.00	0.00		01/2022	060	4,666.67	63.83%	2,978.89	7,645.56
	05/2023	1.08%		03/2022	061	0.00	0.00%	0.00	0.00		02/2022	061	4,666.67	64.92%	3,029.44	7,696.11
	06/2023	1.08%		04/2022	062	0.00	0.00%	0.00	0.00		03/2022	062	4,666.67	66.00%	3,080.00	7,746.67
	07/2023	1.08%		05/2022	063	0.00	0.00%	0.00	0.00		04/2022	063	4,666.67	67.08%	3,130.56	7,797.22
	08/2023	1.08%		06/2022	064	0.00	0.00%	0.00	0.00		05/2022	064	4,666.67	68.17%	3,181.11	7,847.78
	09/2023	1.08%		07/2022	065	0.00	0.00%	0.00	0.00		06/2022	065	4,666.67	69.25%	3,231.67	7,898.33
	10/2023	1.08%		08/2022	066	0.00	0.00%	0.00	0.00		07/2022	066	4,666.67	70.33%	3,282.22	7,948.89
	11/2023	1.08%		09/2022	067	0.00	0.00%	0.00	0.00		08/2022	067	4,666.67	71.42%	3,332.78	7,999.44
	12/2023	1.08%		10/2022	068	0.00	0.00%	0.00	0.00		09/2022	068	4,666.67	72.50%	3,383.33	8,050.00
	01/2024	1.08%		11/2022	069	0.00	0.00%	0.00	0.00		10/2022	069	4,666.67	73.58%	3,433.89	8,100.56
	02/2024	1.08%		12/2022	070	0.00	0.00%	0.00	0.00		11/2022	070	4,666.67	74.67%	3,484.44	8,151.11
	03/2024	1.08%		01/2023	071	0.00	0.00%	0.00	0.00		12/2022	071	4,666.6775.75%	3,535.00	8,201.67
	04/2024	1.08%		02/2023	072	0.00	0.00%	0.00	0.00		01/2023	072	4,666.67	76.83%	3,585.56	8,252.22
	05/2024	1.08%		03/2023	073	0.00	0.00%	0.00	0.00		02/2023	073	4,666.67	77.92%	3,636.11	8,302.78
	06/2024	1.08%		04/2023	074	0.00	0.00%	0.00	0.00		03/2023	074	4,666.67	79.00%	3,686.67	8,353.33
	07/2024	1.08%		05/2023	075	0.00	0.00%	0.00	0.00		04/2023	075	4,666.67	80.08%	3,737.22	8,403.89
	08/2024	1.08%		06/2023	076	0.00	0.00%	0.00	0.00		05/2023	076	4,666.67	81.17%	3,787.78	8,454.44
	09/2024	1.08%		07/2023	077	0.00	0.00%	0.00	0.00		06/2023	077	4,666.67	82.25%	3,838.33	8,505.00
	10/2024	1.08%		08/2023	078	0.00	0.00%	0.00	0.00		07/2023	078	4,666.67	83.33%	3,888.89	8,555.56
	11/2024	1.08%		09/2023	079	0.00	0.00%	0.00	0.00		08/2023	079	4,666.67	84.42%	3,939.44	8,606.11
	12/2024	1.08%		10/2023	080	0.00	0.00%	0.00	0.00		09/2023	080	4,666.67	85.50%	3,990.00	8,656.67
	01/2025	1.08%		11/2023	081	0.00	0.00%	0.00	0.00		10/2023	081	4,666.67	86.58%	4,040.56	8,707.22
	02/2025	1.08%		12/2023	082	0.00	0.00%	0.00	0.00		11/2023	082	4,666.67	87.67%	4,091.11	8,757.78
	03/2025	1.08%		01/2024	083	0.00	0.00%	0.00	0.00		12/2023	083	4,666.67	88.75%	4,141.67	8,808.33
	04/2025	1.08%		02/2024	084	0.00	0.00%	0.00	0.00		01/2024	084	4,666.67	89.83%	4,192.22	8,858.89
	05/2025	1.08%		03/2024	085	0.00	0.00%	0.00	0.00		02/2024	085	4,666.67	90.92%	4,242.78	8,909.44
	06/2025	1.08%		04/2024	086	0.00	0.00%	0.00	0.00		03/2024	086	4,666.67	92.00%	4,293.33	8,960.00
	07/2025	1.08%		05/2024	087	0.00	0.00%	0.00	0.00		04/2024	087	4,666.67	93.08%	4,343.89	9,010.56
	08/2025	1.08%		06/2024	088	0.00	0.00%	0.00	0.00		05/2024	088	4,666.67	94.17%	4,394.44	9,061.11
	09/2025	1.08%		07/2024	089	0.00	0.00%	0.00	0.00		06/2024	089	4,666.67	95.25%	4,445.00	9,111.67
	10/2025	1.08%		08/2024	090	0.00	0.00%	0.00	0.00		07/2024	090	4,666.67	96.33%	4,495.56	9,162.22
	11/2025	1.08%		09/2024	091	0.00	0.00%	0.00	0.00		08/2024	091	4,666.67	97.42%	4,546.11	9,212.78
	12/2025	1.08%		10/2024	092	0.00	0.00%	0.00	0.00		09/2024	092	4,666.67	98.50%	4,596.67	9,263.33
	01/2026	1.08%		11/2024	093	0.00	0.00%	0.00	0.00		10/2024	093	4,666.67	99.58%	4,647.22	9,313.89
	02/2026	1.08%		12/2024	094	0.00	0.00%	0.00	0.00		11/2024	094	4,666.67	100.67%	4,697.78	9,364.44
	03/2026	1.08%		01/2025	095	0.00	0.00%	0.00	0.00		12/2024	095	4,666.67	101.75%	4,748.33	9,415.00
	04/2026	1.08%		02/2025	096	0.00	0.00%	0.00	0.00		01/2025	096	4,666.67	102.83%	4,798.89	9,465.56
	05/2026	1.08%			TOTAL				423,500.00		02/2025	097	4,666.67	103.92%	4,849.44	9,516.11
	06/2026	1.08%									03/2025	098	4,666.67	105.00%	4,900.00	9,566.67
	07/2026	1.08%									04/2025	099	4,666.67	106.08%	4,950.56	9,617.22
	08/2026	1.08%									05/2025	100	4,666.67	107.17%	5,001.11	9,667.78
	09/2026	1.08%									06/2025	101	4,666.67	108.25%	5,051.67	9,718.33
	10/2026	1.08%									07/2025	102	4,666.67	109.33%	5,102.22	9,768.89
	11/2026	1.08%									08/2025	103	4,666.67	110.42%	5,152.78	9,819.44
	12/2026	1.08%									09/2025	104	4,666.67	111.50%	5,203.33	9,870.00
	01/2027	1.08%									10/2025	105	4,666.67	112.58%	5,253.89	9,920.56
	02/2027	1.08%									11/2025	106	4,666.67	113.67%	5,304.44	9,971.11
	03/2027	1.08%									12/2025	107	4,666.67	114.75%	5,355.00	10,021.67
	04/2027	1.08%									01/2026	108	4,666.67	115.83%	5,405.56	10,072.22
	05/2027	1.08%									02/2026	109	4,666.67	116.92%	5,456.11	10,122.78
	06/2027	1.08%									03/2026	110	4,666.67	118.00%	5,506.67	10,173.33
											04/2026	111	4,666.67	119.08%	5,557.22	10,223.89
											05/2026	112	4,666.67	120.17%	5,607.78	10,274.44
											06/2026	113	4,666.67	121.25%	5,658.33	10,325.00
											07/2026	114	4,666.67	122.33%	5,708.89	10,375.56
											08/2026	115	4,666.67	123.42%	5,759.44	10,426.11
											09/2026	116	4,666.67	124.50%	5,810.00	10,476.67
											10/2026	117	4,666.67	125.58%	5,860.56	10,527.22
											11/2026	118	4,666.67	126.67%	5,911.11	10,577.78
											12/2026	119	4,666.67	127.75%	5,961.67	10,628.33
											01/2027	120	4,666.67	128.83%	6,012.22	10,678.89
													TOTAL			850,737.08
Principal + Multa + Juros + Encargos Leais se houver.
Clique aqui