Joe and Mary's Dog Food, Financial Statement Analysis. Calculate ratios
Not what you're looking for?
**Please see attachment for case study info and balance sheet and income statement.
1. Create Funds statements for 2001, 2002 and 2003.
2. Calculate the following ratios for 2000: Current ratio, Quick ratio, Inventory turnover ratio, Gross profit Margin, Net profit margin, ROA, Asset turnover ratio, fixed asset turnover ratio, debt ratio, and the times interest earned ratio.
3. Calculate the Debt ratio and the current ratio for 2000, 2001, 2002 and 2003. Compare the ratios over the 4-year period and explain any trends you see and any deviations from that trend.
4. Bob has reason to believe that the company will grow their sales by 10% from 2003 in 2004. Create a budgeted Income Statement for Joe and Mary's Dog Food Company for 2004. Assume that the cost structure that was in place for the company with regards to fixed cost and interest expense will be the same in 2004 as it was in 2003, and that the firms variable costs will continue to be 40% of total sales. The company is the 35% tax bracket.
5. What would the company's dividend payment be for 2004? How much of the dividend was paid out to Joe and Mary if they did not own any shares of the firm's common stock. Ignore the taxes that would be paid on the dividend payment.
Purchase this Solution
Solution Summary
The solution shows all the calculations used to compute the answers to the questions.
Purchase this Solution
Free BrainMass Quizzes
Introduction to Finance
This quiz test introductory finance topics.
Basics of corporate finance
These questions will test you on your knowledge of finance.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.