FIN 571 TUTOR Education is Power/fin571tutor.com FIN 571 TUTOR Education is Power/fin571tutor.com | Page 36

FOR MORE CLASSES VISIT www . fin571tutor . com

Ratio Analysis Problems
Ratio Analysis
( Individual Assignment )
You may use excel or word . doc format for this assignment .
Please post your homework as a word . doc or excel file in the class
discussion section below by the due date .
1 . Analysis of cost of goods sold problem .
1992
1993
1994
Gross Profit Margin
60 %
55 %
51 %
What is happening to cost of goods sold ? As was done in the week 2
online lecture on ratio analysis , please assume sales of 1 dollar each year
as you do your analysis . This problem follows the process shown in the
Week 2 Ratio Analysis online lecture section titled : " Another Income
Statement Analytical Approach : Percent of Sales "
( 5 points )
2 . Overhead ( or Sales , General and Administrative Expense ) problem .
1992
1993
1994
Gross Profit Margin
40 %
39 %
41 %
Operating Margin ( NOI / Sales )
15 %
10 %
5 %
What is happening to S , G and A ( or overhead expenses )? Please set up
an illustration assuming sales of 1.00 dollar each year just as you did in
problem number one .
( 5 points )
3 . Balance Sheet Problem
1992
1993
1994
Annual Sales Growth ( over prior yr )
+ 1 %
0 %
+ 1 %
Current Ratio
3.5X
2X
1.2X
Average Collection Period
25 days 30 days 55
days
What is happening to liquidity ? Why ? What are some follow-up questions
your would ask ? ( 5 points )