Attachment A - InvestmentDetailSourceDataExample.xlsx

XLSX spreadsheet 11 KB Posted Jan 24, 2020

Attached to: FINANCIAL REPORTING AND BUSINESS INTELLIGENCE TOOL WITH INTEGRATED GOVERNANCE, RISK MANAGEMENT, AND COMPLIANCE CAPABILITIES
Solicitation number: FCSIC2020-01
Issued by: Farm Credit Administration

View the file

Other files

File	Type	Posted
Amended SOW GRC and BI Solicitation Jan 2020 with Track Changes .pdf	PDF	Jan 24, 2020
Attachment C - BankDataSourceDataExample.pdf	PDF	Jan 24, 2020
Requirements Response Sheet.xlsx	XLSX spreadsheet	Jan 24, 2020
Attachment B - FinancialStatementandTBSourceDataExample.xlsx	XLSX spreadsheet	Jan 24, 2020
Q and A from vendors - 1-24-2020.pdf	PDF	Jan 24, 2020
FCSIC SOW GRC and BI Solicitation - Jan 2020.pdf	PDF	Jan 6, 2020
FCSIC SOW - Appendix A - Day 1 Reports - Jan 2020.pdf	PDF	Jan 6, 2020

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Attachment A - InvestmentDetail

Account Description	Security Description	Security Number	Memo Number	Purchase Date	Shares/Par	Initial Discount	Initial Premium	Cost	Market Value	Amortization	Inflation Compensation	Accrued Interest	Yield to Maturity	Coupon Rate	Maturity Date
Company Name	MK NOTE 2.000% 01/31/2020	122254	132323	08/01/2018	80184729.65	-689087.52	0	79495642.13	80209787.38	650882.09	0	666753.46	2.5888586	2	01/31/2020
Company Name	MK NOTE 2.375% 04/30/2020	122254	132333	07/26/2018	141846301.1	-642741.05	0	141203560	142200916.8	520322.58	0	564559.97	2.6396521	2.375	04/30/2020
Company Name	MK NOTE 2.875% 11/15/2021	122254	132343	10/22/2019	199488028.9	0	5018370.73	204506399.6	204163529.6	-465087.56	0	724788.24	1.6313133	2.875	04/30/2020
Company Name	MK NOTE 2.500% 01/31/2021	122254	132353	11/19/2019	100226294.2	0	1017923.3	101244217.5	101134595	-98378.5	0	1041754.28	1.6406641	2.5	01/31/2020
Company Name	MK TIPS 0.125% 01/15/2022	122254	132363	05/24/2012	75000000	0	4054062.66	79054062.66	85243103.2	-3210986.58	10269750	48949.01	-0.4235974	0.125	04/30/2021
Company Name	ONE DAY 1.510% 01/02/2020	122254	132373	12/31/2019	103208184.9	0	0	103208184.9	103208184.9	0	0	0	1.5099984	1.51	07/31/2020
	Total				699953538.8	-1331828.57	10090356.69	708712066.8	716160116.9	-2603247.97	10269750	3046804.96

File details come from the government source that posted it. Updated Jan 25, 2020.