# Balance Sheet and Inventory Turnover

Good Essays
530 Words
Grammar
Plagiarism
Writing
Score
Balance Sheet and Inventory Turnover
Suppose the Robinson Company had a cost of goods sold of \$1,000,000 in 2010 and \$1,200,000 in 2011. a. Calculate the inventory turnover for each year. Comment on your findings b. What would have been the amount of inventories in 2011 if the 2010 turnover ratio had been maintained?

a. inventory turnover for 2010 =COGS/Inventory = \$1,000,000/350,000=2.857 inventory turnover for 2011 =COGS/Inventory = \$1,200,000/500,000=2.4 b. \$1,200,000 /inventory =2.857 Inventory in 2011 to maintain 2010 turnover ratio = \$420,021.00

2. The Robinson Company has the following current assets and current liabilities for these two years: 2010 2011
Cash and marketable securities \$50,000 \$50,000
Accounts receivable \$300,000 \$350,000
Inventories \$350,000 \$500,000
Total current assets \$700,000 \$900,000

Accounts payable \$200,000 \$250,000
Bank loan 0 150,000
Accruals 150,000 200,000
Total current liabilities \$350,000 \$600,000
If sales in 2010 were \$1.2 million, sales in 2011 were \$1.3 million, and cost of goods sold was 70 percent of sales, how long were Robinson's operating cycles and cash conversion cycles in each of these years? What caused them to change during this time?

OC=(Accounts Receivable)/(Sales/365)+Inventory/(COGS/365)

OC_2010=300,000/(1,200,000/365)+350,000/(840,000/365)=243 days

OC_2011=350,000/(1,300,000/365)+500,000/(910,000/365)=299 days

CCC_2010=300,000/(1,200,000/365)+350,000/(840,000/365)-200,000/(840,000/365)=156 days

CCC_2011=350,000/(1,300,000/365)+500,000/(910,000/365)-250,000/(910,000/365)=199 days

3. The Robinson Company from Problem 2 had net sales of \$1,200,000 in 2010 and \$1,300,000 in 2011.
a. Determine the receivables turnover in each year.
b. Calculate the average collection period for each year.
c. Based on the receivables turnover for 2010, estimate the investment in receivables if net sales were \$1, 300,000 in 2011.
d. How much of a change in

## You May Also Find These Documents Helpful

• Satisfactory Essays

2. What are the trends in inventory turnover, days in inventory, accounts receivables turnover, and days in receivables ratios for 1993-1995? What is the major driver for growth in inventory and receivables? If you look at 1Q96 data for inventory, how does seasonality impact your analysis?…

• 398 Words
• 2 Pages
Satisfactory Essays
• Satisfactory Essays

Start with the partial model in the file Ch12 P10 Build a Model.xls on the textbook’s Web site, which contains the 2013 financial statements of Zieber Corporation. Forecast Zeiber's 2014 income statement and balance sheets. Use the following assumptions: (1) Sales grow by 6%. (2) The ratios of expenses to sales, depreciation to fixed assets, cash to sales, accounts receivable to sales, and inventories to sales will be the same in 2014 as in 2013. (3) Zeiber will not issue any new stock or new long-term bonds. (4) The interest rate is 11% for long-term debt and the interest expense on long-term debt is based on the average balance during the year . (5) No interest is earned on cash. (6) Dividends grow at an 8% rate. (6) Calculate the additional funds needed (AFN). If new financing is required, assume it will be raised by drawing on a line of credit with an interest rate of 12%. Assume that any draw on the line of credit will be made on the last day of the year, so there will be no additional interest expense for the new line of credit. If surplus funds are available, pay a special dividend.…

• 351 Words
• 2 Pages
Satisfactory Essays
• Good Essays

E12-1 (Classification Issues—Intangibles) Presented below is a list of items that could be included in the intangible assets section of the balance sheet.…

• 1082 Words
• 5 Pages
Good Essays
• Satisfactory Essays

A firm has current assets of \$100,000 and total assets of \$300,000. The firm 's sales are \$900,000. The firm 's fixed asset turnover is…

