Finance Help
Ratio Analysis
Compute the ratios below for Blue Bill Corporation based on the financial statements provided. Ending inventory was $1,237.6 for year 2010.
After calculating the various ratios, analyze the overall financial health of Blue Bill Corporation.
Values presented on the financial statements are in millions.
Blue Bill Corporation Blue Bill Corporation
Balance Sheet Income Statement
December 31, 2011 2011
Assets Liabilities and Shareholders' Equity Sales $10,495.0
Current Assets Current liabilities Cost of products sold 6,700.5
Cash and cash equivalents $483.2 Short-term debt $43.4 Gross Profit 3,794.5
Receivables (net of allowance) 1,045.1 Long-term debt due within a year 151.6 Selling and administrative expense 2,350.9
Inventories 1,249.4 Accounts payable 1,007.7 Operating income 1,443.6
Other current assets 273.5 Other accrued liabilities 972.7 Other income (18.3)
Total current assets 3,051.2 Total current liabilities 2,175.4 Earnings before interest and taxes 1,425.3
Property, plan and equipment Interest expense 295.2
Land 77.1 Long-term liabilities Taxes 247.8
Buildings 842.4 Long-term debt 4,559.4 Net income $882.3
Equipment 3,546.0 Deferred taxes 665.3
Less accumulated depreciation 2,373.7 Other long-term liabilities 784.2
Total property, plant and equipment 2,091.8 Total long-term liabilities 6,008.9
Other noncurrent assets 4,932.6 Shareholders' equity 1,891.3
Total assets $10,075.6 Total liabilities and shareholders' equity $10,075.6
Ratio analysis
Liquidity ratios:
Current ratio
Quick ratio
Activity ratios:
Inventory turnover
Receivables turnover
Days sales outstanding
Fixed asset turnover
Total asset turnover
Profitability ratios:
Gross profit margin
Operating profit margin
Net profit margin
Return on assets
Return on equity
Leverage ratios:
Debt / Net worth
Debt ratio
Coverage ratios:
Times-interest-earned
Analysis of Blue Bill Corporation's financial health
- 6 years ago
- 20
Purchase the answer to view it
- pam_finance_help.docx
Purchase the answer to view it
- ratio_analysis.xlsx
Purchase the answer to view it
- blue_bill_corporation.docx
Purchase the answer to view it
- blue_bill_ratio_analysis_tutorial.xlsx
Purchase the answer to view it
- copy_of_module_04_financial_statements_and_ratio_analysis_problems.xlsx
- INF 337 Week 5 Final Paper Integrated Cost and Schdule Control
- Human Resource Planning
- WACC
- MKT571 Week 3 Market Segmentation and Product Position
- 4 questions management practices
- DeVry ACCT 305 Week 1 DQs
- Core humanity paper
- Electromagnetic
- ECO372 Week Three Discussion Questions
- CJA 384 Week 2 Discussion Questions ( CJA384 Week 2 DQ ) ( CJA 384 Week 2 DQ's
Written Assignment - Ratio Analysis
Download theModule 07_Ratio Analysis Problem. Excel template and complete the included problems.
excel document is attached.
6 years agoRatio Analysis
NOT RATEDI have attached my Excel doc that this has to be done on.
Thank you!
7 years agoRatio Analysis
NOT RATEDMUST BE FINISHED WITHIN 4-5 HOURS! ALSO MUST BE EXCELLENT IN RATIO ANALYSIS!! EXCEL TAMPLET IS DOWN BELOW, PLEASE DOWNLOAD AND ENSURE YOU KNOW HOW TO DO IT BEFORE ASKING TO DO THE WORK. THANK YOU!!
7 years agoRatio Analysis
NOT RATEDSee attached excel sheet and compute the ratios based on the financial statements provided. Ending inventory was $1,237.6 for year 2010. Follow instructions.
6 years agoCompute the ratios below for Blue Bill Corporation based on the financial statements provided
NOT RATEDRatio Analysis Compute the ratios below for Blue Bill Corporation based on the financial statements provided. … 6 years agoCompute the ratios below for Blue Bill Corporation based on the financial statements provided. Ending inventory was $1,237.6 for year 2010. After calculating the various ratios, analyze the overall financial health of Blue Bill Corporation. Valu
NOT RATEDRatio Analysis Compute the ratios below for Blue Bill Corporation based on the financial statements provided. … 6 years agoModule 07 Written Assignment - Ratio Analysis
NOT RATEDDownload theModule 07_Ratio Analysis Problem. Excel template and complete the included problems.
4 years ago