Please answer the question below according to the information given in the attachment: a) Using the information provided for 31 Dec 2005, calculate the following: net working capital, current ratio, quick ratio, inventory turnover, average collection period, total debt ratio, gross profit margin, net profit margin, return on total assets, return on equity. b) Evaluate the company’s performance against industry average ratios and compare with last year’s results.
Please answer the question below according to the information given in the attachment: a) Using the information provided for 31 Dec 2005, calculate the following: net working capital, current ratio, quick ratio, inventory turnover, average collection period, total debt ratio, gross profit margin, net profit margin, return on total assets, return on equity. b) Evaluate the company’s performance against industry average ratios and compare with last year’s results.
Chapter9: Responsibility Accounting And Decentralization
Section: Chapter Questions
Problem 5PA: Financial information for BDS Enterprises for the year-ended December 31, 20xx, was gathered from an...
Related questions
Question
Please answer the question below according to the information given in the attachment:
a) Using the information provided for 31 Dec 2005, calculate the
following: net
turnover, average collection period, total debt ratio, gross profit margin,
net profit margin, return on total assets, return on equity.
b) Evaluate the company’s performance against industry average ratios
and compare with last year’s results.
![Alpha Milk Corp is considering taking over their competitor, Dana Dairy
Products, and asked your consultancy firm to perform financial statement
analysis to assess feasibility of this strategic initiative. You are given the
following key financial ratios, the firm's income statement and the balance
sheet. You can assume that there are 365 days in a year.
Dana Dairy Products Key Ratios
Industry
Average
1.3
Actual
Actual
2004
2005
Current Ratio
1.0
Quick Ratio
0.8
0.75
30 days
Average collection Period 23 days
Inventory Turnover
Debt Ratio
21.7
19
64.7%
50%
Times Interest Earned
4.8
5.5
Gross Profit Margin
Net Profit Margin
13.6%
12.0%
1.0%
0.5%
Return on total assets
2.9%
2.0%
Return on Equity
8.2%
4.0%
Income Statement
Dana Dairy Products
For the Year Ended December 31, 2005
$100,000
87,000
$13,000
11,000
$2,000
Sales Revenue
Less: Cost of Goods Sold
Gross Profits
Less: Operating Expenses
Operating Profits
Less: Interest Expense
Net Profits Before Taxes
500
$1,500
600
$900
Less: Taxes (40%)
Net Profits After Taxes](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F418cf947-54f3-443a-8312-77a96292016a%2F66e21f0d-6419-47ce-8743-1ffe013e8dc8%2Fdt37nh5_processed.png&w=3840&q=75)
Transcribed Image Text:Alpha Milk Corp is considering taking over their competitor, Dana Dairy
Products, and asked your consultancy firm to perform financial statement
analysis to assess feasibility of this strategic initiative. You are given the
following key financial ratios, the firm's income statement and the balance
sheet. You can assume that there are 365 days in a year.
Dana Dairy Products Key Ratios
Industry
Average
1.3
Actual
Actual
2004
2005
Current Ratio
1.0
Quick Ratio
0.8
0.75
30 days
Average collection Period 23 days
Inventory Turnover
Debt Ratio
21.7
19
64.7%
50%
Times Interest Earned
4.8
5.5
Gross Profit Margin
Net Profit Margin
13.6%
12.0%
1.0%
0.5%
Return on total assets
2.9%
2.0%
Return on Equity
8.2%
4.0%
Income Statement
Dana Dairy Products
For the Year Ended December 31, 2005
$100,000
87,000
$13,000
11,000
$2,000
Sales Revenue
Less: Cost of Goods Sold
Gross Profits
Less: Operating Expenses
Operating Profits
Less: Interest Expense
Net Profits Before Taxes
500
$1,500
600
$900
Less: Taxes (40%)
Net Profits After Taxes
![Balance Sheet
Dana Dairy Products
December 31, 2005
Assets
Cash
$ 1,000
Accounts Receivable
8,900
Inventories
4,350
$14,250
Total Current Assets
Gross Fixed Assets
$35,000
Less: Accumulated Depreciation
Net Fixed Assets
13,250
21,750
$36,000
Total Assets
Liabilities & Stockholders' Equity
Accounts Payable
Accruals
$ 9,000
6,675
$15,675
4,125
$19,800
1,000
15,200
$16,200
$36,000
Total Current Liabilities
Long-term Debt
Total Liabilities
Common Stock
Retained Earnings
Total Stockholders' Equity
Total Liabilities & Stockholders Equity](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F418cf947-54f3-443a-8312-77a96292016a%2F66e21f0d-6419-47ce-8743-1ffe013e8dc8%2Fvjwl8n_processed.png&w=3840&q=75)
Transcribed Image Text:Balance Sheet
Dana Dairy Products
December 31, 2005
Assets
Cash
$ 1,000
Accounts Receivable
8,900
Inventories
4,350
$14,250
Total Current Assets
Gross Fixed Assets
$35,000
Less: Accumulated Depreciation
Net Fixed Assets
13,250
21,750
$36,000
Total Assets
Liabilities & Stockholders' Equity
Accounts Payable
Accruals
$ 9,000
6,675
$15,675
4,125
$19,800
1,000
15,200
$16,200
$36,000
Total Current Liabilities
Long-term Debt
Total Liabilities
Common Stock
Retained Earnings
Total Stockholders' Equity
Total Liabilities & Stockholders Equity
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College