spartan1

An analyst has collected the following data about a firm:

• Receivables turnover = 10 times.
• Inventory turnover = 8 times.
• Payables turnover = 12 times.

What is the average receivables collection period, the average inventory processing period, and the average payables payment period? (assume 360 days in a year)

Receivables Collection Period

Inventory Processing Period

Payables Payment Period

A) 36 days 45 days 30 days

B) 30 days 30 days 60 days

C) 45 days 36 days 30 days

---

Receivables collection period = 360 / 10 = 36 days
Inventory processing period = 360 / 8 = 45 days
Payables payment period = 360 / 12 = 30 days

spartan1

The following footnote appeared in Crabtree Company’s 20X7 annual report:

“On December 31, 20X7, Crabtree recognized a restructuring charge of $20 million, of which $5 million was for severance pay for employees who will be terminated in 20X8 and $15 million was for land that became permanently impaired in 20X7.”

Based only on these changes, Crabtree’s net profit margin and fixed asset turnover ratio in 20X8 as compared to 20X7 will be?

Net profit margin

Fixed asset turnover

A) Higher Unchanged

B) Higher Higher

C) Lower Higher

---

The restructuring charge and asset write-down are non-recurring transactions; thus, net income will be higher in 20X8, all else equal. In 20X8, fixed asset turnover will be the same as 20X7, all else equal. The asset impairment charge is a one-time charge, so fixed assets will not be reduced further in 20X8.

spartan1

During 2007, Brownfield Incorporated purchased $140 million of inventory. For the year just ended, Brownfield reported cost of goods sold of $130 million. Inventory at year-end was $45 million. Calculate inventory turnover for the year.

A) 3.71.

B) 3.25.

C) 2.89.

---

First, calculate beginning inventory given COGS, purchases, and ending inventory. Beginning inventory was $35 million [$130 million COGS + $45 million ending inventory – $140 million purchases]. Next, calculate average inventory of $40 million [($35 million beginning inventory + $45 million ending inventory) / 2]. Finally, calculate inventory turnover of 3.25 [$130 million COGS / $40 million average inventory].

spartan1

An analyst has gathered the following information about a company:

• Cost of goods sold = 65% of sales.
• Inventory of $450,000.
• Sales of $1 million.

What is the value of this firm’s average inventory processing period using a 365-day year?

A) 0.7 days.

B) 252.7 days.

C) 1.4 days.

---

COGS = (0.65)($1,000,000) = $650,000
Inventory turnover = CGS / Inventory = $650,000 / $450,000 = 1.4444
Average Inventory Processing Period = 365 / 1.4444 = 252.7 days

spartan1

Given the following information about a company:

• Receivables turnover = 10 times.
• Payables turnover = 12 times.
• Inventory turnover = 8 times.

What are the average receivables collection period, the average payables payment period, and the average inventory processing period respectively?

Average Receivables Collection Period

Average Payables Payment Period

Average Inventory Processing Period

A) 37 30 52

B) 37 45 46

C) 37 30 46

---

Average receivables collection period = (365 / 10) = 36.5 or 37
Average payables payment period = (365 / 12) = 30.4 or 30
Average inventory processing period = (365 / 8) = 45.6 or 46

spartan1

Given the following income statement and balance sheet for a company:

Balance Sheet
Assets	Year 2003	Year 2004
Cash	500	450
Accounts Receivable	600	660
Inventory	500	550
Total CA	1300	1660
Plant, prop. equip	1000	1250
Total Assets	2600	2,910
Liabilities
Accounts Payable	500	550
Long term debt	700	1102
Total liabilities	1200	1652
Equity
Common Stock	400	538
Retained Earnings	1000	720
Total Liabilities & Equity	2600	2,910
Income Statement
Sales		3000
Cost of Goods Sold		(1000)
Gross Profit		2000
SG&A		500
Interest Expense		151
EBT		1349
Taxes (30%)		405
Net Income		944

What is the average receivables collection period?

A) 76.7 days.

B) 80.3 days.

C) 60.6 days.

