In Progress

Do calculations to solve the question - using the information provided

I have a data analysis task. Part II: Bonds

1. Municipal Bonds - Municipal bonds are haircut per Exhibit 1 based on both their time to maturity and scheduled maturity at date of issue. The bond details can be found on the Bonds & Ratings Information tab in the spreadsheet.

2. Corporate Bonds - Corporate bonds are haircut based on both their time to maturity and whether they are rated as investment grade (defined by S&P and Fitch as BBB- and above and by Moody's as Baa3 and above) by at least two of the nationally recognized statistical rating organizations. If the bonds qualify as investment grade, use Exhibit 2 to determine the haircut of the bonds. If they do not qualify as investment grade, then they are considered non-marketable and follow the haircut rules as stated in Exhibit 3.

It is important to note that the haircut is calculated using the absolute value of the market value of the relevant bond.

What is the total haircut in USD on the positions in the accompanying spreadsheet?

Skills: Accounting, Finance, Mathematics

See more: when to use begin mode on financial calculator, financial calculator begin end mode, how to use financial calculator sharp el-738, how to use a financial calculator hp 10bii, how to use financial calculator to calculate pv, when to use bgn mode, how to use financial calculator to calculate fv, how to use financial calculator ba ii plus present value, why do we use graphs to represent data, why do we use data structures, what does a data entry specialist do, what does a data entry person do, what does a data entry clerk do, what do data entry clerks do, data entry data operator computer operator back office non voice wpm typing

About the Employer:
( 0 reviews ) Ilford, United Kingdom

Project ID: #14417272

Awarded to:

charleslimnet

I possess exceptional Accounting and Finance skills. I hold MBA (Strategic Management) [url removed, login to view] (Finance and Marketing) & CPA.K (Accounting and Finance.) I have successfully completed over 2000 related projects and the re More

£50 GBP in 1 day
(133 Reviews)
6.2

8 freelancers are bidding on average £41 for this job

£166 GBP in 1 day
(33 Reviews)
6.1
Dianarises

Stay tuned, I'm is still working on this proposal.

£18 GBP in 1 day
(0 Reviews)
0.0
samnjoro781

A proposal has not yet been provided

£18 GBP in 1 day
(0 Reviews)
0.0
£18 GBP in 1 day
(0 Reviews)
0.0
suiluap

Hi, if you sent me the exhibits and the spreadsheet, I could take a look. Doesn't sound too complicated at the moment. Relevant Skills and Experience Know a little about debt instruments. Proposed Milestones £20 GBP More

£20 GBP in 1 day
(0 Reviews)
0.0
£23 GBP in 1 day
(0 Reviews)
0.0
kreativeapostle

kindly consider my application for the task

£13 GBP in 1 day
(0 Reviews)
2.1