The file named Nancybonds.xlsx gives the bond rating for several bonds in a previous and future month.
Question:
The file named Nancybonds.xlsx gives the bond rating for several bonds in a previous and future month. You want to efficiently count how many bonds were downgraded. Unfortunately, each company is listed in more than one row. Assuming you have sorted the data on the company name, how would you determine the number of downgraded bonds?
Transcribed Image Text:
F22 Clipboard A 1. 2 Bond ID 3 111013ADO 4 111013AB4 5 111013AA6 313917AF3 7 46062RAG3 6 8 46062RAH1 9 681936AK6 10 681936AJ9 11 81234PAF9 12 817565AJ3 13 723686AA9 Paintin F 32 33 ISSUER ID BSY BSY BSY FCH IPX IPX OHI OHI S SRV PHB fr B AAB AAB Font C company BRITISH SKY BROADCAST BRITISH SKY BROADCAST BRITISH SKY BROADCAST FELCOR SUITES INTERPOOL INC INTERPOOL INC OMEGA HEALTHCARE OMEGA HEALTHCARE SPRINT NEXTEL CORP SERVICE CORP INTL 20 among 8 issuers, there are 6 issuer who get downgrade 21 there are 1 issuer who get upgrade Alignment PIONEER HY-BRED INTL IN ABN-AMRO BANK ABN-AMRO BANK 14 00077QAA8 15 00077DAF6 16 17 18 Try to determine how many company whose rating was changed by "Standard and Poor" 19 In this case, there are 8 issuers 26 I use contif and put a if function in it but it does not work out 27 28 29 30 31 D 24 I have thousands thousands of this kind of bond id in the database by month 25 Last month Score Score now 22 Goal 23 How do I write a formula to see how many issuers are upgrade or downgrade (by month)? 10 10 10 12 12 12HH72444 54 E Number 9 9 11 11 11 13 13 G Score change downgrade 6 10 5 F 44 19 OO Styles H
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 85% (7 reviews)
Answered By
Benard Ndini Mwendwa
I am a graduate from Kenya. I managed to score one of the highest levels in my BS. I have experience in academic writing since I have been working as a freelancer in most of my time. I am willing to help other students attain better grades in their academic portfolio. Thank you.
4.90+
107+ Reviews
240+ Question Solved
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Question Posted:
Students also viewed these Business questions
-
Consider a problem of simple linear regression in which the durability Y of a certain type of alloy is to be related to the temperature X at which it was produced. Suppose that the eight pairs of...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
How do recruitment and selection practices contribute to high performance in an organization?
-
Handi Inc., a cell phone manufacturer, procures a standard display from LCD Inc. via an options contract. At the start of quarter 1 (Q1), Handi pays LCD $4.50 per option. At that time, Handi's...
-
Calculate the continuation value of KMS using your reproduction of Table 18.8 from Problem 14, and assuming an EBITDA multiple of8.5. Year Income Statement ($000s) Sales Costs Except Depreciation...
-
In 2009, the administration of President Obama instituted a so-called Cash for Clunkers program. You are to evaluate the effectiveness of the program, which was intended to stimulate the economy and...
-
Minnesota Office Products (MOP) produces three different paper products at its Vaasa lumber plant: Supreme, Deluxe, and Regular. Each product has its own dedicated production line at the plant. It...
-
Adams Educational Services had budgeted its training service charge at $72 per hour. The company planned to provide 34,000 hours of training services during Year 3. By lowering the service charge to...
-
A 2 4 factorial design was run in a chemical process. The design factors are A = time, B = concentration, C = pressure, and D = temperature. The response variable is yield. The data follow: (a)...
-
Martin Luther King Day occurs on the third Monday in January. Write a formula that computes (given the year) the date of Martin Luther King Day. First determine the day of the week for January 1 of...
-
The file named Addresses.xlsx gives peoples names on one line, their street address on the next line, and their city, state, and zip code on the following line. How could you put each persons...
-
The tied three-hinged arch is subjected to the loading shown. Determine the components of reaction at A and C and the tension in the cable. 15 kN 10 kN 2 m -1 m-| -2 m -2 m- 0.5 m
-
A project has been selected for implementation. The net cash flow (NCF) profile associated with the project is shown below. MARR is 10 percent/year. a. What is the internal rate of return of this...
-
Match the measures of worth in the first column with the appropriate unit of measure that results from the analysis. Measure of Worth (a) Annual Worth (b) External Rate of Return (c) Future Worth (d)...
-
True or False: If \(\operatorname{IRR}(\mathrm{A})>\operatorname{IRR}(\mathrm{B})\), then \(\operatorname{ERR}(\mathrm{A})>\operatorname{ERR}(\mathrm{B})\).
-
An investment is guaranteed to have a unique value of IRR if which of the following is true? a. Alternating positive and negative cash flows b. An initial negative cash flow followed by all positive...
-
Consider the following cash flow profile, and assume MARR is 10 percent/year and the finance rate is 4 percent/year. a. Determine the MIRR for this project. b. Is this project economically...
-
Can any low enough backup pressure generate an isentropic supersonic flow?
-
5. Convert the following ERD to a relational model. SEATING RTABLE Seating ID Nbr of Guests Start TimeDate End TimeDate RTable Nbr RTable Nbr of Seats RTable Rating Uses EMPLOYEE Employee ID Emp...
-
For years, the drug Vioxx, developed and marketed by Merck, was one of the blockbuster drugs on the market. One of a number of so-called Cox-2 anti-inflammatory drugs, Vioxx was considered by many...
-
Explore the relationship between the selling prices (Y) and the appraised values (X) of the 148 homes in the file P02_11.xlsx by estimating a simple linear regression model. Interpret the standard...
-
The file P02_10.xlsx contains midterm and final exam scores for 96 students in a corporate finance course. Each row contains the two exam scores for a given student, so you might expect them to be...
-
What are the expected earnings and revenue of mobile carwashes? What competition exists today? What competition could enter the market? What barriers are there to market entry? How much investment is...
-
1) What recommendations would you give to one another so that each of you will have a great job onboarding into the organization? 2) What are four things you could do to learn more about an...
-
Describe Jeff Bezos and his most important actions and achievements. Analyze Jeff Bezos personality using the big 5 traits learned in class. Analyze Jeff Bezos style of the leader using 2 theories...
Study smarter with the SolutionInn App