Instructions: These are corporate bonds that pay coupons semi-annually. Bond data below was taken at 7/8/20 at 11 AM. Write a code in RStudio to determine the Yield of the investment if you were to buy each bond on 7/8/20 at 11 AM.

Bond	Company Name	Maturity	Ratings	Ask Size	Bid	Ask	Industry	Sector	Category
RCL CORP 7.5 IBCID29209607	Royal Caribbean Cruises Ltd	Oct15'27	BA2/BB (MOODY/SP)	1500000	79.1	81.5	Leisure Time	Consumer, Cyclical	Cruise Lines
SWN CORP 7.75 IBCID288865258	Southwestern Energy Co	Oct01'27	BA3/BB- (MOODY/SP)	53000	89.25	90.625	Oil&Gas	Energy	Oil Comp-Explor&Prodtn
MBI CORP 7.15 IBCID29198621	MBIA Inc	Jul15'27	BA3/NR (MOODY/SP)	150000	84.5	88	Insurance	Financial	Financial Guarantee Ins
PEMEX CORP 9.5 IBCID64890212	Petroleos Mexicanos	Sep15'27	BA2/BBB (MOODY/SP)	100000	101.155	105.79	Oil&Gas	Energy	Oil Comp-Integrated
CC CORP 5.375 IBCID276163091	Chemours Co/The	May15'27	B1/B (MOODY/SP)	300000	91.54	93.6	Chemicals	Basic Materials	Chemicals-Specialty
SCI CORP 7.5 IBCID64890499	Service Corp International/US	Apr01'27	BA3/BB (MOODY/SP)	100000	113	120.45	Commercial Services	Consumer, Non-cyclical	Funeral Serv&Rel Items
BACR CORP 3.25 IBCID296544511	Barclays Bank PLC	Nov24'27	A1/A (MOODY/SP)	5000	103.1	110	Banks	Financial	Commer Banks Non-US
VMW CORP 4.65 IBCID415978711	VMware Inc	May15'27	BAA2/BBB- (MOODY/SP)	150000	110.7	111.479	Software	Technology	Software Tools
TCP CORP 3.9 IBCID277274296	TC PipeLines LP	May25'27	BAA2/BBB (MOODY/SP)	100000	104.205	106.918	Pipelines	Energy	Pipelines
DXC CORP 4.75 IBCID284546730	DXC Technology Co	Apr15'27	BAA2/BBB- (MOODY/SP)	7000	111.328	111.993	Computers	Technology	Computer Services
KZOKZ CORP 4.75 XS1595713782	KazMunayGas National Co	Apr19'27	BAA3/BB (MOODY/SP)	200000	108.32	112.38	Oil&Gas	Energy	Oil Comp-Integrated
VMW CORP 3.9 IBCID285991232	VMware Inc	Aug21'27	BAA2/BBB- (MOODY/SP)	18000	106.7	107.321	Software	Technology	Software Tools
AXS CORP 4.0 IBCID298404184	AXIS Specialty Finance PLC	Dec06'27	BAA1/A- (MOODY/SP)	3000	106.033	108.343	Insurance	Financial	Reinsurance
INRCIN CORP 3.835 XS1733877762	Indian Railway Finance Corp Ltd	Dec13'27	BAA3/BBB- (MOODY/SP)	200000	103.72	107.58	Transportation	Industrial	Transport-Rail
STJSPH CORP 4.584 IBCID290054346	St Joseph's Hospital & Medical Center/NJ	Jul01'27	BAA3/BBB- (MOODY/SP)	500000	103.85	112.144	Commercial Services	Consumer, Non-cyclical	Non-Profit Charity
GE CORP 3.45 IBCID417231253	General Electric Co	May01'27	BAA1/BBB+ (MOODY/SP)	500000	104.233	104.775	Miscellaneous Manufactur	Industrial	Diversified Manufact Op
VRSN CORP 4.75 IBCID288386294	VeriSign Inc	Jul15'27	BA1/BBB- (MOODY/SP)	2000	105.707	106.365	Internet	Communications	Web Hosting/Design
KZTGKZ CORP 4.375 XS1682544157	KazTransGas JSC	Sep26'27	BAA3 (MOODY)	200000	107.32	111.43	Pipelines	Energy	Pipelines
TFX CORP 4.625 IBCID296544307	Teleflex Inc	Nov15'27	BA3/BB (MOODY/SP)	100000	105.92	106.722	Healthcare-Products	Consumer, Non-cyclical	Disposable Medical Prod
BANCOG CORP 4.125 USP12651AB49	Banco General SA	Aug07'27	BAA2/BBB+ (MOODY/SP)	200000	105.22	109.58	Banks	Financial	Commer Banks Non-US
HRC CORP 4.375 USU43295AC52	Hill-Rom Holdings Inc	Sep15'27	BA3/BB (MOODY/SP)	500000	101.4	105.87	Healthcare-Products	Consumer, Non-cyclical	Medical Products
CHTR CORP 5.875 USU12501AM14	CCO Holdings LLC / CCO Holdings Capital Corp	May01'27	B1/BB (MOODY/SP)	259000	103.45	105.51	Media	Communications	Cable/Satellite TV
TT CORP 6.443 IBCID29156277	Ingersoll-Rand Co	Nov15'27	BAA2/BBB (MOODY/SP)	1000	122.326	125.9255	Miscellaneous Manufactur	Industrial	Diversified Manufact Op
CNQCN CORP 3.85 IBCID277355328	Canadian Natural Resources Ltd	Jun01'27	BAA2/BBB (MOODY/SP)	250000	107.3989	107.926	Oil&Gas	Energy	Oil Comp-Explor&Prodtn
PRXNA CORP 4.85 USN5946FAD98	Prosus NV	Jul06'27	BAA3/BBB- (MOODY/SP)	500000	111.214	114.27	Internet	Communications	Internet Content-Info/Ne
PSD CORP 7.02 IBCID29209919	Puget Sound Energy Inc	Dec01'27	A2/A- (MOODY/SP)	18000	124.762	130.18	Electric	Utilities	Electric-Integrated