[SOLVED] Excel Functions (Date, Conditional, Text-to-Column, etc), VBA (macro recorders, Loop) – Business Finance

by | Aug 28, 2022 | Business Finance

Please finish the following excel file in 2 hours. The problem sets instructions are listed in text boxes.Please also consider the following:⁃ Professional format and presentation are always important. ⁃ You should not include modules that do not have any code in it. ⁃ Do not include subroutines that are not relevant to the assignment (delete any subroutines you have used for testing). ⁃ Also, make sure to name your module/s and subroutines appropriately.⁃ Make sure that all your subroutines are located in dedicated module/s. Do not delete or add additional modules.⁃ The efficiency of your VBA code will be taken into consideration. Make sure you apply the efficiency methods we have learned in class. Make sure that your code is ‘clean’ (clear and well-organized), and properly indented.⁃ Do not delete/add or rename the sheets in the midterm final excel file submission.- Make sure to double-check your work for any errors before submission.This is a statement about doing all the work yourself. Before you
begin, you have to sign the statement with your full name and date
it.
I your name here, hereby declare that all answers provided in this
assignment are the result of my work alone. I have not used the
work and/or help of other students or other persons, any methods
to cheat, or any other form of academic dishonesty. I fully
understand that if I engage in any form of academic dishonesty, I
may receive a failing grade for the course and will be a subject to
additional penalties by the University.
Signed by:
Date:
Time:
TABLE 39: REGULATORY CAPITAL STRUCTURE AND RELATED REGULATORY CAPITAL RATIOS
State Street
State Street Bank
(In millions)
Basel III Advanced Approaches
Basel III
December
Standardized
31, 2018
Approach
Basel IIIDecember
Advanced31,
Appr
20
Common shareholders’ equity:
Common stock and related surplus$
10,565
$
Retained earnings
20,606
Accumulated other comprehensive(1,332
income (loss))
20,606
(1,332
)
Treasury stock, at cost
(8,715
(8,715
)
)
Total
21,124
21,124
Regulatory capital adjustments:
Goodwill and other intangible assets,
(9,350
net of associated
)
deferred tax liabilities(1)
(9,350
)
Other adjustments(2)
(194
)
(194
)
CET1 capital
11,580
11,580
Preferred stock
3,690
3,690
Trust preferred capital securities subject
—
to phase-out from tier 1 capital
—
—
—
Other adjustments
Tier 1 capital
Qualifying subordinated long-term debt
15,270
15,270
778
778
Trust preferred capital securities phased
—
out of tier 1 capital
ALLL and other
—
14
83
Other adjustments
—
Total capital
RWA:
$
16,062
$
Credit risk(3)
$
47,738
$
Operational risk(4)
46,060
Market risk
Total RWA
—
NA
1,517
$
1,517
95,315
$
Total RWA
$
Adjusted quarterly average assets
$
95,315
$
211,924
$
Problem 1- Data_CleanUp:
1.Clean up the data using the find and replace, and go to special (F5) tools.
Note: You will need to make some changes by hand to make the results look exactly as on the picture. Attention
to detail is important.
The final results should look exactly as the picture below:
2. In CELL B35, create a Data Validation List with the respective data column headers.
3. In CELL A36, create a Data Validation List with the respective data row headers
4. Name the range B6:I33, “STT_Data”.
5. In CELL B36, create a function that brings up a value from your data range based on the values in CELLS B35
and A36.
6. Create and apply the following Conditional Formatting rules:
Fill orange – the cell containing the value based on step 5
Fill light orange – the row containing the value based on step 5
Fill light orange – the column containing the value based on step 5
TAL RATIOS
Basel III Standardized Approach
Basel IIIDecember
Advanced31,
Approaches
2017Basel III
December
Standardized
31, 2018-b
Approach December
10,565
$
10,302
18,856
18,856
(972
)
(972
)
(9,029
)
(9,029
)
19,157
(6,877
(76
19,157
)
)
(6,877
(76
)
)
12,204
12,204
3,196
3,196
—
—
(18
)
(18
)
15,382
15,382
980
980
—
—
4
72
1
1
16,131
$
16,367
97,303
$
52,000
45,822
NA
1,334
98,820
1,334
$
99,156
Attention
n CELLS B35
98,820
$
99,156
211,924
$
209,328
Basel III Advanced Approaches
Basel III
December
Standardized
31, 2017-b
Approach December 31, 2017-b
$
10,302
$
12,894
14,261
(1,112
)
14,261
(1,112
)
(809
—
—
—
26,043
(9,073
(29
12,312
26,043
)
)
(9,073
(29
16,941
23,115
)
)
(6,579
(5
16,941
16,531
—
—
—
—
—
—
—
—
—
16,941
16,941
16,531
776
776
983
—
—
11
—
—
83
—
—
—
$
16,435
$
17,728
$
101,349
$
45,565
44,494
NA
1,517
$
45,295
1,517
102,683
1,334
$
91,576
$
102,683
$
91,576
$
209,328
$
209,413
$
12,894
$
11,612
12,312
)
(809
)
—
23,115
)
)
(6,579
(5
)
)
16,531
—
—
—
16,531
983
—
72
—
$
17,800
$
17,514
$
94,776
$
49,489
$
96,118
NA
1,334
$
96,293
$
96,293
$
96,118
$
209,413
$
206,070
$
11,612
$
17,586
$
98,433
$
99,767
$
99,767
$
206,070
High Stores
12 Low Street
Boston
MA, 02115
Company Name Address
8883562265
Low Stores Inc.
21 High Street Apt. 1B
Woburn
MA, 01801
8882312266
Middle Stores LLC
33 Side Street
Brighton
MA, 02134
8005632264
Large Stores
13 Center Street
Boston
MA, 02116
8003062265
Small Shops Inc.
33 Very High Street Apt. 1C
Gloucester
MA, 01930
8003212266
Wind Stores LLC
44 Blueberry Street
Rock Port
MA, 02134
8886002264
High Stores 1
13 Low Street
Boston
MA, 02115
8883562266
Low Stores Inc.
22 High Street Apt. 1B
Woburn
MA, 01801
8882312267
Middle Stores 1 LLC
34 Side Street
Brighton
MA, 02134
8005632265
Large Stores
14 Center Street
Boston
MA, 02116
8003062266
Small Shops Inc.
34 Very High Street Apt. 1C
Gloucester
MA, 01930
8003212267
Wind Stores LLC
45 Blueberry Street
Rock Port
MA, 02134
8886002265
City
State
ZIP
Phone
Problem 2 – Transpose data using formulas:
Create a formula to concatenate and transpose data.
Use text-to-column to un-concatenate. Format the results
1. In Range C1:C60, create a formula that concatenates the
into one cell using comma (,) as a separator, when the active
When the active cell is not on the same row as the company
2. Enter the formula down in all cells to C60.
3. Copy the results of your formula (Copy Range C1:C60), sel
– DO not delete the formulas from C1:C60 – I need to check f
4. With current selection, delete all cells (move cells up) tha
5. Use the Text-To-Columns function to separate the cell dat
6. Add corresponding column headers are provided
7. Format ZIP codes as ZIP codes: “00000” (zip codes start w
numbers: “[ Transpose with array:
emory and then load the values in the sheet all at once.
3) as a table named: “AAPL_Bonds_Data”.
ginal Column A (shift cells to left).
the text box.
on to execute the Macro (name it “Transpose”).
on over CELL L1.
ing off the Application Screen Updating.
the end of your code.
testing but make sure to delete any duplicates after you are done
w for how the final results should look like.
Issuer Name
Symbol
Callable
Sub-Product Type
Coupon
Maturity
Moody’s®
S&P
Price
Yield
Callable
APPLE INC
AAPL4336432
Yes
Corporate Bond
1.3
2/23/2018
Aa1
AA+
100.12
0.991
APPLE INC
AAPL4001806
Yes
Corporate Bond
1
5/3/2018
Aa1
AA+
99.836
1.283
APPLE INC
AAPL4001811
Corporate Bond
1.561
5/3/2018
Aa1
AA+
100.142
APPLE INC
AAPL4452438
Yes
Corporate Bond
1.55
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
Moody
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
Yield
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
Callable
Moody
Yield
2/8/2019
Aa1
AA+
100.065
1.501
APPLE INC
AAPL4452430
Corporate Bond
1.392
2/8/2019
Aa1
AA+
100.098
APPLE INC
AAPL4336439
Corporate Bond
2.134
2/22/2019
Aa1
AA+
101.395
APPLE INC
AAPL4336438
Yes
Corporate Bond
1.7
2/22/2019
Aa1
AA+
100.259
1.51
APPLE INC
AAPL4122387
Yes
Corporate Bond
2.1
5/6/2019
Aa1
AA+
100.839
1.564
APPLE INC
AAPL4122391
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
Corporate Bond
1.612
5/6/2019
Aa1
AA+
100.125
APPLE INC
AAPL4389214
Corporate Bond
1.453
8/2/2019
Aa1
AA+
100.186
APPLE INC
AAPL4389210
Yes
Corporate Bond
1.1
8/2/2019
Aa1
AA+
99.186
1.552
APPLE INC
AAPL4538815
Corporate Bond
1.5
9/12/2019
AA+
99.805
1.602
APPLE INC
AAPL4452431
Corporate Bond
1.512
2/7/2020
Aa1
AA+
100.273
APPLE INC
AAPL4452433
Yes
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
Corporate Bond
1.9
2/7/2020
Aa1
AA+
100.365
1.74
APPLE INC
AAPL4208636
Corporate Bond
1.561
2/7/2020
Aa1
AA+
100.423
APPLE INC
AAPL4208638
Yes
Corporate Bond
1.55
2/7/2020
Aa1
AA+
99.686
1.687
APPLE INC
AAPL4242663
No
Corporate Bond
1.609
5/6/2020
Aa1
AA+
100.564
APPLE INC
AAPL4242668
Yes
Corporate Bond
2
5/6/2020
Aa1
AA+
100.567
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
1.775
APPLE INC
AAPL4492959
Corporate Bond
1.379
5/11/2020
Aa1
AA+
100.131
APPLE INC
AAPL4492958
Yes
Corporate Bond
1.8
5/11/2020
Aa1
AA+
100.08
1.768
APPLE INC
AAPL4336435
Yes
Corporate Bond
2.25
2/23/2021
Aa1
AA+
101.768
1.698
APPLE INC
AAPL4336437
No
Corporate Bond
2.444
2/23/2021
Aa1
AA+
102.829
APPLE INC
AAPL4122392
Yes
Corporate Bond
2.85
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
5/6/2021
Aa1
AA+
102.941
1.997
APPLE INC
AAPL4389212
Yes
Corporate Bond
1.55
8/4/2021
Aa1
AA+
98.259
2.024
APPLE INC
AAPL4452434
Yes
Corporate Bond
2.5
2/9/2022
Aa1
AA+
101.363
2.164
APPLE INC
AAPL4208635
Yes
Corporate Bond
2.15
2/9/2022
Aa1
AA+
99.928
2.167
APPLE INC
AAPL4452432
Corporate Bond
1.811
2/9/2022
Aa1
AA+
101.156
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
APPLE INC
AAPL4492954
Corporate Bond
1.659
5/11/2022
Aa1
AA+
100.772
APPLE INC
AAPL4492955
Yes
Corporate Bond
2.3
5/11/2022
Aa1
AA+
100.639
2.151
APPLE INC
AAPL4242669
Yes
Corporate Bond
2.7
5/13/2022
Aa1
AA+
102.182
2.2
APPLE INC
AAPL4538813
Yes
Corporate Bond
2.1
9/12/2022
Aa1
AA+
99.27
2.257
APPLE INC
AAPL4336434
Yes
Corporate Bond
2.85
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
2/23/2023
Aa1
AA+
102.474
2.344
APPLE INC
AAPL4001809
Yes
Corporate Bond
2.4
5/3/2023
Aa1
AA+
99.859
2.427
APPLE INC
AAPL4452439
Yes
Corporate Bond
3
2/9/2024
Aa1
AA+
102.421
2.574
APPLE INC
AAPL4122390
Yes
Corporate Bond
3.45
5/6/2024
Aa1
AA+
104.913
2.633
APPLE INC
AAPL4492960
Yes
Corporate Bond
2.85
5/11/2024
Aa1
AA+
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
101.491
2.597
APPLE INC
AAPL4208641
Yes
Corporate Bond
2.5
2/9/2025
Aa1
AA+
100.071
2.489
APPLE INC
AAPL4242665
Yes
Corporate Bond
3.2
5/13/2025
Aa1
AA+
102.951
2.767
APPLE INC
AAPL4336441
Yes
Corporate Bond
3.25
2/23/2026
Aa1
AA+
103.934
2.708
APPLE INC
AAPL4389208
Yes
Corporate Bond
2.45
8/4/2026
Aa1
AA+
96.62
2.886
APPLE INC
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
AAPL4452435
Yes
Corporate Bond
3.35
2/9/2027
Aa1
AA+
103.328
2.931
APPLE INC
AAPL4492956
Yes
Corporate Bond
3.2
5/11/2027
Aa1
AA+
101.818
2.976
APPLE INC
AAPL4507383
Yes
Corporate Bond
3
6/20/2027
Aa1
AA+
100.13
2.984
APPLE INC
AAPL4538816
Yes
Corporate Bond
2.9
9/12/2027
Aa1
AA+
99.018
3.015
APPLE INC
AAPL4336436
Yes
Corporate Bond
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
4.5
2/23/2036
Aa1
AA+
112.611
3.542
APPLE INC
AAPL4001810
Yes
Corporate Bond
3.85
5/4/2043
Aa1
AA+
101.733
3.744
APPLE INC
AAPL4122386
Yes
Corporate Bond
4.45
5/6/2044
Aa1
AA+
110.566
3.814
APPLE INC
AAPL4208639
Yes
Corporate Bond
3.45
2/9/2045
Aa1
AA+
94.834
3.754
APPLE INC
AAPL4242667
Yes
Corporate Bond
4.375
5/13/2045
Aa1
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
AA+
109.216
3.831
APPLE INC
AAPL4336433
Yes
Corporate Bond
4.65
2/23/2046
Aa1
AA+
113.62
3.849
APPLE INC
AAPL4377623
Corporate Bond
4.15
6/22/2046
APPLE INC
AAPL4389215
Yes
Corporate Bond
3.85
8/4/2046
Aa1
AA+
101.25
3.778
APPLE INC
AAPL4452437
Yes
Corporate Bond
4.25
2/9/2047
Aa1
AA+
107.473
3.82
APPLE INC
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
AAPL4538814
Yes
Corporate Bond
3.75
9/12/2047
Aa1
AA+
99.46
3.78
APPLE INC
AAPL4336432
Yes
Corporate Bond
1.3
2/23/2018
Aa1
AA+
100.12
0.991
APPLE INC
AAPL4001806
Yes
Corporate Bond
1
5/3/2018
Aa1
AA+
99.836
1.283
APPLE INC
AAPL4001811
Corporate Bond
1.561
5/3/2018
Aa1
AA+
100.142
APPLE INC
AAPL4452438
Yes
Corporate Bond
1.55
2/8/2019
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
Aa1
AA+
100.065
1.501
APPLE INC
AAPL4452430
Corporate Bond
1.392
2/8/2019
Aa1
AA+
100.098
APPLE INC
AAPL4336439
Corporate Bond
2.134
2/22/2019
Aa1
AA+
101.395
APPLE INC
AAPL4336438
Yes
Corporate Bond
1.7
2/22/2019
Aa1
AA+
100.259
1.51
APPLE INC
AAPL4122387
Yes
Corporate Bond
2.1
5/6/2019
Aa1
AA+
100.839
1.564
APPLE INC
AAPL4122391
Corporate Bond
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
1.612
5/6/2019
Aa1
AA+
100.125
APPLE INC
AAPL4389214
Corporate Bond
1.453
8/2/2019
Aa1
AA+
100.186
APPLE INC
AAPL4389210
Yes
Corporate Bond
1.1
8/2/2019
Aa1
AA+
99.186
1.552
APPLE INC
AAPL4538815
Corporate Bond
1.5
9/12/2019
AA+
99.805
1.602
APPLE INC
AAPL4452431
Corporate Bond
1.512
2/7/2020
Aa1
AA+
100.273
APPLE INC
AAPL4452433
Yes
Corporate Bond
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
1.9
2/7/2020
Aa1
AA+
100.365
1.74
APPLE INC
AAPL4208636
Corporate Bond
1.561
2/7/2020
Aa1
AA+
100.423
APPLE INC
AAPL4208638
Yes
Corporate Bond
1.55
2/7/2020
Aa1
AA+
99.686
1.687
APPLE INC
AAPL4242663
No
Corporate Bond
1.609
5/6/2020
Aa1
AA+
100.564
APPLE INC
AAPL4242668
Yes
Corporate Bond
2
5/6/2020
Aa1
AA+
100.567
1.775
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
APPLE INC
AAPL4492959
Corporate Bond
1.379
5/11/2020
Aa1
AA+
100.131
APPLE INC
AAPL4492958
Yes
Corporate Bond
1.8
5/11/2020
Aa1
AA+
100.08
1.768
APPLE INC
AAPL4336435
Yes
Corporate Bond
2.25
2/23/2021
Aa1
AA+
101.768
1.698
APPLE INC
AAPL4336437
No
Corporate Bond
2.444
2/23/2021
Aa1
AA+
102.829
APPLE INC
AAPL4122392
Yes
Corporate Bond
2.85
5/6/2021
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
Aa1
AA+
102.941
1.997
APPLE INC
AAPL4389212
Yes
Corporate Bond
1.55
8/4/2021
Aa1
AA+
98.259
2.024
APPLE INC
AAPL4452434
Yes
Corporate Bond
2.5
2/9/2022
Aa1
AA+
101.363
2.164
APPLE INC
AAPL4208635
Yes
Corporate Bond
2.15
2/9/2022
Aa1
AA+
99.928
2.167
APPLE INC
AAPL4452432
Corporate Bond
1.811
2/9/2022
Aa1
AA+
101.156
APPLE INC
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
AAPL4492954
Corporate Bond
1.659
5/11/2022
Aa1
AA+
100.772
APPLE INC
AAPL4492955
Yes
Corporate Bond
2.3
5/11/2022
Aa1
AA+
100.639
2.151
APPLE INC
AAPL4242669
Yes
Corporate Bond
2.7
5/13/2022
Aa1
AA+
102.182
2.2
APPLE INC
AAPL4538813
Yes
Corporate Bond
2.1
9/12/2022
Aa1
AA+
99.27
2.257
APPLE INC
AAPL4336434
Yes
Corporate Bond
2.85
2/23/2023
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
Aa1
AA+
102.474
2.344
APPLE INC
AAPL4001809
Yes
Corporate Bond
2.4
5/3/2023
Aa1
AA+
99.859
2.427
APPLE INC
AAPL4452439
Yes
Corporate Bond
3
2/9/2024
Aa1
AA+
102.421
2.574
APPLE INC
AAPL4122390
Yes
Corporate Bond
3.45
5/6/2024
Aa1
AA+
104.913
2.633
APPLE INC
AAPL4492960
Yes
Corporate Bond
2.85
5/11/2024
Aa1
AA+
101.491
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
2.597
APPLE INC
AAPL4208641
Yes
Corporate Bond
2.5
2/9/2025
Aa1
AA+
100.071
2.489
APPLE INC
AAPL4242665
Yes
Corporate Bond
3.2
5/13/2025
Aa1
AA+
102.951
2.767
APPLE INC
AAPL4336441
Yes
Corporate Bond
3.25
2/23/2026
Aa1
AA+
103.934
2.708
APPLE INC
AAPL4389208
Yes
Corporate Bond
2.45
8/4/2026
Aa1
AA+
96.62
2.886
APPLE INC
AAPL4452435
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
Yes
Corporate Bond
3.35
2/9/2027
Aa1
AA+
103.328
2.931
APPLE INC
AAPL4492956
Yes
Corporate Bond
3.2
5/11/2027
Aa1
AA+
101.818
2.976
APPLE INC
AAPL4507383
Yes
Corporate Bond
3
6/20/2027
Aa1
AA+
100.13
2.984
APPLE INC
AAPL4538816
Yes
Corporate Bond
2.9
9/12/2027
Aa1
AA+
99.018
3.015
APPLE INC
AAPL4336436
Yes
Corporate Bond
4.5
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
2/23/2036
Aa1
AA+
112.611
3.542
APPLE INC
AAPL4001810
Yes
Corporate Bond
3.85
5/4/2043
Aa1
AA+
101.733
3.744
APPLE INC
AAPL4122386
Yes
Corporate Bond
4.45
5/6/2044
Aa1
AA+
110.566
3.814
APPLE INC
AAPL4208639
Yes
Corporate Bond
3.45
2/9/2045
Aa1
AA+
94.834
3.754
APPLE INC
AAPL4242667
Yes
Corporate Bond
4.375
5/13/2045
Aa1
AA+
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
109.216
3.831
APPLE INC
AAPL4336433
Yes
Corporate Bond
4.65
2/23/2046
Aa1
AA+
113.62
3.849
APPLE INC
AAPL4377623
Corporate Bond
4.15
6/22/2046
APPLE INC
AAPL4389215
Yes
Corporate Bond
3.85
8/4/2046
Aa1
AA+
101.25
3.778
APPLE INC
AAPL4452437
Yes
Corporate Bond
4.25
2/9/2047
Aa1
AA+
107.473
3.82
APPLE INC
AAPL4538814
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
Yes
Corporate Bond
3.75
9/12/2047
Aa1
AA+
99.46
3.78
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
Problem 3 (2) – Transpose_Data_VBA utilizing special
selection:
This is a copy of the datat from Problem3.
Create a button for the macro but DO NOT RUN IT!
Make sure to populate the helper cells range
I need this copy to test your macro (see if it works).
You can test your VBA code on a separate sheet and then
delete it.
a_VBA utilizing special
Problem3.
ut DO NOT RUN IT!
er cells range E11:G1040.
cro (see if it works).
a separate sheet and then
Problem 4.1:
Eventus (R) Software from Cowan Research, L.C.
Summary of Eventus Event Study Data and User Selections
1. Use the Text-to-column tool to delimit the data into se
Select –> Fixed Width to manually select the column sepa
Note: Make sure that the Event date for each event
date is in row 313. For example: 20020417
ESTIMATION PERIOD: Ends 46 days before the event date;
255 days in length.
TOTAL SECURITY-EVENTS IN REQUEST FILE:
TOTAL SECURITY-EVENTS DROPPED:
Date outside of period available
72
2
2
SECURITY-EVENTS WITH USEABLE RETURNS:
Minimum days of return data required for parameter estimation:
70
4
Any non-trading date has been converted to the previous trading date.
NOTE: Useable returns means all nonmissing returns except the
first day after a missing estimation period return.
Please check the SAS log (Log tab in PC SAS, or *.log file) for any messages.
Eventus� software is produced by Cowan Research, L.C., an independent company.
Many users have mentioned Eventus in their papers. Thank you for your support!
Get expert help and code samples at http://support.eventstudy.com/.
Eventus (R) Software from Cowan Research, L.C.
Results of Daily Security Return Data Input
Estimation
Event
Period Period
Returns Returns
PERMNO Name on Event Date
Event Date 0
Standard
Variance
Autocor-
Deviation
relation*
14593
18OCT2010
0.00181
55.13%
0.00135
1.00
41.96%
0.00032
0.01301
0.0398
14593
18JAN2011
0.00209
56.69%
0.00130
1.02
43.92%
0.00030
0.01259
0.0254
14593
20APR2011
0.00252
58.26%
0.00146
0.97
44.71%
0.00025
0.01140
-0.0026
14593
19JUL2011
0.00132
14593
18OCT2011
0.00157
56.29%
0.00125
0.89
51.76%
0.00022
0.01050
0.0687
14593
24JAN2012
0.00094
53.16%
0.00075
0.75
49.41%
0.00026
0.01196
0.1057
14593
24APR2012
0.00148
53.54%
0.00132
0.74
45.10%
0.00028
0.01262
0.0921
14593
24JUL2012
0.00191
52.76%
0.00192
0.76
44.31%
0.00034
0.01456
0.0244
14593
25OCT2012
0.00231
53.93%
0.00178
0.74
43.14%
0.00031
0.01480
0.0282
14593
23JAN2013
0.00128
52.37%
0.00098
0.93
47.84%
0.00030
0.01461
-0.0250
14593
23APR2013
0.00019
49.62%
-0.00048
1.18
47.84%
0.00042
0.01815
-0.0117
14593
23JUL2013
-0.00078
48.04%
-0.00178
1.14
50.20%
0.00039
0.01745
0.0465
14593
28OCT2013
-0.00060
48.03%
-0.00142
1.03
48.24%
0.00039
0.01812
0.0601
14593
27JAN2014
0.00011
49.60%
-0.00084
0.83
47.84%
0.00037
0.01841
0.0568
14593
23APR2014
0.00072
51.57%
0.00026
0.54
48.63%
0.00026
0.01558
0.0778
14593
22JUL2014
0.00124
52.75%
0.00099
0.40
48.63%
0.00023
0.01500
0.0229
14593
20OCT2014
0.00179
54.32%
0.00145
0.53
46.27%
0.00021
0.01403
0.0325
14593
27JAN2015
0.00190
55.11%
0.00152
0.66
45.88%
0.00018
0.01260
0.0293
14593
27APR2015
0.00214
55.51%
0.00165
0.90
45.10%
0.00019
0.01203
0.0312
14593
21JUL2015
0.00186
55.90%
0.00131
1.04
47.84%
0.00019
0.01133
-0.0623
14593
27OCT2015
0.00044
50.81%
0.00042
1.17
49.02%
0.00023
0.01218
-0.0762
14593
26JAN2016
0.00029
48.43%
0.00025
1.17
47.84%
0.00028
0.01272
-0.1027
14593
26APR2016
-0.00088
45.68%
-0.00044
1.16
50.20%
0.00030
0.01246
-0.0920
14593
26JUL2016
-0.00099
46.45%
-0.00082
1.12
52.94%
0.00031
0.01312
0.0249
14593
25OCT2016
-0.00004
50.38%
-0.00027
1.05
50.20%
0.00030
0.01309
0.0499
14593
31JAN2017
0.00001
50.79%
-0.00034
0.95
49.80%
0.00023
0.01259
0.1411
14593
02MAY2017
0.00151
55.49%
0.00076
0.79
50.20%
0.00016
0.01160
0.1811
14593
01AUG2017
0.00202
55.51%
0.00144
0.77
44.31%
0.00012
0.01006
0.1116
14593
02NOV2017
0.00174
55.90%
0.00124
0.93
47.45%
0.00013
0.01011
0.1080
14593
01FEB2018
0.00194
56.69%
0.00104
1.18
46.27%
0.00012
0.00940
0.1149
14593
01MAY2018
0.00114
53.16%
0.00034
1.25
48.24%
0.00015
0.00953
0.1410
14593
31JUL2018
14593
01NOV2018
0.00096
0.00139
55.13%
52.37%
0.00065
0.00021
52.75%
0.86
1.20
0.00054
* First order autocorrelation of market model abnormal returns
Eventus (R) Software from Cowan Research, L.C.
Parameter Estimates and Estimation Period Statistics
Market Index=Value
1.13
49.80%
48.24%
46.27%
0.00020
0.00019
0.00018
0.01092
0.01064
0.01057
0.0591
0.1711
0.1881
(continued)
Mean
Event
PERMNO
% of Raw
Total
Date
Market
Returns
Total
Model Res-
Return
>0
Alpha
Beta
Residual
Return
iduals>0
Standard
Variance
Autocor-
Deviation
relation*
14593
29JAN2019
0.00051
52.36%
0.00023
1.23
46.67%
0.00026
0.01184
0.1517
14593
30APR2019
0.00024
53.15%
-0.00004
1.42
46.27%
0.00037
0.01289
0.1345
14593
30JUL2019
0.00009
55.11%
-0.00021
1.49
48.24%
0.00036
0.01296
0.0765
Mean
0.00137
52.50%
0.00101
1.14
47.07%
0.00050
0.01748
0.0402
Median
0.00150
52.95%
0.00098
1.13
47.25%
0.00039
0.01732
0.0425
* First order autocorrelation of market model abnormal returns
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE COMPUTER INC
PERMNO=14593 Event Date=20020417
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
1.38%
(-10,-2)
5.37%
(-5,0)
4.71%
(-1,+1)
-1.97%
(+2,+10)
-2.73%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE COMPUTER INC
PERMNO=14593 Event Date=20020716
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-5.50%
(-10,-2)
10.18%
(-5,0)
10.80%
(-1,+1)
-8.47%
(+2,+10)
-1.56%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE COMPUTER INC
PERMNO=14593 Event Date=20021016
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
(-10,-2)
8.76%
2.90%
(-5,0)
-3.94%
(-1,+1)
-10.94%
(+2,+10)
9.95%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE COMPUTER INC
PERMNO=14593 Event Date=20030115
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-6.00%
(-10,-2)
-2.34%
(-5,0)
(-1,+1)
(+2,+10)
-2.80%
0.98%
6.43%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE COMPUTER INC
PERMNO=14593 Event Date=20030416
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-11.95%
(-10,-2)
-6.33%
(-5,0)
(-1,+1)
(+2,+10)
-8.28%
-4.42%
6.82%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE COMPUTER INC
PERMNO=14593 Event Date=20030716
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
9.14%
(-10,-2)
0.87%
(-5,0)
-1.38%
(-1,+1)
7.72%
(+2,+10)
-3.73%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE COMPUTER INC
PERMNO=14593 Event Date=20031015
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
2.33%
(-10,-2)
10.73%
(-5,0)
5.38%
(-1,+1)
-5.06%
(+2,+10)
1.47%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE COMPUTER INC
PERMNO=14593 Event Date=20040114
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
3.68%
(-10,-2)
8.67%
(-5,0)
7.83%
(-1,+1)
-4.22%
(+2,+10)
-1.06%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE COMPUTER INC
PERMNO=14593 Event Date=20040514
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
4.60%
(-10,-2)
4.02%
(-5,0)
4.24%
(-1,+1)
-0.89%
(+2,+10)
-0.86%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE COMPUTER INC
PERMNO=14593 Event Date=20040714
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
0.92%
(-10,-2)
-9.26%
(-5,0)
(-1,+1)
(+2,+10)
-4.24%
13.32%
-0.45%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE COMPUTER INC
PERMNO=14593 Event Date=20041013
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
3.99%
(-10,-2)
-1.94%
(-5,0)
3.69%
(-1,+1)
18.99%
(+2,+10)
6.67%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE COMPUTER INC
PERMNO=14593 Event Date=20050112
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-8.05%
(-10,-2)
8.26%
(-5,0)
(-1,+1)
(+2,+10)
1.48%
2.09%
1.50%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE COMPUTER INC
PERMNO=14593 Event Date=20050413
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-17.64%
(-10,-2)
-5.42%
(-5,0)
-3.63%
(-1,+1)
-10.34%
(+2,+10)
-6.69%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE COMPUTER INC
PERMNO=14593 Event Date=20050713
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-22.66%
(-10,-2)
-5.79%
(-5,0)
(-1,+1)
(+2,+10)
-4.30%
5.27%
2.48%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE COMPUTER INC
PERMNO=14593 Event Date=20051011
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
3.06%
(-10,-2)
-4.83%
(-5,0)
(-1,+1)
(+2,+10)
-0.84%
-1.84%
7.80%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE COMPUTER INC
PERMNO=14593 Event Date=20060118
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
5.94%
(-10,-2)
8.96%
(-5,0)
8.35%
(-1,+1)
-8.65%
(+2,+10)
-7.99%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE COMPUTER INC
PERMNO=14593 Event Date=20060419
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-6.78%
(-10,-2)
3.98%
(-5,0)
(-1,+1)
(+2,+10)
-8.15%
-0.02%
4.10%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE COMPUTER INC
PERMNO=14593 Event Date=20060719
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-12.16%
(-10,-2)
-3.91%
(-5,0)
(-1,+1)
(+2,+10)
-1.40%
12.83%
6.34%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE COMPUTER INC
PERMNO=14593 Event Date=20061018
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-4.30%
(-10,-2)
-4.22%
(-5,0)
-1.42%
(-1,+1)
4.57%
(+2,+10)
-0.98%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20070117
Cumulative
Abnormal
Days
Return
——————————–
(-30,-2)
-0.98%
(-10,-2)
15.02%
(-5,0)
8.44%
(-1,+1)
-5.20%
(+2,+10)
-6.42%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20070425
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-4.35%
(-10,-2)
-3.91%
(-5,0)
3.31%
(-1,+1)
4.39%
(+2,+10)
6.01%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20070725
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
11.74%
(-10,-2)
5.13%
(-5,0)
0.99%
(-1,+1)
6.50%
(+2,+10)
-10.35%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20071022
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
15.12%
(-10,-2)
6.36%
(-5,0)
6.54%
(-1,+1)
7.86%
(+2,+10)
-0.79%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20080122
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-7.56%
(-10,-2)
-5.34%
(-5,0)
-3.54%
(-1,+1)
-15.31%
(+2,+10)
-10.53%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20080423
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
18.62%
(-10,-2)
6.06%
(-5,0)
(-1,+1)
(+2,+10)
4.94%
0.45%
5.31%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20080721
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-3.43%
(-10,-2)
-1.39%
(-5,0)
-7.34%
(-1,+1)
-8.41%
(+2,+10)
-4.39%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20081021
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-10.95%
(-10,-2)
12.93%
(-5,0)
(-1,+1)
-13.02%
5.03%
(+2,+10)
-2.27%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20090121
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-13.84%
(-10,-2)
-5.21%
(-5,0)
-3.18%
(-1,+1)
10.80%
(+2,+10)
4.38%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20090422
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
12.28%
(-10,-2)
0.70%
(-5,0)
1.40%
(-1,+1)
1.11%
(+2,+10)
-3.67%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20090721
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
4.25%
(-10,-2)
4.24%
(-5,0)
0.16%
(-1,+1)
1.67%
(+2,+10)
-0.24%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20091019
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
1.92%
(-10,-2)
-4.35%
(-5,0)
-3.09%
(-1,+1)
4.61%
(+2,+10)
-0.58%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20100125
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
0.35%
(-10,-2)
-1.14%
(-5,0)
-0.27%
(-1,+1)
0.36%
(+2,+10)
-4.90%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20100420
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
2.55%
(-10,-2)
1.56%
(-5,0)
-0.97%
(-1,+1)
3.26%
(+2,+10)
0.68%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20100720
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-7.43%
(-10,-2)
-4.45%
(-5,0)
-3.72%
(-1,+1)
0.76%
(+2,+10)
-3.63%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20101018
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
6.29%
(-10,-2)
2.98%
(-5,0)
5.46%
(-1,+1)
3.06%
(+2,+10)
-4.64%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20110118
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-0.81%
(-10,-2)
3.74%
(-5,0)
-1.47%
(-1,+1)
-2.00%
(+2,+10)
-1.34%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20110420
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-10.02%
(-10,-2)
-1.02%
(-5,0)
0.81%
(-1,+1)
2.64%
(+2,+10)
-1.60%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20110719
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
3.21%
(-10,-2)
(-5,0)
6.91%
5.42%
(-1,+1)
5.14%
(+2,+10)
5.04%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20111018
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
5.60%
(-10,-2)
0.66%
(-5,0)
5.10%
(-1,+1)
-4.64%
(+2,+10)
-2.84%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20120124
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
2.22%
(-10,-2)
-3.75%
(-5,0)
-2.02%
(-1,+1)
5.27%
(+2,+10)
2.68%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20120424
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
1.64%
(-10,-2)
-11.33%
(-5,0)
-4.16%
(-1,+1)
5.68%
(+2,+10)
-6.61%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20120724
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-3.61%
(-10,-2)
(-5,0)
-3.63%
-1.08%
(-1,+1)
-4.00%
(+2,+10)
2.50%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20121025
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-12.39%
(-10,-2)
-4.93%
(-5,0)
-4.15%
(-1,+1)
-2.00%
(+2,+10)
-10.21%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20130123
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-16.72%
(-10,-2)
-7.03%
(-5,0)
0.50%
(-1,+1)
-10.46%
(+2,+10)
-0.34%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20130423
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-7.83%
(-10,-2)
-7.24%
(-5,0)
-4.92%
(-1,+1)
1.97%
(+2,+10)
9.24%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20130723
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-2.46%
(-10,-2)
(-5,0)
0.14%
-1.76%
(-1,+1)
4.66%
(+2,+10)
6.23%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20131028
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
13.38%
(-10,-2)
5.91%
(-5,0)
4.12%
(-1,+1)
-3.27%
(+2,+10)
2.72%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20140127
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-1.06%
(-10,-2)
4.44%
(-5,0)
2.78%
(-1,+1)
-7.03%
(+2,+10)
5.37%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20140423
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-0.24%
(-10,-2)
0.48%
(-5,0)
-0.89%
(-1,+1)
6.72%
(+2,+10)
4.21%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20140722
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
(-10,-2)
(-5,0)
-1.00%
-2.36%
-2.47%
(-1,+1)
2.43%
(+2,+10)
-1.65%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20141020
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-2.53%
(-10,-2)
-2.03%
(-5,0)
-2.10%
(-1,+1)
3.78%
(+2,+10)
3.43%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20150127
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-4.24%
(-10,-2)
-0.63%
(-5,0)
1.52%
(-1,+1)
(+2,+10)
3.14%
2.62%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20150427
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-3.20%
(-10,-2)
-0.11%
(-5,0)
4.20%
(-1,+1)
0.34%
(+2,+10)
-3.73%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20150721
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-3.80%
(-10,-2)
-0.63%
(-5,0)
2.86%
(-1,+1)
-2.93%
(+2,+10)
-9.07%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20151027
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-3.46%
(-10,-2)
3.89%
(-5,0)
1.54%
(-1,+1)
-0.62%
(+2,+10)
-1.54%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20160126
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-4.40%
(-10,-2)
6.02%
(-5,0)
1.22%
(-1,+1)
-6.67%
(+2,+10)
4.63%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20160426
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-0.14%
(-10,-2)
-6.15%
(-5,0)
(-1,+1)
(+2,+10)
-3.01%
-7.76%
-2.54%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20160726
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-2.11%
(-10,-2)
0.46%
(-5,0)
-2.93%
(-1,+1)
5.05%
(+2,+10)
5.82%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20161025
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
11.69%
(-10,-2)
1.81%
(-5,0)
(-1,+1)
(+2,+10)
-0.06%
-0.47%
-3.09%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20170131
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
4.37%
(-10,-2)
1.83%
(-5,0)
0.54%
(-1,+1)
6.29%
(+2,+10)
3.05%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20170502
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
0.00%
(-10,-2)
-0.60%
(-5,0)
1.79%
(-1,+1)
(+2,+10)
2.17%
4.83%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20170801
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-0.72%
(-10,-2)
-1.74%
(-5,0)
-2.31%
(-1,+1)
4.63%
(+2,+10)
2.58%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20171102
Cumulative
Abnormal
Days
Return
——————————–
(-30,-2)
2.14%
(-10,-2)
4.29%
(-5,0)
5.76%
(-1,+1)
1.33%
(+2,+10)
-1.53%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20180201
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-13.36%
(-10,-2)
-8.59%
(-5,0)
-3.52%
(-1,+1)
-1.66%
(+2,+10)
8.22%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20180501
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-6.84%
(-10,-2)
-7.87%
(-5,0)
2.91%
(-1,+1)
9.78%
(+2,+10)
1.99%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20180731
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-0.70%
(-10,-2)
-0.70%
(-5,0)
(-1,+1)
(+2,+10)
-0.88%
5.63%
2.94%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20181101
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
6.18%
(-10,-2)
1.37%
(-5,0)
-0.83%
(-1,+1)
-4.77%
(+2,+10)
-7.99%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20190129
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
-8.40%
(-10,-2)
0.20%
(-5,0)
(-1,+1)
(+2,+10)
-0.39%
3.95%
0.63%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20190430
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
3.98%
(-10,-2)
1.43%
(-5,0)
-3.67%
(-1,+1)
3.96%
(+2,+10)
-6.48%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns,
Value Weighted Index
APPLE INC
PERMNO=14593 Event Date=20190730
Cumulative
Abnormal
Days
Return
——————————-(-30,-2)
1.12%
(-10,-2)
0.75%
(-5,0)
(-1,+1)
-0.53%
4.71%
(+2,+10)
1.93%
——————————–
Eventus (R) Software from Cowan Research, L.C.
Market Model Abnormal Returns, Value Weighted Index
Mean
Abnormal
Day
N
Return
Portfolio
Positive:
Negative
Time-Series
(CDA) t
Generalized
p-value
Sign Z
p-value
—————————————————————————————————–30
70
0.19%
37:33
0.841
0.4001
0.970
0.3320
-29
70
-0.06%
29:41
-0.249
0.8031
-0.946
0.3443
-28
70
-0.07%
31:39
-0.314
0.7532
-0.467
0.6407
-27
70
-0.43%
28:42
-1.885
0.0594
-1.185
0.2360
-26
70
-0.23%
27:43
-1.007
0.3139
-1.425
0.1543
-25
70
-0.04%
34:36
-0.186
0.8523
0.252
0.8013
-24
70
-0.17%
36:34
-0.739
0.4601
0.731
0.4650
-23
70
0.03%
36:34
0.138
0.8900
0.731
0.4650
-22
70
-0.24%
32:38
-1.065
0.2871
-0.227
0.8202
-21
70
0.26%
28:42
1.133
0.2571
-1.185
0.2360
-20
70
-0.14%
32:38
-0.626
0.5316
-0.227
0.8202
-19
70
0.25%
35:35
1.120
0.2626
0.491
0.6233
-18
70
-0.22%
32:38
-0.990
0.3220
-0.227
0.8202
-17
70
-0.24%
27:43
-1.045
0.2958
-1.425
0.1543
-16
70
-0.34%
30:40
-1.511
0.1307
-0.706
0.4801
-15
70
0.12%
38:32
0.510
0.6104
1.209
0.2265
-14
70
0.02%
36:34
0.073
0.9422
0.731
0.4650
-13
70
-0.12%
32:38
-0.526
0.5992
-0.227
0.8202
-12
70
-0.19%
29:41
-0.829
0.4074
-0.946
0.3443
-11
70
0.14%…
Purchase answer to see full
attachment



Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.