# BUSN 5200 W4 Homework

Satisfactory Essays
467 Words
Grammar
Plagiarism
Writing
Score
BUSN 5200 W4 Homework
Kelsie Bellino

Homework Assignment for Week 4:

• Prepare a ratio analysis for the fiscal year ended Dec 31, 2012. Organize your analysis per the following outline:

(1) Liquidity - Current ratio: current assets/ current liabilities= 25,000/17,000 = 1.47% - Quick ratio: current assets-inventory/ current liabilities= 25,000-17,000 / 17,000 = .25 (note: 17,000 cancels itself out) Comments on liquidity: Cannot tell if these ratios are good or bad without more information on the company’s situation or past years.

(2) Asset management - Total Asset turnover: sales/ total assets= 10,000/40,000= .25 - Average collection period (ACP): A/R/ average credit sales per day= 3,000/ (10,000/365) = 3,000/ 27 = 111 days Comments on asset management: Joe’s Is producing \$0.25 for each \$1 of assets. This cannot be further explained without more information. Joe’s customers take over 111 days to pay their bills.

(3) Debt management - Debt ratio: total liabilities/ total assets= 20,000/ 40,000= .5 or 50% - Times interest earned: earnings before interest and taxes(EBIT)/ interest ex.=
3,000/200 = 15 Comments on debt management: Joes is not in large debt because it is not equal to their total liabilities as long as they keep their accounts payable low and do not borrow more money than their assets can outweigh, this includes their long term debt. Joes EBIT could drop 2,800 and they could still make interest payments. Joe’s ratio of 15 means the income is 15 times greater than the annual interest expense.

(4) Profitability - Net profit margin: Net income/sales= 1,800/10,000= 18% - Return on Assets (ROA)= Net income/ total assets= 1,800/40,000=.045 or 4.5% - Return on Equity (ROE)= Net income/ total equity=1,800/20,000= .09 or 9% - Extended Du Pont equation=
ROE= Net income/sales x Sales/total assets x Total Assets/total (common) equity = .09 = .18 x .25 x 2.0 Comments on profitability to include your comments on the

## You May Also Find These Documents Helpful

• Satisfactory Essays

a. Establish a strategic management plan with the goal of becoming more competitive in the market.…

• 400 Words
• 2 Pages
Satisfactory Essays
• Satisfactory Essays

ACC/291 March 25,2012 Liquidity Ratios Current Ratio: Current Assets/Current Liabilities 2005 \$14,555,092/ \$6,974,752= 2.09:1 2004 \$14,643,456/ \$6,029,696=2.43:1 Acid Test Ratio: Cash+ Short-Term Investments + Receivables (Net)/ Current Liabilities 2005 \$305,563 + \$283,583 +\$6,133,663/ \$6,974,752= .96:1 2004 \$357,216 + \$133,504 + \$5,775,104/ \$6,029,696=1.04:1 Receivables Turnover: Net Credit Sales/ Average Net Receivables 2005 \$50,823,685/ (\$6,133,663 + 5,775,104/2) \$50,823,685/ \$5,954,384= 8.54 times 2004 \$46,044,288/(\$5,775,104+6,569,344/2) \$46,044,288/ \$6,172,224=7,46 times Inventory Turnover: Cost of Goods Sold/ Average Inventory 2005 \$42,037,624/ (\$7,850,970+\$7,854,112/2) \$42,037,624/\$7,852,541=5.35 times 2004 \$37,480,050/ (\$7,854,112+8,074,880/2) \$37,480,050/ \$7,964,496=4.71 times Profitability Ratios Current Assets 2004 2005…

• 1563 Words
• 7 Pages
Satisfactory Essays
• Powerful Essays

The liquidity ratios of the firm are slightly below the industry averages. This is due to inventory and accounts receivable making up a significantly larger portion of the current assets than cash and marketable securities. This may be indicative of a problem with inventory management and/or collection on accounts.…

• 1083 Words
• 5 Pages
Powerful Essays
• Good Essays

The strength of Mark X as a company is its fixed assets turnover ratio, which rose from 1990 to 1992. This tells us Mark X 's ability to generate net sales from each addition of a fixed asset. Sales generated from the fixed assets are greater than the costs of the fixed assets, which imply that the fixed assets that were purchased are good investments for the company. This is really the only positive ratio they have at the moment. Weaknesses we found in Mark X were its debt ratio, which increased from 40.47% in 1990 to 46.33% in 1991 and from 46.33% to 59.80% in 1992. This shows us Mark X 's amount of debt relative to its assets is increasing and that its debt is equal to more than half of its assets by 1992. The current ratio and quick ratio has also indicated negative change, both decreasing between 1990 and 1992. The current ratio is a liquidity ratio that measures a company 's ability to pay short term obligations, while the quick ratio shows a company 's ability to pay its short-term obligations with its most liquid assets. Both ratios are steadily decreasing, indicating to us the position of the company has become less and less favorable.…