• 1042 Words
• 5 Pages
Satisfactory Essays
• Satisfactory Essays

8. The Global Network has sales of \$418,700, cost of goods sold of \$264,900, and inventory of \$61,900. What is the inventory turnover rate?…

• 350 Words
• 2 Pages
Satisfactory Essays
• Powerful Essays

1) With our 10k final case study project we will be looking at the 10k financial filing of Apple Inc. Based on the 10k we read; we will apply the concepts learned in this class to form a thorough analysis of the financial statement. In a manner that will show we comprehend the ideas taught in this class.…

• 1220 Words
• 5 Pages
Powerful Essays
• Satisfactory Essays

Coca-Cola & Pepsi Financial Statement Analysis Team A Frances Sanchez, Herbie Merced, and Javier Urbina ACC 400 Accounting for Decision Making August 22, 2013 Introduction • Comparison of Coca-Cola and Pepsi • Financials from 2004 • Review financial ratios ▫ Liquidity ▫ Solvency ▫ Profitability • Discuss profitability of each company • Which company is the best investment opportunity Coca-Cola & Pepsi Ratios Comparison Liquidity Ratios Current Ratio (Current Assets/Current Liabilities) Coca-Cola Pepsi-Cola 1.10 1.27 (\$12,094/\$10,971) (\$8,639/\$6,752)…

• 357 Words
• 2 Pages
Satisfactory Essays
• Powerful Essays

4- A company has net sales of \$900,000 and average accounts receivable of \$300,000, What is its accounts receivable turnover for the period?…

• 992 Words
• 4 Pages
Powerful Essays
• Good Essays

Regarding the liquidity ratios, East Coast Yachts current ratio is below the median industry ratio. This implies the company has less liquidity than the industry in general. However, the current ratio is above the lower quartile, so there are companies in the industry with lower liquidity than East Coast Yachts. The company may have more predictable cash flows, or more access to short-term borrowing.…

• 706 Words
• 3 Pages
Good Essays
• Satisfactory Essays

BANKING PRODUCTS AND PROCESSES ISFS 601 Professor Robert J. Kauffman January 2014 OPERATIONS IN FINANCIAL SERVICES ISFS 601 JANUARY 2014 Note: Refer to Hatzakis, Nair and Pinedo (2010) in Production and Operations Management for additional details and comments about research that is worthwhile to conduct in this area. OPERATIONS IN FINANCIAL SERVICES ISFS 601 (HNP 5) Professor Robert J. Kauffman January 2014 Note: Refer to Hatzakis, Nair and Pinedo (2010) in Production and Operations Management for additional details and comments about research that is worthwhile to conduct in this area.…

• 413 Words
• 2 Pages
Satisfactory Essays
• Better Essays

3. 2.2 inventory turns per year in retail segment stores – this inventory was just…

• 1983 Words
• 8 Pages
Better Essays
• Satisfactory Essays

10. What will be the operating cycle; if average collection period is 80 days and inventory turnover is 1.05 times.…

• 664 Words
• 3 Pages
Satisfactory Essays
• Satisfactory Essays

A. What was Topps’ inventory turnover ratio and average days to sell inventory for 2006 and 2005? In order for one to completely understand what inventory turnover ratio is, it is important to define it. Inventory turnover ratio is the cost of goods sold divided by inventory (Edmonds, et al., 2007). In 2006, Topps company had a turnover ratio of 5.38, compared to 5.74 in 2005. These figures show that Topps had a better year in 2005. 2006 was the turning year for Topps’, it was a restructured era for the company. In 2005 the consolidated gross profit as a percentage of net sales was 35.7% up from 35.2% in 2004.…

• 332 Words
• 2 Pages
Satisfactory Essays
• Good Essays

1. “Accounting is ingrained in our society and it is vital to our economic system.” Do you agree? Explain.…

• 1268 Words
• 6 Pages
Good Essays
• Satisfactory Essays

Ba sic a ccou nting le ss ons an d qu es tio ns fo r high s cho ol a nd c ollege s tude nts…

• 89824 Words
• 360 Pages
Satisfactory Essays