Exercises
CHAPTER 2 An Introduction to Financial Statements
1.Given the database in JNJBS.Txt, what is the average CATA, CLTA,
and TDTA for JNJ? How do the ratios for JNJ compare to the respec-
tive CATA, CLTA, and TDTA ratios for all WRDS companies in the
year 2003, found in BSIS2003.txt? Explain with respect to external
capital markets needs.
The file format is:
Data JNJBS;
infile “D:JNJBS.txt” lrecl=50;
input smbl 1-6yeara 8-11@ 13 CATA f9.3 @ 23 CLTA f9.3 @ 33
TDTA f9.3;
Data BSIS2003;
infile “D:BSIS2003.txt” lrecl=75;
input smbl 1-6yeara 8-11@ 13 CATA f9.3 @ 23 CLTA f9.3 @ 33
TDTA f9.3 @ 43 ROE f9.3 @ 53 ROA f9.3 @ 63 ROS f9.3;
2.Given the database in JNJIS.Txt, what is the average ROA, ROS, and
ROE for JNJ? How do the ratios for JNJ compare to the respective ROA,
ROS, and ROE ratios for all WRDS companies in the year 2003, found in
BSIS2003.txt? Explain with respect to profitability, leverage, and product.
The file format is:
Data JNJIS;
infile “D:JNJIS.txt” lrecl=50;
input smbl 1-6yeara 8-11@ 13 ROE f9.3 @ 23 ROA f9.3 @ 33 ROS
f9.3;
CHAPTER 3 Ratio Analysis
1.Given the database in JNJRatios.Txt, what is the average CR, SA,
TDA, ROE, DuPontA, and NewZ for JNJ? How do the ratios for JNJ
compare to the respective ratios for all WRDS companies in the year
263
