Desagio_CRI380(1Emissao)-2021-11-18

Prévia do material em texto

Worksheet
	Série	CRI 380 (1ª Emissão)
	Data do Cálculo	2021-11-18
	Taxa Original	IPCA/IBGE + 23,0000% a.a.
	Taxa Estimada	IPCA/IBGE + -228,2748% a.a.
	PU Original	958.06052397
	PU Estimado	3552784.2999999
	PU-PAR	370.830,88292564%
	N	Data	PMT	Dias VP	VP	Índice de Correção	VP Corrigido
	1	2021-11-22	34.93718021	2	34.6091335082	1.0010989727	35.2296199484
	2	2021-12-20	20.33376776	22	18.3294526797	1.0136122594	22.2543219353
	3	2022-01-20	20.3342814	45	16.4453660062	1.0136122594	24.8051730129
	4	2022-02-21	20.33377311	67	14.823963109	1.0136122594	27.5169165278
	5	2022-03-21	20.33378429	85	13.6172825844	1.0136122594	29.9553307725
	6	2022-04-20	20.33331294	106	12.3327685919	1.0136122594	33.0737814454
	7	2022-05-20	20.33300393	127	11.1695115732	1.0136122594	36.5171648565
	8	2022-06-20	20.33337235	147	10.1641440959	1.0136122594	40.1306467852
	9	2022-07-20	20.3339303	169	9.1625080317	1.0136122594	44.5201314726
	10	2022-08-22	20.33309107	192	8.2201457829	1.0136122594	49.6198488823
	11	2022-09-20	20.17606649	212	7.4223490881	1.0136122594	54.1077867916
	12	2022-10-20	20.11427756	233	6.7017699292	1.0136122594	59.5590152317
	13	2022-11-21	20.1135604	253	6.0982158389	1.0136122594	65.4490371408
	14	2022-12-20	20.11334029	274	5.5230406403	1.0136122594	72.2633863281
	15	2023-01-20	20.11375806	297	4.9553043731	1.0136122594	80.5460511468
	16	2023-02-22	20.1135264	318	4.4879244106	1.0136122594	88.932203188
	17	2023-03-20	20.11377595	336	4.1226532408	1.0136122594	96.8140869905
	18	2023-04-20	20.11338037	358	3.716207061	1.0136122594	107.3985393111
	19	2023-05-22	20.11369007	378	3.3817021463	1.0136122594	118.025622566
	20	2023-06-20	20.11362766	398	3.0772499085	1.0136122594	129.7018559243
	21	2023-07-20	20.11322939	420	2.7738680989	1.0136122594	143.8818300124
	22	2023-08-21	20.11322128	442	2.5004447851	1.0136122594	159.615160791
	23	2023-09-20	20.02519044	463	2.254719351	1.0136122594	175.4643787596
	24	2023-10-20	19.94357095	484	2.0337565269	1.0136122594	192.9456673171
	25	2023-11-20	19.94276433	503	1.8593395962	1.0136122594	211.028028449
	26	2023-12-20	19.94258711	525	1.6760481722	1.0136122594	234.101741317
	27	2024-01-22	19.94375621	546	1.518071251	1.0136122594	258.493664426
	28	2024-02-20	19.94296289	565	1.3878809154	1.0136122594	282.7192003246
	29	2024-03-20	19.94299395	586	1.2569936398	1.0136122594	312.1589420603
	30	2024-04-22	19.94267023	608	1.1330724202	1.0136122594	346.2877212332
	31	2024-05-20	19.94288779	627	1.0359522315	1.0136122594	378.7603476681
	32	2024-06-20	19.94296156	649	0.9338410799	1.0136122594	420.179127526
	33	2024-07-22	19.943036	671	0.8417947907	1.0136122594	466.1272126937
	34	2024-08-20	19.94289474	692	0.7624008251	1.0136122594	514.660907909
	35	2024-09-20	19.87666203	715	0.681744574	1.0136122594	571.7331340957
	36	2024-10-21	19.78624911	736	0.6146415414	1.0136122594	628.3956662306
	37	2024-11-20	19.78608721	757	0.5566709468	1.0136122594	693.8241745623
	38	2024-12-20	19.78601688	779	0.5017976811	1.0136122594	769.6907120481
	39	2025-01-20	19.78646408	798	0.4587919504	1.0136122594	841.8771804154
	40	2025-02-20	19.78570404	821	0.4116064609	1.0136122594	938.3156917448
	41	2025-03-20	19.7858849	839	0.3781046676	1.0136122594	1021.4734038971
	42	2025-04-22	19.78585754	860	0.3424456376	1.0136122594	1127.8368048785
	43	2025-05-20	19.78536384	879	0.3130820185	1.0136122594	1233.5538196123
	44	2025-06-20	19.78561029	901	0.2822247993	1.0136122594	1368.4592639817
	45	2025-07-21	19.78568218	922	0.2556094764	1.0136122594	1510.9609903654
	46	2025-08-20	19.78567244	944	0.2304137409	1.0136122594	1676.1828781794
	47	2025-09-22	19.73488397	967	0.2061936154	1.0136122594	1863.4686312049
	48	2025-10-20	19.73327882	987	0.1876154721	1.0136122594	2047.6607206638
	49	2025-11-20	19.73236699	1010	0.1683184249	1.0136122594	2282.2060647035
	50	2025-12-22	19.73260397	1032	0.1517289709	1.0136122594	2531.79438753
	51	2026-01-20	19.73262224	1051	0.1387222863	1.0136122594	2769.1820709868
	52	2026-02-20	19.73266084	1072	0.1256398148	1.0136122594	3057.5400938928
	53	2026-03-20	19.73228652	1092	0.1143267376	1.0136122594	3359.9681481263
	54	2026-04-20	19.73225051	1112	0.1040341158	1.0136122594	3692.3733347192
	55	2026-05-20	19.73218781	1132	0.0946679913	1.0136122594	4057.6582279581
	56	2026-06-22	19.73211225	1154	0.085336168	1.0136122594	4501.3435782663
	57	2026-07-20	19.73259916	1174	0.0776555707	1.0136122594	4946.7973294975
	58	2026-08-20	19.73209748	1197	0.0696698138	1.0136122594	5513.5332744723
	59	2026-09-21	19.66015618	1218	0.0628692908	1.0136122594	6065.4567623098
	60	2026-10-20	19.65793709	1238	0.0572029334	1.0136122594	6664.7785954064
	61	2026-11-20	19.65777628	1260	0.0515639746	1.0136122594	7393.5078089534
	62	2026-12-21	19.65725354	1281	0.0466998017	1.0136122594	8163.1689877031
	63	2027-01-20	19.65790156	1301	0.0424969846	1.0136122594	8971.0719917933
	64	2027-02-22	19.65720766	1322	0.038487791	1.0136122594	9904.8707228458
	65	2027-03-22	19.6572161	1342	0.0350228862	1.0136122594	10884.794549701
	66	2027-04-20	19.5747392	1362	0.0317361812	1.0136122594	11911.472344438
	67	2027-05-20	19.57467121	1383	0.0287430837	1.0136122594	13151.755859913
	68	2027-06-21	19.57446075	1404	0.0260320812	1.0136122594	14521.07835838
	69	2027-07-20	19.57433631	1425	0.0235768798	1.0136122594	16033.041181267
	70	2027-08-20	19.57435381	1448	0.021152894	1.0136122594	17870.356654465
	71	2027-09-20	19.57717054	1468	0.0192513436	1.0136122594	19641.151627946
	72	2027-10-20	19.57505486	1489	0.0174338903	1.0136122594	21684.020651229
	73	2027-11-22	19.57498588	1510	0.0157896673	1.0136122594	23941.870745506
	74	2027-12-20	19.57479814	1530	0.0143680415	1.0136122594	26310.260902288
	75	2028-01-20	19.5752044	1553	0.0128910907	1.0136122594	29325.882620816
	76	2028-02-21	19.57437609	1575	0.0116199143	1.0136122594	32531.274379222
	77	2028-03-20	19.57462292	1593	0.0106741742	1.0136122594	35414.463528455
	78	2028-04-20	19.57476669	1615	0.0096220834	1.0136122594	39287.303244402
	79	2028-05-22	19.57449817	1635	0.0087557211	1.0136122594	43173.524061624
	80	2028-06-20	19.5744912	1655	0.0079674716	1.0136122594	47444.795943719
	81	2028-07-20	19.57447608	1677	0.0071821063	1.0136122594	52632.816364365
	82	2028-08-21	19.51256543	1699	0.0064536839	1.0136122594	58203.512849063
	83	2028-09-20	19.33826461	1720	0.0057928331	1.0136122594	63690.128230728
	84	2028-10-20	19.28244928	1741	0.0052313758	1.0136122594	70119.146716889
	85	2028-11-20	19.18985223	1760	0.0047599531	1.0136122594	76325.337180486
	86	2028-12-20	19.18948549	1782	0.0042906789	1.0136122594	84669.850617481
	87	2029-01-22	19.18997462	1803	0.0038861296	1.0136122594	93488.816806145
	88	2029-02-20	19.18934129	1822	0.0035528778	1.0136122594	102251.10412282
	89	2029-03-20	19.18939077	1842	0.0032330331	1.0136122594	112367.40831569
	90	2029-04-20	19.18949005	1864	0.0029143657	1.0136122594	124655.36454028
	91	2029-05-21	19.18938252	1884	0.0026519808	1.0136122594	136987.1333727
	92	2029-06-20	19.13583204	1905	0.0023951732	1.0136122594	150829.37377819
	93	2029-07-20	19.13601751	1927	0.0021591	1.0136122594	167324.10055846
	94	2029-08-20	19.07459227	1948	0.0019492012	1.0136122594	184154.35887931
	95	2029-09-20	18.85732911	1970	0.0017370536	1.0136122594	201964.61321309
	96	2029-10-22	18.85556717	1991	0.0015730874	1.0136122594	222974.14221864
	97	2029-11-20	18.85517015	2010	0.0014382058	1.0136122594	243875.42180706
	98	2029-12-20	18.85492146	2032	0.0012964236	1.0136122594	270539.49022009
	99	2030-01-21	18.85530526	2052	0.0011797352	1.0136122594	297310.84116375
	100	2030-02-20	18.85479951	2074	0.0010634193	1.0136122594	329812.76348954