eMBS Demonstration Tour

Products

Demo

Demonstration Tour

Portfolio P&I

You can view the last four months of amortization for an entire Portfolio, as shown in this example, or a subset or single security in your portfolio.

This example shows recent amortization of the sample portfolio "HOUSEACCT." The results are ordered by Product and Coupon, with subtotals at the end of each Product/Coupon grouping.

You can also reorder the results by CUSIP. You can quickly save these results in a spreadsheet format (.csv file) to use in a spreadsheet application.

Historical P & I for Portfolio HOUSEACCT

Product	Coupon	Security	CUSIP	Prefix	Face	2/1/2021					1/1/2021					12/1/2020					11/1/2020					P&I Details for Security
Product	Coupon	Security	CUSIP	Prefix	Face	Payment	Interest	Principal	Balance	Factor	Payment	Interest	Principal	Balance	Factor	Payment	Interest	Principal	Balance	Factor	Payment	Interest	Principal	Balance	Factor	P&I Details for Security

FNM30	4	FNMAE0994	31419BC86	CL	9,960,832.02	55,336.14	9,383.14	45,953.00	2,768,988.68	0.27798769	73,834.47	9,597.26	64,237.21	2,814,941.69	0.28260106	74,256.47	9,812.08	64,444.39	2,879,178.89	0.28905004	36,472.26	9,900.65	26,571.62	2,943,623.29	0.29551982	P&I for FNMAE0994
FNM30	4	FNMAK3341	3138E7WB6	CL	1,587,007.00	1,698.51	983.42	715.09	294,311.62	0.18545074	1,698.22	985.80	712.42	295,026.71	0.18590133	1,697.95	988.16	709.79	295,739.14	0.18635024	2,833.01	994.29	1,838.72	296,448.92	0.18679749	P&I for FNMAK3341
FNM30	4	2				57,034.65	10,366.56	46,668.09	3,063,300.31		75,532.69	10,583.06	64,949.63	3,109,968.40		75,954.42	10,800.24	65,154.18	3,174,918.03		39,305.28	10,894.94	28,410.34	3,240,072.21

FNM30	4.5	FNM257121	31371NSJ5	CL	1,267,256.00	2,612.11	1,363.61	1,248.50	362,381.32	0.28595747	2,611.60	1,368.27	1,243.33	363,629.82	0.28694267	2,611.09	1,372.92	1,238.17	364,873.15	0.28792379	2,610.57	1,377.54	1,233.03	366,111.32	0.28890084	P&I for FNM257121
FNM30	4.5	FNM257219	31371NVL6	CL	6,522,403.72	401.57	56.60	344.97	14,748.98	0.00226128	401.43	57.89	343.54	15,093.95	0.00231417	401.27	59.17	342.10	15,437.49	0.00236684	401.12	60.45	340.67	15,779.59	0.00241929	P&I for FNM257219
FNM30	4.5	FNM257356	31371NZV0	CL	1,420,009.00	856.78	466.79	389.99	124,087.10	0.08738473	873.11	468.31	404.80	124,477.09	0.08765937	839.81	469.70	370.11	124,881.90	0.08794444	1,227.20	472.53	754.68	125,252.01	0.08820508	P&I for FNM257356
FNM30	4.5	FNM257569	31371PCE8	CL	1,000,000.00	349.05	197.06	151.99	52,396.02	0.05239602	348.95	197.62	151.33	52,548.01	0.05254801	348.88	198.19	150.69	52,699.34	0.05269934	348.80	198.75	150.05	52,850.03	0.05285003	P&I for FNM257569
FNM30	4.5	4				4,219.51	2,084.06	2,135.45	553,613.42		4,235.09	2,092.09	2,143.00	555,748.88		4,201.05	2,099.97	2,101.07	557,891.87		4,587.69	2,109.27	2,478.42	559,992.95

FNM30	5	FNM983077	31415LCN5	CL	75,612,525.00	36,900.20	8,273.30	28,626.90	1,956,965.57	0.0258815	41,884.92	8,412.77	33,472.15	1,985,592.47	0.0262601	44,009.14	8,560.47	35,448.66	2,019,064.62	0.02670278	78,601.38	8,851.10	69,750.29	2,054,513.28	0.0271716	P&I for FNM983077
FNM30	5	FNM983078	31415LCP0	CL	14,661,923.00	2,285.68	1,326.65	959.04	317,436.06	0.02165037	2,285.26	1,330.62	954.64	318,395.09	0.02171578	85,592.94	1,680.26	83,912.68	319,349.73	0.02178089	2,851.77	1,685.12	1,166.65	403,262.41	0.02750406	P&I for FNM983078
FNM30	5	FNMAC5447	31417SBR0	CL	5,281,770.00	11,463.11	1,043.55	10,419.56	240,033.52	0.04544566	8,980.76	1,076.49	7,904.27	250,453.08	0.0474184	4,606.84	1,091.14	3,515.70	258,357.36	0.04891492	14,274.90	1,145.84	13,129.05	261,873.06	0.04958055	P&I for FNMAC5447
FNM30	5	3				50,649.00	10,643.50	40,005.50	2,514,435.15		53,150.95	10,819.88	42,331.06	2,554,440.64		134,208.92	11,331.87	122,877.05	2,596,771.71		95,728.05	11,682.06	84,045.99	2,719,648.76