• 1418 Words
• 4 Pages
Good Essays
• Good Essays

Liquidity ratios measure the short-term ability a company to pay its obligations and meet unexpected needs of cash. These numbers can be found by analyzing the company’s balance sheet. The company that closely matches or exceeds the industry averages in liquidity is Tootsie Roll. Tootsie Roll’s current ratio of 2.34 exceeds that of the industries 1.29. They also have a lower cash to debt ratio 1.05 (2.37 industry, days in inventory 63.98 (industry 72.7) and a quicker inventory turnover 5.7 (industry 6.05). The only ratio were Hershey exceeds Tootsie Roll is receivables turnover ratio. Hershey collects more of its receivables but Tootsie Roll collects faster. Tootsie Roll is better suited to collect cash quickly to pay its obligations and meet unexpected cash needs.…

• 416 Words
• 2 Pages
Good Essays
• Good Essays

The first category of ratio analysis is the liquidity ratio. In this category, we have calculated the current ratio. The current ratio for Albertson’s for 2003 is 1.2 and for 2004 is 1.05. Companies that have a ratio at or below 1.0 should be concerned, unless they have inventory that can be quickly converted to cash. www.beginnersinvest.about.com .…

• 1389 Words
• 6 Pages
Good Essays
• Satisfactory Essays

1. (Monthly compounding) If you bought a \$1,000 face value CD that matured in nine months, and which was advertised as paying 9% annual interest, compounded monthly, how much would you receive when you cashed in your CD at maturity?…

• 420 Words
• 4 Pages
Satisfactory Essays
• Satisfactory Essays

1. Liquidity ratios. Edison, Stagg, and Thornton have the following financial information at the close of business on July 10:…

• 796 Words
• 4 Pages
Satisfactory Essays
• Satisfactory Essays

Liquidity Ratios The top part of Ramakrishnan, Inc,’s 2012 and 2011 balance sheets is listed below…

• 659 Words
• 12 Pages
Satisfactory Essays
• Good Essays

Ford’s liquidity has improved over the past 3 years. From 2007 to 2008, liquidity went down, but improved in 2009 better than 2007. Ford has the ability to pay for its current liabilities 1.39 times and without assets, Ford has the ability to pay for its current liabilities 1.28 times, which means they do not have to rely on sales of inventory. For 2009, Ford’s quick ratio was 1.28 and their current ratio was 1.39 which both we better than the industry average which was .90 and 1.17, respectively. Ford’s liquidity in 2009 was better than most of their peers which means their liquidity position is strong.…

• 296 Words
• 2 Pages
Good Essays
• Powerful Essays

Available cash, or rather the lack of it, is a critical problem facing the company. All of the liquidity ratios are showing signs of decline. The current ratio has been in decrease over the past 4 years, possibly due in part to rapid expansion and more recently to poor product selection. There has been a much sharper weakening over the past 2 years.…

• 735 Words
• 3 Pages
Powerful Essays
• Satisfactory Essays

1. Increased demand for a product or service will usually result in lower prices for the item. FALSE…

• 2522 Words
• 11 Pages
Satisfactory Essays
• Satisfactory Essays

When I first thought about the questions this week I had to step back and really think about what was being asked and why. The first question involves increasing U.S sports franchises popularity overseas and the cultural obstacles one must overcome. The next question deals with making products from these franchises appropriate for international market, and the last question brings in our government, would placing tariffs on imported products protect our industries. These three questions have multiple ways of being answered it will really depend on the beliefs of the person answering the question.…

• 354 Words
• 1 Page
Satisfactory Essays
• Powerful Essays

Liquidity ratios, like the current ratio, provide information about a firm's ability to meet its short time financial obligations. Short-term creditors seek a high current ratio from prospective clients since it reduces their risk. For investors in a company, such as shareholders, a lower ratio is sought, so that more of a firm's assets are working to grow the business. When computing financial relationships, a good indication of the company's financial strengths and weaknesses becomes clear. Examining these ratios over time provides insight as to how effectively the business is being operated. The general consensus on liquidity ratios is; the higher the better, especially if a firm is reliant on any significant extent on creditors to finance their assets.…

• 1303 Words
• 6 Pages
Powerful Essays
• Satisfactory Essays

Review the financial information pertaining to Salco Inc. in Study Problem 4-10 on pages 113 and 114 of you text. Answer the following questions in an Excel document. Solve using Excel formulas (preferred) or clearly write out the steps you took to calculate your answers. Round any dollar amounts to the nearest dollar (\$1,500,074) and any percentages to two decimals (9.56%).…

• 535 Words
• 3 Pages
Satisfactory Essays