Module 6 Homework Assignment Use the information given in the green tabs to solve the questions below
Module 6 | ||||||||||
Homework Assignment | ||||||||||
Use the information given in the green tabs to solve the questions below | ||||||||||
(answers in yellow, and show formulas used when applicable.) | ||||||||||
1) | Calcluate the following profitablility ratios: | |||||||||
2010 | 2009 | Formulas | ||||||||
a) | Percent return on net sales | |||||||||
b) | Percent return on assets employed | |||||||||
i) | What does the percent return on net sales indicate? | |||||||||
ii) | What does the percent return on assets employed indicate? | |||||||||
iii) | What does the change from 2009 to 2010 in the percent return on assets mean for the company? | |||||||||
2) | The CFO wants a projection for 2011 showing a net profit margin of 25%. | |||||||||
What changes would have to happen for the net profit to increase? | ||||||||||
3) | What was the long term debt to equity ratio in 2009. | |||||||||
2009 | Formulas | |||||||||
Ratio of Long Term Debt To Equity | ||||||||||
What does this mean? | ||||||||||
What is better a higher or lower ratio? | ||||||||||
4) | What are liquidity measures? | |||||||||
Choose two ratios that assist in the determination of these measures. | ||||||||||
(show the answers for both year as well as the formula) – (hint see page 360-361 of text) | ||||||||||
2010 | 2009 | Formulas | ||||||||
Ratio #1 | ||||||||||
Ratio #2 | ||||||||||
5) | What are debt service (coverage) ratios | |||||||||
What is the formula to use | ||||||||||
to determine debt service coverage | ||||||||||
6) | The two purple tabs show the breakdown of each division in this company. | |||||||||
What types of items might you decide to “trend” based on the information shown. | ||||||||||
(ie, if sales in one division declined from one year to the next, what kinds of trends might you want to | ||||||||||
start paying attention to. — hint page 373 and 374) | ||||||||||
7) | Describe at least two things that could happen within this company that would make it necessary for | |||||||||
the controller to dig into the numbers and provide a write up to management. | ||||||||||
(for instance, the controller might notice that inventory has shrunk by over 50% what | ||||||||||
might he look for in the numbers and what ratios might he use to check things before alerting management) | ||||||||||