Huffman Trucking Balance Sheet (Unaudited) December


Question Description:

35

This is a bit more work so I am offering more. I need it in 48 hours? Can you handle this? I have attached the balance sheet and income statement. If you need more info let me know and I can get it immediately. I have alerts on my phone now for you so when you respond I see it in about 2 minutes. Resources: Virtual Organizations Access the information contained in your selected organization’s balance sheet and income statement to calculate the following: Liquidity ratios Current ratio Acid-test, or quick, ratio Receivables turnover Inventory turnover Profitability ratios Asset turnover Profit margin Return on assets Return on common stockholders’ equity Solvency ratios Debt to total assets Times interest earned Show your calculations for each ratio. Create a horizontal and vertical analysis for the balance sheet and the income statement. Write a 350- to 700-word memo to the CEO of your selected organization in which you discuss your findings from your ratio calculations and your horizontal and vertical analysis. In your memo, address the following questions: What do the liquidity, profitability, and solvency ratios reveal about the financial position of the company? Which users may be interested in each type of ratio? What does the collected data reveal about the performance and position of the company? Format your memo consistent with APA guidelines. (THIS IS A MUST)! Huffman Trucking.docx Huffman Trucking Balance Sheet (Unaudited) December 31st 2011 2010 (In Thousands) Assets Current Assets Cash & Cash Equivalents $89,664 $58,003 51,869 81,557 6,267 5,529 $147,800 $145,089 Carrier Operating Property (at cost) $85,306 $81,461 Less: Allowance for Depreciation (69,536) (67,119) Net Carrier Operating Property $15,770 $14,342 7,516 8,739 Goodwill (net) 49,852 49,852 Other Assets 46,327 37,306 Accounts Receivable Prepaid Expenses & Supplies Total Current Assets Assets of Discontinued Operations Historic Balance Sheet Data (Excel 2003 Version) Huffman Trucking Statement of Income (Unaudited) December 31st 2011 2010 (In Thousands) Revenue $1,109,295 $969,240 $406,191 $367,993 Fuel Expense 318,737 258,904 Operating Supplies and Expenses 117,670 105,875 Purchased Transportation 138,140 114,250 Operating Expenses Salaries, Wages & Benefits Operating Taxes & Licenses 19,033 17,753 Insurance & Claims 11,995 12,493 Provision for Depreciation 3,009 2,773 Total Operating Expenses $1,014,775 $880,041 $94,520 $89,199 $466 $768 34,887 32,923 $59,167 $55,508 Operating Income form Continuing Operations Interest Expense Tax Expense Net Income Historic Income Statement Data (Excel 2003 Version) Resources: Virtual Organizations Click the Virtual Organization link to access the Virtual Organizations. Select one of the Virtual Organizations as the basis for this assignment. Obtain faculty approval of your selected organization before beginning the assignment. Access the information contained in your selected organization’s balance sheet and income statement to calculate the following: Liquidity ratios o Current ratio o Acid-test, or quick, ratio o Receivables turnover o Inventory turnover Profitability ratios o Asset turnover o Profit margin o Return on assets o Return on common stockholders’ equity Solvency ratios o Debt to total assets o Times interest earned Show your calculations for each ratio. Create a horizontal and vertical analysis for the balance sheet and the income statement. Write a 350- to 700-word memo to the CEO of your selected organization in which you discuss your findings from your ratio calculations and your horizontal and vertical analysis. In your memo, address the following questions: What do the liquidity, profitability, and solvency ratios reveal about the financial position of the company? Which users may be interested in each type of ratio? What does the collected data reveal about the performance and position of the company? Format your memo consistent with APA gu

Answer

35