---

Average collection period = 365 / receivables turnover
Receivables turnover = sales / average receivables = 3,000 / 630 = 4.76
Average receivables collection period = 365 / 4.76 = 76.65

spartan1

An analyst has gathered the following information about a company:

Balance Sheet
Assets
	Cash	100
	Accounts Receivable	750
	Marketable Securities	300
	Inventory	850
	Property, Plant & Equip	900
	Accumulated Depreciation	(150)
Total Assets		2750
Liabilities and Equity
	Accounts Payable	300
	Short-Term Debt	130
	Long-Term Debt	700
	Common Stock	1000
	Retained Earnings	620
Total Liab. and Stockholder's equity		2750
Income Statement
Sales		1500
COGS		1100
Gross Profit		400
SG&A		150
Operating Profit		250
Interest Expense		25
Taxes		75
Net Income		150

What is the receivables turnover ratio?

A) 2.0.

B) 0.5.

C) 1.0.

---

Receivables turnover = 1,500(sales) / 750(receivables) = 2.0

spartan1

An analyst has gathered the following information about a company:

Balance Sheet
Assets
	Cash	100
	Accounts Receivable	750
	Marketable Securities	300
	Inventory	850
	Property, Plant & Equip	900
	Accumulated Depreciation	(150)
Total Assets		2750
Liabilities and Equity
	Accounts Payable	300
	Short-Term Debt	130
	Long-Term Debt	700
	Common Stock	1000
	Retained Earnings	620
Total Liab. and Stockholder's equity		2750
Income Statement
Sales		1500
COGS		1100
Gross Profit		400
SG&A		150
Operating Profit		250
Interest Expense		25
Taxes		75
Net Income		150

Determine the current ratio and the cash ratio.

Current Ratio

Cash Ratio

A) 1.98 1.86

B) 4.65 0.93

C) 2.67 1.07

---

Current ratio = [100(cash) + 750(accounts receivable)+ 300(marketable securities) + 850(inventory)] / [300(AP) + 130(short term debt)] = (2000 / 430) = 4.65
Cash ratio = [100(cash) + 300(marketable securities)] / [300(AP) + 130(short term debt)] = (400 / 430) = 0.93

spartan1

Eagle Manufacturing Company reported the following selected financial information for 2007:

Accounts payable turnover	5.0
Cost of goods sold	$30 million
Average inventory	$3 million
Average receivables	$8 million
Total liabilities	$35 million
Interest expense	$2 million
Cash conversion cycle	13.5 days

Assuming 365 days in the calendar year, calculate Eagle's sales for the year.

A) $52.3 million.

B) $58.4 million.

C) $57.8 million.

---

Set up the cash conversion cycle formula and solve for the missing variable, sales. Days in payables is equal to 73 [365 / 5 accounts payable turnover]. Days in inventory is equal to 36.5 [365 / ($30 million COGS / $3 million average inventory)]. Given the cash conversion cycle, days in inventory, and days in payables, calculate days in receivables of 50 [13.5 days cash conversion cycle + 73 days in payables – 36.5 days in inventory]. Given days in receivables of 50 and average receivables of $8 million, sales are $58.4 million [($8 million average receivables / 50 days) × 365].

spartan1

An analyst has gathered the following information about a firm:

• Quick ratio of 0.25.
• Cash ratio of 0.20.
• $2 million in marketable securities.
• $10 million in cash.

What is their receivables balance?

A) 5 million.

B) 2 million.

C) 3 million.

---

Cash ratio = (cash + marketable securities) / current liabilities
0.20 = ($10,000,000 + $2,000,000) / current liabilities
current liabilities = $12,000,000 / 0.2 = $60,000,000
Quick ratio = [cash + marketable securities + receivables] / $60,000,000
0.25 = [$10,000,000 + $2,000,000 + receivables] / $60,000,000
($60,000,000)(0.25) = $12,000,000 + receivables
$15,000,000 = $12,000,000 + receivables
$15,000,000 − $12,000,000 = receivables
$3,000,000 = receivables