FNM30	5.5	FNM983079	31415LCQ8	CL	2,525,722.00																					P&I for FNM983079
FNM30	5.5	FNM983080	31415LCR6	CL	1,266,463.00	378.34	207.05	171.29	45,003.36	0.03553468	378.27	207.83	170.44	45,174.65	0.03566993	378.21	208.61	169.60	45,345.09	0.03580451	378.53	209.38	169.15	45,514.69	0.03593843	P&I for FNM983080
FNM30	5.5	2				378.34	207.05	171.29	45,003.36		378.27	207.83	170.44	45,174.65		378.21	208.61	169.60	45,345.09		378.53	209.38	169.15	45,514.69

FNM30	6	FNM751406	31403KYB3	CL	500,000.00	601.60	315.07	286.53	62,728.36	0.12545671	601.54	316.50	285.04	63,014.88	0.12602976	601.48	317.92	283.56	63,299.92	0.12659984	601.42	319.33	282.10	63,583.48	0.12716696	P&I for FNM751406
FNM30	6	FNM837593	31407QRN8	CL	1,000,000.00	949.21	522.90	426.31	104,153.38	0.10415338	949.09	525.02	424.07	104,579.69	0.10457969	948.97	527.13	421.84	105,003.76	0.10500376	948.07	529.22	418.85	105,425.60	0.1054256	P&I for FNM837593
FNM30	6	2				1,550.81	837.97	712.83	166,881.74		1,550.63	841.52	709.11	167,594.57		1,550.45	845.05	705.40	168,303.68		1,549.50	848.55	700.95	169,009.08

FNM30	6.5	FNM825007	31407AR45	CL	1,000,000.00																					P&I for FNM825007
FNM30	6.5	FNM893961	31410QFA4	CL	1,000,000.00																					P&I for FNM893961
FNM30	6.5	FNM955986	31413URF8	CL	1,000,000.00	377.36	213.01	164.35	39,161.09	0.03916109	47,568.91	468.14	47,100.77	39,325.44	0.03932544	760.45	469.72	290.73	86,426.21	0.08642621	778.44	471.38	307.06	86,716.94	0.08671694	P&I for FNM955986
FNM30	6.5	3				377.36	213.01	164.35	39,161.09		47,568.91	468.14	47,100.77	39,325.44		760.45	469.72	290.73	86,426.21		778.44	471.38	307.06	86,716.94

FNM30	7	FNM350001	31376AX60	CL	1,000,000.00	89.66	28.53	61.13	4,829.52	0.00482952	89.62	28.88	60.74	4,890.65	0.00489065	89.60	29.24	60.36	4,951.39	0.00495139	89.54	29.58	59.96	5,011.75	0.00501175	P&I for FNM350001
FNM30	7	FNM350005	31376AYA0	CL	1,000,000.00																					P&I for FNM350005
FNM30	7	FNM350006	31376AYB8	CL	1,000,000.00																					P&I for FNM350006
FNM30	7	3				89.66	28.53	61.13	4,829.52		89.62	28.88	60.74	4,890.65		89.60	29.24	60.36	4,951.39		89.54	29.58	59.96	5,011.75

FNM30	8.5	FNM350002	31376AX78	CL	1,000,000.00	150.65	56.80	93.85	7,925.35	0.00792535	150.63	57.46	93.17	8,019.20	0.0080192	150.61	58.12	92.49	8,112.37	0.00811237	150.59	58.77	91.82	8,204.86	0.00820486	P&I for FNM350002
FNM30	8.5	1				150.65	56.80	93.85	7,925.35		150.63	57.46	93.17	8,019.20		150.61	58.12	92.49	8,112.37		150.59	58.77	91.82	8,204.86

TOTAL		20				114,449.99	24,437.49	90,012.50	6,395,149.93		182,656.80	25,098.87	157,557.92	6,485,162.43		217,293.69	25,842.81	191,450.89	6,642,720.35		142,567.62	26,303.94	116,263.68	6,834,171.23

While viewing in Spreadsheet format, use your browser's 'Save As' function to save the data to a file with the extention '.csv', and then open that file in your favorite spreadsheet program.

Demonstration Tour